Formulas and Functions in Excel
Sheet1
| HOURS REQUIRED | ||||||
| Units | Fabrication | Welding | Machining | Assembly | Packaging | Total Hours |
| Weekly Production -- Hours per unit | 1.5 | 2.25 | 0.7 | 3.2 | 0.5 | |
| 200 | ||||||
| 300 | ||||||
| 400 | ||||||
| 500 | ||||||
| Weekly Requirement | Total Requirement | |||||
| Hours per Week | 40 | 200 | ||||
| 300 | ||||||
| 400 | ||||||
| 500 | ||||||
| Weekly Requirement | Total Requirement | |||||
| Hours per Week | 45 | 200 | ||||
| 300 | ||||||
| 400 | ||||||
| 500 |