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

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 | "As Sold" Budget Margin % | "As Completed" Margin | Difference between Budget / Completed | FREIGHT REIM | Completed Margin     (+Gain / -Loss) | As Sold Margin | Margin (+/-) As Sold Margin
23-4089 |  |  | 42576 | 2024-01-18 00:00:00 | 2024-01-19 00:00:00 |  | 2024-01-24 00:00:00 | 6446 | 8141.82 |  | 21211
24-4095 |  |  | 4386 | 2024-01-31 00:00:00 | 2024-01-30 00:00:00 |  | 2024-01-31 00:00:00 | 660 | 442.74 |  | 2186 | 1832.35
24-4103 |  |  | 2918 | 2024-01-31 00:00:00 | 2024-01-30 00:00:00 |  | 2024-01-31 00:00:00 | 275 | 429 |  | 1563 | 1822.7
23-4007 |  |  | 50618 | 2024-01-10 00:00:00 | 2024-01-03 00:00:00 |  | 2024-01-17 00:00:00 | 16720 | 20137.34 |  | 17613.8
24-4102 |  |  | 8800 | 2024-03-08 00:00:00 | 2024-01-30 00:00:00 |  | 2024-01-31 00:00:00 | 1320 | 1651.83 |  | 2800
23-4086 |  |  | 5100 | 2024-01-15 00:00:00 | 2024-01-31 00:00:00 |  | 2024-01-31 00:00:00 | 2255 | 2331.09 |  | 1050 | 1304.01
23-4087 |  |  | 5100 | 2024-01-15 00:00:00 | 2024-01-31 00:00:00 |  | 2024-01-31 00:00:00 | 2255 | 1402.5 |  | 1050
23-4092 |  |  | 2624 | 2024-01-19 00:00:00 | 2024-01-18 00:00:00 |  | 2024-01-19 00:00:00 | 847 | 1041.33 |  | 925 | 772.51
24-4096 |  |  | 1980 | 2024-01-26 00:00:00 | 2024-01-18 00:00:00 |  | 2024-01-19 00:00:00 | 297 | 548.17 |  | 1046 | 758.46
24-4097 |  |  | 4350 | 2024-01-16 00:00:00 | 2024-01-17 00:00:00 |  | 2024-01-17 00:00:00 |  |  |  | 2520 | 2401.57
23-4065 |  |  | 4101 | 2024-01-16 00:00:00 | 2024-01-08 00:00:00 |  | 2024-01-10 00:00:00 | 379.5 | 763.58 |  | 2405.1 | 2477.1
23-4064 |  |  | 10060 | 2023-12-20 00:00:00 | 2024-01-11 00:00:00 |  | 2024-01-15 00:00:00 | 4070 | 5478 |  | 2292.73 | 1912.43
23-4085 |  |  | 4320 | 2024-01-22 00:00:00 | 2024-01-12 00:00:00 |  | 2024-01-15 00:00:00 | 1562 | 1807.66 |  | 1372 | 1200.66
24-4111 |  |  | 1275 | 2024-02-01 00:00:00 | 2024-01-31 00:00:00 |  | 2024-01-31 00:00:00 | 352 | 270.42 |  | 220 | 171.53
23-4091 |  |  | 1300 | 2024-01-08 00:00:00 | 2024-01-08 00:00:00 |  | 2024-01-10 00:00:00 | 0 |  |  | 715 | 796.46
24-4110 |  |  | 3235 | 2024-01-29 00:00:00 | 2024-01-29 00:00:00 |  | 2024-01-31 00:00:00 | 264 | 207.17 |  | 1349 | 1276.65
24-4099 |  |  | 11633.91 | 2024-01-16 00:00:00 | 2024-01-16 00:00:00 |  | 2024-01-19 00:00:00 |  |  |  | 6802.27 | 6802.27
23-4063 |  |  | 13950 | 2024-01-10 00:00:00 | 2024-01-02 00:00:00 |  | 2024-01-04 00:00:00 | 0 |  |  | 9474 | 9345.62
24-4104 |  |  | 3808.8 | 2024-02-06 00:00:00 | 2024-01-31 00:00:00 |  | 2024-01-31 00:00:00 |  |  |  | 1711 | 1623
24-4105 |  |  | 621 | 2024-02-06 00:00:00 | 2024-01-31 00:00:00 |  | 2024-01-31 00:00:00 |  |  |  | 275 | 175
23-4019 |  |  | 38701 | 2024-01-10 00:00:00 | 2024-01-03 00:00:00 |  | 2024-01-05 00:00:00 | 4398 |  |  | 21773.73
24-4098 |  |  | 10458.75 | 2024-01-19 00:00:00 | 2024-01-17 00:00:00 |  | 2024-01-19 00:00:00 | 1908.5 | 787.42 |  | 3517 | 3054.33
23-4077 |  |  | 44730 | 2024-05-01 00:00:00 | 2024-01-31 00:00:00 |  | 2024-01-31 00:00:00 | 16351.5 | 14028.65 |  | 13993
24-4094 |  |  | 8330 | 2024-02-28 00:00:00 | 2024-02-07 00:00:00 |  | 2024-02-07 00:00:00 | 4031.5 | 4672.24 |  | 1479
23-4081 |  |  | 61475 | 2024-01-05 00:00:00 | 2024-02-07 00:00:00 |  | 2024-02-09 00:00:00 | 20020 | 21225.41 |  | 14500 | 14073.12
24-4106 |  |  | 1025 | 2024-02-01 00:00:00 | 2024-02-07 00:00:00 |  | 2024-02-08 00:00:00 | 481.25 | 386.83
24-4112 |  |  | 680 | 2024-02-26 00:00:00 | 2024-02-06 00:00:00 |  | 2024-02-06 00:00:00 | 121 | 66.92 |  | 255 | 240.43
24-4107 |  |  | 1800 | 2024-03-07 00:00:00 | 2024-02-05 00:00:00 |  | 2024-02-05 00:00:00 | 440 | 378.58 |  | 560 | 309.32
24-4113 |  |  | 900 | 2024-02-10 00:00:00 | 2024-02-02 00:00:00 |  | 2024-02-05 00:00:00 | 352 |  |  | 153.4 | 154.66
24-4101 |  |  | 480 | 2024-01-31 00:00:00 | 2024-01-31 00:00:00 |  | 2024-02-01 00:00:00 |  |  |  | 145 | 235
24-4093 |  |  | 1315 | 2024-03-01 00:00:00 | 2024-02-11 00:00:00 |  | 2024-02-14 00:00:00 |  |  |  | 876 | 859.49
24-4118 |  |  | 5200 | 2024-02-29 00:00:00 | 2024-02-22 00:00:00 |  | 2024-02-22 00:00:00 |  |  |  | 3372 | 3208.5
24-4115 |  |  | 3808.8 | 2024-03-04 00:00:00 | 2024-02-22 00:00:00 |  | 2024-02-22 00:00:00 |  |  |  | 1711 | 1725.55
24-4116 |  |  | 5875 | 2024-03-04 00:00:00 | 2024-02-22 00:00:00 |  | 2024-02-22 00:00:00 | 1100 | 483.09 |  | 1605
24-4117 |  |  | 16560 | 2024-03-11 00:00:00 | 2024-02-22 00:00:00 |  | 2024-02-26 00:00:00 | 6143.5 | 4155.26 |  | 4608 | 1814.8
24-4127 |  |  | 8210 | 2024-02-27 00:00:00 | 2024-02-22 00:00:00 |  | 2024-02-26 00:00:00 | 1540 | 258.5 |  | 2154 | 1854.52
24-4109 |  |  | 47200 | 2024-05-23 00:00:00 | 2024-02-19 00:00:00 |  | 2024-02-26 00:00:00 | 7150 | 4391.75 |  | 18038
24-4126 |  |  | 1360 | 2024-03-22 00:00:00 | 2024-02-26 00:00:00 |  | 2024-02-28 00:00:00 | 242 | 110.92 |  | 492 | 459.76
24-4124 |  |  | 6895 | 2024-03-15 00:00:00 | 2024-02-29 00:00:00 |  | 2024-02-29 00:00:00 | 1408 | 507.53 |  | 3038 | 2702.61
23-4090 |  |  | 880 | 2024-02-28 00:00:00 | 2024-02-28 00:00:00 |  | 2024-02-28 00:00:00 |  |  |  | 88 | 88
23-4077 |  |  | 1000 | 2024-05-01 00:00:00 | 2024-02-15 00:00:00 |  | 2024-02-15 00:00:00 | 440 | 440 |  | 210 | 210
24-4122 |  |  | 500 | 2024-03-13 00:00:00 | 2024-02-15 00:00:00 |  | 2024-02-15 00:00:00 |  |  |  | 50 | 50
24-4108 |  |  | 2807 | 2024-03-07 00:00:00 | 2024-02-23 00:00:00 |  | 2024-03-07 00:00:00 | 660 | 251.17 |  | 1164 | 1388.9
24-4129 |  |  | 2560 | 2024-03-04 00:00:00 | 2024-03-01 00:00:00 |  | 2024-03-04 00:00:00 |  |  |  | 1211 | 1112.54
24-4100 |  |  | 5425 | 2024-03-04 00:00:00 | 2024-03-04 00:00:00 |  | 2024-03-04 00:00:00 | 605 | 443.67 |  | 2377 | 1481.42
24-4121 |  |  | 3450 | 2024-03-15 00:00:00 | 2024-02-27 00:00:00 |  | 2024-03-07 00:00:00 | 1083.5 | 1693.08 |  | 1072 | 961.7
24-4137 |  |  | 5890 | 2024-03-11 00:00:00 | 2024-03-11 00:00:00 |  | 2024-03-11 00:00:00 | 715 | 198.92 |  | 1836
24-4123 |  |  | 4135 | 2024-03-20 00:00:00 | 2024-03-08 00:00:00 |  | 2024-03-11 00:00:00 | 1853.5 | 1819.59 |  | 727
24-4131 |  |  | 2250 | 2024-03-11 00:00:00 | 2024-03-08 00:00:00 |  | 2024-03-11 00:00:00 | 825 | 590.34 |  | 654 | 406.4
24-4125 |  |  | 4265 | 2024-03-20 00:00:00 | 2024-03-08 00:00:00 |  | 2024-03-13 00:00:00 | 946 | 534.42 |  | 1820 | 1847.7
24-4133 |  |  | 2100 | 2024-03-20 00:00:00 | 2024-03-11 00:00:00 |  | 2024-03-13 00:00:00 | 863.5 | 439.08 |  | 501 | 438.8
24-4139 |  |  | 2075 | 2024-03-27 00:00:00 | 2024-03-22 00:00:00 |  | 2024-03-25 00:00:00 | 495 |  |  | 734
24-4119 |  |  | 3825 | 2024-03-22 00:00:00 | 2024-03-22 00:00:00 |  | 2024-03-25 00:00:00 | 330 |  |  | 2166.64
 |  |  |  |  |  | On Time Shipped | Total Shipped | Not on Time |  |  |  |  |  |  | As Sold Margin | As Completed Margin |  |  |  |  |  | Completed Margin     (+Gain / -Loss) | As Sold Margin | Margin (+/-) As Sold Margin
 |  |  |  |  |  |  | = Shipments on Time
 |  |  | Sales | Labor | Material
 | Jan
 | Feb
 | Mar
 | Current Month