x JISES 2. Prepare a master schedule based on the following information Forecast

Question

x JISES 2. Prepare a master schedule based on the following information Forecast 100 100 120 120 150 150 180 180 Orders 106 94 65 40 21 9 2 0 Currently there are 145 units in inventory. Policy calls for a fixed order quantity of 250 units. Given: Net Inv.-Beg. Inv-Usage: End. Inv. Net Inv. + MPS: ATP MPS-Total Orders for the period Week Beg. Inv. Forecast Orders 1066S 40 13 0 Proj. OH -3g189691991 11929 39 MPS End. Inv. ATP proj cttd on hand 00 10 120 120 ISD ISO 1R 8D 39919 3. Given that $20 per unit (280 units per period maximum) $3. per unit (40 units per period maximum) Period 2 4 Forecast 200 200 300 400 Regular Time: Overtime: Subcontracting: Ncxe available Beginning Inventory: None Carrying Cost: $I per unt per perniod 50 Backorder Cost: $5 per unit per period 200 Production Schedule: Period Forecast Production Overtime On-hand Beg.Inv. End.Inv Aver.Inv Backlog 200 200 300 400 500 280 280 280 280 6 200280 Totals: Cost: S 2.00 S 3.00 S 1.00 S 5.00 Period!Regular|Overtime! Holding!Borders Total Totals

Explanation / Answer

ATP = MPS - next week commited orders - current week committed orders

Projected on hand = Inventory from previous week - Forecast + MPS MPS is done when on hand inventory is less than current week requirement

ATP = MPS - next week commited orders - current week committed orders

1 2 3 4 5 6 7 8 Beginning inventory 145 Forecast 100 100 120 120 150 150 180 180 Customer orders 106 94 65 40 21 9 2 0 Projected on hand 45 195 75 205 55 155 225 45 End Inventory 39 189 69 199 49 149 219 39 MPS 0 250 0 250 0 250 250 0 ATP 0 91 189 239 248

Related Questions

Navigate

• Browse (All)
• Browse X
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.