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

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!