SOP (Aggregate Planning The following formulas and data are for solving the problems in this part of the exam. P1 = IEt + S- IB let = let + Pt-St-Bt-1 AVG. INV. = (IEt + 18t)/2 let IBt. P St Bt-1 Inventory at the end of a time period Inventory at the beginning of a time period Output (Production) during a time period. 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). 1. II. III. IV. 80 100 200 80 460 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-II, etc.) (NOTE: Question 1 is a stand-alone question and has nothing to do with the remaining questions. Do not use the worksheet for this problem. Show your work in the space provided.) 1. If the beginning inventory is 30 for Q-1, 60 units are produced during Q-1, and sales occur according to the forecast for Q-1, what is the average inventory for Q-I? (Show your calculations and CIRCLE your answer.) 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.) 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 hereDO NOT enter this on the scanning form) a) b) C) d) e) Split between Q-II and Q-11 Split between Q-I and Q-11 Q-Ill only Q-Il only The general manager needs new glasses; there are no backorders in this plan. EXTRA CREDIT (worth four points if correct) 6. Using the Aggregate Planning Worksheet labeled "B", show a plan that meets the following criteria. The beginning inventory in Q-1 is 30. Sales occur according to the forecast. Output occurs as follows: 140 in Q-I, 140 in Q-11, 100 in Q-III, and 100 in Q-IV