Attachment 0007 - Sample Price Breakdown Worksheet with Rates.xlsx

XLSX spreadsheet 37 KB Posted

Attached to
Construction Inspection Services (Amendment 0001) Federal contract opportunity
Solicitation number
86615621Q00002
Issued by
Department of Housing and Urban Development

About this file

This document contains a sample price breakdown worksheet with rates for a federal construction inspection services contract opportunity. The solicitation is set aside for 8(a) small businesses and seeks fixed price quotations for inspection services across three regions of the continental United States for a one year base period plus four one year options. Inspection tasks include routine checks of eight construction groups in each region as well as incentives and transition periods. Offerors must provide fully loaded hourly rates for prime and subcontractor inspectors. The total evaluated price will be based on these rates and estimated hours. Responses are due by December 14, 2020 to the Department of Housing and Urban Development.

View the file

Other files for this federal contract opportunity

Other files attached to Construction Inspection Services (Amendment 0001), newest first.
File Type Posted
Amendment 86615621Q00002-0001.pdf PDF
Attachment 0002 - Quality Assurance Surveillance Plan (QASP).doc DOC document
Attachment 0005 - Description Region 3.doc DOC document
Attachment 0004 - Description Region 2.doc DOC document
Attachment 0003 - Description Region 1.doc DOC document
Attachment 0001 - Performance Work Statement.doc DOC document
Attachment 0006 - Sample Labor Category - Hours Breakdown Worksheet Without Rates.xlsx XLSX spreadsheet
RFQ 86615621Q00002.pdf PDF

On GovTribe

Work with this file on GovTribe

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

Text version

BASE

Attachment 0007 – Sample Price Breakdown Worksheet with Rates 86615621Q00002
BASE PERIOD: 12 Months
Task: 0001 - Routine Inspections- Group 1 (Region 1)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.0025$ 475.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.0025$ 475.00
$ - 0
$ - 0
$ - 0
Total Labor$ 950.00
Task: 0002 - Routine Inspections- Group 2 (Region 1)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.005$ 95.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.003$ 57.00
$ - 0
$ - 0
$ - 0
Total Labor$ 152.00
Task: 0003 - Routine Inspections - Group 3 (Region 1)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.006$ 114.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.008$ 152.00
$ - 0
$ - 0
$ - 0
Total Labor$ 266.00
Task: 0004 - Routine Inspections - Group 4 (Region 2)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.009$ 171.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.003$ 57.00
$ - 0
$ - 0
$ - 0
Total Labor$ 228.00
Task: 0005 - Routine Inspections - Group 5 (Region 2)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.006$ 114.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.007$ 133.00
$ - 0
$ - 0
$ - 0
Total Labor$ 247.00
Task: 0006 - Routine Inspections - Group 6 (Region 2)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.008$ 152.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.003$ 57.00
$ - 0
$ - 0
$ - 0
Total Labor$ 209.00
Task: 0007 - Routine Inspections - Group 7 (Region 3)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.006$ 114.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.008$ 152.00
$ - 0
$ - 0
$ - 0
Total Labor$ 266.00
Task: 0008 - Routine Inspections - Group 8 (Region 3)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.005$ 95.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.002$ 38.00
$ - 0
$ - 0
$ - 0
Total Labor$ 133.00
Task: 0009 - Incentives - Routine Inspections (3 percent)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.006$ 114.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.002$ 38.00
$ - 0
$ - 0
$ - 0
Total Labor$ 152.00
Task: 0010 - Transition-In and Quality Assurance Control Plan
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.0010$ 190.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.005$ 95.00
$ - 0
$ - 0
$ - 0
Total Labor$ 285.00
Total Base Price$ 2,888.00
NOTE:
Quoter must also provide a breakdown of costs by task (labor category, hours & rate)
This list will be used to understand the contractor's methodology
Rates must be fully loaded and must be inclusive of escalation rates per year, fringe, overhead, training, G&A, and fee/profit.
** Round total to whole numbers (example: $201,750.00); do not use decimals places (example: $201,750.50)

Sample Price Breakdown Worksheet &"-,Bold"With Rates Attachment 001

OPTION 1

