Complete the Menu Pre-Cost and Abstract using the information from Exercise 10.2 Exercise 10.1. IM 47% 29:01 PM Exercise 10.2 answers - Saved File Home Insert Draw Formulas Data Review View Zoom In Zoom Out 19 Freeze Panes fx H - J K L . N o 1 ACTUAL SALES AND STANDARD COST PERCENTAGE Total Sales Number Sold Total Cost Total Sales 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 21 Cost $1.10 $1.65 $1.95 $2.10 $1.30 $1.85 $7.75 $7.95 $5.70 $6.20 $5.50 $3.40 $4.20 $6.35 $7.35 $4.50 $6.80 $4.75 $0.90 $0.95 $0.90 Sales Food Cost Price Percentage $4.30 $5.50 $6.95 $6.95 $5.45 $6.95 $21.50 $19.50 $15.45 $17.45 $17.45 $10.45 $12.45 $17.45 $19.50 $14.45 $19.45 $14.50 $3.50 $4.00 $3.50 + Sheet1 Sheetz Sheets IM 47% 29:01 PM Exercise 10.2 answers - Saved File Home Insert Praw Formulas Data Review View Zoom In Zoom Out 19 Freeze Panes fx 2 G H 1 A B C D E F Exercise 10.2 Menu Pre Cost and Abstract Day Friday Date 6-Oct FORECAST SALES AND FORECAST PERCENT Menu Item Number Forecasted Total Cost Tota Sale 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 21 Black Bean Soup Clam Chowder Shrimp Cocktail Oysters Rockefeller Prosciutto and Fig Bruschetta Jewels of the Sea New York Strip Steak Prime Rib of Beef Baby Back Pork Ribs Roast Leg of Lamb Loin of Pork a Maison Meatless Manicotti Chicken Breasts au Soy Tea-Smoked Salmon Baked Stuff Shrimp Chicken Albufera Fruits De Mer Catch of the Day Deep Dish Apple Pie Banna Beignets Apple-Blackberry Cobler Totals Total Covers Cost $1.10 $1.65 $1.95 $2.10 $1.30 $1.85 $7.75 $7.95 $5.70 $6.20 $5.50 $3.40 $4.20 $6.35 $7.35 $4.50 $6.80 $4.75 $0.90 $0.95 $0.90 Sales Price Food Cost Percentage $4.30 $5.50 $6.95 $6.95 $5.45 $6.95 $21.50 $19.50 $15.45 $17.45 $17.45 $10.45 $12.45 $17.45 $19.50 $14.45 $19.45 $14.50 $3.50 $4.00 $3.50 + Sheet1 Sheetz Sheets