For numerical problems, you must SHOW ALL THE STEPS IN YOUR CALCULATIONS for

full credit. ROUND OFF NUMBERS UP TO 5 DECIMAL PLACES for higher accuracy. You

must USE THE APPROPRIATE UNIT/LABEL OF MEASUREMENT in your answers.

PLEASE ANSWER THE FOLLOWING THREE QUESTIONS. YOU MUST SHOW YOUR COMPLETE CALCULATIONS FOR FULL. CREDIT. 1. (SHOW YOUR COMPLETE WORK) The actual demand data for a product being sold at a convenience store durine the nast six weeks are shown below: Determine the demand forecast for THIS WEEK using each of the following methods: a. A 4-week moving average. b. A 3-week weighted moving average using weights of 12,3, and 1 for one week ago, two weeks ago, and three weeks ago, respectively. (Hint the higher weights are applied to the mere recent time periods.) Exponential smoothing using the following: smoothing constant, a=0.45 and the demand forecast for two weeks ago =221 units. [8 points] Use the appropriate label/unit of measurement in your answers. Leave the numbers in decimals and go up to 5 decimal places for higher accuracy. 2. (SHOW YOUR COMPLETE WORK) Manager at a local retailer has been monitoring the demand for a product. The actual demand data durine the last five weeks are shown below: Use trend-adjusted exponential smoothing to obtain the demand forecast for THIS WEEK. Use the following: Exponentially smoothed forecast five weeks ago =138 units Exponentially smoothed trend estimate five weeks ago =8 units The smoothing constants: =0.4,=0.5. [32 points] Use the appropriate labelumit of measurement in your answer. Leave the numbers in decimals and go up to 5 decimal places for higher accuracy: 3. (SHOW YOUR COMPLETE WORK) The actual demand data over the past seven weeks for a new product are shown below: a. Plot the weekly demand data using a software OR on a sheet of graph paper. [5 points] b. Use TREND PROJECTIONS method to determine the equation of the trend line estimating the linear relationship between time (in weeks) and demand (in units sold). [23 points] c. Use the equation of the trend line to predict demand for THIS WEEK. [2 points] (Hint: 'Seven weeks ago' will have a value of ' 1 ' in the equation of the trend line, and by the same logic 'One week ago' will have a value of ' 7 ' in the equation of the trend line.) Use the appropriate label/unit of measurement in your answers. Leave the numbers in decimals and go up to 5 decimal places for higher accuracy