Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

excel data: Week Sales 1 5548.6100 2 5687.6600 3 5466.2100 4 5668.0900 5 5552.7300 6 5665.0000 7 5441.4900 8 5333.3400 9 4977.9900 10 5163.3900 11

image text in transcribed

excel data:

Week Sales
1 5548.6100
2 5687.6600
3 5466.2100
4 5668.0900
5 5552.7300
6 5665.0000
7 5441.4900
8 5333.3400
9 4977.9900
10 5163.3900
11 5191.2000
12 5582.6000
13 5267.4200
14 5228.2800
15 5076.8700
16 5387.9300
17 5147.9400
18 5067.6000
19 5123.2200
20 5035.6700
21 5213.8600
22 4868.8100
23 5264.3300
24 5546.5500
25 5187.0800
26 5014.0400
27 5188.1100
28 5514.6200
29 5168.5400
30 5362.1800
The owner of a convenience store near Salt Lake City in Utah has been tabulating weekly sales at the store, excluding gas. The accompanying data file contains the sales for 30 weeks. a. Use the 3-period moving average to forecast sales for the 31st week. Note: Do not round intermediate calculations. Round final answer to 2 decimal places. b. Use simple exponential smoothing with a=0.3 to forecast sales for the 31st week. Note: Do not round intermediate calculations. Round final answer to 2 decimal places. c-1. Report the performance measures for the techniques in parts a and b. Note: Do not round intermediate calculations. Round final answers to 2 decimal places

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions

Question

A chipped cracked sheet of glass is useless to us.

Answered: 1 week ago