Media Consultants uses proven techniques to measure forecast accuracy and to determine when the forecast needs...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Media Consultants uses proven techniques to measure forecast accuracy and to determine when the forecast needs to be reviewed/updated. The following data has been extracted from their information system: Month 1 2 3 4 5 6 7 8 9 10 11 12 13. 14 15 16 17 18 19 20 Actual Sales ($million) 22 22 22 22 24 24 24 23 23 23 23 22 22 22 22 21 21 20 20 20 Forecast ($million) 30 24 18 15 15 19 24 26 32 27 22 16 14 18 21 23 25 28 25 21 a). Compute a tracking signal for months 11 through 20. Compute an initial value of MAD for month 11, and then update it for each month using exponential smoothing with alpha-.1. What can you conclude? Assume limits of +/-4. b). Using the first half of the data construct a control chart with 2s limits. What can you conclude? c). Plot the last 10 errors on the control chart. Are the errors random? What is the implication of this? Media Consultants uses proven techniques to measure forecast accuracy and to determine when the forecast needs to be reviewed/updated. The following data has been extracted from their information system: Month 1 2 3 4 5 6 7 8 9 10 11 12 13. 14 15 16 17 18 19 20 Actual Sales ($million) 22 22 22 22 24 24 24 23 23 23 23 22 22 22 22 21 21 20 20 20 Forecast ($million) 30 24 18 15 15 19 24 26 32 27 22 16 14 18 21 23 25 28 25 21 a). Compute a tracking signal for months 11 through 20. Compute an initial value of MAD for month 11, and then update it for each month using exponential smoothing with alpha-.1. What can you conclude? Assume limits of +/-4. b). Using the first half of the data construct a control chart with 2s limits. What can you conclude? c). Plot the last 10 errors on the control chart. Are the errors random? What is the implication of this?
Expert Answer:
Answer rating: 100% (QA)
a Use the following expression to compute the exponentially smoothened MAD MAD ale 1 aMADt1 The trac... View the full answer
Related Book For
Intermediate Accounting Reporting and Analysis
ISBN: 978-1285453828
2nd edition
Authors: James M. Wahlen, Jefferson P. Jones, Donald Pagach
Posted Date:
Students also viewed these general management questions
-
The following information has been extracted from the draft financial statements of TEX, a manufacturing entity: TEX - Income statement for the year ended 30 September 2003 September 2003...
-
The following trial balance has been extracted from the ledger of Andrea Howell, a sole trader, as at 31 May 20X3, the end of her most recent financial year. The following additional information as...
-
The following information has been extracted from the accounting records of the Atwood Corporation: 1. Cash on hand (undeposited sales receipts) ............ $ 1,020 2. Certificates of deposit...
-
Explain why some conditions on the market are regarded as anomalies and explain how that affects factor investing.
-
A recent survey of 992 people asked: In which professional sportfootball, boxing, hockey, or martial artsis an athlete most likely to sustain an injury that will affect the athlete after he or she...
-
Intermediate substations are often economical from the viewpoint of the number of lines required for power transfer if their costs do not outweigh the reduction in line costs. (a) True (b) False
-
Leicht Transfer & Storage provides warehousing services and often purchases pallets from Pallet Central. The companies followed a standard practice for documenting these transactions in which Pallet...
-
On June 1, Cindy Godfrey started Divine Designs Co., a company that provides craft opportunities, by investing $12,000 cash in the business. Following are the assets and liabilities of the company at...
-
Find a big-O estimate (in terms of n) for the run-time of the code given below. m+0 for i1 to n forji i to n * n m+i+j (b) i1 while i n j <1 while j i jj+1 i+i+1 Activate Go to Setti
-
D Question 1 What is the total balance in the Trial Balance on the Debit side from your Worksheet? $339000 $409,000 $388,500 $393,000 Question 2 8 pts $97,000 O $104,000 O $11,000 O $106,000 8 pts...
-
One hazard of space travel is debris left by previous missions. There are several thousand objects orbiting Earth that are large enough to be detected by radar, but there are far greater numbers of...
-
Due to seeing Avatar, people have decided that 3D is the way of the future and plain old HD sets are for those who still think Razrs are cool. At the same time, the government, in order to support...
-
What transformations have occurred in the realm of gender dynamics within the working world over the past fifty years, and what are the primary impediments hindering gender equality in the workplace?...
-
Fill out the truth table below to describe the functionality of a full-adder. Four of these will be linked together to create a 4-bit, ripple-carry adder. The Ob prefix on the operands denotes that...
-
CLV Suppose you are a mar tech firm selling your B2B software as a service (SaaS) to obtain an annual revenue stream for your acquired customers. You typically acquire these customers at a cost of...
-
When the United States puts tariffs on imports, who do you think ultimately pays these tariffs? Is it the foreign companies selling the import, American consumers, or both? Explain your answer.
-
Assume that you are a new project manager and you want to motivate your team members to perform at their best. Develop one strategy for each of the categories of human need in Maslow's hierarchy....
-
we have to compute the letter grades for a course. The data is a collection of student records stored in a file. Each record consists of a name(up to 20 characters), ID (8 characters), the scores of...
-
Describe the financial reporting model within the FASB Conceptual Framework.
-
Donald Company operates a business in Orange County. While Donald uses a calendar fiscal year, Orange Countys fiscal year begins in October. How should Donald account for its property taxes assessed...
-
What are two frequently used ratios measuring leverage? How are they computed, and what do they mean?
-
A second-order dynamic system is modeled as \[9 \ddot{x}+6 \dot{x}+\frac{10}{9} x=14 \delta(t), \quad x(0)=0, \quad \dot{x}(0)=-\frac{1}{4}\] a. Find the response \(x(t)\) in closed form. b. Plot the...
-
Consider a first-order system with time constant \(\tau\) and zero initial condition. Find the system's unit-step response for \(\tau=\frac{1}{3}\) and \(\frac{2}{3}\), plot the two curves versus \(0...
-
a. Identify the damping type and find the free response. b. Plot the free response by using the initial command. \(\ddot{x}+3 \dot{x}+4 x=0, \quad x(0)=\frac{2}{5}, \quad \dot{x}(0)=0\)
Study smarter with the SolutionInn App