Get documents about "Invoice Blueline
W
Description
Invoice Blueline document sample
Document Sample
Instructions:
(Enter state route number, project description,county, consultant's name,
prepared by name, and date prepared. This information will be transferred
to all other sheets. The date prepared must be entered in the appropriate
cell on this sheet to remove these instructions prior to printing.)
TENNESSEE DEPARTMENT OF TRANSPORTATION
MANDAY ESTIMATE AND FEE PROPOSAL
Click Here to Select Type of Proposal from Drop Down List
<Route>
<Description>
<County> County
Project Identification Number (PIN): <000000.00>
General Comments:
<Consultant>
<Consultant Contact Person>
<address>
<phone>
Prepared By: <fax>
<Name> <e-mail>
Date prepared:
<Date>
Project No.:
<00000-0000-00> Version 2.22
55ed01b8-84d2-40a6-9280-1d917654e540.xls
2/22/2011
SURVEY SUMMARY
Survey Summary
Route: <Route> <Date>
Description: <Description>
County: <County>
Consultant: <Consultant> INPUT SIDEROADS LT & RT OF
Prepared By: <Name> CENTERLINE
Project No.: <00000-0000-00> Sideroad Name Length (feet)
Mainline Project Length: 0.00 (miles)
Number of Sideroads: 0 Length: 0 (feet)
Office Travel Time per day (hrs): 0.00
Crew Travel Time per day (hrs): 0.00
Crew Work per day (hrs): 8
Number of Existing Lanes: 0 Proposed: 0
Number of Driveways/Ramps: 0
Location:
Existing Road: 100% Rural: 50%
New Alignment: 0% Urban: 50%
Business: 0%
Rural Land Character: Woods: 30% Terrain: Flat 0%
Pasture: 70% Rolling: 60%
Cultivated: 0% Hilly: 40%
Mountains: 0%
Distance to Nearest Benchmark: 0.0 miles
Number of Survey Updates 0 R.O.W. Staking:
Iron Pins 0
Aerial Mapping Available: YES 1 Stake Points 0
2 Stake Points 0
NO
Approximate Obscured Area: 100% Use 100% if no mapping is available.
Proposed DTM Width: 0 (ft) Total Length 0
Geotechnical Staking:
Drainage: Points 0
Approx. Number of Culvert Sites: 0
Number of Bridges: Small: 0 Medium 0 Large: 0
Approx. Number of Property Tracts: 0 Number of Railroad Crossings: 0
Indicate Utilities Present: Elect.: Telephone: Cable TV:
Water: Sewer: Gas:
Fiber Optic: Petroleum Pipeline:
Comments on Difficulty, Conditions or Other Considerations:
Version 2.22
55ed01b8-84d2-40a6-9280-1d917654e540.xls
2/22/2011 2
SURVEY MANDAY ESTIMATE
ESTIMATE FOR FIELD SURVEYS
PROJECT DESCRIPTION: Version 2.22
Route: <Route>
Description: <Description>
County: <County> Prepared By: <Name>
Consultant: <Consultant> Date Prepared: <Date>
Project No.: <00000-0000-00>
TOTAL LENGTH(miles): 0.00
OFFICE TRAVEL TIME PER DAY(hrs): 0.00
CREW TRAVEL TIME PER DAY(hrs): 0.00
OFFICE CADD
PARTY CHIEF
INSTRUMENT
MANAGER
FLAGGER
FLAGGER
RODMAN
RODMAN
PROJECT
TECH.
MAN
ACTIVITY
PM O P I R R F F Total
1.Establish & Stake Alignments
2. Update Survey
3. Control Traverses
4. Set Aerial Control
5. Bench Levels
6. Develop Digital Terrain Model
7. R.O.W.,Deed & Utility Research
8. Property Owner Contact
9. Locate Property & Pres. R.O.W.
Lines
10. Obtain Topo/Verify Aerial
11. Drainage Surveys (Culverts)
12. Bridge Surveys (bridge details,
stream alignment, topo, profile, flood
plain sections, high water, etc.
13. Railroad Surveys
14. Utilities
15. Stake R.O.W. & Easements
16. Stake Sounding Holes
17. Note Reduction & other
Calculations
18. Plot Plan, Profiles, Property Map,
Drainage Map, Bridge Survey, Control
Point Table, etc.
19. Supervision
20. Travel Time (8 HOUR MAN-DAYS)
TOTALS (8 HOUR MAN-DAYS)
55ed01b8-84d2-40a6-9280-1d917654e540.xls
2/22/2011 3
SURVEY MANDAY ESTIMATE
PROJECT DESCRIPTION: Version 2.22
Route: <Route>
Description: <Description>
County: <County>
Consultant: <Consultant>
Project No.: <00000-0000-00>
TOTAL LENGTH(miles): 0.00
Date Prepared: <Date> Prepared By: <Name>
DIFFICULTY
DIFFICULTY
OFFICE
FIELD
REMARKS
Align. 0.5 0.5
Update 1.0 1.0 0 Survey Updates
Control 1.0 0.5
Aerial 0.0 0.0 0 0 NUMBER HORIZONTAL & NUMBER VERTICAL POINTS
Levels 1.0 1.0 ZERO IF NOT REQUIRED
DTM 1.0 1.0 100% PERCENT SKIPS 0 DTM WIDTH(feet)
Research 1.0 1.0 0 NUMBER OF TRACTS
Contacts 1.0 1.0
Property 1.0 1.0 1 DO NOT EDIT THESE CELLS
Topo 1.0 1.0 0.00 0.00
Culverts 1.0 1.0
Bridges 1.0 1.0 0 0 0 NUMBER OF SMALL, MEDIUM, LARGE BRIDGES
RR 1.0 1.0 0 NUMBER OF RR CROSSINGS
Utilities 1.0 1.0 5 Number of Different Utilities Involved
R.O.W. 1.0 1.0 FALSE TRUE TRUE TRUE DO NOT EDIT THESE CELLS
Geotech. 1.0 1.0 TRUE TRUE FALSE FALSE
1.0 0 0 0 Number of IP's, 1-stake, 2-stakes
Plotting 1.0 0 Number of Geotechnical Staking Points
1.0 #DIV/0! 8 - Hr MD/MILE not including travel
1.0 1.0 #DIV/0! 8 - Hr MD/MILE
55ed01b8-84d2-40a6-9280-1d917654e540.xls
2/22/2011 4
SURVEY LABOR DIRECT EXPENSES
SURVEY DIRECT LABOR COST
PROJECT DESCRIPTION:
ROUTE: <Route>
DESCRIPTION: <Description>
COUNTY: <County>
CONSULTANT: <Consultant> Prepared By: <Name>
TOTAL LENGTH(miles): 0.00 Date Prepared: <Date>
Abbrv. Personnel Classification 8 - Hr Man-Days Approved Hours Rate Per Hr Direct Labor
1 PM PROJECT MANAGER 0.0 8.0 $ - $ -
2 O OFFICE CADD TECH. 0.0 8.0 $ - $ -
3 P PARTY CHIEF 0.0 8.0 $ - $ -
4 I INSTR. MAN 0.0 8.0 $ - $ -
5 R RODMAN 0.0 8.0 $ - $ -
6 R RODMAN 0.0 8.0 $ - $ -
7 F FLAGGER 0.0 8.0 $ - $ -
8 F FLAGGER 0.0 8.0 $ - $ -
TOTALS 0.0 $ -
Direct Labor Cost Per 8 - Hour Man-Day #DIV/0!
Version 2.22
55ed01b8-84d2-40a6-9280-1d917654e540.xls
2/22/2011 5
SURVEY LABOR DIRECT EXPENSES
Version 2.22
SURVEY DIRECT EXPENSES
PROJECT DESCRIPTION:
ROUTE: <Route>
DESCRIPTION: <Description>
COUNTY: <County> Prepared By: <Name>
CONSULTANT: <Consultant> Date Prepared: <Date>
TOTAL LENGTH(miles): 0.00 Project No.: <00000-0000-00>
Item Subtotal Item Total Cost
Reproduction Costs
Item Description Number / Unit Unit Price
Xerographic Bond 0 $ - $ -
Blueline Fullsize 0 $ - $ -
Photo-Copies 0 $ - $ -
Deeds 0 $ - $ -
Subtotal $ -
Travel
Survey Crew Travel Calculations
From:
To:
Number of Trips No. of Miles/No. of People * RATE
Travel Day Per Diem 0.00 Man-Days X 0.00 People X $ 0.00 Per Day $ -
Non Travel Day Per Diem 0.00 Man-Days X 0.00 People X $ 0.00 Per Day $ -
Transportation 0.00 Man-Days X 0.00 Miles X $ 0.00 Per Mile $ -
Lodging 0.00 Nights X 0.00 People X $ 0.00 Per Person $ -
Subtotal $ -
Office Personnel Travel Calculations
From:
To:
Number of Trips No. of Miles/No. of People * RATE
Travel Day Per Diem 0.00 Man-Days X 0.00 People X $ 0.00 Per Day $ -
Non Travel Day Per Diem 0.00 Man-Days X 0.00 People X $ 0.00 Per Day $ -
Transportation 0.00 Round Trips X 0.00 Miles X $ 0.00 Per Mile $ -
Lodging 0.00 Nights X 0.00 People X $ 0.00 Per Person $ -
Other Expenses Subtotal $ -
Item Description Number / Unit Unit Price
0 $ - $ -
0 $ - $ -
0 $ - $ -
0 $ - $ -
0 $ - $ -
0 $ - $ -
0 $ - $ -
Subtotal $ -
TOTAL DIRECT EXPENSES $ -
* Rate must agree with most current State of Tennessee travel regulations.
First and last day of travel must be at the 75% Per Diem Rate.
55ed01b8-84d2-40a6-9280-1d917654e540.xls
2/22/2011 6
DESIGN MANDAYS A
DESIGN MANDAY ESTIMATE PAGE A
ROUTE: <Route>
DESCRIPTION: <Description>
COUNTY: <County>
CONSULTANT: <Consultant>
Prepared By: <Name>
Date Prepared: <Date>
Project No.: <00000-0000-00> Version 2.22
I. PROJECT LENGTH (enter project length in miles) MILES
II. TYPICAL SECTIONS (enter length of appropriate section or sections)
A. NEW ALIGNMENT
1. Freeway - Controlled Access 140 M.D./Mile 0.0 MANDAYS
2. Non - CA (w/shoulders) 140 M.D./Mile 0.0 MANDAYS
3. Street (curb & gutter) 150 M.D./Mile 0.0 MANDAYS
B. WIDENING
1. Freeway - Controlled Access 150 M.D./Mile 0.0 MANDAYS
2. Rural Roadway (w/shoulders) 140 M.D./Mile 0.0 MANDAYS
3. Street (curb & gutter) 155 M.D./Mile 0.0 MANDAYS
C. MISCELLANEOUS
1. Bridge replacement - rural 110 M.D./Mile (min. 75) 0.0 MANDAYS
2. Bridge replacement - urban 130 M.D./Mile (w/c&g) 0.0 MANDAYS
TOTAL SECTION II 0.0 MANDAYS
Place X in applicable sections. If over 20 properties/mile,
III. OTHER FACTORS enter actual number of properties/mile in row III-A-5.
(Do not mark more than one block per section.)
A. PROPERTIES/MILE
1. < 8 Tracts/mile NO CHANGE 0.0 MANDAYS
2. 8-12 Tracts/mile ADD 5% 0.0 MANDAYS
3. 13-16 Tracts/mile ADD 10% 0.0 MANDAYS
4. 17-20 Tracts/mile ADD 15% 0.0 MANDAYS
5. > 20 Tracts/mile ADD 15% + 0.0 MANDAYS
(1/2%/Tracts >20)
B. TERRAIN
1. Mountainous or Rolling
with high cuts/fills ADD 15% 0.0 MANDAYS
C. PLAN SCALE
1. 100 Scale DEDUCT 10% 0.0 MANDAYS
2. 50 Scale NO CHANGE 0.0 MANDAYS
3. 20 Scale ADD 10% 0.0 MANDAYS
Subtotal Mandays (page A) 0.0 MANDAYS
(Place X in adjacent block to remove instructions prior to printing.)
User Notice: It is the user's responsibility to verify information in this program is correct.
Page 7
55ed01b8-84d2-40a6-9280-1d917654e540.xls
2/22/2011
DESIGN MANDAYS B
DESIGN MANDAY ESTIMATE PAGE B
ROUTE: <Route>
DESCRIPTION: <Description>
COUNTY: <County>
CONSULTANT: <Consultant>
Prepared By: <Name>
Date Prepared: <Date>
Project No.: <00000-0000-00> Version 2.22
IV. ADDITIONAL FACTORS
Note: Consultant to provide supplemental information for items listed below as deemed necessary.
A. SIDEROADS
(Measure from end of radius return) 110 M.D./ Mile 0.0 MANDAYS
E. RIGHT-OF-WAY
1. Prop. ROW calls on Pres. Layout NO CHANGE 0.0 MANDAYS
2. ROW Detail Sheets Required 2 M.D./ Sheet 0.0 MANDAYS
F. PUBLIC INVOLVEMENT
1. Additional meetings (enter no. of mandays) 0.0 MANDAYS
2. Special displays & renderings (enter no. of mandays) 0.0 MANDAYS
3. Newsletters (enter no. of mandays) 0.0 MANDAYS
G. DRAINAGE
1. Retention/Detention Ponds (enter no. of mandays) 0.0 MANDAYS
2. Special details (enter no. of mandays) 0.0 MANDAYS
H. EROSION CONTROL PLANS
1. Additional EC phases (enter no. of mandays) 0.0 MANDAYS
2. Contour Sheets 5 M.D./Mile 0.0 MANDAYS
3. Detention basin design (enter no. of mandays) 0.0 MANDAYS
4. Special details (enter no. of mandays) 0.0 MANDAYS
I. PERMITS
1. Permit drawings (enter no. of mandays) 0.0 MANDAYS
2. Mitigation plans (enter no. of mandays) 0.0 MANDAYS
3. Revisions to plans (enter no. of mandays) 0.0 MANDAYS
J. GEOLOGY
1. Retaining Wall Concept sheets (enter no. of mandays) 0.0 MANDAYS
2. Soils and Geology sheets (enter no. of mandays) 0.0 MANDAYS
K. TRAFFIC CONTROL PLANS
1. Complex traffic control design (enter no. of mandays) 0.0 MANDAYS
2. Special details - TMP (enter no. of mandays) 0.0 MANDAYS
L. INTERCHANGES
1. Length of ramps 100 M.D./ Mile 0.0 MANDAYS
(Length being start of separate profile)
2. Urban interchange design (enter no. of mandays) 0.0 MANDAYS
M. NO. OF CONSTRUCTION PROJECTS
1. One construction project NO CHANGE 0.0 MANDAYS
2. Additional construction projects 20 M.D./ Project 0.0 MANDAYS
N. MISCELLANEOUS FACTORS
1. Value Engineering Reviews (enter no. of mandays) 0.0 MANDAYS
2. Constructability Reviews (enter no. of mandays) 0.0 MANDAYS
3. Signal Design (enter no. of mandays) 0.0 MANDAYS
4. Lighting Design (enter no. of mandays) 0.0 MANDAYS
5. Signing Design (enter no. of mandays) 0.0 MANDAYS
(enter no. of mandays) 0.0 MANDAYS
(enter no. of mandays) 0.0 MANDAYS
Subtotal Mandays (page B) 0.0 MANDAYS
Subtotal Mandays (page A) 0.0 MANDAYS
VI. TOTAL MANDAYS 0.0 MANDAYS
(Place X in adjacent block to remove instructions prior to printing.)
User Notice: It is the user's responsibility to verify information in this program is correct.
Page 8
55ed01b8-84d2-40a6-9280-1d917654e540.xls
2/22/2011
DESIGN LABOR & AVG. M.D.
LABOR RATES
ROUTE: <Route> Project No.: <00000-0000-00>
DESCRIPTION: <Description> PIN No.: <000000.00>
COUNTY: <County>
CONSULTANT: <Name>
Prepared By: <Name>
Date Prepared: <Date>
This sheet calculates the average mandays, labor cost, and average manday rate for each phase of a project.
In the shaded blocks, enter the manday rate for each classification of personnel and the estimated percentage
for both the total project and the individual phases.
Boxes that are not applicable should be left blank. Version 2.22
PERSONNEL MANDAY RATE
PROJECT MANAGER $ -
PROJECT ENGINEER $ -
ENGINEER $ -
CADD TECHNICIAN $ -
CAD DRAFTER $ -
TOTAL MANDAYS 0.00 M.D.
PERCENTAGE OF TOTAL PROJECT
PRELIMINARY PLANS 0.0 %
RIGHT-OF-WAY PLANS 0.0 %
CONSTRUCTION PLANS 0.0 %
TOTAL PROJECT 0.0 %
PRELIMINARY PLANS 0.0 % OF TOTAL PROJECT
MANDAYS LABOR COSTS
PROJECT MANAGER 0.0 % PREL. PLANS 0.0 M.D. $ -
PROJECT ENGINEER 0.0 % PREL. PLANS 0.0 M.D. $ -
ENGINEER 0.0 % PREL. PLANS 0.0 M.D. $ -
CADD TECHNICIAN 0.0 % PREL. PLANS 0.0 M.D. $ -
CAD DRAFTER 0.0 % PREL. PLANS 0.0 M.D. $ -
0.0 %
TOTALS PRELIMINARY PLANS 0.0 M.D. $ -
PRELIMINARY PLANS AVERAGE RATE PER MANDAY #DIV/0!
RIGHT-OF-WAY PLANS 0.0 % OF TOTAL PROJECT
MANDAYS LABOR COSTS
PROJECT MANAGER 0.0 % R.O.W. PLANS 0.0 M.D. $ -
PROJECT ENGINEER 0.0 % R.O.W. PLANS 0.0 M.D. $ -
ENGINEER 0.0 % R.O.W. PLANS 0.0 M.D. $ -
CADD TECHNICIAN 0.0 % R.O.W. PLANS 0.0 M.D. $ -
CAD DRAFTER 0.0 % R.O.W. PLANS 0.0 M.D. $ -
0.0 %
TOTALS RIGHT-OF-WAY PLANS 0.0 M.D. $ -
RIGHT-OF-WAY PLANS AVERAGE RATE PER MANDAY #DIV/0!
CONSTRUCTION PLANS 0.0 % OF TOTAL PROJECT
MANDAYS LABOR COSTS
PROJECT MANAGER 0.0 % CONST. PLANS 0.0 M.D. $ -
PROJECT ENGINEER 0.0 % CONST. PLANS 0.0 M.D. $ -
ENGINEER 0.0 % CONST. PLANS 0.0 M.D. $ -
CADD TECHNICIAN 0.0 % CONST. PLANS 0.0 M.D. $ -
CAD DRAFTER 0.0 % CONST. PLANS 0.0 M.D. $ -
0.0 %
TOTAL MANDAYS CONSTRUCTION PLANS 0.0 M.D. $ -
CONSTRUCTION PLANS AVG. RATE PER MANDAY #DIV/0!
TOTAL LABOR COSTS $ -
AVERAGE RATE PER MANDAY #DIV/0!
(Place X in adjacent block to remove instructions prior to printing.)
55ed01b8-84d2-40a6-9280-1d917654e540.xls
2/22/2011 Page 9
DESIGN DIRECT EXPENSES
DESIGN DIRECT EXPENSES
Version 2.22
ROUTE: <Route> Project No.: <00000-0000-00>
DESCRIPTION: <Description> PIN No.: <000000.00>
COUNTY: <County>
CONSULTANT: <Consultant>
Prepared By: <Name>
Date Prepared: <Date>
Item Subtotal Item Total Cost
Reproduction Costs:
(Enter quantity and unit price)
Item Description Number / Unit Unit Price
Photo-copies $ -
Full size bond $ -
Half size bond $ -
Full size vellum $ -
Half size vellum $ -
Full size mylar $ - $ -
Travel:
(Enter number of trips, people or milage, and rate)
Number of Trips No. of Miles/No. of People RATE *
Per Diem (75%) $ 0.00 Per Day $ -
Per Diem $ 0.00 Per Day $ -
Transportation $ 0.00 Per Day $ -
Lodging $ 0.00 Per Person $ - $ -
* Rate must agree with most current State of Tennessee travel regulations.
First and last day of travel must be at the 75% Per Diem Rate.
Other Expenses:
(Enter description, number and unit price.)
Item Description Number / Unit Unit Price
0 $ - $ -
0 $ - $ -
0 $ - $ -
0 $ - $ -
0 $ - $ -
0 $ - $ -
0 $ - $ - $ -
TOTAL DIRECT EXPENSES $ -
(Place X in adjacent box if allocation of direct expenses is to be different than total project allocation percentage.)
DIRECT EXPENSES PRELIMINARY PLANS 0.0 % $ -
DIRECT EXPENSES RIGHT-OF-WAY PLAN 0.0 % $ -
DIRECT EXPENSES CONSTRUCTION PLANS 0.0 % $ -
0.0 %
( Place X in box to remove instructions prior to printing.
0.0 0.0 (Do not edit or place data in these cells.)
0.0 0.0
0.0 0.0
55ed01b8-84d2-40a6-9280-1d917654e540.xls
2/22/2011 Page 10
FEE PROPOSAL
FEE PROPOSAL
ROUTE: <Route> Project No.: <00000-0000-00>
DESCRIPTION: <Description> PIN No.: <000000.00>
COUNTY: <County>
CONSULTANT: <Consultant>
Prepared By: <Name>
Date Prepared: <Date>
COMPLETE SURVEY SHEETS FIRST IF SURVEY IS INCLUDED IN THE CONTRACT.
PROCEED WITH FEE PROPOSAL IF SURVEY IS NOT INCLUDED.
This sheet computes percent net fee and performs fee proposal calculations for each phase of the project and total project.
Enter the appropriate overhead rate & fill in shaded boxes that apply for each phase. Version 2.22
Data For Fee Calculations
Overhead Rate = **
** (State Project Maximum overhead rate = 1.45)
** (Federal Project Maximum overhead rate per External Audit Report)
Design Direct Labor = $ -
Survey Direct Labor = $ -
Total Direct Labor = $ -
Cost for net fee basis = $ - * NOTE: Net Fee for Supplements shall be the same
Net Fee = (Rounded to Nearest Tenth) 0.0% * as the original contract. It may be necessary
to modify net fee calculated on supplement requests.
* Net fee is based on cost of contract not including direct cost and net fee as follows:
Survey & Design / Design Only Rates Survey Only Rates
$ 0 - $ 100,000 = 13.0% $ 0 - $ 50,000 = 13.0%
$100000 - $ 500,000 = 12.5% $ 50,000 - $ 200,000 = 12.5%
> $ 500,000 = 12.0% > $200,000 = 12.0%
(Place X in adjacent box to remove instructions prior to printing.)
SURVEYS
1 Direct Labor = $ -
2 Overhead (Overhead Rate = 0.0000 ) = $ -
(Overhead rate X direct labor)
3 Subtotal 1 + 2 = $ -
4 Net Fee = 0.0% (Rounded to nearest $10.) = $ -
(Direct labor X 2.35 X 0.NF)
5 Subtotal 3 + 4 = $ -
6 Direct Expense = $ -
7 Premium Labor = $ -
(Premium Labor is only eligible if the survey crew works greater than a 40 hour work week.)
8 Total Survey = $ -
(Total 5 + 6 + 7)
55ed01b8-84d2-40a6-9280-1d917654e540.xls
2/22/2011 Page 11
FEE PROPOSAL
Version 2.22
Preliminary Design
1 Direct Labor = $ -
2 Overhead (Overhead Rate = 0.0000 ) = $ -
(Overhead rate X direct labor)
3 Subtotal 1 + 2 = $ -
4 Net Fee = 0.0% (Rounded to nearest $10.) = $ -
(Direct labor X 2.35 X 0.NF)
5 Subtotal 3 + 4 = $ -
6 Direct Expense = $ -
7 Premium Labor = $ -
8 Total Preliminary Plans = $ -
(Total 5 + 6 + 7)
Right-of-Way Design
1 Direct Labor = $ -
2 Overhead (Overhead Rate = 0.0000 ) = $ -
(Overhead rate X direct labor)
3 Subtotal 1 + 2 = $ -
4 Net Fee = 0.0% (Rounded to nearest $10.) = $ -
(Direct labor X 2.35 X 0.NF)
5 Subtotal 3 + 4 = $ -
6 Direct Expense = $ -
7 Premium Labor = $ -
8 Total Right-of-Way Plans = $ -
(Total 5 + 6 + 7)
55ed01b8-84d2-40a6-9280-1d917654e540.xls
2/22/2011 Page 12
FEE PROPOSAL
Version 2.22
Construction Design
1 Direct Labor = $ -
2 Overhead (Overhead Rate = 0.0000 ) = $ -
(Overhead rate X direct labor)
3 Subtotal 1 + 2 = $ -
4 Net Fee = 0.0% (Rounded to nearest $10.) = $ -
(Direct labor X 2.35 X 0.NF)
5 Subtotal 3 + 4 = $ -
6 Direct Expense = $ -
7 Premium Labor = $ -
8 Total Construction Plans = $ -
(Total 5 + 6 + 7)
Total Project
1 Direct Labor = $ -
(Sum of Survey, Prel., R.O.W., & Const. Direct Labor)
2 Overhead (Overhead Rate = 0.0000 ) = $ -
(Overhead rate X direct labor)
3 Subtotal 1 + 2 = $ -
4 Net Fee = 0.0% (Rounded to nearest $10.) = $ -
(Sum of Survey, Prel., R.O.W., & Const. Net Fee)
5 Subtotal 3 + 4 = $ -
6 Direct Expense ( Itemize and attach ) = $ -
(Sum of Survey, Prel., R.O.W., & Const. Direct Expenses)
7 Premium Labor = $ -
(Sum of Survey, Prel., R.O.W., & Const. Premium Labor)
8 Total Project = $ -
(Total 5 + 6 + 7)
Total Contract $ -
DESIGN COST PER MILE #DIV/0!
SURVEY COST PER MILE #DIV/0!
TOTAL COST PER MILE #DIV/0!
55ed01b8-84d2-40a6-9280-1d917654e540.xls
2/22/2011 Page 13
FEE PROPOSAL SUMMARY
FEE PROPOSAL SUMMARY
ROUTE: <Route> Project No.: <00000-0000-00>
DESCRIPTION: <Description> PIN No.: <000000.00>
COUNTY: <County>
CONSULTANT: <Consultant>
Prepared By: <Name>
Date Prepared: <Date>
mark the appropriate box below an values for the initial ceiling will be calculated.
Version 2.22
Survey Fee Proposal Summary
Direct Labor Overhead Subtotal Net Fee Subtotal Direct Premium Total
Direct Labor & Direct Labor, Expense Labor Phase
Overhead Overhead, &
Net Fee
SURVEY $ - $ - $ - $ - $ - $ - $ - $ -
Design Fee Proposal Summary
Direct Labor Overhead Subtotal Net Fee Subtotal Direct Premium Total
Direct Labor & Direct Labor, Expense Labor Phase
Overhead Overhead, &
Net Fee
PRELIMINARY PLANS $ - $ - $ - $ - $ - $ - $ - $ -
RIGHT-OF-WAY PLANS $ - $ - $ - $ - $ - $ - $ - $ -
Subtotal Preliminary & $ - $ - $ - $ - $ - $ - $ - $ -
Right-of-Way Plans
CONSTRUCTION PLANS $ - $ - $ - $ - $ - $ - $ - $ -
Subtotal Preliminary, R.O.W., $ - $ - $ - $ - $ - $ - $ - $ -
& Construction Plans
Total Survey & Design $ - $ - $ - $ - $ - $ - $ - $ -
(Place a X in appropriate box indicating the point of the initial contract ceiling. Only one (1) block should have an X placed.)
(Note: (Survey thru Const. Plans) can be checked if no initial contract ceiling is to be set.)
Survey
Survey thru Prel. Plans
Survey thru R.O.W. Plans
Survey thru Const. Plans
Prel. Plans
Prel & R.O.W. Plans
Prel. Thru Const. Plans
INITIAL CONTRACT CEILING
Direct Labor Overhead Subtotal Net Fee Subtotal Direct Premium Total
Direct Labor & Direct Labor, Expense Labor Ceiling
Overhead Overhead, &
Net Fee
Contract will initially be
authorized for:
(Place X in adjacent box to remove instructions prior to printing.)
55ed01b8-84d2-40a6-9280-1d917654e540.xls
2/22/2011 14
SURVEY FORM REVISIONS
Version 2.22
REVISIONS TO EXCEL MAN-DAY SPREADSHEET
SURVEY FORMS
Date Worksheet Revised Version Description
6/1/1998 Survey Manday Changed travel time equations to match discussion at meeting of May 4, 1998.
6/1/1998 Survey Manday Form Instructions Changed travel time equations to match discussion at meeting of May 4, 1998.
6/1/1998 All Sheets Changed gray background to a lighter shade of gray for copying and faxing.
6/1/1998 Survey Summary Changed the number of decimal places on the English project length to two.
6/1/1998 Survey Summary Changed culvert site background to gray with red text to prompt for allowable manual input.
6/1/1998 Survey Labor & Direct Expenses Changed default values and some of the format of profit rate.
6/8/1998 Survey Manday Changed equation for mandays/km &mandays/mile to include only mainline length.
6/22/1998 Survey Summary & Survey Manday Changed travel time to allow for crew and aoofce varying rates.
6/22/1998 All Sheets Added Version Number on all pages except for Instructions Page.
6/22/1998 Survey Manday Form Instructions Modified Equations to match travel.
6/30/1998 Survey Summary 1.01 Added Round command to stop rounding problems. (Changed to version 1.01)
9/28/1998 Survey Summary 1.02 Modified to allow English Units Input (Changed to version 1.02)
1/7/1999 All Sheets 1.02 Eliminated metric, Combined with Design, Incorporated Invoice Sheet
2/22/1999 Several Sheets 2.00 See Design Comments
4/15/1999 Summary,Estimate, & Instructions 2.01 Modified Equations for Rounding Errors, Modified Mapping Check Box Errors, Updated Instructions. (Version 2.01)
4/4/2000 All Sheets 2.02 Duplicated row headings on page 2 of estimate, Removed page protection, Added sideroad list,
Added MD per mile less travel for information, Added contact person information,
Modified total length to exclude length of sideroad included in mainline width
4/4/2000 Survey Labor & Direct Expenses 2.02 Modified Direct Expenses to Update Travel Regulations, 20% of Per Diem is Travel Day, 80 % is not. Added
Cover Sheet New Print Button For In-House Use. Added Difficulty for Property Owner Contacts., Added Checklist Sheet for
Survey Items at Bottom of Cover Sheet
2/21/2001 Cover Sheet, Survey Summary,
Survey Manday Estimate,
Survey Labor & Direct Expenses &
Fee Proposal Added Crew Hour Workday Option to Work Sheets, split difficulty factor to office and field, and Made General Corrections
2/21/2001 All Sheets 2.10 (Changed to version 2.10)
3/5/2004 All Sheets 2.11
Changed TDOT logo to new logo
3/8/2004 Survey Invoice 2.11 Deleted Invoice Sheet
3/30/2007 2.2 Updated entire template
3/3/2010 Cover Sheet, Survey Summary, 2.22 Changed to version 2.22, Changed default crew work per day hours to 8, Revised default rural land character percentages,
Survey Manday, Survey Labor, Changed approximate obscured area default to 100%, Modified manday equations for line items 17 & 19 on project manager,
Direct Expenses, Fee Proposal Added difficulty factors to office and field travel time, Added footnote pertaining to premium labor, Removed travel rates
and reproduction unit prices, Added footnote pertaining to the use of the most current travel rates
55ed01b8-84d2-40a6-9280-1d917654e540.xls
15 15
SURVEY FORM REVISIONS
Revised By
JHW
JHW
JRG
JHW
JHW
JHW
JHW
JHW
JHW
JHW
JHW
JHW
JRG/JHW
JRG/JHW
JHW
JHW
JRG/JHW
JHW
General Corrections
JHW/WJG
JHW/WJG
JHW
FMM/JHW
JHW/JKH
& 19 on project manager,
55ed01b8-84d2-40a6-9280-1d917654e540.xls
16 16
DESIGN FORM AND FEE PROPOSAL REVISIONS
REVISIONS TO EXCEL MAN-DAY SPREADSHEET
DESIGN FORMS & FEE PROPOSAL SHEETS
Date Worksheet Revised Version Description
7/21/1998 All sheets 1.01 1) Add cover sheet, design direct expenses sheet, design form revisions sheet.
2) Added survey manday estimate sheets (Equations and factors match
survey estimate version 1.01.)
3) Added version to all sheets.
4) Added instructions to design sheets.
7/21/1998 Fee Proposal 1.01 Added equations eliminating need to input survey direct labor and direct
expenses seperately.
7/28/1998 Design Labor & Avg. M.D. Rate 1.02 1) Added round command to labor cost and Avg. M.D. rate formulas.
7/28/1998 All Sheets 1.02 1) Changed version No. to 1.02.
7/28/1998 Design Mandays 1.02 1) Added round command to total mandays column.
2) Add 3-5 lane curb and gutter typicals to section II (Typical Sections).
3) Deleted curb and gutter factors from section III (Other Factors).
4) Changed Section III A 5 from "Add 20%+(1/2%/tract>20).
7/28/1998 Fee Proposal 1.02 1) Rounded net fee to nearest $ 10 for Preliminary, R.O.W., Const, & Total.
10/20/1998 Design Mandays 1.03 1) Changed project length input from metric to English.
10/20/1998 All Sheets 1.03 1) Changed version to 1.03.
10/20/1998 Cover Sheet 1.03 1) Added Two Print Macro Buttons
12/14/1998 Fee Proposal 1.04 1)Corrected Survey direct labor equation in cell D18.
2)Added round command to formulas
12/14/1998 Fee Proposal Summary 1.04 1)Added sheet to workbook.
12/14/1998 All Sheets 1.04 1) Changed version to 1.04
2)Minor modifictions to sheets.
3) Changed location to input project description to cover sheet .
4) Changed shading for input areas.
12/14/1998 Design Mandays 1.04 1) Changed plan scales to English.
2) Modified instructions in other factors section.
12/14/1998 Design Direct Expenses 1.04 1) Add option to vary percentage of direct expense percentage.
12/14/1998 Design Manday Breakdown 1.04 1) Incorporated design labor into design labor & M.D. rate sheet and deleted.
1/7/1999 several 1.04 Referenced Project Summary for Header Information
2/22/1999 Several 1.04 Modified Fee Proposal, Cover Sheet, Corrected Estimate Equations
2/23/1999 All sheets 2.00 Changed version to 2.00
4/15/1999 All sheets 2.01 Changed version to 2.01
4/15/1999 Fee Proposal 2.01 Changed information under total project
4/4/2000 All sheets 2.02 Changed version to 2.02
4/4/2000 Design Direct Expenses 2.02 Changed travel expense rates block.
4/4/2000 Design Mandays 2.02 Changed curb and gutter descriptions
4/4/2000 Fee Proposal 2.02 Added instruction regarding net fee calculation.
3/5/2004 All Sheets 2.11 Changed TDOT logo to new logo
3/8/2004 Design Invoice 2.11 Deleted Design Invoice Sheet
3/30/2007 2.2 Updated entire template
4/9/2008 Design Mandays 2.21 Minor updates to shts A & B (formerly 7 & 7A); changed version to 2.21
3/3/2010 Design Mandays B 2.22 Changed contour sheets criteria from 20 md/mile to 5 md/mile
55ed01b8-84d2-40a6-9280-1d917654e540.xls
2/22/2011 17
DESIGN FORM AND FEE PROPOSAL REVISIONS
Version 2.22
Revised By
MA
MA
MA
MA
MA
MA
MA
MA
MA
MA
MA
MA
MA
MA
MA
MA
MA
MA
MA
MA
JRG
JHW
MA
MA
MA
MA
MA
MA
MA
JHW/WJG
JHW
FMM/JHW
FMM
FMM/JHW
55ed01b8-84d2-40a6-9280-1d917654e540.xls
2/22/2011 18
SURVEY MANDAY FORM INSTRUCTIONS
Information regarding use of Project Summary/Manday Estimate form.
Definition of a project with a 1.0 Difficulty Factor
1. Land lays flat to rolling.
2. Project is semi-rural (Urban portion = 50% residential, 5% business, 45% rural)
3. Rural portion is 50% wooded.
4. 10% DTM skips
5. No severe wetlands or other environmental concerns.
6. Project is in proximity to existing roadways requiring pavement
checks of the aerial mapping.
7. Aerial mapping is available.
8. Three or fewer underground utilities.
Input is required only in the gray cells with red text. Replace the red text with
values appropriate to the project.
Following is an explaination of the formulae used in the spreadsheets:
DF = difficulty factor, L = Total length of project = Mainline length + Side road length
Engineer = The person responsible for the day to day supervision of the project.
This person likely will use CADD software for engineering/survey calculations.
CADD = Office CADD Technician = The person or functions pertaining to drafting
type duties.
Crew = A party chief, an instrumentman, two rodmen and occasional flagmen when needed.
These designations are used to show survey functions. Actual party size may
vary.
Each formula assigned to the crew is used for each of the four crew members.
No formulae are given for flagging. Input the number of days needed directly
into the spreadsheet.
crew - L * DF / 0
(The underlying
55ed01b8-84d2-40a6-9280-1d917654e540.xls
19 19
SURVEY MANDAY FORM INSTRUCTIONS
1. Establish and stake alignments:
Engineer - L * DF / 2.48 miles per manday
CADD - L * DF / 3.72 miles per manday
crew - L * DF / 0.5 miles per manday
2. Update Survey:
Engineer - 1/2 * Party Chief Mandays * DF
CADD - 1/2 * Party Chief Mandays * DF
crew -Number of Updates * 3 crew days per update * DF
3. Control Traverse:
Engineer - L * DF / 1.86 miles per manday
CADD - L * DF / 6.21 miles per manday
crew - L * DF / 1.49 miles per manday
4. Set Aerial Control:
Engineer - 1 day if there are any H or V points
CADD - zero
crew - 6 H points per day + 6 V points per day times DF
5. Bench Levels:
Engineer - L * DF / 6.21 miles per manday
CADD - L * DF / 6.21 miles per manday
crew - L * DF / 1.86 miles per manday
6. Develop DTM:
Engineer - L / 1.86 miles per manday + add 10% if no mapping is available
CADD - L / 1.24 miles per manday + add 10% if no mapping is available
crew - 500 feet per manday per 300 feet of DTM width
A reduction in mandays of 40% is required when there is no mapping available
and the assumption of 100% skip areas is used. (The assumption is that simply
picking up DTM skips is much more dificult that picking up 100% of an
average project)(If you have no mapping, input 100% for the skip area
which results in far too much time, thus the reduction)
7. R.O.W. Utility Research:
Engineer - 1 day per 30 tracts
CADD - 1 day per 30 tracts
8. Property Owner Contact:
Engineer - 1 day per 15 tracts
Party Chief - 1 day per 15 tracts
9. Locate property & row lines:
Engineer - # tracts * DF * 10 tracts per manday
CADD - # tracts * DF * 10 tracts per manday
crew - # tracts * DF * 6 tracts per crewday
10. Obtain topo verify aerial:
Engineer - L / 3.11 miles per manday
CADD - L * DF / 1.55 miles per manday + add 65% if no mapping is available
crew - L * DF / 0.31 miles per crewday + add 50% if no mapping is available
11. Drainage Surveys (Culverts)(Q<500 cfs):
Engineer - L / 1.55 miles per manday (Approx. 17 culverts per manday)
CADD - L / 1.55 miles per manday (Approx. 17 culverts per manday)
crew - L * DF / 0.5 miles per manday (Approx. 5 culverts per manday)
(The underlying assumption is one pipe culvert every 500 feet)
55ed01b8-84d2-40a6-9280-1d917654e540.xls
20 20
SURVEY MANDAY FORM INSTRUCTIONS
12. Bridge Surveys:
Engineer - sum of all bridge crossings*DF / 2 bridges per manday
crew - 1 crewday per small crossing * DF
1.5 crewdays per medium crossing * DF
2 crewdays per large crossing * DF
A small bridge is 20ft to 60ft long
A medium bridge is 60ft to 150ft long
A large bridge is greater than 150ft
13. Railroad Surveys:
Engineer - 1/3/ manday per railroad crossing * DF
CADD - 1/3 manday per railroad crossing * DF
crew - 2/3 crew day per railroad crossing * DF
14. Utilities:
Engineer - L * DF / 6.21 miles per manday
CADD - L * DF / 2.48 miles per manday
crew - L * DF / 0.37 miles per manday
15. Stake R.O.W. and easements:
Engineer - (Cadd Tech mandays/8 + Party Chief Mandays/7) * DF
CADD -(Iron Pin Points + 1 Stake Points + 2 Stake Points) * 150 Pts. Per manday * DF
crew - (Iron Pin Points/25 Points per day + 1 Stake Points/40 Points per day + 2 Stake
Points/35 Points per day) * 150 Pts. Per manday * DF
16. Stake Soundings:
Engineer - (Number of Points /300 points per manday)*DF
CADD - (Number of Points /150 points per manday)*DF
crew - (Number of Points /40 points per manday)*DF
17. Note Reduction:
Project Manager - L * DF* 1.0 mandays per 1 mile
18. Plotting: Plotting time is for creating paper plots only.
Engineer - .25 * Cadd Tech mandays * DF
CADD - L * DF* 1.61 mandays per 1 mile
19. Supervision:
Engineer - 1.0 mandays per 1 mile * DF
20. Travel:
Engineer - (Office daily travel time / 8hrs in a working day )* 3 total trips to the project
CADD - (Office daily travel time / 8hrs in a working day )* 1 total trip to the project
crew - ((crew daily travel time / 8hrs in a working day) * sum of days as calculated
in items 1-16.) divided by ((8 hours in a working day - crew daily travel time) / 8 hours
in a working day))
55ed01b8-84d2-40a6-9280-1d917654e540.xls
21 21
Related docs
Other docs by ahl18156
