Spreadsheet: 807534d1669936218-formula-not-working-for-all-cells-the-same-sample-cap-sheet
Sheet: CORPORATE (2)

 |  | VEHICLES
CORPORATE ROLLUP |  | F450 CREW CAB STAKE DUMP - 9'6" BODY |  | F450 CREW CAB STAKE DUMP - 11' BODY |  | F450 EXTENDED CAB STAKE DUMP - 11' BODY |  | F450 EXTENDED CAB CONSTRUCTION DUMP - 9' BODY |  | F350 CREW CAB PICK UP |  | F350 EXTENDED CAB PICK UP |  | F350 EXTENDED CAB PICK UP 4X4 |  | F150 EXT CAB IRRIGATION VEHICLE |  | F150 EXT CAB MANAGEMENT VEHICLE 4x2
2023 CAP COST |  | 70386 |  | 76883 |  | 75684 |  | 75640 |  | 54012 |  | 52563 |  | 54742 |  | 46823 |  | 43851
N-NEW / R-REPLACE |  | N | R | N | R | N | R | N | R | N | R | N | R | N | R | N | R | N | R
EAST DIVISION | REQUESTED
 | RECEIVED
 | UNBUDGETED
CENTRAL DIVISION | REQUESTED
 | RECEIVED
 | UNBUDGETED
WEST DIVISION | REQUESTED
 | RECEIVED
 | UNBUDGETED
BLANK | REQUESTED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | RECEIVED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | UNBUDGETED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BLANK | REQUESTED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | RECEIVED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | UNBUDGETED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BLANK | REQUESTED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | RECEIVED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | UNBUDGETED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BLANK | REQUESTED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | RECEIVED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | UNBUDGETED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BLANK | REQUESTED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | RECEIVED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | UNBUDGETED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL REQUESTED >>>
TOTAL RECEIVED >>>
TOTAL UNBUDGETED >>>
BUDGETED NEW (QTY)
Total
NEW RECEIVED (QTY)
TOTAL COST
BUDGETED REPLACEMENT (QTY) |  | 1
TOTAL COST
Remaining Transfers
[NAME] (QTY)
TOTAL COST
UNBUDGETED RECEIVED (QTY)
TOTAL COST
Replacements needing fulfilled
Replacement Transfer Costs
Remaining CU for inventory
TOTAL REQUESTED (QTY)
TOTAL REQUESTED ($$$)
TOTAL RECEIVED (QTY)
TOTAL RECEIVED ($$$)
BALANCE (QTY)
BALANCE ($$$)
UNBUDGETED (QTY)
UNBUDGETED ($$$)
Current Inventory (QTY) |  | 22 |  | 4 |  | 0 |  | 5 |  | 6 |  | 0 |  | 0 |  | 0 |  | 1
2021 Inventory Spend
Prior Year Inventory Spend |  | 63391 |  | 67506 |  | 0 |  | 61823 |  | 46168 |  | 0.01 |  | 0 |  |  |  | 0.01
Current Inventory ($$$)
Additional Inventory ON ORDER
Additional Inventory ON ORDER  ($$$)
Available for Transfer |  | 3 |  | 4 |  |  |  |  |  | 1 |  | 1 |  | 1 |  |  |  | 1
Total Inventory/Transfer
Total Requested
Remaining Needed
2023 Capital Spend
 |  | Budget |  | Actual |  | Difference
TOTAL NEW (GROWTH)
TOTAL REPLACEMENT
Total
Adjusted 2023 SPEND