Exhibit B - Price Table Workbook W911RX24R0011.xlsx
XLSX spreadsheet 246 KB Posted
- Solicitation number
- W911RX24R0011
About this file
This document appears to be a price table workbook related to a federal contract opportunity for III Armored Corps Agricultural Sanitation and Washing Services, Solicitation Number W911RX24R0011.
The contract requires the contractor to provide non-personal services for agricultural disinfectant or washing of military equipment, including containers, vehicles, trailers, and aircraft. The contract includes a base year and four option years. Pricing is provided on a firm-fixed-price basis for various levels of service, with estimated monthly quantities of 1 job per CLIN. The total annual contract value is $0.00. The workbook also includes a Weighted Guidelines Profit Report and a detailed cost breakdown by labor, equipment, materials, and other direct charges. The solicitation is being issued by the Department of the Army Materiel Command Mission and Installation Contracting Command at Fort Hood, with a questions due date of October 10, 2024.
View the file
Other files
Show all 17
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
CLIN Schedule
| III Armored Corps, FT Cavazos | |
| BASE 12 Months |
CLINS: Level of Service Est. QTY (Monthly) Unit Unit Price Total Annual Cost
0001 AG Wash/AG San for Container FFP 1 JOB $0.00
0002 AG Wash/AG San for Track Veh FFP 1 JOB $0.00
0003 AG Wash/AG San for Trailer FFP 1 JOB $0.00
0004 AG Wash/AG San for Special Load FFP 1 JOB $0.00
0005 AG Wash/AG San for Wheeled Veh FFP 1 JOB $0.00
0006 AG Wash/AG San for Aircraft FFP 1 JOB $0.00
0007 AG Wash/AG San for UAS FFP 1 JOB $0.00
Total $0.00
| III Armored Corps, FT Cavazos | |
| 1st Option. 12 Months |
| CLINS: | Level of Service | Est. QTY (Monthly) | Unit | Unit Price | Total Annual Cost |
| 1001 | AG Wash/AG San for Container FFP | 1 | JOB | $0.00 |
1002 AG Wash/AG San for Track Veh FFP 1 JOB $0.00
1003 AG Wash/AG San for Trailer FFP 1 JOB $0.00
1004 AG Wash/AG San for Special Load FFP 1 JOB $0.00
1005 AG Wash/AG San for Wheeled Veh FFP 1 JOB $0.00
1006 AG Wash/AG San for Aircraft FFP 1 JOB $0.00
1007 AG Wash/AG San for UAS FFP 1 JOB $0.00
Total $0.00
| III Armored Corps, FT Cavazos | |
| 2nd Option. 12 Months |
| CLINS: | Level of Service | Est. QTY (Monthly) | Unit | Unit Price | Total Annual Cost |
| 2001 | AG Wash/AG San for Container FFP | 1 | JOB | $0.00 |
2002 AG Wash/AG San for Track Veh FFP 1 JOB $0.00
2003 AG Wash/AG San for Trailer FFP 1 JOB $0.00
2004 AG Wash/AG San for Special Load FFP 1 JOB $0.00
2005 AG Wash/AG San for Wheeled Veh FFP 1 JOB $0.00
2006 AG Wash/AG San for Aircraft FFP 1 JOB $0.00
2007 AG Wash/AG San for UAS FFP 1 JOB $0.00
Total $0.00
| III Armored Corps, FT Cavazos | |
| 3rd Option. 12 Months |
CLINS: Level of Service Est. QTY (Monthly) Unit Unit Price Total Annual Cost
| CLINS: | Level of Service | Est. QTY (Monthly) | Unit | Unit Price | Total Annual Cost |
| 3001 | AG Wash/AG San for Container FFP | 1 | JOB | $0.00 |
3002 AG Wash/AG San for Track Veh FFP 1 JOB $0.00
3003 AG Wash/AG San for Trailer FFP 1 JOB $0.00
3004 AG Wash/AG San for Special Load FFP 1 JOB $0.00
3005 AG Wash/AG San for Wheeled Veh FFP 1 JOB $0.00
3006 AG Wash/AG San for Aircraft FFP 1 JOB $0.00
3007 AG Wash/AG San for UAS FFP 1 JOB $0.00
Total $0.00
| III Armored Corps, FT Cavazos | |
| 4th Option. 12 Months |
| CLINS: | Level of Service | Est. QTY (Monthly) | Unit | Unit Price | Total Annual Cost |
| 4001 | AG Wash/AG San for Container FFP | 1 | JOB | $0.00 |
4002 AG Wash/AG San for Track Veh FFP 1 JOB $0.00
4003 AG Wash/AG San for Trailer FFP 1 JOB $0.00
4004 AG Wash/AG San for Special Load FFP 1 JOB $0.00
4005 AG Wash/AG San for Wheeled Veh FFP 1 JOB $0.00
4006 AG Wash/AG San for Aircraft FFP 1 JOB $0.00
4007 AG Wash/AG San for UAS FFP 1 JOB $0.00
Total $0.00
Total Contract Value $0.00
Weighted Guidelines
RECORD OF WEIGHTED GUIDELINES APPLICATION REPORT CONTROL SYMBOL
| 1. REPORT NO. | 2. BASIC PROCUREMENT INSTRUMENT IDENTIFICATION NO. | 3. SPIIN | 4. DATE OF ACTION | |||||
| a. PURCHASING OFFICE | b. FY | c. TYPE PROC INST CODE | d. PRISN | TBD | 2024 | JUNE | ||
| W911RX | 2025 | |||||||
| 5. CONTRACTING OFFICE CODE | ITEM | COST CATEGORY | OBJECTIVE |
| 6. NAME OF CONTRACTOR | 13. | MATERIAL | ||||||
| 14. | SUBCONTRACTS | |||||||
| 7. DUNS NUMBER | 8. FEDERAL SUPPLY CODE | 15. | DIRECT LABOR | $ - 0 | ||||
| 16. | INDIRECT EXPENSES | $ - 0 | ||||||
| 9. DOD CLAIMANT PROGRAM | 10. CONTRACT TYPE CODE | 17. | OTHER DIRECT CHARGES | $ - 0 | ||||
| 18. | SUBTOTAL COSTS (13 thru 17) | $ - 0 | ||||||
| 11. TYPE EFFORT | 12. USE CODE | 19. | GENERAL AND ADMINISTRATIVE | $ - 0 | ||||
| 20. | TOTAL COSTS (18 + 19) | $ - 0 | ||||||
| WEIGHTED GUIDELINES PROFIT FACTORS | ||||||||
| ITEM | CONTRACTOR RISK FACTORS | ASSIGNED WEIGHTING | ASSIGNED VALUE | BASE (Item 20) | PROFIT OBJECTIVE | |||
| 21. | TECHNICAL | |||||||
| 22. | MANAGEMENT/COST CONTROL | |||||||
| 23. | PERFORMANCE RISK (COMPOSITE) | $ - 0 | ||||||
| 24. | CONTRACT TYPE RISK | $ - 0 | $ - 0 | |||||
| 25. | WORKING CAPITAL | COSTS FINANCED | LENGTH FACTOR | INTEREST RATE | ||||
| $ - 0 | ||||||||
| CONTRACTOR FACILITIES CAPITAL FINANCED | AMOUNT EMPLOYED | |||||||
| 26. | LAND | $ - 0 | ||||||
| 27. | BUILDINGS | $ - 0 | ||||||
| 28. | EQUIPMENT | 0.0% | $ - 0 | $ - 0 | ||||
| 29. | COST EFFICIENCY FACTOR | ASSIGNED VALUE | BASE (Item 20) | |||||
| $ - 0 | $ - 0 | |||||||
| 30. | TOTAL PROFIT OBJECTIVE | |||||||
| NEGOTIATED SUMMARY | ||||||||
| PROPOSED | OBJECTIVE | NEGOTIATED | ||||||
| 31. | TOTAL COSTS | $ - 0 | ||||||
| 32. | FACILITIES CAPITAL COST OF MONEY (DD Form 1861) | |||||||
| 33. | PROFIT | ERROR:#VALUE! | ||||||
| 34. | TOTAL PRICE (Line 31 + 32 + 33) | $ - 0 | $ - 0 | $ - 0 | ||||
| 35. | MARKUP RATE (Line 32 + 33 divided by 31) | 0.000% | 0.000% | 0.000% | ||||
| CONTRACTING OFFICER APPROVAL | ||||||||
| 36.TYPED/PRINTED NAME OF CONTRACTING OFFICER (Last, First, Middle Initial) | ||||||||
| 37.SIGNATURE OF CONTRACTING OFFICER | 38. TELEPHONE NO. | 39.DATE SUBMITTED |
(YYYYMMDD)
| Richie, Christopher A. | 520-944-0622 | |||
| OPTIONAL USE | ||||
| 96. | 97. | 98. | 99. | |
| DD FORM 1547, JUL 2002 | PREVIOUS EDITION IS OBSOLETE. | |||
| 215.404-72 Modified weighted guidelines method for nonprofit organizations other than FFRDCs. |
| (a) Definition. As used in this subpart, a nonprofit organization is a business entity— | ||
| (1) That operates exclusively for charitable, scientific, or educational purposes; | ||
| (2) Whose earnings do not benefit any private shareholder or individual; | ||
| (3) Whose activities do not involve influencing legislation or political campaigning for any candidate for public office; and | ||
| (4) That is exempted from Federal income taxation under section 501 of the Internal Revenue Code. | ||
| (b) For nonprofit organizations that are entities that have been identified by the Secretary of Defense or a Secretary of a Department as receiving sustaining support on a cost-plus-fixed-fee basis from a particular DoD department or agency, compute a fee objective for covered actions using the weighted guidelines method in 215.404-71, with the following modifications: | ||
| (1) Modifications to performance risk (Blocks 21-23 of the DD Form 1547). | ||
| (i) If the contracting officer assigns a value from the standard designated range (see 215.404-71-2(c)), reduce the fee objective by an amount equal to 1 percent of the costs in Block 20 of the DD Form 1547. Show the net (reduced) amount on the DD Form 1547. | ||
| (ii) Do not assign a value from the technology incentive designated range. | ||
| (2) Modifications to contract type risk (Block 24 of the DD Form 1547). Use a designated range of –1 percent to 0 percent instead of the values in 215.404-71-3. There is no normal value. | ||
| (c) For all other nonprofit organizations except FFRDCs, compute a fee objective for covered actions using the weighted guidelines method in 215.404-71, modified as described in paragraph (b)(1) of this subsection. |
Cost Breakdown
| Labor Estimate | Base Year | FOY1 | FOY2 | FOY3 | FOY4 | FOY5 | TOTAL | |
| Start Date: 09/01/2023 | ||||||||
| Labor | Calculator | |||||||
| Exempt Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Non Exempt Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Labor | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Labor Fringe Benefits | ||||||||
| Exempt Fringe | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Non Exempt Fringe | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Fringe | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Total Labor $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
| Other Direct Charges | ||||||||
| *Major Equipment | 4% Esc | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| *Minor Equipment | 4% Esc | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| *Vehicle Operation | 4% Esc | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| *Rental | 4% Esc | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| *Training & Subcontracts | 4% Esc | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Parts and Supplies for P&P | 4% Esc | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| *IT Support Costs | 4% Esc | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Total Other Direct Charges | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Direct Costs (01+02+03) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| G&A | 14.00% | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Through G&A | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Profit (based on Weighted Guidelines) ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
Total Through Profit ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE!
| (reserved for taxes) | 0.000% | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | |
| MATOC Fee | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | |
| ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! |
| Base Price | Annual | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! |
| Invoice Per Month / Divided by 12 | Monthly | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | |
| Assumptions: | ||||||||
| Hourly median wage referenced from Bureau Labor Statistics (BLS) website. | ||||||||
| Staffing levels and supervisor to worker ratios determined by current staffing levels, current custodial contract. | ||||||||
| City, State tax rate of X.XX% utilized for parts and supplies. | ||||||||
| Signatures: |
&"Arial,Bold"&12&A
Staffing Plan
| FILL IN THIS PAGE FIRST |
| Direct Labor |
| Position / Job # | FTEs | Labor Hours | Wage Rate | Labor Cost | Fringe Cost | Labor + Fringe | Wage Determination / Labor Category Translation | ||||
| Planning & Work Control | Contractor wages | Hourly Wage Rate | |||||||||
| Base Operations | FILL IN THIS PAGE FIRST | ||||||||||
| SCA # | Position | Qty | |||||||||
| On-Site Manager | - 0 | - 0 | - 0 | - 0 | |||||||
| Foreman | - 0 | - 0 | - 0 | - 0 | |||||||
| Technicians | - 0 | - 0 | - 0 | - 0 | O1113 | General Clerk III | 9 | $ 16.82 | 01113 - General Clerk III | ||
| HAZMAT Supervisor | - 0 | - 0 | - 0 | - 0 | |||||||
| Tractor Operator | - 0 | - 0 | - 0 | - 0 | Indirect | Lead | 3 | $ 25.14 | |||
| Total | 0.00 | - 0 | - 0 | - 0 | - 0 |
| Exempt Labor | ERROR:#NAME? | ERROR:#REF! | - 0 | - 0 | - 0 | |
| Non Exempt Labor | ERROR:#NAME? | ERROR:#REF! | - 0 | - 0 | - 0 | |
| Total Labor (check) | ERROR:#NAME? | ERROR:#REF! | $ - 0 | $ - 0 | $ - 0 | - 0 |
Part time employee FTE calculations:
Calculated FTE as a whole. Not calculating PTE for contractor
| Changes V - V: | FTES |
| Added more Custodial, FT |
Added more Grounds FT
Added more Tractor Operator FT
Planning and Work Control Total Direct Staff (FTES) 0.00 Hours - 0
| On-Site Manager | Foreman | Technicians | HAZMAT Supervisor | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | Tractor Operator | ||||||||||||||||
| Line | ERROR:#REF! | |||||||||||||||||||||||||||
| No. | Description | FTE | Proposed | FTE | Proposed | FTE | Proposed | FTE | Proposed | FTE | Proposed | FTE | Proposed | FTE | Proposed | FTE | Proposed | FTE | Proposed | FTE | Proposed | FTE | Proposed | FTE | Proposed | FTE | Proposed | |
| 1 | Nondisabled Labor Hours | |||||||||||||||||||||||||||
| 2 | Total Labor Hours Worked to Produce Service | |||||||||||||||||||||||||||
| (Average Productivity 100.00% (Whole %) Precentage | ||||||||||||||||||||||||||||
| 3 | Average Wage | |||||||||||||||||||||||||||
| 4 | Total Labor Costs | |||||||||||||||||||||||||||
| (Multiply Line 1 by line 3) | ||||||||||||||||||||||||||||
| 5 | Average Hourly Earnings | |||||||||||||||||||||||||||
| (Divide Line 1 by Line 2 and Multiply by Line 3) | ||||||||||||||||||||||||||||
| 6 | Number of Holiday and Vacation and Sick Leave Hours | |||||||||||||||||||||||||||
| (Multiply Total of H-V-S Days by 8 Hours) | ||||||||||||||||||||||||||||
| Holiday | ||||||||||||||||||||||||||||
| Vacation | ||||||||||||||||||||||||||||
| Sick | ||||||||||||||||||||||||||||
| PTO | ||||||||||||||||||||||||||||
| Breavement | ||||||||||||||||||||||||||||
| 7 | Average Work Years | |||||||||||||||||||||||||||
| (Divide Line 2 by 1920 Hours) | ||||||||||||||||||||||||||||
| (Line 2(2080-((Holi+Vac.+Sick+Bereave) x8)) | ||||||||||||||||||||||||||||
| 8 | Health and Welfare Rate ($/Hour) | |||||||||||||||||||||||||||
| 9 | Hourly Earnings plus Health and Welfare | |||||||||||||||||||||||||||
| (Add Lines 5 and 8) | ||||||||||||||||||||||||||||
| 10 | Payroll-Based Expense Rates | |||||||||||||||||||||||||||
| a. FICA | ||||||||||||||||||||||||||||
| b. Unemployment | ||||||||||||||||||||||||||||
| c. Accident Insurance | ||||||||||||||||||||||||||||
| d. Workers Compensation Rate | ||||||||||||||||||||||||||||
| e. Total Payroll Expense Rates | ||||||||||||||||||||||||||||
| 11 | Total Health and Welfare Benefits | |||||||||||||||||||||||||||
| (Multiply Line 2 by Line 8) | ||||||||||||||||||||||||||||
| 12 | Holiday and Vacation and Sick Pay Benefits | |||||||||||||||||||||||||||
| (Multiply Line 6 by Line 7 by Line 9) | ||||||||||||||||||||||||||||
| 13 | Payroll Taxes | |||||||||||||||||||||||||||
| a. On Pay (Multiply Line 4 by Line 10e) | ||||||||||||||||||||||||||||
| b. On Holidays Vacations Sick | ||||||||||||||||||||||||||||
| (Multiply Lines 5 by 6 by 7 by 10e) | ||||||||||||||||||||||||||||
| c. Total Payroll Taxes (Add Lines 13a and 13b) | ||||||||||||||||||||||||||||
| 14 | Other (See Attached Addendum if line 14 is >0) | |||||||||||||||||||||||||||
| 15 | TOTAL FRINGE BENEFITS (ADD 11,12,13c) | |||||||||||||||||||||||||||
| Total Labor Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||||||||||||||
| 16 | Labor Rate / HR | |||||||||||||||||||||||||||
| Fringe Rate % (Check Value): | ERROR:#DIV/0! |
&"Arial,Bold"&A
Major Equipment
| Major Equipment | 5 | |||||||||||||||||
| Line Number | Item Discription | FY put in Service | Useful Life | Quantity | Unit Price | Total Price | Salvage Value | 3% | Salvage Value | % Used on Service | Base Year | FOY1 | FOY2 | FOY3 | FOY4 | 5 Year Cost | Average Annual Cost | |
| Quantity | 1st Replacement Cost Less 50% Salvage | Annual Cost | ||||||||||||||||
| - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||||
| - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||||
| - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||||
| - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||||
| - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||||||
| $ - 0 | ||||||||||||||||||
| - 0 | - 0 | $ - 0 | ||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| $ - 0 | ||||||||||||||||||
| Total Cost: | $ - 0 | |||||||||||||||||
| Total | $ - 0 |
Minor Equipment
| Planned Expenditure | ||||||||||||||
| MINOR EQUIPMENT | 5 | |||||||||||||
| Item Description | Source Name | YR | Qty | Cost Price | Amount | % Used on Service | Base Year | FOY1 | FOY2 | FOY3 | FOY4 | 5 Year Cost | Average Annual Cost | |
| - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||
| - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||
| - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||
| - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||
| - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | $ - 0 | ||||||||
| - 0 | $ - 0 | |||||||||||||
| - 0 | $ - 0 | |||||||||||||
| Taxes= | $ - 0 | - 0 | - 0 | $ - 0 | ||||||||||
| TOTAL | $ - 0 | $ - 0 | $ - 0 |
&"Arial,Bold"&A
Parts and Supplies
| Note | Description | Qty | Unit Price | Subtotal | % Used on Service | Total for Srvice |
| 1 | $ - 0 | $ - 0 | ||||
| 2 | $ - 0 | $ - 0 | ||||
| 3 | $ - 0 | $ - 0 | ||||
| 4 | $ - 0 | $ - 0 | ||||
| 5 | $ - 0 | $ - 0 | ||||
| 6 | $ - 0 | $ - 0 | ||||
| 7 | $ - 0 | $ - 0 | ||||
| 8 | $ - 0 | $ - 0 | ||||
| 9 | $ - 0 | $ - 0 | ||||
| 10 | $ - 0 | $ - 0 | ||||
| 11 | $ - 0 | $ - 0 | ||||
| 12 | $ - 0 | $ - 0 | ||||
| 13 | $ - 0 | $ - 0 | ||||
| 14 | $ - 0 | $ - 0 | ||||
| 15 | $ - 0 | $ - 0 | ||||
| 16 | $ - 0 | $ - 0 | ||||
| Subtotal | $ - 0 | |||||
| State Sales Tax | $ - 0 | |||||
| Total | $ - 0 |
Vehicle Costs
| Vehicles Major Equipment | Vehicle Operation | |||||||||||||||||||||||||||||||||||
| # | Description | Useful Life (years) | Quantity | Unit Price | Total Price | Salvage Value | 0% | % Used on Service | Base Year | FOY1 | FOY2 | FOY3 | FOY4 | Total Cost | Average Annual Cost | No. | Vehicle Description | Fuel | Registration/Insurance | Total | ||||||||||||||||
| 1st Replacement Cost Less 10% Salvage | Quantity | Mileage per Year | MPG | Gallons/Year | Cost/Gallon | % Used for Service | Total Fuel Cost | Yearly Main. Cost | % Used for Service | Total Maint. Cost | Yearly Registration Cost/Vehicle | Yearly Registration Cost | Yearly Insurance Cost/Vehicle | Yearly Insurance Cost | % Used for Service | Total Ins./Reg. Cost | Total Cost/Vehicle | Total Vehicle Cost | ||||||||||||||||||
| years | ||||||||||||||||||||||||||||||||||||
| 1 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | 1 | - 0 | - 0 | - 0 | - 0 | - 0 | ERROR:#DIV/0! | - 0 | ||||||||||||||||||||||||
| 2 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | 2 | - 0 | - 0 | - 0 | - 0 | - 0 | ERROR:#DIV/0! | - 0 | ||||||||||||||||||||||||
| 3 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | 3 | - 0 | - 0 | - 0 | - 0 | - 0 | ERROR:#DIV/0! | - 0 | ||||||||||||||||||||||||
| 4 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | 4 | - 0 | - 0 | - 0 | - 0 | - 0 | ERROR:#DIV/0! | - 0 | ||||||||||||||||||||||||
| 5 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | 5 | - 0 | - 0 | - 0 | - 0 | - 0 | ERROR:#DIV/0! | - 0 | ||||||||||||||||||||||||
| 6 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | 6 | - 0 | - 0 | - 0 | - 0 | - 0 | ERROR:#DIV/0! | - 0 | ||||||||||||||||||||||||
| 7 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | 7 | - 0 | - 0 | - 0 | - 0 | ERROR:#DIV/0! | - 0 | |||||||||||||||||||||||||
| 8 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | 8 | - 0 | - 0 | - 0 | - 0 | ERROR:#DIV/0! | - 0 | |||||||||||||||||||||||||
| 9 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! | 9 | - 0 | - 0 | - 0 | - 0 | ERROR:#DIV/0! | - 0 | |||||||||||||||||||||||||
| Total Cost: | $ - 0 | |||||||||||||||||||||||||||||||||||
| ERROR:#DIV/0! | Total Annual Fuel Cost | $ - 0 | $ - 0 | $ - 0 | Total Cost for Vehicle Maintenance | $ - 0 |
| Note 1: |
| Note 2: |
| Note 3: |
Rental & Insurance
| RENTAL | |||||
| Description | Quantity | Unit | Unit Cost | Rate/Year | NOTES |
Total Costs for Rental
&"Arial,Bold"&U&A
Training & Subcontracts
| Subcontracts | ||||
| Description | Quantity | Unit Price | Rate/Year | NOTES |
Total Costs Training & Subcontracts $ - 0
IT Support Costs
| IT Support Costs | YR put in Service | Useful Life | Quantity | Unit Price | Salvage Value | 3% | % Used on Service | Base Year | FOY1 | FOY2 | FOY3 | FOY4 | |||||
| Part | SUPPLIER | QTY | COST | TOTAL | Quantity | Total Price | 1st Replacement Cost Less 10% Salvage | ||||||||||
| $0.00 | $0.00 | 100% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||
| $0.00 | $0.00 | 100% | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | |
| $ - 0 |
&A image1.jpeg
File details come from the government source that posted it. Updated .