3-Sample of % Increase Rate Schedule- - Spreadsheet.xlsx
XLSX spreadsheet 54 KB Posted
- Solicitation number
- 1-26-3-21-8
- Issued by
- Maryland
About this file
This is a Rate Schedule sample document for the Maryland Energy Administration Building Energy Performance Standards (BEPS) Technical Assistance Pilot Program, managed by the Maryland Environmental Service (MES) under MEA Project No. 1-26-3-21-8 for Years 1 & 2. The document presents a template for personnel rate increases and cost structures for prime contractors and multiple subcontractors, establishing billable rates based on base wages, overhead and fringe costs, fixed fees (profit margins), and proposed increases. The spreadsheet is formatted to capture staff names, job titles/labor classifications, and justifications for rate increases, though the current sample contains primarily error values and placeholder data requiring completion by contractors.
The rate schedule employs a standardized calculation methodology with a 2% annual increase allowance and includes overhead and fringe rates applied to base hourly rates to determine fully billable rates. A companion personnel roster from a related MDOT/MPA dredged material management contract (MES Contract 1-20-3-26-8, as of March 2020) demonstrates actual implemented rates for reference, showing base rates ranging from $18.19 to $75.00 per hour with overhead calculated at 160% and fixed fees at 10%. The document specifies that all mileage, per diem, hotel, and travel charges must comply with State-approved FY allowable rates, with hotel expenses capped at $150 per night unless prior justification is provided, and miscellaneous items exceeding $100 individually or monthly require advanced authorization from MES.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 2-1-26-3-21-8 Rate Schedule Att F-1.xlsx | XLSX spreadsheet | |
| 1-1-26-3-21-8 Solicitation.pdf |
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
MEA
| PROJECT NO. 1-26-3-21-8 | Years 1 & 2 |
| NOTE: ALL INFORMATION IN THIS WORKBOOK IS CONFIDENTIAL |
Maryland Energy Administration Building Energy Performance Standards (BEPS) Technical Assistance Pilot Program
| Prime Company Name | Staff Name | Job Title/Labor Classification | Base Rate | Proposed Base Rate | ||||||
| as of | Overhead/Fringe Rate | Subtotal | fixed fee (profit) | Fully Billable Rate | 2% increase | JUSTIFICATION FOR HIGHER RATE INC. | ||||
| X% | X% | |||||||||
| ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#DIV/0! | ||||||
| ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#DIV/0! | ||||||
| ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#DIV/0! | ||||||
| ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#DIV/0! | ||||||
| ADDITIONAL EMPLOYEES | ||||||||||
| ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | ERROR:#VALUE! | |||||||
| Subcontractor Company Name | Staff Name | Job Title/Labor Classification | Base Rate $ | Proposed Base Rate | ||||||
| as of | Overhead/Fringe Rate | Subtotal | fixed fee (profit) | Fully Billable Rate | 2% Increase | JUSTIFICATION FOR HIGHER RATE INC. | ||||
| 0% | 10% | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||||
| $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||||
| $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||||
| $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||||
| $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||||
| $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||||
| $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||||
| $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||||
| $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||||
| Subcontractor Company Name | Staff Name | Job Title/Labor Classification | Base Rate $ | Proposed Base Rate | ||||||
| as of | Overhead/Fringe Rate | Subtotal | fixed fee (profit) | Fully Billable Rate | 2% Increase | JUSTIFICATION FOR HIGHER RATE INC. | ||||
| 0% | 10% | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||||
| $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||||
| $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||||
| $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||||
| Subcontractor Company Name | Staff Name | Job Title/Labor Classification | Base Rate $ | Proposed Base Rate | ||||||
| as of | Overhead/Fringe Rate | Subtotal | fixed fee (profit) | Fully Billable Rate | 2% Increase | JUSTIFICATION FOR HIGHER RATE INC. | ||||
| 0% | 10% | |||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||||
| $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||||
| $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||||
| $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||||
| $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||||
| $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! | ||||||
| $0.00 | $0.00 | $0.00 | $0.00 | ERROR:#DIV/0! |
| ** Mileage, per diem, hotel and travel charges shall not exceed State-approved FY allowable rates. |
| ** Hotel expenses will be cost-reimbursable, with receipts, up to a maximum of $150 per night unless prior justification is provided. |
| ** Miscellaneous items that exceed $100 individually or in total each month charged with advanced authorization from MES. |
Request for Proposal - Project ID No. 1-19-3-31-8 Engineering and Environmental Services in Support of MDOT MPA’s Dredged Material Management Activities & Projects
Page &P of 5
GBA_Rates
| MES CONTRACT 1-20-3-26-8 ¡ AS OF MARCH 2020 | ||||||
| Engineering and Environmental Services in Support of MDOT/MPA's DMM Activities & Projects | ||||||
| PERSONNEL NAME | CATEGORY | BASE RATE | OH | SUBTOTAL | FEE | BILLABLE RATE |
| 160% | 10% | |||||
| Grady Bryant | Principal | $75.00 | $120.00 | $195.00 | $19.50 | $214.50 |
| DeWitt Barlow | Principal | $75.00 | $120.00 | $195.00 | $19.50 | $214.50 |
| Dennis Urso, PE | Sr. Associate | $75.00 | $120.00 | $195.00 | $19.50 | $214.50 |
| Kevin Kremkau, PE | Sr. Associate | $75.00 | $120.00 | $195.00 | $19.50 | $214.50 |
| Dana Cheney, PE | Sr. Associate | $74.59 | $119.34 | $193.93 | $19.39 | $213.33 |
| William Murchinson | Sr. Associate | $72.02 | $115.23 | $187.25 | $18.73 | $205.98 |
| Stanley Lulewicz, PE | Associate | $72.02 | $115.23 | $187.25 | $18.73 | $205.98 |
| Douglas Moore, PLS, CH | Associate | $67.39 | $107.82 | $175.21 | $17.52 | $192.74 |
| Martin Snow | Associate | $66.88 | $107.01 | $173.89 | $17.39 | $191.28 |
| John Drake | Associate | $61.73 | $98.77 | $160.50 | $16.05 | $176.55 |
| Chester Hedderman, PE, PLS | Associate | $61.73 | $98.77 | $160.50 | $16.05 | $176.55 |
| Daniel Behnke, PE | Associate | $58.65 | $93.84 | $152.49 | $15.25 | $167.74 |
| Ben Leonard | Associate | $56.58 | $90.53 | $147.11 | $14.71 | $161.82 |
| Paul Seaboldt, PLS | Sr. Engineer | $54.01 | $86.42 | $140.43 | $14.04 | $154.47 |
| Alan DelPilar | Sr. Engineer | $51.45 | $82.32 | $133.77 | $13.38 | $147.15 |
| Edward DeAngelo | Sr. Engineer | $50.42 | $80.67 | $131.09 | $13.11 | $144.20 |
| Brian Newbury, PE | Sr. Engineer | $49.89 | $79.82 | $129.71 | $12.97 | $142.69 |
| Jonathan Barker, PG | Sr. Engineer | $48.87 | $78.19 | $127.06 | $12.71 | $139.77 |
| Sean Flanigan | Sr. Engineer | $48.87 | $78.19 | $127.06 | $12.71 | $139.77 |
| Ralph Sharrett, PE | Sr. Engineer | $47.33 | $75.73 | $123.06 | $12.31 | $135.36 |
| Michael Tatigian, PE | Sr. Engineer | $46.81 | $74.90 | $121.71 | $12.17 | $133.88 |
| Shaun Bootsma, PLS, CH | Sr. Engineer | $46.30 | $74.08 | $120.38 | $12.04 | $132.42 |
| Carlton Bryant, PE | Sr. Engineer | $43.73 | $69.97 | $113.70 | $11.37 | $125.07 |
| Sara Halpin | Engineer 2 | $42.69 | $68.30 | $110.99 | $11.10 | $122.09 |
| Jayne McClure, EIT | Engineer 2 | $38.58 | $61.73 | $100.31 | $10.03 | $110.34 |
| Tyler Littlefield, PE | Engineer 2 | $35.49 | $56.78 | $92.27 | $9.23 | $101.50 |
| Ben Cushing, PE | Engineer 2 | $35.49 | $56.78 | $92.27 | $9.23 | $101.50 |
| Matthew Carter | Sr. Technician | $33.44 | $53.50 | $86.94 | $8.69 | $95.64 |
| Hunter Daisey | Sr. Technician | $33.44 | $53.50 | $86.94 | $8.69 | $95.64 |
| Jake Derolf | Engineer 1 | $32.92 | $52.67 | $85.59 | $8.56 | $94.15 |
| Lauren Folkert, EIT | Engineer 1 | $32.41 | $51.86 | $84.27 | $8.43 | $92.69 |
| Olivia Koster, EIT | Engineer 1 | $31.64 | $50.62 | $82.26 | $8.23 | $90.49 |
| Patricia Patterson | Technician 2 | $31.90 | $51.04 | $82.94 | $8.29 | $91.23 |
| Jacob Bear | Technician 2 | $31.38 | $50.21 | $81.59 | $8.16 | $89.75 |
| Paul Winchell | Technician 2 | $31.38 | $50.21 | $81.59 | $8.16 | $89.75 |
| Matthew Rajacich | Engineer 1 | $30.73 | $49.17 | $79.90 | $7.99 | $87.89 |
| Warren Staver, EIT | Engineer 1 | $30.73 | $49.17 | $79.90 | $7.99 | $87.89 |
| Nathan Laubham, EIT | Engineer 1 | $30.73 | $49.17 | $79.90 | $7.99 | $87.89 |
| Eric Cook | Technician 2 | $29.32 | $46.91 | $76.23 | $7.62 | $83.86 |
| Christopher Manuel | Technician 2 | $27.78 | $44.45 | $72.23 | $7.22 | $79.45 |
| Sheila Mainhart | Technician 1 | $24.70 | $39.52 | $64.22 | $6.42 | $70.64 |
| Linda Randolph | Technician 1 | $18.19 | $29.10 | $47.29 | $4.73 | $52.02 |
| RATE CHANGE | ||||||
| Travis Schmidt | Engineer 1 | $40.00 | $64.00 | $104.00 | $10.40 | $114.40 |
| ADDITIONAL PERSONNEL | ||||||
| Craig Boggs | Technician 2 | $29.96 | $47.94 | $77.90 | $7.79 | $85.69 |
| Doug Barker | Technician 2 | $26.00 | $41.60 | $67.60 | $6.76 | $74.36 |
| Logan Milne | Technician 2 | $26.00 | $41.60 | $67.60 | $6.76 | $74.36 |
Certified true and correct as of this date.
| Dennis Urso | Date |
| Vice President |
Page &P of 2
Gahagan & Bryant Associates, Inc.
9008-O Yellow Brick Road, Baltimore, Maryland 21237 Phone (410) 682-5595 Fax (410) 682-2175 image1.png
File details come from the government source that posted it. Updated .