I need help just with the first box on page 71. And the bottom parts (a,b,c) if you don't mind, thank you in advance for all your help! (:

I will give a thumbs up

Assignment 1. Fill in the master schedules listed below, taking the data from the above tables a adding row values for projected inventory and available to promise (ATP). Assima there is no demand time fence for this data. 2. Once you have completed the tables, examine the list of orders for this model bicycle and determine specifically what information should be given to the perspective customer. For example, if the order request was for 40 bicycles (with defined options) in week 4 and it appears that only 32 could be delivered, then you should be telling the customer that they can have only 32 in week 4 and then the rest could be delivered at a later week (you should be specific as to WHICH week). Assume the orders listed for evaluation are NOT cumulative-in other words, evaluate each requested order independently ignoring the existence of the other requested orders for the evaluation of this one order. 3. Suppose Macarry's Bicycle managers discover that a major competitor has had to shut down their production for the next three months due to a major fire. The Macarry's managers fully expect that many of the competitor's customers will turn to Macarry's Bicycles to fill their orders during this critical time for them. In fact, one of the com- petitor's customers has already asked about an order of 250 of the models for delivery in week 5. What actions should Macarry's take in this case? Be as specific as possible. Master Scheduling 71 8 5 46 50 6 46 20 7 48 25 | 18-speed gear option Existing inventory 25 Week 1 2 3 4 Forecast 35 | 39 | 42 44 Cust. Orders 38 40 33 Projected Inven. MPS 150 ATP 9 53 10 53 11 56 40 0 0 5 Straight handle-bars Existing inventory 20 Week 1 2 3 Forecast 15 17 18 19 Cust. Orders 16 18 20 5 Projected Inven. MPS 20 15 20 22 21 15 8 21 20 9 22 5 10 23 8 24 0 ATP 12 6 13 5 13 15 7 14 10 Head and tail light set Existing inventory 5 Week 3 4 Forecast 11 12 13 Cust. Orders 12 10 8 Projected Inven. MPS 30 ATP 8 9 10 11 14 | 15 | 15 | 16 1120 17 9 7 Here are the orders to evaluate. Again you are reminded to treat these independently. For example, when you evaluate order number 2, ignore the other order requests (1, 3, and 4), and so forth. a. A customer is asking about an order of 32 of the bicycles for week 3. All 32 are to be 18 speed, 12 are to have straight handle-bars, and 14 are to have the light set. b. A customer is asking about an order of 60 of the bicycles for week 6. Fifty of them are to be 18 speed, 12 are to have straight handlebars, and 5 to have the light set. c. A customer is asking about an order of 20 of the bicycles for week 2. All are to be 18 speed, all are to have straight handlebars, and all are to have the light set. d. A customer is asking about an order of 110 of the bicycles in week 7. Sixty are to be 18 speed, 22 are to be straight handlebars, and 15 are to have the light set. Assignment 1. Fill in the master schedules listed below, taking the data from the above tables a adding row values for projected inventory and available to promise (ATP). Assima there is no demand time fence for this data. 2. Once you have completed the tables, examine the list of orders for this model bicycle and determine specifically what information should be given to the perspective customer. For example, if the order request was for 40 bicycles (with defined options) in week 4 and it appears that only 32 could be delivered, then you should be telling the customer that they can have only 32 in week 4 and then the rest could be delivered at a later week (you should be specific as to WHICH week). Assume the orders listed for evaluation are NOT cumulative-in other words, evaluate each requested order independently ignoring the existence of the other requested orders for the evaluation of this one order. 3. Suppose Macarry's Bicycle managers discover that a major competitor has had to shut down their production for the next three months due to a major fire. The Macarry's managers fully expect that many of the competitor's customers will turn to Macarry's Bicycles to fill their orders during this critical time for them. In fact, one of the com- petitor's customers has already asked about an order of 250 of the models for delivery in week 5. What actions should Macarry's take in this case? Be as specific as possible. Master Scheduling 71 8 5 46 50 6 46 20 7 48 25 | 18-speed gear option Existing inventory 25 Week 1 2 3 4 Forecast 35 | 39 | 42 44 Cust. Orders 38 40 33 Projected Inven. MPS 150 ATP 9 53 10 53 11 56 40 0 0 5 Straight handle-bars Existing inventory 20 Week 1 2 3 Forecast 15 17 18 19 Cust. Orders 16 18 20 5 Projected Inven. MPS 20 15 20 22 21 15 8 21 20 9 22 5 10 23 8 24 0 ATP 12 6 13 5 13 15 7 14 10 Head and tail light set Existing inventory 5 Week 3 4 Forecast 11 12 13 Cust. Orders 12 10 8 Projected Inven. MPS 30 ATP 8 9 10 11 14 | 15 | 15 | 16 1120 17 9 7 Here are the orders to evaluate. Again you are reminded to treat these independently. For example, when you evaluate order number 2, ignore the other order requests (1, 3, and 4), and so forth. a. A customer is asking about an order of 32 of the bicycles for week 3. All 32 are to be 18 speed, 12 are to have straight handle-bars, and 14 are to have the light set. b. A customer is asking about an order of 60 of the bicycles for week 6. Fifty of them are to be 18 speed, 12 are to have straight handlebars, and 5 to have the light set. c. A customer is asking about an order of 20 of the bicycles for week 2. All are to be 18 speed, all are to have straight handlebars, and all are to have the light set. d. A customer is asking about an order of 110 of the bicycles in week 7. Sixty are to be 18 speed, 22 are to be straight handlebars, and 15 are to have the light set