Spreadsheet: 864381d1711569364-grouping-2024-shipments-test
Sheet: Oct 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-4050 | Airco |  | 3079 | 2023-10-03 00:00:00 | 2023-10-02 00:00:00 |  | 2023-10-02 00:00:00 | 737 | 805.75 |  | 1348 | 481.05
23-4053 | Esi, Inc. of Tennessee |  | 14470 | 2023-10-02 00:00:00 | 2023-10-02 00:00:00 |  | 2023-10-02 00:00:00 | 330 | 687.5 |  | 6714.61
23-4003 | [NAME] |  | 49084 | 2023-10-10 00:00:00 | 2023-10-12 00:00:00 |  | 2023-10-13 00:00:00 | 23006.5 | 22979.89 |  | 10020
23-4055 | Bearings & Power Transmissions, Inc. |  | 815 | 2023-10-10 00:00:00 | 2023-09-26 00:00:00 |  | 2023-10-13 00:00:00 | 110 |  |  | 120 | 253.08
23-4023 | Bachmann Industries |  | 8640 | 2023-10-04 00:00:00 | 2023-10-12 00:00:00 |  | 2023-10-13 00:00:00 | 935 | 1835.16 |  | 4290
23-4054 | [NAME] |  | 500 | 2023-10-16 00:00:00 | 2023-10-13 00:00:00 |  | 2023-10-13 00:00:00 | 110 | 79.75 |  | 131 | 112.48
23-4056 | Bachmann-Morelco |  | 7375 | 2023-10-27 00:00:00 | 2023-10-17 00:00:00 |  | 2023-10-18 00:00:00 | 3795 | 1778.33
23-3971 | Air Techniques |  | 7137 | 2023-10-15 00:00:00 | 2023-10-06 00:00:00 |  | 2023-10-19 00:00:00 | 3194.5 | 4233.19 |  | 1263
23-4036 | BLACK MOUNTAIN SAND |  | 3660 | 2023-09-22 00:00:00 | 2023-10-23 00:00:00 |  | 2023-10-23 00:00:00 | 385 | 400.58 |  | 1995 | 1946.17
23-4040 | [NAME] |  | 4533 | 2023-10-22 00:00:00 | 2023-10-23 00:00:00 |  | 2023-10-23 00:00:00 | 1963.5 | 1599.58 |  | 920
23-4041 | [NAME] |  | 4533 | 2023-10-22 00:00:00 | 2023-10-23 00:00:00 |  | 2023-10-26 00:00:00 | 1963.5 | 2621.67 |  | 920
23-3996 | Bachmann (Technip Barouge 4 23-4416) |  | 121518 | 2023-09-08 00:00:00 | 2023-10-25 00:00:00 |  | 2023-10-25 00:00:00 | 41976 | 36775.75 |  | 29604
23-4046 | Airco |  | 13490 | 2023-10-04 00:00:00 | 2023-10-22 00:00:00 |  | 2023-10-25 00:00:00 | 907.5 | 720.5 |  | 7180 | 7170.31
23-4057 | Bachmann - Kissimmee |  | 2532 | 2023-10-31 00:00:00 | 2023-10-30 00:00:00 |  | 2023-10-30 00:00:00 | 220 | 51.53 |  | 1300 | 1010.09
23-4059 | Esi, Inc. of Tennessee |  | 12700 | 2023-10-23 00:00:00 | 2023-10-23 00:00:00 |  | 2023-10-30 00:00:00 | 165 | 209.92 |  | 6142.1
23-4026 | Bachmann - Kissimmee |  | 28050 | 2023-10-31 00:00:00 | 2023-10-31 00:00:00 |  | 2023-10-31 00:00:00 | 12760 | 5519.25 |  | 2125 | 2205
 |  |  |  |  |  |  | Total Shipments | Late Shipments |  |  |  |  |  | As Sold Margin | As Completed Margin
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 22-3823 FRT | 12100 |  |  |  |  |  |  | -12100
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 23-3967 | 795.5 | CO Commission not captured
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 23-3989 | 12861.75 | [NAME] in Sept Labor Cost in Oct.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 23-3823 | 925.83 | Mitsubishi Labor captured in Oct
22-3823 | Mitsubishi Power |  | 749150 | 2023-08-03 00:00:00 | 2023-10-18 00:00:00 |  | 2023-10-18 00:00:00 | 209960.3 | 231916.49 |  | 422555