Food Sales Num of Covers Average Check 1 Day Total Weekly Total Monthly Total Yearly Total % Gross Sales Lunch Dinner Take-out TOTAL Liquor Sales pel 310 550 210 $13.95 $20.00 $11.00 1070 $3.50 S Liquor Cost @ 23% = Total Gross Sales S Food Cost @33% = Total Cost of Sales = Gross Profit Weekly Rate Monthly Total Yearly Total Labour Cost Position Salaried: Gen Manager Asst. Manager Chef Sous Chef $1,500.00 $1,350.00 $1,350.00 $1,100.00 Hourly: Cooks Bartender Hostess) Server Steward Totals Hourly Rate $16.50 $15.00 $15.00 $15.00 $15.00 Weekly Hours 400 170 175 900 200 Yearly Total Benefits 7% of Total Labour Overhead Costs@ 22% of Total Gross Sales Profit/Loss NO 1. Calculate the popularity index for the following sales in Excel. Round each result to two decimals. Item Portions sold a. A B 75 35 80 C D 40 Rectangular Shije b. Item Portions sold A 30 B 40 70 D 125 c. Item Portions sold 85 A B D E mon 120 65 50 45 2. Using the popularity indexes calculated in Question 1a, predict the sales for each item if total sales for all items are expected to be 300. 3. Using the popularity indexes calculated in Question 1b, predict the sales for each item if total sales for all items are expected to be 150. 4. Using the popularity indexes calculated in Question 1c, predict the sales for each item if total sales for all items are expected to be 450