Milk Totals — one sheet for the milk run
Where it is. A tab called Milk Totals, across the top beside Packing Reports and Vendor Orders.
What it is for. Loading a milk run off individual order slips means counting the same jugs several times over. This is one page: milk types down the side, pickup stops across the top, and the number that goes to each.
Setting it up takes one field. Open it and it is already set the way you will want it almost every time — open orders, every stop ticked. Type the pickup date, press Show these, press Print this sheet.
The other filters. You can tick Completed as well if you are looking back at a week already done, and you can untick stops if you only want part of the run. Ticking every stop and ticking none come to the same thing.
Multi-packs are counted as what they are. A four gallon bundle is four gallons on this sheet, not one bundle, because four gallons is what somebody has to lift onto the truck.
Anything unusual keeps its own line. The sheet has a line for plain gallons and one for plain half gallons. Chocolate milk, kefir, sheep milk, anything in glass — these each get a line of their own rather than being added into the plain ones. It would be tidier to fold them in and it would also be wrong: the driver would load white jugs and come back short.
The same goes for a milk you have only just added. If the sheet does not recognise it, it appears under its own name at the bottom rather than quietly vanishing. A new line you were not expecting means something needs a look; a missing jug on the truck means somebody goes without.
It prints in black and white. The colours beside each stop are there to help you on screen. On paper the sheet goes plain black on white, which is the clearest a workshop printer will give you.
Picking a date makes it fast. Without one the sheet adds up the last sixty days. With one it looks at that day only, which is both the answer you wanted and the quickest this page ever loads.