Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

CleLRY WOIR Historical demand for a product is: January February March April May June DEMAND 16 14 18 16 a. Using a weighted moving average

image text in transcribed

image text in transcribed

image text in transcribed

CleLRY WOIR Historical demand for a product is: January February March April May June DEMAND 16 14 18 16 a. Using a weighted moving average with weights of 0.50 (June), 0.20 (May), and 0.30 (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 a = 0.20 and a June forecast = 12, find the July forecast. (Round your answer to 1 decimal place.) July forecast CHERMy Work 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.) 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_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

Investment Grade Energy Audit Making Smart Energy Choices

Authors: Shirley J. Hansen, James W. Brown

1st Edition

0824709284, 978-0824709280

More Books

Students also viewed these Accounting questions

Question

What is the relationship between humans and nature?

Answered: 1 week ago