Table of Contents
Entering Output Grand Totals
- Navigate to the Output Grand Totals worksheet.
- Configure slicers to the appropriate context. In this case, we are making products in the Shape phase at PHQ (location) on TUE (day of the week).
- Enter the numbers recorded for Grand Total Actual on the printed output worksheet (as referenced in the beginning of this article).
Product that needs to be distributed
If you are on a phase that does not require distribution to other location, you can skip the following steps.
Understanding the Consequences of Pre-Sorting
This is a filled example of a shape output sheet for pastry production. It is the standard way of recording shaped product that is distributed across several locations.
- Pastry production is variable by nature, so notice the discrepancies that exist between the values in the Grand Total Actual column and the total of LFP Actual, PHQ Actual, and PSH Actual columns.
- The default mode is to pre-sort product (sorting product by the par before the grand total is established) as they are created to make efficient use of space, causing the distribution to be uneven when considering proportions of pars.
We need to figure out how to reconcile the discrepancy between pre-sorted numbers and ideal sorting numbers according to the Grand Total Actual production.
Entering Output by Transfer Location
- Navigate to the Output by Transfer Location worksheet.
- Configure slicers to the appropriate context. In this case, we are making products in the Shape phase at PHQ (location) on TUE (day of the week).
- Enter the numbers that were pre-sorted for each transfer location from the output worksheet. In this case, we enter the values from LFP Actual, PHQ Actual, and PSH Actual.
- Reference the Discrepancy Reconciliation column. This will tell you how much product to add or subtract from each location's pre-sorted quantity.
- No further steps for manual entry are necessary under normal circumstances.
⚠️ Discrepancies within Discrepancies
The sum of the products being moved around should be zero, but it doesn't always work out so cleanly in reality.
Discrepancy Reconciliation may be off by one or two, because these values are rounded to the nearest integer because they were calculated from percentages. Unfortunately, resolving this is not possible without a more complicated algorithm.
To better understand this, let us refer to the records for Pain au Chocolat using our example above:
If we remove 1 product from LFP and remove 1 product from PHQ, we only have 2 products in total to give to PSH, not 3.
Use your best judgment to decide what to do with these differences. In this case, the simplest solution is to give PSH only 2 additional product.