Attachment 0007 – Sample Price Breakdown Worksheet with Rates 86615621Q00002
OPTION 1: 12 Months
Task: 0001 - Routine Inspections- Group 1 (Region 1)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.0025$ 475.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.0025$ 475.00
$ - 0
$ - 0
$ - 0
Total Labor$ 950.00
Task: 0002 - Routine Inspections- Group 2 (Region 1)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.005$ 95.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.003$ 57.00
$ - 0
$ - 0
$ - 0
Total Labor$ 152.00
Task: 0003 - Routine Inspections - Group 3 (Region 1)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.006$ 114.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.008$ 152.00
$ - 0
$ - 0
$ - 0
Total Labor$ 266.00
Task: 0004 - Routine Inspections - Group 4 (Region 2)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.009$ 171.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.003$ 57.00
$ - 0
$ - 0
$ - 0
Total Labor$ 228.00
Task: 0005 - Routine Inspections - Group 5 (Region 2)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.006$ 114.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.007$ 133.00
$ - 0
$ - 0
$ - 0
Total Labor$ 247.00
Task: 0006 - Routine Inspections - Group 6 (Region 2)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.008$ 152.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.003$ 57.00
$ - 0
$ - 0
$ - 0
Total Labor$ 209.00
Task: 0007 - Routine Inspections - Group 7 (Region 3)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.006$ 114.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.008$ 152.00
$ - 0
$ - 0
$ - 0
Total Labor$ 266.00
Task: 0008 - Routine Inspections - Group 8 (Region 3)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.005$ 95.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.002$ 38.00
$ - 0
$ - 0
$ - 0
Total Labor$ 133.00
Task: 0009 - Incentives - Routine Inspections (3 percent)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.006$ 114.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.002$ 38.00
$ - 0
$ - 0
$ - 0
Total Labor$ 152.00
Total Base Price$ 2,603.00
NOTE:
Quoter must also provide a breakdown of costs by task (labor category, hours & rate)
This list will be used to understand the contractor's methodology
Rates must be fully loaded and must be inclusive of escalation rates per year, fringe, overhead, training, G&A, and fee/profit.
** Round total to whole numbers (example: $201,750.00); do not use decimals places (example: $201,750.50)

OPTION 2

Attachment 0007 – Sample Price Breakdown Worksheet with Rates 86615621Q00002
OPTION 2: 12 Months
Task: 0001 - Routine Inspections- Group 1 (Region 1)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.0025$ 475.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.0025$ 475.00
$ - 0
$ - 0
$ - 0
Total Labor$ 950.00
Task: 0002 - Routine Inspections- Group 2 (Region 1)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.005$ 95.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.003$ 57.00
$ - 0
$ - 0
$ - 0
Total Labor$ 152.00
Task: 0003 - Routine Inspections - Group 3 (Region 1)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.006$ 114.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.008$ 152.00
$ - 0
$ - 0
$ - 0
Total Labor$ 266.00
Task: 0004 - Routine Inspections - Group 4 (Region 2)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.009$ 171.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.003$ 57.00
$ - 0
$ - 0
$ - 0
Total Labor$ 228.00
Task: 0005 - Routine Inspections - Group 5 (Region 2)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.006$ 114.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.007$ 133.00
$ - 0
$ - 0
$ - 0
Total Labor$ 247.00
Task: 0006 - Routine Inspections - Group 6 (Region 2)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.008$ 152.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.003$ 57.00
$ - 0
$ - 0
$ - 0
Total Labor$ 209.00
Task: 0007 - Routine Inspections - Group 7 (Region 3)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.006$ 114.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.008$ 152.00
$ - 0
$ - 0
$ - 0
Total Labor$ 266.00
Task: 0008 - Routine Inspections - Group 8 (Region 3)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.005$ 95.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.002$ 38.00
$ - 0
$ - 0
$ - 0
Total Labor$ 133.00
Task: 0009 - Incentives - Routine Inspections (3 percent)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.006$ 114.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.002$ 38.00
$ - 0
$ - 0
$ - 0
Total Labor$ 152.00
Total Base Price$ 2,603.00
NOTE:
Quoter must also provide a breakdown of costs by task (labor category, hours & rate)
This list will be used to understand the contractor's methodology
Rates must be fully loaded and must be inclusive of escalation rates per year, fringe, overhead, training, G&A, and fee/profit.
** Round total to whole numbers (example: $201,750.00); do not use decimals places (example: $201,750.50)

OPTION 3

