Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the following table to answer questions 44 and 45 2012 Month Actual Demand - 2011 2011 Ave. Monthly Demand Monthly Index Month 2012 Ave.
Use the following table to answer questions 44 and 45 2012 Month Actual Demand - 2011 2011 Ave. Monthly Demand Monthly Index Month 2012 Ave. Monthly Demand Monthly Index Monthly Forecast 102 Jan-11 Feb-11 118 136 157 134 114 Mar-11 Apr-11 May-11 Jun-11 Jul-11 Aug-11 Sep-11 Oct-11 Nov-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 97 83 100 120 144 Dec-11 173 1,478 1,800 44). The VP of Sales estimates that annual demand in 2012 will be 1,800 units. He has asked you to break down his annual demand estimate into a monthly forecast. Using the above information, calculate the Seasonal Index for each month based on the 2011 data. Fill in each month's seasonal index in the table above. 45). Given the Seasonal Indices you calculated in Question 44 and the estimated annual volume of 1,800 units, calculate the forecasted monthly demand for 2012 in the above table. Use the following table to answer questions 44 and 45 2012 Month Actual Demand - 2011 2011 Ave. Monthly Demand Monthly Index Month 2012 Ave. Monthly Demand Monthly Index Monthly Forecast 102 Jan-11 Feb-11 118 136 157 134 114 Mar-11 Apr-11 May-11 Jun-11 Jul-11 Aug-11 Sep-11 Oct-11 Nov-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 97 83 100 120 144 Dec-11 173 1,478 1,800 44). The VP of Sales estimates that annual demand in 2012 will be 1,800 units. He has asked you to break down his annual demand estimate into a monthly forecast. Using the above information, calculate the Seasonal Index for each month based on the 2011 data. Fill in each month's seasonal index in the table above. 45). Given the Seasonal Indices you calculated in Question 44 and the estimated annual volume of 1,800 units, calculate the forecasted monthly demand for 2012 in the above table
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started