Sample Inventory Usage Analysis Report

Purpose

A sample Inventory Usage Report and description of the fields are listed below.

Note: The sample report may differ from the actual report. The options used to configure the report will determine the actual output of the report.

Figure 8.76 Sample Inventory Usage Report



	Inventory Usage Analysis for 3/2/200X
Focus Cafe	created at 3/7/200X 12:24:06 PM																Page 1 of 1
					---------------------------------- Unit Usage ------------------------------------------						---------------- Dollar Usage ----------------				---------------- Food Cost -----------------
	Beg	Unit	Stock		Begin		Qty	Proj	Actual		Proj	Actual		%	$	%	$	%
Item	Date	Cost		Unit	Inv	+ Purchases	Sold	= End Inv	End Inv =	Variance	End Inv	End Inv =	Variance	Variance	COGS	COGS	COGU	COGU
Freezer
Apple Pies	2/25/200X	0.19	Ea.		70.00	120.00	48.00	142.00	125.00	-17.00	26.72	23.52	-3.20	-13.60	9.03	0.04	12.23	0.06
Breast Fillets (FTF)	2/25/200X	10.99	Bag		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Breast Fillets (Fresh)	2/25/200X	12.65	Bag		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Buns	2/25/200X	0.18	Ea.		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Butter Solids	2/25/200X	1.95	Ea.		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Cajun Meat	2/25/200X	7.79	Chub		14.00	18.00	21.56	10.44	15.00	4.56	81.35	116.87	35.52	30.39	167.97	0.76	132.45	0.60
Chicken Etouffee Base	2/25/200X	5.87	Chub		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Corn	2/25/200X	0.29	Ea.		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Crawfish Etouffee Base	2/25/200X	3.44	Chub		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
French Fries	2/25/200X	3.63	Bag		24.00	36.00	31.05	28.95	22.00	-6.95	105.05	79.82	-25.22	-31.60	112.65	0.51	137.88	0.62
Gravy Base	2/25/200X	5.94	Chub		13.00	18.00	16.21	14.79	6.00	-8.79	87.81	35.62	-52.19	-146.53	96.22	0.44	148.42	0.67
Mississippi Mud Cake	2/25/200X	0.56	Ea.		0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Freezer Totals					121.00	192.00	116.82	196.18	168.00	-28.18	300.93	255.83	-45.09	-17.62	385.87	1.75	430.98	1.95

Chicken
Chicken Pieces	2/25/200X	33.39	Case		37.00	68.00	70.66	34.34	23.00	-11.34	1,146.67	767.97	-378.70	-49.31	2,359.28	10.68	2,737.98	12.40
Chicken Wings	2/25/200X	57.60	Case		1.00	1.00	0.00	2.00	0.00	-2.00	115.20	0.00	-115.20	0.00	0.00	0.00	115.20	0.52
Dark Chicken	2/25/200X	28.00	Case		8.00	1.00	11.51	-2.51	6.00	8.51	-70.22	168.00	238.22	141.80	322.22	1.46	84.00	0.38
Wingers	2/25/200X	56.70	Case		1.00	0.00	0.00	1.00	1.00	0.00	56.70	56.70	0.00	0.00	0.00	0.00	0.00	0.00
Chicken Totals					47.00	70.00	82.17	34.83	30.00	-4.83	1,248.35	992.67	-255.68	-25.76	2,681.50	12.14	2,937.18	13.30
Grand Totals					168.00	262.00	198.99	231.01	198.00	-33.01	1,549.28	1,248.50	-300.77	-24.09	3,067.37	13.89	3,368.16	15.25

Figure 8.77 Inventory Usage Analysis Report Fields

Field

Description

Subgroup

Item

The name of the Inventory Item.

Beg Date

The date that a physical count was last taken for the item.

Unit Cost

The Unit Cost is the last purchase price for the Inventory Item.

Stock Unit

The Stock Unit defined for the item.

Unit Usage

Begin Inv	The beginning count of the Inventory Item.
Purchases	The number of Units Purchased (of the Inventory Item) from the Beg Date through the End Date. Note: Only purchases from posted Invoices are accumulated.
Qty Sold	The number of Inventory Items sold from the Beg Date through the End Date.
Proj End Inv	Begin Inv plus Purchases minus Qty Sold.
Actual End Inv	The physical Ending Inventory that was counted for the Inventory Item.
Variance	Actual End Inv minus Proj End Inv.

Dollar Usage

Proj End Inv	Proj End Inv multiplied by Unit Cost.
Actual End Inv	Actual End Inv multiplied by Unit Cost.
Variance	Actual End Inv Dollar Usage minus Proj End Inv Dollar Usage.
% Variance	Variance (Dollar Usage) divided by Actual End Inv (Dollar Usage) displayed as a percentage.

Food Cost

$ COGS	(Cost of Goods Sold) Unit Cost multiplied by Qty Sold.
% COGS	(Cost of Goods Sold) $ COGS divided by Net Sales displayed as a percentage.
$ COGU	(Cost of Goods Used) Unit Sales multiplied by Unit Cost.
% COGU	(Cost of Goods Used) Cost of Goods Used divided by Net Sales displayed as a percentage.

Subgroup Totals

Begin Inv	Total Begin Inv for the Subgroup.
Purchases	Total Purchased for the Subgroup.
Qty Sold	Total Qty Sold for the Subgroup.
Proj End Inv	Total Proj End Inv for the Subgroup.
Actual End Inv	Total Actual End Inv for the Subgroup.
Variance	Total Variance for the Subgroup.
Proj End Inv	Total Proj End Inv for the Subgroup.
Actual End Inv	Total Actual End Inv for the Subgroup.
Variance	Total Variance for the Subgroup.
% Variance	Variance Dollar Amount divided by Actual End Inv Dollar amount displayed as a percentage.
$ COGS	Total $ COGS for the Subgroup.
% COGS	Average % COGS for the Subgroup displayed as a percentage.
$ COGU	Total $ COGU for the Subgroup.
% COGU	Average % COGU for the Subgroup displayed as a percentage.

Grand Totals

Begin Inv	Total Begin Inv for all Subgroups.
Purchases	Total Purchased for all Subgroups.
Qty Sold	Total Qty Sold for all Subgroups.
Proj End Inv	Total Proj End Inv for all Subgroups.
Actual End Inv	Total Actual End Inv for all Subgroups.
Variance	Total Variance for all Subgroups.
Proj End Inv	Total Proj End Inv for all Subgroups.
Actual End Inv	Total Actual End Inv for all Subgroups.
Variance	Total Variance for all Subgroups.
% Variance	Total Variance Dollar Amount divided by Actual End Inv Dollar amount displayed as a percentage.
$ COGS	Total $ COGS for all Subgroups.
% COGS	Average % COGS for all Subgroups displayed as a percentage.
$ COGU	Total $ COGU for all Subgroups.
% COGU	Average % COGU for all Subgroups displayed as a percentage.

Figure 8.77.1 Inventory Usage Analysis Report Setup Options

Option	Selection
Sort	Subgroup

Related Topics (none)