(* = easy; ** = moderate; ***= advanced) Problems for Section 12.1: Master Scheduling 1. (*) Complete the following master schedule record: On-hand inventory at end of week 1: 65 Week Forecasted demand Booked orders 15 Projected ending inventory Master production schedule 150 Available to promise 65 70 75 93 67 200 2. (**) Consider the master schedule record shown in problem 1. Suppose marketing books! an order for an additional 10 units in week 4. Recalculate the projected ending inventory and available-to-promise numbers. How low does the projected ending inventory get? What actions might the company take as a result? WOW piou 1. suppuse marketing books an order for an additional 10 units in week 4. Recalculate the projected ending inventory and available-to-promise numbers. How low does the projected ending inventory get? What actions might the company take as a result? 3. (*) Complete the following master schedule record: On-hand inventory at end of week 1:100 Forecasted demand 250 250 300 300 350 350 250 250 Booked orders 265 255 270245260235 180 100 Projected ending inventory Master production schedule Available to promise 220 Week 500 700 500 . (**) Consider the master schedule record shown in problem 3. Suppose the production manager calls and says that only 600 units will be finished in week 6, not the 700 units originally called for. Recalculate the projected ending inventory and available-to-promise numbers. What does a negative projected ending inventory value mean? How does it differ from a negative available to-promise number? As a manager, which would be easier to deal with a negative projected inventory value or a negative ATP? 5. Consider the following partially completed master schedule record: On-hand inventory at end of April: 40 Month tay June Week Forecasted demand 200 225 225 225 200 2001 Booked orders 201 195 193 190 182178 Projected ending inventory Master production schedule 600 16750 Available to promise a. Complete the projected on-hand inventory calculations and the available-to-promise cal culations. 0 0 600 prum Hinders. What doe Lieu enuing Inventory value mean? How does it differ from a negative available to-promise number? As a manager, which would be easier to deal with a negative projecte inventory value or a negative ATP? 5. Consider the following partially completed master schedule record: On-hand inventory at end of April: 40 Month Week 19 20 21 22 23 24 25 26 Forecasted demand 200 200 200 225 225 225 200 200 Booked orders 205203 201 195 193 190 182 Projected ending inventory Master production schedule 600 675 0 0 600 Available to promise 178 240 a. (*) Complete the projected on-hand inventory calculations and the available-to-promise cal culations. b. (**) Suppose that a customer calls and cancels an order for 50 units in week 25. Which of th following statements are true? The ATP for week 25 will increase by 50 units. The projected ending inventory for week 25 will increase by 50 units. The ATP for weeks 19 and 22 will be unaffected