MM 9.47%9:05 PM Exercise 10.3 answers - Saved File Home Insert Draw Formulas Data Review View Zoom In Zoom Out * Freeze Panes fx Periodic Potential Savings Worksheet 4 A B D E F G 133 130 45 40 44 72 125 60 72 66 II 8 Clam Chowder 9 Shrimp Cocktail 10 Oysters Rockefeller 11 Prosciutto and Fig Bruschetta 12 Jewels of the Sea 13 New York Strip Steak 14 Prime Rib of Beef 15 Baby Back Pork Ribs 16 Roast Leg of Lamb 17 Loin of Pork a Maison 18 Meatless Manicotti 19 Chicken Breasts au Soy 20 Tea-Smoked Salmon 21 Baked Stuff Shrimp 22 Chicken Albufera 23 Fruits De Mer 24 Catch of the Day 25 Deep Dish Apple Pie 26 Banna Beignets 27 Apple-Blackberry Cobler 28 Totals 29 Total Covers 30 31 Sales For Test Period 32 Actual Cost 33 Standard Cost 34 Potential Savings 35 36 Actual Cost Percentage 37 Standard Cost Percentage 38 Potential Savings as a % of Sales 39 40 $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 $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 32 61 77 79 45 59 77 79 88 60 $6,139.95 41 + Sheet1 Sheetz Sheets MM 47%9:05 PM Exercise 10.3 answers - Saved File Home Insert Draw Formulas Data Review View Zoom In Zoom Out * Freeze Panes fx Periodic Potential Savings Worksheet 2 A B E F G 1 ytial Savings Worksheet Sales Price Total Standard Cost Total Sales Exercise 10.3 Veriodic P 2 For Test Period October 10-15 3 4 5 Menu Item Number Portion 6 Sold Cost 7 Black Bean Soup 112 $1.10 8 Clam Chowder 133 $1.65 9 Shrimp Cocktail 130 $1.95 10 Oysters Rockefeller 45 $2.10 11 Prosciutto and Fig Bruschetta 40 $1.30 12 Jewels of the Sea 44 $1.85 13 New York Strip Steak 72 $7.75 14 Prime Rib of Beef 125 $7.95 15 Baby Back Pork Ribs 60 $5.70 16 Roast Leg of Lamb 72 $6.20 17 Loin of Pork a Maison 66 $5.50 18 Meatless Manicotti 32 $3.40 19 Chicken Breasts au Soy 61 $4.20 20 Tea-Smoked Salmon 77 $6.35 21 Baked Stuff Shrimp 79 $7.35 22 Chicken Albufera 45 $4.50 23 Fruits De Mer 59 $6.80 24 Catch of the Day 77 $4.75 25 Deep Dish Apple Pie 79 $0.90 26 Banna Beignets 88 $0.95 27 Apple-Blackberry Cobler 60 $0.90 28 Totals 29 Total Covers 30 31 Sales For Test Period 32 Actual Cost 33 Standard Cost $6,139.95 21 Potential Savinns + Sheet1 Sheetz Sheets $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 Complete the Periodic Savings Worksheet for Barnaby's Hideaway for the Exercise 10.3 period October 10-15