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

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
22-3900 | Birmingham Rubber & Gasket |  | 1278 | 2023-01-04 00:00:00 | 2023-01-04 00:00:00 |  | 325 | 68.5 |  | 440 | 398.54
22-3896 | AIRCO INDUSTRIAL |  | 19380 | 2023-01-06 00:00:00 | 2023-01-04 00:00:00 |  | 2145 | 1733.67 |  | 10937 | 9363.97
22-3894 | TECHNOS |  | 6786 | 2023-01-13 00:00:00 | 2023-01-06 00:00:00 |  | 0 | 0 |  | 4613 | 4535
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
23-3911 | Technos |  | 500 | 2023-01-26 00:00:00 | 2023-01-12 00:00:00 |  | 39 | 0 |  | 148 | 154.19
22-3850 | VOGT POWER |  | 26392 | 2023-12-20 00:00:00 | 11/23/2022 and 1/12/23 |  | 8021 | 11714.08 |  | 9873
23-3901 | BARTLETT EQUIPMENT CO |  | 5364 | 2023-01-20 00:00:00 | 2023-01-20 00:00:00 |  | 578 | 0 |  | 2426 | 2079.51
23-3903 | BLACK MOUNTAIN SAND |  | 3600 | 2023-01-20 00:00:00 | 2023-01-25 00:00:00 |  | 416 | 847.92 |  | 2032 | 1776
23-3915 | [NAME] |  | 1798 | 2023-01-20 00:00:00 | 2023-01-20 00:00:00 |  | 176 | 475.75 |  | 878.7 | 269.7
22-3897 | MONARCH WELDING |  | 2289 | 2023-01-18 00:00:00 | 2023-01-25 00:00:00 |  | 649 | 562.67 |  | 673 | 882.55
22-3895 | LINDBERG PROCESS EQUIPMENT |  | 3072 | 2023-01-23 00:00:00 | 2023-01-27 00:00:00 |  | 1458 | 2445.09 |  | 630 | 656.74
23-3902 | THERMAL FLUID SYSTEMS |  | 1184 | 2023-02-06 00:00:00 | 2023-01-27 00:00:00 |  | 660 | 617.84 |  | 141 | 245.83
23-3916 | [NAME] |  | 5236 | 2023-01-27 00:00:00 | 2023-01-27 00:00:00 |  | 1293 | 1941.49 |  | 1922 | 2727.41
23-3917 | BLACK MOUNTAIN SAND |  | 5260 | 2023-02-08 00:00:00 | 2023-01-31 00:00:00 |  | 429 | 638 |  | 2754 | 526
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
23-3913 | G Squared Engineered Products |  | 4222 | 2023-01-24 00:00:00 | 2023-01-26 00:00:00 |  | 0 |  |  | 0 | 1236.98
 | [NAME]
 | FEBRUARY
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
 | [NAME]
