Spreadsheet: 864381d1711569364-grouping-2024-shipments-test
Sheet: MAY 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 | Budget Margin | Actual Margin
23-3925 | Bachmann Industries | ME | 58535 | 2023-05-05 00:00:00 | 2023-05-05 00:00:00 |  | 2023-05-05 00:00:00 | 19959.5 | 17298.44 |  | 12972
23-3981 | Bearings & Power Transmissions, Inc. | AL | 2740 | 2023-05-03 00:00:00 | 2023-05-03 00:00:00 |  | 2023-05-03 00:00:00 | 456.5 | 289.66
23-3980 | Damper & Control System | AL | 2840 | 2023-05-01 00:00:00 | 2023-05-01 00:00:00 |  | 2023-05-01 00:00:00 | 519.5 | 1361.25 |  | 742 | 683.95
23-3926 | Bachmann Industries | MI | 7170 | 2023-05-10 00:00:00 | 2023-05-10 00:00:00 |  | 2023-05-10 00:00:00 | 2530 | 1930.5 |  | 2211.9
23-3967 | BLACK MOUNTAIN SAND | TX | 12655 | 2023-05-10 00:00:00 | 2023-05-10 00:00:00 |  | 2023-05-10 00:00:00 | 487.85 | 974.42 |  | 7002
22-3753 | ESI | OH | 6984 | 2023-05-10 00:00:00 | 2023-05-10 00:00:00 |  | 2023-05-10 00:00:00 | 1501.5 | 3156.99 |  | 3035.4
22-3880 | THYSSENKRUP | AL | 103110 | 2023-05-08 00:00:00 | 2023-05-09 00:00:00 |  | 2023-05-09 00:00:00 | 25671.25 | 23291.6 |  | 42428
23-3957 | Bachmann - County of Oswego |  | 3713.2 | 2023-04-25 00:00:00 | 2023-05-12 00:00:00 |  | 2023-05-12 00:00:00 | 165 |  |  | 1868.2 | 1836.81
23-3954 | Murphy Exploration | TX | 59260 | 2023-04-20 00:00:00 | 2023-05-09 00:00:00 |  | 2023-05-09 00:00:00 | 165 | 0 |  | 28664.2
23-3955 | Murphy Exploration |  | 105028.1 | 2023-04-20 00:00:00 | 2023-05-10 00:00:00 |  | 2023-05-10 00:00:00 | 19058 | 19417 |  | 32726
23-3982 | AIRCO INDUSTRIAL | SC | 3155 | 2023-05-30 00:00:00 | 2023-05-23 00:00:00 |  | 2023-05-23 00:00:00 | 341 | 895.58 |  | 1801 | 1574.48
23-3984 | Eriks North America | SC | 6430 | 2023-05-31 00:00:00 | 2023-05-21 00:00:00 |  | 2023-05-23 00:00:00 | 1380.5 | 1133.92 |  | 2987 | 2769.05
23-3985 | Technos, Inc | TX | 575 | 2023-05-25 00:00:00 | 2023-05-23 00:00:00 |  | 2023-05-23 00:00:00 |  | 93.5 |  | 324
23-3978 | Bachmann Industries |  | 8700 | 2023-05-24 00:00:00 | 2023-05-21 00:00:00 |  | 2023-05-24 00:00:00 |  | 1110.08 |  | 3250
23-3988 | [NAME] | AL | 668 | 2023-06-02 00:00:00 | 2023-05-23 00:00:00 |  | 2023-05-24 00:00:00 |  | 0 |  | 406 | 366.95
23-3977 | BLACK MOUNTAIN SAND | TX | 4700 | 2023-05-15 00:00:00 | 2023-05-30 00:00:00 |  | 2023-05-30 00:00:00 | 484 | 512.42 |  | 2710 | 2025
23-3966 | Indeck Power Equipment Co. | NY | 9152 | 2023-05-26 00:00:00 | 2023-05-26 00:00:00 |  | 2023-05-30 00:00:00 | 3547.5 | 3589.67 |  | 2628
23-3991 | Bachmann Industries |  | 920 | 2023-06-08 00:00:00 | 2023-05-30 00:00:00 |  | 2023-06-01 00:00:00 | 440 | 367.58 |  | 0
23-3983 | Bachmann Industries |  | 7415 | 2023-06-01 00:00:00 | 2023-05-30 00:00:00 |  | 2023-06-01 00:00:00 | 3520 | 1705 |  | 600
23-3979 | Bachmann Industries |  | 14020 | 2023-05-23 00:00:00 | 2023-05-23 00:00:00 |  | 2023-06-01 00:00:00 | 2640 | 2403 |  | 6800 | 5267.53
22-3823 | Mitsubishi Power |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 26261 |  |  |  |  |  |  |  | 26261
 | May 2023 Revenue
 |  |  |  |  | # of Shipments
 |  |  |  |  | # of Shipments on Time and % |  |  |  |  |  |  |  |  | As Sold Margin | As Completed Margin
Partial inv | THYSSENKRUP
prior mon | Murphy Exploration |  | -56380.53
 |  | Total Rev
 |  | QB Rev | 313634.77