Attachment A - BUSINESS Pricing Templates Updated.xlsx
XLSX spreadsheet 34 KB Posted
- Solicitation number
- 75N99023R00029
About this file
This document includes pricing templates and instructions for a federal solicitation seeking inspection and quality assurance support services. The National Institutes of Health, under the Department of Health and Human Services, is soliciting proposals to provide inspection services for its facilities managed by the Division of Design and Construction Management. Offerors are instructed to complete templates calculating fully burdened labor rates for key personnel categories and estimating total prices for a base period and four potential award terms providing mechanical, electrical, HVAC, testing and balancing, and electrical metering inspection services. Pricing is to be based on assumptions of inspecting an average of 125 projects per year lasting 90 days each, with templates automatically calculating extended prices from input labor rates and hours.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Request_DTSB_services.xlsx | XLSX spreadsheet | |
| RFI - Inspection Contract - Final Response.pdf | ||
| Attachment C - DISCLOSURE LOBBYING ACTIVITIES.pdf | ||
| Attachment B - SIMILAR PROJECT TEMPLATE.pdf | ||
| Attachment E - Past Performance Questionnaire.pdf | ||
| Attachment D - Health_Safety_Requirements.pdf | ||
| 75N99023R00029 Final.pdf | ||
| Attachment A - BUSINESS Pricing Templates.xlsx | XLSX spreadsheet |
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
Instructions
| RFP #NIHxxxxxx: PRICE PROPOSAL INSTRUCTIONS | |
| DO NOT CHANGE THE SPREADSHEETS INCLUDING CALCULATIONS. Inform the government of questions or concerns. | |
| 1 | Complete "LABOR RATES CALCULATION" Worksheet as follows: |
| A | Enter base rate for each labor category |
| B | Enter Fringe % |
| D | Enter Overhead % |
| F | Enter G&A % if any |
| H | Enter Profit % |
| J | Loaded (Burdened) Houlrly Rate will calculate automatically |
| Check all formulas to ensure correct rates are calculated. These Labor Rates will be used for fixed price task orders. |
| 2 | Complete the "PRICING CALCULATION BACKUP" Worksheet as follows: |
| Estimate the number of hours for inspection based on the following: |
Average # of projects/year = 125; Average Duration of Projects = 90 days; Average Inspection required = 1.5 hours/project; Assume 50% Mechanical, 35% Electrical, 15% A/S/C (Offeror may propose) other split of mechanical, electrical, A/S/C inspection); Assume 30 projects per year will require TAB services and Electrical Metering services.
| C | For all Award Term periods, enter a % for escalation. |
| D | Enter Proposed Labor Categories (Key Personnel) |
| E | Burdened Rates for Base Period are LINKED from Labor Rates Calculation Worksheet for Base Period. Burdened Rates for Award Terms will calcuate automatically based on proposed escalation percentages. |
| F | Enter Proposed Annual Hours for each labor category based on above assumptions. NOTE any proposed deviation from the assumptions. |
| G | For Base and all Award Terms, Hours Total Cost will calculate automatically. |
| IMPORTANT - It is the Offeror's responsibility to verify that the formulas and totals produce an accurate fee. |
| 3 | Check the TABLE 1 Worksheet: |
| The total annual price proposed will automatically populate from the Pricing Calculation Backup Worksheet. | |
| This Table will consitute the total price proposal for comparison purposes and will represent the value of the contract. | |
| THE OFFEROR IS RESPONSIBLE TO ENSURE THAT THIS TABLE ACCURTELY REFLECTS THE OFFEROR'S PRICE PROPOSAL. |
Table 1
| RFP NIHXXXXXX - TABLE XX - PROPOSAL SUMMARY OF PRICES | ||
| CLIN Item | ||
| Base Period | Total Price: | |
| 0001 | Inspection and QA Support Services: | $ - 0 |
| AWARD TERM 1 | ||
| 1001 | Inspection and QA Support Services: | $ - 0 |
| AWARD TERM 2 | ||
| 2001 | Inspection and QA Support Services: | $ - 0 |
| Option | AWARD TERM 3 | |
| 3001 | Inspection and QA Support Services: | $ - 0 |
| Option | AWARD TERM 4 | |
| 4001 | Inspection and QA Support Services: | $ - 0 |
| Total Price - Contract Base and Four Award Terms: | $ - 0 |
Labor Rates Calculation RFP NIHxxxxxxxxx - PRICING SCHEDULE BACKUP WORKSHEET - Page 1
| Labor Rates | ||||||||||||
| Item | Labor Categories | A | B | C | D | E | F | G | H | I | J | |
| Hourly Base Rate ($) | Fringe % | Fringe ($) (= A * B ) | Overhead (%) | Overhead ($) (= (A+C)*D) | G&A % | G&A ($) | ||||||
| (= (A+C+E)*F) | Profit (%) | Profit ($) | ||||||||||
| (= (A+C+E+G)*H) | Loaded Hourly Rate ($) |
(= A+C+E+G+I)
| 1 | Prime | Project Manager - Example | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 2 | Mechanical Inspector | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 3 | Electrical Inspector | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 4 | A/S/C Inspector | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 5 | Testing/Adjusting/Balancing | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 6 | Electrical Metering | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 7 | Other (Describe) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 10 | Team Member 1 (if any) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 11 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 12 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 13 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 14 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 15 | Team Member 2 (if any) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 16 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 17 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 18 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 19 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Pricing Calculation Backup
| RPF NIXXXX PRICING CALCULATION WORKSHEET | |||||||
| A | Base | C | D | E | F | G | |
| CLIN NO. | PERIOD | ESCALATION | |||||
| (%) | KEY PERSONNEL | ||||||
| POSITION | BURDENED RATE | ||||||
| / HR ($) (from Labor Rates Calculation) | ANNUAL HOURS PROPOSED | TOTAL COST ($) | |||||
| 0001 | Base | NA | Project Manager | $ - 0 | $ - 0 | ||
| Mechanical Inpsector | $ - 0 | $ - 0 | |||||
| Electrical Inspector | $ - 0 | $ - 0 | |||||
| General Inspector (A/S/C) | $ - 0 | $ - 0 | |||||
| TAB | $ - 0 | 1750 | $ - 0 | ||||
| Electrical Metering | $ - 0 | 450 | $ - 0 | ||||
| Other (Describe) | $ - 0 | $ - 0 | |||||
| Base Total: | 0 | $ - 0 | |||||
| 1001 | Award Term 1 | 3.00% | Project Manager | $ - 0 | $ - 0 | ||
| Mechanical Inpsector | $ - 0 | $ - 0 | |||||
| Electrical Inspector | $ - 0 | $ - 0 | |||||
| General Inspector (A/S/C) | $ - 0 | $ - 0 | |||||
| TAB | $ - 0 | 1750 | $ - 0 | ||||
| Electrical Metering | $ - 0 | 450 | $ - 0 | ||||
| Other (Describe) | $ - 0 | $ - 0 | |||||
| Award Term 1 Total: | 0 | $ - 0 | |||||
| 2001 | Award Term 2 | 0.00% | Project Manager | $ - 0 | $ - 0 | ||
| Mechanical Inpsector | $ - 0 | $ - 0 | |||||
| Electrical Inspector | $ - 0 | $ - 0 | |||||
| General Inspector (A/S/C) | $ - 0 | $ - 0 | |||||
| TAB | $ - 0 | 1750 | $ - 0 | ||||
| Electrical Metering | $ - 0 | 450 | $ - 0 | ||||
| Other (Describe) | $ - 0 | $ - 0 | |||||
| Award Term 2 Total: | 0 | $ - 0 | |||||
| 3001 | Award Term 3 | 0.00% | Project Manager | $ - 0 | $ - 0 | ||
| Mechanical Inpsector | $ - 0 | $ - 0 | |||||
| Electrical Inspector | $ - 0 | $ - 0 | |||||
| General Inspector (A/S/C) | $ - 0 | $ - 0 | |||||
| TAB | $ - 0 | 1750 | $ - 0 | ||||
| Electrical Metering | $ - 0 | 450 | $ - 0 | ||||
| Other (Describe) | $ - 0 | $ - 0 | |||||
| Award Term 3 Total: | 0 | $ - 0 | |||||
| 4001 | Award Term 4 | 0.00% | Project Manager | $ - 0 | $ - 0 | ||
| Mechanical Inpsector | $ - 0 | $ - 0 | |||||
| Electrical Inspector | $ - 0 | $ - 0 | |||||
| General Inspector (A/S/C) | $ - 0 | $ - 0 | |||||
| TAB | $ - 0 | 1750 | $ - 0 | ||||
| Electrical Metering | $ - 0 | 450 | $ - 0 | ||||
| Other (Describe) | $ - 0 | $ - 0 | |||||
| Award Term 4 Total: | 0 | $ - 0 |
File details come from the government source that posted it. Updated .