Please Do the Work in Excel, and show what formulas was used and Solver. It has to be done in excel or the question doesn't work.

Problem 4 The famous Y. S. Chang Restaurant is open 24 hours a day. Waiters and busboys report for duty at 3 AM, 7AM, 11AM, 3PM, 7PM, or 11PM, and each works an 8-hour shift. The following table shows the minimum number of workers needed during the six periods into which the day is divided. Chang's scheduling problem is to determine how many waiters and busboys should report for work at the start of each time period to minimize the total staff required for one day's operations. (Hint: Let X; equal the number of waiters and busboys beginning work in time period i, where i =1, 2, 3, 4, 5, 6.) PERIOD TIME Number of Waiters and Busboys required 3AM - 7AM 3 7AM - 11AM 12 11AM-3PM 16 3PM - 7PM 9 7PM - 11PM 11 11PM -3AM 4 1 2 3 4 5 6 Use Excel model to determine how to minimize the number of total staff required for Chang Restaurant's daily operation