Spreadsheet: 864381d1711569364-grouping-2024-shipments-test
Sheet: Jan 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
23-4089 | Airco |  | 42576 | 2024-01-18 00:00:00 | 2024-01-19 00:00:00 |  | 2024-01-24 00:00:00 | 6446 | 8141.82 |  | 21211
24-4095 | Airco |  | 4386 | 2024-01-31 00:00:00 | 2024-01-30 00:00:00 |  | 2024-01-31 00:00:00 | 660 | 442.74 |  | 2186 | 1832.35
24-4103 | Airco |  | 2918 | 2024-01-31 00:00:00 | 2024-01-30 00:00:00 |  | 2024-01-31 00:00:00 | 275 | 429 |  | 1563 | 1822.7
23-4007 | Andritz |  | 50618 | 2024-01-10 00:00:00 | 2024-01-03 00:00:00 |  | 2024-01-17 00:00:00 | 16720 | 20137.34 |  | 17613.8
24-4102 | Bachmann - Canada |  | 8800 | 2024-03-08 00:00:00 | 2024-01-30 00:00:00 |  | 2024-01-31 00:00:00 | 1320 | 1651.83 |  | 2800
23-4086 | Bachmann - Syncrude Seals |  | 5100 | 2024-01-15 00:00:00 | 2024-01-31 00:00:00 |  | 2024-01-31 00:00:00 | 2255 | 2331.09 |  | 1050 | 1304.01
23-4087 | Bachmann - Syncrude Seals |  | 5100 | 2024-01-15 00:00:00 | 2024-01-31 00:00:00 |  | 2024-01-31 00:00:00 | 2255 | 1402.5 |  | 1050
23-4092 | [NAME] |  | 2624 | 2024-01-19 00:00:00 | 2024-01-18 00:00:00 |  | 2024-01-19 00:00:00 | 847 | 1041.33 |  | 925 | 772.51
24-4096 | [NAME] |  | 1980 | 2024-01-26 00:00:00 | 2024-01-18 00:00:00 |  | 2024-01-19 00:00:00 | 297 | 548.17 |  | 1046 | 758.46
24-4097 | [NAME] |  | 4350 | 2024-01-16 00:00:00 | 2024-01-17 00:00:00 |  | 2024-01-17 00:00:00 |  |  |  | 2520 | 2401.57
23-4065 | Black Mountain Sand |  | 4101 | 2024-01-16 00:00:00 | 2024-01-08 00:00:00 |  | 2024-01-10 00:00:00 | 379.5 | 763.58 |  | 2405.1 | 2477.1
23-4064 | Cleveland-Cliff |  | 10060 | 2023-12-20 00:00:00 | 2024-01-11 00:00:00 |  | 2024-01-15 00:00:00 | 4070 | 5478 |  | 2292.73 | 1912.43
23-4085 | Damper & Control Systems |  | 4320 | 2024-01-22 00:00:00 | 2024-01-12 00:00:00 |  | 2024-01-15 00:00:00 | 1562 | 1807.66 |  | 1372 | 1200.66
24-4111 | Eriks |  | 1275 | 2024-02-01 00:00:00 | 2024-01-31 00:00:00 |  | 2024-01-31 00:00:00 | 352 | 270.42 |  | 220 | 171.53
23-4091 | Kronospan |  | 1300 | 2024-01-08 00:00:00 | 2024-01-08 00:00:00 |  | 2024-01-10 00:00:00 | 0 |  |  | 715 | 796.46
24-4110 | L&M Industrial |  | 3235 | 2024-01-29 00:00:00 | 2024-01-29 00:00:00 |  | 2024-01-31 00:00:00 | 264 | 207.17 |  | 1349 | 1276.65
24-4099 | Mitsubishi Power |  | 11633.91 | 2024-01-16 00:00:00 | 2024-01-16 00:00:00 |  | 2024-01-19 00:00:00 |  |  |  | 6802.27 | 6802.27
23-4063 | North American Construction |  | 13950 | 2024-01-10 00:00:00 | 2024-01-02 00:00:00 |  | 2024-01-04 00:00:00 | 0 |  |  | 9474 | 9345.62
24-4104 | Power Systems |  | 3808.8 | 2024-02-06 00:00:00 | 2024-01-31 00:00:00 |  | 2024-01-31 00:00:00 |  |  |  | 1711 | 1623
24-4105 | Power Systems |  | 621 | 2024-02-06 00:00:00 | 2024-01-31 00:00:00 |  | 2024-01-31 00:00:00 |  |  |  | 275 | 175
23-4019 | St. Mary's Cement |  | 38701 | 2024-01-10 00:00:00 | 2024-01-03 00:00:00 |  | 2024-01-05 00:00:00 | 4398 | 5487.17 |  | 21773.73
24-4098 | Technos |  | 10458.75 | 2024-01-19 00:00:00 | 2024-01-17 00:00:00 |  | 2024-01-19 00:00:00 | 1908.5 | 787.42 |  | 3517 | 3054.33
23-4077 | Valmet |  | 44730 | 2024-05-01 00:00:00 | 2024-01-31 00:00:00 |  | 2024-01-31 00:00:00 | 16351.5 | 14028.65 |  | 13993
 |  |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  | On Time | Total Shipped | Total Late
 |  |  |  |  |  |  | Shipments |  |  |  |  |  |  |  | As Sold Margin | As Completed Margin
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 169984.61