Storeroom Inventory Twoo

Sheet1

	Use the following formulas:
	This year - Last year = Variance
	Variance / Last Year = Percentage Variance
	Frank's Fried Fish Shack
	Month	Guests This Year	Guests Last Year	Variance	Percentage Variance
	Jan	14,200	13,700
	Feb	15,230	14,900
	Mar	16,860	16,342
	Apr	17,230	16,500
	May	15,980	14,986
	Jun	16,534	15,720
	6-Mo. Total:
	Use the following formulas:
	Last year x % Guest Increase = Guest Increase Estimate
	Last Year + Guest Increase Estimate = Guest Count Forecast
	Mama Maria's Pasta Palace
	Month	Guests Last Year	% Increase Estimate	Guest Increase Estimate	Guest Count Forecast
	Jan	13,700	6.5%
	Feb	14,900	6.5%
	Mar	16,342	6.5%
	Apr	16,500	6.5%
	May	14,986	6.5%
	Jun	15,720	6.5%
	6-Mo. Total:		6.5%
	Compute Sales to Date for Franks Fish Shack:
	Sales Period	Date	Daily Sales	Sales to Date
	Monday	1-Jan	$ 853.80	$ 853.80
	Tuesday	2-Jan	$ 972.00
	Wednesday	3-Jan	$ 1,285.30
	Thursday	4-Jan	$ 944.80			Daily Sales + Sales to date
	Friday	5-Jan	$ 752.77
	Saturday	6-Jan	$ 893.42
	Sunday	7-Jan	$ 724.87
	Week's Total:

This year - Last Year

Variance / Last Year

Last Year X % Increase estimate

Last Year + Guest Increase estimate

Sheet2

	SAMPLE PRODUCT SPEC SHEETS
	Use this template to create a product spec sheet for your menu items
	Product	Item Description	package description	Case price	price per EACH	price per LB.	price per OZ.
	DAIRY
	Eggs	Large Grade AA	30 Dozen	$30.69				(Price per dozen)
	Butter	unsalted	36-1 # bricks	$115.00
	Milk	whole	4-1 gallon	$19.15
	SEAFOOD
	Cod	fresh : paella	10#	$98.00
	Shrimp	fresh : entrée 36/40 ct	10# cs	$48.90
	Calamari	frozen : entrée	25# Box	$127.50
	PRODUCE
	tomatoes	Med/red, vine ripe	20 #	$17.28
	pepper	Med green bell pepper	25 # Box	$17.29
	FRESHPOINT:	From the produce pricing handout, determine the following:
Line #	Product	Item Description	package description	Case price	price per EACH	price per LB.	price per OZ.
1	Tomatoes	5 x 6 Repack
15	Bananas	Green Tip
33	Squash	Zucchini
37	Lettuce	Green Leaf
42	Lettuce	Iceberg