Question: I need help with part C, D and E please. Historical demand for a product is: DEMAND January February March April May June a. Using

I need help with part C, D and E please.

Historical demand for a product is: DEMAND January February March April May June 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 12.1 b. Using a simple three-month moving average, find the July forecast. (Round your answer to 1 decimal place.) July forecast 12 c. Using single exponential smoothing with a = 0.40 and a June forecast = 12, 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 = 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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Problem 18-15 (Algo) Historical demand for a product is January February March April May June DEMAND 12 10 13 12 15 13 o. Using a weighted moving average with weights of 0,50 (June), 0.20 (May), and...

Historical demand for a product is January February March April May June DEMAND 12 a. Using a weighted moving average with weights of 0.50 (June), 0.20 (May), and 0.20 (April), find the July...

1300_06FAX s Question 17-am 1- Connex + zto.mheducation.com/ext/map/indexhtml?_con con&external_browserslaunchurahttps%253A%252F%25 Update Saved Help Save & Exit Submit Historical demand for a...

15. Historical demand for a product is January February March April May June Demand 12 11 15 12 16 15 a. Using a weighted moving average with weights of 0.60, 0.30, and 0.10, find the July forecast....

If you can please show your work and round the correct decimal asked I would be very grateful! Thankyou! Historical demand for a product is January February March April May June DEMAND 14 11 15 14 16...

Problem 18-15 (Algo) Historical demand for a product is January February March April May June DEMAND 12 10 13 12 15 13 o. Using a weighted moving average with weights of 0.50 (June), 0.20 (May), and...

Historical demand for a product is: January February March April May June DEMAND 14 13 17 14 18 17 a. Using a weighted moving average with weights of 0.60 (June). 0.30 (May), and 0.10 (April), find...

Problem 18-15 (Algo) Historical demand for a product is January February March April May June DEMAND 18 17 21 18 22 21 a. Using a weighted moving average with weights of 0.50 (June), 0.40 (May), and...

Historical demand for a product is: January February March April May June DEMAND 15 14 18 15 19 18 a. Using a weighted moving average with weights of 0.40 (June), 0.20 (May), and 0.40 (April), find...

Historical demand for a product is: January February March April May June DEMAND 21 19 23 21 24 23 a. Using a weighted moving average with weights of 0.60 (June), 0.20 (May), and 0.20 (April), find...

The following information is for Carla Vista Company in September: 1. Cash balance per bank, September 30, $6,900. 2. Cash balance per book, September 30, $5,430. 3. Outstanding cheques, $3,150. 4....

Beginning Work in Process was 20,000 units 20% that were complete and 80,000 units started, with ending. Work in Process of 18,000 units that were 30% complete. If the manager adds materials halfway...

what is the basis for continuing these flexibilities even though there is no further recognized public health emergency?

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...