Question: Please ignore the current numbers plugged in. I need help with both parts b and c but with these new numbers: Month Price Per Chip

Please ignore the current numbers plugged in. I need help with both parts b and c but with these new numbers:

Month Price Per Chip January $1.85 February $1.66 March $1.69 April $1.93Please ignore the current numbers plugged in. I

This exercise contains only parts b and c. b) Forecast January sales using each of the following methods. i) Compute the January sales forecast using naive method. The January sales forecast using the naive method= 24 sales. (Enter your response as a whole number.) ii) Compute the January sales forecast using a 3-month moving average. The January sales forecast using a 3-month moving average approach = 22 sales. (Round your response to two decimal places.) iii) Compute the January sales forecast using a 3-month weighted average with weights of 0.10, 0.30, and 0.60 with the heaviest weights applied to the most recent months. The January sales forecast using a 3-month weighted average = 23.10 sales. (Round your response to two decimal places.) iv) Compute the January sales forecast using exponential smoothing with = 0.30 and a starting forecast for September being 19. The January sales forecast using exponential smoothing= 21.42 sales. (Round your response to two decimal places.) v) Compute the January sales forecast using a trend projection. Using a method of trend projection, the forecast for January sales = 25.50 sales. (Round your response to two decimal places.) c) The method that can be used for making a forecast for the month of March is a trend projection This exercise contains only parts b and c. b) Forecast January sales using each of the following methods. i) Compute the January sales forecast using naive method. The January sales forecast using the naive method= 24 sales. (Enter your response as a whole number.) ii) Compute the January sales forecast using a 3-month moving average. The January sales forecast using a 3-month moving average approach = 22 sales. (Round your response to two decimal places.) iii) Compute the January sales forecast using a 3-month weighted average with weights of 0.10, 0.30, and 0.60 with the heaviest weights applied to the most recent months. The January sales forecast using a 3-month weighted average = 23.10 sales. (Round your response to two decimal places.) iv) Compute the January sales forecast using exponential smoothing with = 0.30 and a starting forecast for September being 19. The January sales forecast using exponential smoothing= 21.42 sales. (Round your response to two decimal places.) v) Compute the January sales forecast using a trend projection. Using a method of trend projection, the forecast for January sales = 25.50 sales. (Round your response to two decimal places.) c) The method that can be used for making a forecast for the month of March is a trend projection

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!