Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

c-2. Which is the preferred technique for making the forecast? begin{tabular}{|c|r|r|} hline & A & B hline 8 & 7 & 5811.3000 hline

image text in transcribedimage text in transcribedimage text in transcribed

c-2. Which is the preferred technique for making the forecast? \begin{tabular}{|c|r|r|} \hline & A & B \\ \hline 8 & 7 & 5811.3000 \\ \hline 9 & 8 & 5695.8000 \\ \hline 10 & 9 & 5316.3000 \\ \hline 11 & 10 & 5514.3000 \\ \hline 12 & 11 & 5544.0000 \\ \hline 13 & 12 & 5962.0000 \\ \hline 14 & 13 & 5625.4000 \\ \hline 15 & 14 & 5583.6000 \\ \hline 16 & 15 & 5421.9000 \\ \hline 17 & 16 & 5754.1000 \\ \hline 18 & 17 & 5497.8000 \\ \hline 19 & 18 & 5412.0000 \\ \hline 20 & 19 & 5471.4000 \\ \hline 21 & 20 & 5377.9000 \\ \hline 22 & 21 & 5568.2000 \\ \hline 23 & 22 & 5199.7000 \\ \hline 24 & 23 & 5622.1000 \\ \hline 25 & 24 & 5923.5000 \\ \hline 26 & 25 & 5539.6000 \\ \hline 27 & 26 & 5354.8000 \\ \hline 28 & 27 & 5540.7000 \\ \hline 29 & 28 & 5889.4000 \\ \hline 30 & 29 & 5519.8000 \\ \hline 31 & 30 & 5726.6000 \\ \hline \end{tabular} The owner of a convenience store near Salt Lake City in Utah has been tabulating weekly sales at the store, excluding gas. The accompanying table shows a portion of the sales for 30 weeks. Click here for the Excel Data File a. Use the 3-period moving average to forecast sales for the 31st week. (Do not round intermediate calculations. Round final answer to 2 decimal places.) b. Use simple exponential smoothing with =0.3 to forecast sales for the 31st week. (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. (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

Step: 3

blur-text-image

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

Modern Database Management

Authors: Fred R. McFadden, Jeffrey Slater, Mary B. Prescott

5th Edition

0805360549, 978-0805360547

More Books

Students also viewed these Databases questions