Report Group Percentage Report

Purpose

The Sample Report Group % Report, shown below, is designed to display the Store ID, Net Sales, Food Sales, Food Sales %, Liquor Sales, Liquor Sales %, Beer Sales and Beer Sales %.

Figure 3.4.25 Sample Report Group % Report

Focus POS Corp

Report Group % Report for 3/1/200x-3/31/200x at 11/28/200x 1:41:32 PM Page 1

========================================================================================================

01 | 72867.89 | 42684.80 | 58.58 | 20339.22 | 27.91 | 9843.87 | 13.51 |

02 | 71617.15 | 43864.16 | 61.25 | 19829.68 | 27.69 | 7923.31 | 11.06 |

04 | 76227.18 | 45533.34 | 59.73 | 21166.10 | 27.77 | 9527.74 | 12.50 |

03 | 74348.75 | 44719.67 | 60.15 | 20559.95 | 27.65 | 9069.13 | 12.20 |

--------------------------------------------------------------------------------------------------------

Totals | 73765.24 | 44200.49 | 59.93 | 20473.74 | 27.76 | 9091.01 | 12.32 |

========================================================================================================

Figure 3.4.26 Sample Report Group % Report Fields

Field

Description

Store ID

Column 1

Displays the Restaurant ID established in Setup > Restaurants > ID.

Net Sales

Column 2

Displays the Net Sales amount for the restaurant for the selected date range.

Food Sales

Column 3

Displays the Food Sales amount for the restaurant for the selected date range.

Food %

Column 4

Calculates the percentage of Food Sales to Net Sales for the selected date range.

Liquor Sales

Column 5

Displays the Liquor Sales amount for the restaurant for the selected date range.

Liquor %

Column 6

Calculates the percentage of Liquor Sales to Net Sales for the selected date range.

Beer Sales

Column 7

Displays the Beer Sales amount for the restaurant for the selected date range.

Beer %

Column 8

Calculates the percentage of Beer Sales to Net Sales for the selected date range.

Totals

Net Sales	Column 2 Displays the corporate average Net Sales amount.
Food Sales	Column 3 Displays the corporate average Food Sales amount.
Food %	Column 4 Displays the corporate average Food Sales to Net Sales percentage.
Liquor Sales	Column 5 Displays the corporate average Liquor Sales amount.
Liquor %	Column 6 Displays the corporate average Liquor Sales to Net Sales percentage.
Beer Sales	Column 7 Displays the corporate average Beer Sales amount.
Beer %	Column 8 Displays the corporate average Beer Sales to Net Sales percentage.

Report Setup - Column 1 (Store ID)

Field	Setup Information
Heading 1	Store ID
Heading 2
Size	10
Sort	Ascending
Format	Text
Display	Yes
Filtered	No
Expression	“REST-ID”
Constant	n/a

Report Setup - Column 2 (Net Sales)

Field	Setup Information
Heading 1	Net
Heading 2	Sales
Size	10
Sort	<None>
Format	Currency (Avg. Total)
Display	Yes
Filtered	No
Expression	“Net Sales”
Constant	n/a

Report Setup - Column 3 (Food Sales)

Field	Setup Information
Heading 1	Food
Heading 2	Sales
Size	10
Sort	<None>
Format	Currency (Avg. Total)
Display	Yes
Filtered	No
Expression	"RG$1:Food"
Constant	n/a

Report Setup - Column 4 (Food %)

Field	Setup Information
Heading 1	Food %
Heading 2
Size	10
Sort	<None>
Format	% (Average Breaks)
Display	Yes
Filtered	No
Expression	“Column3” / “Column2”
Constant	n/a

Report Setup - Column 5 (Liquor Sales)

Field	Setup Information
Heading 1	Liquor
Heading 2	Sales
Size	10
Sort	<None>
Format	Currency (Avg. Total)
Display	Yes
Filtered	No
Expression	"RG$1:Liquor"
Constant	n/a

Report Setup - Column 6 (Liquor %)

Field	Setup Information
Heading 1	Liquor %
Heading 2
Size	10
Sort	<None>
Format	% (Average Breaks)
Display	Yes
Filtered	No
Expression	"Column5” / “Column2
Constant	n/a

Report Setup - Column 7 (Beer Sales)

Field	Setup Information
Heading 1	Beer
Heading 2	Sales
Size	10
Sort	<None>
Format	Currency (Avg. Total)
Display	Yes
Filtered	No
Expression	"RG$1:Beer"
Constant	n/a

Report Setup - Column 8 (Beer %)

Field	Setup Information
Heading 1	Beer %
Heading 2
Size	10
Sort	<None>
Format	% (Average Breaks)
Display	Yes
Filtered	No
Expression	"Column7” / “Column2”
Constant	n/a

Report Format Options

Field	Option
File Format	Text
Totals by Date	Not Selected
Type	None

Related Topics (none)