Excel problems
ealhazmi
problemmrptemplate_1.xlsxGeneralData
| Bars/Min | 200 |
| Shift hrs | 8 |
| Bars per box | 24 |
| Box per case | 12 |
| Bars per case | 288 |
| Weight (lb) per Case | 72 |
SalesForecase
| Sales Forecasting | Jan | Feb | March | April | May | June | |
| Previous Year (Cases) | 5734 | 5823 | 5884 | 6134 | 6587 | 6735 | |
| Promotion Sales( Cases) | 300 | 300 | |||||
| Previous Year Base (Cases) | |||||||
| Growth | 3.00% | ||||||
| Base Projection (Cases) | |||||||
| Promotion (Cases) | 500 | ||||||
| Sales Forecase (Cases) |
SOP
| SOP | Dec | Jan | Feb | March | April | May | June | |
| Sales Forecast | ||||||||
| Production Plan | ||||||||
| Inventory | 100 | |||||||
| Working Days | 22 | 20 | 22 | 21 | 23 | 21 | ||
| Capacity (Shipping Cases) | ||||||||
| Utilization | ||||||||
| NRG-A (cases) | 70% | |||||||
| NRG-B (cases) | 30% |
MPS
| Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | |||
| Demand Management | 1/2-1/5 | 1/8-1/12 | 1/15-1/19 | 1/22-1/26 | 1/29-1/31 | 2/1-2/2 | |
| Monthly Demand | NRG-A | ||||||
| NRG-B | |||||||
| Working Days in Week | 4 | 5 | 5 | 5 | 3 | 2 | |
| Working Days in Month | |||||||
| MPS | NRG-A | ||||||
| Weekly Demand | NRG-B | ||||||
| Demand Management | 2-Jan | 3-Jan | 4-Jan | 5-Jan | 6-Jan | ||
| NRG-A | |||||||
| NRG-B | |||||||
| Working Days in Month | |||||||
| MPS | NRG-A | ||||||
| Daily Demand | NRG-B |
MRP
| Oats : LT = 2 Weeks | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | |
| MPS | NRG-A | |||||
| (Cases) | NRG-B | |||||
| MPS | NRG-A | |||||
| (500 lb batches) | NRG-B | |||||
| Gross requirements (lb) | ||||||
| Scheduled Receipts | 44000 | 44000 | 0 | 0 | 0 | |
| Planned Receipts | ||||||
| On hand | 11650 | |||||
| Planned Orders | ||||||
| Bill of Material for 500 lb batch of Oat | ||||||
| NRG-A | 300 | |||||
| NRG-B | 250 |
