MSOM online homework Scofied only
ZYBH
capacity_excelom1.docxCapacity
Problem 6.
Crossover / Cost-Volume Analysis
1 Variable Cost, 3 Options
Problem 9.
= 4,500 / 6,500 = 69.23%
Problem 10.
= 6,400 * .88 = 5,632 units
Problem 11.
= 800 / 900 = 88.9%
Problem 12.
= 500 / .85 = 588 sinks/day
Problem 13.
Design = 93,600 * .90 = 84,240
Fabrication = 156,000 * 1.03 = 160,680
Finishing = 64,000 * 1.05 = 67,200
Productivity Station 1 = 60 / 20 = 3 units/min
Productivity Station 2 = 60 / 12 = 5 units/min
Productivity Station 3 = 4 / 15 = 4 units/min
Bottleneck = slowest productivity = Station 2, 5 minutes/unit.
Throughput Time = sum of station productivity = 3 + 5 + 4 = 12 minutes
Weekly capacity = 12 hrs./day x 5 days/week x 60 minutes = 3,600 minutes
= 3,600 minutes / 5 minutes = 720 units