23-3909 | Eriks North America |  | 2418 | 2023-03-03 00:00:00 | 2023-03-01 00:00:00 |  | 1100 | 1552.83 |  | 534 | 419.1
23-3938 | VOGT POWER |  | 5067 | 2023-03-01 00:00:00 | 2023-03-02 00:00:00 |  | 1155 | 2442 |  | 1881 | 1590.61
23-3928 | AIRCO INDUSTRIAL |  | 11178 | 2023-03-01 00:00:00 | 2023-03-01 00:00:00 |  | 1490.5 | 3762.92 |  | 3692 | 4383.84
23-3930 | Bachmann-Hamon |  | 1290 | 2023-02-21 00:00:00 | 2023-03-02 00:00:00 |  | 10 |  |  | 250
22-3904 | [NAME] |  | 10282 | 2023-03-24 00:00:00 | 2023-03-07 00:00:00 |  | 0 | 0 |  | 5955 | 1269.84
23-3912 | Eriks North America |  | 2723 | 2023-03-03 00:00:00 | 2023-03-02 00:00:00 |  | 1178 | 2236.67 |  | 655
22-3862 | Bachmann |  | 114400 | 2023-03-10 00:00:00 | 2023-03-09 00:00:00 |  | 34320 | 36876.58 |  | 40640
23-3937 | Bachmann |  | 15240 | 2023-03-10 00:00:00 | 2023-03-09 00:00:00 |  | 1210 | 1086.25 |  | 3911.49
23-3932 | Bachmann |  | 285 | 2023-02-25 00:00:00 | 2023-03-17 00:00:00 |  | 165 | 0 |  | 0 | 0
23-3923 | [NAME] |  | 7317 | 2023-04-08 00:00:00 | 2023-03-17 00:00:00 |  | 3465 | 4856.51 |  | 1491 | 1315.05
23-3952 | Kronospan |  | 3420 | 2023-03-10 00:00:00 | 2023-03-17 00:00:00 |  | 0 | 0 |  | 2445 | 2445
23-3906 | Bachmann | ME | 19642.5 | 2023-03-09 00:00:00 | 2023-03-21 00:00:00 |  | 2860 | 2639.07 |  | 9006.41 | 5016.27
22-3888 | VOGT POWER | TX | 27910 | 2023-02-17 00:00:00 | 2023-03-21 00:00:00 |  | 10406 | 11206.24 |  | 8772 | 8775.66
23-3956 | Technos Fan | TX | 1880 | 2023-03-31 00:00:00 | 2023-03-21 00:00:00 |  | 550 | 795.67 |  | 706
23-3943 | Bachmann | ME | 1260 | 2023-03-30 00:00:00 | 2023-03-21 00:00:00 |  | 401.5 | 276.83 |  | 360 | 382.98
23-3910 | [NAME] | MI | 845 | 2023-03-18 00:00:00 | 2023-03-21 00:00:00 |  | 0 | 0 |  | 513.51 | 434.77
22-3891 | [NAME] | MI | 20356 | 2023-02-21 00:00:00 | 2023-03-21 00:00:00 |  | 8487 | 8481.6 |  | 5349.6 | 5183.28
23-3948 | BLACK MOUNTAIN SAND | TX | 758 | 2023-03-24 00:00:00 | 2023-03-21 00:00:00 |  | 110 | 331.83 |  | 330 | 393.98
23-3944 | ALBANY RUBBER & GASKET | GA | 2480 | 2023-03-20 00:00:00 | 2023-03-22 00:00:00 |  | 715 | 966.17 |  | 992 | 955.94
23-3949 | Eriks North America | SC | 3615 | 2023-04-11 00:00:00 | 2023-03-22 00:00:00 |  | 660 | 590.33 |  | 1497 | 1217.71
23-3960 | Bearings & Power Transmissions, Inc. | AL | 2515 | 2023-03-24 00:00:00 | 2023-03-27 00:00:00 |  | 459.8 | 241.64 |  | 1048
23-3953 | Indeck Power Equipment Co. | IL | 1735 | 2023-03-22 00:00:00 | 2023-03-27 00:00:00 |  | 550 | 0 |  | 621 | 534.24
23-3935 | Bachmann | ME | 1352 | 2023-03-16 00:00:00 | 2023-03-29 00:00:00 | NO | 203.5 | 220.92 |  | 540 | 456.19 |  |  |  |  |  | #REF! | #REF! | 1
23-3951 | AIRCO INDUSTRIAL | SC | 39082 | 2023-03-23 00:00:00 | 2023-03-29 00:00:00 |  | 11935 | 5334.07 |  | 14675 | 13260.64
23-3963 | [NAME] | AL | 698 | 2023-03-31 00:00:00 | 2023-03-29 00:00:00 |  | 264 | 0 |  | 208 | 0
23-3922 | [NAME] | AL | 6277 | 2023-04-10 00:00:00 | 2023-03-29 00:00:00 |  | 3107.5 | 3722.57 |  | 1140 | 921.32
23-3947 | Bachmann | ME | 17681 | 2023-03-15 00:00:00 | 2023-03-29 00:00:00 |  | 3245 | 4847.33 |  | 8690 | 6210.07
23-3942 | Bachmann | ME | 2520 | 2023-03-15 00:00:00 | 2023-03-29 00:00:00 |  | 1320 | 974.42 |  | 0 | 0
23-3961 | Bachman Techno | ME | 1350 | 2023-03-30 00:00:00 | 2023-03-31 00:00:00 |  | 660 | 943.25 |  | 0
 | [NAME]
 | March Revenue |  | 330733 |  | Shipments |  |  |  |  |  |  |  | As Sold Margin | Completed Margin |  |  |  |  | On budget
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #REF! |  |  | #REF!
 |  |  |  |  |  |  |  |  | #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