I need help answering the orders at the bottom from the following master schedules, which I have completed.

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 request (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. 50 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 20 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. 60 are to be 18 speed, 22 are to be straight handlebars, and 15 are to have the light set.

What specific information should be given to the prospective customers? Which weeks will have the shortages and which weeks could those shortages be delivered in a week.

Common Parts (Frame, etc.) Existing Inventory 40 Week Forecast Cust. Orders Projected Inv. (40) MPS ATP 1 50 56 184 200 54 2 55 52 129 3 60 45 69 4 62 33 7 5 65 70 137 200 45 6 65 50 72 7 68 35 4 8 70 60 134 200 120 9 75 20 59 10 75 20 184 200 180 11 80 0 104 12 85 0 19 18 Speed gear option Existing Inventory 25 Week Forecast Cust. Orders Projected Inv. (25) MPS ATP 1 35 37 138 150 27 2 39 38 99 3 42 40 SZ 4 44 33 13 5 46 50 113 150 55 6 46 20 67 7 48 25 19 8 49 40 120 150 100 9 53 5 67 10 53 5 14 11 56 0 108 150 12 60 0 48 Straight handle-bars Existing inventory 20 IN 1 15 16 4 Week Forecast Cust. Orders Projected Inv. (20) MPS ATP 2 17 18 46 60 37 3 18 20 26 5 20 15 4 19 5 7 6 20 22 25 7 21 15 4 8 21 20 43 60 35 9 23 5 20 10 23 B 57 60 52 11 24 O 33 12 26 0 7 60 8 Head and tail light set Existing inventory S 4 8 14 Week Forecast Cust. Orders Projected Inv. MPS ATP 1 10 2 25 30 11 2 11 12 13 3 12 10 1 13 8 18 30 7 5 13 15 3 6 13 9 20 30 14 7 14 7 6 9 15 2 7 10 15 1 22 30 29 16 0 6 12 17 0 19 30 30 22 30 17