slide 1 is the information from exercise 10.1 the other 2 are from exercise 2 the assignments are labeled at the top of worksheet

MIM Bb 42%9:47 AM answers 10.1 - saved File Home Insert Draw Formulas Data Review View AutoSum Recently Used Calculate Now = E28 A B 1 Exercise 10.1 Day D E F Comparison: Sales Forecast and Actural Sales Date 6-Oct Friday 2 3 4 Menu Item Sales Forecast Actual Sales Difference 2 3 0 -2 3 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 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 22 27 25 11 8 9 15 23 12 14 13 6 12 15 16 9 12 15 16 18 22 320 320 20 25 22 10 8 8 17 20 12 10 11 8 15 16 14 10 11 16 15 20 22 310 310 4 2 -2 -3 -1 2 -1 1 -1 1 -2 0 10 10 + Sheet1 Sheetz Sheets MIM Bb 42%9:48 AM Exercise 10.2 - Read-only H File Home Insert Draw Formulas Pata Review View AutoSum Recently Used O Calculate Now fx 4 A B D E F G H 1 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 MIM Bb 9.41%9:48 AM Exercise 10.2 - Read-only H File Home Insert Draw Formulas Data Review View AutoSum Recently Used O Calculate Now 4 H - J L M N O P 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. $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 Exercise 10.2 Complete the Menu Pre-Cost and Abstract using the information from Exercise 10.1