Get documents about "Salary Agreement Generic
Description
Salary Agreement Generic document sample
Document Sample
FEDERAL HIGHWAY ADMINISTRATION
CENTRAL FEDERAL LANDS HIGHWAY DIVISION
CFL CONSTRUCTION BASELINE BUDGET
PROJECT NUMBER: NV PRA LASV 10(1) BUDGET
DATE:
March 2, 2009
PROJECT NAME: Las Vegas
Beginning Date of Construction 2/3/2009 End Date of Construction 9/30/2010
Dates of Seasonal Suspensions 11/15/09 To 3/1/10
Dates of Seasonal Suspensions To
Start-Up Page
Please complete the information in the blue cells above and below. Data will be automatically transferred to successive worksheets.
Personnel ==> COE PE Assistant PE Inspector 1 Inspector 2 PM Bob Bell
Wage Rate ====> $100.00 $100.00 $89.00 $103.50 $144.88 $143.32 $113.53
Generic Env. Generic Generic Generic QA Generic
Personnel ==> Generic Bridge Generic Design
Permits Geotech Hydraulics Materials Pavements
Generic Safety Generic Survey
Wage Rate ====> $71.54 $71.54 $71.54 $71.54 $71.54 $71.54 $71.54 $71.54 $71.54
Functional Support Personnel ==>
Wage Rate ====>
Instructions for Use
1) Fill in all Personnel and burdened Rates. Note that up to 30 classifications can be used. If more are needed, use a generic classification and rate (ex. Designer, Grade 11)
2) Generic resources for Functional Support is provided to reduce the time needed to determine the correct individuals. Actual resources will be provided by the P3 group.
3) On the 'Personnel Tab', fill in the Department and the role of each person.
4) For each discipline/activity tab, select from the pull-down list the appropriate personnel in row 6.
5) Fill in requried information in the lab, travel, equipment and materials, and task order tabs.
General Notes
1) Rows can be inserted into each worksheet by pressing CTRL>I or Tools>Macros>Run Macro "InsertRow". Copy the format in column A from the row above down to the new row.
2) Do not delete unnecessary worksheets(tabs) from this file! Simply hide the worksheets as needed.
> To Hide Worksheets: Click 'Format' > 'Sheet' > 'Hide'
> To Unhide Worksheets: Click 'Format' > 'Sheet' > 'Unhide'
3) To print, select a range of tabs from Summary to end. Each sheet will be numbered sequentially from X to Y. Print the Start and Personnel tabs separately.
90e4160c-35cc-4bc6-b6ca-60d7c3236fc6.xls 7/22/2011
FEDERAL HIGHWAY ADMINISTRATION
CENTRAL FEDERAL LANDS HIGHWAY DIVISION
CFL CONSTRUCTION BASELINE BUDGET
PROJECT #: NV PRA LASV 10(1) BUDGET DATE: 02-Mar-2009
PROJECT: Las Vegas
Construction Administration & Record Check
PE
A Contract Administration
CA Contract Administration Step Weight
Step 1 Contract Administration 100% 400 400
C8 Pending Final Record - Check & Voucher
Final record check and issuance of final
Step 1 100% 20 20
voucher
Subtotal of hours for CM 400 400
Subtotal of hours for C8 20 20
Subtotal of hours 420 420
Salary Rate, per hour $100.00
Subtotal Labor Costs for CM $40,000.00 $40,000.00
Subtotal Labor Costs for C8 $2,000.00 $2,000.00
Subtotal Labor Costs $42,000.00
TOTAL LABOR COST, (this sheet) $42,000.00 Formula Check OK
90e4160c-35cc-4bc6-b6ca-60d7c3236fc6.xls 7/22/2011
FEDERAL HIGHWAY ADMINISTRATION
CENTRAL FEDERAL LANDS HIGHWAY DIVISION
CFL CONSTRUCTION BASELINE BUDGET
PROJECT #: NV PRA LASV 10(1) BUDGET DATE: 02-Mar-2009
PROJECT: Las Vegas
Construction Management - COE
COE Totals
C Construction Management
CM Construction Management Step Weight
Step 1 Construction Management - Construction 100% 100 100
Subtotal of hours 100 100
Salary Rate, per hour $100.00
Subtotal Labor Costs $10,000.00
TOTAL LABOR COST, (this sheet) $10,000.00 Formula Check OK
FEDERAL HIGHWAY ADMINISTRATION
CENTRAL FEDERAL LANDS HIGHWAY DIVISION
CFL CONSTRUCTION BASELINE BUDGET
PROJECT #: NV PRA LASV 10(1) BUDGET DATE: 02-Mar-2009
PROJECT: Las Vegas
Functional Support Totals
Generic Generic Generic
Generic Bridge Bob Bell
Design Geotech Pavements
D Design
C7 Functional Support During Construction Step Weight
Step 1 Functional Support During Construction 100% 10 35 20 20 25 110
Subtotal of hours 10 35 20 20 25 110
Salary Rate, per hour $71.54 $71.54 $71.54 $71.54 $113.53
Subtotal Labor Costs $715.40 $2,503.90 $1,430.80 $1,430.80 $2,838.25
TOTAL LABOR COST, (this sheet) $8,919.15 Formula Check OK
90e4160c-35cc-4bc6-b6ca-60d7c3236fc6.xls 7/22/2011
FEDERAL HIGHWAY ADMINISTRATION
CENTRAL FEDERAL LANDS HIGHWAY DIVISION
CFL CONSTRUCTION BASELINE BUDGET
PROJECT #: NV PRA LASV 10(1) BUDGET DATE: 02-Mar-2009
PROJECT: Las Vegas
Construction Inspection
Assistant PE Inspector 1 Inspector 2 Totals
I Inspection - Construction
CI Inspection Step Weight
Step 1 Construction Inspection 100% 400 350 350 1,100
Subtotal of hours 400 350 350 1,100
Salary Rate, per hour $89.00 $103.50 $144.88
Subtotal Labor Costs $35,600.00 $36,225.00 $50,708.00
TOTAL LABOR COST, (this sheet) $122,533.00 Formula Check OK
FEDERAL HIGHWAY ADMINISTRATION
CENTRAL FEDERAL LANDS HIGHWAY DIVISION
CFL CONSTRUCTION BASELINE BUDGET
PROJECT #: NV PRA LASV 10(1) BUDGET DATE: 02-Mar-2009
PROJECT: Las Vegas
Project Management - PM
PM Totals
W Project Manager
PMC Project Management - Construction Step Weight
Step 1 Project Management - Construction 100% 100 100
Subtotal of hours 100 100
Salary Rate, per hour $143.32
Subtotal Labor Costs $14,332.00
TOTAL LABOR COST, (this sheet) $14,332.00 Formula Check OK
90e4160c-35cc-4bc6-b6ca-60d7c3236fc6.xls 7/22/2011
FEDERAL HIGHWAY ADMINISTRATION
CENTRAL FEDERAL LANDS HIGHWAY DIVISION
CFL CONSTRUCTION BASELINE BUDGET
PROJECT #: NV PRA LASV 10(1) BUDGET DATE: 02-Mar-2009
PROJECT: Las Vegas
Material Lab Testing
P3 Activity
CM Construction Materials Total Cost
Code
CFL Central Lab Tests C10 $5,000
TOTAL MATERIALS COST $5,000.00
FEDERAL HIGHWAY ADMINISTRATION
CENTRAL FEDERAL LANDS HIGHWAY DIVISION
CFL CONSTRUCTION BASELINE BUDGET
PROJECT #: NV PRA LASV 10(1) BUDGET DATE: 02-Mar-2009
PROJECT: Las Vegas
Equipment and Supplies
Time on Additional Misc.
P3 Activity Monthly
Project Mileage Supplies Total Cost
Code Charge
(Months) Charge Costs
Vehicle CX 7.0 $500 $100 $3,600
Vehicle CX 5.0 $500 $100 $2,600
Vehicle CX 3.0 $500 $100 $1,600
Vehicle CX $500
CFL Field Office Trailer
Cost of CFL Field Office or Lab Trailers is Accounted for with Depot Overhead Recovery
CFL Field Lab Trailer
Field Office Space (not furnished by Depot) CA
Field Lab Space (not furnished by Depot) CA
Miscellaneous Supplies/Bank Card CA $300 $300
TOTAL EQUIPMENT AND SUPPLY COST CX $7,800.00
TOTAL EQUIPMENT AND SUPPLY COST CA $300.00
90e4160c-35cc-4bc6-b6ca-60d7c3236fc6.xls 7/22/2011
FEDERAL HIGHWAY ADMINISTRATION
CENTRAL FEDERAL LANDS HIGHWAY DIVISION
CFL CONSTRUCTION BASELINE BUDGET
PROJECT #: NV PRA LASV 10(1) BUDGET DATE: 02-Mar-2009
PROJECT: Las Vegas
Travel
SHORT TERM PROJECT PER DIEM LONG TERM PROJECT PER DIEM
For Per Diem rates, go to gsa.gov Short Term Short Term Long Term Time Long Term Long Term Long Term Total
Short Term Per
P3 Activity Project Per Time on on Project Project Per Days Per Project Per
Diem Total
Diem (per day) Project (Days) (Months) Diem (per day) Month Diem Total
PE CA $105 15 $1,575 6.5 $64 30 $12,480 $14,055.00
Assistant PE CI $105 15 $1,575 5.5 $64 30 $10,560 $12,135.00
Inspector 1 CI $105 15 $1,575 5.5 $64 30 $10,560 $12,135.00
Inspector 2 CI $105 15 $1,575 5.5 $64 30 $10,560 $12,135.00
15 30
15 30
15 30
15 30
For Per Diem rates, go to gsa.gov Car Rental Misc. Each Total
# of Days per Per Diem (per Rental Car &
P3 Activity # of Trips Per Diem Total Airfare (Each) Airfare Total Total (Incl (Parking,
Trip day) Misc. Total
Gas) Mileage, Tolls)
Construction Operations Engineer CM 4 4 $105 $1,470 $1,200 $4,800 $200 $100 $1,200.00 $7,470.00
Project Manager PMC 3 3 $105 $788 $1,200 $3,600 $175 $75 $750.00 $5,137.50
R&R Trips (PE) CA 1 $750 $750 $50 $50.00 $800.00
R&R Trips (field pool - Inspectors & Asst. PE) CI 1 $750 $750 $50 $50.00 $800.00
Functional Support C7 2 3 $105 $525 $800 $1,600 $150 $75 $450.00 $2,575.00
TOTAL TRAVEL COSTS $67,242.50
90e4160c-35cc-4bc6-b6ca-60d7c3236fc6.xls 7/22/2011
FEDERAL HIGHWAY ADMINISTRATION
CENTRAL FEDERAL LANDS HIGHWAY DIVISION
CFL CONSTRUCTION BASELINE BUDGET
PROJECT #: NV PRA LASV 10(1) BUDGET DATE: 02-Mar-2009
PROJECT: Las Vegas
Task Order Summary
P3 Activity Number of Duration Cost (per Total Estimated
Consultant Name Employee Name Role
Code People (months) month) Task Order Cost
Yeh & Associates CI-I CI 1 4 $22,000 $88,000
RockSol CI-II CI 1 3 $25,000 $75,000
Total Task Order Cost $163,000.00
Reimbursable Agreement Summary
P3 Activity Number of Duration Cost (per Total Estimated
Government Agency Employee Name Role
Code People (months) month) Task Order Cost
Forest Service Tom Jones CI-I CI 1 4 $22,000 $88,000
Total Reimbursable Agreement Cost $88,000.00
90e4160c-35cc-4bc6-b6ca-60d7c3236fc6.xls 7/22/2011
FEDERAL HIGHWAY ADMINISTRATION
CENTRAL FEDERAL LANDS HIGHWAY DIVISION
CFL CONSTRUCTION BASELINE BUDGET
PROJECT NUMBER: NV PRA LASV 10(1) BUDGET DATE: 02-Mar-2009
PROJECT NAME: Las Vegas
Reimbursable
BREAKDOWN P3 Work Equipment/ CFL Material Task Order Agreement Personnel Hours Rate Labor Cost
Activity Code Hours Labor Costs Supply Costs Lab Costs Travel Costs Costs Costs Total
Contract Administration Total A 420 $42,000.00 $300.00 $14,855.00 $57,155.00 COE 100 $100.00 $10,000.00
CA A 400 $40,000.00 $300.00 $14,855.00 $55,155.00 PE 420 $100.00 $42,000.00
C8 A 20 $2,000.00 $2,000.00 Assistant PE 400 $89.00 $35,600.00
Construction Management Total C 100 $10,000.00 $7,470.00 $17,470.00 Inspector 1 350 $103.50 $36,225.00
CM C 100 $10,000.00 $7,470.00 $17,470.00 Inspector 2 350 $144.88 $50,708.00
Functional Support Total D 110 $8,919.15 $2,575.00 $11,494.15 PM 100 $143.32 $14,332.00
C7 D 110 $8,919.15 $2,575.00 $11,494.15 Bob Bell 25 $113.53 $2,838.25
Inspection Total I 1,100 $122,533.00 $37,205.00 $163,000.00 $88,000.00 $410,738.00
CI I 1,100 $122,533.00 $37,205.00 $163,000.00 $88,000.00 $410,738.00
Materials - Lab Billings Total M $5,000.00 $5,000.00
C10 M $5,000.00 $5,000.00 Generic Bridge 10 $71.54 $715.40
Project Manager Total W 100 $14,332.00 $5,137.50 $19,469.50 Generic Design 35 $71.54 $2,503.90
PMC W 100 $14,332.00 $5,137.50 $19,469.50 Generic Env. Permits $71.54
Equipment and Supplies Total X $7,800.00 $7,800.00 Generic Geotech 20 $71.54 $1,430.80
CX X $7,800.00 $7,800.00 Generic Hydraulics $71.54
CE Subtotals 1,830 $197,784.15 $8,100.00 $5,000.00 $67,242.50 $163,000.00 $88,000.00 $529,126.65 Generic QA Materials $71.54
Depot Recovery $13,516.33 Generic Pavements 20 $71.54 $1,430.80
CE Totals 1,830 $197,784.15 $8,100.00 $5,000.00 $67,242.50 $163,000.00 $88,000.00 $542,642.98 Generic Safety $71.54
Generic Survey $71.54
Totals 1,830 $197,784.15
90e4160c-35cc-4bc6-b6ca-60d7c3236fc6.xls 7/22/2011
FEDERAL HIGHWAY ADMINISTRATION
CENTRAL FEDERAL LANDS HIGHWAY DIVISION
CFL CONSTRUCTION BASELINE BUDGET
PROJECT NUMBER: NV PRA LASV 10(1)
BUDGET DATE: 02-Mar-2009
PROJECT NAME: Las Vegas
SUMMARY
Work Code A C D I M W SUBTOTAL X- Equip X-Overhead X TOTAL
5% of Labor &
CE (Hours) 420 100 110 1100 100 1830
Indirect Costs
CE (Labor
$42,000.00 $10,000.00 $8,919.15 $122,533.00 $14,332.00 $197,784.15 $9,889.21 $9,889.21
Costs)
CE (Indirect
$15,155.00 $7,470.00 $2,575.00 $37,205.00 $5,000.00 $5,137.50 $72,542.50 $7,800.00 $3,627.13 $11,427.13
Costs)
CE Total $57,155.00 $17,470.00 $11,494.15 $159,738.00 $5,000.00 $19,469.50 $270,326.65 $7,800.00 $13,516.33 $21,316.33
AE-C (Task
$163,000.00 $163,000.00
Orders)
AG-C
$88,000.00 $88,000.00
(Agreements)
TOTALS $57,155.00 $17,470.00 $11,494.15 $410,738.00 $5,000.00 $19,469.50 $521,326.65 $21,316.33 $542,642.98
TOTAL BUDGET
$542,642.98
CN BUDGET: $12,000,000.00
COST TO DATE: 3/10/09 $200,000.00
REMAINING CE COST: $542,642.98
TOTAL CE COST: $742,642.98
% CE COST: 6.2%
90e4160c-35cc-4bc6-b6ca-60d7c3236fc6.xls 7/22/2011
Related docs
Other docs by khi66344
Jiasoj Jdfljsdoi sl Configuration Approach State of Connecticut Core CT Project Salary Item Overview
Views: 14 | Downloads: 0
