Question: Quarter Sales Forecast (use this forecast for ALL problems). I. 100 II. 120 III. 200 IV. 100 520 Use the spaces between the questions to
Quarter Sales Forecast (use this forecast for ALL problems). I. 100 II. 120 III. 200 IV. 100 520 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-I, 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.) The beginning inventory in Q-I is 50. 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 $5.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.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