Attachment 0007 – Sample Price Breakdown Worksheet with Rates 86615621Q00002
OPTION 3: 12 Months
Task: 0001 - Routine Inspections- Group 1 (Region 1)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.0025$ 475.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.0025$ 475.00
$ - 0
$ - 0
$ - 0
Total Labor$ 950.00
Task: 0002 - Routine Inspections- Group 2 (Region 1)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.005$ 95.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.003$ 57.00
$ - 0
$ - 0
$ - 0
Total Labor$ 152.00
Task: 0003 - Routine Inspections - Group 3 (Region 1)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.006$ 114.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.008$ 152.00
$ - 0
$ - 0
$ - 0
Total Labor$ 266.00
Task: 0004 - Routine Inspections - Group 4 (Region 2)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.009$ 171.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.003$ 57.00
$ - 0
$ - 0
$ - 0
Total Labor$ 228.00
Task: 0005 - Routine Inspections - Group 5 (Region 2)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.006$ 114.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.007$ 133.00
$ - 0
$ - 0
$ - 0
Total Labor$ 247.00
Task: 0006 - Routine Inspections - Group 6 (Region 2)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.008$ 152.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.003$ 57.00
$ - 0
$ - 0
$ - 0
Total Labor$ 209.00
Task: 0007 - Routine Inspections - Group 7 (Region 3)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.006$ 114.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.008$ 152.00
$ - 0
$ - 0
$ - 0
Total Labor$ 266.00
Task: 0008 - Routine Inspections - Group 8 (Region 3)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.005$ 95.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.002$ 38.00
$ - 0
$ - 0
$ - 0
Total Labor$ 133.00
Task: 0009 - Incentives - Routine Inspections (3 percent)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.006$ 114.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.002$ 38.00
$ - 0
$ - 0
$ - 0
Total Labor$ 152.00
Total Base Price$ 2,603.00
NOTE:
Quoter must also provide a breakdown of costs by task (labor category, hours & rate)
This list will be used to understand the contractor's methodology
Rates must be fully loaded and must be inclusive of escalation rates per year, fringe, overhead, training, G&A, and fee/profit.
** Round total to whole numbers (example: $201,750.00); do not use decimals places (example: $201,750.50)

OPTION 4

Attachment 0007 – Sample Price Breakdown Worksheet with Rates 86615621Q00002
OPTION 4: 12 Months
Task: 0001 - Routine Inspections- Group 1 (Region 1)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.0025$ 475.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.0025$ 475.00
$ - 0
$ - 0
$ - 0
Total Labor$ 950.00
Task: 0002 - Routine Inspections- Group 2 (Region 1)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.005$ 95.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.003$ 57.00
$ - 0
$ - 0
$ - 0
Total Labor$ 152.00
Task: 0003 - Routine Inspections - Group 3 (Region 1)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.006$ 114.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.008$ 152.00
$ - 0
$ - 0
$ - 0
Total Labor$ 266.00
Task: 0004 - Routine Inspections - Group 4 (Region 2)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.009$ 171.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.003$ 57.00
$ - 0
$ - 0
$ - 0
Total Labor$ 228.00
Task: 0005 - Routine Inspections - Group 5 (Region 2)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.006$ 114.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.007$ 133.00
$ - 0
$ - 0
$ - 0
Total Labor$ 247.00
Task: 0006 - Routine Inspections - Group 6 (Region 2)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.008$ 152.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.003$ 57.00
$ - 0
$ - 0
$ - 0
Total Labor$ 209.00
Task: 0007 - Routine Inspections - Group 7 (Region 3)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.006$ 114.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.008$ 152.00
$ - 0
$ - 0
$ - 0
Total Labor$ 266.00
Task: 0008 - Routine Inspections - Group 8 (Region 3)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.005$ 95.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.002$ 38.00
$ - 0
$ - 0
$ - 0
Total Labor$ 133.00
Task: 0009 - Incentives - Routine Inspections (3 percent)
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.006$ 114.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.002$ 38.00
$ - 0
$ - 0
$ - 0
Total Labor$ 152.00
Task: 0010 - Transition-Out
Labor Category:Prime or SubHourly RateVolume/HoursTotal Per Year
Example - InspectorPrime$ 19.0010$ 190.00
$ - 0
$ - 0
$ - 0
Example - InspectorSubcontractor$ 19.005$ 95.00
$ - 0
$ - 0
$ - 0
Total Labor$ 285.00
Total Base Price$ 2,888.00
NOTE:
Quoter must also provide a breakdown of costs by task (labor category, hours & rate)
This list will be used to understand the contractor's methodology
Rates must be fully loaded and must be inclusive of escalation rates per year, fringe, overhead, training, G&A, and fee/profit.
** Round total to whole numbers (example: $201,750.00); do not use decimals places (example: $201,750.50)

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