Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Financial Accounting

Authors: Theodore Christensen, David Cottrell, Cassy Budd

12th Edition

1260165116, 9781260165111

More Books

Students also viewed these Accounting questions

Question

Differentiate between classical and operant conditioning.

Answered: 1 week ago

Question

Brief the importance of span of control and its concepts.

Answered: 1 week ago

Question

What is meant by decentralisation?

Answered: 1 week ago

Question

Write down the Limitation of Beer - Lamberts law?

Answered: 1 week ago

Question

Discuss the Hawthorne experiments in detail

Answered: 1 week ago