Question

1. The business analyst for Video Sales, Inc. wants to forecast this year's demand for DVD...

1. The business analyst for Video Sales, Inc. wants to forecast this year's demand for DVD decoders based on the following historical data: Year Demand 5 years ago 900 4 years ago 700 3 years ago 600 2 years ago 500 Last year 300 8. What is the forecast for this year using exponential smoothing with alpha = .4?

Year Demand
5 years ago 900
4 years ago 700
3 years ago 600
2 years ago 500
Last year 300

A. 163

B. 180

C. 300

D. 504

E. None of the choices

2. What is the MAE for the exponential smoothing with alpha = .4?

A. 64320
B. 198
C. 249
D. 247.8
E. None of the choices

Please show all the steps on excel, thank you in advance!

Homework Answers

Answer #1

so, forecast for this year = 503.52 ≈ 504

b) MAE=   Σ |et|/n = 991.20/4 =   247.80

please revert for doubt

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Sales of air conditioners have grown consistently over the years and the follow represents sales: Year          ...
Sales of air conditioners have grown consistently over the years and the follow represents sales: Year           Sales 1                  520 2                  550 3 600 4                  610 5                  680 6                  710 7 810 8 820 9 900 1) The sales manager had predicted, before the business started, that year 1 sales would be 465 air conditioners. Using exponential smoothing with an alpha of .30, develop a forecast. 2) Using smoothing constants of .6 and .9, develop forecasts for the sales of air...
1) Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply...
1) Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table . YEAR DEMAND FOR FERTILIZER (1,000S OF BAGS) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15 a) Develop a 3-year moving averages model to forecast sales. b) Develop a 3-year weighted moving averages model in which sales in the most recent year are given...
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week...
Problem 1: Auto sales at Carmen’s Chevrolet are shown below. Develop a 3-week moving average. Week Auto Sales 1 8 2 10 3 9 4 11 5 10 6 13 7 - Problem 2: Carmen’s decides to forecast auto sales by weighting the three weeks as follows: Weights Applied Period 3 Last week 2 Two weeks ago 1 Three weeks ago 6 Total Problem 3: A firm uses simple exponential smoothing with to forecast demand. The forecast for the week...
A small business has recorded sales over the last 20 years.  The data is provided in accompanying...
A small business has recorded sales over the last 20 years.  The data is provided in accompanying workbook, tab “Small Business”. The business would like to use this data to provide a sales forecast for the future, specifically, the next two years. Build a spreadsheet that shows all the forecasts on a side-by-side basis so they can be compared for effectiveness using an error measure. Create a chart showing the data in time.  Discuss any patterns in the dat Create moving average...
Individual Assignment ACC705 On 1 July 2015, Tuna Ltd acquired all the issued shares of Brim...
Individual Assignment ACC705 On 1 July 2015, Tuna Ltd acquired all the issued shares of Brim Ltd. Tuna Ltd paid $30 000 in cash and 20 000 shares in Tuna Ltd valued at $3 per share. At this date, the equity of Brim Ltd consisted of $66 000 share capital and $6000 retained earnings.    At 1 July 2015, all the identifiable assets and liabilities of Brim Ltd were recorded at amounts equal to their fair values except for: Carrying...
1.For a competitive, profit-maximizing firm, the labor demand curve is the same as the Group of...
1.For a competitive, profit-maximizing firm, the labor demand curve is the same as the Group of answer choices marginal revenue curve. marginal product curve. marginal cost curve. marginal revenue product curve. 2.Scenario 21 Gertrude Kelp owns three boats that participate in commercial fishing for fresh Pacific salmon off the coast of Alaska. As part of her business she hires a captain and several crew members for each boat. In the market for fresh Pacific salmon, there are thousands of firms...
In February 2012, the Pepsi Next product was launched into the US market. This case study...
In February 2012, the Pepsi Next product was launched into the US market. This case study provides students with an interesting insight into PepsiCo’s new product process and some of the challenging decisions that they faced along the way. Pepsi Next Case Study Introduction Pepsi Next was launched by PepsiCo into the US market in February 2012, and has since been rolled out to various international markets (for instance, it was launched in Australia in September 2012). The new product...