Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Historical demand for a product is DEMAND January 15 February 13 March 17 April 15 May 18 June 17 a. Using a weighted moving average

Historical demand for a product is

DEMAND
January 15
February 13
March 17
April 15
May 18
June 17

a. Using a weighted moving average with weights of 0.40 (June), 0.30 (May), and 0.30 (April), find the July forecast. (Round your answer to 1 decimal place.)

b. Using a simple three-month moving average, find the July forecast. (Round your answer to 1 decimal place.)

c. Using single exponential smoothing with = 0.10 and a June forecast = 13, find the July forecast. (Round your answer to 1 decimal place.)

d. Using simple linear regression analysis, calculate the regression equation for the preceding demand data. (Do not round intermediate calculations. Round your intercept value to 1 decimal place and slope value to 2 decimal places.)

e. Using the regression equation in d, calculate the forecast for July. (Do not round intermediate calculations. Round your answer to 1 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

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

Banking On Freedom Black Women In U.S. Finance Before The New Deal

Authors: Shennette Garrett-Scott

1st Edition

0231183917, 978-0231183918

More Books

Students also viewed these Finance questions