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

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-3753 | ESI |  |  | 2022-11-16 00:00:00 | 3/29/22 and 6/7/22 |  |  | 104164.91 |  | 109897.6
22-3886 | ALBANY RUBBER & GASKET |  | 2783 | 2022-12-05 00:00:00 | 2023-01-04 00:00:00 |  | 1331 | 537.75 |  | 521 | 528.58 |  | 1852
22-3900 | Birmingham Rubber & Gasket |  | 1278 | 2023-01-04 00:00:00 | 2023-01-04 00:00:00 |  | 325 | 68.5 |  | 440 | 398.54 |  | 765
22-3896 | AIRCO INDUSTRIAL |  | 19380 | 2023-01-06 00:00:00 | 2023-01-04 00:00:00 |  | 2145 | 1733.67 |  | 10937 | 9363.97 |  | 13082
22-3894 | TECHNOS |  | 6786 | 2023-01-13 00:00:00 | 2023-01-06 00:00:00 |  | 0 | 0 |  | 4613 | 4535 |  | 6786
22-3899 | G Squared Bio Lab |  | 2325.6 | 2023-01-05 00:00:00 | 2023-01-06 00:00:00 |  | 396 | 432.5 |  | 112 | 210.26 |  | 508
23-3911 | Technos |  | 500 | 2023-01-26 00:00:00 | 2023-01-12 00:00:00 |  | 39 | 0 |  | 148 | 154.19 |  | 187
22-3850 | VOGT POWER |  | 26392 | 2023-12-20 00:00:00 | 11/23/2022 and 1/12/23 |  | 8021 | 11714.08 |  | 9873 |  |  | 17894
23-3901 | BARTLETT EQUIPMENT CO |  | 5364 | 2023-01-20 00:00:00 | 2023-01-20 00:00:00 |  | 578 | 0 |  | 2426 | 2079.51 |  | 3004
23-3903 | BLACK MOUNTAIN SAND |  | 3600 | 2023-01-20 00:00:00 | 2023-01-25 00:00:00 |  | 416 | 847.92 |  | 2032 | 1776 |  | 2448
23-3915 | [NAME] |  | 1798 | 2023-01-20 00:00:00 | 2023-01-20 00:00:00 |  | 176 | 475.75 |  | 878.7 | 269.7 |  | 1054.7
22-3897 | MONARCH WELDING |  | 2289 | 2023-01-18 00:00:00 | 2023-01-25 00:00:00 |  | 649 | 562.67 |  | 673 | 882.55 |  | 1550.9
22-3895 | LINDBERG PROCESS EQUIPMENT |  | 3072 | 2023-01-23 00:00:00 | 2023-01-27 00:00:00 |  | 1458 | 2445.09 |  | 630 | 656.74 |  | 2088
23-3902 | THERMAL FLUID SYSTEMS |  | 1184 | 2023-02-06 00:00:00 | 2023-01-27 00:00:00 |  | 660 | 617.84 |  | 141 | 245.83 |  | 801
23-3916 | [NAME] |  | 5236 | 2023-01-27 00:00:00 | 2023-01-27 00:00:00 |  | 1293 | 1941.49 |  | 1922 | 2727.41 |  | 3215
23-3917 | BLACK MOUNTAIN SAND |  | 5260 | 2023-02-08 00:00:00 | 2023-01-31 00:00:00 |  | 429 | 638 |  | 2754 | 526 |  | 3283
23-3914 | Bachmann Industries |  | 1075 | 2023-01-20 00:00:00 | 2023-01-31 00:00:00 |  | 206.25 | 260.34 |  | 521.39 | 234.75 |  | 727.64
23-3913 | G Squared Engineered Products |  | 4222 | 2023-01-24 00:00:00 | 2023-01-26 00:00:00 |  | 0 |  |  | 0 | 1236.98 |  | 2110
 | [NAME]
 | January Revenue |  | 191215.1 |  | Shipments |  |  |  |  |  |  |  | As Sold Margin | Completed Margin |  |  |  |  | On budget
 | [NAME] Prior Rev
 |  | ESI 3753
 |  | Vogt 3850 | 6598
 | Current Month Milestone Inv
 |  | Bachmann 3884 | -9922.5
 |  | Clarage 3892 | -6996
 |  | Bachmann 3862 | -34320
 |  | Dominion | -21820
 |  | [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