S14 ATTH 6 Labor Hr Price Proposal WKSHT.xls
XLS spreadsheet 46 KB Posted
- Solicitation number
- HUD86614822R00016
About this file
This document contains a pricing worksheet template and cost estimating worksheet for a federal solicitation from the Department of Housing and Urban Development seeking a contractor to conduct the HUD-HHS Childcare Study. The solicitation requires the contractor to describe the early childcare needs, preferences, and solutions used by HUD-assisted families; how these families engage with early childcare assistance programs; the current availability of on-site early childcare services at public housing agencies; and how HUD, PHAs, and state and federal programs can better support on-site early childcare. The pricing worksheet template includes columns for labor categories, hourly rates, burden rates, markups, and fully burdened rates for a base period and option period. The cost estimating worksheet uses this pricing data to calculate estimated costs by labor category and period based on input hours. The total estimated cost for the base and option periods combined is provided as $1,670,741.88.
View the file
Other files
Show all 11
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
Pricing Details
| PRICE DETAILS | April 20, 2012 | |||||||||
| FA2543-12-R-0005 | ||||||||||
| Protiro, Inc.- Attachment B - Page1 | ||||||||||
| ATTACHMENT 6 | ||||||||||
| Labor Hour Price Schedule Worksheet (EXAMPLE) | Fill in this column | Fill in this column | Fill in this column | Fill in this column | Fill in this column | Columns automatically calculate. | Fill in this column | Column Automatically Calculates | ||
| Labor Category | Hourly Raw Rate | Direct Labor Burden | Overhead/ G&A Markup | V&A Multiplier | Profit/ Fee | Multiplier | Fully Burdened Hourly Rate - Base Period | Escalation Rate for Option Period I | Fully Burdened Hourly Rate - Option Period I | |
| Civil Engineer | $ 34.62 | 33.21% | 26.00% | 8.30% | 8.00% | 186.22% | $ 64.47 | 2.50% | $ 66.08 | |
| Electrical Engineer | $ 36.06 | 33.21% | 26.00% | 8.30% | 8.00% | 186.22% | $ 67.15 | 2.50% | $ 68.83 | |
| Engineer Technician | $ 30.28 | 33.21% | 26.00% | 8.30% | 8.00% | 186.22% | $ 56.39 | 2.50% | $ 57.80 | |
| Industrial Engineer Technician | $ 30.28 | 33.21% | 26.00% | 8.30% | 8.00% | 186.22% | $ 56.39 | 2.50% | $ 57.80 | |
| Architect | $ 34.62 | 33.21% | 26.00% | 8.30% | 8.00% | 186.22% | $ 64.47 | 2.50% | $ 66.08 |
Cost Est Wksht
| COST ESTIMATING WORKSHEET | |||||||||
| FA2543-12-R-0005 | April 20, 2012 | ||||||||
| Protiro, Inc. - Attachment B - Page 2 | |||||||||
| Fill in number of hours in this column. | Column data automatically populate from Price Schedule Worksheet | Column Automatically Calculates | Column Automatically Calculates | Fill in number of hours in this column. | Column data automatically populate from Price Schedule Worksheet. | Column Automatically Calculates | Column Automatically Calculates | Column Automatically Calculates | |
| COST ESTIMATE | Base Period | Option Period I | |||||||
| Labor Category | Estimated Number of Hours for Base Period | Burdened Hourly Rate for Base Period | Estimated Cost for Monthly Period | Estimated Cost for Base Period | Estimated Number of Hours for Option Period I | Burdened Hourly Rate for Option Period I | Estimated Cost for Monthly Period | Estimated Cost for Option Period I | Total Estimated Cost for Contract |
| Civil Engineer | 3840 | $ 64.47 | $ 20,630.02 | $ 247,560.23 | 3840 | $ 66.08 | $ 21,145.77 | $ 253,749.25 | $ 501,309.48 |
| Electrical Engineer | 1920 | $ 67.15 | $ 10,744.06 | $ 128,928.69 | 1920 | $ 68.83 | $ 11,012.66 | $ 132,151.89 | $ 261,080.58 |
| Engineer Technician | 3840 | $ 56.39 | $ 18,043.82 | $ 216,525.80 | 3840 | $ 57.80 | $ 18,494.91 | $ 221,938.94 | $ 438,464.74 |
| Industrial Engineer Technician | 1920 | $ 56.39 | $ 9,021.91 | $ 108,262.90 | 1920 | $ 57.80 | $ 9,247.46 | $ 110,969.47 | $ 219,232.37 |
| Architect | 1920 | $ 64.47 | $ 10,315.01 | $ 123,780.10 | 1920 | $ 66.08 | $ 10,572.88 | $ 126,874.61 | $ 250,654.71 |
| TOTAL ESTIMATE | 13,440 | $ 68,754.81 | $ 825,057.72 | 13,440 | $ 70,473.68 | $ 845,684.16 | $ 1,670,741.88 |
File details come from the government source that posted it. Updated .