C8 N4523A26Q1001 YT-810 Attachment 2 Price Worksheet.xlsx

95 KB Posted

Attached to
Maintenance, Repair, and Preservation of YT-810
Solicitation number
N4523A26Q1001
Issued by

About this file

Written by GovTribe AI ·

This document is a Price Worksheet Excel file for a naval vessel maintenance contract (N4523A26Q1001) for the YT-810 Harbor Tug. The spreadsheet provides a detailed template for contractors to submit pricing information, with specific instructions for completing labor rate calculations, labor category details, and cost breakdowns across multiple work package line items. Contractors are required to fill out yellow-highlighted cells with labor rates, hours, and cost information, including regular and overtime labor hours, direct labor rates, fringe benefits, overhead, G&A, profit, and other direct costs.

The pricing worksheet covers an extensive range of maintenance and repair activities for the vessel, including hull preservation, tank inspections, deck repairs, lighting system repairs, hydraulic system modifications, sea trials, and other technical services. The document is designed to capture comprehensive labor and material costs for each specific task outlined in the contract, with auto-calculating formulas to help contractors systematically price their proposed work for the Puget Sound Naval Shipyard and Intermediate Maintenance Facility.

View the file

Other files

File Type Posted
C9 N4523A26Q1001 YT-810 RFC Answers 1-8.pdf PDF
C9 N4523A26Q1001 YT-810 Amendment 0003 - RFC Answers 1-7.pdf PDF
C9 N4523A26Q1001 YT-810 Amendment 0003.pdf PDF
C8 N4523A26Q1001 YT-810 Attachment 2 Price Worksheet UPDATED.xlsx XLSX spreadsheet
C9 N4523A26Q1001 YT-810 Attachment 1 Statement of Work - Errata 2.pdf PDF
C9 N4523A26Q1001 YT-810 Amendment 0002.pdf PDF
C9 N4523A26Q1001 YT-810 Amendment 0002 - RFC Answers 1-5.pdf PDF
C9 N4523A26Q1001 YT-810 Amendment 0001 - RFC Answers 1.pdf PDF
C9 N4523A26Q1001 YT-810 Attachment 1 Statement of Work - Errata 1.pdf PDF
C9 N4523A26Q1001 YT-810 Amendment 0001.pdf PDF
C8 N4523A26Q1001 YT-810 Attachment 4 Past Performance.docx DOCX document
C8 N4523A26Q1001 YT-810 Exhibit A CDRLs and DIDs Request.pdf PDF
C8 N4523A26Q1001 YT-810 Attachment 1 Statement of Work.pdf PDF
C8 N4523A26Q1001 YT-810 Exhibit B GFP Attachment.pdf PDF
C8 N4523A26Q1001 Solicitation.pdf PDF
C8 N4523A26Q1001 YT-810 Attachment 8 Growth Management Request Form.docx DOCX document
C8 N4523A26Q1001 YT-810 Attachment 7 BAVR Instructions.pdf PDF
C8 N4523A26Q1001 YT-810 Attachment 3 RFC Form.docx DOCX document
C8 N4523A26Q1001 YT-810 Attachment 5 Corporate Experience.docx DOCX document
C8 N4523A26Q1001 YT-810 Attachment 9 Growth Management Program Tracking Log.xlsx XLSX spreadsheet
C8 N4523A26Q1001 YT-810 Attachment 6 Drawings Request.pdf PDF
Show all 21

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instruction Sheet

Instructions for Contractors for Filling-out J-2 Price Proposal Worksheet

All yellow fields are to be filled out by the Contractor prior to submittal to The Government.
DO NOT FILL IN ANY CELL THAT IS NOT BRIGHT YELLOW.
Labor Mix & Rates Sheet
1Enter Company Name and Date
2Fill in each rate in its applicable yellow cell
3Fill in each labor category and ensure all yellow boxes are filled in
a.Example Labor Categories
Shipfitter
Sheetmetal
Welder/Burer
Electrician
Inside Machinist
Outside Machinist
Boilermaker
Pipefitter
Insulator/Lagger
Shipwright/Carpenter
EX/Ord
Painter/Blaster
Rigger/Laborer
QA/NDT
4Next, fill in each yellow cell for Regular Labor Hours and Overtime Labor Hours
5Your Total Direct Labor Rate Per Hour will autopopulate in each sheet. All other rates entered will also auto populate.
Price Proposal Worksheet
1All company and contract information and rates will be autopopulated from previous sheet.
2Fill in each yellow cell with its applicable information
3Anything that is not in yellow is locked, these cells will auto-calculate.
4Before submitting, ensure there are no more bright yellow cells.
IF USING FCCOM
Facilities Capital Cost of Money (FCCOM) is not required. If you are not inputting FCCOM please enter N/A in all cells. However, if your company is inputting FCCOM, it needs to be calculated based on the proper CASB-CMF form. Please include the CASB-CMF form with your submission.
Labor Hour Breakdown
1Enter each labor categoy will autofill from the "labor Mix & Rates" sheet
2Fill in each Regular and Overtime hour for each labor category and line item.

