Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help Historical demand for a product is as follows: a. Using a simple four-month moving average, calculate a forecast for October, (Round your answer

Please help
image text in transcribed
image text in transcribed
Historical demand for a product is as follows: a. Using a simple four-month moving average, calculate a forecast for October, (Round your answer to 2 decimal places.) b. Using single exponential smoothing with a=0.30 and a September forecast =61, calculate a forecast for October. (Round your answer to 1 decimal places.) 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.) 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.) d. Calculate a forecost for October using your regression formula. (Round your answer to 2 decimal places.)

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

Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics

Authors: Cliff T. Ragsdale

8th Edition

130594741X, 978-1337517317, 1337517313, 978-1305947412

More Books

Students also viewed these General Management questions

Question

A savings deposit is an investment in a series of short-term bonds.

Answered: 1 week ago