Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SAM SALES FIGURE MONTH UNIT SALES FIGURE JAN 14 FEB 16 MARCH 23 APRIL 25 MAY 24 a) Make a forecast for June using a

SAM SALES FIGURE

MONTH UNIT SALES FIGURE
JAN 14
FEB 16
MARCH 23
APRIL 25
MAY 24

a) Make a forecast for June using a three-period moving average and a four-period moving average. (Clearly show all formulas and calculations and round to one decimal place).

b) Using the data presented above, what will be the forecast for July (using both the three-period moving average and four-period moving average) if the actual unit sales figure for June turns out to be 20? (Clearly show all formulas and calculations and round to one decimal place).

c) Using the data presented above, what will be the forecasts for June and July using the exponential smoothing method? Compile two different forecasts for both months (four forecasts in all) using alpha values of 0.1 and 0.6 and with a forecast value for May of 23; actual sales for June would be 20. (Clearly show all formulas and calculations and round to one decimal place).

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

Quantitative Methods For Business

Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey Cam

11th Edition

978-0324651812, 324651813, 978-0324651751

More Books

Students also viewed these General Management questions