Question: Need right away in excel. In Level Production Plan PP.62 A manufacturer of solid state drives (SSDs) has projected the next six months of demand

Need right away in excel. In Level Production Plan

PP.62 A manufacturer of solid state drives (SSDs) has projected the next six months of demand to be as shown the table below:

Cost Variables
Labor cost/hour $14
Overtime cost/unit $32
Subcontracting cost/unit $24
Holding cost/unit/month $9
Hiring cost/employee $2,800
Firing cost/employee $5,100
Supply/Demand Info Beginning Jan Feb Mar Apr May Jun
Forecast (demand) 52,700 64,500 45,900 62,100 54,100 62,700
Regular production
Overtime production
Subcontract production
Ending inventory 12,600
Hired employees
Fired employees
Total employees 515
Capacity Information
Total labor hours/SSD 2
Regular production units/employee/month 100
Max regular production/month 55,100
Max overtime production/month 5,000
Max subcontractor production/month 4,500

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!