Exhibit B - Price Table Workbook (updated 20NOV24) W911RX24R0011.xlsx
XLSX spreadsheet 104 KB Posted
- Solicitation number
- W911RX24R0011
About this file
This is a pricing workbook template for a contract opportunity at Fort Hood for Agricultural Sanitation (AGSAN) Services. The workbook contains CLIN structures for a base year and four option years, with each period having three CLINs: Mobilization-Demobilization, AGSAN Services, and Equipment & ODCs. The template includes detailed worksheets for labor calculations, staffing plans, major/minor equipment costs, parts and supplies, vehicle costs, rental and insurance, and training and subcontracts.
The workbook incorporates weighted guidelines calculations for profit determination and includes sections for G&A costs (set at 14%), labor fringe benefits, and direct/indirect labor costs. The template appears to be designed for a firm-fixed-price contract structure, with provisions for calculating monthly invoice amounts. While the workbook structure is complete, no actual pricing data is filled in, with most cells showing $0.00 or blank values.
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 Mobilization-Demobilization 1 JOB $0.00
0002 AGSAN Services 1 JOB $0.00
0003 Equipment & ODCs 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 | Mobilization-Demobilization | 1 | JOB | $0.00 |
1002 AGSAN Services 1 JOB $0.00
1003 Equipment & ODCs 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 | Mobilization-Demobilization | 1 | JOB | $0.00 |
2002 AGSAN Services 1 JOB $0.00
2003 Equipment & ODCs 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 |
| 3001 | Mobilization-Demobilization | 1 | JOB | $0.00 |
3002 AGSAN Services 1 JOB $0.00
3003 Equipment & ODCs 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 | Mobilization-Demobilization | 1 | JOB | $0.00 |
4002 AGSAN Services 1 JOB $0.00
4003 Equipment & ODCs 1 JOB $0.00
Total $0.00
Total Contract Value ERROR:#NAME?
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! | |
| 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
File details come from the government source that posted it. Updated .