Ready to calculate
Enter the counts from the cooler and catering sheet, then calculate the order.
Inputs changed. Calculate order to update this result.
Recommended order
Order 3 cases
Covers a 29-unit shortage after full-case rounding.
Check the catering piece count before ordering. This is a large catering reserve.
7
extra units after order
Sales coverage target
45
Inventory plus this order should cover sales until the following truck.
Catering conversion
5
35 pieces rounded up to 5 units.
Total need
50
Retail units plus catering units.
Inventory
16
1 case x 12 plus 4 loose units.
Shortage before ordering
34
Shortage is rounded up to full cases for ordering.
Math
- Sales coverage target: Friday truck order cycle = 61 8-piece units.
- Catering reserve: 35 pieces / 8 = 5 rounded-up units.
- Inventory: (1 cases x 12) + 4 loose units = 16 units.
- Cases to order: max(0, 50 - 16) / 12 = 3 full cases.
Units per case: 12
Pieces per unit: 8
Sales coverage target: 61 units