Item Cost Trend Chart
Overview:
The Item Cost Trend Chart lets you view the cost trend for an inventory item, combined item, or recipe item (sold or not sold), over a selected period. For recipe items, the cost trend for each ingredient is included. An example of the chart 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 Item Cost Trend Chart lets you view the cost trend for an inventory item, combined item, or recipe item (sold or not sold), over a selected period.
- For recipe items, the cost trend for each ingredient is included.
- The number of days to include in the trend can be selected (60 days is the default).
- This chart can take time to calculate - especially for recipe items if you include many days to look back.
Item Cost Trend Parameters:
To display an Item Cost Trend Chart, navigate to Recipes & Sales>Reports>Item Cost Trend Chart. Upon selection, a screen like the one below will display:
Select Item: Use the search function to find the inventory or recipe item you wish to run the trend for. Inventory items will have the vendor's name in parentheses. Recipe items will have the term "recipe item" in parentheses.
Item Cost Trend Chart - Recipe Item:
After selecting a Recipe Item, a chart similar to the one below will display:
Select Another Item: Use this button to select a new Item to chart.
Number of Days: Use the drop-down to select a different number of days to look back. 60 days is the default.
Theoretical Cost (Vertical Axis): This is the theoretical recipe cost, based on its ingredient costs and portion sizes.
Time (Horizontal Axis): This is the earliest date (based on the number of days selected) on the left through the current date on the right.
Total Cost: This is the blue line in the graph and it represents the total theoretical cost for this burger. In the above example, the theoretical cost of this burger has gone from under $2.50 to over $2.50, for the 60 days displayed.
Other Colors: Each color in the bars of this chart represents the cost amount and the cost trend for a recipe ingredient in this burger. There will be a color code guide listing the color for each ingredient on the right of the chart. In the above example, you can see that the biggest portion of this burger's cost is coming from 3-1 Round Beef Patty ((approximately $1.15). Also using the above example, the cost for the 3-1 Round Beef Patty has been very stable while the cost of the 12/14 Daily Bacon has been more variable over the last 60 days.
Cost Source and Date: You can hover over a bar for a date, and over the color of an ingredient, and the chart will display the source and cost for the ingredient at that date.
Ingredient Sort on Cost Change: The chart sorts and lists the ingredients so that the ingredient with the most steady cost is displayed at the bottom and the ingredient with the most variation in cost at the top.
Ingredient Cost Detail: You can click on one of the bars, and in the color zone of a specific ingredient, and the chart will display the cost for a specific ingredient (Inventory or Recipe Item) over the same date range. In the below example, 12/14 Daily Bacon was selected:
Item Cost Trend Chart - Inventory Item:
You can also select an Inventory Item to view the Item Cost Trend Chart. After selecting an Inventory Item, a chart similar to the one below will display:
In the example above we have selected the 12/14 Daily Bacon Inventory Item. The Purchase Unit name is displayed after the Item so you will know what the cost trend represents.