need some help please

need help

sales forecast & actual sales

Exercise 10.1 Comparison: Sales Forecast and Actural Sales Date 6-Oct Day Friday Sales Forecast Actual Sales Menu Item Difference -2 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 20 25 22 10 8 8 17 20 12 10 11 8 15 16 14 10 11 16 15 20 22 sty @ MacBook Air Exercise 10.2 Menu Pre Cost and Abstract Day Friday Dato FORECAST SALES AND FORECAST PERCENT 6-Oct ACTUAL SALES AND STANDARD COST PERCENTAGE Menu Item Number Forecasted Number Sold Total Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total Sales $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Total Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 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 Manicott 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 Sales Price Food Cost Percentage $4.30 25.58% $5.50 30.00% $6.95 28.06% $6.95 30.22% $5.45 23.85% $6.95 26.62% $21.50 36.05% $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 A 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 25.58% $5.50 30.00% $6.95 28.06% $6.95 30.22% $5.45 23.85% $6.95 26.62% $21.50 36.05% $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 $0.90 $0.00 $0.00 $0.00 Periodic Potential Savings Worksheet Exercise 10.3 For Test Period October 10-15 Menu Item Sales Price Total Standard Cost $123.20 $219.45 $253.50 $94.50 $52.00 $81.40 $558.00 $993.75 $342.00 Total Sales $481.60 $731.50 $903.50 $312.75 $218.00 $305.80 $1,548.00 $2.437.50 $927.00 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 Pio Banna Beignets Apple-Blackberry Cobler Totals Total Covers Number Sold 112 133 130 45 40 44 72 125 60 72 66 32 61 77 79 45 59 77 79 88 60 Portion 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 $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 $2.717.80 $7,865.65 Sales For Test Period Actual Cost Standard Cost Potential Savings $6.422.85 Actual Cost Percentage Standard Cost Percentage Potential Savings as a % of Sales