Labor Mix & Rates

Contractor/Company Name:
Project/Vessel Name:YT-810Date:

Base Rates: Regular Labor ERROR:#DIV/0! Fringe Overhead G&A Profit FCCOM

Labor Mix and Rates

Labor Category Regular Hours Overtime Hours Total Category Hours Total Regular $/hour Total Overtime $/hour Total Category Dollars

0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
0$0.00
Column Totals000$0.00$0.00$0.00

Direct Labor Rate Per Hour ERROR:#DIV/0!

Example Labor Categories Shipfitter Sheetmetal Welder/Burer Electrician Inside Machinist Outside Machinist Boilermaker Pipefitter Insulator/Lagger Shipwright/Carpenter EX/Ord Painter/Blaster Rigger/Laborer QA/NDT

YT-810

Contractor/Company Name:0
Project/Vessel Name:YT-810Date:12/31/99

Base Rates: Labor ERROR:#DIV/0! Fringe 0.00% Overhead 0.00% G&A 0.00% Profit 0.00% FCCOM 0.00%

Base Work Package Proposal
PARAGRAPH No.TITLEPRIMESUBCONTRACTOROther Direct Cost (ODC)*PRIMELine Item Total
M/HLabor CostMATERIAL PRICETOTALM/HLabor CostMaterial CostTOTALODCTravel ODCTOTALFringeOverheadG&AProfitFCCOM
1.4Arrival ConferenceERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
1.5Required DocumentsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
1.6Progress MeetingsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
1.7Availability RequirementsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
1.7.1Transportation of VesselERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
1.7.2Provide Metered Electrical ServiceERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
1.7.3Provide Office SpaceERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
1.8Care of VesselERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
1.14Hot Work/WeldingERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
1.16Preservation RequirementsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
1.17Environmental & Hazwaste ManagementsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
1.18MaterialsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
1.19Weight ControlERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
1.21Integrated Logistic SupportERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
1.22Gas FreeERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
1.23General Requirements for TestingERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
1.25Compartment Arrival/Closeout InspectionsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.1.1Personnel and EquipmentERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.1.2Docking ProceduresERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.1.3Blocking PlanERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.1.4Crib and Brace BlockingERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.1.5Setting and Alignment of Docking BlocksERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.1.6Stability CalculationsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.1.7Docking ConferenceERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.1.8Docking the VesselERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.1.9Post DockingERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.1.10Shifting the VesselERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.1.11Undocking the VesselERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.1.13Final Docking ReportERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.2.1Identify Distinguishing Figures and MarkingsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.2.2Rubber FendersERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.2.3Zinc AnodesERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.2.4Hull Blasting and PreservationERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.2.5Hull and Freeboard Visual InspectionERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.2.6Hull and Freeboard Ultrasonic Test (UT) InspectionERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.3.2Rubber Fender Retention ModificationERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.3.3Stern Rubber Fender StrapsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.3.4Bow Rubber Fender StrapsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.4.1Black Water Tank PCPERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.4.2Open, Pump, Clean, Ventilate, and Gas Free Tanks/VoidsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.4.3Tank Visual Inspection (VT)ERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.4.4Identify Color Schemes and MarkingsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.4.5Preliminary Air TestERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.4.6Install Access CoversERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.4.7Clean, Flush, and Disinfect Potable Water SystemERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.4.8Certification of Potable Water Piping and TankERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.4.9Final Air TestERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.4.10Tank/Void Closeout InspectionERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.4.11On-Load FuelERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.5.1Main Deck Non-skid RepairERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.5.2Visual Inspection for Structural DefectsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.5.3Ultrasonic (UT) InspectionERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.6.1Deckhouse PreservationERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.6.2Bridge Deck Non-skid RepairERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.6.3Deckhouse Expansion Joint RepairsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.6.4Stack Tip ModificationERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.6.5Brow Hydraulic Hose RepairERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.6.6Mast Hydraulic Hose RepairERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.7.1Schottel Z-Drive RepairERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.7.2Power Transmission RepairERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.7.3Hydraulic Systems RepairERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.7.4Propeller RepairsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.10.1Hull/Engine Room Bilge Impressed Anode RepairsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
ERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
ERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
ERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Mast Lighting and Deckhouse Lighting RepairsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
ERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
ERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
ERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
ERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
ERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
ERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
ERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
ERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.10.2Mast Lighting and Deckhouse Lighting RepairsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.10.3Automatic Voltage Regulator Installation (YT-808-0109D)ERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.11.1Sea ValvesERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.11.2Winch Control Piping Modification (YT-0104D)ERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.11.3Potable WaterHose Bibb Drain Valve Installation (YT-0107D)ERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.12.1Deck Winch Hose RepairsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.13.1Operational ResponsibilityERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.13.2Sea Trial Baseline TestingERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.13.3Dock TrialsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.13.4Sea TrialsERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3.13.5Post Sea TrialERROR:#DIV/0!ERROR:#DIV/0!$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
ERROR:#DIV/0!$0.00$0.00$0.00$0.00$0.00$0.00$0.00
ERROR:#DIV/0!$0.00$0.00$0.00$0.00$0.00$0.00$0.00
ERROR:#DIV/0!$0.00$0.00$0.00$0.00$0.00$0.00$0.00
ERROR:#DIV/0!$0.00$0.00$0.00$0.00$0.00$0.00$0.00
ERROR:#DIV/0!$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Column Totals0ERROR:#DIV/0!$0.00ERROR:#DIV/0!$0.00$0.00$0.00$0.00$0.00$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!

