Question

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 of January 1 was 500 units whereas the actual demand turned out to be 450 units. Calculate the demand forecast for the week of January 8.

Problem 4:

Exponential smoothing is used to forecast automobile battery sales. Two value of are examined, and Evaluate the accuracy of each smoothing constant. Which is preferable? (Assume the forecast for January was 22 batteries.) Actual sales are given below:

Month

Actual Battery Sales

Forecast

January

20

22

February

21

March

15

April

14

May

13

June

16


Problem 5:

Use the sales data given below to determine: (a) the least squares trend line, and (b) the predicted value for 2003 sales.

Year

Sales (Units)

1996

100

1997

110

1998

122

1999

130

2000

139

2001

152

2002

164

To minimize computations, transform the value of x (time) to simpler numbers. In this case, designate year 1996 as year 1, 1997 as year 2, etc.


Problem 6:

Given the forecast demand and actual demand for 10-foot fishing boats, compute the tracking signal and MAD.

Year

Forecast Demand

Actual Demand

1

78

71

2

75

80

3

83

101

4

84

84

5

88

60

6

85

73

Problem: 7

Over the past year Meredith and Smunt Manufacturing had annual sales of 10,000 portable water pumps. The average quarterly sales for the past 5 years have averaged: spring 4,000, summer 3,000, fall 2,000 and winter 1,000. Compute the quarterly index.

Problem: 8

Using the data in Problem 7, Meredith and Smunt Manufacturing expects sales of pumps to grow by 10% next year. Compute next year’s sales and the sales for each quarter.



Homework Answers

Answer #1

A three week moving average means that the value of a particular week will be the average of the past three weeks. In the problem 01 mentioned we have been given the auto sales figure of the first six weeks. In order to calculate the three week moving average we need to start from week 4 as we need atleast 3 prior weeks of data to work.

The table below will describe the solution:

Week Auto sales 3 week moving average (Answer)
1 8
2 10
3 9
4 11 (8+10+9)/3 = 9
5 10 (10+9+11)/3 = 10
6 13 (9+11+10)/3 = 10
7 (11+10+13) = 11.33


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 paint at Eddie's hardware store over the past 10 weeks are shown below: Week...
Sales of paint at Eddie's hardware store over the past 10 weeks are shown below: Week 1 - 20 Week 2- 21 Week 3- 29 Week 4- 36 Week 5- 24 Week 6- 29 Week 7-37 Week 8- 24 Week 9- 26 Week 10- 29 A. The forecast for week 3 using exponential smoothing with alpha=0.6 and a week 1 initial forecast of 20 is _____ B. For the forecast developed using exponential smoothing with alpha=0.6 and a week 1...
(b) Develop the three-week moving average forecasts for this time series. (Round your answers to two...
(b) Develop the three-week moving average forecasts for this time series. (Round your answers to two decimal places.) Week Time Series Value Forecast 1 16 2 11 3 13 4 10 5 14 6 12 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (c) Use α = 0.2 to compute the exponential smoothing forecasts for the time series. Week Time Series Value Forecast 1 16 2 11 3 13 4...
Given the following sales data: week 1: 20 week 2: 29 week 3: 34 week 4:...
Given the following sales data: week 1: 20 week 2: 29 week 3: 34 week 4: 21 week 5: 22 Forecast sales for week 6 using an exponential smoothing forecast with alpha = 0.4. Intialize using F(2) = [ A(1) + A(2) ] / 2. Your Answer:
Problem 5:  Below is 4 weeks of sales data for a restaurant that is open 5 days...
Problem 5:  Below is 4 weeks of sales data for a restaurant that is open 5 days a week (Tuesday-Saturday).   a. Develop an Exponential Smoothing forecast.  Use an alpha of .85 and assume the initial forecast for January is 975 b. Calculate the MAD for this forecast. Actual Day Demand Tuesday 975 Wednesday 1225 Thursday 1445 Friday 1750 Saturday 2160 Tuesday 1500 Wednesday 750 Thursday 895 Friday 1500 Saturday 1445 Tuesday 1025 Wednesday 650 Thursday 850 Friday 980 Saturday 1500 Tuesday 750...
Actual sales for January through April are shown below: Observation Month Actual Sales (A) Forecasted Sales...
Actual sales for January through April are shown below: Observation Month Actual Sales (A) Forecasted Sales (F)   1 January 18 2 February 23 3 March 20 4 April 16 5 May a. Use exponential smoothing with α = 0.2 to calculate smoothed averages and forecast sales for May from the above data. Assume the forecast for the initial period (January) is 18. b. Calculate MSE, and MAPE.
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 12...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 12 16 11 18 13 (b) Develop the three-week moving average forecasts for this time series. (Round your answers to two decimal places.) Week Time Series Value Forecast 1 19 2 12 3 16 4 11 5 18 6 13 Compute MSE. (Round your answer to two decimal places.) MSE =   What is the forecast for week 7? (c) Use α = 0.2 to compute...
Problem 15-05 (Algorithmic) Consider the following time series data. Week 1 2 3 4 5 6...
Problem 15-05 (Algorithmic) Consider the following time series data. Week 1 2 3 4 5 6 Value 16 13 18 11 15 14 Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places. Week Time Series Value Forecast 1 16 2 13 3 18 4 11 5 15 6 14 MSE: _______ The forecast for week 7: ______ Use  = 0.2 to compute the exponential smoothing values...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13 15 12 16 14 c)Use α = 0.2 to compute the exponential smoothing forecasts for the time series. Week Time Series Value Forecast 1 18 2 13 18 3 15 4 12 5 16 6 14 Compute MSE. (Round your answer to two decimal places.) MSE =____ What is the forecast for week 7? (Round your answer to two decimal places.) ____ (e)Use a...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13 16 11 17 14 A) What type of pattern exists in the data? (HORIZONTAL OR TREND) B) Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. If required, round your answers to two decimal places. Week Time Series Value Forecast 1 18 2 13 3 16 4 11 _______ 5 17 _______ 6 14 _______ MSE:...
Requirements: Moving Averages. Use the below actual sales to calculate a one-year average which will be...
Requirements: Moving Averages. Use the below actual sales to calculate a one-year average which will be used as the forecast for next periods (chapter 14, text). Choose a moving average period that best supports this calculation. Exponential Smoothing. Use the same data to forecast sales for the next periods with α=.40 (chapter 14, text). Regression Analysis on Excel. Draw a scatter graph from Insert/Graph/Scatter graph selections in Excel (chapter 15, text). Month Actual Sales 1 3050 2 2980 3 3670...