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!
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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!