Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Historical demand for a product is DEMAND January 19 February 18 March 22 April 19 May 23 June 22 a. Using a weighted moving average

Historical demand for a product is

DEMAND
January 19
February 18
March 22
April 19
May 23
June 22

a.

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

July forecast

b.

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

July forecast

c.

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

July forecast

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.)

Y = + t

e.

Using the regression equation in d, calculate the forecast for July. (Do not round intermediate calculations. Round your answer to 1 decimal place.)

July forecast

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

Students also viewed these Accounting questions