Question
Given the past sales for the previous 9 months, use regression method to forecast the demand for month 10, 11, and 12. Month Demand 1
Given the past sales for the previous 9 months, use regression method to forecast the demand for month 10, 11, and 12.
| Month | Demand |
| 1 | 1600 |
| 2 | 1700 |
| 3 | 1600 |
| 4 | 2100 |
| 5 | 2500 |
| 6 | 2700 |
| 7 | 2800 |
| 8 | 2900 |
| 9 | 2920 |
| 10 | ? |
| 11 | ? |
| 12 | ? |
(a) Please use the EXCEL function of SLOPE and INTERCEPT to find the forecasted value of month 10, 11, and 12 demand.
SLOPE =
INTERCEPT =
Therefore,
The forecasted demand for month 10 is:
The forecasted demand for month 11 is:
The forecasted demand for month 12 is:
(b) Please use the EXCEL function of FORECAST to find the the forecasted value of month 10, 11, and 12 demand.
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
Principles Of Housing Finance Reform
Authors: Susan M. Wachter, Joseph Tracy
1st Edition
0812248627, 978-0812248623
