ࡱ>  `\pThomas J. Bittner Ba=   =(bCd8S@"1& LinePrinter1Arial1Arial1Arial1Arial1&  LinePrinter1.Times New Roman1.Times New Roman1& LinePrinter1&  LinePrinter1&$ LinePrinter1( Arial Narrow1( Arial Narrow1( Arial Narrow1(  Arial Narrow1(  Arial Narrow1( Arial Narrow1( Arial Narrow1( Arial Narrow1(  Arial Narrow1( Arial Narrow1(  Arial Narrow1(  Arial Narrow1(  Arial Narrow1(Q Arial Narrow"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) General_) mm/dd/yy_) 0.00_) 0.0%0_) 0.000%"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)$[$-409]dddd\,\ mmmm\ dd\,\ yyyy[$-409]mmm\-yy;@[$-409]mmmm\ d\,\ yyyy;@ mm/dd/yy;@ m/d/yy;@ "$"#,##00_);[Red]\(0\) mm/yyyy                + ) , *    ) ( 1  1 ! #       ! !  %         % #    !  ! ! # & @ @ ! # & ""@ @  @ @  # % #@ @  %     # ! # # !          %  ! & @ @  ! ! %     @ @ %     !             1    1 !  #  #@ @  #@ @    &      & !    %     #  ! #@ @ #  @ @  #    1 1@@ 1 @ @ 1@ @ 1@  1 @  1@   1q@ @  q@ @  q@ @  1q@ @  1w@ @  w@ @  w@ @  1w@ @  w@ @  1w@ @   @ @  1 w@ @  1 w@ @  w@ @   (@   (  !8@   8  1<@   8   8  8  1 < !/ /  /  /!/  /% /  / % /  1w@ @ /  w@ @ /  w@ @ /  1w@ @ /   q@ @   w@ @   q @   w @   w@ @ /   w @ /   @ @ /    @ /  q@@  w@@ /  w@@  @@ /  & @ @  & @ & @ @ & @ &  &  &  &   & @ @  & @ @  & & & @ @ & @ & @  *  * & /&  / & / &  / &  & @ @ &   &  *   ! ! !  ! 1@@  1@  1 @   8@  8  8@  8  !8@   8 "x@@  "x @   8ff3 ``i̙3f3̙ff33333f33f33BBB\`T>PBW_AAPRzPBW_MPRPBW_MPR_SummaryCOST GUIDELINES @ENRIREAD ME,ADJSIZE<ADSIZE2<<BLDGREMO:CCONCOST:zENR: ENR:   ;2  ;  ;  ;2  ;' Print_Area_MI;TOTBLDG:zTOTCONST:aTOTCONST:f"fnfX8@rj0 3 A@@  `$THE UNIVERSITY OF WISCONSIN SYSTEM PROJECT TITLE: Date Prepared :LOCATION :  Prepared By :OPTION NO. : TOT PROJ COST EST:NEW BUILDING AREA ASF New Const  GSF New Const REMODELING AREAEscalation Factor: GSF Remodeling GSF Total BldgEst. Occup. Date :Space CategoryASFEffGSF$/GSF Subtotal: $Trade CategoryGeneral -Surface Treatment -Minor -Partial -CompletePlumbing -Special Laboratory NeedsElectric#SUBTOTAL BUILDING / REMODELING COST >>>>>> $>>>>>>> >>>> $ TOTAL PROJECT BUDGET ESTIMATENOTES: -Heat/Vent/Air CondNEW CONSTRUCTION BY SPACE TYPEREMODELING BY SPACE TYPEREMODELING BY TRADESUBTOTAL CONSTRUCTION COSTSUBTOTAL REMODELING COST,ADDITIONAL CONSTRUCTION / REMODELING COSTS:ESCALATION FACTORFunction Revised By:/GSF: Total Project Cost/ASF: Total Project Cost)/ASF: Construction Cost (building & site))/GSF: Construction Cost (building & site) Efficiency Remodeling4SUBTOTAL BUILDING / REMODELING COST (from page 1)- Asbestos Abatement3. Additional Site Costs1. Demolition#2. Hazardous Materials Remediation - SpecifyDESIGN CONTINGENCY>>>> $'SUBTOTAL UN-ESCALATED CONSTRUCTION COST2. Additional Design Services- Pre-planning- Systems Furniture design- Reimbursible costs- HazMat consultant- Basic Services4. Special Construction5. Utility Extensions+6. Special Mechanical / Electrical Systems3. Project Contingency4. DSF Project Management- Food Service- Audio-Visual - Computer Equipment- Systems Furniture"7. Fixed Furnishings and Equipment$1. Architect/Engineer Basic Services- Testing & Balancing- EIS/EIA consultant- Commissioning (specify level)NEW CONSTRUCTION REMODELINGHAZMAT ABATEMENT DEMOLITIONSPECIAL CONSTRUCTIONA/E BASIC SERVICESA/E ADDITIONAL SERVICESPROJECT CONTINGENCYDSF MANAGEMENT FEE TOTAL FEESSPECIAL & MOVABLE EQUIPMENTPERCENT FOR THE ARTSMAJOR PROJECT BUDGET SUMMARYMAJOR PROJECT BUDGET WORKSHEET$ Base Date:Projected Bid DateBid Date Index: Base IndexProjected Bid Index1. Architect/Engineer Services2. Project Contingency3. DSF Project Management5. Movable Equip. Allowance6. Special Equipment7. Percent for the Arts4. Movable Equip. Allowance5. Special Equipment 1. Demolition"2. Hazardous Materials Remediation - Parking - Specify>This template has several changes from the previous worksheet:1.2.3.4.5.6.7.(CONSTRUCTION COST GUIDELINES 2007 - 2009 Efficiency %$/ GSFRemarksClassroom BuildingAcademic  Multi UseFine Arts AuditoriumFine Arts Instructional LabsFood Service BuildingLaboratory SpaceLibraryOffice BuildingsvFor offices as part of other buildings with higher costs/ GSF use average of office cost and the other space type costPhysical Education BuildingsResidence Hall- Semi-Suite Doubles (Type 2)- Suite Style (Type 3) 130 - 140 Student UnionAgricultural Buildings#Pole Barn, includes fixed equipmentPole Barn, unheated!Service and Maintenance BuildingsStorage Buildings50 - 60Pre-fab metal buildingParking 500 stalls 100 stalls$25,000  40,000/ stall 200 stalls- Instructional Dry Lab- Instructional Wet Lab- Research Lab- Animal Space- Computer Lab- Instructional Greenhouse- Research Greenhouse- Arena - Field House- Pool- Animal Housing - Hay Storage - Unheated- Heated- Freestanding ramp- Ramp beneath building - Surface Lot65 225 - 250 400 - 600 170 - 180 250 - 280 155 - 160 130 - 145 255 - 280 200 - 220 500 - 540 180 - 200 220 - 250 250 - 290 380 - 410 145 - 165 155 - 175 185 - 215 140 - 150$44,000 - $50,000/ bed$59,000 - $70,000/ bed80 - 9070 - 80$10,500  12,500/ stall$2500 - $4000/ stall90 -100100 -120 120 - 135- LEED"! certificationXXXX#ALL AGENCY PROJECT BUDGET WORKSHEETThe Bid Date Index value is now automatically filled in when the bid date is assigned. Use only January or July dates. For bid dates in othe months use the nearest January or July after the desired bid date. TOTAL CONSTRUCTION COST There are now two budget worksheets& the Major Project Budget Worksheet [PBW_MPR] and the All Agency Project Budget Worksheet [PBW_AAPR].(F GP Y| } /Since most major projects will go through a pre-planning process, and that process will determine the budget for enumeration, the Major Project Budget Worksheet [PBW_MPR] has been simplified to require less detail. The primary method of cost estimating will be to use $/GSF. The line item costs on page 2 will be only for those items that are extraordinary, not normally covered by a $/GSF calculation, and for which there is a reliable cost information. Examples include an unusual amount of excavation, special foundations, or major extensions of utilities.  In addition to the Major Project Budget Worksheet there is a Major Project Budget Summary [PBW_MPR_Summary] that will accompany the major project request document when submitted to DOA. This sheet is automatically completed when the Major Project Budget Worksheet is filled in.1 =Y Zk  Since most A/E's use a design contingency when developing budgets both budget worksheets now contain a design contingency calculation. 10% is normal for major projects, but consideration should be given to use of higher amounts for complex remodeling projects.* Additional Design Services line items on the Major Project Budget Worksheet should only be completed for those line items for which there is relatively high degree of confidence in the estimated number. -K The All Agency Project Budget Worksheet [PBW_AAPR] is to be used for All Agency funded projects. Since most All Agency funded project budgets are developed using line items, this worksheet is organized with more line items on page 2.' (2  For an All-Agency project the Major Project Budget Worksheet [PBW_MPR] and the Major Project Budget Summary [PBW_MPR_Summary] can be deleted. For a major project, the All Agency Project Budget Worksheet [PBW_AAPR] can be deleted. Other worksheets are linked and should not be deleted.=FOkl}OComments should be deleted by firtst unprotecting the worksheet (Tools|Protection|Unprotect Sheet...), then placing the mouse over the cell in which the comment occurs (cells with comments have a small red triangle in the upper right hand corner of the cell), right-clicking, and then selecting the "Delete Comment" option pop-up menu.Ad,: Trade Cost Category Cost(SUBTOTAL CONSTRUCTION/REMODELING COST TOTAL PROJECT BUDGET ESTIMATE#2007-2009 CAPITAL BUDGET WORKSHEETS !""5""#c$vP%c&"&'`(s)&)* ,+? + K,^ c-v .$ . K/^/020C1V71 =cc  $xD=R]gtIu  dMbP?_*+%-cjg&L&"Arial Narrow,Regular"&8&D&C&"Arial Narrow,Regular"&8&A &Z&F&R&"Arial Narrow,Regular"&8page &P of &N&?'?(?)?M\\UWSYSADM\UWSA_CPB2_HP9050DN_dXXLetter.HP LaserJet 9050 PCL62xekSQ3i]xEuq h.JYtfJnETRqOQ+\Qp!SyY9ߙ3̜/IE-K]\!PFCi݀Awy+l`+}Ha;+VK׹ndCnBoA焴%dqҍCJc?B4N[>r@yaW_?Iwވ~#Al tYCx -ҍq&j`Y#5ED_H*'c u=f}hQlXފ(9d͹* g|=8Zh9ZyY@; ti/~KZ#7v׎*jc>]._TʝUϴIlNE(ˉ^̮ﴙxs;l'01"t:Sx.y@[z"dXX??cU} } }  }  } U }  }  } U                     %%%%% ! %% !   !%kAj?@!/AJ !   !4 5%6%%% %0% 7 !   !% DwA!%%%%%%%% ! %%%%%%% ! D %%% !c%~ lC@ !   DC $-DD A~DD B %5 % !f %/ %c@ D@; Bf !8$%% !d %~ mC@ %64%% !e %/ %c@ D @; Bf  !  64%% !  %' '? _D @D @A !~  4%%%%% !~ C$ -D DA~D DB %6% !%~ lC@&&&&&&&&99999999 -T:&&&&;& < ; ; = ; >>> e/fIg3D DDA B~ h ib-DDA%####!#B :U8888&;8 < && > >> >& & , &&D"@A-DDA& , &&D:@A-DDA& , &&DF@A-DDA& , &&DL@A-DDA& & , &&D$@A-DDA& , &&A*@A-DDA& , &&A1@A-DDA&D- l20eR:f&d:ic2&V&Z&wwww&ww !"#$%&'()*+,-./0123456789:;<=>? , && DC@ A- D D A & !'!& ", "&&"D*@"A-" D"D"A"& #, #&&#D8@#A-#"D#D#A#& $, $&&$DC@$A-$#D$D$A$& %%& &, &&&&D$@&A-&$D&D&A&& ', '&&'D0@'A-'&D'D'A'& (, (&&(D5@(A-('D(D(A(&)&&&&&% );/)(%(GA*%%%%%!#% +" +CCCCC +1!.+)D@D)@A,"CCCCC"E-"CCCCC"E."CCCCC"E/% /DPROJECT TITLE: /C eDX/%%%%%% 0!70%%CCC 01!0+D+@1!%%CCC"E2%%%%%%%% 3--3&&&&&&& 4Fp4&&&H,&/40%56GA 5I< 5&&&~ 5 5,&8 6I< 6&&&~ 6 6,&87,&&&H,&8 8Fq8&&&&,&/84%9:GA 9Q8 9&&&~ 9 9&&8 :I< :&&&~ : :&&8;J&&&K&&8 <F9<&&&&,&/<8%=?A =Qr =&&&~ = =,&8 >Is >&&&~ > >,&8 ?Is ?&&&~ ? ?&&8D( lw&www&wwwWbsP&W<<W<<W<<@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_@J&&&K&&8 AFFA&&&K&&/A<%BCGA BI< B&&&~ B B&&8 CI< C&&&~ C C&&8DJ&&&8&&8 EFGE&&&8,&/EA%FKGA FI< F&&&~ F F&&8 GI< G&&&~ G G&&8 HI< H&&&~ H H&&8 II< I&&&~ I I&&8 JI< Jj&&~ J J&&8 KI< K&&&~ K K&&8LJ&&&K&&8 MFHM&&&L,&/ME%NUGA NI< N&&&~ N N&&8 OI< O&&&~ O O&&8 PI< P&&&~ P P&&8 QI< Q&&&~ Q Q&&8 RI< R&&&~ R R&&8 SI< S&&&~ S S&&8 TI< T&&&~ T T&&8 UI< U&&&~ U U&&8VH&&&K&&& WFOW&&&K,&/WM%XYGA XI< X&&&~ X X&&& YI< Y&&&~ Y Y&&&Z&&&&&&&8 [-[:::: [-" [.>N[/W8$0@$4@$8@$<@$A@$E@$M@$W@BA\%%%%%%%% ]-?]::NN ]-" ].>]/[D[@^%%%%%%%# _-._&_O? aC_&&&&8D lW<<W<<<<<<W<<<<<<<<W<<\` a b c d e f g h i j k l m n o pqrstuv w xyz{|}~`,&P88,&8 a-a::NN a-" a.>-a/ fD_D]@Ab-::NN-.Nc-::NN-.Nd-::NN-.Ne% eDPROJECT TITLE: eC DXe%%%%%%/f! ]Da (from Page 2)(%TOTAL CONSTRUCTION COST (from Page 2)f%%CCC f1>f` hCf g!%%CCC1#g hFhh&~ hM @h8.h hDhDfA h,&(h jDhAiQ&%%%,&8 jFij&~ jR.@j jDf-j jDjDjA j,&*j lDjA!AkJ&P8&&&8 lFjl&~ lS@%l lDfDjG~-l lDlDlA l,&*l nDlA!Am&&&88&&8 nFnn&~ nRn nDf-n nDnDnA n,&*n wDnA!AoHHUKKHHK pFop&T88,&/pf%quGA qQL q&&8~ q qV&8 rQM r&&8~ r rV&8 sQN s&&8~ s sV&8 tQK t&&8~ t tV&8 uI< u&&8~ u uV&8v,&&8K,&8 w"$wCCCC w"" w1#8w2 }"$f@$h@$j@$l@$n@$p@BxCCCCCCC% y4%\y pFDfDD AA~DfDD AB yX3yYY%% z4%\z yFDfD D AA~DfD D AB zX4zYY%%{4%YYYY%% |4%\| zFDwDD AA~DwDD AB |Z2|%%%% }%%\} |FDwD D AA~DwD D AB }Z1}%%%% ~"%~%%%%%%% [&%%%%%%%D lms$W<<<<<x& [&%%%%%%%:< %     Ae (    Bp XPP?Z [ ]4@p' g{OC5c V<WInsert only January or July dates using nearest date on or after anticipated bid date.<V N  B XPP?7]Z ^]4@t' @gHޕ <15% per DSF guidelines<u~ N  B$ XPP?IX [i]4@$' #$@7i? B<C8% per DSF guidelines. Additional fees are covered by contingency.<BB N  Jeff KosloskeAh Jeff KosloskeAj Jeff KosloskeA>@<d 7ggDggh'h@  $~qŶf  dMbP?_*+%<hjg&L&"Arial Narrow,Regular"&8&D&C&"Arial Narrow,Regular"&8&A &Z&F&R&"Arial Narrow,Regular"&8page &P of &N&?'?(?)?M\\UWSYSADM\UWSA_CPB2_HP9050DN_dXXLetter.HP LaserJet 9050 PCL62xekSQ3i]xEuq h.JYtfJnETRqOQ+\Qp!SyY9ߙ3̜/IE-K]\!PFCi݀Awy+l`+}Ha;+VK׹ndCnBoA焴%dqҍCJc?B4N[>r@yaW_?Iwވ~#Al tYCx -ҍq&j`Y#5ED_H*'c u=f}hQlXފ(9d͹* g|=8Zh9ZyY@; ti/~KZ#7v׎*jc>]._TʝUϴIlNE(ˉ^̮ﴙxs;l'01"t:Sx.y@[zA!.!…0rQ"dXX??cU} } }  }  } U }  }  } U    x@     x@         x@   a%%%%% ! %% !   !%3Aj?@!AJ !   !4 5%6%%% %0% 7 !   !% D@A!%%%%%%%% ! %%%%%%% !  D %%% !c%~ lC@ !   DC $>-DD A~DD B %5 % !f %/ %c@ D@; Bf !8$%% !d %~ mC@ !  64%% !e %/ %c@ D @; Bf  !~  4%% !  %' '? dD @D @A !~ C $-D D A~D D B %6 %%%%%%%%% !%~ lC@99999999 -(:&&&&;& < ; ; = ;> >& /I 3D DDA B~ -DDA& ?/@I3D DDA B~ A-DDA& ?/@I3D DDA B~ A-DDA& ?/@I3D DDA B~ A-DDA& /I3D DDA B~ -DDA&&# %@@8# %@@8 ,/%@@GA& &+8888,8D%####!#B -):&&&&;& < ; ; = ;> >& /I3D DDA B~ -!DDA& ?/@I3D DDA B~ A-DDA& ?/@I3D DDA B~ A-DDA& ?/@I3D DDA B~ A-DDA&Dl20eR:f&d:uo:&hD&h !"@#$%&'()*+,-./0123456789x@:;<=>? / I 3D  D D A B~  - D D A &!&#!  % @@!8#!! % @@!8 !,/!!% @@GA!&"&8888&,8 #:*#8888&;8 $< $&& $> $>$> $>$& %%& &, &&&&D"@&A-& D&D&A&& ', '&&'D:@'A-'&D'D'A'& (, (&&(DF@(A-('D(D(A(& ), )&&)DL@)A-)(D)D)A)& **& +, +&&+D$@+A-+)D+D+A+& ,, ,&&,A*@,A-,+D,D,A,& -, -&&-A1@-A--,D-D-A-& ., .&&.DC@.A-.-D.D.A.& /'/& 0, 0&&0D*@0A-0.D0D0A0& 1, 1&&1D8@1A-10D1D1A1& 2, 2&&2DC@2A-21D2D2A2& 33& 4, 4&&4D$@4A-42D4D4A4& 5, 5&&5D0@5A-54D5D5A5& 6, 6&&6D5@6A-65D6D6A6&7&&&&& 7,J764%&)@@%+.@@%02@@%46@@BA7& 8&,8&&&&,8P87:D! D7 B$ ERRORD!D7B9%%%%%!#% :" :CCCCC :1!.:8D@D8@A;"CCCCC"E<"CCCCC"E="CCCCC"E>%0 -DPROJECT TITLE: >CT jDX>%%%%%% ?!7?%%CCC ?1!?:D:@A!D0l&Z&wwww&wwww&www&wwwzxbs@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_@!%%CCC"EA%%%%%%%% B--B&&&&&&& CF: C&&&~ CG C,&'C?DCAD,&&&H,&8 EF;E&&&&,&/EC%FGGA FQ8 F&&&~ F F&&8 GI< G&&&~ G G&&8HJ&&&K&&8 IF9I&&&&,&'IEDJA JI< J&&&~ J J&&8KJ&&&K&&8 LFFL&&&K&&/LI%MNGA MI< M&&&~ M M&&8 NI< N&&&~ N N&&8OJ&&&8&&8 PFGP&&&8,&/PL%QTGA QI< Q&&&~ Q Q&&8 RI< R&&&~ R R&&8 SI< S&&&~ S S&&8 TI< T&&&~ T T&&8UJ&&&K&&8 VFHV&&&L,&/VP%WXGA WI< W&&&~ W W&&8 XI< X&&&~ X X&&8YH&&&K&&& ZFOZ&&&K,&/ZV%[\GA [I< [&&&~ [ [&&& \I< \&&&~ \ \&&&]&&&&&&&8 ^-^:::: ^-" ^.>N^/Z8$?@$C@$E@$I@$L@$P@$V@$Z@BA_%%%%%%%%D l&eW<<O<W<<W<<<<W<<W<<` a b c d e f g h i j k l m n o pqrstuvwxyz{|}~ `C= `%%%~ `M$@ `%%-`^D`D^@Aa%%%%%%%# b-?b::NN b-" b.>$b/`$^@$`@Bc%%%%%%%# d-.d&dO? fCd&&&&8e,&P88,&8 f-f::NN f-" f.>-f/ kDdDb@Ag-::NN-.Nh-::NN-.Ni-::NN-.Nj%X >DPROJECT TITLE: jC| jDXj%%%%%%/k! bDf@ (from Page 2)(%TOTAL CONSTRUCTION COST (from Page 2)k%%CCC k1>k` nCk l!%%CCC1#l mFPm&%88,&/m r%noGA nQEn&~ nMn8.n oDnDkA n,&8 oQCo&~ oM@o8-o mDoDn@A oH&8p,&P8K&&8 qF@q&P8K&&/q {%ryGA rQAr&~ rM?r8.r uDrDkA r,&8 sQ s&P8~ sG s&&8 tQBt&~ tM@t8.tkDtDA t&&8 uQSu&~ uMu8.u qDuDkA u&&8 vQR v&P8~ v v&&8 wQD w&P8~ w w&&8 xQQ x&P8~ x x&&8 yI< y&P8~ y y&&8 zJ z&P8 z& z&&8 {FI{&~ {R@{ {Dk-{ {D{D{A {,&*{ }D{A!A|J&P8&&&8 }FJ}&~ }S@%} }DkD{-} }D}D}A },&*} D}A!A~&&&88&&8&&T88H&8D lkdLms$WrqWr<rr<<<<<   Fk&~ R @ Dk- DDA ,&* DA!AHHUKKHHK Fl&T88,&/t%GA QL &&8~  V&8 QM &&8~  V&8 QN &&8~  V&8 QK &&8~  V&8 I< &&8~  V&8,&&8K,&8 Fm&~ W?= '$k$m$q${$}$$B- DDA ,&' DA%%%%%%%# "$CCCC "" 1#B2 ,$k@$m@$q@${@$}@$@$@$@BCCCCCCC% 4%\ FDkDD AA~DkDD AB X3YY%% 4%\ FDkD D AA~DkD D AB X4YY%%4%YYYY%% 4%\ FDDD AA~DDD AB Z2%%%% %%\ FDD D AA~DD D AB Z1%%%% "%%%%%%%% [&%%%%%%% [&%%%%%%%.YW<<<<<&&l %   > A2  D    e4  (    B XPP? i [ ]4@P' =CS W<XInsert only January or July dates using nearest date on or after anticipated bid date. <W N  B XPP?%= n?]4@ '  qnCO5 <From WALMS or DSF estimate< N  Bd XPP?IHi K]4@dl'  e1Ou1/o T<UExtensive utility extensions or pro-rated share of central utility improvement costs<uT A  Bȱ XPP?nU- VK]4@ȱT' OF^Ğ <New factor. Normally 10% < N  B, XPP?a< ei]4@,' ERH]FcV F<GNormally 4% of A/E fee. Includes survey, geotechnical, and plan review<QF| A  B XPP?fZ g]4@' _;F0 <Ranges from 1/2% to 1.25%< A  B XPP?m p]4@' yaG')c  5<6Type I: $50,000 - $75,000 Type II: $20,000 - $35,000<5 A   BX XPP?iK k]4 @X'  [VA+A|R (<)Up to an additional 1% for highest level<( N   B XPP?ri u]4 @D' Эp%LV֒i 5<6Use 5% to 10% of construction cost as a rule-of-thumb<5 A  Jeff KosloskeuF Jeff KosloskeuQ Jeff Kosloskeu` Jeff Kosloskeuo Jeff Kosloskeur Jeff Kosloskeuu Jeff Kosloskeuv Jeff Kosloskeu Jeff Kosloskeu>@<d 7ggDggh'h@  3'  dMbP?_*+%jg&L&"Arial Narrow,Regular"&8&D&C&"Arial Narrow,Regular"&8&A &Z&F&R&"Arial Narrow,Regular"&8page &P of &N&?'?(?)?M\\UWSYSADM\UWSA_CPB2_HP9050DN_dXXLetter.HP LaserJet 9050 PCL62xekSQ3i]xEuq h.JYtfJnETRqOQ+\Qp!SyY9ߙ3̜/IE-K]\!PFCi݀Awy+l`+}Ha;+VK׹ndCnBoA焴%dqҍCJc?B4N[>r@yaW_?Iwވ~#Al tBx -ҍq&j`Y#5ED_H*'c u=f}hQlXފ(9d͹* g|=8Zh9ZyY@; ti/~KZ#7v׎*jc>]._TʝUϴIlNE(ˉ^̮ﴙxs;l'01"t:Sx.y@zA!.!…0rQ"d"XX??cU} #"}  "}  "} U "}  "} U "3        `%%%%% ! %% ! ZX  !%]Aj?@! Z ! ZX  !4\ ZXXX%6%%% %0%^ ZXXX ! ZX  !%D%%%%%%%% ! %%%%%%% ! ` Z %%% !c%nC@ Z !  ` Z  $ Z  %5 % !f % %c@ Z  %64%% !d % oC@ Z  %64%% !g % &c@ Z  !  64%% !  % '? C !  0Z  4%%%%% ! Z $ Z  %6% !%nC@ Z!($%%!%) !( Z X3Y+Y) !( Z X4Y+Y)!(*YY+Y) !( Z Z2%!%) && Z Z1&&&&99999999%__%%%%% ,T__%%%%` Z ,U__%%%%` Z^ ,W__%%%%` ZC ,Vaa%%%%` ZE ,Xaa%%%%%` ;IZG~,aa%%%%` -+aa%%%%/ Z^,bb%%%%` ,= __%c? !Z` %%` Z`D l20X&zNNXEPPPPFFFFMF !"#$%&'()*+,-./01 2  ,%%%%%%` !-?!%%%%%%!/ Zb"-%%%%%%d #-. #%%%#'? Zd #%%d$,%%%%%%` %-%%%%%% %.>%/ #C&,%%%%%%` ',Y '%%%'c %Zn '%%'` .Zm (,Z(%%%%%%(` )Zq ),[ )%%%)cQ? 'Z{ )%%)` *Z{ *,\ *%%%*c{Gz? )Z} *%%*` ,Z}+%%%%%%%` ,0],%%%%% ,.>#,/ * %'*-%%%%%%%` .C^.%%%%% ..>%./ (;G~/%%%%%%%` 0C_ 0%%%0${Gzd? 'Z0% 0.>0/ 0Z1%%%%%%%` 2"2%%%% 2"" 21#22 0Z*PhFPPpFppWYz`   >   P N  02 0 (     Bl XPP? -]4@l' 2MJʒ^ I<JThis worksheet will auto-complete based on Major Project Budget Worksheet<dIr N Jeff Kosloskeo>@ 7bb,ggD  3X  dMbP?_*+%jg&L&"Arial Narrow,Regular"&8&D&C&"Arial Narrow,Regular"&8&A &Z&F&R&"Arial Narrow,Regular"&8page &P of &N&?'?(?)?M\\UWSYSADM\UWSA_CPB2_HP9050DN_dXXLetter.HP LaserJet 9050 PCL62xekSQ3i]xEuq h.JYtfJnETRqOQ+\Qp!SyY9ߙ3̜/IE-K]\!PFCi݀Awy+l`+}Ha;+VK׹ndCnBoA焴%dqҍCJc?B4N[>r@yaW_?Iwވ~#Al tYCx -ҍq&j`Y#5ED_H*'c u=f}hQlXފ(9d͹* g|=8Zh9ZyY@; ti/~KZ#7v׎*jc>]._TʝUϴIlNE(ˉ^̮ﴙxs;l'01"t:Sx.y@[zA!.!…0rQ"dXX??cU} *"}  }  } *} *} U 3+@x@      |p q r s} s~ sptuvvvp wxAy@P@ z wp {|A}@P@ ~ {p{|}~{p {|@}@P@ ~ {p{|}~{p {|j@}O@ ~ {p {|}~{p { |L@}@P@ ~ {p {|}~{p  p  |j@}N@ ~ {p |j@}M@ ~ {p |j@}K@ ~ {p |L@}K@ ~ {p |j@}@P@ ~ {p |@}T@ ~ {p |j@}T@ ~ {p{|}~{p {~ |@  ~ {p{|}~{p {|L@}@P@ ~ p{|}~{p L@Q@  p |@}S@ ~ {p |@}R@ ~ {p |@}S@ ~ {p{|}~{p p |A}T@ ~ {pDl"P@@@@@"@@@@@@@FJ@@@@" !"#$%&'()*+,-./012  |@}T@ ~ { p!{|}~{p "{~ "|j@"} "~ "{p#{|}~{p $$p %%|@}@U@ %~ %{%p &&|L@}V@ &~ &{&p'{|}~{p ({(|j@}@U@ (~ ({p){|}~{p **p ++|@@}W@ +~ +{+p ,,|@@}W@ ,~ ,{,p-{{}~{p ..p / /{~ /}K@/~ /{/p 0 0{~ 0}J@0~ 0{0p 1 1{ 1}~ 1{1p2*2hJB"JJ@"JJ"LLB>@  7bb*ggDggh'h     dMbP?_*+%&C&A &Z&F&R7/13/07M\\UWSYSADM\UWSA_CPB2_HP9050DN_dXXLetter.HP LaserJet 9050 PCL62xekSQ3i]xEuq h.JYtfJnETRqOQ+\Qp!SyY9ߙ3̜/IE-K]\!PFCi݀Awy+l`+}Ha;+VK׹ndCnBoA焴%dqҍCJc?B4N[>r@yaW_?Iwވ~#Al tYCx -ҍq&j`Y#5ED_H*'c u=f}hQlXފ(9d͹* g|=8Zh9ZyY@; ti/~KZ#7v׎*jc>]._TʝUϴIlNE(ˉ^̮ﴙxs;l'01"t:Sx.y@[z"dXX??cU} U     C@c@@~ Y@Ƴ@%  LLA~ @~ p@+@~ @~ `@@~ @~ `@@~ @~ @f@~ @~ @Ե@~ @~ @D@~ @~ @@ ~ @~ `@ *@ ~ @~ `'@ @ ~ @~ >@ @6~ @d;;;;;;;;; /  6>@ 7bb+ggD  * _  dMbP?_*+%jg&L&"Arial Narrow,Regular"&8&D&C&"Arial Narrow,Regular"&8&A &Z&F&R&"Arial Narrow,Regular"&8page &P of &NM\\UWSYSADM\UWSA_CPB2_HP9050DN_dXXLetter.HP LaserJet 9050 PCL62xekSQ3i]xEuq h.JYtfJnETRqOQ+\Qp!SyY9ߙ3̜/IE-K]\!PFCi݀Awy+l`+}Ha;+VK׹ndCnBoA焴%dqҍCJc?B4N[>r@yaW_?Iwވ~#Al tYCx -ҍq&j`Y#5ED_H*'c u=f}hQlXފ(9d͹* g|=8Zh9ZyY@; ti/~KZ#7v׎*jc>]._TʝUϴIlNE(ˉ^̮ﴙxs;l'01"t:Sx.y@[z"dXX??U} } c*;     @@   t  u   v   w   x   y   z   {       Dl  !"#$%&'() !"#$%&'(), >@" 7bb-ggDgghWh  Oh+'0p X`| budget worksheetCAPITAL Planning & BUDGETThomas J. BittnerMicrosoft Excel@ο @)@6GoC' x7&" WMFC>* p1pQl2 EMFpQ xEP4F, EMF+@``F\PEMF+"@ @ $@ 0@?!@ @     !" !" !  " !  '~}h%  ~}h   &~}h% 6% Ld!??% $6$% Ld$$$!??% 565% Ld555!??% F6F% LdFFF!??% W6W% LdWWW!??% y6y% Ldyyy!??% 6% Ld!??% 6% Ld!??% 6% Ld!??% 262% Ld222!??% 6% Ld!??'%  Ld!??%  ~}h% 6% Ld!??% 6% Ld!??% Rp"LinePrinter$e @f0bh@f&e  l 0bh@f$e g0bh $e 0`h$e k:0 3Arial NaD0 D lY $e dv%    TT "AA LP1TT '4AA 'LP2TT 8EAA 8LP3TT IVAA ILP4TT kxAA kLP5TT |AA |LP6TT AA LP7TT!(AA!LPATTZ`AAZLPB% " !%   '%     Ld$r!??Rp Arial Narrow5 g0Bi g5  l0Bi g5 h0Bi 5 0@i5 k:0 3Arial06 v l6 v5 k4D dv% Rp Arial NarrowĮ g0Bi gƮ  l 0Bi gĮ h0Bi Į 0@iĮ k:0 3Arial06 p l6 pĮ k4D dv%    TXX"gAAXLP1.Rp Arial Narrow|8 g0Bi g~8  l 0Bi g|8 h0Bi |8 0@i|8 k:0 3Arial06 y l6 y|8 k4D dv% % Rp  Arial Narrow6 g0Bi g6  l 0Bi g6 h0Bi 6 0@i6 k:0 3Arial06 w l6 w6 k4D dv% % % % % % % % " !% %   3Xy% % % % % % % % % % % % % %   T<5XgAA5X(LThere are now two budget worksheets& the  % TXgAAXLMajor Project Budget Worksheet  % TTXgAAXLP % TXgAAX L`[PBW_MPR]  % TX gAAX L` and the % TXegAAXLtAll Agency Project T5ixAA5iLlBudget Worksheet % TTixAAiLP % TixAAi L`[PBW_AAPR] % TTixAAiLP.% % % % " !% %     TX"AALP2.% &" WMFC ppQ% % % % % " !% %   3% % % % % % % % % % % % % % % % % % % % % %   Tl5NAA5LXSinceTdSgAASLTmostTllAAlLXmajorT|AAL\projectsTdAALTwillTXAALPgoTxAAL\throughTTAALPaT@AA Ldpre-planningT|ElAAEL\process,T`pAApLTandTdAALTthatTxAAL\processTdAALTwillTAA L`determineT`AALTtheTp5AALXbudgetT`9EAA:LTforTIAAI Ldenumeration,T`4BAA5LTthe% TlHcAAHLXMajor TxhAAhL\ProjectTpAALXBudgetTAA L`Worksheet % TLAALL% T.AA L`[PBW_MPR]  % TLAA/LLT`4DAA4LThasTdJaAAJLTbeenTgAAg L`simplifiedTXAALPtoTxAAL\requireTdAALTlessTxAAL\detail.T`AALTTheTx;AAL\primaryTpAbAAALXmethodTXhoAAhLPofTdtAAtLTcostT5aAA5 L`estimatingTdfsAAfLTwillTXxAAxLPbeTXAALPtoT`AALTuseTpAALX$/GSF.T`AALTTheTdAALTlineTd AALTitemTl&AALXcostsTX+6AA+LPonTd;RAA;LTpageTTW\AAWLP2Td`mAA`LTwillTXr}AArLPbeTdAALTonlyT`AALTforTlAALXthoseTlAALXitemsTdAALTthatT`AALTareTHAALhextraordinary,T`MZAAMLTnotT|^AA^L\normallyTx5[AA5L\coveredTX`kAA`LPbyTTqvAAqLPaTl{AA{LX$/GSFTAA Ldcalculation,T`AALTandT`AALTforTlAALXwhichTl4AALXthereTX9?AA9&WMFCppQLPisTTEJAAELPaT|OpAAOL\reliableTdvAAvLTcostTAA Ldinformation.T|AAL\ExamplesTxAAL\includeTX)AALPanTx.RAA.L\unusualTpXyAAXLXamountTX~AA~LPofT5UAA5BLexcavation, special foundations, or major extensions of utilities.% % % % " !% %   % % " !% %   6F  T6EEAA6>LThis template has several changes from the previous worksheet:% % % " !% %   $  T #AA#L2007-2009 CAPITAL BUDGET WORKSHEETS     % % " !% %   % % " !% %   ' % (   ( &% 6% Ld!??% 6% Ld!??% 6% Ldq!??% $6$% Ld$$$q!??% ( % " !%   % " !%   ' %   % 6% Ld!??% 6% Ld!??% " F4(EMF+*@$??FEMF+@     '' ' ,~}h- ~}h ~}h-- @ !-$$- @ !$-55- @ !5-FF- @ !F-WW- @ !W-yy- @ !y-- @ !-- @ !-- @ !-22- @ !2-- @ !-  @ !- ~}h-- @ !-- @ !-"LinePrinter-  2  1 2 ' 2 2 8 3 2 I 4 2 k 5 2 | 6 2 7 2 !A 2 ZB"System-'- ,-   @ !r Arial Narrow- Arial Narrow-   2 X1. Arial Narrow- -  Arial Narrow- - - - - - - -'- - ,yX3- - - - - - - - -- -- --  C2 X5(There are now two budget worksheetsthe  - 42 XMajor Project Budget Worksheet  - 2 X - 2 X [PBW_MPR]  - 2 X and the - $2 XAll Agency Project 2 i5Budget Worksheet - 2 i - 2 i [PBW_AAPR] - 2 i.-- - -'- - ,  2 2.- - - - - -'- - ,3- - - - -- -- -- -- -- -- -- -- --  2 5Sincet 2 Smost2 lmajort2 projects 2 will 2 go2 throughs 2 a2  pre-planning2 Eprocess, 2 pand 2 that2 process, 2 will2  determinei 2 the2 budget 2 :for2 I enumeration, 2 5the- 2 HMajort 2 hProject,2 Budget2 Worksheeto - 2 - 2 [PBW_MPR]o  - 2 / 2 4has 2 Jbeen2 g simplified 2 to2 require 2 less2 detail. 2 The2 primary2 Amethod 2 hof 2 tcost2 5 estimating 2 fwill 2 xbe 2 to 2 use2 $/GSF. 2 The 2 line 2 item2 costs. 2 +on 2 ;page 2 W2 2 `will 2 rbe 2 only 2 for2 those.2 items. 2 that 2 are2 extraordinary, 2 Mnot2 ^normally2 5coveredy 2 `by 2 qa2 {$/GSFe2 calculation, 2 and 2 for2 whiche2 theree 2 9is 2 Ea2 Oreliable 2 vcost2  information.2 Examples2 includes 2 an2 .unusuals2 Xamount 2 ~ofj2 5Bexcavation, special foundations, or major extensions of utilities.-- - -'- - ,- -'- - ,F6 d2 6>This template has several changes from the previous worksheet:-- -'-- ,$ <2 #2007-2009 CAPITAL BUDGET WORKSHEETS     - -'-- ,- -'-- ,-  -- @ !-- @ !-- @ !q-$$- @ !q$- -'- ,-'- ,- -- @ !-- @ !-'՜.+,0HP X`hp x '  PBW_AAPRPBW_MPRPBW_MPR_SummaryCOST GUIDELINESENRREAD ME PBW_AAPR!ENRENR'COST GUIDELINES'!Print_AreaPBW_AAPR!Print_AreaPBW_MPR!Print_AreaPBW_MPR_Summary!Print_Area'READ ME'!Print_AreaPBW_AAPR!TOTCONST TOTCONST  Worksheets Named Ranges   !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry FWorkbook}SummaryInformation(8pDocumentSummaryInformation8