Average Store Sales Ranking by Group Report   

Purpose

The Sample Average Store Sales Ranking by Group Report, shown below, is designed to display the Store ID, Group, Net Sales, Dollar amount off Group Average, % off Group Average, Dollar amount off Corporate Average, % of Corporate Sales and the Store Sales Rank within the Group.

 

 Figure 3.4.19 Sample Average Store Sales Ranking by Group Report

Focus POS Corp

                                    Average Store Sales (Grp) for 3/1/2007-3/31/200x at 10/24/200x 1:20:01 AM Page 1

 

  Rest  |  Store ID  |  Net Sales |      $ off      |      % off      |      $ off      |      % off      |  Store Sales |

 Group  |            |            |  Group Average  |  Group Average  |   Corp Average  |   Corp Average  |   Group Rank |

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

  North |        01  |   81221.88 |         1919.50 |            2.42 |         3104.82 |            3.82 |            1 |

        |        03  |   77382.89 |        -1919.50 |           -2.42 |         -734.17 |           -0.95 |            2 |

 Totals |            |   79302.38 |                 |                 |                 |                 |              |

        |            |            |                 |                 |                 |                 |              |

  South |        02  |   74308.67 |        -2623.07 |           -3.41 |        -3808.39 |           -5.13 |            2 |

        |        04  |   79554.81 |         2623.07 |            3.41 |         1437.75 |            1.81 |            1 |

 Totals |            |   76931.74 |                 |                 |                 |                 |              |

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

 Totals |            |   78117.06 |                 |                 |                 |                 |              |

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

 

Figure 3.4.20 Sample Average Store Sales Ranking by Group Report Fields

Field

Description

Rest Group
Column 1
 
Displays the Group established in Setup > Restaurants > Groups. Note: This Column uses the “Totals on Break” option in the Filter to display Totals by Group.

Store ID
Column 2
 
Displays the Restaurant ID established in Setup > Restaurants > ID.

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

$  off Group Average
Column 4
 
Calculates the dollar difference between the individual store Net Sales and the Group average.

% off Group Average
Column 5
 
Calculates the percentage difference between the individual store Net Sales and the Group average.

$ off Corp Average
Column 6
 
Calculates the dollar difference between the individual store Net Sales and the corporate average.

% off Corp Average
Column 7
 
Calculates the percentage difference between the individual store Net Sales and the corporate average.

Store Sales Group Rank
Column 8
 
Ranks the Net Sales of the restaurant to other restaurants in the Group.

Totals (Break Totals)

Net Sales
Column 3
 
Displays the average Net Sales amount for all restaurants in the Group.

Total (Grand Totals)

Net Sales
Column 3
 
Displays the corporate average Net Sales amount.

 

Report Setup - Column 1 (Rest Group)

Field

Setup Information

Heading 1

Rest

Heading 2

Group

Size

10

Sort

Ascending

Format

Text

Display

Yes

Filtered

Yes

 

Filter Options

Field

Option

Totals on Break

Totals on Break

Expression

“REST-GROUP”

Constant

n/a

 

Report Setup - Column 2 (Store ID)

Field

Setup Information

Heading 1

Store

Heading 2

ID

Size

5

Sort

Ascending

Format

Text

Display

Yes

Filtered

No

Expression

“REST-ID”

Constant

n/a

 

Report Setup - Column 3 (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 4 ($ off Group Average)

Field

Setup Information

Heading 1

$ off

Heading 2

Group Average

Size

15

Sort

<None>

Format

Currency

Display

Yes

Filtered

Yes

 

Filter Options

Field

Option

Totals Stop Column

2

Expression

“Column3” – “ColumnGroupTotal3”

Constant

n/a

 

Report Setup - Column 5 (% off Group Average)

Field

Setup Information

Heading 1

% off

Heading 2

Group Average

Size

15

Sort

<None>

Format

% (Average Breaks)

Display

Yes

Filtered

Yes

Field

Option

Totals Stop Column

2

Expression

“Column3” / “ColumnGroupTotal3” - 1

Constant

n/a

 

Report Setup - Column 6 ($ off Corp Average)

Field

Setup Information

Heading 1

$ off

Heading 2

Corp Average

Size

15

Sort

<None>

Format

Currency

Display

Yes

Filtered

Yes

Field

Option

Totals Stop Column

2

Expression

“Column3” - “ColumnTotal3”

Constant

n/a

 

Report Setup - Column 7 (% off Corporate Average)

Field

Setup Information

Heading 1

% off

Heading 2

Corporate Average

Size

15

Sort

<None>

Format

% (Average Breaks)

Display

Yes

Filtered

Yes

Field

Option

Totals Stop Column

2

Expression

“Column3” / “ColumnTotal3” - 1

Constant

n/a

 

Report Setup - Column 8 (Store Sales Group Rank)

Field

Setup Information

Heading 1

Store Sales

Heading 2

Group Rank

Size

11

Sort

<None>

Format

Integer

Display

Yes

Filtered

Yes

Field

Option

Totals Stop Column

2

Expression

“RankGroupTotal3”

Constant

n/a

 

Report Format Options

Field

Option

File Format

Text

Totals by Date

Not Selected

Type

None

 

Related Topics (none)

 

 
 
Copyright © 2007 Focus POS Systems