Question
MAxx Inc. during the past six weeks indicate the number of jobs requests: WEEK 1 2 3 4 5 6 Requests (Actual) 46 40 38
MAxx Inc. during the past six weeks indicate the number of jobs requests:
WEEK | 1 | 2 | 3 | 4 | 5 | 6 |
Requests (Actual) | 46 | 40 | 38 | 42 | 44 | 45 |
Required: Predict the number of requests for Week 7 using each of the following methods:
a.. A four-period moving average.
b. Exponential smoothing with a = .40. Forecast for Week 1 was 50.
2. Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 11 months
Compute MAD and MSE for each forecast.
The forecasts and actual sales are as follows:
Month | SALES (ACTUAL) | FORECAST I | FORECAST II |
1 | 780 | 770 | 778 |
2 | 789 | 785 | 788 |
3 | 794 | 790 | 792 |
4 | 780 | 784 | 798 |
5 | 778 | 770 | 774 |
6 | 772 | 768 | 770 |
7 | 765 | 761 | 759 |
8 | 775 | 771 | 775 |
9 | 786 | 784 | 788 |
10 | 790 | 788 | 788 |
11 795 800 795
3. An electronics company is looking to develop a regression model to predict the number of units sold for a special running watch. Data is provided below:
Sales (units) | Price ($) | Advertising ($) |
500 | 100 | 50 |
480 | 120 | 40 |
485 | 110 | 45 |
510 | 103 | 55 |
490 | 108 | 40 |
488 | 109 | 30 |
496 | 106 | 45 |
a. Should this company use both price and promotion dollars, or just one of them only, to determine the sales? Perform data analysis and Explain. b. Use the model you determined (multiple regression) to predict sales if price is set at $125 and advertising is $55.
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