Are you tired of constantly monitoring the prices of various inputs and wrangling spreadsheets just to track the unit cost of your finished goods?
Look no further than the DecisionNext Finished Goods Index Report. This monthly report features index-style reporting for three common menu items: hamburger, white bread loaf, and hot dog.
The underlying value of these indices lies in the consolidation of multiple raw material forecasts which provide insights into cost projections for the finished goods. All from a single screen, users can seamlessly combine multiple raw material cost forecasts from different commodity groups. These finished goods templates can be saved and used to easily transform forecasts into the quantities required for any recipe.
Figure 1 – Finished goods forecast indices for the month of May.
How the Indices (fig 1) are Calculated:
The index number for each finished good is calculated by taking the forecasted aggregate price for the inputs in May of 2023 and dividing it by the historical aggregate price for those same inputs in May of 2022. Essentially, we are using the tool to forecast the finished goods cost in a future month and make the YoY comparison to the cost from the previous year.
Our forecast indices are based on a ¼ lb hamburger in a 2 oz bun, a standard 16 oz loaf of white bread, and a 1.6 oz hotdog in a 2 oz bun. We expect to add more indices over the coming months.
Hamburger Deep Dive:
For this report we have chosen to showcase the cost of a single hamburger (fig. 2).
At time of publishing (April ‘23) the cost of aggregated inputs of a ¼ lb hamburger and a 2 oz. bun is forecasted to be $0.74 in May 2023 vs. $0.79 in May 2022, down $0.05 YoY resulting in an index value of 94.
Figure 2 – Recipe for a ¼ lb hamburger and 2oz bun loaded into a DecisionNext transaction. Note that this transaction is hypothetical.
This DecisionNext platform offers the ability to collect forecasts and fixed costs for each input for a given recipe into a fully customizable view. In our example (fig. 2) we see the recipe for a generic ¼ lb hamburger and 2 oz bun. This view combines each input variable into a finished goods forecast for the hamburger. The value for each line item (with the exception of water) is pulled in from its own forecast model.
We are forecasting the cost of hamburger inputs in May 2023 to be $0.74, down from $0.79 in May of last year. This change has primarily been driven by the decrease in the cost of ground beef.
Overall, the DecisionNext Finished Goods Index Report showcases the flexibility of our tool’s range of solutions. It offers multi-commodity forecasting consolidated into a single finished goods forecast, the ability to choose the timeframe for the forecast, and the option to customize recipe templates to optimize finished goods profitability.
Every month an updated set of The Finished Goods indices will be featured in The Formula. Readers can then start to track the trends over time. Additionally, each month we will do a deep dive into a selected finished good.