Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

TABLE:3 Period Demand forecast Weights Weighted Moving Exponential X2 Smoothing xy average forecast 1 1600 23 456 2 2200 2000 1600 2500 3500 7

image text in transcribed

TABLE:3 Period Demand forecast Weights Weighted Moving Exponential X2 Smoothing xy average forecast 1 1600 23 456 2 2200 2000 1600 2500 3500 7 3300 8 3200 9 3900 10 4700 11 4300 12 4400 13 a. Calculate the forecast for the data using a four-year moving average. b. Use the data to calculate the forecast for period 5 using a four-period weighted average moving average. The weights of .4, .3, .2, and .1 are assigned to the most recent, second most recent, third most recent and the fourth most recent respectively. c. Based on the data, calculate the forecast from period three using the exponential smoothing method. Assume the forecast for period two is 1600 and =3 d. Use the data to estimate the linear trend forecast using the simple linear regression to calculate the trend line and the forecast for period 13 OR estimate the regression equation for period 13. NOTE!!! In this question, you are required to show all your calculations for each of the trend lines to enable you estimate or forecast the demand for period 13.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Horngrens Financial and Managerial Accounting

Authors: Tracie L. Nobles, Brenda L. Mattison, Ella Mae Matsumura

4th Edition

978-0133251241, 9780133427516, 133251241, 013342751X, 978-0133255584

Students also viewed these General Management questions