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

The detailed answer for the above question is provided below Calculating Exponential Smoothing Forec... 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

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Finance questions

Question

Given find the value of k. es 1 e kx dx = 1 4'

Answered: 1 week ago