Question
Franklin Henry forecasts demand for an auditingand accounting services group, for an estate planning group ,and a business consulting group.His group forecasts for the preceding
Franklin Henry forecasts demand for an auditingand accounting services group, for an estate planning group ,and a business consulting group.His group forecasts for the preceding six-month(M) period, which were made six months prior to that time, are each based on a level, patternless projection.The following data table shows these forecasts(F) and the actual demand (AD) for each group :
Estate Planning Auditing and Accounting Business Consulting
(Client -days) (Client -days) (Client -days)
M AD F M AD F M AD F
1 120 130 1 260 230 1 120 120
2 80 130 2 240 230 2 140 120
3 100 130 3 270 230 3 170 120
4 120 130 4 320 230 4 190 120
5 125 130 5 290 230 5 230 120
6 110 130 6 200 230 6 210 120
Calculate the Forecast error(FE),MAD, Revised Forecast, Revised Error,and Revised MAD.Has the FE improved(decreased) ? What is the % improvementfor each forecast ?
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