Spreadsheet: 864381d1711569364-grouping-2024-shipments-test
Sheet: Sept 2023

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 | Net Profit  (+Gain / -Loss
23-3999 | [NAME] |  | 12390 | 2023-08-29 00:00:00 | 2023-08-30 00:00:00 |  | 2023-09-05 00:00:00 | 2420 | 2316.42 |  | 5313.72
23-4038 | Bachmann (ND Paper) |  | 12000 | 2023-09-05 00:00:00 | 2023-09-01 00:00:00 |  | 2023-09-05 00:00:00 | 1650 | 899.25 |  | 3770.8
23-4027 | [NAME] |  | 5010 | 2023-09-06 00:00:00 | 2023-09-01 00:00:00 |  | 2023-09-05 00:00:00 | 2205.5 | 2253.17 |  | 1194 | 1050.16
23-4028 | [NAME] |  | 1895 | 2023-09-14 00:00:00 | 2023-09-01 00:00:00 |  | 2023-09-06 00:00:00 | 819.5 | 995.5 |  | 467 | 457.29
23-4035 | Technos |  | 2161 | 2023-09-11 00:00:00 | 2023-09-01 00:00:00 |  | 2023-09-06 00:00:00 | 170.5 |  |  | 1294 | 876.9
23-4032 | Bachmann (Carmeuse) |  | 1150 | 2023-09-07 00:00:00 | 2023-09-06 00:00:00 |  | 2023-09-07 00:00:00 | 330 | 121 |  | 409.88 | 243.88
23-4000 | [NAME] |  | 30490 | 2023-09-02 00:00:00 | 2023-09-04 00:00:00 |  | 2023-09-13 00:00:00 | 13090 | 15230.4 |  | 7630
23-4049 | Bachmann (Exxon) |  | 720 | 2023-09-19 00:00:00 | 2023-09-15 00:00:00 |  | 2023-09-18 00:00:00 | 330 | 146.67 |  | 16
23-4052 | Bachmann (ND Paper) |  | 3450 | 2023-09-20 00:00:00 | 2023-09-19 00:00:00 |  | 2023-09-19 00:00:00 | 110 |  |  | 806.18 | 573.36
23-4004 | Basin Electric Power Cooperative |  | 14400 | 2023-08-18 00:00:00 | 2023-09-18 00:00:00 |  | 2023-09-19 00:00:00 | 4620 | 3814.24 |  | 4666.92 | 1566.64
23-4020 | Get Pro Industrial |  | 60000 | 2023-09-01 00:00:00 | 2023-09-01 00:00:00 |  | 2023-09-20 00:00:00 | 0 |  |  | 40294 | 39653.5 |  |  | 39653.5
23-4034 | Damper & Control System |  | 1380 | 2023-09-21 00:00:00 | 2023-09-21 00:00:00 |  | 2023-09-21 00:00:00 | 374 | 495 |  | 558 | 557.31
23-4037 | Airco |  | 3430 | 2023-09-26 00:00:00 | 2023-09-26 00:00:00 |  | 2023-09-29 00:00:00 | 814 | 615.09 |  | 1516 | 1107.78
23-4043 | Damper & Control System |  | 4917 | 2023-09-29 00:00:00 | 2023-09-27 00:00:00 |  | 2023-10-02 00:00:00 | 1221 | 654.5 |  | 1956 | 1711.33
23-4044 | Bachmann (Morelco Seals) |  | 1830 | 2023-09-29 00:00:00 | 2023-09-25 00:00:00 |  | 2023-10-02 00:00:00 | 880 | 217.25 |  | 150 | 55
23-4047 | Airco |  | 2400 | 2023-09-29 00:00:00 | 2023-09-28 00:00:00 |  | 2023-10-02 00:00:00 | 495 | 947.83 |  | 1122 | 918.34
23-3989 | Bachmann (Seminole SD) |  | 126900 | 2023-09-20 00:00:00 | 2023-09-30 00:00:00 |  | 2023-10-02 00:00:00 | 34100 | 73263.85 |  | 51502
22-3823 | Mitsubishi Power |  | 149830 |  |  |  |  |  |  |  |  |  |  | 127355.5 | 127355.5
 |  |  |  |  |  |  | [NAME] | Shipped On Time | Did Not Ship On Time
 |  |  |  |  |  |  |  | Shipped On Time |  |  |  |  |  |  | As Sold Margin | As Completed Margin
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DateTransaction
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amount