Atch_7_-_Pricing_Spreadsheet_-_NNSY_revised_9-6-18.xlsx
XLSX spreadsheet 19 KB Posted
- Attached to
- Boat Preventative Maintenance and Repairs
- Solicitation number
- N0018918Q0241
About this file
Atch_7_-_Pricing_Spreadsheet_-_NNSY_revised_9-6-18.xlsx
View the file
Other files
| File | Type | Posted |
|---|---|---|
| N0018918Q0241-0003.docx | DOCX document | |
| Questions_and_Answers__N0018918Q0241.docx | DOCX document | |
| N0018918Q0241-0002.docx | DOCX document | |
| N0018918Q0241-0001.docx | DOCX document | |
| Atch_2_-_PM_TDL_Template.docx | DOCX document | |
| N0018918Q0241.docx | DOCX document | |
| Atch_3_-_Repair_TDL_Template.docx | DOCX document | |
| Atch_1_-_WD_2015-4341_Rev_-10.txt | TXT text file |
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
PM Pricing Spreadsheet
| NNSY BOAT PREVENTATIVE MAINTENANCE PRICING SPREADSHEET | Base Period 1 | FAR 52.217-8 | Total | |||||
| TASK | Objective | Days After TDL | UOI | Job Cost | Total Cost | Job Cost | Total Cost | |
| 1.1 | TRAILERS QUARTERLY INSPECTION EVERY 3 MONTHS | 1 | 12 | $1.00 | $12.00 | $1.00 | $12.00 | $24.00 |
| 1.2 | TRAILERS ANNUAL INSPECTION EVERY 12 MONTHS | 0 | 4 | $1.00 | $4.00 | $1.00 | $4.00 | $8.00 |
| 2.1 | QUARTERLY EVERY 3 MONTHS | 0 | 8 | $1.00 | $8.00 | $1.00 | $8.00 | $16.00 |
| 2.2 | F/O TANKS , CLEAN & INSPECT - EVERY 12 MONTHS | 0 | 0 | $1.00 | $0.00 | $1.00 | $0.00 | $0.00 |
| 2.3 | ULTRA-SONIC NON-DESTRUCTIVE TESTING - AS REQUIRED | 0 | 0 | $1.00 | $0.00 | $1.00 | $0.00 | $0.00 |
| 2.4 | HYBRID FOAM COLLAR SYSTEM - AS REQUIRED | 0 | 0 | $1.00 | $0.00 | $1.00 | $0.00 | $0.00 |
| 3.1 | BOAT U/W HULL INSPECT, REPAIR AND PRESERVE - EVERY 12 MONTHS | 0 | 0 | $1.00 | $0.00 | $1.00 | $0.00 | $0.00 |
| 3.2 | BOAT FREEBOARD, INSPECT, REPAIR & PRESERVE - EVERY 12 MONTHS | 0 | 0 | $1.00 | $0.00 | $1.00 | $0.00 | $0.00 |
| 3.3 | PILOT HOUSE EXTERIOR INSPECT & PRESERVE - EVERY 24 MONTHS | 0 | 0 | $1.00 | $0.00 | $1.00 | $0.00 | $0.00 |
| 3.4 | NON-SKID REMOVE & RENEW AND MAIN DECK PRESERVE - EVERY 24 MONTHS | 0 | 0 | $1.00 | $0.00 | $1.00 | $0.00 | $0.00 |
| 4.1 | FIRE SUPPRESSION SYSTEM - EVERY 6 MONTHS | 0 | 8 | $1.00 | $8.00 | $1.00 | $8.00 | $16.00 |
| 4.2 | FUEL SYSTEM INSPECT - EVERY 6 MONTHS | 0 | 8 | $1.00 | $8.00 | $1.00 | $8.00 | $16.00 |
| 4.3 | COMMUNICATION SYSTEMS INSPECT - EVERY 6 MONTHS | 0 | 8 | $1.00 | $8.00 | $1.00 | $8.00 | $16.00 |
| 4.4 | INTEGRATED ELECTRONIC NAVIGATION INSPECT - EVERY 12 MONTHS | 0 | 4 | $1.00 | $4.00 | $1.00 | $4.00 | $8.00 |
| 4.5 | HYDRAULIC STEERING SYSTEM - EVERY 6 MONTHS | 0 | 16 | $1.00 | $16.00 | $1.00 | $16.00 | $32.00 |
| 4.6.1 | EPIRB QUARTERLY - EVERY 3 MONTHS | 0 | 12 | $1.00 | $12.00 | $1.00 | $12.00 | $24.00 |
| 4.6.2 | EPIRB BIENNIAL - EVERY 2 YEARS | 0 | 0 | $1.00 | $0.00 | $1.00 | $0.00 | $0.00 |
| 4.6.3 | EPIRB QUINQUENIAL - EVERY 5 YEARS | 0 | 0 | $1.00 | $0.00 | $1.00 | $0.00 | $0.00 |
| 4.7 | MARINE AIR SYSTEM - MONTHLY | 0 | 36 | $1.00 | $36.00 | $1.00 | $36.00 | $72.00 |
| 5 | ELECTRICAL FEED AND SUPPLY - EVERY 6 MONTHS | 0 | 8 | $1.00 | $8.00 | $1.00 | $8.00 | $16.00 |
| 6.1 | PROPULSION OUTBOARD MAINTENANCE- 20 HOURS BREAK-IN | 0 | 3 | $1.00 | $3.00 | $1.00 | $3.00 | $6.00 |
| 6.2 | PROPULSION OUTBOARD MAINTENANCE- EVERY 100 HOURS | 0 | 16 | $1.00 | $16.00 | $1.00 | $16.00 | $32.00 |
| 6.3 | PROPULSION OUTBOARD MAINTENANCE- EVERY 200 HOURS | 0 | 8 | $1.00 | $8.00 | $1.00 | $8.00 | $16.00 |
| 6.4 | PROPULSION OUTBOARD MAINTENANCE- EVERY 400 HOURS | 0 | 8 | $1.00 | $8.00 | $1.00 | $8.00 | $16.00 |
| 6.5 | PROPULSION OUTBOARD MAINTENANCE- EVERY 1,200 HOURS | 0 | 8 | $1.00 | $8.00 | $1.00 | $8.00 | $16.00 |
| 7.1 | GENERATOR MAINTENANCE INITIAL 50 HOURS | 0 | 3 | $1.00 | $3.00 | $1.00 | $3.00 | $6.00 |
| 7.2 | GENERATOR MAINTENANCE - EVERY 100 HOURS | 0 | 20 | $1.00 | $20.00 | $1.00 | $20.00 | $40.00 |
| 7.3 | GENERATOR MAINTENANCE - EVERY 200 HOURS | 0 | 16 | $1.00 | $16.00 | $1.00 | $16.00 | $32.00 |
| 7.4 | GENERATOR MAINTENANCE - EVERY 500 HOURS | 0 | 8 | $1.00 | $8.00 | $1.00 | $8.00 | $16.00 |
| 7.5 | GENERATOR MAINTENANCE - EVERY 1,000 HOURS | 0 | 8 | $1.00 | $8.00 | $1.00 | $8.00 | $16.00 |
| 8 | TRANSPORTATION | 0 | 60 | $1.00 | $60.00 | $1.00 | $60.00 | $120.00 |
| SubTotal | $282.00 | $282.00 | $564.00 | |||||
| 0 | ||||||||
| * | Contractor shall quote on each specific task line item as a complete job to include labor and parts | |||||||
| * | Task 1.1 is provided as an example. Please remove example pricing and update accodrdingly | |||||||
| * | DO NOT CHANGE ANY UNITS OF ISSUE (UOI). CONTRACTORS SHALL ONLY INPUT EACH TASK JOB COST AND HOURLY RATES FOR REPAIRS ON SECOND PAGE. | CLIN 1001 - PM's | $282.00 | |||||
| * | PLEASE PROVIDE JOB COST EVEN IF UOI IS ZERO. | CLIN 1002 - Repairs | $500.00 | |||||
| * | FAR 52.217-8 COLUMN TOTAL WILL BE DIVIDED BY 2 TO OBTAIN 6 MONTH PRICING | SubTotal | $782.00 | |||||
| 52.217-8 | CLIN 2001 - PM's | $141.00 | ||||||
| 52.217-8 | CLIN 2002 - Repairs | $250.00 | ||||||
| SubTotal | $391.00 | |||||||
| Total | $1,173.00 |
Hourly Rate Repair Spreadsheet
| Repairs | Total | ||||
| Labor Category | Base Year | FAR 52.217-8 | |||
| Motor Vehicle Mechanic | Estimated Hours | Hourly Rate | Estimated Hours | Hourly Rate | |
| 500 | $1.00 | 250 | $1.00 | ||
| SubTotal | $500.00 | $250.00 | $750.00 |
| Repairs | $500.00 |
| 52.217-8, 6 month extension | $250.00 |
| Total | $750.00 |
Quoters shall provide repair parts/materials at cost (to include any shipping or handling fees) and provide documentation of price paid for each repair part (to include any shipping or handling fees). Contractor is responsible for obtaining and providing repair parts to the government at the lowest discounted price available. Mark-up of repair parts will not be allowed. Hourly rate is provided as an example. Please remove example and update accordingly.
File details come from the government source that posted it.