Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Not sure how to get trend lie form this data > ezto.mheducation.com Files M Question 7 - HW # 4 (Forecasting) - Connect Course

Not sure how to get trend lie form this data

image text in transcribedimage text in transcribed
> " ezto.mheducation.com Files M Question 7 - HW # 4 (Forecasting) - Connect Course Hero HW # 4 (Forecasting) i Saved Help Save & Exit Submit Check my work Problem 3-13 (Algo) 10 Historical demand for a product is as follows: points DEMAND April 68 May 63 June 88 eBook July 68 August 93 September 88 Print a. Using a simple four-month moving average, calculate a forecast for October. (Round your answer to 2 decimal places.) References Forecast for October 84.25 b. Using single exponential smoothing with a = 0.20 and a September forecast = 54, calculate a forecast for October. (Round your answer to 2 decimal places.) Forecast for October 60.80 Mc Graw > " ezto.mheducation.com Files M Question 7 - HW # 4 (Forecasting) - Connect Course Hero HW # 4 (Forecasting) i Saved Help Save & Exit Submit Check my work 7 b. Using single exponential smoothing with a = 0.20 and a September forecast = 54, calculate a forecast for October. (Round your 10 answer to 2 decimal places.) points Forecast for October 60.80 eBook Print c. Using simple linear regression, calculate the trend line for the historical data. Say the X axis is April = 1, May = 2, and so on, while the Y axis is demand. (Round your intercept value to the nearest whole number and slope value to 2 decimal places.) References Y + t d. Calculate a forecast for October using your regression formula. (Round your answer to 2 decimal places.) Forecast for October Mc Graw

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

Operations Management Processes and Supply Chains

Authors: Lee J. Krajewski, Larry P. Ritzman, Manoj K. Malhotra

10th edition

978-013280747, 132807394, 9780132951814, 132807475, 132951819, 978-0132807395

More Books

Students also viewed these General Management questions