- 06 Nov 2024
- 3 Minutes to read
- Print
- DarkLight
- PDF
Weekly Review - Location
- Updated on 06 Nov 2024
- 3 Minutes to read
- Print
- DarkLight
- PDF
The Weekly Review - Location Report shows a detailed look into one Location’s weekly sales. This is broken down by Day Part; Service Type; Account; Net Sales vs the year before last/Last Year, Last Month, and Last Week; Guest Counts and Average Check; Cost Analysis (purchases by cost account); Key Controllable Expenses; and Labor. Percentages can be turned on with the ‘+’ sign at the top of the report to see how each number is broken down by a percent vs sales.
This can help individual unit Managers keep a pulse on the current week and review the previous week. All Vital Signs for the business are included in this report and can be a very quick way to see the snapshot needed to make business decisions throughout the week.
The Discounts and Comps full list can be viewed by clicking the ‘+’ sign next to Discounts and Comps.
Navigation
To navigate to the Weekly Review - Location Report, click 'My Reports' under 'Reports' in the left pane and then select 'Op. Analysis' in the top header of the reporting window. Once opened, a listing of reports will be shown.
Find 'Weekly Review - Location' and select 'Customize' next to the report. This will open up a listing of all Report Parameters that can be used to define your report.
Report Parameters
Field | Description | |
---|---|---|
1 | Location | A listing of all the Locations. |
2 | Week | The specified week that this report is ran for. |
3 | Show Unapproved | This option will either show or hide unapproved transactions. |
4 | YoY (Year over year) Comparison | This option will compare the current week's values against the same week from either:
|
5 | Report Format | Collapsed - Does not include percentages of sales. Expanded - Adds a column after each day to display each components percentage of net sales in their prospective category. |
6 | View Options | This section provides options to select, save, edit, or delete a report view. |
7 | Run | Generates the report. Click the down arrow to the right of the Run button to export, email, or print the report. |
Report Fields
Report Field | Description | |
---|---|---|
1 | Click +/ - for % | Expands or collapses the report.
|
2 | Week Days | The days of the selected week in the report parameters laid out in separate columns to allow a deeper look into each day's numbers. |
3 | Week Total | The total of all week days' numbers. |
4 | Last Week | The Week Total from the previous week. |
5 | PTD | The Period to Date total. |
6 | YTD | The Year to Date total. |
7 | Net Sales Analysis | Breaks down Net Sales and Cost by analyzing Net Sales by Day Part, Service Type, and Account. |
8 | Net Sales Comparison | Compares Net Sales to Target Net Sales, Prior Year Sales, and Week to Date Sales. Target Net Sales: The Daily Sales Goals set on the 'Goals' tab of the Location record. This allows forecasts and goals to be built separately from the Sales Forecast. Week to Date Target Net Sales: The sum of each week-to date Target Net Sales. |
9 | Guest Analysis | Compares guest count by day part to the target guest count, displays average sales per check by day part, and shows the overall average sales per check. Target Guest Count: This is calculated by taking the Sales Goal and dividing it by the Daily Target Avg Check. Average Sales per Check: This is calculated by dividing total sales by the number of checks. |
10 | W/E | The report displays the four most recent week-end dates, starting with the date selected in the report parameters and including the three prior week-ends. These dates are specifically used in the Cost Analysis section, allowing comparison across weeks to assess the progress of a location.
|
11 | Cost Analysis | Breaks down Costs by COGS Type, COGS Type Purchases, Key Controllables and Labor.
COGS - This value includes any and all transactions that are hitting a particular COGS amount. COGS Purchases - This value only pulls the COGS effect on AP Invoices (purchases) and does not factor in other transactions, such as In Counts or Item Transfers. Key Controllables - A list of Key Controllables and their values. Labor - Displays labor values by operational reporting category. |
Email, Export, or Print the Report
This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.