Base Work Package ERROR:#DIV/0!

Level of Effort to Completion
PARAGRAPH No.TITLEM/HLabor CostMATERIAL PRICETOTALM/HLabor CostMaterial CostTOTALODCTravel ODCTOTALFringeOverheadG&AProfitFCCOMLine Item Total
Level of Effort (LOE) to Completion - Growth4,401ERROR:#DIV/0!$35,970.34ERROR:#DIV/0!$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Column Totals4,401ERROR:#DIV/0!$35,970.34ERROR:#DIV/0!$0.00ERROR:#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.00ERROR:#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.00ERROR:#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.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Column Totals8802ERROR:#DIV/0!$71,940.68ERROR:#DIV/0!0$0.00ERROR:#DIV/0!$0.00$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!

Total LOE to Completion: ERROR:#DIV/0!

TOTAL PROPOSED PRICE: ERROR:#DIV/0!

ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Column Totals0ERROR:#DIV/0!$0.00ERROR:#DIV/0!$0.000ERROR:#DIV/0!$0.00$0.00$0.00ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!

Total Option Items (O): ERROR:#DIV/0!

TOTAL PROPOSED PRICE: ERROR:#DIV/0!

Total LOE to Completion: ERROR:#DIV/0!

TOTAL PROPOSED PRICE: ERROR:#DIV/0!

*ODC-Defined as anything other than labor, subcontracts, and/or material that is directly attributable to a contract per FAR 31.202. Examples include rental charges and travel etc.

NOTE: Please fill in within the yellow highlighted boxes, the fixed labor rate, proposed G&A and proposed Profit rates.

NOTE: Labor rates and Profit rates used to calculate for the overall price of the base contract award shall be the basis for pricing on all modifications under this contract.

*ODC-Defined as anything other than labor, subcontracts, and/or material that is directly attributable to a contract per FAR 31.202. Examples include rental charges and travel etc.

NOTE: Please fill in within the yellow highlighted boxes, the fixed labor rate, proposed G&A and proposed Profit rates.

NOTE: Labor rates and Profit rates used to calculate for the overall price of the base contract award shall be the basis for pricing on all modifications under this contract.

*ODC-Defined as anything other than labor, subcontracts, and/or material that is directly attributable to a contract per FAR 31.202. Examples include rental charges and travel etc.

NOTE: Please fill in within the yellow highlighted boxes, the fixed labor rate, proposed G&A and proposed Profit rates.

NOTE: Labor rates and Profit rates used to calculate for the overall price of the base contract award shall be the basis for pricing on all modifications under this contract.

Labor Hour Breakdown

