ch14hmwkdata.xlsx
Pr18
| Item AB500 | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Gross Requirements |
| Scheduled Receipts |
| Projected Available |
| Planned Orders |
| Item AB501 | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Gross Requirements |
| Scheduled Receipts |
| Projected Available |
| Planned Orders |
| Item AB511 | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Gross Requirements |
| Scheduled Receipts |
| Projected Available |
| Planned Orders |
| Item AB521 | | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| Gross Requirements |
| Scheduled Receipts |
| Projected Available |
| Planned Orders |
Pr20
| Machines | 3 |
| Work time | 8 |
| Word days | 5 |
| Effic Rate | 90% |
| Util Rate | 90% |
| | | | Orders | Qty | Setup Time | Run Time | Hrs Needed |
| | | | LL110 | 10 | 2.0 | 1.2 |
| Available Capacity | | | LL118 | 25 | 4.0 | 0.4 |
| Additional Capacity | | | LL131 | 100 | 6.0 | 0.6 |
| | | | LL140 | 50 | 4.0 | 0.2 |
Pr22
| Machines | 3 |
| Work time | 15 |
| Word days | 5 |
| Effic Rate | 80% |
| Util Rate | 90% |
| | | | Orders | Qty | Setup Time | Run Time | Hrs Needed |
| | | | LL110 | 10 | 2.5 | 1.2 |
| Available Capacity | | | LL118 | 25 | 4.5 | 0.4 |
| Additional Capacity | | | LL131 | 100 | 6.5 | 0.7 |
| | | | LL140 | 55 | 4.5 | 0.1 |
Pr24
| Machines | 3 |
| Work time | 12 |
| Word days | 6 |
| Effic Rate |
| Util Rate |
| | | | Orders | Qty | Setup Time | Run Time | Hrs Needed |
| | | | LL110 | 100 | 4.0 | 0.3 |
| Available Capacity | | | LL118 | 250 | 6.0 | 0.1 |
| Additional Capacity | | | LL131 | 100 | 3.0 | 0.3 |
| | | | LL140 | 500 | 8.0 | 0.1 |
| | | | Orders | Qty | Setup Time | Run Time | Hours Needed |
| | | | LL110 | 100 | 4.0 | 0.3 |
| | | | LL118 | 250 | 6.0 | 0.1 |
| | | | LL131 | 100 | 3.0 | 0.3 |
| | | | LL140 | 500 | 8.0 | 0.1 |
wmashles88
