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...
-
On January 1, 2017, Forrester Company issued $400,000, 8%, 5-year bonds at face value. Interest is payable annually on January 1. Instructions Prepare journal entries to record the following. (a) The...
-
Wallace Computer Company is a small, closely held corporation. Eighty percent of the stock is held by Derek Wallace, president. Of the remainder, 10% is held by members of his family and 10% by Kathy...
-
Muffins The weights of muffin cartons are normally distributed with a mean weight of 1.25 kilograms and a standard deviation of 0.1 kilograms. (a) What is the probability that a randomly selected...
-
S. Noble and T. Wells share income on a 6 : 4 basis. They have capital balances of $100,000 and $70,000, respectively, when W. Trinity is admitted to the partnership. Instructions Prepare the journal...
-
A Body with a mass of 1000kg moves horizontally from its original position A to point B, 24 m away in 3 seconds. The body is then accelerated for 2.5 s to point C. The new velocity at Point C is 12...
-
John Fuji (birthdate June 6, 1981) moved from California to Washington in December 2018. His earnings and income tax withholding for 2019 for his job as a manager at a Washington apple-processing...
-
Baillie Power leased high-tech electronic equipment from Courtney Leasing on January 1, 2021. Courtney purchased the equipment from Doane Machines at a cost of $257,500, its fair value. (FV of $1, PV...
-
Have computers become sophisticated enough to be powerful extensions of how humans think and communicate? Or do computers and humans capture and process data and transform it into information in...
-
What are the major criticisms of the neo-Malthusian perspective to resource scarcity and economic growth in general? Be specific.
-
In Part Two, you covered a wide range of systems analysis methods in seven chapters, Again, reread the introduction at the beginning of Part Two; then list what resonated the most for you in each...
-
The objective of software metrics is to provide I mathematically valid method for measuring software quality and productivity. Research articles on the Web and/or in your school library regarding...
-
Part Four of the textbook takes you into the final phase of the project, then into ongoing operations and support. Follow the same process as for the preceding parts, but in addition, please take a...
-
A cash flow is payable continuously at a rate of p, per annum at time t provided a life who is aged x at time 0 is still alive. I is a random variable T which measures the complete future lifetime in...
-
Explain the term global capital markets. This chapter primarily discusses global equity markets. What other types of financial instruments are traded in these markets? How important are global...
-
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...
-
The random vector \((X, Y)\) has the joint probability density \[f_{X, Y}(x, y)=\frac{1}{2} e^{-x}, \quad 0 \leq x, 0 \leq y \leq 2\] (1) Determine the marginal densities and the mean values \(E(X)\)...
-
Let \[f_{X, Y}(x, y)=c x^{2} y, 0 \leq x, y \leq 1\] be the joint probability density of the random vector \((X, Y)\). (1) Determine the constant \(c\) and the marginal densities. (2) Are \(X\) and...
-
The temperatures \(X\) and \(Y\), measured daily at the same time at two different locations, have the joint density \[f_{X, Y}(x, y)=\frac{x y}{3} \exp \left[-\frac{1}{2}\left(x^{2}+\frac{y^{3}}{3}...
Study smarter with the SolutionInn App