WEEK 1
qkiii123
ch01ex01_solution1.xlsxSheet1
| Precision Products | ||||||||
| Manpower Planning | ||||||||
| H O U R S R E Q U I R E D | ||||||||
| Units | Fabrication | Welding | Machining | Assembly | Packaging | Total Hours | ||
| Weekly Production | 1 | 1.5 | 2.25 | 0.7 | 3.2 | 0.5 | 8.15 | |
| Units | 200 | 300 | 450 | 140 | 640 | 100 | 1,630 | |
| 300 | 450 | 675 | 210 | 960 | 150 | 2,445 | ||
| 400 | 600 | 900 | 280 | 1,280 | 200 | 3,260 | ||
| 500 | 750 | 1,125 | 350 | 1,600 | 250 | 4,075 | ||
| Weekly Manpower | Total Manpower | |||||||
| Hours | 40 | 200 | 7.50 | 11.25 | 3.50 | 16.00 | 2.50 | 41 |
| 300 | 11.25 | 16.88 | 5.25 | 24.00 | 3.75 | 61 | ||
| 400 | 15.00 | 22.50 | 7.00 | 32.00 | 5.00 | 82 | ||
| 500 | 18.75 | 28.13 | 8.75 | 40.00 | 6.25 | 102 | ||
