Spreadsheet: 859486d1707853046-determining-sales-per-month-cost-data
Sheet: 02.14.24

OPEN JOBS |  |  |  | 55
JOB NUMBER | CUSTOMER | Sell Price | Due Date | Labor Hours $$ Budget | HOURS - LABOR BUDGET | HOURS - LABOR TO DATE | LABOR HOURS - REMAINING AGAINST BUDGET | MATERIAL BUDGET | MATERIAL [NAME] | OPEN PO | MATERIAL BUDGET REMAINING | "As Sold" Revenue Budget  Margin % | "As Completed" Revenue % Margin To Date | % Used of Budget | Milestone Billing Information | Milestone Complitions and Billed | Notes: | Hours Labor to Date in $ | Budgeted Amount | Hours Labor to Date in $ | Budgeted Amount | Cost to Date
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column132 | Column14 | Column15 | Column16 | Column133
23-4045 + CO | AEP (FIELD SERVICE) |  | 2020-04-07 00:00:00 |  |  |  |  |  | 16300.42 | 88700 |  |  |  |  | 30% at po and 70% Complition | 30% of Milestone billed on 9/13/23. | Due Date was changed to 04/08/2024 per Change Order.
23-4067 | XRG Technologies | 59500 | 2020-01-14 00:00:00 | 16555 |  |  |  | 19974.24 | 5950 |  |  |  |  |  |  |  | Need Change Order for Change of date due to delays in modifications to drawings.
23-4090 | [NAME] | 18663 | 2020-03-30 00:00:00 | 4092 |  |  |  | 8578.3 | 1866.3 |  |  |  |  |  |  |  | Customer has delayed job for 60 days or more due to EPA issues. 01/31 to 03/31.  Will evaluate at the 60 day.
24-4093 | St. Mary's Cement | 1315 | 2020-02-29 00:00:00 |  |  |  |  | 876.5 | 181.5 | 655
24-4100 | Airco | 5425 | 2020-02-11 00:00:00 | 605 |  |  |  | 2377 |  | 1481.42
24-4108 | Airco | 2807 | 2020-02-27 00:00:00 | 660 |  |  |  | 1164 |  | 1388.9
24-4109 | Bachmann - Trinidad | 47200 | 2023-02-16 00:00:00 | 7150 |  | 2 days, 9:23:00 |  | 18038 | 348.85 |  |  |  |  |  | 50% at release to fab / 50% at ready to ship | Billied 50% Milestone Billing on 01/31/2024 release to Fab
23-4077 co | Valmet | 1000 | 2020-04-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sold Shrink Wrap Seperately from Job..  This is [NAME]
24-4114 | Bachmann - Utah - Dampers | 27969 | 2020-04-10 00:00:00 | 10505 |  |  |  | 8500
24-4115 | Power Systems | 3808.8 | 2020-03-03 00:00:00 | 0 |  |  |  | 1711 |  | 1615
24-4117 | [NAME] | 16560 | 2020-03-10 00:00:00 | 6143.5 |  |  |  | 4608
24-4118 | Black Mountain Sand | 5200 | 2020-02-28 00:00:00 |  |  |  |  | 3372
24-4119 | G Squared Engineered | 3825 | 2020-03-21 00:00:00 | 330 |  |  |  | 2166.64
24-4120 | Duke Energy | 95880 | 2020-04-14 00:00:00 | 32560 |  |  |  | 26889.24
24-4121 | Damper & Control | 3450 | 2020-03-14 00:00:00 | 1083.5 |  |  |  | 1072
24-4116 | Cargill
 | January
 | February
 | March
 | April
 | May
 | Backlog Total:
ORDERS SHIPPED IN  FEBRUARY
24-4101 | Bachmann - UAE | 480 | 2020-01-30 00:00:00 |  |  |  |  | 145 | 235
24-4112 | Technos | 680 | 2020-02-25 00:00:00 | 121 |  | 1:13:00 |  | 255 | 240.43
24-4107 | Bachmann - Yogt Guyana | 1800 | 2020-03-06 00:00:00 | 440 |  | 6:53:00 |  | 560 | 309.32
24-4113 | Bachmann - Mexico | 900 | 2020-02-09 00:00:00 | 352 |  |  |  | 153 | 154.66
24-4106 | Bachmann - Columbia | 1025 | 2020-01-31 00:00:00 | 481.25 |  | 7:02:00
23-4081 | Bachmann - Meraki Dewa Spare Parts | 61475 | 2020-01-04 00:00:00 | 20020 |  | 15 days, 1:20:00 |  | 14500 | 14073.12 |  |  |  |  |  | 50% at receipt of order / 50% at ready to ship | Invoiced customer 50% at receipt of order 11/17/23
24-4094 | [NAME] | 8330 | 2020-02-27 00:00:00 | 4031.5 |  | 3 days, 12:57:00 |  | 1479 | 855.42 | 33
Total Labor Hours To Date
Total Material To Date
Total Open P/O