Discount Percentage Report

Purpose

The Sample Discount Percentage Report, shown below, is designed to display the Store ID, Net Sales, individual Discounts, Total Discounts $, Discount Percentage, Net Sales Rank and Disc % Rank.

Figure 3.4.21 Sample Discount Percentage Report

Focus POS Corp

Discount Percentage Report for 3/1/200X-3/31/200X at 11/28/200X 11:02:52 AM Page 1

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

01 | 76204.46 | 24.51 | 66.31 | 111.53 | 2.49 | 204.84 | 0.27 | 3 | 3 |

02 | 74308.67 | 116.84 | 29.99 | 273.29 | 0.00 | 420.12 | 0.57 | 4 | 1 |

03 | 77382.89 | 61.69 | 61.12 | 229.69 | 0.00 | 352.50 | 0.46 | 2 | 2 |

04 | 79554.81 | 75.20 | 56.12 | 74.00 | 0.00 | 205.32 | 0.26 | 1 | 4 |

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

Totals | 76862.71 | 69.56 | 53.38 | 172.13 | 0.62 | 295.70 | 0.39 | | |

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

Figure 3.4.22 Sample Discount Percentage 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.

Open Discount

Column 3

Displays the Open Discount amount for the restaurant for the selected date range.

Employee Meal

Column 4

Displays the Employee Discount amount for the restaurant for the selected date range.

Manager Meal

Column 5

Displays the Manager Meal Discount amount for the restaurant for the selected date range.

Senior Discount

Column 6

Displays the Senior Discount amount for the restaurant for the selected date range.

Total Discount $

Column 7

Displays the Total Discount amount for the restaurant for the selected date range.

Discount Percentage

Column 8

Calculates the Total Discount to Net Sales Amount for the selected date range.

Net Sales Rank

Column 9

Ranks the Net Sales of the restaurant to all restaurants.

Disc % Rank

Column 10

Ranks the Discount Percentage of the restaurant to all restaurants.

Total

Net Sales	Column 2 Displays the corporate average Net Sales amount.
Open Discount	Column 3 Displays the corporate average Open Discount amount.
Employee Meal	Column 4 Displays the corporate average Employee Meal Discount amount.
Manager Meal	Column 5 Displays the corporate average Manager Meal Discount amount.
Senior Discount	Column 6 Displays the corporate average Senior Discount amount.
Total Discount $	Column 7 Displays the corporate average Total Discount amount.
Discount Percentage	Column 8 Displays the Total Discounts to Net Sales corporate average.

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 (Open Discount)

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

Report Setup - Column 4 (Employee Meal)

Field	Setup Information
Heading 1	Employee
Heading 2	Meal
Size	10
Sort	<None>
Format	Currency (Avg. Total)
Display	Yes
Filtered	No
Expression	"DISC$3:Crew 50%"
Constant	n/a

Report Setup - Column 5 (Manager Meal)

Field	Setup Information
Heading 1	Manager
Heading 2	Meal
Size	10
Sort	<None>
Format	Currency (Avg. Total)
Display	Yes
Filtered	No
Expression	"DISC$4:Manager's Meals"
Constant	n/a

Report Setup - Column 6 (Senior Discount)

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

Report Setup - Column 7 (Total Discount $)

Field	Setup Information
Heading 1	Total
Heading 2	Discount $
Size	10
Sort	<None>
Format	Currency (Avg. Total)
Display	Yes
Filtered	No
Expression	"Column3" + "Column4" + "Column5" + "Column6"
Constant	n/a

Report Setup - Column 8 (Discount Percentage)

Field	Setup Information
Heading 1	Discount
Heading 2	Percentage
Size	10
Sort	<None>
Format	Currency (Avg. Breaks)
Display	Yes
Filtered	No
Expression	“Column7" / "Column2" * 100.00
Constant	100

Report Setup - Column 9 (Net Sales Rank)

Field	Setup Information
Heading 1	Net
Heading 2	Sales Rank
Size	10
Sort	<None>
Format	Integer
Display	Yes
Filtered	No
Expression	"RankTotal2"
Constant	n/a

Report Setup - Column 10 (Disc % Rank)

Field	Setup Information
Heading 1	Disc %
Heading 2	Rank
Size	10
Sort	<None>
Format	Integer
Display	Yes
Filtered	No
Expression	“RankTotal8”
Constant	n/a

Report Format Options

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

Related Topics (none)