Facilities Management homework

profilelur28
assignment_1_section_002_-_template1.xlsx
Home>Engineering homework help>Mechanical Engineering homework help>Facilities Management homework

Tables-Part 1

_/20
Names: 1
2
3
4
HTM 32200-002
Hospitality Facilities Management
Assignment 1
Due: Monday, August 31, 2015
Part 1
Fixtures 25
Bulbs per fixture 20
Setup time 25 minutes
Position time 2 minutes
Change time 0.5 minutes
Tear down time 20 minutes
Wages $40.00 per hour
Rated life of bulb 5000 hours Rated life of bulb 25000 hours
Hours on per day 20 hours Hours on per day 20 hours
Cost per Bulb $0.42 Cost per Bulb $9.99
Replacement Cycle (Days) Number of bulbs burned on that day Total burned out prior to replacement Replacement Cycle (Days) Number of bulbs burned on that day Total burned out prior to replacement
Spot Group Group with spot Spot Group Group with spot
210 0 0 1160 0 0
211 0 0 1161 0 0
212 0 0 1162 0 0
213 0 0 1163 0 0
214 0 0 1164 0 0
215 1 0 1165 0 0
216 0 1 1166 0 0
217 1 1 1167 0 0
218 0 2 1168 0 0
219 1 2 1169 1 0
220 4 3 1170 0 1
221 3 7 1171 0 1
222 2 10 1172 0 1
223 2 12 1173 1 1
224 2 14 1174 0 2
225 2 16 1175 0 2
226 5 18 1176 0 2
227 5 23 1177 0 2
228 4 28 1178 0 2
229 4 32 1179 0 2
230 0 36 1180 0 2
231 4 36 1181 0 2
232 5 40 1182 0 2
233 11 45 1183 0 2
234 11 56 1184 0 2
235 7 67 1185 0 2
236 8 74 1186 0 2
237 11 82 1187 0 2
238 12 93 1188 0 2
239 12 105 1189 0 2
240 8 117 1190 0 2
241 14 125 1191 1 2
242 10 139 1192 0 3
243 19 149 1193 0 3
244 10 168 1194 1 3
245 13 178 1195 3 4
246 10 191 1196 1 7
247 16 201 1197 0 8
248 21 217 1198 0 8
249 12 238 1199 0 8
250 18 250 1200 4 8
251 20 268 1201 1 12
252 16 288 1202 1 13
253 14 304 1203 1 14
254 20 318 1204 1 15
255 15 338 1205 2 16
256 16 353 1206 3 18
257 17 369 1207 2 21
258 11 386 1208 1 23
259 11 397 1209 2 24
260 10 408 1210 2 26
261 7 418 1211 2 28
262 15 425 1212 3 30
263 6 440 1213 8 33
264 6 446 1214 5 41
265 6 452 1215 4 46
266 1 458 1216 2 50
267 7 459 1217 2 52
268 3 466 1218 4 54
269 8 469 1219 5 58
Prepare one graph for each of the two bulbs. Make sure you save the charts as a sperate sheet and use "scatter" as the chart type.
Best method for replacing $0.42 bulbs:
Replacement cycle (in days):
Annual cost for most efficient method:
Annual saving versus spot:
Best method for replacing $9.99 bulbs:
Replacement cycle (in days):
Annual cost for most efficient method:
Annual saving versus spot:
Which bulb should you choose?
If you purchase the $9.99 bulbs how much would you save/lose versus the $0.42 bulb, best method?

Tables-Part 2

Part 2
Cost per kilowatt hour is $0.11
Current bulbs ($0.42) use 40 watt per bulb.
LED bulbs ($9.99) will use 4 watts per bulb.
The labor cost for installing the bulbs are the same as for the current bulbs.
Fixtures 25
Bulbs per fixture 20
Setup time 25 minutes
Position time 2 minutes
Change time 0.5 minutes
Tear down time 20 minutes
Wages $40.00 per hour
Rated life of bulb 5000 hours Rated life of bulb 25000 hours
Hours on per day 20 hours Hours on per day 20 hours
Cost per Bulb $0.42 Cost per Bulb $9.99
What is the cost per day for energy used by the $0.42 bulb?
What is the cost per day for energy used by the $9.99 bulb?
Replacement Cycle (Days) Number of bulbs burned on that day Total burned out prior to replacement Replacement Number of bulbs burned on that day Total burned out
Spot Group Group with spot Cycle (Days) prior to replacement Spot Group Group with spot
210 0 0 1160 0 0
211 0 0 1161 0 0
212 0 0 1162 0 0
213 0 0 1163 0 0
214 0 0 1164 0 0
215 1 0 1165 0 0
216 0 1 1166 0 0
217 1 1 1167 0 0
218 0 2 1168 0 0
219 1 2 1169 1 0
220 4 3 1170 0 1
221 3 7 1171 0 1
222 2 10 1172 0 1
223 2 12 1173 1 1
224 2 14 1174 0 2
225 2 16 1175 0 2
226 5 18 1176 0 2
227 5 23 1177 0 2
228 4 28 1178 0 2
229 4 32 1179 0 2
230 0 36 1180 0 2
231 4 36 1181 0 2
232 5 40 1182 0 2
233 11 45 1183 0 2
234 11 56 1184 0 2
235 7 67 1185 0 2
236 8 74 1186 0 2
237 11 82 1187 0 2
238 12 93 1188 0 2
239 12 105 1189 0 2
240 8 117 1190 0 2
241 14 125 1191 1 2
242 10 139 1192 0 3
243 19 149 1193 0 3
244 10 168 1194 1 3
245 13 178 1195 3 4
246 10 191 1196 1 7
247 16 201 1197 0 8
248 21 217 1198 0 8
249 12 238 1199 0 8
250 18 250 1200 4 8
251 20 268 1201 1 12
252 16 288 1202 1 13
253 14 304 1203 1 14
254 20 318 1204 1 15
255 15 338 1205 2 16
256 16 353 1206 3 18
257 17 369 1207 2 21
258 11 386 1208 1 23
259 11 397 1209 2 24
260 10 408 1210 2 26
261 7 418 1211 2 28
262 15 425 1212 3 30
263 6 440 1213 8 33
264 6 446 1214 5 41
265 6 452 1215 4 46
266 1 458 1216 2 50
267 7 459 1217 2 52
268 3 466 1218 4 54
269 8 469 1219 5 58
Best method for replacing $0.42 bulbs:
Replacement cycle (in days):
Annual cost for most efficient method:
Annual saving versus spot:
Best method for replacing $9.99 bulbs:
Replacement cycle (in days):
Annual cost for most efficient method:
Annual saving versus spot:
Which bulb should you choose?
If you purchase the $9.99 bulbs how much would you save/lose versus the $0.42 bulb, best method?