Question: Please help me answer question 7 and 9 7 . Sales for the past 1 2 months at Computer Success are given here. table
Please help me answer question and
Sales for the past months at Computer Success are given here.
tableMonthSales $Month,Sales $JanuaryJuly,FebruaryAugust,MarchSeptember,AprilOctober,MayNovember,JuneDecember,
a Use a threemonth moving average to forecast the sales for the months May through December.
b Use a fourmonth moving average to forecast the sales for the months May through December.
c Compare the performance of the two methods by using the mean absolute deviation as the performance criterion. Which method would you recommend?
d Compare the performance of the two methods by using the mean absolute percent error as the performance criterion. Which method would you recommend?
e Compare the performance of the two methods by using the mean squared error as the performance criterion. Which method would you recommend?
Consider the sales data for Computer Success given in Problem
a Use a month weighted moving average to forecast the sales for the months April through December. Use weights of and giving more weight to more recent data.
b Use exponential smoothing with to forecast the sales for the months April through December. Assume that the initial forecast for January was $ Start error measurement in April.
c Compare the performance of the two methods by using the mean absolute deviation as the performance criterion, with error measurement beginning in April. Which method would you recommend?
d Compare the performance of the two methods by using the mean absolute percent error as the performance criterion, with error measurement beginning in April. Which method would you recommend?
e Compare the performance of the two methods by using the mean squared error as the performance criterion, with error measurement beginning in April. Which method would you recommend?
A convenience store recently started to carry a new brand of soft drink. Management is interested in estimating future sales volume to determine whether it should continue to carry the new brand or replace it with another brand. The table below provides the number of cans sold per week. Use both the trend projection with regression and the exponential smoothing let with an initial forecast for week of methods to forecast demand for week Compare these methods by using the mean absolute deviation and mean absolute percent error performance criteria. Does your analysis suggest that sales are trending and if so by how much?
tableWeek
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
