Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Comparison: Sales Forecast and Actual Sales Day: Friday Date 06-Oct Menu Item Sales Forecast Actual Sales Black Bean Soup 22 20 Clam Chowder 27 25
| Comparison: Sales Forecast and Actual Sales | ||||||
| Day: | Friday | Date | 06-Oct | |||
| Menu Item | Sales Forecast | Actual Sales | ||||
| Black Bean Soup | 22 | 20 | ||||
| Clam Chowder | 27 | 25 | ||||
| Shrimp Cocktail | 25 | 22 | ||||
| Oysters Rockefeller | 11 | 10 | ||||
| Prosciutto and Fig Bruschetta | 8 | 8 | ||||
| Jewels of the Sea | 9 | 8 | ||||
| New York Strip Steak | 15 | 17 | ||||
| Prime Rib of Beef | 23 | 20 | ||||
| Baby Back Pork Ribs | 12 | 12 | ||||
| Roast Leg of Lamb | 14 | 10 | ||||
| Loin of Pork a Maison | 13 | 11 | ||||
| Meatless Manicotti | 6 | 8 | ||||
| Chicken Breasts au Soy | 12 | 15 | ||||
| Tea-Smoked Salmon | 15 | 16 | ||||
| Baked Stuff Shrimp | 16 | 14 | ||||
| Chicken Albufera | 9 | 10 | ||||
| Fruits De Mer | 12 | 11 | ||||
| Catch of the Day | 15 | 16 | ||||
| Deep Dish Apple Pie | 16 | 15 | ||||
| Banna Beignets | 18 | 20 | ||||
| Apple-Blackberry Cobler | 22 | 22 | ||||
| Totals | ||||||
| Total Covers | 162 | 160 |
| Exercise 10.1 | Menu Pre-Cost and Abstract | ||||||||||||
| Day | Friday | Date | 06-Oct | ||||||||||
| FORECAST SALES AND FORECAST PERCENT | ACTUAL SALES AND STANDARD COST PERCENTAGE | ||||||||||||
| Menu Item | Number | Sales Price | Food Cost | Total | Total | Number | Sales | Food Cost | Total | Total | |||
| Forecasted | Cost | Percentage | Cost | Sales | Sold | Cost | Price | Percentage | Cost | Sales | |||
| Black Bean Soup | $1.10 | $4.30 | $1.10 | $4.30 | |||||||||
| Clam Chowder | $1.65 | $5.50 | $1.65 | $5.50 | |||||||||
| Shrimp Cocktail | $1.95 | $6.95 | $1.95 | $6.95 | |||||||||
| Oysters Rockefeller | $2.10 | $6.95 | $2.10 | $6.95 | |||||||||
| Prosciutto and Fig Bruschetta | $1.30 | $5.45 | $1.30 | $5.45 | |||||||||
| Jewels of the Sea | $1.85 | $6.95 | $1.85 | $6.95 | |||||||||
| New York Strip Steak | $7.75 | $21.50 | $7.75 | $21.50 | |||||||||
| Prime Rib of Beef | $7.95 | $19.50 | $7.95 | $19.50 | |||||||||
| Baby Back Pork Ribs | $5.70 | $15.45 | $5.70 | $15.45 | |||||||||
| Roast Leg of Lamb | $6.20 | $17.45 | $6.20 | $17.45 | |||||||||
| Loin of Pork a Maison | $5.50 | $17.45 | $5.50 | $17.45 | |||||||||
| Meatless Manicotti | $3.40 | $10.45 | $3.40 | $10.45 | |||||||||
| Chicken Breasts au Soy | $4.20 | $12.45 | $4.20 | $12.45 | |||||||||
| Tea-Smoked Salmon | $6.35 | $17.45 | $6.35 | $17.45 | |||||||||
| Baked Stuff Shrimp | $7.35 | $19.50 | $7.35 | $19.50 | |||||||||
| Chicken Albufera | $4.50 | $14.45 | $4.50 | $14.45 | |||||||||
| Fruits De Mer | $6.80 | $19.45 | $6.80 | $19.45 | |||||||||
| Catch of the Day | $4.75 | $14.50 | $4.75 | $14.50 | |||||||||
| Deep Dish Apple Pie | $0.90 | $3.50 | $0.90 | $3.50 | |||||||||
| Banna Beignets | $0.95 | $4.00 | $0.95 | $4.00 | |||||||||
| Apple-Blackberry Cobler | $0.90 | $3.50 | $0.90 | $3.50 | |||||||||
| Totals | |||||||||||||
| Total Covers |
| Exercise 10.2 | Periodic Potential Savings Worksheet | ||||
| For Test Period October 10 -15 | |||||
| Menu Item | Number | Portion | Sales Price | Total | Total |
| Sold | Cost | Standard Cost | Sales | ||
| Black Bean Soup | 112 | $1.10 | $4.30 | ||
| Clam Chowder | 133 | $1.65 | $5.50 | ||
| Shrimp Cocktail | 130 | $1.95 | $6.95 | ||
| Oysters Rockefeller | 45 | $2.10 | $6.95 | ||
| Prosciutto and Fig Bruschetta | 40 | $1.30 | $5.45 | ||
| Jewels of the Sea | 44 | $1.85 | $6.95 | ||
| New York Strip Steak | 72 | $7.75 | $21.50 | ||
| Prime Rib of Beef | 125 | $7.95 | $19.50 | ||
| Baby Back Pork Ribs | 60 | $5.70 | $15.45 | ||
| Roast Leg of Lamb | 72 | $6.20 | $17.45 | ||
| Loin of Pork a Maison | 66 | $5.50 | $17.45 | ||
| Meatless Manicotti | 32 | $3.40 | $10.45 | ||
| Chicken Breasts au Soy | 61 | $4.20 | $12.45 | ||
| Tea-Smoked Salmon | 77 | $6.35 | $17.45 | ||
| Baked Stuff Shrimp | 79 | $7.35 | $19.50 | ||
| Chicken Albufera | 45 | $4.50 | $14.45 | ||
| Fruits De Mer | 59 | $6.80 | $19.45 | ||
| Catch of the Day | 77 | $4.75 | $14.50 | ||
| Deep Dish Apple Pie | 79 | $0.90 | $3.50 | ||
| Banna Beignets | 88 | $0.95 | $4.00 | ||
| Apple-Blackberry Cobler | 60 | $0.90 | $3.50 | ||
| Totals | |||||
| Total Covers | |||||
| Sales For Test Period | |||||
| Actual Cost | |||||
| Standard Cost | |||||
| Potential Savings | |||||
| Actual Cost Percentage | |||||
| Standard Cost Percentage | |||||
| Potential Savings as a % of Sales |
| Exercise 16.1 | Barnaby's Hideaway | ||||||||
| Daily Beverage Cost Calculations with Adjustments | |||||||||
| Beverages | Total Cost | Sales | Cost % | ||||||
| Date | Issued | Additions | Subtractions | Today | To Date | Today | To Date | Today | To Date |
| 01-Nov | |||||||||
| 02-Nov | |||||||||
| 03-Nov | |||||||||
| 04-Nov | |||||||||
| 05-Nov | |||||||||
| 06-Nov | |||||||||
| 07-Nov |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Accounting For Decision Making And Control
Authors: Jerold Zimmerman
7th Edition
0078136725, 9780078136726
