The table is completed, just need help with the orders! A, B, C, D (pic 3)

Common Parts Week 1 2 3 4 6 7 8 9 10 10 12 Forecast 50 55 60 62 65 65 68 70 75 75 80 85 Cust. Orders 56 52 45 3370 5035 60 20 20 O Projected Ivn 40 184 129 697 137 724 134 59184 104 19 MPS 200 200 200 200 ATP 54 45 120 180 18-speed gear option 3 4 5 6 7 Week 1 2 9 11 10 12 Forecast 35 39 42 44 46 46 48 49 53 53 56 60 Cust. Orders 37 38 4033 50 20 25 40 5 5 0 0 Projected in 25 138 99 57 13 113 67 19 120 67 108 48 MPS 150 150 150 150 ATP 27 55 100 150 Week 9 10 11 12 Straight handlebars 1 2 3 4 5 6 7 8 15 17 18 19 20 20 21 21 16 18 205 15 2215 20 Forecast 23 23 24 26 Cust. Orders 5 B 0 o Projected lyn 204 46 267 47 254 43 2057 33 7 MPS 60 60 60 60 ATP 4 17 8 35 52 Head and tail light set 3 4 5 6 7 8 Week 1 2 10 11 12 9 15 Forecast 10 11 12 13 13 13 14 14 15 16 17 8 Cust. Orders 2 12 10 8 15 9 7 11 2 1 0 O Projected lyn 5 25 13 1 183 206 22 7 22 6 19 MPS 30 30 30 30 30 30 ATP 11 7 14 17 29 30 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 cumulativein other words, evaluate each requested order independently ignoring the existence of the other requested orders for the evaluation of this one order. 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