(NOTE: Do not use any data from question 1.) The beginning inventory in Q-I is 20. The required ending inventory in Q-IV is 40 (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 $10.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.) 5 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 Q-II and Q-111 b) Split between Q.1 and Q-11 Q-Ill only Q-ll only ) The general manager needs new glasses, there are no backorders in this plan a Beoge ) SOP (Aggregate) Planning The following formulas and data are for solving the problems in this part of the exam. P. - lge+ S - Is la = let +P-S-B AVG. INV. = (le + le:)/2 let Inventory at the end of a time period Inventory at the beginning of a time period P: Output (Production) during a time period. S Sales during a time period. Backorders at the end of the prior time period. (There were no backorders at the end of the period preceding Q-1.) Quarter Sales Forecast (use this forecast for ALL problems) let BA 1 50 120 =52 IV 60 50 280 Use the spaces between the questions to write in your answers if the question asks you to do so Follow all instructions exactly Remember to submit a completed copy of the worksheet to support your answers to questions 2-5 (NOTE that Quarter 1 will be abbreviated as Q-1 Quarter 2 as Q-11, etc)