Use the following table to answer questions 44 and 45 2012 Ave. 2012 Actual Demand -...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Use the following table to answer questions 44 and 45 2012 Ave. 2012 Actual Demand - 2011 Ave. Monthly Monthly Month Month Monthly Monthly 2011 Monthly Demand Index Index Demand Forecast Jan-11 102 Jan-12 Feb-11 118 Feb-12 Mar-11 136 Mar-12 Apr-12 May-12 Apr-11 157 May-11 134 Jun-11 114 Jun-12 Jul-11 97 Jul-12 Aug-11 83 Aug-12 Sep-11 100 Sep-12 Oct-11 120 Oct-12 Nov-11 144 Nov-12 Dec-11 173 Dec-12 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 Ave. 2012 Actual Demand - 2011 Ave. Monthly Monthly Month Month Monthly Monthly 2011 Monthly Demand Index Index Demand Forecast Jan-11 102 Jan-12 Feb-11 118 Feb-12 Mar-11 136 Mar-12 Apr-12 May-12 Apr-11 157 May-11 134 Jun-11 114 Jun-12 Jul-11 97 Jul-12 Aug-11 83 Aug-12 Sep-11 100 Sep-12 Oct-11 120 Oct-12 Nov-11 144 Nov-12 Dec-11 173 Dec-12 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.
Expert Answer:
Answer rating: 100% (QA)
To calculate the seasonal index for each month based on the 2011 data we need to first calculate the average monthly demand and the monthly index for ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Use the following table to calculate PV, AC, EV, CPI, SPI, and ETC for a project that is in its 11th week of execution.
-
Use the following table to answer the questions. Year ___________________ Real GDP (billions of 2009 dollars) 1990 ..............................................$8,955 1991...
-
Use the following table to answer the questions. Annual Income Tax Liability $15,000........................................$0 30,000......................................4,500...
-
A yo-yo moves downward until it reaches the end of its string, where it "sleeps." As it sleeps-that is, spins in place-its angular speed decreases from 35 rad/s to 25 rad/s. During this time it...
-
The Crunchy Potato Chip Company packages potato chips in a process designed for 10.0 ounces of chips with an upper specification limit of 10.5 ounces and a lower specification limit of 9.5 ounces....
-
Holdem Properties Corporation purchased a parcel of land in 2010 for $1 million with the intent to construct a building on the property in the near future. At the time of purchase, and in the...
-
Assume that management at Subway has decided to implement a balanced scorecard for the organization. Visit the company's site map at http://www.subway.com/subway root/sitemap.aspx. Using the...
-
HAART, or highly active antiretroviral therapy, is currently recommended for the treatment of HIV and involves the administration of three or more medicines at one time. Explain why this combined...
-
USE YOUR OWN WORDS! DO NOT CUT AND PASTE FROM THE INTERNET, ESPECIALLY WIKIPEDIA! CITE YOUR SOURCES!! REMEMBER IF YOU CAN FIND IT ON THE INTERNET (GOOGLE, WIKI, ETC.), SO CAN I. DO NOT USE ChatGPT, I...
-
Student researchers at Hope College conducted an experiment to determine whether students memorize material better if they are taking notes on paper using handwriting as opposed to taking notes on a...
-
On an insurer's balance sheet, incurred but not reported losses are Available answer options Select only one option A A past current asset. B Not reported. C A category of reserves. D A long-term...
-
Why is the audit report so critical to the auditor's performance and reputation? When do auditors begin planning the audit report? Why?
-
Which of the following statements concerning audit evidence is correct? a. To be appropriate, audit evidence should be either persuasive or rel- evant but need not be both. b. The measure of the...
-
What kinds of recommendations do auditors make regarding the control system?
-
Discuss two important aspects of working paper management.
-
In testing the existence assertion for an asset, an auditor ordinarily works from the a. Financial statements to the potentially unrecorded items. b. Potentially unrecorded items to the financial...
-
Solve for the ratios listed below: Current Assets $ 2 6 , 0 0 0 Accounts Receivable $ 4 , 1 0 0 Current Liabilities $ 1 6 , 5 0 0 Inventory $ 4 , 1 0 0 Net Sales $ 5 2 , 0 0 0 Total Assets $ 3 8 , 0...
-
Illini Company, Inc. Balance Sheet as of 12/31/20X0 Assets Current Assets: Cash $1,500,000 Accounts receivable, net 18,000 Inventory 50,000 Total current assets 1,568,000 Equipment 90,000 Goodwill...
-
At point A in the following graph, is planned aggregate expenditure greater than, equal to, or less than GDP? What about at point B? At point C? For points A and C, indicate the vertical distance...
-
Describe the relationship of the AD, SRAS, and LRAS curves when the economy is in long-run macroeconomic equilibrium.
-
Suppose the graph on the next page shows Tanzania's production possibilities frontier for cashew nuts and mangoes. Assume that the output per hour of work is 8 bushels of cashew nuts or 2 bushels of...
-
Murphy Corporation has 50,000 shares of \(\$ 10\) par value common stock outstanding. The company has \(\$ 450,000\) of retained earnings. At year-end, the company declares a cash dividend of \(\$...
-
Torey Corporation was organized on April 1, with an authorization of 25,000 shares of six percent, \(\$ 50\) par value preferred stock and 200,000 shares of \(\$ 5\) par value common stock. During...
-
Ryan Corporation began business on March 1, 2016. At that time, it issued 20,000 shares of \(\$ 60\) par value, seven percent cumulative preferred stock and 100,000 shares of \(\$ 5\) par value...
Study smarter with the SolutionInn App