Average Store Sales Ranking Report

Purpose

The Sample Average Store Sales Ranking Report, shown below, is designed to display a store’s Net Sales, Dollar amount off the corporate Net Sales average, Percentage amount off the corporate Net Sales average and the Store Rank based on Net Sales.

Figure 3.4.11 Sample Average Store Sales Ranking Report

Focus POS Corp

Average Store Sales Rank for 3/1/200x-3/31/200x at 10/24/200x 1:19:12 AM Page 1

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

01 | 81221.88 | 3104.82 | 3.97 | 25.99 | 1 |

02 | 77382.89 | -734.17 | -0.94 | 24.76 | 3 |

03 | 74308.67 | -3808.39 | -4.88 | 23.78 | 4 |

04 | 79554.81 | 1437.75 | 1.84 | 25.46 | 2 |

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

Totals | 78117.06 | | | | |

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

Figure 3.4.12 Sample Average Store Sales Ranking 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.

$ Amount off Average

Column 3

Calculates the dollar difference between the individual store Net Sales and the corporate average.

% Amount off Average

Column 4

Calculates the percentage difference between the individual store Net Sales and the corporate average.

% Amount of Corp Sales

Column 5

The individual store’s percentage of corporate Net Sales.

Store Sales Rank

Column 6

The rank of the individual store based on Net Sales.

Totals

Net Sales

Column 2

The average Net Sales for all restaurants.

Report Setup - Column 1 (Store ID)

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

Report Setup - Column 2 (Net Sales)

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

Report Setup - Column 3 ($ Amount off Average)

Field

Setup Information

Heading 1

$ Amount

Heading 2

off Average

Size

Sort

<None>

Format

Currency

Display

Yes

Filtered

Yes

Filter Options

Field	Option
Totals Stop Column	2

Expression

“Column2” – “ColumnTotal2”

Constant

n/a

Report Setup - Column 4 (% Amount off Average)

Field

Setup Information

Heading 1

% Amount

Heading 2

off Average

Size

Sort

<None>

Format

% (Average Breaks)

Display

Yes

Filtered

Yes

Filter Options

Field	Option
Totals Stop Column	2

Expression

“Column2” / “ColumnTotal2” – 1

Constant

1.00

Report Setup - Column 5 (% Amount Calc) Note: This column is used for calculation purposes and not displayed.

Field	Setup Information
Heading 1	% Amount
Heading 2	Calc
Size	15
Sort	<None>
Format	Currency
Display	No
Filtered	No
Expression	“Net Sales”
Constant	n/a

Report Setup - Column 6 (Percentage of Corp Sales)

Field

Setup Information

Heading 1

Percentage of

Heading 2

Corp Sales

Size

Sort

<None>

Format

% (Average Breaks)

Display

Yes

Filtered

Yes

Filter Options

Field	Option
Totals Stop Column	2

Expression

“Column5” / “ColumnTotal5”

Constant

n/a

Report Setup - Column 7 (Store Sales Rank)

Field

Setup Information

Heading 1

Store Sales

Heading 2

Rank

Size

Sort

<None>

Format

Integer

Display

Yes

Filtered

Yes

Filter Options

Field	Option
Totals Stop Column	2

Expression

“RankTotal2”

Constant

n/a

Report Format Options

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

Related Topics (none)