Target Cost Variance Report

Overview:

The Target Cost Variance Report enables you to isolate the impact that ingredient cost changes for your Sales Item recipes are having on your targeted profits, over a specified date range. This report provides an easy way to evaluate if due to changes in your ingredient costs and if the pricing for your Sales Items is in line with your cost of sales and profit targets. An example of the report is below:

Things to know!

• This report will only be accessible and visible to users who are given access to this report function. 
• The Target Cost Variance report enables you to isolate the impact that ingredient cost changes for your Sales Item recipes are having on your targeted profits, over a specified date range. 
• The Target Cost Variance report can be run for any desired Site, date range, Department, Category, Group, or all Sales Items.
• This report provides an easy way to evaluate if due to changes in your ingredient costs, the pricing for your Sales Items stays in line with your cost of sales and profit targets.  

Report Parameters

To Run a Target Cost Variance report, use the Sidebar to navigate to the Menu Analytics Report menu option and then select it 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.

Recipe Item Group: If you want to run the report for a specific Recipe Group (an example might be Sandwiches), you can use the drop-down to select your desired  Group. 

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.

Target Cost Variance Report:

Selecting to Run the Report will display a report similar to below:  

Target Cost Variance Report: This report enables you to isolate the impact that ingredient cost changes for your Sales Item recipes are having on your targeted profits, over a specified date range. For example, in the report above, the cost of a 3 oz Ham item that had an average price of $2.25 should be $.68 to hit its Target Cost % of 30%. Its actual theoretical cost is $.75 so its cost is $.07 ($.074 to be exact) over the Target Cost.  

Report Options: For a description of the toolbar provided at the top of the report, please see "Report Options" for help. Report Options link.