Spreadsheet: 864381d1711569364-grouping-2024-shipments-test
Sheet: Feb 2024

Job Number | Customer | Ship To State | Sell Price | Contract (Due) Date | Ready to Ship Date | [NAME] to Ship On Time | Invoice Request Date | LABOR BUDGET $ | TOTAL LABOR $ | LABOR VARIANCE | MATERIAL BUDGET $ | TOTAL MATERIAL $ | MATERIAL [NAME] | TOTAL COST BUDGET | TOTAL ACTUAL COST | [NAME] | ON BUDGET | "As Sold" Budget Margin % | "As Completed" Margin | Difference between Budget / Completed | FREIGHT REIM | Completed Margin     (+Gain / -Loss) | As Sold Margin | Margin (+/-) As Sold Margin
24-4094 | [NAME] |  | 8330 | 2024-02-28 00:00:00 | 2024-02-07 00:00:00 |  | 2024-02-07 00:00:00 | 4031.5 | 4672.24 |  | 1479
23-4081 | Bachmann- Meraki Dewa |  | 61475 | 2024-01-05 00:00:00 | 2024-02-07 00:00:00 |  | 2024-02-09 00:00:00 | 20020 | 21225.41 |  | 14500 | 14073.12
24-4106 | Bachmann- Columbia |  | 1025 | 2024-02-01 00:00:00 | 2024-02-07 00:00:00 |  | 2024-02-08 00:00:00 | 481.25 | 386.83
24-4112 | Technos |  | 680 | 2024-02-26 00:00:00 | 2024-02-06 00:00:00 |  | 2024-02-06 00:00:00 | 121 | 66.92 |  | 255 | 240.43
24-4107 | Bachmann - Vogt Guyana |  | 1800 | 2024-03-07 00:00:00 | 2024-02-05 00:00:00 |  | 2024-02-05 00:00:00 | 440 | 378.58 |  | 560 | 309.32
24-4113 | Bachmann - Mexico |  | 900 | 2024-02-10 00:00:00 | 2024-02-02 00:00:00 |  | 2024-02-05 00:00:00 | 352 |  |  | 153.4 | 154.66
24-4101 | Bachmann - UAE |  | 480 | 2024-01-31 00:00:00 | 2024-01-31 00:00:00 |  | 2024-02-01 00:00:00 |  |  |  | 145 | 235
24-4093 | St. Mary's Cement |  | 1315 | 2024-03-01 00:00:00 | 2024-02-11 00:00:00 |  | 2024-02-14 00:00:00 |  |  |  | 876 | 859.49
24-4118 | Black Mountain Sand |  | 5200 | 2024-02-29 00:00:00 | 2024-02-22 00:00:00 |  | 2024-02-22 00:00:00 |  |  |  | 3372 | 3208.5
24-4115 | Power Systems |  | 3808.8 | 2024-03-04 00:00:00 | 2024-02-22 00:00:00 |  | 2024-02-22 00:00:00 |  |  |  | 1711 | 1725.55
24-4116 | Cargill, LTD |  | 5875 | 2024-03-04 00:00:00 | 2024-02-22 00:00:00 |  | 2024-02-22 00:00:00 | 1100 | 483.09 |  | 1605
24-4117 | [NAME] |  | 16560 | 2024-03-11 00:00:00 | 2024-02-22 00:00:00 |  | 2024-02-26 00:00:00 | 6143.5 | 4155.26 |  | 4608 | 1814.8
24-4127 | [NAME] |  | 8210 | 2024-02-27 00:00:00 | 2024-02-22 00:00:00 |  | 2024-02-26 00:00:00 | 1540 | 258.5 |  | 2154 | 1854.52
24-4109 | Bachmann - Trinidad |  | 47200 | 2024-05-23 00:00:00 | 2024-02-19 00:00:00 |  | 2024-02-26 00:00:00 | 7150 | 4391.75 |  | 18038
24-4126 | Technos |  | 1360 | 2024-03-22 00:00:00 | 2024-02-26 00:00:00 |  | 2024-02-28 00:00:00 | 242 | 110.92 |  | 492 | 459.76
24-4124 | Eriks |  | 6895 | 2024-03-15 00:00:00 | 2024-02-29 00:00:00 |  | 2024-02-29 00:00:00 | 1408 | 507.53 |  | 3038 | 2702.61
23-4090 | [NAME] |  | 880 | 2024-02-28 00:00:00 | 2024-02-28 00:00:00 |  | 2024-02-28 00:00:00 |  |  |  | 88 | 88
23-4077 | Valmet |  | 1000 | 2024-05-01 00:00:00 | 2024-02-15 00:00:00 |  | 2024-02-15 00:00:00 | 440 | 440 |  | 210 | 210
24-4122 | Basin Electric |  | 500 | 2024-03-13 00:00:00 | 2024-02-15 00:00:00 |  | 2024-02-15 00:00:00 |  |  |  | 50 | 50
 |  |  |  |  |  | On Time | Total Shippments | Not on Time
 |  |  |  |  |  |  | Shipments |  |  |  |  |  |  |  | As Sold Margin | As Completed Margin