Historical demand for a product is DEMAND January 16 February 14 March 18 April 16 May 19 June 18 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 α = 0.20 and a June forecast = 12, find the July forecast. Make whatever assumptions you wish. (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 Referencese Book & Resources Worksheet Difficulty: M