Question: Sitting on Maggie Brumfields desk is the latest planned order report from the companys MRP system. Maggies job is to determine if there is enough
Sitting on Maggie Brumfields desk is the latest planned order report from the companys MRP system. Maggies job is to determine if there is enough capacity to handle the workload and to level the load if its uneven. She gathers the latest cost figures and gets to work. Subcontracting and hiring extra workers are not options at this point, but overtime, pulling work ahead, and postponing work are. Regular production costs $10 an hour and is limited to 40 hours a week. Overtime costs $15 an hour and cannot exceed 40 extra hours (i.e., a double shift). An inventory cost of $3 per period is assessed for each hours worth of work performed in advance. Postponing work costs $20 per item per period. Use the following information to construct an initial load summary chart. Level the loads. Then create a revised chart that meets demand at the least possible cost. How much money is saved by economically leveling the load?
.png)
PLANNED ORDER REPORT Week Item 90 100 250 600 160 PROCESSING TIMES Setup Time min) 15 30 50 45 Run Time Item min per unit) 15 10
Step by Step Solution
3.46 Rating (179 Votes )
There are 3 Steps involved in it
Run Load Load Period Item Setup Time Units mins hrs 1 A 15 3 90 285 B 30 15 100 1530 D 45 4 6... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
184_607567201a937_143308.xlsx
300 KBs Excel File
