do in the same format as the first

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 p/pl 310 550 210 $13.95 $20.00 $11.00 1070 $3.50 $ Liquor Cost @ 23% $ Food Cost @ 33% Total Gross Sales 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 1. Calculate the popularity index for the following sales in Excel. Round each result to two decimals. a. Item Portions sold A B 75 35 80 40 D b. Item Portions sold 30 B 40 70 D 125 c. Item Portions sold I 85 mo> 120 65 50 45 2. Using the popularity indexes calculated in Question la, 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