Contractor/Company Name:0
Project/Vessel Name:YT-810Date:12/31/99
Base Rates:Regular Labor RateERROR:#DIV/0!
NameRateTotal CostNameRateTotal Cost
Labor Hour Breakdown
PARAGRAPH No.TITLELabor CategoriesTotal Overall Labor Cost
000000000000000000Total Regular HoursTotal Overtime Hours
REGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOT
1.4Arrival Conference00ERROR:#DIV/0!
1.5Required Documents00ERROR:#DIV/0!
1.6Progress Meetings00ERROR:#DIV/0!
1.7Availability Requirements00ERROR:#DIV/0!
1.7.1Transportation of Vessel00ERROR:#DIV/0!
1.7.2Provide Metered Electrical Service00ERROR:#DIV/0!
1.7.3Provide Office Space00ERROR:#DIV/0!
1.8Care of Vessel00ERROR:#DIV/0!
1.14Hot Work/Welding00ERROR:#DIV/0!
1.16Preservation Requirements00ERROR:#DIV/0!
1.17Environmental & Hazwaste Managements00ERROR:#DIV/0!
1.18Materials00ERROR:#DIV/0!
ERROR:#REF!ERROR:#REF!00ERROR:#DIV/0!
1.21Integrated Logistic Support00ERROR:#DIV/0!
ERROR:#REF!Gas Free00ERROR:#DIV/0!
1.25Compartment Arrival/Closeout Inspections00ERROR:#DIV/0!
3.1.1Personnel and Equipment00ERROR:#DIV/0!
3.1.2Docking Procedures00ERROR:#DIV/0!
3.1.3Blocking Plan00ERROR:#DIV/0!
3.1.5Setting and Alignment of Docking Blocks00ERROR:#DIV/0!
3.1.6Stability Calculations00ERROR:#DIV/0!
ERROR:#REF!ERROR:#REF!00ERROR:#DIV/0!
3.1.7Docking Conference00ERROR:#DIV/0!
ERROR:#REF!ERROR:#REF!00ERROR:#DIV/0!
3.1.8Docking the Vessel00ERROR:#DIV/0!
3.1.9Post Docking00ERROR:#DIV/0!
3.1.10Shifting the Vessel00ERROR:#DIV/0!
3.1.11Undocking the Vessel00ERROR:#DIV/0!
3.1.13Final Docking Report00ERROR:#DIV/0!
3.2.1Identify Distinguishing Figures and Markings00ERROR:#DIV/0!
ERROR:#REF!ERROR:#REF!00ERROR:#DIV/0!
3.2.2Rubber Fenders00ERROR:#DIV/0!
ERROR:#REF!ERROR:#REF!00ERROR:#DIV/0!
3.2.3Zinc Anodes00ERROR:#DIV/0!
3.2.4Hull Blasting and Preservation00ERROR:#DIV/0!
ERROR:#REF!ERROR:#REF!00ERROR:#DIV/0!
3.2.5Hull and Freeboard Visual Inspection00ERROR:#DIV/0!
3.2.6Hull and Freeboard Ultrasonic Test (UT) Inspection00ERROR:#DIV/0!
ERROR:#REF!ERROR:#REF!00ERROR:#DIV/0!
3.3.2Rubber Fender Retention Modification00ERROR:#DIV/0!
3.3.3Stern Rubber Fender Straps00ERROR:#DIV/0!
3.3.4Bow Rubber Fender Straps00ERROR:#DIV/0!
3.4.1Black Water Tank PCP00ERROR:#DIV/0!
3.4.2Open, Pump, Clean, Ventilate, and Gas Free Tanks/Voids00ERROR:#DIV/0!
3.4.3Tank Visual Inspection (VT)00ERROR:#DIV/0!
3.4.4Identify Color Schemes and Markings00ERROR:#DIV/0!
ERROR:#REF!ERROR:#REF!00ERROR:#DIV/0!
3.4.5Preliminary Air Test00ERROR:#DIV/0!
3.4.6Install Access Covers00ERROR:#DIV/0!
3.4.7Clean, Flush, and Disinfect Potable Water System00ERROR:#DIV/0!
3.4.8Certification of Potable Water Piping and Tank00ERROR:#DIV/0!
3.4.9Final Air Test00ERROR:#DIV/0!
ERROR:#REF!ERROR:#REF!00ERROR:#DIV/0!
3.4.10Tank/Void Closeout Inspection00ERROR:#DIV/0!
3.4.11On-Load Fuel00ERROR:#DIV/0!
ERROR:#REF!ERROR:#REF!00ERROR:#DIV/0!
0000ERROR:#DIV/0!
0000ERROR:#DIV/0!
0Mast Lighting and Deckhouse Lighting Repairs00ERROR:#DIV/0!
0000ERROR:#DIV/0!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!$0.00ERROR:#REF!
Column Totals00000000000000000000000000000000000000ERROR:#DIV/0!

Base Work Package ERROR:#DIV/0!

OPTION YEAR TABLE IF NEEDED:

Labor Hour Breakdown
PARAGRAPH No.TITLELabor CategoriesTotal Overall Labor Cost
000000000000000000Total Direct HoursTotal Overtime Hours
REGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOTREGOT
0000ERROR:#DIV/0!
0000ERROR:#DIV/0!
0000ERROR:#DIV/0!
0000ERROR:#DIV/0!
Column Totals00000000000000000000000000000000000000ERROR:#DIV/0!

Total Option Items (O): ERROR:#DIV/0!

TOTAL DIRECT LABOR COSTS BY WORK ITEM ERROR:#DIV/0!

File details come from the government source that posted it. Updated .