Question: can you show work in excel please?? thank you! Based on the following data, answer Questions 1-2 Actual Period Demand Forecast 1 2 3 132
can you show work in excel please?? thank you!
Based on the following data, answer Questions 1-2 Actual Period Demand Forecast 1 2 3 132 148 147 153 161 164 145 139 150 154 165 172 5 6 1. Which of the following is true a. On average, the forecast is underestimating the actual demand by 3.33 units b. On average, the forecast is overestimating the actual demand by 3.33 units c. On average, the forecast is underestimating the actual demand by 6.33 units d. On average, the forecast is off by 4.3 e. On average, the forecast is overestimating the actual demand by 20 units 2. Which of the following is true a. On average, the forecast is underestimating the actual demand by 3.33 units b. On average, the forecast is 3.33 units away from the actual demand c. On average, the forecast is 38 units away from the actual demand d. The forecast is 6.33 units away from the actual demand e. On average, the forecast is overestimating the actual demand by 20 units
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
