Complete the exercise 10.1, 10.2 and 16.1 using Comparison: Sales For cast and Actual sales Table data as below

                                                                                                                                                                             

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