Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 34 2 37 3 38 4 37 5 40 6

The following table contains the demand from the last 10 months:

MONTH ACTUAL DEMAND
1 34
2 37
3 38
4 37
5 40
6 37
7 42
8 44
9 41
10 42

a. Calculate the single exponential smoothing forecast for these data using an ? of 0.20 and an initial forecast (F1) of 34. (Round your intermediate calculations and answers to 2 decimal places.)

Month Exponential Smoothing
1
2
3
4
5
6
7
8
9
10

b. Calculate the exponential smoothing with trend forecast for these data using an ? of 0.20, a ? of 0.30, an initial trend forecast (T1) of 1.00, and an initial exponentially smoothed forecast (F1) of 33. (Round your intermediate calculations and answers to 2 decimal places.)

Month FITt
1
2
3
4
5
6
7
8
9
10

c-1. Calculate the mean absolute deviation (MAD) for the last nine months of forecasts. (Round your intermediate calculations and answers to 2 decimal places.)

MAD
Single exponential smoothing forecast?
Exponential smoothing with trend forecast?

c-2. Which is best?

Single exponential smoothing forecast
Exponential smoothing with trend forecast

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

Personal Finance For Dummies

Authors: Eric Tyson

5th Edition

0470038322, 978-0470038321

More Books

Students also viewed these Finance questions

Question

4-1. What is meant by the term you attitude? [LO-1]

Answered: 1 week ago