Using the Aggregate Planning Worksheet labeled "A", show a plan that meets the following criteria (NOTE: Do not use any data from question 1.) The beginning inventory in Q-I is 10. The required ending inventory in Q-IV is 30 (which implies no back orders at the end of Q-IV) Sales occur according to the forecast A level output plan is required. From this plan, answer questions 2 through 5. 2. What is the quarterly output rate? 3. What is the highest amount of inventory that appears in this plan? 4. Inventory Carrying Cost is $15.00 per unit per quarter based upon the average inventory in each quarter. What is the total carrying cost incurred using this plan? (Show your calculations and CIRCLE your answer.) The division general manager directs you to eliminate all back orders while minimizing the impact on inventory carrying cost. Assuming that there are no capacity limitations, cost penalties, or other restrictions (such as maintaining completely level output), this request would best be accomplished by scheduling additional output when? (Circle you answer here DO NOT enter this on the scanning form) Split between 0-11 and 0-|||| Split between 0-1 and Q-|| 22 g 0-lll only Q-ll only The general manager needs new glasses, there are no backorders in this plan. Name: AGGREGATE PLANNING WORKSHEET TA' (use for problems 2-5, NOT problem Period 1 11 Forecast (Four Perica Format) IN Total Output Output mhus Forecast footinetuse liit helps you Seginning Ending Sackorder Using the Aggregate Planning Worksheet labeled "A", show a plan that meets the following criteria (NOTE: Do not use any data from question 1.) The beginning inventory in Q-I is 10. The required ending inventory in Q-IV is 30 (which implies no back orders at the end of Q-IV) Sales occur according to the forecast A level output plan is required. From this plan, answer questions 2 through 5. 2. What is the quarterly output rate? 3. What is the highest amount of inventory that appears in this plan? 4. Inventory Carrying Cost is $15.00 per unit per quarter based upon the average inventory in each quarter. What is the total carrying cost incurred using this plan? (Show your calculations and CIRCLE your answer.) The division general manager directs you to eliminate all back orders while minimizing the impact on inventory carrying cost. Assuming that there are no capacity limitations, cost penalties, or other restrictions (such as maintaining completely level output), this request would best be accomplished by scheduling additional output when? (Circle you answer here DO NOT enter this on the scanning form) Split between 0-11 and 0-|||| Split between 0-1 and Q-|| 22 g 0-lll only Q-ll only The general manager needs new glasses, there are no backorders in this plan. Name: AGGREGATE PLANNING WORKSHEET TA' (use for problems 2-5, NOT problem Period 1 11 Forecast (Four Perica Format) IN Total Output Output mhus Forecast footinetuse liit helps you Seginning Ending Sackorder