Sample Item Count Daily Report (with Cost)

Purpose

A sample Item Count Daily Report and description of the fields are shown 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.49 Sample Item Count Daily Report




	Daily Item Count for 3/11/200X
Focus Cafe	created at 3/11/200X 2:48:17 PM									Page 1 of 1
			Net	% of	Unit	Total	% of	Cost/	Gross		Profit/
Item		Units	Sales	Sales	Cost	Cost	Cost	Sales	Profit		Sales
Bourbon		5	11.25	3.31	0.54	2.70	2.54	24.00	8.55		76.00
Bud		8	18.00	5.29	0.74	5.92	5.56	32.89	12.08		67.11
Bud Light		6	13.50	3.97	0.74	4.44	4.17	32.89	9.06		67.11
Coors Light		13	29.25	8.60	0.74	9.62	9.04	32.89	19.63		67.11
Corona		17	42.50	12.50	0.87	14.79	13.89	34.80	27.71		65.20
Corona Light		9	22.50	6.62	0.87	7.83	7.35	34.80	14.67		65.20
Heineken		3	7.50	2.21	1.05	3.15	2.96	42.00	4.35		58.00
Jack Daniels		3	12.75	3.75	0.47	1.41	1.32	11.06	11.34		88.94
JumboMarg Frozen		10	52.50	15.44	1.57	15.70	14.75	29.90	36.80		70.10
JumboMarg rox		12	63.00	18.53	1.84	22.08	20.74	35.05	40.92		64.95
Marg Straw		2	9.00	2.65	2.45	4.90	4.60	54.44	4.10		45.56
Marg. Froz.		1	2.75	0.81	0.97	0.97	0.91	35.27	1.78		64.73
Miller Lite		2	4.50	1.32	0.74	1.48	1.39	32.89	3.02		67.11
PatronSilver Jumbo Marg		4	51.00	15.00	2.87	11.48	10.78	22.51	39.52		77.49
Grand Totals		95	340.00	100.00		106.47	100.00	31.31	233.53		68.69

Figure 8.50 Sample Item Count Daily Report Fields (Sorted by Report Group)

Field

Description

Item

The Menu Item Guest Check Name.

Units

The number of units sold.

Net Sales

Net Sales (net of Item Discounts) for the Menu Item.

% of Sales

Net Sales to Grand Total Sales percentage for the Menu Item.

Unit Cost

The Cost of the Menu Item.

Total Cost

Units Sold multiplied by Unit Cost.

% of Cost

The Menu Item Cost divided by the Total Cost for the report.

Cost/Sales

The Total Cost divided by Net Sales and displayed as a percentage.

Gross Profit

Net Sales minus Total Cost.

Profit/Sales

The Gross Profit divided by Net Sales and displayed as a percentage.

Grand Totals

Units	The number of units sold.
Net Sales	Total Net Sales (net of Item Discounts) for all Menu Items.
% of Sales	Net Sales to Grand Total Sales percentage for all Menu Item.
Total Cost	Total Cost for all Menu Items.
% of Cost	Total Menu Item Cost divided by the Total Cost for the report.
Cost/Sales	The Total Cost divided by Total Net Sales and displayed as a percentage.
Gross Profit	Total Net Sales minus Total Cost.
Profit/Sales	The Total Gross Profit divided by Total Net Sales and displayed as a percentage.

Figure 8.50.1 Sample Item Count Daily Report Setup Options

Fields Used

Description

Include Cost Informtion

Selected.

Primary Sort

Report Group

Selected.

Secondary Sort

Name

Selected.

Related Topics (none)