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

JOB NUMBER | CUSTOMER | Ship To State | SELL PRICE | DUE DATE | INVOICE Request DATE | ON Time | LABOR BUDGET $ | TOTAL LABOR $ | LABOR VARIANCE | MATERIAL BUDGET | TOTAL MATERIAL | MATERIAL [NAME] | TOTAL COST BUDGET | TOTAL ACTUAL COST | [NAME] |  | latest ending cost as of 11/1/2022 | variance | on budget
22-3861 | VOGT POWER |  | 75421 | 2023-01-16 00:00:00 | 2023-02-14 00:00:00 |  | 27909 | 41117.49 |  | 18214 | 26972.6
23-3907 | BACHMANN - Peru |  | 18215 | 2023-02-18 00:00:00 | 2023-02-24 00:00:00 |  | 2915 | 2091.83 |  | 7863.91 | 6062.24
23-3908 | BACHMANN- Fondorie Horne |  | 5455 | 2023-02-11 00:00:00 | 2023-02-27 00:00:00 |  | 1347.5 | 2177.09 |  | 2138.14
23-3931 | Bachmann - Teco |  | 1350 | 2023-02-21 00:00:00 | 2023-02-28 00:00:00 |  | 660 |  |  |  | 0
23-3921 | Technos |  | 4596 | 2023-02-24 00:00:00 | 2023-02-13 00:00:00 |  | 858 | 769.09 |  | 2261
22-3890 | BACHMANN |  | 550 | 2023-02-01 00:00:00 | 2023-02-23 00:00:00 |  | 165 | 428.08 |  | 200 | 495.54
22-3859 | VOGT POWER |  | 53476 | 2022-12-16 00:00:00 | 2023-02-21 00:00:00 |  | 16830 | 20340.25 |  | 19678
23-3905 | [NAME] |  | 806 | 2023-01-31 00:00:00 | 2023-02-02 00:00:00 |  | 0 |  |  | 548 | 513
22-3872 | Marathon |  | 1250 | 2023-02-20 00:00:00 | 2023-02-06 00:00:00 |  | 54 | 78.83 |  | 658 | 747.44
22-3918 | Airtek Construction |  | 2472 | 2023-02-17 00:00:00 | 2023-02-06 00:00:00 |  | 68.75 |  |  | 1600
23-3929 | Airco |  | 2400 | 2023-02-03 00:00:00 | 2023-02-06 00:00:00 |  | 610.5 | 189.75 |  | 1170 | 1061.81
23-3919 | [NAME] |  | 2916 | 2023-02-20 00:00:00 | 2023-02-06 00:00:00 |  | 358 | 631.58 |  | 1609.59 | 491.61
22-3799 | DOMINION ENERGY |  | 87280 | 2022-10-29 00:00:00 | 2023-02-06 00:00:00 |  | 30825 | 18688.18 |  | 29400
22-3812 | BACHMANN |  | 29400 | 2022-12-14 00:00:00 | 2023-02-07 00:00:00 |  | 9672 | 9968.5 |  | 9024
23-3933 | Exxon Mobile |  | 1003 | 2023-02-10 00:00:00 | 2023-02-09 00:00:00 |  | 231 | 360.26 |  | 270.3 | 240.54
22-3839 | BACHMANN |  | 80080 | 2022-12-16 00:00:00 | 2023-02-15 00:00:00 |  | 27242.5 | 33013.08 |  | 26816 | 16411.39
 | FEBRUARY TOTALS
 | February Revenue |  | 311339 |  | Shipments |  |  |  |  |  |  |  | As Sold Margin | Completed Margin |  |  |  |  | On budget
 | [NAME] Prior Rev
 |  | Dominion 3799
 |  | Bachmann 3899 | 24499.5
 |  | Vogt 3859 | 16042
 | Current Month Milestone Inv
 |  | Thyssenkrup | -28653
 |  | [NAME]
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  | Shipments |  |  |  |  |  |  |  | As Sold Margin | As Completed Margin