Theoretical Profit from Sales Report
Overview:
The Theoretical Profit from Sales Report enables you to determine what your total theoretical profit from sales should be, and what amount of that profit is coming from each Sales Item, based on the quantity sold and the cost for each Sales Item. An example of the report is shown below:
Things to know!
- This report will only be accessible and visible to users who are given access to this report function.
- The Theoretical Profit from Sales report enables you to determine what your total theoretical profit from sales should be, and what amount of that profit is coming from each Sales Item, based on the quantity sold and the cost for each Sales Item
- The Theoretical Profit from Sales report can be run for any desired Site, date range, Department, Category, or all Sales Items.
Report Parameters
To run a Theoretical Profit from Sales report, use the Sidebar to navigate to the Menu Analytics menu option and select the Theoretical Profit from Sales Report from the submenu. Upon selection, a report parameters screen like the one below will display:
Site: This filter only displays if you are logged into your company (versus a specific Site). The drop-down enables a search and selection of your desired Site.
Begin Date: From the drop-down calendar, select a starting date range.
End Date: From the drop-down calendar, select an ending date range.
Recipe Department: If you want to run the report for a specific Recipe Department (an example might be the Food Department), you can use the drop-down to select your desired Department.
Recipe Category: If you want to run the report for a specific Category (an example might be Draft Beer), you can use the drop-down to select your desired Category.
Theoretical Cost Method: Use the drop-down to indicate if you want to utilize the Effective Cost or Weighted Average cost for the report. Please click this link for an article about the Costing Methods - FAQs.
Run Report: Once you have selected your report parameters, click the Run Report button to list the report.
Theoretical Profit from Sales Report - Detail:
Selecting to Run the Report will display a report similar to below:
The Theoretical Profit from Sales Report enables you to determine what your total theoretical profit from sales should be, and what amount of that theoretical profit is coming from each Sales Item, based on the quantity sold and the cost for each Sales Item. For example, in the report example above, based on its sales count, the Breakfast Burrito Sales Item is contributing $3,147.50 to sales revenue and $2,531.22 to theoretical profits. Its profit as a percentage of the total Food Department sales is 9.95% and it is 9.16% of all Department sales (total sales). The Breakfast Entrees Category is generating 22.08% of the total Food Department's theoretical profits.
Report Options: For a description of the toolbar provided at the top of the report, please see "Report Options" for help. Report Options link.
When you see this button it means a sort option is available to display the transactions in ascending or descending order (from lowest to highest or highest to lowest). Click on the button to invoke the sort option. Click once for lowest to highest. Click again to reverse the sort to be for highest to lowest.
Theoretical Profit from Sales Report - Summary:
Selecting to Run the Report will display a report similar to below:
In the above Theoretical Profit from Sales Summary, Sales and Theoretical profit from sales are reported for each Sales Category (an example is Breakfast Entrees), each Sales Department (an example is Food), and for total Sales. Each Sales Item Category profit is shown as a % of its Sales Item Department and as a % of total sales.