Question: Use the sales data below to generate forecasts for months 724 using a sixperiod and a threeperiod moving average. Use MAD to compare the forecasts.

Use the sales data below to generate forecasts for months 7–24 using a six‐period and a three‐period moving average. Use MAD to compare the forecasts. Which forecast is more stable? Which is more responsive and why?

Month Sales Month Sales Month Sales 1 120 9 145 17 158 2 122 10 150 18 149 3 135 11 144 19 170 4 138 12 154 20 165 5 129 13 160 21 171 6 136 14 155 22 158 7 139 15 162 23 173 8 143 16 160 24 170

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Operations Management Questions!

Use the sales data below to generate forecasts for months 724 using a six-period and a three-period moving average. Use MAD to compare the forecasts. Which forecast is more stable? Which is more...

Use the sales data below to generate forecasts for months 68 using a Naive method and a three-period moving average. Use MAD to compare the forecasts. Which forecast is more accurate?...

2. Sales for the past 12 months at Bell, Inc. are given below. MONTH MONTH SALES (5 MILLIONS) 10 January July SALES ($ MILLIONS) 26 31 12 August February March 14 September 27 April 16 October 18 May...

Week Actual Service Calls 1 24 2 36 36 3 4 25 5 30 9. Consider the sales data for Computer Success given in Problem 7. a. Use a 3-month weighted moving average to forecast the sales for the months...

1. QUESTION 1 ________ methods assume that what has occurred in the past will continue to occur in the future. Time series Regressio n Quantitati ve Qualitativ e 1 points QUESTION 2 1. ________ is...

what would the excel formula be for each question a-i? A major source of revenue in Texas is a state sales tax. One category of tax is classified as Retail Trade. The following table gives four years...

Mop and Broom Manufacturing has tracked the number of units sold of their most popular mop over the past 24 months. This is shown. a. Develop a linear trend line for the data. (Round your answers to...

Old MathJax webview Description Case studies are used to enable you to apply new concepts, use the tools you have mastered, and improve your technical skills you have attained. Through the individual...

Excelsior flashlights. has recorded the number of flashlights it has sold in each of the last 15 months of business. Use the recorded demand data below to develop three-period and four-period simple...

Please Answer Asap Thank you! A30. SUPPLEMENT A SPREADSHEET MODELING: AN INTRODUCTION Problems 1. Kaizer Plastic produces a variety of plastic items for pack Soek can work only with a single "Set...

Part A - Scientific evidence supporting evolution Scientific evidence documents the pattern of evolution. The evidence exists in a variety of categories, including direct observation of evolutionary...

You are purchasing 12 pound average weight whole salmon The yield percentage is 69%. The As Purchased Price is $4.89 per pound. You are serving 63 people. You want to serve a 6 ounce portion. How...

Income Statement, Cost of Services Provided, Service Attributes Berry Company is an architectural firm located in Detroit, Michigan. The company works with small and medium-size construction...

Based on his estimates of the risk of a security, a trader believes that the price of a stock traded in a dealer market will fall within a $3 range, with potential prices being uniformly distributed....

Michael Marc, the President of MMS Associates, is considering an alternative plan for the sales staff situation described in Problem 9. His alternative plan is shown in Figure.What is the ld score...

A manufacturing company is designing an assembly line to produce its main product. The line should be able to produce 60 units per hour. The following data in Table give the necessary information....

An assembly line must be designed to produce 40 containers per hour. The following data in Table give the necessary information. (a) Draw a precedence diagram. (b) Compute the cycle time (in seconds)...

Inventory Turnover The following data (in millions) were taken from recent annual reports of Apple Inc., a manufacturer of personal computers and related products, and Mattel Inc., a manufacturer of...

Yaneska, When looking at price ceilings, you will find that the government will need to get involved to estimate what an appropriate price would be. How challenging do you think this is for us to...

Auto Co. Purchased 10% of the common shares of Manual Co. on January 1, 2020, for $32,000 paid in cash. During 2020, Manual Co. earned net income of $6,000 and paid dividends 50% from net income to...