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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
