Question
1. The table below contains the actual sales data for the past 3 months, as well as the value that we forecasted for each month.
1. The table below contains the actual sales data for the past 3 months, as well as the value that we forecasted for each month. We are interested in how well our forecasting system has been performing--in particular we are interested in Bias. Compute the MFE for data in the table. Month Actual Sales Forecast Sales Apr 91 89 May 70 114 Jun 125 122
2.You started with a time series of actual sales data for 12 months. You used this data to determine that there is a trend of 15. Month 15's actual sales are 1,181. What is your trend-based forecast for month 16?
3. You started with a time series of actual sales data for 8 quarters (a quarter is a 3 month period, such as Fall 2021). You used this data to determine that there is a trend of -287. Quarter 10's actual sales are 11,044. What is your trend-based forecast for quarter 11? Note that the trend here is negative
. 4. The table below contains historical actual sales data for the past 5 months. What is the trend? Note, you should graph this out and eyeball it. However, you can supplement this by using excel. Feb 2001 Mar 1988 Apr 1979 May 1968 Jun 1960
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started