Spreadsheet: 727823d1618137530-building-a-truck-even-pallet-quantities-pallet-builder_mod1
Sheet: Example_2

Truck # | Item # | Lot # | Description |  | QTY (Cases) | Cases per Pallet | # of Pallets |  | Truck 1 | Truck 2 | Truck 3 | Truck 4 | Truck 5 | Truck 6 | Truck 7 | Truck 8 | Truck 9 | Truck 10 | Truck 11 | Truck 12
1 | 4563 | 1065A | 24 ct Vanilla |  | 2760 | 120 | 23 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | = | 1
2 | 4563 | 1065A | 24 ct Vanilla |  | 1440 | 120 | 12 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
2 | 4563 | 1065P | 24 ct Vanilla |  | 1320 | 120 | 11 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
3 | 4563 | 1065P | 24 ct Vanilla |  | 2760 | 120 | 23 |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | 4563 | 1065P | 24 ct Vanilla |  | 2760 | 120 | 23 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
5 | 4563 | 1065P | 24 ct Vanilla |  | 2760 | 120 | 23 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
6 | 4563 | 1065P | 24 ct Vanilla |  | 2760 | 120 | 23 |  | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 | 8974 | 1068P | 24 ct Chocolate |  | 360 | 120 | 3 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
7 | 8974 | 1068P | 24 ct Chocolate |  | 2400 | 120 | 20 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 | 8974 | 1068P | 24 ct Chocolate |  | 2760 | 120 | 23 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
9 | 8974 | 1068P | 24 ct Chocolate |  | 1200 | 120 | 10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
9 | 8974 | 1068P | 24 ct Chocolate |  | 1560 | 120 | 13 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
10 | 8974 | 1068P | 24 ct Chocolate |  | 840 | 120 | 7 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
10 | 8974 | 1068P | 24 ct Chocolate |  | 1920 | 120 | 16 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
11 | 8974 | 1068P | 24 ct Chocolate |  | 1200 | 120 | 10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
11 | 8974 | 1068P | 24 ct Chocolate |  | 1560 | 120 | 13 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
12 | 8974 | 1068P | 24 ct Chocolate |  | 2400 | 120 | 20 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
12 | 8974 | 1068P | 24 ct Chocolate |  | 360 | 120 | 3 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
13 | 4563 | 1065P | 24 ct Vanilla |  | 111 | 120 | 0.925 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
13 | 4563 | 1065P | 24 ct Vanilla |  | 40 | 120 | 0.3333333333333333 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 | 8974 | 1068P | 24 ct Chocolate |  | 105 | 120 | 0.875 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
13 | 8974 | 1068P | 25 ct Chocolate |  | 307 | 120 | 2.558333333333333 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 | 8974 | 1068P | 26 ct Chocolate |  | 47 | 120 | 0.3916666666666667 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 | 8974 | 1068P | 27 ct Chocolate |  | 31 | 120 | 0.2583333333333334 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
13 | 8974 | 1068P | 28 ct Chocolate |  | 88 | 120 | 0.7333333333333333 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 | 8974 | 1068P | 29 ct Chocolate |  | 62 | 120 | 0.5166666666666667 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
13 | 8974 | 1068P | 30 ct Chocolate |  | 852 | 120 | 7.1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
 |  |  |  |  |  |  |  |  | <= | <= | <= | <= | <= | <= | <= | <= | <= | <= | <= | <=
 |  |  |  |  |  |  |  |  | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26
 |  |  |  |  |  |  |  |  | => | => | => | => | => | => | => | => | => | => | => | =>
 |  |  |  |  |  |  |  |  | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23