=== Adding Delivery-Ready Columns ===

Step 1: Adding delivery_quantity column (rounded UP values)...
Column already exists, skipping...

Step 2: Calculating delivery quantities (rounding UP)...

Rounding Statistics:
  Total Plans: 26504
  Sum Planned (precise): 1,617,725.78 units
  Sum Delivery (rounded): 1,630,953 units
  Total Overage: 13,227.22 units
  Average Overage: 0.50 units per plan

Step 3: Creating delivery_view for field staff...
View created successfully

Step 4: Sample delivery data:

School | Commodity | Planned | Delivery | Overage
--------------------------------------------------------------------------------
SCH-0001        | Rice            |   277.17 |      278 | +0.83 kg
SCH-0001        | Maize           |   123.34 |      124 | +0.66 kg
SCH-0001        | Gari            |    24.95 |       25 | +0.06 kg
SCH-0001        | Beans           |    38.80 |       39 | +0.20 kg
SCH-0001        | Peanut          |    11.09 |       12 | +0.91 kg
SCH-0001        | Millet          |    22.27 |       23 | +0.73 kg
SCH-0001        | Vegetable Oil   |   115.03 |      116 | +0.97 litres
SCH-0001        | Palm Oil        |    34.65 |       35 | +0.35 litres
SCH-0001        | Margarine       |    65.51 |       66 | +0.49 kg
SCH-0001        | Tinned Tomatoes |   191.25 |      192 | +0.75 tins

=== Process completed successfully! ===

Now field staff will see whole numbers for delivery.
Example: Instead of '157.02 kg', they see '158 kg'