Docstoc

Print Design Proposal - Excel

Document Sample
Print Design Proposal - Excel Powered By Docstoc
					          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




d3ad6fac-a592-46d9-8223-66e425201589.xls
7/8/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




d3ad6fac-a592-46d9-8223-66e425201589.xls
7/8/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




                                                     CADD TECH.


                                                                  PARTY CHIEF


                                                                                INSTRUMENT
                                           MANAGER




                                                                                                               FLAGGER




                                                                                                                             FLAGGER
                                                                                             RODMAN



                                                                                                      RODMAN
                                           PROJECT




                                                      OFFICE




                                                                                    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)




      d3ad6fac-a592-46d9-8223-66e425201589.xls
      7/8/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




       d3ad6fac-a592-46d9-8223-66e425201589.xls
       7/8/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




   d3ad6fac-a592-46d9-8223-66e425201589.xls
   7/8/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.




d3ad6fac-a592-46d9-8223-66e425201589.xls
7/8/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
       d3ad6fac-a592-46d9-8223-66e425201589.xls
       7/8/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
      d3ad6fac-a592-46d9-8223-66e425201589.xls
      7/8/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.)




d3ad6fac-a592-46d9-8223-66e425201589.xls
7/8/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




     d3ad6fac-a592-46d9-8223-66e425201589.xls
     7/8/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)




d3ad6fac-a592-46d9-8223-66e425201589.xls
7/8/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)




d3ad6fac-a592-46d9-8223-66e425201589.xls
7/8/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!




d3ad6fac-a592-46d9-8223-66e425201589.xls
7/8/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.)




d3ad6fac-a592-46d9-8223-66e425201589.xls
7/8/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




d3ad6fac-a592-46d9-8223-66e425201589.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,




                   d3ad6fac-a592-46d9-8223-66e425201589.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




d3ad6fac-a592-46d9-8223-66e425201589.xls
7/8/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




d3ad6fac-a592-46d9-8223-66e425201589.xls
7/8/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




d3ad6fac-a592-46d9-8223-66e425201589.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)




d3ad6fac-a592-46d9-8223-66e425201589.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))




d3ad6fac-a592-46d9-8223-66e425201589.xls
21                                                                21

				
DOCUMENT INFO
Description: Print Design Proposal document sample