Decision Logic’s Production Sheet tool gives stores the ability to accurately predict the quantity of prepped items to prepare on a day-to-day basis. This provides a greater ability to plan and control the production of your food products so that the correct amount gets prepared.
Decision Logic uses historical menu mix data coupled with historical ingredient usage to predict your typical daily usage.
This information, along with your current on-hand inventory, allows Decision Logic to make a well-informed decision on how much you will need to prep on a given day.
With the Production Sheet, you can ensure the production of the proper quantity of product is prepped to minimize waste and food cost and to maximize sales opportunities.
Table of Contents
For additional questions or assistance please submit a support ticket by visiting the Decision Logic Help Center.
Daily menu mix data for the last six weeks plus or minus two standard deviations are utilized to determine the amount of product a store should prep to get them to the next scheduled prep day. The prediction is based on usage, derived by an average number of actual sales per day of the week for a menu item. The configured minimum and maximum values for each item serve as the Par for that item.
How much pico de gallo should be prepared for today, Monday? We want to prep this as infrequently as possible, and it has a shelf life of three days.
Production Sheet Calculation Examples
Example Scenario #1
Avg last 6 weeks from 3-19 (last Mon) (ignoring outliers) +
Example Scenario #2If you have a 3.5 days Max Prepped Amount on 3/26/18 (Monday) the math used to calculate the build to amount is:
Note, there is a removal of +/- 2 Standard Deviations will be referred to as "ignoring outliers. Outliners are any # outside on the normal range.
For instructions on how to set up your Production Sheets, see Production Sheet Maintenance & Setup
For Store Setup instructions, see Production Sheet Store Setup
For the store-side, see Production Sheet Entry & Predicted Prep
The Production Sheet features a weekly view of predicted prep. See, Production Sheet Weekly View