Question: Please help me to solve this on excel. Do not use solutions already available on chegg. Thats trash. One of the divisions of TCC is
Please help me to solve this on excel. Do not use solutions already available on chegg. Thats trash.
One of the divisions of TCC is a hotline for consumers requesting information on their line of all-inclusive student vacations for the week after finals. As more and more information becomes available online from customers who are making negative Yelp posts about the vacation timing, phone requests for information have been declining. Still, the company is concerned with proper staffing during the days of December 17th and 18th.
| Date | Shift | Requests | |
| December 13 | Day | 70 | |
| Evening | 47 | ||
| Night | 46 | ||
| December 14 | Day | 65 | |
| Evening | 43 | ||
| Night | 37 | ||
| December 15 | Day | 59 | |
| Evening | 39 | ||
| Night | 34 | ||
| December 16 | Day | 56 | |
| Evening | 35 | ||
| Night | 30 |
Forecast the demand for information requests for the three shifts of December 17th and the three shifts of December 18th.
A) Create a chart that shows the number of requests. Do you see both trend and seasonality components in the data?
B) Forecast the number of requests for December 17th and December 18th. Please copy these numbers and include them on the executive summary (the first worksheet).
C) Create a second chart that shows both the requests through December 16th and the forecasted requests for December 17th and 18th. Color the chart so it is easy to distinguish the actual requests from the forecast.
At the end of this problem you should have 2 charts and an answer to question A. Include and label a separate tab with your regression results.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
