PLEASE COMPLETE WORK IN EXCEL SPREADSHEET ONLY. SHOW ALL FORMULAS/FUNCTIONS TO SHOW ANSWERS AND EXPLAIN TO ME HOW YOU GOT THE ANSWER. DO NOT WRITE IT DOWN IN A PIECE OF PAPER ONLY EXCEL.

1. A restaurant has tracked the number of meals served at lunch over the last four weeks. The data show little in terms of trends, but do display substantial variation by day of the week. Use the following information to determine the seasonal (daily) indices for this restaurant.

1	2	3	4	Average Weekly Demand	Average Daily Demand	Seasonal Index
40	35	39	43
54	55	51	59
61	60	65	64
72	77	78	69
89	80	81	79
91	90	99	95
80	82	81	83