Loading...
HomeMy WebLinkAbout2010-190 CONT Addendum - Pathway Enterprises , . ADDENDUM TO CITY OF ASHLAND CONTRACT FOR JANITORIAL SERVICES Addendum made this ~ day of November, 2010, between the City of Ashland ("City") and Pathway Enterprises ("Contractor"). Recitals: A. On September 3, 2010 , City and Contractor entered into a "City of Ashland Contract for Janitorial Services" (further referred to in this addendum as "the agreement"). B. The parties desire to amend the agreement to increase the compensation to be paid to Contractor to compensate for the livina waae increase effective June 30. 2010. City and Consultant agree to amend the agreement in the following manner: 1. The compensation will increase from $73,560.32 to $75,840.54 for a total annual increase of $2,280.22 for the current fiscal year due to the living wage increase from $12.96 to $13.40 per hour effective June 30,2010. 2. Except as modified above the terms of the agreement shall remain in full force and effect. CONTRAeTOR: BY R fi;WtfhrfL- Ce-CJ DATE /~////I} Its CITY OF ~SHLAND: -L- BY ~ft\&'D I repartment Head Date 'V\ \ '1 lei Purchase Order # t:J-96 q CJ 1- CITY OF ASHLAND, ADDENDUM TO CONTRACT FOR JANITORIAL SERVICES, 11/112010 Pathway Enterprises, me. .. ISSA :~~~E: ". ...:q:e. on ap.~rli~~.al1d .V.;,int*n.:nce August 25, 2010 Kari Olson . Purchasing Representative City of Ashland 90 N. Mountain Ave. Ashland, OR 97520 Ms. Olson, After our recent exchanges regarding the increased Living Wage I have updated the previous proposal figures that were accepted in July, 2010. Overall, by incorporating the new Living Wage our annual price for services is increased from $73,560.32 to $75,840.54 for a total annual increase of $2,280.22. The updated changes for 2010 services are as follows - . . Service increases for the Police Department, City Hall and Community Development Center. . The increased Living Wage from $12.96 per hour to $\3.40 per hour. The following tables reflect the changes contained in the attached costing spreadsheets. THE GROVE SERVICE CENTER STREET AND SHOP POLICE DEPARTMENT CITY HALL COMMUNITY DEVELOPMENT MUNICIPAL COURT TOTAL ANNUAL COST TOTAL MONTHY COST THE GROVE SERVICE CENTER STREET AND SHOP POLICE DEPARTMENT CITY HALL COMMUNITY DEVELOPMENT MUNICIPAL COURT 2008 - 2009 REDUCTIONS 2009 - 2010 INCREASES 2010 - 2011 10,199.48 - 10,199.48 313.27 10,512.75 13,659.69 4036.91 9622.78 293.69 9,916.47 6,605.42 2,315.81 4,289.61 126.48 4,416.09 12,506.29 3,748.57 8,757.72 2,947.59 11,705.31 9,622.78 2,883.52 6,739.26 6,158.62 12,897.88 21,733.53 6,343.73 15,389.80 4,067.18 19,456.98 6,739.26 - 6,739.26 195.80 6,935.06 81,066.45 19,328.54 61,737.91 14,102.63 I 75,840.54 6,755.54 5,144.83 1,175.22 I 6,320.05 PROPOSED DAYS IWK PROPOSED HRS/DAY TOTAL HRS / WK TOTAL ANNUAL HRS 2 4 8 416 4 1.875 7.5 390 3 1 3 156 4 2.25 9 468 4 2.5 10 520 5 3.1 15.5 806 5 1 5 260 ~ Pathway Ente.. ' rises Inc. rp, .' ISSA {h~~:~: on (j"",in~'.nd ~.;;jnt.n;nce These changes will meet the budgetary goals set forward by the city while adding back valuable services to these community facilities. I truly appreciate the partnership we have with you and we hope to continue providing an expanding variety of services for you and your customers. Sincerely, Richard Simpson Contract Services Director Pathway Enterprises, Inc. 655 Washington Street Ashland, OR 97502 (541) 488-1536 (541) 601-4550 (541) 488-5948 . Ashland City Hall 2009.2010 Costing Workbook For Janitorial & Grounds Maintenance Contracts Under the Qualified Rehabilitation Facilities Program -'."'~':; :-. ',J' : .,.' . .' . ',",...- .' "'. ... Oregon State Department of Administrative Services Procurement, Fleet, and Surplus Services 1225 Ferry Street SE, U140 Salem, Oregon 97301 (503) 378-4642 , SUMMARY OF ANNUAL COSTS Oregon Department of Administrative Services Project Costing Worksheet The summary sheet is linked to the other sheets in this workbook. Any area shaded in light green is either a formula or linked to another work sheet. The only manual input to this sheet will be to input the QRF name. The costs are to be divided into five categories: Raw Materials, labor. Overhead, Delivery and Reserve Costs. Raw materials consist of supplies, small equipment & tools, and large or special equipment. Each category is detailed on the following sheets. Labor costs is direct labor used to produce or service the,contract. Overhead costs is a line item charge which is computed on the overhead sheet. Transportation or delivery and reserve computations are also completed on the following sheets. All these costs will vary depending upon your organization and the specifications for the project. Each sheet will have an example calculation and further instructions for completion. QRF Name Pathwa Enter rises, Inc. Project Cit of Ashland 2010-2011 Cit Hall Executive Director Signature: Raw Materials Per Time Use - Supplies Equipment, Tools & Subcontracting (from supplies worksheet) $ 233:29 (from small equipment worksheet) $ :, 486: 17, Subtotal 1 $ 719.46 (from labor daily worksheet) 1$ 8,824.97 I 1$ 2,579;58 I (from Trans & Reserve worksheet) 1$ Labor Direct Labor Overhead See Overhead Worksheet Delivery Transportation Total Before Marglnl $ 12, 124~OO I Reserve Margin Held in Reserve 1$ 773.87'1 12.'897:88,1 1,074.82 (from Trans & Reserve worksheet) Total Bid YearlYI'$ Monthly' $ DAS Form#12J Revision 10.03 Page 1 Summary Sheet , U J:~ M~ l' e~ .ijii s8 E i ~, '. " ~ . a ~ ~ 8 8 8 8 0 0 8 8 ~ 8 0 0 0 8 8 8 0 0 0 0 0 ~ ~ ,; i ,; ,; ~ ~ ,; ~ ,; ~ ,; ,; ~ . , l r , : . ~ ! ;; j " , ~. . , " ~ ~ ~ , ~ , . : . . , - ~ ~ . ., . 1; , , s . ", i ~ ! i', t , , .: ~ .8 ,', .; I ~ i ~ .:l ~ , ~ t I i , ~ . . ~ . .. . . . ~ a . i! > ;; E .f ~ " .. " ~. ~- . ~ ~ . " ~5 . ~ Iii ~ " i ~ Vi ]; ! \: , t ;; i ~ ~ ; ~~ ' ,;- c ; .~ ~ . .::. . . ~ .. . ~ , " , ~ J ~ -~ " ? . ~ ~ , .... . ;; .; ,. . ~ ; . r ~ . " , . ~ . ~ . , 0 .. .. . . . ~~ .. . . .. . . . . . ~~ ~. tg ~. 0 ~ ~ . . ~ l ,; 0 . . 0 . ;; , . . ~ , , .. . . . . .. . . . .. . . . . I;~ ~ ~- .; E. :!e " * " 0 ~ " . , . .. . .. . .. . ,,; . . . . . . ~ ~ ~ ~ . ~ 8 " ~ , . ~ ~ . . e . . ~ .. . ~ ~ . . .. . . . ~ . < ~ 0 ,; " * ~ " , I ~ ::i . , e . . . . .. . . . . ... . . e! ~ 'n ~. ~ . ~ . ,; ~ . << . ~ . . ~ u ~ ~ ~ ;; . ] H ~ . ~ ~ .~ '! I 0 . . Q . C ! "~ 8w ~.:l! ~~~ ....NI').,"''''...'''CI>~;:~~::!~ " . " ~ < ~~~ ~ . . ~ . ~ .. " . ~ ~ ,!1 ~ 8 l;' " E w " " . :J i ~ s5~ ~.s:A ~:5~ ti i . ;; 2" . E ~~ j!~ ~2 ,; ~~ ~ s~ ~ ~1l ; iJ ~ j~ ,I ~~ ~ E i: <: ~ 5 5l! 8.= ~g ls"8 "'.....w ~..~ ~~ ;f. <.!!-s ...~ 8 -5;;::! c: ~~ <: c~~ ,g::'l:: 5 ~ 1i ~ ::J 8. ;t.s: 8.~! ~~ o. .<olI e~:t15~ ~~~ g~~~%~~~8 1P~~ dr~~~ III lie 0 .. c:: '5 ti . Q.i~~5~~ '#. :s f! b_"'_'" 8.:1 g.!] ~~~~allllllS~ J::.80~~~fd-ei OJ::...";:"c $.!] e CD c "'.!!!.lII <II"""" <I).! ._.J:J i!- e'E'Gl..!E 0 r'II~<~~H~ I.~ ! ~ ~ ~ 0; 0; B ~ lo ~ . e ~:>. >. >.:5 -5 Gl ~ OIl:::: .10 ~e~~~~~ 0..., i~~ .\j1~.5 E"9]i.!!!]g.~,g ~ 'D ~ 8- >~e:E:Eoao=<Il .,~'" I~I."~~ ~ ~~~5~1:~~1;j I~.c 2'2'gogg,5~ 8t't:!~1; .I~~fi~~~;~ii~~gll If!" ~:s ~~ ~ ~ CIl.>>]i ~ ~;g. ~I]i E E E E 'B 'B ~ e ~ ~ l;j "'5 ~S~1;1;1;~ iJ~ <:.."!~!l!..E ,~~~1i:~~~~ 8~E5 ~5 1;1. ~1H.il.!;!;~ 8 ...~:; 01 01 Ii E E E ii &. -5.. .. i5 ...~,~u888.G.G 'i.~~~~~ ....... ..... e.............~o& ...o:;...e i::liis:!o 3'<>~:ij x.2.2.2.2'ii::l; .2.=1....:3x ~.g.g..g..g <: ~ ..g E &: ii <; ~ In In UH" ~ 1ii 10:. Ci'<> ~ i ... E!: 3 5t ii=g~ 5 ~:i.i ~ . ~~ :1-;; ~&~ zc:l!l ,0" !1J ~ -fi~ .!:1 ~8. .8~" s" u"21! ~oti .:;~ li~::: l~~ M1i :3. .., 2'"# .8~~ ~.. ~ ~~ .'6 ~N~ '.0 ~~fl o 8.~ :31!~ "e' ~...!!! c.5<J :1 ti e B~~ ~Ji dti.. ii!!-<: <:'6~ ~~i o.Eii .."'.<: ."- _Cia g~l .o~ B &-8 ~~~ i~.5 .. . ~~j <00 8.8.g, . -. ~~! So< ~E '6~~ ~ ~~ .8 go 8. .!!IE" .i ~ ~ ..< :g054; <I'i:~ ~!~ '6.<>-g .. . .. . ,!.<:15 .8~~ ~." .!'IE.... ~~~ .!'I.!:t; ~ g~ Ei~ h~ 08- ~ . :::S~ 1l~~~ .-<1 € ~~l6 ~'" ::l~_ .!!~o ~ 0< 0.....9: ~~ [i m!! S.8 O~~..!lI i~ ~~ & ~:~ cO~m }i!l1js .. "''''~ ~ ~ i ~~ a; .,j~ OI~c-o. .:!.s ~ ~;;'l ~.8~~~ H~~' ~ ~ ii f ~1l~~~ ~~;i~ l'i~U ...~~:5~ j~~!1I j'j ~..- E ~ i~5~~ i!:::l~"8 i;;.:l~g ~~s~.8 ~i i i"~ ~ E 8.5 e Sl ~ ~ ~~ 10 .!'I 0 0 U i': ~ ~j~l~....- ~U"..,i!; -ll ~"i g-~ _.8 g.'S \~p2. ~ ~~.;~~fi ~ t~ ~ ~ ~ ~ ., "'<:e J3.ssE~ -g.s~~~~ ~!!~~~f Ji~ e l:l!-g ~:: ~ 11 ~ 13 2SlO!;z ~i5. ,[~gt~~ :S;~1l~"&i ~ !~~o go s~'8..:E '":;~.2"~ i~~!!i~ .fii.5.5 f! 8- :2.!i::~<O Sl!!g-.2:.,~ ~"'"~i! ,,~~ s;,-8 g~~..sz .81i.;sio 1sj ~ 0; is ~~~e~1 e"l!l<i<:" ~~,'.~? -.~.. . i~n.!~1l. 5~~~~1i <:OEOI~" ~ii~~~~ ;i~~~~ ~_~ ts g.g.2: ~~~!if .' ~ ~ U..!'I-R !'! sn. g'1!! a. j~il~~ j ~ ~ ~~. HUH i3.i~ ~ ~! ~.. ~ - 0.0. :I (; ~J ~ 8- 0lI-t!t! '" ON ~!!j~~o - 0" ........:; H=HI -"5~~~~ f::~~"iie 0..,....:2.<: . 3: . [ i ~ t I . 11 ~ . I j 1 ~ i [ ~ ~ . J1 ~ ~8. H ~. .~ .< ~i ~e. ,g ~ t~ . i~ ef'. It"., ~~ .~~ ~~ h ,. li5 '!~ . .~ H _0 ~;; ~ e.., ~ .:111 do i~ ~ 15!5 .g H ~ ";'l t 8.- ~ i g, .2 S 'l;j~ i~ ~i H ~~ 5 ~ <( ~2 ~ 80s.! 0 Oi .6 ;~~~ g,i~~~ ~i;;:c'3 c.o < . ~ . . ~ ~ 5 d ;; ~ ." H -. .. 6. !~ .~ '~ ~g ~. ~i a,; i~ -~ 0" I~. .~ ~ " l;'< -" -g 8_ n H ~8 H ul'{ ~. 8~ !~ ~~ 8:8 -E~ H ~~ ]j~ ~! .~ .~ ~:i %~ ~" 8~ o' - i j~ ~~ ~~ "I is. .~ I" ~i h llt .- ~~. idE' .a~ So :; "'" ~3~ llj:i "!1i. !.., [ ~1:l ~88 ~~~ .X.. ~." -.- ~." ~h . . Q . . 1 ~ i " ~g .i~ ~~ ~~ " RAW MATERIALS Supplies Pathway Enterprises, Inc. City of Ashland 2010-2011 City Hall Raw Materials: This category is often spelled out in the Request for Offer (RFO). Language such as "Items to be provided by Contractor" will usually reflect Supplies or Raw Materials. [n the case of a Service Contract this will likely include not only supplles required to perform the service each month, but also Equipment & Tools. In the case 'of a commodity contract the Raw Materials will be figured on a Per Item Manufactured basis. Oregon Department of Administrative ~ervices Project Costing Worksheet A custodial contract, for example, may require the following for month - Supplies: Paper products and soap Cleaning chemicals or products Spray bottles Broom and dustpan Floor Wax Scrub brushes or scouring pads Per Use/Per Item Manufactured - Supplies 1 2 3 4 5 6 7 8 . 10 11 12 13 14 15 16 17 18 ,. 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 3. 40 Item Unit Units Needed Monthly An~ual Price Per Month Cost Cost Pine Q Disinfectant $ 4.80 0.1666 '$iiI" "",0 0~80r l$&t::i'Y';:~;: 9~60 Cream Cleanser $ 2.91 0.1668 :$J:.<,'fii-.':;,: 0:481 :'$tii~f~;;::w5;82: Glass Cleaner $ 6.29 0.1666 $t.tt::::;:~1~05~ i$~;f~:t:~1 2:57- Heavv Dutv Cleanser $ 4.80 0.1666 '$,';'" . 0:80} :$~i>-'fJ;;f{9:60 Oder Counteractant $ 30.65 '$" -"';:':::"(;~ i$t':"r'c,f;;/Z~,' Careet lane $ 5.00 $;' -";)C,/'/!}7!'U !$U);if;,\f,;:::;i Careet Shamooo $ 1 3.01 i $~~ '::1:;~'~<:::.:~H' f$~~~:r.;jf~1'!' 24 0' Bottle & tn er $ 2.27 0.1666 : $j:S'f.~18'; 0:381 !$B:.t1.M:4f.54' Ae lie Bowl Mo s $ 1 .71 0.5000 :$r:;{i~1;~t<t0:861 1$IlCZllll0'26' Sera er W/btades $ 6.51 0.1666 :$I",t':~':!K1[08r !$Ei,~;13!0,1; r OZ Pum s $ 2.31 0.1666 :$~W;"~~O~381 !$l'iC,j~,t5:;'~.'iAr62i Pa er Filter $ 21 .1 0 0.3332 (n~;:n'>.--'6~E031 [$1tt~84!37; Std loo end Mop $ 5.65 0.3332 r$~i;;;fj;'(<~~1~88' t$~22:59~ 24" Dust mop $ 4.26 0.1666 !;$l:t~${;;,:\:'~0!7tlI !$~1i~la:52! Doocllebua BN Pads $ 1 .16 0.1666 $r;,/~'~:I0!20! l$WnZ-;i(i-2!36! Duster . exoandable $ 5.75 0.1666 :$~~~:;:!7;~O:961 f$CK1M;t1~50' Soot Awav $ 2.74 0.3332 :$~"'.;~t~'\~;0:9_1r i$~~~;:t;1 0:96' Cleanina Pads $ 4.70 0.1666 ,: $~~~~;~;-c;,'1 0~7. at ~$JtZf:i?,4;:9;40 Wax Moo $ 6.60 0.1666 '$~:,:G/};/;'':,1n3t l$Ji~m-,,;;1 3:59' :$;.:.n:'(,'~-;,r~~~' t$~;l;];_~l';' :$~'/:;'~7:~-l~~ :n,r;e---EY~I',' . $L.1 ,:,;';.:~':~.:;;f'lt I $~~'wj;f_;;~~~, ;" : $_\>/t;:..:?(,?,,;::~ [$~;M;~'~:: $l~;t>j-JX~j~ ;$~~~~?(.m,,' $??-'j:',i;,,':,:'ft.";;'ll f$~{~~-;~:'?:'/ $r.,<<<::;;--':J':;_::.<~ I$Wfs;<;:?-:~:;-;,' , $t;:~";-'i'l1l'i.'~~;r:~ ;$~):i;0!'\:'~: $~~T?7Jr:~: [$~-:;rEiV~-~"" $t~~"r::';:i::-2;~J~ I $IJ~~~'f;":'::~,J,:.' ,-. $V-;:~:),i"},;:~:~t<: r$~:.f::;;*;:(:~~i~:, $lf-';ti;Y:',-;;~~il.~:: f.$m.'~~;\'~~~';T $i:.:"';- "!~':7~~&~ 1$lfjj;\,-U~:)':~":-'::' $'.' '>,-:~~~~ l$~,~':.:':;". $t i>t,"l!' l$fi'1T~~V'--'" $: ~;:>~,,:;:f ~ $li:.'r~:~{ :::; : '~':' I$;}~,\i';::~';'t:-;-~~~\ l $~":n:t~~:~,;;;?:: I :$~;:'i'.';'~(~}.~~~ ~$~~f~<':_:::': ','- $i.t';.g:~-Ji':r:.~W ~$m:::;j"~:S,j:;:;, !$"t7i;,;o"}Jl'!( 1$I~r"'~Q:;t.::~:- ;$~::;:-':;;t:::~;:'''~: r$W~ft:;';:;_~~: ." Total F,;"l 9:4'4" f$V -'0233:29, - ,..~.. ,,-.... __'___'_'~_'_~,m,---"""______ IJ\re:~~, 9f~~D.~[.~lorri1ul~:..t!rive~=.J Monthly Cost = Monthly cost is computed by multiplying the total unit cost by the units needed per month. Annual Cost = Annual cost is computed by monthly cost times 12 months. DAS Form #12 J Revision 10.03 Page 2 Supplies Sheet , :4: u . - ~ ~~ '" 0 ~;o ;l~ ~~. . . - 0 E., E- ~! _ e ;:.. c ~ . o. . e c o ~ E e U)~~...~ . . o.. = :: E>- gp=. o I- . ., E < " ~ ~ o . ., 0 .. ., :J '" c o ~ " u . . e tJ . e- o. " :s .5 . .~ 5 i c " j; '0 c ~ " 0 E " S 8 " 0 0 .5 u . 1; 5 c " 0 '" I 8. .0 " 0 .5 ~ .0. " . " c 0 .5 0 ~ 0 . . ~ ~ u S , E " .. !! .5 . 0 ~ ., e!~2 g - iiI ' . . . i:o ~ m ~~;g i;' " E E ~.~ ~ . ti . .. "e,s g!i j ~~i ~..!:.!!.!! E ~ " &::21 >.; " ,,~- Oa:g.c . ~5~ "- c 0 ~ E ~~ .s' ~2!:~ ~ 1lI:ic. elllC.I: E U<:!i! o'8.EIO E ~~ 0 :5 ~ ~:dij " ~ "C.~ l: " ~ a -g i .. . =1L~! " c " -. . ".5 ~1e.!! E 0" .. E 0 E ' ~ ., .g.~e; ~ . E w ~~ ::I III GI 0 a ".5 g-~:g 1; c :?af! '~-fi ~c ~ ~~ 8- ~.E.i: s 0_ - -~o >00" - . ~~ ~ a~~! ~ "H" " I- ....OZca . ~ ~ c 8,,_ -g.5~ en CI.l.,;o ..J<I/l~- :$..!:h=~ 0:: 8 e--c ~ I-..~~ <"wji " . 1:'<( :a: .~~'i5 <( a.1lI~ O::WCLU .. :I: " U ~gggg-.t ~in ~gg~g(. ,; ~ 8:;; (j ;.' :;: ~' i:', ~- c:( ~ '" ~ ~',... ,;. \; , ~~~!'?~ .~( f t , r , , ;~- l~' "O!1 ":5 _~oooc:d ~8~dci~ci e~f~~P~: CL5;~~;~ ;F.'#<f'.'$.* 00000 ~:8('H'\l8N e" .."#- .. ~o66'6 1O..~q9.~!=l: 8~~~~P2~ l! ... R ~ i~- ~, !\ CIl"'!ii''"'''''' :5 CL ~ f1<. ,:~' i~_ ,... ~~<I)~!,!;.. " c '#.;F. *-;F.;F.'': o ~ ~:nn:~ g ~ :; 3' ~. .." "" ~- ] i i . e , 2-lf e ';' ';~ ~ b , '" .." ~' .~.. ~ , u ~.. l::::= " ., ~~p~N~~~~~~~~~~ .l!!_~~~C!;~ =: ic:( ~o - . ~~ 00000 00000 c;gggg '<tIN'<t IN ..... IN- ~ .................... -< c 0 0" a~ -u , . ~. We . . " " . E ~ a ~ ffi ~~"-j"- @~~g~ -g g ~Ig'~ ~u:w::Em .....<NM'<tIOCOt-a;lo)~::~~:!~ ... j" " " ~ " . E ~ "5 ~ .w ~ '" ~ ;! .. "ii o I- . ;; 8 o S 1; < a 'E a 0. m S -'" < o o ~ , ." .5 .9 ~ ~ . JIl ~:;:J .~ ~ a." . < c 8 ~ .~ rnS ~2 ~ :3.2:- Cli "2 Egg: ~cg-g-g ~~~~~.[ . ~~l~~~'~~ .5~-oQlm(l)g,:..... ~~!.~~~Bi a.. C:..c cr:J (I) c: E .,8......(I)o>-8~ tl" Ul(l)3:"- c: (I) ~ 8:5~ 8.(1) (I) ~ ~~ a g Ui:5:5 ,~~5 ~~ 8'*:3 c: .-"'ffi cu (I)..... is.. E ~~';;:o:!;:i5'cE:;J .g=~;w.s~81ii .!!2~~:5~ti:S.9~ :J <i) Ql Cl r::: Ql Cl .- ~;~.~8'2',5:-g 5 ~il if Hill ~:fl'~~o'~~s~ "- (I) ,Q"C Ql "C "C >-'0 a~:5 1ii.$'~.!! j!!..c.!! 5: <I) (,) :J 0- cu m >-:J Ul:: (I) a....... '0 "S is.. 0- m cu c. E.!! O"y:e E ~~~8ill*c3~8 II II II II n II II ~&:: g~8 IIlS>:J ul:u ~;:u~ ~::;;; 00- u 0. "CI C 0 ::I o :u _.l!:l :J. l: ~D.:!:~ a: ~ ..J ~ ~ '2 g ~.!!.:5D. e :3f 0. .. . e M . a o D. ~ NM ..~ e- &~ . "" <( . C'" . OVERHEAD OIerheadCosls PIothv4yEnlerpoisCityofAshlBnd201G-2011CityHaII There are many different ways organizations allocate overhead Internally (e.g., Percent of total costs, dollar figure sum, as a percent of direct labor, etc). In the space provlthxl below, IndIcate how your organization allocates overhead to this particular contract, what Items go Into your overhead, and what that overhead amount 15 (whether as a percent or exact amount) Oregono..partmenlofAdmlnlstrallnServlces ProjectCostlnllWoricsheet IFILL IN ONLY ONE OF THE THREE METHODS DETAILED BELOWI 20.00% Percent of Total Cost Method: FOI every dollar spenl Pfoducing a final product, orprovldinll a service, a certain pe.roe nlalleoflhaldona,;s fequlredlOlovernead. Tocalculale1heovemndpelcenlaoe.itisbesl1ohave~nandalrecordsfarytllJr OIlJllniza~onlh8Igcblldeye8fOfmOl". Addlogetherthee.p..,,<:liMesthalmakeuplheoverl1eadCOSI(.ee wOIUhUI below). Nowadd!his figure llllhe Raw materials. Directtabor and o.tlveryb a total cost OMda thafigure'oroverheadbYlhe5gurefortollllt~ls.Theresultis3percentlhatrepresen13overheadas3 pOfcel'lllllleOllhelolollco5tlf5nancilllrecordloarenolavailabteestimatatleoverhead...pensesasbestyou can.estim3t~olhereoslSasbeslyouean,andU$olhosam''lormut3101lct3pereentage. 1. Enter Overhead as a Percent of Total Costs . OR 2. Enter Allocated Overhead as a Dollar.Flgure Sum OR Dollar.Flgure Sum Method: You can enter tho doDar amount you are allocatlng to overhead in the bar ilyou aro conlldentlhalyou can aIIocataoverheadltemslolhisparllcularploject. YoucanusalheWorksheal...tool(ilneeded) Ioldenti c.,.13. Percent of Total Direct Labor Method: Toldeotifyoverheadcoslll,yoU need lhe financial recorcb lor your organization 0 rdvlslonlorthopeslyear.lnpulallthe costs 01 the entiroontityll1delalledbelow.Linettemswhld1 are noldelatledbe low should be mpulinto lha cells marked .oiher";pleaselncludoados<;rlption.Whlllyouaretrylnotodetorminelsapercenlage.rhere'ore, do 1'101 gross up lhe e~pe""es'or Inflation or 10 conform 10 the current yur budge\. Ned. input inlO tile cell below the total15rec\ labor hours paid out by your entire organization rClr Ihe same period. These flgures Ihoutd be found on the year endplI;'roll reporlOo 1'101 include hOln which can be c1usJfted n management oc edmlnistr;llive cosls. (Including thele eoa.1S Into th~ d~ect labor h:'~~::~~c::.ol~:':"":':-~~~~:~~~::::~lo;';~:~~~LtlOa~m COI\ by<ivl15ng~lotaJ 3. Overhead as a Percent of Total DIrect labor Hours ToIalAnoolll OWactloboc Hour. InputTollllhomWorkshHtcn6elcw OVerhead plftobor hCOl $- Timorequlred 10 <;omplel! ccnlrac\ 520 T olaf AulgnMl OverhNd WORK AREA: I INDlRECTCOSTS ManagementSola~es Manag!ment Psyroll Tax Expense Man"llemenlMocIcallnsurance ManagementPenslon Plsn Expense Soles & AdmlnIglflya SoIaries SoIes&Adm~lfIyePayrollTaxExperrle Sales&Adm.lnlslrlflyeMadlcallnwranca Sales&Admlnlslnl1ivePenslOClP\anExpense OfficaRenl Advertl.lngandPubllcEducellon BackgroundCheck.o&Urloalysls Professional & AccCUlllng I Audil Fees Tralnlng&Work.orSolety lneuranco Telephone "".~ ProportyTul$lllcensea/Fees Dues & SlJbsalpUons Deproclell_olftcebull<lng Deproclellon-olftce~ment Rep...&Malrrtenanca--ollice ClaarUngandMalntenance OlftcoEqulpmenlRentaJ Office SlJppUea Poslago&Frelght Rehab MlscellaneCUlExpenee BadOebls Olhef:' -. Other.' Other:' TOTAL INDIRECT COSTS Worksheet Total Annual 0 eratlons ORGANIZATION DEPARTMENTAL Use the area below to show how you arrlved at the final figure that you show as your total Overhead $. CPl FtoIorJn:rnBU (.-hbolrooo1 ,~ ,- t...rI_bla...."_'~,..'" ''''''' IS. DAsForm'12J R....I.IOClll).03 \ Page 5 OVarhaad CompulatiOCl Sheet Delivery & Reserve Pathway Enterprises, Inc. City of Ashland 2010-2011 City Hall This category covers any costs associated with delivering your product or service to the buyer. A service contract, for example, will likely include the costs associated with getting the individuals who will perform the service to the place where the service will be performed. Gas, oil, vehicle maintenance and repair are all part of Delivery costs. Most often these costs can be' recovered by charging a certain amount per mile. The State of Oregon reimburses 36 cents per mile for its employees who use their own vehicles on State business. That's not to say your costs may be less or more. The labor required (the driver and the workers if they are on the clock), should be captured in Direct Labor. If your costs are 9reater than the state allowed cost, please provide a detailed schedule on how you arrived at your cost per mile. Oregon Department of Administrative Services Project Costing Worksheet Services Contract 1 2 3 4 Miles Per Rate Per Daily Services per Annual Deliverv Descrlotlon Service Mile Cost Year Trans Cost caravan $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Margin The law allows a "margin held in reserve" This is usually added as a percentage after all other costs have been calculated. The mar9in % can vary depending on the product or service being offered and or9anizatlonal, contractual and market variables specific to the project. Some research will likely be required to come up with a percentage that not only allows for inventory and equipment replacement, but Is in alignment with industry standards and fair market value. Any percentage hi9her than six percent (6%) will have to be justified to DAS. 60%1 Enter as a % of "Total Before Margin" DAS Form #12 J Revision 10-03 Page 6 Trans-Delivery and Margin Sheet . Community Development 2009-2010 Costing Workbook For Janitorial & Grounds Maintenance Contracts Under the Qualified Rehabilitation Facilities Program _.~,,:>.. . .... . . :':.. : 0" . .-. . ...... ." .......... Oregon State Department of Administrative Services Procurement, Fleet, and Surplus Services 1225 Feny Street SE, U140 Salem, Ore9on 97301 (503) 378-4642 . SUMMARY OF ANNUAL COSTS Oregon Department of Administrative Services Project Costing Worksheet The summary sheet is linked to the other sheets in this workbook. Any area shaded in light green is either a formula or linked to another work sheet The only manual input to this sheet will be to input the QRF name. The costs are to be divided into five categories: Raw Materials, Labor. Overhead, Delivery and Reserve Costs. Raw materials consist of supplies, small equipment & tools, and large or special equipment. Each category is detailed on the following sheets. Labor costs is direct labor used to produce or service the contract Overhead costs is a line item charge which is computed on the overhead sheet. Transportation or delivery and reserve computations are also completed on the following sheets. All these costs will vary depending upon your organization and the specifications for the project. Each sheet will have an example calculation and further instructions for completion. QRF Name Pathwa Enter rises Inc. Project Cit of Ashland 2010-2011 Communit Develo ment Executive Director Signature: Raw Materials Per Time Use. Supplies Equipment. Tools & Subcontracting (from supplies worksheet) (from small equipment worksheet) ,$ 233.29 .$ 486:17 Subtotal 1 $ 719.46. 1$ 13,678.71 1.$ '-.:3,891.401 1$ labor Direct Labor (from labor dairy worksheet) Overhead See Overhead Work.sheet Delivery Transportation (from Trans & Reserve worksheet) Total Before Marginl$ 18,289.561 Reserve Margin Held in Reserve (from Trans & Reserve worksheet) 1$ 1,167.42'1 19.456.981 1,621.41 Total Bid Yearlyl $ Monthly $ OAS Form#12J Revision 10-03 Page 1 Summary Sheet . RAW MATERIALS Supplies Pathway Enterprises, Inc. City of Ashland 2010-2011 Community Develooment Raw Materials: This category is often spelled out in the Request for Offer (RFO). language such as "[terns to be provided by Contractor" will usually reflect Supplies or Raw Materials. In the case of a Service Contract this wi11likely include not only supplies required to perform the service each month, but also Equipment & Tools. In the case of a commodity contract the Raw Materials will be figured on a Per Item Manufactured basis. Oregon Department of Administrative Services Project Costing Worksheet A custodial contract, for example, may require the following for month - Supplies: Paper products and soap Cleaning chemicals or products Spray bottles Broom and dustpan Floor Wax Scrub brushes or scouring pads Par Use/Per Item Manufactured - Supplies 1 2 3 4 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Item Unit I Units Needed Monthly Annual Price Per Month Cost Cost Pine Q Disinfectant $ 4.80 0.1666 $ ,0.80;- [$\/,;.:;:-, :,;'~ 9:60~ Cream Cleanser $ 2.91 0.1666 $( 0~48~ !$!k~,)t;'tl:".:5~82: Glass Cleaner $ 6.29 0.1666 $" ,t.';~;,1t.OM l$,r,tr;-?~12i57,;' He. Du Cleanser $ 4.80 0.1666 '$'[: '.<,:".',:0:801 tnm{r",",!9.60; 24 oz Bottle & tri er $ 2.27 0.1666 $. ,,"~;,JO:38! !$rL;l;l-;~":Ar54\ ACNlic Bowl Mo s $ 1.71 0.5000 $: -~?':'0:86r ~$t!:tX\~10:'26; Scraoaer Wlblades $ 6.51 0.1666 $' .'-~',V08l !$~~13:0H . ,. I OZ Pumas $ 2.31 0.1666 :$;:'::-" ....,;:0~381 1$~'1:r>!:4'62' Paoer Filter $ 21.10 0.3332 ~ $~:\:'~ '.<G~i:-7f:O 31 f$~'lr8~~37e. Sid loao end Moo $ 5.65 0.3332 : $~~:::P,l;:;':i:';;;'~1 ~881 1$_22'59:' 24" Dust moo $ 4.26 0.1666 t$r:~"}";.;t"liO,7.1[ !$_8;52, Daadlebua BN Pads $ 1.18 0.1666 l$~t:,')~;~r..0l20l i$~2~361 Duster exnandable $ 5.75 0.1666 :$~-'- '-gO:96! l$Wt;'i';_t1!50~ S otAwa $ 2.74 0.3332 ~$i"'~:,-:''?J 0,9JJ [$~';10;96~ Cleanin Pads $ 4.70 0.1666 in .....-;',0;7.8t ~$~I.;.1!;\~9r40) WaxMo $ 6.80 0.1668 $1; e'.f1t:131 t$~~~f13'~59; $" :~~::i~';w l$em~'~.~J'~: F .-;:::~~~ ($~-:~~;~?;' $ ~::.r~.!l.4. [$E;6*'#V~' $, "'*';~ I$~'i~':;-:::;::}- $ ',:~;,~;;,; [$~:~;;,,4.~ $' , ':;:"'~ f$rin';;"t~tf;;'~j:f,,\ . $';, -'-,',:-,::",. ~$Er.tt":.;/.r~~:i:t $' :1)- -/',~ t$!J'Zi,~:~'::~{~V~, $, ';'!Eft r$R:t>:::-t~_-~:.-- $,' -:..~-&,,",- ;$~,::.:X~'", ~,:,~-:~ $ ~;~, [$~r~: It.~&r~:;,~: .$ .:'~F~ r$~'tf.n:~"(~,i,; $ :;,,!1\1ii i$m!:;:cr""..'t:::';:;~ $ .'.'.;~ [$[i;,.~~~)?~V:~ $' ,'C._ !$JliZi~~:;t $' -~:;:ry'(E~: ~$It!i~~;,~~_:.' $ ':',!--~0 1$f{f;,f',I{,Ii',S",c:', $ -:~:'Wf,;. !$~\':.:,"!:J3.:~.'';'- $ ;':~:;''!:.::f:~:,' ~$!.1S!..!,{::,::-~:y;t . .$ -'.:~~S~ l$~tc(,,~',":::' A-'" $ ':.,~:r/ !$~'?;:~:;>'}:""/.:': Total $ 19:44\ ;V 233:29 .....u .~ ---.-- -.--- -.. 'Afefu'1!gf~~ri._~re firITl~~~_:_ __ I Monthly Cost'" Monthly cost is computed by multiplying the total unit cost by the units needed per month. Annual Cost'" Annual cost is computed by monthly cost times 12 months. DAS Form #12 J Revision 10-03 Page 2 Supplies Sheet . - . . u . ~~ . . .. 0 ~3: <=lg' ~~ . . - 0 .5" E- ~ ~ ~a 2a. c ~ . 0. . C c o ~ . (; ,.': 0~~lo'J&'l- . . 0.. . . E~ :Qi= c 0- " " 0: 0- Z a " '" :> .. ~ ;= ! . o " c o ~ u . 2: ti . 'e- 0. . :s " . .~ " II c " J; '0 c ~ " . E " S 8 . . 0 " u . '5 " C 0. I " 0. 0. .0 " " = .Q, c . "'" C 0. " 0. ~ 0. . . ~ ~ U .5 , e ~ " 0. .S . . 0. ~ , ~si,g ~ . . ~~:E ~ ~ iljjg ~ " . E e ~.!:! ~ . Ii . 0. '2'= g S 1l .-g i eil " ~.s:.!!.!! . x.c!l <:: ~ >0"; . 4>~~ ~8:gJJ "- c; g ~6~~ E Eo.~ ~ (Q:5a. e~c,g . ()o:(~ 0. e. . E 8. a"l:l . 6~;ii . .. ~n: !!- .~c " . ::J 0 Q> CI . ~~i!" " c . " . . u .5 !::..c:UCI E "Ii E~~:C 0. '5 ~ " .Q.~~; 0 0. E ::J (II GI 0 W 0. ~ g4>Ul= ~ ~.!: ~ . " c gat:! .!! ::l C\I C ~ = U >.." ~~~ o=.:i.!! ;g -~. >,0"_ . ~:5~ ecSGl F "''''.. :8~; " . E 0. 0. .. > . c "'" ~ 'g B ~ c " ~,,- ::J.5~ U) rJ}.,;o ~ ~.~ ~ ffi~ ~~ I- _c.!!! ""wii ::E . ;"" ~ [:t '0 <'S:S l';> o::~cfu , " " 0 0. " ~ .. 0. 0. .. 0. , " (oj ci ci N ci ,. 00 , a M .. .. M .. 1, .. c ,~' ~ ;; "': ,-: , < " c " " , ~ , ~ .. ,., ,., , ,., - - - - - '5 J!l ~ 'E " " 0- ;; '" 0 5 0 " ,,', ~~; >, , ~;- ..: U .. 0. 0. .. 0. r.; , ~' 0. M ci ci N ci .!!." M .. .. f .. f I. i. e-" ~:- [~ ;;: ~ a. c >'l ; " ~ ~ !'? ~ I "- "- '" "- "- ~ 0. 0. 8 0. U . N N N . . '0:;) Ii."" ;.. 6 0 0. 0. ;; . .. 0. 0 .. 0 0. " M 0 ci OJ ci " ~ M 0. 0 M 0. J!l P rt .. F' " r . t' ,1\" " . ~t.: > t l., a. , I,; " ~ ~" ,~- :,'. !.i '" '" ~ '" 0.' , '. "- "- "- "- "- 1"-" ~. , ,-. c . M M M 0. M ,I, , 0. ~ M M M .. M ~ S 'i' . u c f . 0. ~ , . . , c a. r,;;, .'" I.. " . i!. i,. .."~ . . OJ N N " " ~ ~ F N N N N ~ ~ ~ u ,'. ~, .~: ,... " ~ ~ 1 , ! c 0. " ~ .. .. .. " .. ;; M M M N M ;g . . ~ . '0 " 0 0. 0. 8 8 " 0. 0. " g ci ,,; g . 0. .. " u " N " N :> " - N - a. ,., ,., ,., ,., ,., c c . . 0. . ~~ . g,,, e "5 u E ~ . 0 . a . c W C c . '!l jl .. ~ . . 1l u ~ " , ii ~ ~ e ~ 'E c j: 0. " 0. , u: w " '" _N(')'<tl,C)a:Jt-(DOl5!::~~:!~ . .. !!- " . E 0. '5 o w '" . 8 . " '0 c 0. 'E 0. 0. m " "'" c o o '" , U .E B ~ , . .1l o"~ o~ '~l! c_ o c a 8 c .~ "~ :5-::: . .E ~ *2:-Gi "5 E 5 ~ ~t:5-gy ~ ~g~ ~'e c:5.~ ~ E a. ai' . ~~~.~~~.~~ l1J lire c; 2: 5 .5 ~ u Q.l CI:I Q.l ~..... 'EoQ)K.8.~n~ Q) ~:5.s u::: e:! l1J E ..... ;>. a3 ro......D ,9- 15.c cu 0 CD c: E 5-UUilV3:;:'SE Q) ~ 8:S~ ~<ll Q) ~ ~:!::og1ii:5:5 .:a~5~':.8*:fl ID.'>19~.!l:'!:a..~ >!I:::'-o_OCE_ c'- u..... . c: ;:J 0..... "'\"5 ~<Il ~'-:"Q) U 8 ~~-g~~Y~B~ Ej;:J 1ii.~ ~'e.~-g 5 .E-g"5aQ)c..~-gti ...... U._ a. CI) ,- CD 41 ~ ~ ~'3 11)5'3 C"O' c~cnE~5E~c.. ~1Q)'~~u'3~5~ .... QJ.Qu Q)"Cu >--0 ~1:51!! .!J"2' .!l.!l.Q.!l ~~ ~ 5.~'~~-a5. Cl:lCl:lc..E.!lg~EE ~~~8.n::~~8 no POD 0 0 ~~:~ S~S :~>-~ U5U <tCl~~ ~""'ii o~~~ :5:E oS! 0.. ~ g "C ~ :J go 'e" ~ ~ica. t :3 e:J 0.. 0. . C M . ~ . a. ~ NM ..2: E- ~~ . 00.,. " . co: ii ,~ ~ . ~~ ;= .s .i~ su E. ~... - e .~ " ~ < ~ o . . = . o i ~ . Bm "'3~ a_A '!I~. :lo~ e 888888888888881g8 !~~~f~~~Wr?O?O?~lf8 _.8" ~ ~;I r '" ~ 3! ' , I ~ '1': r ~ ~: 3 ~~~~~~"V' ;. ""... ~j~~r~ ~!{ ~ ~~rf;~:-d'f :i ~ ~a~~~~~'MMMM~MM~ ~~ Il~ -- E" ~~ Glj ~<i!" ~ ", ~ ~~:3 51 J;< :/ ~ > ; lS .. ~~' ~'~, - ~i~~~~~MM~~;~"~~M~ :~~~0~'r -:- ~ ii n . Ii ~~~ ~ si l. o MMMM~MMMMMMMMMM . ~~ ~~ ~~ o _~n 5~~5! ~ ......;;; ,- - .. , 1Il{!, .;. M...M...MMMM...MM...... ,.., ~~U 'Q...,.;,.; e. n " b~~~ ~ i :,: ~ ~~ ~~"M~M...MM~......M .~u !e<e:i<e:i ~ 3 '. N~8 il'ii 7~ .. ' ~,"" , ~MMM~~MM":'MMM...MM 5 " ~~ 00 dd '- ~~ ~,~ ~ . 1Il~~~~MM~~MMMMMMMM ~f~~ ~~ . ~~!!~~ ~~&!~::! ,8:I; ...... i ~8 Et!e",,; ~H ~o ~ " . i~~ ~~ll~~ ~ ~.j~ 01 ..!!l..!!l _N......."U>...<OO>~~~~;!~ ! o ~ :g ~ ~ ~ ~ ~ 8 '" " E w " " ti ~ 8 o " ;~ E~ ~ 8 "'5l.!!! 'B= .2,S :.'ii~ ~ :l!'l ~ H ~ E'..8 ~ .~ a. .~ ~ 'iJ. ='" 1; U D ~~ 11 , ~ >'5 =g ~ e <: <: -"=' 5i 51; R= E . 51! fllD Gl fll ~;;-: ~j ~ ~=i! 8.5 g :6~~ l! ~ ~.8~ 2""& ;j..J;, 8.f~ I!!: ~ a.~ EO l:D ~g:J?8~ ~.;~ ~1.i~~%&fll~5 l~~~~~~;~ _8g..1!ti l5Gl~>~I:!-fl;j. e.;--~-~8.$<:~ ~~-.oafll<ll8" ~&o~~1;:3;:~ ~~~<:.2.l'1!d!~ -1;~E>E>~~~~ ~ [1!;5 ~ ,~~~~ ~ ~ <J!,,~~.ooJl .~~ f! ~ ;>.;>.;>.55 Cl... ">,.- <II \6~~~~c;~,g altl ~!~ .~I!.G~E19S1!!li~~!~8. .i;~e:g,g,gB'~=<: -~.~m 'i~...~~~....".. ~E -I:i!..c: ... ... .. U u"" E <'l .D., '3,1: 2' 2> l? 2' g ~.... 8 <'{ i 1; E'~"".~"",~~ .-~... ,e] 12 -a -a Q. a."- ~ 'g <II.!! ",.,:il '11':::J '5:::J == <: <: <11.0 S l5 '3 'a ~]I~E~~~~~ia'~~::s .1.9 1; ~;>. ~'8 8 ~ ~ a ~ :l e "~ .c II> '" <: ... :;.. e ~I HH""8~~~R5 '.~~HH~~~~il;;m~ ~!~ u u u 8 U; Ii I' ,!! I' H . ~ " . . .. .. n . n ~::~~~~~ ~.8=::;~ ~~~~ii~ i~~S~ i!~.g.g~<::! .gel;;::; .Olllfo'l0I1l~;; 1Il:l:.o~ ~i ~~~...r 1!~ lj:;~~ o Cl 1; C c 5 ~~:i II . " e ~ soi 'illi:~ i . < p " , . ~ g ~ . . s: ~ i~~ :I;::J.5 " ~ jj , ~ o " . . ~ ~. c5;'" ~ ~flli.t! .. o. . '. ~ OI"~ ~ i: .!!! <5.1i. . :i~~ <.~ Fie" 1i .. ~~8 i ~n <. " ~ ~ o~ .> li~o .5Z ~!!;J if P ~ ~~ j!.ag.g > c.3 'oK t~... " ~u J! ~ , t .~ s" os 0 ~" u" <> ~~:~ .~~~ . " ~ ;I~U 0 .. ~ ~~ ~ ~. .!!=.. ~ -.. II i.s So_ ar Kg. ~ ~; ...~E ~ . . ~~ a~ :3 j~~H ; ~ ~:i e ~N ~ ~~ 1l~~ "l u' ~8 ~g!~ ~5cE E . '. t!_~~8 ~ i [~ i "'.l2 g .g ~~;;.8 " . s ~ --g &! ],'" €E~ ~i~~~ ~ ;lg ~ ~ fl 1i @ a <: '.. ~ 8_ o :tog . ~o 5 ~ "" ~~i s.. <> i.2lO .. {'j~ ..!!ISo ~~ h ~.;S !~S~~~ ~ =~ a] i .. .='1"<0' , -li8 ~w~.2~l i~ ~g'6 b .. '" '" 0 .c.2.. -BH~ . Uci ~d 0 ,~ oJ! . !H.~;: ES.5 < c- i~~ tH ~ ~ ~ . 8~ .. ~ ., <: '8 ~ ",,01.. .u ~.:!":g.c ,~ ~-; 8- . _ '" N '3 "O;~;i~ ~8. 8..eOi i< a-s '. ..""'" .,- i!f~ :;;~ H ~~ -.'Go ]=# .. 1;".!!- 8~ .- ~. ll~" j!!'sg .,- 8.'" eS j! ]lg.{l ig.ez~~ Q' ~li~ . . . ~l5 ~~ ~l:!.s Ig.~~~~ ~~ .:8.~ oili~:~Oi ~~ ~. ~~ :~ ~ ~ ~ 'S_:[~ g> si g <:.!ll C =f '. , ., .. 5 ~ I'; ~ s, .~ 8.8.g, gg, ~~ . -. :i1i3.o~.[ i~~ g- .. COo .~ ." 8~'~'~ .!!~ o' .oUo; Q~ h< :gJi::~"" ~~ h tis:s S l!! g-2"1; ~o ~lf e_ 8~ r 0"=. o. II "",c o. H n"!i~ ~! If.. .. Q .. ! 1i 0".0 g~ ~I g. <Ii - ~ g ~ ." u 0 ~pL" ,,~ ;T' .. .~ ~ . -~. ~~ . ." ]!1!~ ~ ;~~8 h " =i! ~j~ eCl~,j<:= ,. ~ .' g S ii.!!..-:. ". i8. 00 ~ ug.. ~g&"-~! .. '0. E' !; lij!- '6.oog ~0.!1~!:!~ .~ ~ u" 0" ~~!2'.g:5 ,,~ ,. j~~ ~i ~ ~~ ll~li Z!s~l~~ -. f e~ "'..~ ~ 8' .~. ~1l .. .~ 1i Ci ;~~ie!~ e;; ~g "0 =.. "OS a .~ .Ii'; ~ ~~~ -' . Q~ -., 'S ~.~ ~u~l~g ~. .. ~K 2e'6 <5~ t "8~ Euo 'ei~D-e ~.8 K'< "~I ~~i ~ S ..-ii; i.. ~ 8' 8.8- ~~~flig ,< B~~ .s..t 8.'tj Q ~e~ > ~ ~ ~;iF; 1i H l s~, -"0"'"0 :31 g-~ B g> 11.8;;: ~['Ci~ ~~ .'. Ss~=f " .~ . <>...i!i~ 1- ~~~! ...."'0 ~- 5~ ~.- g, ....."'- t.~.o" ~1i u Ha ~~ ij <5 ~eil ;t3 1iI~ 3' i ;;~..liga. <'.~ f~ _.u o~ 8. ll~~i~~ ~~~ ;:2 <5 B .!!o1!<>~"-:' ~ fLL U 1! :.: g :g~..s jjr'~~;: !i OI2'e~ ..>"N ~~;;~ .!lI ~..~~ g,~~~~ "Jlf- "'-<i 8- i lil 8;;...-; g~~3:B ~~],' ~~: ~ i5~Zllii:g~ o.~ ~n . ~ ~ " N" .~ E- If] ~! 0" OVERHEAD OverhoadCosls PathwayEntarp...CitycfAstiand20lo-201ICcmtoonityDeveklpm.... There are many different ways organizations allocate overhead Internally (e.g., Percent of total costs, dollar figure sum, as a percent of direct labor, etc).. In the space provided below, Indicate how your organization allocates overhea~ to this particular contract, what items go Into your overhead, and what that overhead amount Is (whether as a percent or exact amount) O"'!lcnDepartmanlofAdmlni5lnrtlvaS.rvlces ProjedCostlngWortu.hnt IFILL IN ONLY ONE OF THE THREE METHODS DETAILED BELOWI Percent of Total Cost Method: fcreverydollllr.pentprcducing II final prcduCl,or providing a urvke, e cerlainpercentllgecfthllldollllri. requlradfcrcverhelld.Tocalculalalhacverhelldpercentllga,lllab~tlllhave finllnclel recordl lor your ergenlzatlonlhlltgebllckayaerormcra. Add together lhlle.pandl\\Jrealhalmakaup lha oVelheadcasl(see wOlksheetbelow). Now add this figure to the Raw materials, DileCltabor Il11d Delivery tor e total cosl Divide lhefigurefOlllverheadbylhefigwafllrtotalcosts. The relUlllsaparcenllhatrepre.enb overhead as II peluntagallflhe total "".1. lfI\nSflclalrealrd.arenotava~abte estimata 1heooerhead e.pen.1IS esbestyou can.estimale other co.ts as best you can, &nd U$t'\t1e.ame formlllll 10 gel a percentaga. 11. Enter Overhead as a Percent of Total Costs 20,00% OR 2. Enter Allocated Overhead as a Dollar-FIgure Sum OR Dollar-Figure Sum Method: You cen enlerChedoUaramOllntyoueraallocalingto overhead In lha bOll if you a,e conftden tlhetyou<;an aDocele lIYerheed items to this pertic:uter project. You <;an un Che WOl'ksheet es a tool (lfneeded) tGldenti costs ' Percent of Total Direct Labor Method: To Iderrtify overhead cosls,ycu need Ihe t1n8llclel recOl<b for your orQaolntlonOl'dlvI.ionfcrlhepa s!yeer.lnputellthe c05ls or the eoUre entity as detailed below. Line Ilems which are nctdetaile dbelcWlhouklbeinpul Into Ihe celli marked "oll1er";pleaselodudeedesCliption.Whetyouaretryl"otodetermtnelsapercentage, lherelore, do net gross uplhe IIllpeoseslorlnllatlooortoconlormloU,eClArenlyearbudoe1.Ne~t.inpul1I1l0lhe ccU bdow the total direcllehOl'hoorspaid outbyyourentireOl'llenllationforlhesllmepetiod.Thesefilluresshauldberouooco1hayearend payrcllreport. 00 not indude h~ which can be c1e.sified il1 manallemenl or administrative oostl. (Includinlllhese coslllnlo the direct tabor I~C:~==~::~;~~:OOC:::~Ih,:,:,=::I:~::~:s";~:~~~t~:m cost bymicfinll the total 3. Overhead as a Percent of Total Direct Labor Hours InputTolalfromWorkshe<'ton~low Overhead per labor hour Total Amual Dire<:lLebOl'H<rur' Time.equ;nedtocompleleconlrilct "" ToblAsslgnedOverhead WORK AREA: INDIRECT COSTS ManaoementSalaries ManaoemenlPayroIlTlllfExp~ ManeoementMedioallnsurence Management Pension Plan ExpellH Sele. & Administrative Salaries Sele. & Administrative PeyrollTe~ Expense Sallll & Admlnlstrative MedloeJ Inlurance SeIIlS & Admlnlslr1ltive PenslcnPlan Expense Ofl\ceReot AdvertislnllandPublieEducetlOl'l BackllroundChecks&UrineIysia Prefesslonal&Ac:eoIming/hldllF_ Tralnlno &WOl'ker Sefety Insurance Telephone UUliIlu Property TexnlUceosesIFees Duu& Sub$criplions Depreelllloo-ct'llcebuilding Dap.eellllon--ofliceequlpment Rapm& Maintenan<>!Klfliat CteanlnllandMaintenBnCe omceEqulpmentRental OflteeSupplles Poslalle& F'relght Reheb MlleelleneousExpense BedDebtl Other;' Other:" Other:" Other." TOTAL INDIRECT COSTS Worksheet Total Annual 0 erat/ons ORGANtlAnON DEPARTMENTAl Use the area below to show how you arrived at the final figure that you show as your total OVerhead CPlFoo:l<>rhmllL.S(aeolnkbolowl tftol-.._..__...._ul'im T... ,- '.~'lI. t'._ 0ASF'ormt12J Revlslonl()..03 ""00' Overhead ComputatlOl'l Sheet , Delivery & Reserve Pathway Enterprises, Inc. City of Ashland 2010-2011 Community Development This category covers any costs associated with dellverin9 your product or service to the buyer. A service contract, for example, will likely include the costs associated with getting the individuals who will perform the service to the place where the service will be performed. Gas, oil, vehicle maintenance and repair are all part of Delivery costs. Most often these costs can be recovered by charging a certain amount per mile. The State of Oregon reimburses 36 cents per mile for its employees who use their own vehicles on State business. That's not to say your costs may be less or more. The labor required (the driver and the workers if they are on the clock), should be captured In Direct Labor. If your costs are greater than the state allowed cost, please provide a detailed schedule on how you arrived at your cost per mile. Oregon Department of Administrative Services Project Costing Worksheet Services Contract 1 2 3 4 Miles Per Rate Per Daily Services per Annual Dellverv Descriotion Service. Mile Cost Year Trans Cost caravan $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Margin The law allows a 'margin held in reserve' This is usually added as a percentage after all other costs have been calculated. The margin % can vary dependin9 on the product or service bein9 offered and or9anizational, contractual and market variables specific to the project. Some research will likely be required to come up with a percentage that not only allows for inventory and equipment replacement, but is in alignment with industry standards and fair market value. Any percentage higher than six percent (6%) will have to be justified to DAS. 6.0%1 Enter as a % of "Total Before Margin" DAS Form #12 J Revision 10-03 Page 6 Trans-Delivery and Margin Sheet Municipal Court 2009-2010 Costing Workbook For Janitorial & Grounds Maintenance Contracts Under the Qualified Rehabilitation Facilities Program -,..,.:.. \~,.. _,Z) ......, -.... ". ."" Oregon State Department of Administrative Services Procurement, Fleet, and Surplus Services 1225 Feny Street SE, U140 Salem, Oregon 9730t (503) 378-4642 SUMMARY OF ANNUAL COSTS Oregon Department of Administrative Services Project Costing Worksheet The summary sheet is linked to the other sheets in this workbook, Any area shaded in light green is either a formula or linked to another work sheet. The only manual input to this sheet will be to input the QRF name. The,costs are to be divided Into five categories: Raw Materials, Labor, Overhead, Delivery and Reserve Costs, Raw materials consist of supplies, small equipment & tools, and large or special equipment. Each category is detailed on the following sheets. Labor costs is direct la~or used to produce or service the contract. Overhead costs is a line item charge which is computed on the overhead sheet. Transportation or delivery and reserve computations are also completed on the following sheets. All these costs will vary depending upon your organization and the specifications for the project. Eac~ sheet will have an example calculation and further instructions for completion. QRF Name Pathwa Enter rises Inc. Project Cit of Ashland 2010-2011 Munici al Court Executive Director Signature: Raw Materials Per Time Use - Supplies Equipment, Tools & Subcontracting (from supplies worksheet) (from small equipment worksheet) $ 233.29 $ 486.17 Subtotal 1 $ 719.46 1:$ '4A12.491 I.$~ 1,387.01 1'$ Labor Direct labor (from labor daily wbrksheet) Overhead See Overhead Worksheet Delivery Transportation (from Trans & Reserve worksheet) Total Before Marglnl. $ 6,518.96 I Reserve Margin Held in Reserve (from Trans & Reserve worksheet) 1$ 416.101 6,935.061 577.92 Total Bid YeartYI"$ Monthly $ DAS Form #12 J Revision 10-03 Page 1 Summary Sheet Oregon Department of Administrative Services Project Costing Worksheet RAW MATERIALS Supplies Pathway Enterprises, Inc. Citv of Ashland 2010-2011 Municinal Court Raw Materials: This category;s often spelled out in the Request for Offer (RFO). Language such as "Items to be provided by Contractor" will usually reflect Supplies or Raw Materials. In the case of a Service Contract this will likely include not only supplies required to perform the service each month, but also Equipment & Tools. In the case of a commodity contract the Raw Materials will be figured on a Per Item Manufactured basis. A custodial contract, for example, may require the following for month - Supplies: Paper products and soap Cleaning chemicals or products Spray bottles Broom and dustpan Floor Wax Scrub brushes or scouring pads Per Use/Per Item Manufactured - Supplies Item Unit Units Needed Price Per Month $ 4.80 0.1666 $ 2.91 0.1666 $ 6.29 0.1666 $ 4.80 0.1666 $ 30.65 $ 5.00 $ 13.01 $ 2.27 0.1666 $ 1.71 0.5000 $ 6.51 0.1666 $ 2.31 0.1666 $ 21.10 0.3332 $ 5.65 0.3332 $ 4.26 0.1666 $ 1.18 0.1666 $ 5.75 0.1666 $ 2.74 0.3332 $ 4.70 0.1666 $ 6.80 0.1666 1 Pine Q Disinfectant 2 Cream Cleanser 3 Glass Cleaner 4 Heaw Dutv Cleanser SOder Counteractant 6 Camet Lane 7 Camet ShamDoo 8 24 oz Bottle & trinner 9 Acrvlic Bowl MODS 10 Scra er W/blades 1110ZPum s 12 Pa er Filter 13 Std loo end Mo 14 24" Oust mo 15 Doodlebu BN Pads 16 Duster - ex andable 17 Soot Awav 18 Cteanina Pads 19 Wax MOD 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Total Monthly Annual Cost Cost .$;' .:.:~~:;:O:80! ~$~:'i.;:'.:~~.:.t9.60 :$~: ":::,:.:;:0':481 !$n:'~\~!':5:82' $;;' '''r:;'1',05)' ,$!lH~:~;r,~12i571: '$!,.', ;:~O:80:' l$lC('~~7;:9:60' '$:' :~~~1t~ l$~~;~J~~K'; :$'-"-''':''':::~ l$ri['~:"::::;~_;o..~;}:-_~, $:-' h,~ r$5!L.IS;:~i!~':(i $:.\::>.j;'i'0~3811$~'f::.4\54! :$r;(.;;~J/;~O:86! [$~10!26: ':$r,;::i!iL,.::.";,1!08} !$l~.1m13':01! '$t'.:~:~~:;,~.ifO;38i 1$~~4~62 $t:f:,:;,:[:\.U~03f !$Em84~37/ '$hS>::;;$1~88r 1$~~1"k22:59; $r:'f';~;,tO~?1[ !$~~~8!52; $~:i .,)_\ 0!20l r$Il~'1F::t2!36; $~:: ..'-r'::0;96\: [$~<?~t1.H50i :$~L'- ,~0:9n ($tt'~J!10:961 $;' .0'78! !$!!i!;<,::'t 9;40l I$~ '~,W13t ~$~..::.t';":i13159~ $:',." '_/~'"jG-m [n';~.M:~:~7;,?-: '$~ ;',~~:it~:, i$*1t',,::::t~\~C~t: $ti -' :-,,\,;'~'i*r !$re;::;~:l1$l!l.:::;:;'/:~: $r' ':t,'i';,:~:;~~ i$k'8":';';JfJ"::::,'~+: $~: :'~'-'~~~~ :$~~(~;}r".:"~:.~>::; $ """",,',' : $R;(>::.'-~'( $ ,~r_-'" l$K":::;:;;::~ $" ~:.rs :$C~>. ,. '$,' -c':" :$ir';;;:,~~UC\F $'-'-~~,ii~': ;$~:r ;\;'C';,:~,':::':.', $;";: t$'*'J;':',_'::K-::::;i~.;~ $' '. "'e;, ;$;"'.:. '''.'.:'1 $' ~ $~':'i:;,{ ::;;".~;~" . $: ~}iS '$iiJ.!1'.t;:::::.,:," $,' i~ _~::}} ;$~:':';'c'.:,'_c" ._, $ ,'" '$f'."', .' $;: '~t~ :$~t:;:-,/~~" : $1;' ~ .~~{~- [$~~~.ti:":~- I$\': :'<='1:~ l$m';\~;(~i~J:_~:;' ~$; ;~,' ;(,~,'-~$tf i$~:.'-'t{;,~~'i;' $: ;;'-":'~OC',' !$IT:;;~~Y,'!::'::?-: :$' '.'19:44; ~$;:~' '-233~29, ~~'a~(lj']f~],!i'~re-formui8' arf~:6~<-=,==~'~~~.J Monthly Cost I:l Monthly cost is computed by multiplying the total unit cost by the units needed per month. Annual Cost = Annual cost is computed by monthly cost times 12 months. DAS Form #12 J Revision 10-03 Page 2 Supplies Sheet . ~ . . u . ~~ . . '" 0 ~;o " m ~.s . . - 0 -"u E ~ "0 u ,,'!!' _ 2 ~o. c ~ :l. . o c o m . o D .0. . " o u "S , "0 8 .~ - , e .~ [ u - CI ,g: CoO c: ~ iG' ~~~~ l/) ~ uio ~ ~~.~~ ~ 0:: 8 e-"C a. ~ ....~ ~ E ~ ]l~~ ~ ~.~~o ~ <( i}(ll~..!!l 0::: UJ a.. C,) g .... .. " . E ~ "5 ~ w a c ~ ;; . " . . ~. . . .~ ",.5 0:.... a I- u " 0: I- Z a u '" ::> '" 0~~~~ . E ;:: .~ . o U c o " '2 u . . o . . ~ . . ~ u~~ ." . );C..Da; '5~ Qj III g "0" ~"S g. "" . . c . .- . "8" .~ E U . 5 E o a u: c ~~ e - . . ii"~ .~ ~ ~ "''''''' ti . 'e ~ . :s " .~ "0 '" . '0 ~ . .. 8 . " " c i . S c ;; c .. E .9 . o U . S . > ~ ~ .. " '" " c 0 o ;:: {l u , . " ~ c . :2 ~ e3i.2 ~.s oS! .8cu~ . ~ = ~~ ~ . e~g] ~'-.!! .!!! c ~ >-"; ~8g~ ~,g~~ elllC.c ~ 8.~~ c lIl;i C o gl: ~."Oc ::I 0 cu III .~ ~ :3 e-. ......_ .c :ii~l::!J! E>:::::J.c .e-i;'e-; g.:::g ..!!l-g:l~ :5 g ~Cll o::<.!!! >,0.... ffi~~= !l:OZIll . " !2 " . E ~ "5 ~ W ;::.;. 0 0 0 8 ~ ,,~. ~ tF !t~ ".' ~:" r ~ = 0 0 ~ ~,: [S:' .. M d Ci N d " ~ ~ ~; ~ f , .0 , 1;; ro = = ro ro f r: , ro c 0 r " Ii r,' r: ~ c u ~. 't .i ~ " " k ~ ,; , ( '1_ ;i , ~ ~ - ,,:. , t' ~',. ." '" ~ '" '" '" " ," :"~ L ..,' . ~.~. .:., , , ~ - - - - - 1; " ~ 'c .. => 1;; ;::;. 0 0 0 0 f .. F ,,,' u '" 0 0 ~ 0 ,. 0 M d d N d ~E .!!,u ro ro '" ro ro , 2" ~- g ~ ~ r (C f; ~.. 0. C rl " => ~ !t ~ '" !!t: ~., t~ i~' , ,. " " " " " 0 0 0 8 0 U . 0 N N N . . - - 'e- => 0. " ~ 0 0 " 8 ~ " ~ ~~~ i " , 1;; . '" 0 0 ~ ~! ~. !~ \; 0 . M d d N d ~ ~l' r u ~ ro 0 0 ro 0 tt ~,i R ;:, ro ~ ~ ~ i-: l1 5 ~ il' iit it ','. 'c ~ ~ m ~, I ~i, ,. => 0. W " ~ ~ ( ~ !. ,. , " " '" ~ '" ~ r h '" f, . '. " " " " " ~ ~'. fI"' . ~ p ,.. t., ~g ro ro ro ~ ro ll- p j ~ ro ro ro ro r , ~ ~: " 'a r r n ~, .. V" , U c ..,. ~ ( . ~ ~-: fi, e e i~j , , " F ~\ t ,. ~ . f~' I:. ~:; , :.1 ~f : . . , 0 0. r. ~. ,~ ~ ~ ~. fi 1L ~ im , ""... N " (\i " N N N N N N N "I~ N N U . .,... r;: F f 0< ;0;;;: r:: r - ~ , ,. '; <, c ~ :~ 0 , , u : ~ i'l '" ~ ~ '" <;; ro ro ro . :E ~ . . 1; ::> 0 0 " 8 8 " 0 0 ;; ci g .0 g . 0 '" " " ~ '" ~ N ::> Ii. N - ~ ~ ~ ~ ~ ~ c . 41 .2 ~ [:@ e ., u E ~ . ~ . , . c w 0 G . c . . '" > U .. . 5 . ~ ~ " u ~ . u , . u 5 . " E " 0 .li 0 , ;: u: " " .... N (')...,. Lt'l.fD r-. 00 lJ:I ~:: ~ ~:! ~ . '" 8 . " "0 c o " o ~ m " '" c o . " , " .S $I e , . . ~ u_ .~t5 ~g ~ 8 ~ .!!! ." :; 5 ~ *;aj ~ E g ~ ~cg-g"y ~~~~~.[. ~.~l~~~.~~ .E~"OCI)coCl)~..... "EoCl)~.8gu~ Ql co.s '-"0.... I'tI CI) E::; ;>. 5-:; co.l=.o ,9- goO CI) 0 I1l C E g.Util1l~~8E Ql~8.s*~~Ql ~ -;;~ogti......s .~,g5~~8~~ c: ._]j co Ql..... i5.. E ~.~ .~ 0::= '0 .2 E :0:; _,="0 -' ,c::J 0..... ~i"'5 li Ql & "':" I1l U ~ "t'C5 -5 !!l ti :; 0 u "'5 en -g Ol C Ql Ol-' ~ E'::J -' C ~ .0' C -0 C I co.- .....- I1l ::J .2-g"'5~I1lc.a-go ilm..2:;= c..!!!:;::; I1l Q) ~l.~ ~"3 m -5 "'5 ; .e- "It; en E ::J.s E ~ C. $,I1l.~ 1;'ti'~ 1;' 5 1;' C:~~-g,~-g-gli-g cJen.!!!..... e 1V..... ;>...... ;;1::: &l a ::-.O~i5..a el.~ ~~~ g~3 ~ <-13: cOUJ :;0::20 II II II U un II ~f~~. ~~~ ~~41~ co~ o t a. CIl =:J "" c Cla.gU " .i 5150'[ ~ '5 ';l - n. CIl :~:5 e :J f n. ~ . o , ~~ E- ~.~ . '" ., " . 00: ro . m . 0. :I 0; ,A ~~ JO ; ~ OS .!j. .5~ e" ~.. -e o. e ! " ~ c o ~ o ~ 8 ~11 8 8 ~Il 8 8 . . . . . '" . . . . . 0 ~ o. ~ f dd d d d " ? ~ d ~ ; . ~ r flf \" ,. , ~ ~ f r 0 ,-" " 0 ~- ~, ,,' " . . .. I,' i .. r '" . . , " . e ;i " ',: ., ( , ; ~ . " ~ 11 : ~ '! . ~ , ~ , , ,.; ~ ,.; " ~ " " " " " ,.; " " " " " . < ~ ~ ! > " " ~ ~ 0 si , , .. .. ;i ~ . '. " " \ . f " :,; .' , " ~j , , I .' ~ 8 ~ ;. ; " " " " , ~ , ~ " ;;. " i-> " " " " . ? ~ ~: H~ , , ~ " , ~ ~ m ~ , . " 0 . 5 ~ " ,.; " ~ " " " " " " ~ " " " . ~~ .0 me ~~ 0 . ~ ~ . . 0 Ii ,; ,; 5 . m . ~ ~ . ? ,; . , ~ , . " ~ " ,.; " " " " . " " " " " "" k~ . ~ 8 .- .; .; eo .. d , " g . . , . ~ ~ d , 0 " " " " " " "" " "" " " " " ~ ~f . ~ 8 . , " " ~ 8 " ~ ~ N . , <, '. , , " . ~ . ,.; " " ~ " " " " " " " " " " . . < il il 0 d d " . $ . " . ~ ,; ~ , . .; ,.; " " " "" ~ " . "" " " " .~ ~ ~ .' .1i . > ~ ~ ~ ! ,; ,; " ; " 8 " " :~ . ~ ~ ~ ~ . ~ ; . ~ 0 e H . ~ ~::~ ~ ~ . , 0 c~ 0 U " " i ~~ <<~~ 0., '!l.~ :lo. _N..,....,,"'t--"''''~::~~:;!~ ~ ~ l , o. ~li:~ ~ , ~ e , . I . o U oo~ I~j . ~ ~ " . ~ ~ ~ " ~ . ~ w d " rl g 8 o " .Be . e e.2 ; . ~ 0 .!j.!!! g !Oil z:, g ~ ~ i" ~ eE e .~ ; ~J li ~~ ~ e >. 5"5 ~~ 'K~e Co _ s~ ~d ~l ~ ~~i x.~ :3 ~~~ ~~ ~ ~.8~ ;tc ... ....~"' ~ CII #- ~ x.~ ~ ~ c. ii <: 0 lD e Cl:D" 5 E "E 4i &,5"'U"" ~'!=5 .c'ijj\2e.2ai<ll~o JiI et-- GI ~E.!!:!:-g is,S:S 2! ~:gu <II ....CD~:;:=:Jl::_I'J#- oE~_"_" i!Lm-E!.:! ~~....,.a.!:! '" CD 8~ ~ 'O"'-li::J1:5i B ~ .. .~ .~ .. .. e lD .5li~~E'~~~~ ~ I~ ....~o jj ~ I'~.s ~ g, g, 4i 4i a ~ ~ 1i 13j;;;;;~~~ ~jl .~l!.s s.~~ ~ ~~ ~ ~ ~~ ~ 1'::SI~ ~.g.g.g ~ ~:a ~ ~~ ~:g "'; 1:........ #. E (') ~.c-.s I~l ~~~g'g,g,1il8jl:!l!li ~I~~~~~:!:::!:-g :.!!~~1l Ie! ~ ~ ~ S 3 ~ ~ ca_ .c ~ l5 ~ ~ -~]IEEEE".i!ts~n!Z.lll"'5 2l1B li ~ li li ~ ~ ~ ~ ~ ~ ~ E ~III~~""8!j..'~ "I .:!I-c w-E68.~ '" ~~._.e" 8'.0 ~ ~ 5555~Rc"'~"Eb <:D:lOOOU.s;.5 oi!:t-i!:I=3: - ....... l!"N"''''~''' giiii:lo :r 0 0 0 0 't:i: ~ggggc:l ~VlVlIl'lIOJ;1i :! 0: 5 .... . ... ~ :;0 .... l! ~~~sg gEf.~ VI ~ I: ~ ~ t~;'i ~ Cc g ,i,i " ~. '0 .- .!l<;;~ till.;~ U3 .H ;;lii~ ~~&. JIIo~ n'. ~~~ .;i~ ~c; "tIO", ~E1' ~. " .!I 8.... "-8l!'i .8 ~~ =.. '>0 ~ f~ . s ~. ~. ", en ,. ~ B o 8.1! ~ o. -Zt:,8 %~~ B~,g .802.. ni 'J1f; "il...-c ~~~ ll- " ..~i s.!:_ e~ 0 g.~ i ~~ ~~~ ..~~ .. I on .. . ." 8.8.~ ~i~ isi -os ..0 "'~d. ~ ~~ .. . ~~~ .'. .~~ ,.. :g~~ "-. ... .Os .!. o~' j.. o'~ .o:;g ... .-g i l:5 ~.~ 3''''1:> ~ ~~ Eno H! !3~ ::~~ i~~i I:~~ ....~o {':10 ~"li ,,~ Ii ~~~.8 lfi1'" c.~ 8.~ ~ ~:'g c5!CO !~J2 II o~~f t:;l e(l!g ~~"'~~ l3Ec"" c. ::.5~~l!'i ~.8~go .8. i:g.~ li a:; g'S~ <> E'i!i "'~ ~i!~i :5li!3~c i.E1!"~ ~]i ~~! "".!I.5:5'" ...:5"t1...o ~8~'a~ .o_et ",ii.i'"8 lij.>i1ir: ~';iil"'8 ~.c:l!t:lil 1!:fdtil.8 ~{iE~~ ~~iJ~ ~tH~2~ .!! ~ ~ 8 ~'li' ~~~M.iS ~g.1i ~~:i' ""o>E-- <,.~n <:I"',!: EO x _.0 ~ ill", ~~~~~; ..li ~..~: ~:5~.s: do -Eell;:.s! 8.",,:5:5~N ~s~*!,g ...!!~~ iii.~ .l:E~",-!y ~l1..i8.~ ..:..e~z ~<>. J!.'ns~, [! ~ ~ ~ o;3B~a; ... 0_.2._ ~ ;~~c=:g ":5~i.5li .i1E.81i~ ~'E ~ e f ~ 8~Ji::~co ~ l!! e.2::l'S i!!'"~gj!~ ~.e~tl-B l'!~~ ~!.8 ~2!Se~~ ! ~~ .. ~ 6s~e~8 ell.. . c "" 5s811.!ll<i- .c: 0.. -t:.- ~8~i't!~ "',:'0"" :::I~ ~.!!1: g'i1ti ~~"tI~~fl __ E it li! . ~~~~...~ 1!a!.EJ!~ -.......".2 ".o~~~ ~iUH l!! 00.. g'e K. :::I <>.,-" ~ S ~ r ~~ , t. ;.. ;; ...2 <>.<:: ~ ~ :B~g~~ !i~~:! K.. .b. ~o~ie8. .8~~~~N .!!! Ci =;: 8 ~ o. 11~!~1 n"C c (I! l!:::. ~l~~~! 3: 9 [ 1i ~ f I , .. ! . " I' j ~ , o i 3: [ i o . ! ~ . ~ ~& ~i H jf L ;i 1', .s ~" [~ U H .. ~! .0 t!! .- ~~ li. ~~ ~ ~. ~ ~; c, 8.... ~ <;; a .~ p ~ l~ ~ ~ I l i1 8 !A' i~ ,I ~i !~ ~~~ ~li ~ l?u..u~ .s"g>- 0 ~itii~ g i~~8 o. ~ . . , ~ o . . a~ ~i .. ~~ .. ., >~ e... i~ ,0 g,~ ~~ '. i~ ~~ ~1;:f .x .. o. ~g .. ~:, _x .. 3", b< ~~ b. ". ~~ ~~ ~o o. ~3 ii .= al! ~~ e2 .~ :a , c g. j[ 2~ . . ~~ .~ , < g.! ~ lii .. s-E n ~~ au d .s:li . -~ ~~ . . ,n .~ .~ [i !l It 0= .. ~8,.:. 8.gE ~~~ .8~~ s" ~j~ "'13 8- ~~ [ 11:50 0'- ~:3:3 ~'2 ~ :~e '"N ~ii ~ ~... <~s . " ~ I ~ i " i~ e- ~~ ~i 0" OVERHEAD Oveme~d Coats PalhwayEnterprlsCllyofAshland2010-2011M..uclpaICourt There are many different ways organizations allocate overhead Internally (e.g., Percent of total costs, dollar figure Bum, as a percent of direct labor, etc). In the space provided below, Indicate how your organizatIon allocates overhead to this particular contract, what Items go Into your overhead, and what that overhead amount Is (whether as a percent or exact amount) Ol'8llon Oepartment of Admlnlstnrtive Services ProJeetCostinllWOl'ksheet IFILL IN ONLY ONE OF THE THREE METHODS DETAILED BELOWI Percent of Total Cost Method: foreverydon~rapentproducing afinalproduct,l)I' providing aurvlce,aceftalnpercentageoflhatdollar is 'equlredroroverhead. To calculate lheovemeadpercentage,ltlsbesttOhovefinanclal records lor your organi18Uon Ihat go back a year 0' more. Add logelher the e.pemfttures Ihat make up 11110 overhead cosl (see worksheel below), New add this figure to Ihe Raw mate,lals, Olre<:tlabor and Delivery for a tOlal cosl. Divide 1I1efiCUrefOlOVe,headbylhefigurefortolalcosIS,The'HUIlIsapercenllhatrepresel'lt5overhaadasa percentageoltlle lotal coot. II financial records lie not eVililable edmate the overhead e'pensel as best you can,elUmele olher costs as best you can, and use 1I1eume formula ta get a perc enb<;e. 1. Enter Overhead as a Percent of Total Costs 20.00"A. OR 2. Enter Allocated Overhead as a Dollar-Figure Sum OR Dollar-Figure Sum Method: Yf;IU can enter the dollar iIIllountyoo are aIIocellnll 10 ovelhead in the bCll Iryoo ilfeconlldenlthatyoocan allocateoverheadilemstolhisparticulilfprojed:. YOUQlnl,lllOtheWorisheelzs~tcaI(llneeded) tolden~ costa. Percent of Total Direct labor Method: Tolden~fy overhead costs, you need the finlll1dal recordo loryoul organllB~on or dlvision lor the past yelll", Inpul Blithe casts Of the entire enUly a detailed belew.line items which ere not detailed below should be Inl'lJt ,,10 the cella markad "other"; pleuelrlcludn. dBaoription. What you are tryinlllO dele,mi... Is a percenls\le,lI>erefore, do not gross up the expenses fl)l'lnnaUon or 10 conf",m 10 Ihe cur,enlyew budget. Ned. Inpul inlO the cell belawlh elotaldirecllabOlhoorspald ouIbyyou-entileorllenlzallorrfl)l'thesameperiod.ThesefillWeslhouldbnfoundonlheyoarendpIIYrollreporLOOnot nctude holnwhlch OWl be dBs.Iiified;as management or admlnlstrat!ve costs. (lndudinlllhe5e oos15 into the d1ree1labor :~~;=::h::I~;=~C;:-~:~~::f~:eacc:::::,o-;~:a~~;I~~COSlby<t~lirlglhetolal 3, Overhead as a Percent of Tolal Direct L.abor Hours TOUIlAnmlalOirltCtlabOfHcus Input Tolal from Worksheel on Below OVerhead per labor hour T,merequlred'tocomplelecontracl 260 TotalAsslgned Ovem.ad WORK AREA: I INDIRECT COSTS ManallemenlSalarles Menagemenl Payroll Tax ExpenBe Management Medicill Insurance Management Pension Plan Explnae Sales&AdmlnlslrativeSelaries SltIes & Mmlnistrative Plyroll Tex Expense Sales&AdministretiveMedlcallnsurence Sales & AdminlBtratlve Penalon PIm Expense DfficeRent AdvertisinllandPubllcEducalIon Background Checka & Urinelyata Professional&AceoootlngJAu<RlFees Traklinll &Worl<er Safety ,~ Telephone Utililles PropertyTexeslUceneealFen Dues & SubscrlptillOB Depreclation-offioebulldlng Deprecla~on-officeequlpment RepaIrs & Mzlnlellence-offlcB CleanlnllandMeintenance Oflice Equlpmenl Rental OfficeSUpplles Postage & Freiltrt ,..... Miso!faneouaExpense ".,""'" Other." Other." -. Other;. TOTAL INDIRECT COSTS Worksheet Total Annual 0 eratlons ORGANIZATION DEPARTMENTAl Use the area below to show how you arrived at the final figure that you show 85 your total OVerhead '. . CPIFoct<olramaLS{HOllIc~ "'"./IWWw.bls "~___,_,t.lm '""" ,- ,- 1$, OASFOI11l'l12J RevislonlG-ro Page 5 Overhead Computation Sheet Delivery & Reserve Pathway Enterprises, Inc. City of Ashland 2010-2011 Municipal Court This category covers any cost~ associated with delivering your product or service to the buyer. A service contract, for example, will likely include the costs associated with getting the Individuals who will perform the service to the place where the service will be performed. Gas, oil, vehicle maintenance and repair are all part of Delivery costs. Most often these costs can be recovered by charging a certain amount per miie. The State of Oregon reimburses 36 cents per mile for Its employees who' use their own vehicles on State business. That's not to say your costs may be less or more. The labor required (the driver and the workers if they are on the clock), shouid be captured in Direct Labor. If your costs are 9reater than the state allowed cost, please provide a detailed schedule on how you arrived at your cost per mile. Oregon Department of Administrative Services Project Costing Worksheet Services Contract 1 2 3 4 Miles Per Rate Per Dally Services per Annual Deliverv Descriotion Service Mile Cost Year Trans Cost caravan $ - $ - $ - $ - $ - $ - $ - $ - $ - .$ - Margin The law allows a "margin held in reserve" This is usually added as a percentage after all other costs have been caiculated. The margin % can vary depending on the product or service being offered and organizational, contractual and market variables specific to the project. Some research will likely be required to come up with a percentage that not oniy allows for inventory and equipment replacement, but Is in alignment with industry standards and fair market value. Any percentage higher than six percent (6%) will have to be justified to DAS. 6.0%1 Enter as a % of "Total Before Margin" DAS Form #12 J Revision 10-03 Page 6 Trans-Delivery and Margin Sheet . Ashland Police Department 2009-2010 Costing Workbook For Janitorial & Grounds Maintenance Contracts Under the Qualified Rehabilitation Facilities Program -'.'" :. - '1.7'; :. ., : .-' . .-. . ',-", " .......... Oregon State Department of Administrative Services Procurement, Fleet, and Surplus SelVices 1225 Ferry Street SE, U140 Salem, Oregon 97301 (503) 378-4642 , , SUMMARY OF ANNUAL COSTS Oregon Department of Administrative Services Project Costing Worksheet The summary sheet is linked to the other sheets in this workbook. Any area shaded in light green is either a formula or linked to another work sheet. The only manual input to this sheet will be to input the QRF name. The costs are to be divided into five categories: Raw Materials, labor, Overhead, Delive~ and Reserve Costs. Raw materials consist of supplies, small equipment & tools, and large or special equipment. Each category is detailed on the following sheets. labor costs is direct labor used to produce or service the contract. Overhead costs is a line item charge which is computed on the overhead sheet. Transportation or delivery and reserve computations are also completed on the following sheets. All these costs will vary depending upon your organization and the specifications for the project. Each sheet will have an example calculation and further instructions for completion. QRF Name Pathwa Enter rises, Inc. Project Ci of Ashland 2010-2011 Ashland Police De artment Executive Director Signature: Raw Materials Per Time Use - Supplies Equipment, Tools & Subcontracting (from supplies worksheet) (from small equipment worksheet) $ 233.29' $ 486.17 Subtotal 1 $ 719.46. 1,$ 7.942.47'1 1$ 2,341.061 1$ labor Direct labor (from labor daily worksheet) Overhead See Overhead Worksheet Delivery Transportation (from Trans & Reserve worksheet) Total Before Marginl'$ 11.002.99. I Reserve Margin Held in Reserve (from Trans & Reserve worksheet) \'$ 702,321 11,705.311 975.44 Total Bid veariYI$ Monthly l$_. / DAS Form#12J Revision 10-03 Page 1 Summary Sheet RAW MATERIALS Supplies Pathway Enterprises, Inc. Citv of Ashland 2010-2011 Ashland Police Deoartment Raw Materials: This category is often spelled out in the Request for Offer (RFO). language such as "Items to be provided by Contractor" will usually reflect Supplies or Raw Materials. [n the case of a SelVice Contract this wi1llikely include not only supplies required to perform the service each month, but also Equipment &.Tools. In the case of a commodity contract the Raw Materials will be figured on a Per Item Manufactured basis. Oregon Department of Administrative Services Project Costing Worksheet A custodial contract, for example, may require the following for month. Supplies: Paper products and soap Cleaning chemicals or products Spray bottles Broom and dustpan Floor Wax Scrub brushes or scouring pads Per Use/Per Item Manufactured - Supplies 1 2 3 4 5 6 7 6 9 10 11 12 13 14 15 16 17 16 ,. 20 21 22 23 24 25 26 27 28 28 30 31 32 33 34 35 36 37 3. 39 40 Item Unit Units Needed Monthly Annual Price Per Month Cost Cost Pine Q Disinfectant $ 4.80 0.1666 $ 0:80; $~:'.:::~: 9~60 Cream Cleanser $ 2.91 0.1 666 ,$" "'->:'O:48l l$lf'- ;~<~, 5.62 Glass Creaner $ 6.29 0.1 666 ,$~ ,\'tr1:05f :$~":'. {:';:~12:57 Heaw Dutv Cleanser $ 4.80 0.1666 $'. .. '.~:0:80: ~$f;' ;~9:60 Oder Counteraetant $ 30.65 ,$" :,:~..::,,~:,: t$~:':;- ;,..,,:.;.~~.:, Co et lane $ 5.00 $' ~$r;;~::-s:;;::,~_'~~ . Co el Sham 00 $ 13.01 $( " -'-'~.::~,"",--":. ~ $~t ,.?:t:'l~':'- C .,..:~.:4 24 oz Bottle & lri er $ 2.27 0.1666 $> ,':.'oO:38{ 1$~,2~J'--''::'A~54 A lie Bowl Mo 5 $ 1 .71 0.5000 '$~;-':. . fO:86\ f$l'"~~~;}i, 10:26 Sera er W/blades $ 6.51 0.1666 i$:;;'-~".::;:~1~08) [$E:tl:;L13',Ot I OZ Pum s $ 2.31 0.1666 :$;;r""''-::;:'X,Oi381 [$~:;i_\::U'4:62 Po er Filter $ 21 .1 0 0.3332 : $;:':;,;', ~,:t.'}t 7': 03~ :$r.:;?%<;;'~~84:37i SId lOOD end Moo $ 5.65 0.3332 ~$\f: j:-.i'iXt:1~:881 l$X.~jD~22:59: 24" Dust moo $ 4.26 0.1666 $;;'.'.-\";.'~ 0~7,1t [n~f:\j;:::8:52 Doodlebua BN Pads $ 1.16 0.1666 '$' .,C-;:0;2Dt '$F "'~7~ 2!36~ Duster . exoandable $ 5.75 0.1666 :$-,': '., -;-:0;96l :$1"'. ':':':11\50 Soot Awav $ 2.74 0,3332 $lL .. ::"::0:91;: i$&,"'-"~~,1 0:96' Cleanina Pads $ 4.70 0.1666 $1>.'" :..,to;78~ i$V .~:t":',9~40; Wox Mon $ 6.60 0.1666 $Ii" i::~-.W~13): '$L ")";1 3~59 :$,'-:' \:.:,\::!:::~:':t~~ l $t\:;~,:i<':i:!~~'/: $;.' ";':!.t,'.-:"? f$!i' ,:'..:f;:,.~,..", ,......,......"..:c." $[,. j->'t/.,_?:,-"r.:~ :$ti".-.t.J;~,:~ .;:.,-',;:~ $:.:',':,~,_;'!\:O{;:'~;;t;:' ;n:\:,~:':"":i:::.::- $;,: '.",{':0.'~c :$r:~ ~'",' . . $', .<. ,$t. . .$ '.: ~.i.j,~ ;$,'. $' " . ",: [$f" . $; r_,.,:,.",,,,,. [$,,/-'; . .' ',--.--'.." ~ $; y,';'H: :$;:'< >>~;'::~,\~ :$\ .'.C< ~$J;;"'; '.''-::'" " '. $t ,..,.'.'......' ..:..'~":_, !$i5_'J.l::-:~:,~t~) , ,~,-!.,' ,.~;,;,::. '$t " ,<~:,:!r~':!22! : $~).\':~':';"".'<'f.~ , $r"ff\:\,\';;-:':-'t t$l1::f.:':': '.:'.:'P". $(,; .~:~;i'-t~~t[t ~$r::,;:: .. .' $; , 'yoy ;$;y<:,:7' .... .' $~: ',)'~::::::.i i$h;;':~:'r\-:~":,: $" ;','"':;; i$l-;"~'; .",;::C..~;" c. $[, .'V__.,';;;~:~i,h~: ;$'\:?:,-:':':,:~;; '$!f)- ."ri-~'~.t~~1": :$~':');:,~t/~c_1:'.~' $i .0':';':::11':7;'- l$r.;~ ;':-'-;'J:~A',:: . .... --.....,.,~ .. Total ~$" 19:44:: ;$~:":~233;29, -,....,.- ."'W .'-' ".,,- .. . rAreai!Qgr~.~!L~I.~.f.QLmul~driveii ':;._L::"~.3 Monthly Cost.. Monthly cost is computed by multiplying the total unit cost by the units needed per month. Annual Cost = Annual cost is computed by monthly cost times 12 months. DAS Form #12 J Revision 10-03 Page 2 Supplies Sheet :ll4i u . ~~ . . "' 0 .;: iiCl e 0 1ii~ - 0 -"<.> e " '0 . ~e ~.. o . e " . .. . o o o a E o c..c .S e . ." "0 .'0 o 0 s;; ~ .~ .. 0 ~ ] [ ti ra III ~ ~ ~ o "' ~ 8 - e .g~~"fi (J) (f) u.io ~ ~~.~~ 0 i:2] 2-~! I1J I- 2 ffi E ~ E-~1l5 ~ :!: ~ f~ e ~%,s;: 0:: ~~o g f- " E . e .. " a W a .~ II . Fe . ... . . .- e> ~1= o I- <.> '" 0: I- Z o <.> <Xl ::l '" , ... , . > , ....~<.4f.?~ . e 1= ~ . o <.> o o E .< u . . o . . ~ E . .. {ie] jg.8: ~~- _b~ &~.E ~"S g. "'" . . o . :s .~ ~'g . e a.a ~.~ o . . .- Ql CD 'Ii"" -'0. ~:E~ "H" "' ti . e .. . :s " .. '0 >l . 'u o ~ . ii u . " o o ~ ~ ~ ~ " ~ ~ c c " o ~ m 'u -g - " li .f: CI o " f~.2 G-5.s: .-~ .o_~i 1l.~.2: . .e~ g ~ 0.._ III 0 ~ ~ .~:: ~815~ ~g~g j!!1llt;;..c:: E 8. ~~ t;; l:'!:s:ij ~ gl:l: ~ 15 a: @ .~~:3 : E~~.!! Ill> ;;:l ~ ~~~; ::J III III 0 g~ :1:; 2l;::lCOc ,s'g ~CO o=<.!! >00.. .. ffi:;~= -OZlIl . ;; o S o .. e .'3 a u . ;; ~ggg8r, ? ~1ii ~:gg~g~~, g8n~m:H' <( f,'~L,B'~,t;~' ~~~~'!!~ ~, ~;. f'~"!;'; ~?{t r~ ~ tjHft~H~.: r!~,t,;;:;,,-~~~, rJ~.~gr.~~~r.~ c~ " 0 " ~~555-~'~~'~.1'~"' ;:; a ~ !=! !=! ~ ~ ' .: -.' ~'fl ,~ ' ~, ~'.: uUMoo.no'.'I'. .....,~..........-...'.....,i..;'... 0' M co <0 M co -r<' "," 'il - Ii: I~' ' " D ~" ~ .t"'UUh, t ~ ~Ii;' t11'1. ~ !:?'!!~~!'!!~; ~ ~~. '&..~,~-~ L;:~ ~~ **-*-*-* ;:;CI~~~~~ . . 0" li.*- .. ~5565~r~~WI~(~ a~I~~.I~.lri.'l.II.'jlli'~1 ~~~nih~~I~~~H ~.f!~a~hU~H~ l[ g.~~~~~~FV6~~~I~[ 1IIIIrlr~;~~III~li~ ~ L., '.~ ~'. iiir ~ f' r ~ ~ t .J ~...' O"llHHii~biilll Ui NNNNNNNNNNNNt\iNN ~~i~~~ff~Fr~~~~FWr O=~~i[pu" r.'~~~R! B &~l~i~: I ~~~~~~1 .!..~~~(!j~ ;;;: ,. ~" ~o ggg88 4lEgg~g '2 u oq- N. "'t N. :::I;t N UJU}Io9WVl- ~ ~ ~ a'~ ~ ~~~~ ~ 1'Il'- !l ~~"~m g:::;;:~::J~ ]l5~.oE ~~;fl~&l .....NM...,lt)<or-(DOI~::~~::!~ . .. l?- E . e .. " a W ~ m 1;; 8 . ;; o o o t o ~ ro ;; ~ c o . "0 o " .. .'3 E ~ m . ~ ~ 0_ .~ .e1il ~" . 0 6 8 c .!!l ~:E .....~ ~ ~ z. ai ""5 E 6 ~ ~cg~~ ~ ~,g -g ~'f? -;::5.!!:J ~ E Q. . ~~~.!!L~~.~~ .5~g-c~-;;~s =::"UEwEU)'Q -Wi ~ ~ .g...o:o::: 13... E.::......::J::2ffi~~ c.l::~O'"::::JQlCE '-8_Qlo>-8~ 5-Ql~L~~@ c (l)...c::o....a:;:a.Q)Q) ~-;~og1ii:5= .::::.55~::8"*~ cO:2ili<1lQ,l-CiE ~~~B::::g'~E~ -0- >.\1) Q).......4J 8 <I) m~.o=g''ti:508 "5~~~~.~~:;'E E rn.- ~ e.- Ql::::J .E'il"5~Q)c..~-g1> .~'..... ,.g ~ a..!!!;;::; Ql Q.i ~~~"5G):5"5c'e C::o= Vol E 3:5 E ~ c. 3l:B'~~1:J'~~5li' isJ~ ~-g.~-g-gli'-g ~~~ '2&.~~~-a~ C'Ilo:tla.E,:!:!O"gEE ~~~8.TI~0~8 nil" II n n n ~&:: l:1'~S :::~>~ u:5u <<1>~~ ~"'1ii cl:!O-$ ~~g 5~8'~ ~ ci :2fij'i;;Q: e ~~~ ~ .. . C M . a . .. ~ NM ..:; Ij- .2~ . "'. ". 00: oj <~ ~ . ~. '!g' .. :sa e ~ h- e ~ . ~ ~ o . Q o o ~ i d ~~. sH ~ 0 8 8 8 8 0 0 0 0 8 g 0 8 0 0 0 0 0 0 0 0 0 0 0 0 ~ ci ci ci 0 ci ci ci ci ci ci ci ci ci ci ~ " . ~ , , ; [, ~ .. , . ~ j , f i ~ f' " , i , " - !:; ~ , , " , ~; ~ , ~ , , 0 . , i; ~ ~ . ~ . r , j t " . , 0 ! ); . . ~ ~ .. ... . ~ . " . . . 0 Z " N ~ > e ~ . " .. . .~. . . " r i: , ~.',' P ~' , ~ ~:l , :. , a ~ , >:. L. ;I;I;I~ ;) :; ~' ~ , ~ " " . . . . . . . ~ . . . Ii r ~' ~, , , , . i " , ~ " '! , , " ~, ~ M ~,~ , [' " , f ? , ~ . " t, , ! . " . . 0 " " " . . . . . . .. . . . . . ~ !i .. t :s o. 0 , ~ . t " 0 0 . 0 . . ~ ;; ~ . ~ " . . . . .. . .. . . . .. g.Jit ~ 'a_ M e 0 ! ! 0 " . , " . ;; , . ~ . " .. " . . . . . . . . . . . . ~~ ~ ~e " . . ." N " . ~ " . , . " . . . . . . . . . . . . . . . . " < 0 0 ci . ~ " " , ;; :;j " ~ .. . . . . . . . . . . . . . . e~ ~ ~~ i . ~. 0 . . . ,; ~ ~o ,U . ;;; " N J . . " ~ . . " i 0 , . , ~~ ! ~~ ~ . ~ . ~ 0 ~ ....N~..."''''.....'''CI>~::~~:!~ 1i . " '- . 0 ~ 1 t: J: . . ~ . ~ '. 5 " il!; ~ i1 ~ ~ '~ e w " " ~ ! ~ . g~'8 .. ~.J:.8 ~5~ tl ~ !j . " ge . e ~~ Ji~ gg ~al ..:. i g ~ ~" ~ h ; ii ~ Uo ~ i~ ,~ ;;~ ~E ... ';:fi Sc 8.5 ~~ 15 ~ ~ 8 . ,g."",::: ~i <f. <(=<5 x:s: tl:S 'il a ~~ ~ ~~~ ~& #.E. 8.{'! l!! ~ D.'E ... Q 2l ~g1"""::aE 3E~ ~.5$U >- ~'!::5 J::'f,i<LIe.2oiiill!o ~~"i1p'll~~ i-ilg.q. l5.!!<,p.:Je_~# e f!~~-~ 2.:1 s;:~ ~"".2.2IG"'l:S! ~g'Oi.nj~:h: 1=1'<:: :3"2"2!l n l!! :E~;;~~';';~~ lf~'" ~ ~~~~o '~.2~g,g,~~5~ lidi.... .,~i~~~~~~~~ ii~ "1'$'. ,s S Sij! g ~ 11 ~[ ,:g:;j~~~~Bo~~~~~ 1.~1. ~ ~ ~ ~ ' , ~ II ::l ~ n E ~ ~,~,~.~~~1?l <'O...;~ 'B.-c ~ ~ E ~~~-c 'c ~ 1: ~ ~ 'S ~ <'0 ::l;:l;:l;:l ~ ~ . 1;'fi 0 E '=> <=~EEEE-81l~E Je,....'3 ~I- ~ ~ ~ ~ III III ~ c: = ~ t E ~I'HH"" 8 ~ ~~ d I';~ ~~aa..!;;.!;;~8 il.!!....c: "Ill! E E E E '5 ... = '" Ill"' ~ ,~ di 8 8 8 8 g. g. g ~ ~ ~ ~ ~ ....... .-;-; e.......rl~~... ~B!!!~o :.s.e.s.s;;::t 'l! ~ 1: 1: 1: I: ~ 3fo'lfo'lfo'lfo'l~~ ~~ 0" . o ~~~~e B.Q~g~ .e.=l....=I: ~i~!i ~..~.=I ct~'ii ~ ~2 c << j L ~~ .!!6-: "5~i'l HS ~H $ .~ 11 ~ ::l s'. llH . [" ~..~ :I~~ -go= .. g>~ ~'i3.. ~ ~t ~.~ 'i ~~ -g r: ~ "'5 .~~~ '0" .! 0 o 8.1:! . "" i~~ -8.~= fl ~.~ .c. ... r:~ ~ E,!ij;; ~~~ t.. .so ~~ 'Sij ~ ~:5; ~~o ~H ..~.s .. . .~ ~i .~ -g " 8.8.g, .!.ii! liS" Jiel 005 l:?;d. ~ ~. Z ..'2: .~~ ll" 1!~~ ;li~ Lo "" 005 'D1l-g Jo ~: '. ~~ S:oia .,- '" '~lls ~,,~ .e ~'D 'llc ,-'I th ~H ' i~~~ [:li~ .....,,0 E':~'5 ;o.Q 8.~ U~c -I'!~~ ~~.8 ..?;..!!! _ ~ ~ll If ~::g .~ ijir; ii .....~ ~H!g ',',~d. c. :::.s ~!:I ~ ~ 1l.g.8'~ .o~"- E E...~:;' HI'~ il~H t,'t~ "=~f5" .. . f!lt . '!.~ ",.... vW"3-a ~~~~.~ ~{j.l2 ~ ~ ~~~.;~ ~i!!l.fl ~~f~j6> .!!Ioo3~. ~i~fi~~ . ,.. I" . ;; . ~" .t . ~ . .11.~ ~1l"S!5~ ~H~~~ ~H~&' i~~~f~ 0"111- 1:;; f.g ~$! . ..~ ""~.. "~=B ~-=~ ~ 8..3 riS!o!!.:<; ~[ .l..!!tl'O'!!I~ f! tt"e.; E g ~1ii~B~1ij ~i]l.2.'O~ ~"'s~:t~ :;;'~r~~ !i -= ~ ~ f 8~.si:: ~ ~ ~ f!~.g:i~ ~.,~H ~ B ~ ~!';: .81i.;S!';~ c.., . ~~:5 iil.8~ ,s3~e{;8 ~oltsi!z:: ~.".~lt ~ g ~ ~~. ....0 8 f!~ ~~~ l?~fi ~2iIJ: U;:,;.s ..'2il!.lie'" =.~ 0-:':. '3,E $; .,' W~ 1ij-rdi1!'tj ~1i~-8--5 'ej~t~e 2~iU; ~ --lO & 'Iii 0 ~ ,ll .~. ''If"~ ~i8.<. :::. 1l ~ ~ ~ ~ .. >.8.-! ~6~SeK i~!~~~ .. _ so 0 H~fn ull~ 0 o~ ~~~i~~ " [ . ~ " , W " > 'lj ! o . . . " . . a ; ~ e " " ~ , ~ ~ [ ~ o . ;; o . . . o Q o . 2 ~ ~8. ~ ; 3~ .~ eo ~. ..~ ~~ ~~ .. .~ ~[ :2 '''' ~. eQ. "" ". ~! '~l h ~~ '0 i~ ". ~e ~~ ..,.. if .~ i ~~ .;, ~i ~ 0.. .l:ii ~! , .. ~ :~ ~ o.ti' ~ Of ~ 2~ .~ i ~ S~ -~ ~.i ~1! 'Iii"' i ~ -< ~j ~'"s ' .lZ f~'e~ ~~~i . g~~~~ c." I . . , 1! o . . ~~ <2 ." -. :5; 0:2 . > .~ 'D :~ ,~ [~ ~~ -. l~ 8.:6. .~ i~. o~ .0 "0 ~"": cg " 5 " ~~ .0 Se ~Gi ~~ ~o ;%;3 ~:6 ~~ ~~ "" "'2:6 .. ~~ o~ f~ e. co ." , 0 !~ "~ ~ ~ ..'s. ~:!2 ~~d ~1i ,~ ~lii 8~ .- H g~ ., d .Eli 'it 0;'" ;! ., >" .. 00 O' ." ~~ !l ~t ~i e" ~~2 ~!l~ ~2~ ~ ~~ .'- !!jl~ 'Di~ ~Bg, ~~= -." il~~ ..- ::l,g. >"~ g,!i i!~Oi <U . . a ~ " ! ~ i " ~~ ,- If~ ~i co . OVERHEAD OvemeadCDSts Paltlway EnterprisCilyofAshllnd 2010-2011 Ashland PollCll Department There are many different ways organizations allocate overhead Internally (e.g., Percent of total costs, dollar figure sum, as a percent of In the space provided below, Indicate how your organization allocates overhead to this particular contract, what Items go Into your ave overhead amount Is (whether as a percent or exact amount) Oregon DapattmentotAdmlnlstnrtlvaS.rvlcH Project Costing Worltsheet IFILL IN ONLY ONE OF THE THREE METHODS DETAILED BELOW! Percent of Total Cost Method: FOf every dollar spent ptoOOcino a finBl p.roduct, or p,ovlding a service, a certain percentage oflhal dollal is required for overhead. Toealcul..t.1heovemeadpercen!:ilge,illsbesllohvafinanda/r eeordsforyour Drganizalianlhal go back a year or more. Addloge1herlheexpenditureslhatmak.uplh,ovef~eadcosl(see worksheelbeiow). Now add thi, figure to the Raw maleria!l, Direcl.labor and Oelillery fDl'. total cO$t. Divide lha~~reIOloverheadbylhaftguraforl\)!alcosl5. Thernullls a percentlhBllepresenboverheadas a percenlageollhelolalcost.Ufonanclalrecor<!sarenolavBilableestimatelheov",hudnpenlesesbeslyou can.estimateolh"'cosl5lllbestyoucan,anduse~'esamefo'mulalogelapercenlage. 1. Enter Overhead as a Percent 01 Tolal Costs 20.... OR 2. Enter Allocated Overhead as a Dollar-Figure Sum OR Dollar.Flgure Sum Method: Y<Al C<ln enter the doDar amount \'IlU are aJlocaling I\) overhud In lhe bcx if you ale con1ldent lhatyou can aIIocale overhead itelll3 I\) !hI1 partioul31 project. You can use the Worksl1eetas a 1001 (ifneededj I\)ldenti urcosb. 3. Overhead as a Percent or Total Direct Labor Hours Percent of Total Direct labor Method: To ld..,tily overhead costa, you need lt1e financial recordsforyourOlganizetionor divisionf or the pllSlyear. Input all the C<lsls olthe entire entity "" delailed below. line itelTl5 which are not detailed below &hould be Input into the celli mwked "oIher"; please Indude a description. Whet you are trying to detennlne br a pe<cenlel1',lherefore. do notgros5 lip the ..penses lor Innation or 10 conform I\) the curenl year budget. N..t. """,,Ilnlo the cd below the I\)taf liredlabor ho.n paid culbyyow entile orll8f\lZation for 1he.ame period. These fillUrel slIot11d be loundonlheye3lendpsyrollleport. Donol Indude houn.whIch earl be o;:lassified as management or administrativa CO'Sb. (Inclu<ing theae costs Into the lireet labor hou. total wlll ddatelheaclualcosl!J,)Theworksheelwil! Cllmpll\elha ""erheadasalileite mcoslbydlvldlnglhetotal rO'ecladlaborhourslorlheconlractintolhetotal ,ojecledlaborhouraforlhecurrenlyear. TolalAnnual O~ectLabor Houri InputTotalfromWorksheelon8e1ow Ovel"~eadperlaborhDUl" Tornelequlredlocompleleconlntl;! '" Tot~I"aclgned Overh....d WORK AREA: Worksheet Total Annual 0 rations INDIRECT COSTS ORGANIZATION DEPARTMENTAl M."agemen\Safaries ManagemenlPayroIlTax Expenso MllI1agemenl MtdlCIII Insurance MlUllll}ementPenGionPlan ExpeJlle Saln & Adminlstrelfve Salarlea Salea & Adminlatraltve Payroll Tax Expenae Salea & Admlnlatrelive Medicaflnsuranca Salea & Adminlatralive Pensloo Pllll1 Elcpenae otnceRent AdIIertialnll and Public Elbcation BackgroundChacka&Urlnalysla Profeaalonal & Ac:countinll/Audit Fees Trelnlng&WorkerSafety I-~ Tel""hone Utilitiaa PropertyTaxellllJcemtlllFees OUea&SubBcrlptions OepredatlOl'Hlfflcebullding Oepredatlon-offlceequlpment R""aIra&Mainlenanee-oflice aeanlng IIIId Maintenance Ol'fice Equlpmant Rental Ol'ficeSuppllea Pcatage & Freight Rehab MlacellanllOUlElcpenaa BadOebl!l Other:" Other:" Other:" Other:" TOTAlINOIRECT COSTS Use the area below to show how you arrived at the final figure that you show as your total Overhead CPIF_IronlBU/MO'"*botMj ,- ,- """.,_"'_...mnn.""""_ Total 1$- OASForm'12J Revl.lonlo-03 Pege~ OvcrheadComputaUonShaet Delivery & Reserve Pathway Enterprises, Inc, City of Ashland 2010-2011 Ashland Police Department This category covers any costs associated with delivering your product or service to the buyeL A service contract, for example, will likely include the costs associated with getting the individuals who will perform the service to the place where the service will be performed. Gas, oil, vehicle maintenance and repair are all part of Delivery costs, Most often these costs can be recovered by charging a certain amount per mile, The State of Oregon reimburses 36 cents per mile for its employees who use their own vehicles on State business, That's not to say your costs may be iess or more, The labor required (the driver and the workers if they are on the clock), should be captured in Direct LaboL If your costs are greater than the state allowed cost, piease provide a detailed schedule on how you arrived at your cost per mile, Oregon Department of Administrative Services , Project Costing Worksheet Services Contract 1 2 3 4 Miles Per Rate Per Daily Services per Annual Deliverv Descriotion Service Mile Cost Year Trans Cost caravan $ - $ - $ - " $ - $ - $ - $ " $ " $ - $ - Margin The law allows a "margin held in reserve" This is usually added as a percentage after all other costs have been calculated, The margin % can vary depending on the product or service being offered and organizational, contractual and market variabies specific to the project Some research wiillikely be required to come up with a percentage that not only allows for inventory and equipment replacement, but is in alignment with industry standards and fair market value, Any percentage higher than six percent (6%) will have to be justified to DAS, 6,0%1 Enter as a % of "Total Before Margin" DAS Form #12 J Revision 10-03 Page 6 Trans-Delivery and Margin Sheet Ashland Service Center 200s..201 0 Costing Workbook For Janitorial & Grounds Maintenance Contracts Under the Qualified Rehabilitation Facilities Program --'',,~'' :, '-": .' ., . , , -, , ........ .," '., o' "'. .... Oregon State Department of Administrative Services Procurement, Fleet, and Surplus Services 1225 Ferry Street SE, U140 Salem, Oregon 97301 (503) 378-4642 SUMMARY OF ANNUAL COSTS Oregon Department of Administrative Services Project Costing Worksheet The summary sheet is linked to-the other sheets in this workbook. Any area shaded in light green is either a formula or linked to another work sheet. The only manual input to this sheet will be to input the QRF name. The costs are to be divided into five categories: Raw Materials, Labor, Overhead, Delivery and Reserve Costs: Raw materials consist of supplies, small equipment & tools, and large or special equipment. Each category is detailed on the following sheets. Labor costs is direct labor used to produce or service the contract. Overhead costs is a line item charge which is computed on the overhead sheet. Transportation or delivery and reserve computations are also completed on the following sheets. All these costs will vary depending upon your organization and the specifications for the project. Each sheet will have an example calculation and further instructions for completion. QRF Name Pathwa Enter rises, Inc. Project Ashland Service Center 2010-2011 Executive Director Signature: Raw Materials Per Time Use. Supplies Equipment, Tools & Subcontracting (from supplies worksheet) $ 233.29 (from small equipment worksheet) $, 486.170 Subtotal 1 $ 719.46 (from labor daily worksheet) 1$ . 6,618.731 1$ 1,983.29.1 (from Trans & Reserve worksheet) 1'$ Labor Direct Labor Overhead See Overhead Worksheet Delivery Transportation Total Before Marglnl: $ 9,321.48.1 Reserve Margin Held in Reserve 1$ _ 594.99 I 9:916.47"1 826.37 (from Trans & Reserve worksheet) Total Bid YearlYI' $ Monthly ~ $ DAS Form #12 J Revision 10-03 Page 1 Summary Sheet RAW MATERIALS Supplies Pathway Enterprises, Inc. Ashland Service Center 201 O~2011 Raw Materials: This category is often spelled out in the Request for Offer (RFO). Language such as "Items to be provided by Contractor" will usually reflect Supplies or Raw Materials. In the case of a Service Contract this will likely include not only supplies required to perform the service each month, but also Equipment & Tools. In the case of a commodity contract the Raw Materials will be figured on a Per Item Manufactured basis. Oregon Department of Administrative Services Project Costing Worksheet A custodial contract, for example, may require the following fOf month. Supplies: Paper products and soap Cleaning chemicals or products Spray bottles Broom and dustpan Floor Wax Scrub brushes or scouring pads Per UselPer Item Manufactured - Supplies 1 2 3 4 8 . 10 11 12 13 14 15 18 17 18 ,. 20 21 22 23 24 25 26 27 28 2. 30 31 32 33 34 35 38 37 38 3. 40 Item Unit Units Needed Monthly Annual Price Per Month Cost Cost Pine Q Disinfectant $ 4.80 0.1666 :$;:::i.;';::~+:0:80j 1$~j~;:',';'1 9.60,' Cream Cleanser $ 2.91 0.1666 $r::.~~nO:~8r ~$m::~'::~:5':82 Glass Cleaner $ 6.29 0.1666 ,$,:)';;{,?;.t.~;11:05f l$!P~~'f~12:57' Heavy Duty Cleanser $ 4.80 0,1668 r$K.^~~~<m801 f$li~~'~x 9~60; 24 oz Bottle & macer $ 2.27 0.1666 -$,Ji:;:jlt"O~38t i$li.l;i'$:\:::4~54: Acrvlic Bowl Mops $ 1 ,71 0.5000 :$~t,;~1:)~rO!86~ f$lW{~t':~1 0!26;, Scraoper W/blades $ 6.51 0.1666 ~$W':i,~~t;:1~081 1$~~~13'm; I OZ Pumps $ 2.31 0.1666 : $~tl?t;:l1., 0?38I r$~~4:62: Paper Filter $ 21.10 0.3332 !$~}:~n031 [$D;;."-84!3'7~ Sid loop end Moo $ 5.65 0.3332 ~$~:,~~1~881 1$~22,59' 24" Dust moo $ 4.26 0.1666 ~$[~$.*11,m7.l.11 !$W.D.M8,52 Doodlebua BN Pads $ 1.18 0.1666 1$'&Jt~~.i.0:20! !$l!.WJ;,m2'36: Duster ex andable $ 5,75 0.1666 1!$~i;'t~~~~'4O:96f !$W~~1-1,1~50l S 01 Awa $ 2.74 0.3332 !$~',\uLt:0:9.1I j$m:Z,J.:g;.'10:96' Cleanin Pads $ 4.70 0.1666 '$r::':-J.ifi:W,0~76f f$f;;~":',\;;;"':9~40 Wax Mo $ 6.80 0.1666 ' $\?"'-t";;::';'H131 ~$!f::'..:;r'l13:59 :$;:."t:~",:,;\~l}Z ;$W:'t:f~fS1~~'::~ $'t.'i':,,;~Z''t'j~1! f$~;~.~tl~~. $li-;::::(;;;:;:;:'~12t,~ r$~1'?,;o;'W'\:':I'~t;;., :' $~itV4~~;fi:'!ti' t$t~~':'~{~*::Cs:'i $~;'~'4""f<\,~_~~: 1$1Ii:;;7C?1; $!'i ::.:q;.;;:;ti~~i i $n.,."1;':~:.~,-,~-:~,; '. .$i':~-::,':?':,~,::.:.,;m !$u.n~~?\?.:;, : n:~.:;~t~:-::::~::a l$fi~:!f:ql?t:c:,::~ '$';) ','o,'~,~,",'::,';'~""",~'" I$M,'IS',;tr~"":.:~':" ,',",'J,"',"',J",,-,'_ '$'Y: ,~{'{;':i:C.:~"'~:,:::.'i\f ;$~~'):.:0;}'i;::.r.:,~::::' , $(' ";.';G.!;'::'-~-::$,'f{f ~ $~t~'(;';:t';-:,~,:p,:,,; $7 '}~:::.:,;;.~':,~ t $~~:':?';~~~:r~,C' ,$,'''',~;y,'~ l$ii:~.:;:":'Z:;::':($' $'~' .;-;-:'1::Y:'~ !$~:')2:?,-:'i"' :$r,':::,~:z.-,,:,~<\'~ [$~:,-~.l:'.-"';::<:;, $~~~:;;:{;~?;\~~-i-~1 t$~%'L1.~~:~:''::f:', '$rr',:r8::?:}~";li~ ! $W,"::;~::',,;'t-,:~',t $n, \~ X-t;:"~,~: 1$~..~,~;'~:,~:\J':~:,":'"'' $" ':r~:~:."f. [$i>:i?i::::'L~;,:~ '$: ';:;-':';;:~::f;-f'i-{'i: [$~~'L::':: V, ;;f,,'fe 1$:r-;;"t~;:,;J7'"~~';.,, Total $: 1 9:441 [$'>:"':'233:29: -, ~ - -, - , -,.- .-.'....- [6~~J~.gC~~.b.,!I!~_forITiUla driVen; __..1 Monthly Cost = Monthly cost is computed by multiplying the total unit cost by the units needed per month. Annual Cost = Annual cost is computed by monthly cost times 12 months. DAS Form #12 J Revision 10-03 Page 2 Supplies Sheet . - . . o . e~ .,f '" 0, ~3: ,,0 ~:5 . . - 0, So E- " 0 ..... - e ~o. c . € . 0, . e c o o e o .0 '. . " 0, " g " . . I ~ 0 Ql E N ~ c: 0 >. 8 (; ClI ~~~~ U) (J) uf1: ~ ..J'" $ ell :i= :S .!:l.t: 0 ~ D::8e-~a. WI- 2 '2: E I- _Cell <II <( Ew(/.) ~ :: QJ >'-c Ql ~ [~ffi ~ c:("5 =:E <Il D:Z~.t "6 !' .. " . E 0, '3 ~ w ~ c '~ ,Q :E . ~ . 0,. . . e:e gp= o I- o .. "' I- Z o o .. ::> Ul ,;' <I)~~~Hlt . E ;= ~ . 0, o c 0, ~ o " . e . ~ . e . 0, fl~-g e . . )(:32 .2~ I~E (3'5g- "" . . c . {5 .~ ~~ E E .!2~ ~'2 c . . ~ ~ [ '-E" . :l:E ~ mmUl ti . e- o, . :5 " '~ . " ,5 . c ~ ~ g ~ ~ E " S ~ li " ~ o ,5 c ~ ~ ~ ~ ;, ~ " 0, o :; .gg " 0, .5 . .9 ~ e.gi,s ijl~:E .8-g~ ~~ ~ . '2'= g]! ~i.!! ~ c",>'o ~8~~ .saE'5 e'filc,g ~ 8.~~ C:~5; ~gj: ~ c ~ ~ .!!!~::l ! c~e.!! 11I>::1.0 ~~2"~ :::J CQ GI 0 g- -8 :::;; <II ::J 1Il C 5g ~1II '5:=c(.!:! >00.... ffi~~! -OZa ;";'6600 <OOOL()O ~1ii~gg~g a8B~~q::' <(.. .., r.' (4"./0.,. ~~!"t!"t~ 'O~ ":5 -j::.;080~H ti a <q~,.!!L.<;:: tu~gg~g~,' .. ~ r; n: fj ~ % ~, c..~;~~;~ **'*'** tiCl~~P~~~~ t~ 0.'" 'Iii .. ~ ~ ~ ~ ~" '" O<llMOONO u:e~~gf,?!;j! ~lii~r.:~-F> ::J"- ~ ki t, ~.\( [, ~!:?:~w!:?:f~ c "#.**'*'#.'!. 04lMMMOM ~E~g'~:?r~ ~ ~ f { a~ r. ~ ~ (;< ;';; ;; ~i. , i<; NNNMNC\,NNN(\,MN(\j'NN Y .,~ ~~- -~~~*-~ .:::.! ' c~ 0, o c , .!_~~:5l~~ =: ".. ~o . 'E.!:! =>.t gg888 8gggg ~N~ N -N ..: .....00...""" _ c c 0, P Q.~ - 0 , . ~. We ~ . 2 " , c ,. . g~ ~ > g L. t5;S g:E~ ::di ~o~.cE ~~Ji~&l ....N(')oq....COt-(lJOI~::~~:!~ ,". r ii , ii . " !' " . E 0, " ~ w t:: (ci ~ :" .. ;; !' J'l . 8 ~ ,5 1; c 0 " 0 0, 16 ,5 '" c 0 ~ " " "iJ ,E .9 ~ " ~ il ~:? '2' ~ ~- ~ 8 ~ .!!l m,5 ~. -0, ~ ~ i- ci :2 E a ~ ~cg~~ ~ ~,g ~ ~ '2' c oS,~ ~ E a. ai ' ~~~,!!l~~.2~ <V g.c: r::::;; 2: 5 '=~"04)m<v~_ c: 0 Ql [.8~13 ~ ~g='s:s:!:u~.8 a. r:::~C'::s <vc: E 'S8_4)9>-8o 0' <Il<V:I:..... r::: Q) 1! 8 =~ 8,(1) Q) ~ -;;,~ 'Og <;;:5:5 . ~ 05 5 1;':-: 8'* ID ~~:~~~~~~~ c = -c..... ,c::S 0..... ~"51i'Q)~:;Q)u<ll8 ..!!!'Cii-c-Ej9:fi=,g_ ::s <Il Q) 01 r::: 01 .- E::S iij,!; ~'2',5~ 5 ~IHunu C~<Il '0'5 a. iii iii >-'5 <Il:: Ql a. L. '0 "5 ti a. rot'lla.E.!!g~BE ~~~ ~ 8 .fi :a a ~ 8 n II II n n II II ~~~~ ~~~ :~>~ 050 0:( & GI C '0 iii '0 ~ o.]l ;:) 'It E ~o.~~ ; .i =~~e ~ .2 tii c 0. 'e ~~;:) 0. 0, . e M . o . 0. ~ NM ;;;~ E~ &~ . ~~ 00: Z" ~1! c1~ ~. -. '5 ,1;10 .sg e. ~" ~t ~ - ~ ~ . . ~ o " .~ ~;:: "-ii .~ __.tu gOO <<~~~ O;:;~.!i :l~~~ . e 0 0 0 8 8 8 0 0 0 8 0 0 0 0 8 ~ 0 0 0 0 0 0 0 0 0 . ,.; ? ci ci ci ~ ci e p ci ci ci P ~ ~ .l F " I' , ~ j V ~ ;! . , " . . C' . .' ;; ~ . ~ ~ , " j P ? ,.; ~ " . . . ~ . . . . . . . . . . . . " 0 Z < ~ e ~ . ~ ~ - . !~ :", . ~ ~ " ~ , B ~ , , ;, . . . . . . . . . . . . . . . . t i:'l . . . , :. ~ " " ~ 0 ~ . ~ " . 0 .. . . .. . . . . . . . . . . . . Ii tli .. 0 , ~ ~ . . . Ii " 0 .! 0 g . " ~ p " . ;; . ~ , . . . . . . . . . . . . . *~ . ~ 8 fti .; .; h " ~ " . . . ~ " . . . . . . . . . . . . . . . ~~ ~ ~ ! e . .; ~ll . . N " 0 , , : . . N . . ~ . .. . . . . . . . . . . . .. . . . . ~ 0 ~ . ci ci . 0 . . . ~ ~ ~ ~ :~ . . . . . . . . . . . . . .. . H ~ l ~ ';1 ~! 0 0 . . ,; ,; ~o . . ~ 8 . . " ~ . ~ . . ~~ ~~ ~ ! . . _"l"'''''..,<l).....'''''''~;:~~::!:~ , ~ . . < , o:!< ~li:~ .! . . p " ;;; . ~ ~ " il!; ~ ! ~ ~ " e w " " . E 8 , '. ~S~ ;2..s~ ~5~ rl i . j; g e . E :a~ ll~ gg .., -.5 ;b :ll~ ~ ~'a ~ ~~ ; ~I ~ 00 n J,!Lf) ~ -... ~ ~'" f~ a ~ 5 ~ ~ 8.= E . 5 '2 ~ 8 . <II al .~;;~ ~W 'iF. ~.!!-5 8.~ B,Si 5 "'C e! E lS.f::i: .~:!:: :J E &! :::I., ;fi!E. ....Z':!! ~~ Q.E ~g~ f!C1..-:.EOI 5E:u 5~*8~ .S1!5 =liI~I!!%g."'=o .!!! i'; r-. III E co ~ ~ '2 ~~!3~2!li~rl.': .... G1(,c>::lI:_ 1\I..... o~~_..,_.. 8.:q~J'.l 5 :>...., l5 a al .. l:J ':i ,g~o~~~lllE~ o..c:gj<;1';2'J.!'Il!!.. C >'~'" "'O::O::~1! .... ~i~;#! gg~ ~'6o ~ '1'~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ · ~~ >.>.>.== III ~"" ..c; ~~~~c;c;~~li) 8.~~ ii'i$.s:g ~]j]i!i li.g '5"t;1 ~8. .E;I:- e .Q :s g 0 a"" 2 _.,.g OJ) l'le 5;G.g..c 1j 13 'O:zi "". -c >. ~ ..:::>..c:....ii: '#.E(')~.c:;::l l'5i,g 2' 2' 2' g' 5 50 8 r{ '" '2 ~ EI-c.>..:;:.~,>.~~Lf) al.....!E'iS."'C .goa.~-aa.--'21l.!!:~2cD le103:ZSZS'S'S E E cD>>~ ~ ~g ~Iai E E E E .;! .;! 1i Gl Ii !!i!. .... '9 ~1i~~~~88g~iil,",l.'lE l!! j;: <II '" r:: -... >>I'l ~~}L~i~~~ ~ ~ ~~ g~ I~I~ ~~~C.S:S5 ~ iil-;:~ l!!eo!i~~g.g.a:c1!:c~g .....<llllOUUU__ ~t-t-r-;> ....... ..... f.-N"""~o& "'~li""f! ~i~~~~~ i1~~~ ~~~.g~~~ .gElfiij~ .OlOlOlOlf.I:;. In: .0.1:1 .... ~ .. E ~.=I ~~ ll=~i O. b t:t: S ;3~:i 1l !ii~ .!I~.s iJlf!f :<=",3 ;s:.2 ... lij~ ~ ; &.~ ";:08- ~2~ u.. ~i~ ~.,~ .;!s:: So. ,00 :l~l ~-g= ~., . ~~~ i il! · ~e-: . 5 19~ f;ca ~ ~ ~ o 8.-g !~i ~ ....!!! a51l rlti... 1:~~ ~d E~~ l~~ ~~~ ..' ~~~ -.co O<~ .. lijo ]j g,~ ~~~ ..!!- .:8.~ ~~~ , ., 8.8.g, . .. ~~5 ... ... ~~s "'2:';' "S -: g.~ .8 ~., .!I~ g. B; ~1ii1il -5~ ili~ g~~ 'C.<>-g $~: ~ fi.~ 1::0::11 ~~-: ~~i ~~1l g [.a i1il.5 ~q !is:: ...2~ "':i5:i:!'5i 11'<::001 g:~~i ....!ill) ~il"O 0.... ~ .. ~. 01i~8. :1:2-,8 [~~..!!! ".e. a.15 ~~ & e.:-g c~~... " ~ 1i ~ .... ..... . 1= :l-aeg ~ ~i~~l g :!.s~~~ ~ ~.8%.go~ .<! tfi!~ i ...-1I.,t! t: .~~~~i 0 :S~.g'il~ ~ ~ ';l '":l 8. ~ .." 010 _ &. $Oi!~5~ ~-"'''I . !! g.2. ~ ~ ~ijjr.lS ~ :~~g~ E i~.:!~~ i ~~~;! ! ~:8.~llB 9 II E 0 t: ol!! ~ ~~~~.2W [ .!:16~8t!:~ ~ !i~g~~ .<: -0'.1 j Ii~~e~1il 5 ~~!~i~ .. ~~~!o5 0 a.~<>~IL: ~ ~i!~t~ ~ o..___t!:..... ~ HH;~ ~E:...9l~ n~~l~ ~;:._~~. e'c.M.3E~ a.~ -E : t- :5;;;8.<>.<:'" ~ ......2.0 2' .!!l;'C~l:I:g ,"5~}:Jil~ .i1f BEll! ~~ ~ ~ e 8. 8 ~ ci- ~ '" s !!~e:1;' '2'"g!c"" .~.l:!., 3:5 5 f"!! <> 1Il!~ cu... ...1:1 .8~~i'~ Hi',~ s8~~~8 """d"''''' ~ 580;.\'2 So .<: 8 <>...1'=.. o8~go,~ .8..:uc:~e E!'!~i.2'5 2.eE~~~ ~H.~~ .,a"s t"" ~~ii g(;; j!:l!~u:f; o"c II ..!I 1!8o..E~ ~~i r~~ J~;8 ~~1i ~~!HE H!. = ~ ~~-;;: ":.8.-! ;<>~i~8. !!tl~~ ~,--~n 1!:a.a~::I >< tiU5E.=::" ~~~i~~ [ g !)..1Ii " . ~; ., os ~g cljg 005 ~~ .0 .- se' .2~ g,~ ~" ~~ "< e-Q. 8:"41 ." ~! <::';5 i~ ~~ ~~ iP e. .' ~. f[ "~ ::;1! E"; ~11 <;.2 Do ~i!! .e oiil .j i! ~ =~ i c.l:j ~ e- . 6-E ,.., :;8 ~... i~ ~l :i!~ [~ .25 a! s".;~ ~~ ~!i'u... u~ .12 $ g>e~ ::I g':i!! ~ 0 ~~ ~ ~! 0," ~ . . , .~ " ';I ;; ~ Ji~ '0 .. -. .. s; .,:2 , > Ii ,~ [i! .~ ~~ ~g- ~.- .~ ~. 'N ~. "" '0 '0 ~ "". og " <>, ,,~ ." "0 8e ~ai .. ~~ 58- ~o ~o !~ I~ "" ~ 8 '" !! ~~ ~~ .0 -. '0 !~ , ~ o' 0> .. s~ . . . " .. .. .~ g8. 2~ ~ . ~~ ., eo -- ;. ~! ., ," a " ". [-g E~ :!i!! ;t .- .. e. ~~2 a.ji3c ~;;~ .8~" s~~ -'- f~~ 1I1l ~ 5.sg. il~= ~;s::! i1!.!! ..2:5 ::.lg ?N ~-!i ~~.. <;8 " . o ~ I i ~ . i , ii~ 5~ "t ~o . OVERHEAD OverhudCosts PalhwayEnterprIsAshhndSelvlceCeoter201G-2011 There are many different ways organizations allocate overhead Internally (e.g., Percent of total costs. dollar figure sum, as II percent of direct labor, ete). In the space provided below, IndIcate how your organization allocates overhead to this particular contract, what items go Into your overhead, and what that overhead amount is (whether as II percent or exact amount) Oregon DeplrtmentotAdmlniltrat/veServl"". ProjllClCostinllWorllshHt ? IFILL IN ONLY ONE OF THE THREE METHODS DETAILED BELOWI Percent of Total Cost Method: Fo, every dollar spent producing e ~nal product. "r P'O,"d1nll a uovlce. a .",ta;n percentage oflhat dolla, i. f.8<lforoverhead,Tocalculalelheovemeadpercenlalle,iti.besttohlvefinanclalrerordafC)l"your organiza~onlhalgob.ck.y.arDfmDfe. Addtogetherlheexpenditureslhalmahuptheove<he.dcosl(see wOIlt$heetbelow). Now add !his figure to the Raw materials. Difed labor anp OeUvery for a toW cosl Oivide the figure for ovemnd bylhe figure for total costs. The result is apercenfth~lrepfesenlSovel!leadlS a percentageoflhetoblleoSllffinantialrecordsarenctavailableestimalllllle<lVerhude~penae8asbesty<:lu CIIn. estimate other costs as best you can. and usa the same formula to get ~ percent~ge. 1. Enter Overhead as a Percent of Total Costs """' OR 2. Enter Allocated Overhead as a Dollar-Figure Sum OR Dollar-Figure Sum Method: YoucanenterthedollaramountyQuarealloC3tingtooverhudlnlhebo~ifyouarecon1idenlthat you can allocate overhead item, to this particular project. You can un the Worksheet IS a tool (i(needed) toldenti costa. Percent of Total Direct Labor Method: Toldenlifyoverheadco.ts, y<:Iu need lhe flnanclal records lor ycur organlzati on or dtvislon for the past yt!81. Input..11 the costs of Ih.. enUr.. entity as detailed below. Une Itema whlcl1 are notdlfla~ed below should be input into the cells morked "oll1er"; pluu include a description. What yoo ara !rIing to determina is a percentage, therefore, do notgrou up the ""penseslor lnnation or 10 eonlofm to lhe currenl year budgel. Ne.t, input lnto the cell below lhe totaldrec:lt aborhourspaid outhyyow entire organization lor lhe Slim.. pariod. These figures shauld be flUldon lheyear end payroll report Oon.ot irK:ludel>oo.n~ can be c:lanifted as manalleme<lt or administralive~b.(Indudingth....e COSlS lnlo the direct labor houltotalwiUdeftatelheactualcosts.)Theworksheetwllteomputelheoverlleadasalineilem cost by cfviding the tolal ro""cledlabOlhourslorlheeonlrectlnlolhetotalflroecledlaborhoUfsfor d1e current year. 3. Overhead as a Percent of Total DIrect Labor Hours TotelAnnualOirectLabofHo..n Input Total/rom Wor!r$heet on Below OV<<lteadperlabOfhClUf. Timere'l\llredtocomplaleconlract "" TotalAsslgnedOvertwar:l WORK AREA: Worksheet Total Annual 0 eratlons INDIRECT COSTS ORGANIZATION DEPARTMENTAL ManagementSaleries Management P8yfolt Tax Expense MlInagementMedioellnsuranoe Management PensIon Plan Expena. SaleS & Admlnlslrellve Salllri.... Sales & Admlnlslrellve P8yfollTIfll Expense Sales & Admlnblrelive Medcallnouance Sales&Adminlslrldivll Penslon Plan Expense Office Renl Advertlslng and Public Educetion Background Checks & Urina/ysls Professional & Aoco<rlting IAudil Fees Tralnlng &WOIker Safely ,~~ Telephone Utilities Property TaxnlUoenslIslFees Dues & SubscripUons Oepreclallon-offkebullofng Depredallon-ofllceequlpment Repalls& Malntenance-office Cteanlngand Ma1ntenance OffiCflEquipmentRental OffiCfl&Jppllu Postage&Frel~t R....' Miscl!hneousExpense BadOel>ls Olher," Olhe,," Olher:" Olher:' TOTAL INOIRECT COSTS Use the area below to show how you arrived at tha final figure that you show as your total Overhead CPI_,*"8l3~tlIcb*-l ,- ,- ..",.'_..M__..........._ T.., IS" OASForm't2J Revbl0ll1o.03 Pelle~ OVerhud Compullltion Sheet . Delivery & Reserve Pathway Enterprises, Jnc, Ashland Service Center 2010-2011 This category covers any costs associated with delivering your product or service to the buyer. A service contract, for example, will likely include the costs associated with getting the individuals who will perform the service to the place where the service will be performed. Gas, oil, vehicle rJ"laintenance and repair are all part of Delivery costs, Most olten these costs can be recovered by charging a certain amount per mile, The State of Oregon reimburses 36 cents per mile for its employees who use their own vehicles on State business, That's not to say your costs may be less or more, The labor required (the driver and the workers if they are on the clock), should be captured in Direct Labor. If your costs are greater than the state allowed cost, please provide a detailed schedule on how you arrived at your cost per mile, Oregon Department of Administrative Services Project Costing Worksheet Services Contract 1 2 3 4 Miles Per Rate Per Daily Services per Annual Deliverv DescriDtiDn Service Mile Cost Year Trans Cost caravan $ " $ - $ - $ - $ - $ - $ " $ - $ - $ - Margin The law allows a "margin held in reserve" This is usually added as a percentage alter all other costs have been calculated, The margin % can vary depending on the product or service being offered and organizational, contractual and market variables specific to the project Some research will likely be required to come up with a percentage that not only allows for inventory and equipment replacement, but is in alignment with industry standards and fair market value, Any percentage higher than six percent (6%) will have to be justified to DAR Enter as a % of "Total Before Margin" 6,00/01 DAS Form #12 J Revision 10,,03 Page 6 Trans-Delivery and Margin Sheet . Ashland Street and Shop 2009-2010 Costing Workbook For Janitorial & Grounds Maintenance Contracts Under the Qualified Rehabilitation Facilities Program -.-' = , . - ,,,., . =." '~.-'"""'.: .' ,- . . ',!... : -, . ",'" . '." "., .' ......... Oregon State Department of Administrative Services Procurement, Fleet, and Surplus Services 1225 Ferry Street SE, U140 Salem, Oregon 97301 (503) 378-4642 .' , SUMMARY OF ANNUAL COSTS Oregon Department of Administrative Services Project Costing Worksheet The summary sheet is linked to the other sheets in this workbook. Any area shaded in light green is either a formula Of linked to another work sheet. The only manual input to this sheet will be to input the QRF name. The costs are to be divided into five categories: Raw Materials, labor, Overhead, Delivery and Reserve Costs. Raw materials consist of supplies, small equipment & tools, and large or special equipment. Each category is detailed on the following sheets. labor costs is direct labor used to produce Of service the contract. Overhead costs is a line item charge which is computed on the overhead sheet. Transportation or delivery and reserve computations are also completed on the following sheets. All these costs will vary depending upon your organization an~ the specifications for the project. Each sheet will have an example calculation and further instructions for completion. QRF Name Pathw Enter rises, Inc. Project Ci of Ashland 2010-2011 Street and Sho Executfve Director Signature: Raw Materials Per Time Use. Supplies Equipment, Tools & Subcontracting (from supplies worksheet) (from small equipment worksheet) $ 134:251 $ 486:17 Subtotal 1 $ 620.41 1$ 2;647A9' 1 1,$ 883.22-1 H$. Labor Direct labor (from labor daily worksheet) Overhead See Overhead Worksheet Delivery Transportation (from Trans & Reserve worksheet) Total Before MarglnP$ _ 4.151.12:1 ReseIVo Margin Held in Reserve 1.$ 264.97'1 :4.416.091 .368.01 (from Trans & Reserve worksheet) Total Bid Yeartyl_$ Monthly.$ DAS Form #12 J Revision 10-03 Page 1 Summary Sheet , Oregon Department of Administrative Services Project Costing Worksheet RAW MATERIALS Supplies Pathway Enterprises, Inc. e;'" of Ashland 2010-2011 Street and Shoo Raw Materials: This category Is often spelled out in the Request fOf Offer (RFO). language such as "Items to be provided by Contractor" will usually reflect Supplies or Raw Materials. In the case of a Service Contract this wi1llikely include not oory supplies required to perform the service each month, but also Equipment & Tools. In the case of a commodity contract the Raw Materials will be figured on a Per Item Manufactured basis. A custodial contract, fOf example, may require the following for month - Supplies: Paper products and soap Cleaning chemicals or products Spray bottles Broom and dustpan Floor Wax Scrub brushes or scouring pads Per Use/Per Item Manufactured - Supplies Item 1 Pine Q Disinfectant 2 Cream Cleanser 3 Glass Cleaner 4 Heavv Dutv Cleanser SOder Counteractant 6 Car et Lane 7 Ca et Sham 00 8 Emulsifier Extract 9 Acrvlic Bowl Mo s 10 Scracoer W/blades 11 I OZ Pumos 12 Paoer Filter 13 Std Loco end Moo 14 24" Dust moo 15 Doodlebuo BN Pads 18 Duster - exnandable 17 Snot Awav 18 24 oz bottleJw tri er 19 Waxmo 20 Cleanin Pads 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Unit Price 4.80 2.91 6.29 4.80 30.65 5.00 13.01 2.27 1.71 6.51 2.31 21.10 5.65 4.26 1.18 5.75 2.74 4.70 6.80 4.59 Units Needed I Per Month 0.0833 $': 0.0833 '$', 0.0833 $" 0.0833 .$;_ $;. $; ,$.' I Monthly Annual Cost Cost ,J., 0:40f:$;,~ 4,80 ;'" 0:24t f$t..~ ,-::~, 2,9h ,:0;521 :,$:~t<~" 6129 0:40i:$~jr<' -:"A~80j ," ,{:.~~ j$U:Ci.;..::;:I>:';;;,:. 7'~;1! l$~~':i';:,:'_.-, -:' _~-~.t:f ~$t.~~i.::\:D';.': $~ ;;/1-:::;",?'j{:-): !$::;';:;,;.~:~';rt;';;\- 0.1666 '$r::-;:',~,_:'~;;:~0~281 ~$rt~.i',-t~J:3:42, 0.0833 ;$i;'::,;;:'::,\:c~rO:MI r.$~t:::;:;::6~51f 0.0833 i $KT:;l';!;'l>'<: m191 ~$E:i-~-lJ:.l',~"r'-2:31f 0.1666 :$iir:"';',;~~;3-:52t !$[lC}""42l'18\ 0.1666 $G':';":~1:~~ 0:9~n !$~N::":,\1 H30:' 0.0833 ;$;t,~,';';:"{~:0l-35t l$F::',:~':';,I'~:.4'!26': 0.1666 $t:,;<,'i((;',O~201 i$::f?i::,~'-;;~:2~36; 0.1666 $~;: ;;":~>:0:961 ;$!Xf-:;:'Z;,~l H50" 0.3332 :$~:"'\:"~~\~0:9:n l$it'.;;ttr:JO:96: 0.0833 $tl ;',j;:70!39J t$'lf.~~..4t70: 0.0833 :$~_< -';:~;;0:57l !$f1i1',~:ct\-:_6~80: 0.1666 '$~,,~:;';':;):OYl61 1$~'~~t~"~'9!18' '$'F, ~:~i-:;:&;'.:X~ l$~,'~t;-:1't!\:~t2 :$: ":~",;':':,'~~_~.:,5:J' l$~/,~\:~'~J~;;,'~?:~:; '$ ':"('-;~ ~$ot';.;-~i:.::C '$: ~.- :~~'\~Zi: ;$If~v~-;:'J:g!,~;"-' ,$'~ "i:':\;-:1i:'1$j~:'~ - ~$~: ~,-n~':-~fJ(" l$':'i::;:~,'f;:-':.::,':t:: $;~ '.>,-;:;:~:-t\t~ :$~t!/\;;,:;:,::;',:,,\; $'," '--t:t:}_~ [$W'tA~Cl,:;~-:;'.:<\' $',' ,,' ;.:.~~:!:t [$~:,~'\,;;-; F ""ce i$:.' ': i$., :::,,~"j:;t~ [$~:,',.:-:,; , . ,$ i$!:Jr';,,:;' '$' '";-~';';,,,~,;' ~$kr::::~:,:,,'i:: - $: ,::::)'j; ~$~h':';-,_i'~::~: ~$-' -':<~" :$~: " -< l$ "'-".-., ;$V;:T, , $, :,,<~H~ ~$r&i:',:;:;'-*~;S~/:; $:'~'" '::5F::";',:}Z ;$R.:':-~;~-~',:~tJ-~'-';' i$''''f':'' ';';Z/;~Jm ~n"!1,t -:t'~:c::,!,i" '$,' .., +-":~_''''"l ~$~' _-.... Total $ - 111:19; f$'-' 134~25 ~f~as,tQ_9f~~~..~~e~f9iiilldfadriVen:~ :~:~ ~,___ Monthly Cost = Monthly cost is computed by multiplying the total unit cost by the units needed per month. Annual Cost = Annual cost is computed by monthly cost times 12 months. DAS Form #12 J Revision 10-03 Page 2 Supplies Sheet .- o 0 u . ~~ ~~ ~;: ~~ i~ .5<.> E- ~! ~~ c o E " . ~ . c c o a . (; . .:. , ~~~l;I)~ " . ~" . . E~ ~j:: o I- <.> " '" I- Z o <.> OJ ::> <IJ . . ;: ~ . o <.> c o ~ " u . . C " . "e' ~ . ;S " 0 " ~ ;; . c " ]j '0 c ~ '. . . " g 0 .. u . 0 ;; u "6 . ;; c .: 0 " ~ 0 ~ ~ D " ;; ~ ,,,- ~ C . " 0 ;; 0 ~ 0 0 . ~ ~ U ~O , e 0- " ~ ~~ ,. 0 '" . ~ ~ '5 .9 " . Ii ~ ~~.e .9 .. ~.a .2' u . . O~ E g ~ 0 i:l~:~ " '" " ~ .!l y- . e ~.~ ~ . . ~ :::I.E~ j] Be-g 'e~ g ~ t/)(I) ufo j ~ ~ fll ~~.!! 4:! ....Iad~_ :!..!!h:::~ . l1~~ !;1Ili:i'G1 . ~8:5~ 0::: 8 e--c c. 4i~g ~ I-_~ ~ . "o~ ~5E"3 ~ -:;:::;..0 ""w~ J"S 8- l!!lIIC.l: :E ~ ~ _ l!! "" 01: e <II E &. Cll"C ~ %:5 ~: c:g S :; 0::: ~~6 '8 ~gl: l- . ~ a -g ~ '" . .~~:3 :- " c . 0 ~~ llie.!! E ~ OJ] e>:::I.c .. Eo .Q.~e; cr "E ga :::I III m 0 W g"~:: 1; a ~.~ c .!! ;;J III C " co. :5] ~Cll. .. ~ ~ 8- "a:::cx:.!! :s -~. >0.... . ~:E ~ c l:: .!I 0 ~ "H" '" QI 0 0 ::: >- -OZea ~ b 8 0 " ~, ,Ii 0' r ~I[ (1 ~1 " ~ 0 '" 0 [l :^<. ,j \.. t '" $' .. ;; <; d N d I~: '-' , W ~ f-, ? '" , .. M ro ~ M ro ". ~ t r. c,_ '," \" ~ ~ c 0 ~ F f( ~ n. i' 'I[ t~ ~~ ~'. ~ ~ ~{ c <.> , ("-', I'- j' " :: r 1;;, r, . . k , ~' , , , .. ,. ,. ~ ~ ,. t,; , , ~ , " - - - - - "6 J!l ;;; 'E .. ::> {!. .. " " " " " , (. ~, ~' .' " ~ 0 0 '" 0 ~' " ::i <; g N <; I i, [' .~U ro M ~ X .. e" if ~ [ ~ ~ ,:;'. ';- ",' ~, "', D. C " , r ;~ ::> ,. ~ ,. ,. ~ f , "' "' "' "' "' 0 0 0 0 0 " . " N N " N . . .e'~ D.' " g " 0 " 1; ,. ~. r- '\ .. ~ ~ 0 '" 0 r V f; r 0 (OJ <; <; N d " t. ~J; <.> ~ M 0 0 M 0 if !L \~ m ~ ~ J i ~; " J!l ~ ~: " t ,~' It~ , , 'E \; ~ ~. , l, " D. ~ t ~, ~: ~ a ~. h;; k ,. ,. ~ ,. ,. "" ~,i ~ ;,:;; Ai .. . '#. "' "' "' "' . " e ,- ,- !'I r W " , c , " . ~ ~ M 0 M ., " " , a M ~ M , J , I,: ~ ~ ~ . , ~ 0 . 0 , , , , u c , , , " e . , t " ~ , ~ , , ~ , ~ . , r: , , . D. i , c ~ k'; l<. ~ , . tl< !l 1, < ~ a. ~ ~ . N " N " N " N ~I~ ~ N N N N N " ~ ~ ,~ 'of " - fif ~;.' r i:' ;;: "7 ~ K ! , ~ ^" , ~ i ~~ to. h; ~- c ~: ~ 0 , <.> I ,.... , " I,;' ..... . ;,~: b ~. ~ ~ ~ ~ ~ ~ 0: M N M . :2 . 0 " . '0 ::> 0 8 0 0 0 'I " 0 0 0 0 g d .,; d . 0 ~ 0 'E .g ~ N, ~ N r " D. oi - ~ ~ ~ ~ ~ " m ,~ U .. .. " c . E 0 0 . -" ~~ . ,.~ e ~" rn '5 u E -g " . ~ . , 0 0 W Q il c 0 ~ 0 jj J!l a > . g . 5 ~ ~ I " u ~ " , . ~ Ii E ~ E c " 0 ~ , u: w " '" ....NM..,.IO(CJr--G:lOl~::~~~~ . .. {!. " . . ~ 's cr W " . 8 m ;; o c o " o ~ 10 S .." c o o '0 ~ U ,. S ~ ~ . o .0 h ~~ ~ :3 ~ .~ rn;; :Sa ~ 5:; ai "3 E g ~ ~~g~g .s ~g~ ~'e t: :5.~ ~ E 0. ai . ~ ~ ~ .!!L~L~ .!L~ 5~g."E@-;~5 ::"C~fDECIlO cod) 0..0.- 13 '- ~ ~:S'S B ~ ~.~ Q.c~C":Jd)CE g.8ti~~~8~ fD ~ 8:5 ~ 8.Q) d) fD..... ....-00.....:5.c: :5 0)'- 0 CIl ;;:l ,g3~~8~m 0._16 co.!! ~ c.. E ~'~o:!;;;ocE; ~;ai.s~8ti ~.Qfj.su:So8 ~ ~ Cl c.~ Cl=;; 'E ro'~ ~ e.~ d):J a::"3~Q)o.aalt) iii.f:!:o:: o,..!!!:;::; fDQ) EBsQ):sscB 't5 III E ~:S E ~ 0. d)'~~t)'3=~5~ ~.2"tJ d)"tJ "0 >0"0 ~.~~'[~~~~ Ql 0. ,-'0 So. 0. m 0. E.!! Sl.f:! E E ~~8aii:aa~8 II U II II II U II ~&:5: g~g :~>-~ U50 ~ ~i; ~~~ .! 0.. <I') U 1;l c :J.Q8-[ ~ <( Z~"Eo. ~ ~~::l Q: ~ . Q M . a o D. ~~ g- &.~ '" 'S " . c'" . ~ 8888888888888888 ~o~ci~cici~cici?~~ci~~ci~ ~.~ ~ . . B. ~. ~~ !~ gs ~. .ES Eli ~p '< . ~ . ~ '~ t; ~ o..~ !i,g . g~ '" ~ MMMM~~MM~~~~~MM~ ~ ...:- H E_ .~ ~,gSi "S,~~ =; e' C. =~MM~~M~MMM"MMM"M "" ; o o ~ C ~~~ ;;; ~!o .0 .. o ""~"""MMMMW~"~~ - ~.. :1j:S .0 .0 .. S . ~ ~ .Eo -. - cc ~ o l.:!~ o' '0 " "MM.."MMM""....M"~~ ~~ ~ ~1l<"i ! E " .... g ~ici ~M~MM....M"MM~~~MMM H~ '0 ~ " l.",f! '" '!- . . ~...MM...M"MMM~~~~MM . u '" . . Ii o o .gi; :. .0 ~MM~~........M........M...~~....~ , > ~ H- ~! ~..i "g~~ ]';:1;; " ~ 8 ~.." ~~~ ~ ,; ~ ~ . .. 8w "'~n o_! ~ ~. :lc. ~ " 0 i~~ ~5'l:", < ~ I. ~ ~.~ tJ .!!j -NM~"''''...''''<II~;::t!~;!:~ ~ ~ N ~ ~ " ~ ~ ~ . c' ili:~ l . . ~ . Ji ~ . ~ ~ ~ ~ % E w " ,;. - :J 8 J tl i .. . go . E e2 ~8 ~~ gg ,,~ .i- ;i!'l ~ ~~ t d ;11 il ]; lie i l!~ f~ ~~ ~ ii ~ ~ R;; e B"E ~ 8- . GJfll €-:i;-:, li'g '# o:(.!!q: 8."5 s 5~5 q c: S c:::;; :!:; . ~ E.8 &1 &4> ~.5 x.{l!! e f <>-"E ~ 0&1 ~~~8~ ~.;~ =.iij~ l!!%g,iillio ~ ir--.f;] E~ la=-g R-~g! .~ti: .!!N:;>:Jl::!-i~ e~-"'-'" 8.:1 :! e~~55a1a1 ':i ~>!'5l1l1~l3E:ii p-1:".- - n n l!! III :E~~~~ogog~~ 15 ~'H~~~U~O ~ 12:.2~g,g,a;~5~ ~~la I~P];];IJIJ~~~ ~!~ gli.s i i i ~~ ~4l ~ ~~ 8. ~1:-~.9.9:g~.,g G l!! . "'-a:l i~i~~ii~:3 3'O~:-~~Jj I~i.<:; ~~gg'[[~ 8<'{:!~~ '21"~ ~~~~~ ~ "" : ~ ~~"2 Ie , E E E := c: c: 5 J:l S .... "3 'It :;::::J::::J::::J~~ >.oOE+> ~l~ e e e e Bill! ~ ~ ~." ~l ~ ~ ~ ~ .. .. i1 c: ~{g ~ ; ~ljJL!!~~~ 8~ ~~ 8.~ I:l~ HH""~ 8... h <Ilf!oooo&.&.c:~4>~.5i5 ...<,lIloooo.s;s; ot-~t-t-3: .... n _ _ II. II II- e::~~~~~ ~~:;;5e !~iiiiE:i ii~~~! ~~~~~!:! ~e:"iio ~ II) 1'''0 '" ~ 't 1Il!l.. 0.0 t~ i ~~~ !it ~i=~~ 5 ;3.i ~ o ~g , . ~.E..8 ~5~ ,; ~. ." .!! ~ 5_ . i~j 1ii~ ~ Slii~ ~ ~8. ~oiij -;:;l! :!!0'S o a."., .:..lij !!5.. On ~ ~i ~:gl3 ~ ~:i .8~~ ! ~~ lii~1! 1~~ i~~ o 8.~ ~~i i!! .S %~li B"fi... .8Z~ ~-- ~j~ ~i-~ ~~~ ..~ ~~~ '" ~o .- ~~. . . ~~~ ~~~ ~ :;~ .!!-cil <00 .00 ~~~ ~ii '0" i!e~ -;:;oc: ~lj ..8~8. i:giij ~~~ ij!~ ~~1! '6.oi! il~; .!"5s 0"" ... 3];..8 .~~..!lI. .~~ ~ t'6 Eu:.s H. ~o~ .- ~ t ':5~ i~~~ e8.#€ Cl.,,~~ .. c go;i!'O ." ~. 8~ ~~ 'O~E&. i:;'i.a &.'ii'"2;.!1 ~~ ~. ~.. ::J.C: ~~: ~ . c:{ii;"" ~~~Si ..0.Ei!!:f t:~~~g -i~:;!l '.l.~ ~:8!S~ o ~g~"Iii ~ . ~. i :S'gllj ~il~~a i~i!~t! ~ 11 ~a! :::~~;~ H~H -ciii'"S! lii...-5,: E ~ l3 ::J OJ 0 j';:'; F ~ 1!~';~1l -.c:__C: ~~~~B .. g-o c:'.. ~~itl? a.,g~.c:~o{:! ~!! ti ~ ~... ~ ~~~;gi'jf ~ 'E ~., -c itS;; 0 ~.8~~l!!g ~ ~~~g~ti .c: 1!l.~ ~~ll.;:l ~ .ei.....~~ .3_" 8.",,55~N c: -c .. ~ .. ~ l! ~iti!f ~~~lfl~ -g;~3,r;a. KH~~~ ~ 0; c8, h Ox .g.c: H~~~~ "5*~;~ i-gGll1iJl ~~ ~ ~ ~ I 8:S!R"=~"" ~ :!! e.s! = ~ 1:'"l!!g.,:! ::J~<Il05~ g~~~~.8 .8i.;~i~ Hi'i~ .s8~,!E8 !!..:gtiE= ::J5 "'o.!! . .280 .;Ff ~c3~g'~~ ~~n~i ~.sE;~~ ~~~~,~ 4>Q.&Ei~ .c:., '" '3 t.! ~~~.~~i' F,"i=;~5 ii~.fi~ ll......a.::J .c:~~;~~ j:1-'~: .~H~f' ~~85.. ;;g""''' ~~~ ~8.-! ~0~~!!8. to~;'il:N 1l~.EC~o .!I '0; 8.... . 8~ c:S.!! ~ lO" .2 ...g,eA ~:g."2 e E c 8~~i~~ [ . ~ . .~ . ;; ~ I o . ] - . ;- I .. ~ ~ j [ ~ .ri.; "0 ~! 8= ~~ ~o ~~ .~ .0 . . :SE' . ~ g,~ ;,2 ~'" .. [~ ~. .- 00 ~! .0 ~~ .. o. ~5 ~~ ..:1i ~a. ~ H ~ -=: l "5 ~ E'-c e ~"'5l do 8.~ ~ oa j ll.s !ii ~o ~ ~~ ~ ~" . !!l! ~ ~~ ~: ~.:! ~l!l. !~ [a .95 "Iii~ ~.,. ~~ ..ug.... ~ W~~ ~ ~ g'~ t '0 g,;;~-g~ ~e:::!s:u of> . ~ , j . . o :1 . o ~.. z~ .- -. .. S; .0 ~> [j ~~ o. <. ~~ ". is s.g- ~~ o' ~f;:f '. Xg ~ " <g .. s. ~.~ ~e H .. i~ ,_0 ~8 E. w~ ~i 8. BB .1:.... .~ .. ~~ I~ .~ la ~~ ;;< ~1 .0 .0 'i j, ~, .. o~ lJ! 0< H g~ p -. ;;. ~! .. .~ o~ '0 o. <~ E-" .:!~ at 0"" ~:~ !~~ 8o~ "ll" .8...~ .", 1l~;; ~1i8. Zl~g, ~". .'l! 2:fl., ~2:5 :I.g, ~." ~!i H~ . . o ~ f ~ . " i~ e- "0 &" ~ .! 0" . " . OregonOepartmenlofAdmlnlstrallveSel'vicl!$ Project CostinllWortsheet OVERHEAD Ovsr11eadCosl:s PoIt1rnyEnlelprlsCityofAshllll>d201G--2011$treel.wShop There are many different ways organizations allocate overhead Internally (e.g., Percent of total costs, dollar figure sum, as a percent of direct labor, etc). In the space provided below, Indicate how your organization allocates overhead to this particular contract, what Items go Into your overhead, and what that overhead amount is (whether as a percent or exact amount) IFILL IN ONLY ONE OF THE THREE METHODS DETAILED BELOWI Percent of Total Cost Method: FOl'everydollar,pentprcduclnllelirlell'foduct,OI'p.ovidlngaselVlce,ecertainpereentagecrlhetdolllUis requiredforoverhud. Tccalculalelheoverheadpercenlage,iti.bu\to hanfinandelfe<:o,ds10 ryoor ofganllatiM thaI go baok a year or mc,... Addlogetherlhee~penditureslhatmak"uplh"overh"adcosl(...e worksh..etbelow). No'll add Ihis figure to lhe Raw malerials, Direct labor and DeJivelY for a total cosl. Divide !he ~\lUre for overhead bylhe ~gure for total costs. The result is a percent lhatreprneno overhead as a percent.-.ge ofllle total cost If ~Randal records are !lol avd..ble edmate Ihe overhead erpenses as besl you caR,estimateo!hercostsasbestVO<Jo;arl,a"dlJl;ethesametormulalogetaperCenlage 1. Enter Overhead as a Percent of Total Costs 20,00% OR 2. Enter Allocated Overhead as a Dollar-Figure Sum Dollar-Figure Sum Method: YOUC8R entel'lIledo!3ramauntVO<Jueanocalinglooverhead in the bcx if you arecDR~dentlllatyoucan elloceleoverfleadilemslolllisparticularproject. You caR use the Worksheel n a tool (iln..eded) toldenti urcosta. OR 3. Overhead as a Percent of Total Direct Labor Hours Percent of Total Direct labor Method: To identify av..rhud coso, you need the fin/lflclal re<:ords for your organlzationor d",1 sionfarthepestyear.lnpulallthe cosls olthe entire antity as detailed below. LWle Items which are not detailed below should be Input into the cells marked "olher": pleanlndude a descripOOR. What yau ara lryinllla determine is a percentage, therel ore,doR01llras.suptha elpen5eslarlnllalianortacardormlathecurrentyellrbudgel.Ne.t,iopotintathacelbel<Mthetolallirec:l labor hours paid aul by y.... entir..orllarizatiOl'1 for Ih.. same perlOd. These tigures.hOlJd be f<Uldon lheyeal end payroll report Do not include h<nn which can bfI c1alllifi~ illI management or admlnlltrallve coso. (Indudinlllh..sa COSlllRta th.. direct labor h;~~:: ~:o~~~~s~; :~:~:::'ln~~:~~~~e~r:~o';::~:~s";o~~:a:u~~..~~i;::;~m COIl by dvllfing the lobI T<NlNlnualDirectLabOl"Hous lnpulTotalh"cmWorhheelonElelow Overhead peflabor hour Trmarequlr~tocompleleCOllb"act '" Total Assigned Ov.rhead I WORK AREA: Use the area below to show how you alTlved at the final 'figure that you show as your total Overhead Worksheet Total Annual 0 erallons INOlRECTCOST$ ORGANIZATION DEPARTMENTAl. Managem..ntSalarles Man&gsment Payroll Tax Expense Manageml8l1tMe<:ical11lS\lllll\CG Manag.m"RtPenslon Plan Exp........ Sal~&AdmlnlstrativeSalarlas Sal~&AdmlnistratlvePayroIlTaKExpen'a SaI~&AdministrBliv.Madlcallll5lnlnca Sales&AdminislrallvePenslanP\anExpetllla OInceRanl Adverllslnlil and Public Educatio!l BaclqjroundChe<:ks&Urlnalysis Proreulonal&AccountingIAud~Fe..a Trainlnll&WOl"kerSafety ,~~ Telepllone Utillties PropartyTaxesll..lcensasIF...... Duea&5ubsc:rlptions D..pre<:letlOl'1_officebullclng Depre<:latlOCHlffi<:aequlpmenl R..palra&Mainlenan<:eo<>1fica Cl..alllngllndMaintenance Offio. Equlpm..nt R.nlal OftlceSupplles Pastage & Freight ..... MiacellanaotJ!IExpetllle BadDabb other:" Othef:" other." other." TOTAL INDIRECT COSTS CPlFJolorfromBlS{Melr1kbolow) ,- ,- "'..I_b""""_~,,,,,_ ,~, u. DASFonnl12J Revlslor11G.03 Page 5 Overheed Compu\3tiOl'1 Sheet . Delivery & Reserve Pathway Enterprises, Inc, City of Ashland 2010-2011 Street and Shop This category covers any costs associated with delivering your product or service to the buyer, A service contract, for example, will likely include the costs associated with getting the Individuals who wili perform the service to the place where the service will be performed, Gas, 011, vehicle maintenance and repair are all part of Delivery costs, Most often these costs can be recovered by charging a certain amount per mile, The State of Oregon reimburses 36 cents per mile for Its employees who use their own vehicles on State business, That's not to say your costs may be less or more, The labor required (the driver and the workers if they are on the clock), should be captured in Direct Labor, If your costs are greater than the state allowed cost, please provide a detailed schedule on how you arrived at your cost per mile, Oregon Department of Administrative Services Project Costing Worksheet Services Contract 1 2 3 4 Miles Per Rate Per Dally Services per Annual Dellverv Description Service Mile Cost Year Trans Cost caravan . $ - $ - $ - $ - $ - $ - $ - $ - .$ - $ - Margin The law allows a "margin held in reserve" This is usually added as a percentage after all other costs have been calculated, The margin % can vary depending on the product or service being offered and organizational, contractual and market variables specific to the project. Some research will likely be required to come up with a percentage that not only allows for inventory and equipment replacement, but is in alignment with industry standards and fair market value, Any percentage higher than six percent (6%) will have to be justified to DAS, Enter as a % of "Total Before Margin" 6,0%1 DAS Form #12 J Revision 10-03 Page 6 Trans-Delivery and Margin Sheet . . " Ashland The Grove 2009-201 0 Costing Workbook For Janitorial & Grounds Maintenance Contracts Under the Qualified Rehabilitation Facilities Program -'=" '.... '':''''- '. : .I. ." ": .. ., . , . ~" : ........... ..... ........ Oregon State Department of Administrative Services Procurement, Fleet, and Surplus Services 1225 Feny Street SE, U140 Salem, Oregon 97301 (503) 378-4642 . , SUMMARY OF ANNUAL COSTS Oregon Department of Administrative Services Project Costing Worksheet The summary sheet is linked to the other sheets in this workbook. Any area shaded in light green is either a formula or linked to another work sheet. The only manual input to this sheet will be to input the QRF nama. The costs IiIre to be divided into five categories: Raw Materials. labor, Overhead, Delivery and Reserve Costs. Raw materials consist of supplies, small equipment & tools, and large or special equipment. Each category is detailed on the following sheets. Labor costs is direct labor used to produce or service the contract Overhead costs is a line item charge which is computed on the overhead sheet. Transportation or delivery and reserve computations are also completed on the following sheets. All these costs will vary depending upon your organization and the specifications for the project. Each sheet will have an example calculation and further instructions for completion. QRF Name pathwa Enter rises, Inc. Project Cit of Ashland The Grove 2010-2011 Executive Director Signature: Raw Materials Per Time Use - Supplies Equipment, Tools & Subcontracting (from supplies worksheet) (from small equipment worksheet) '$ $~ Subtotal 1 ; $ 233.29: 486.17 719.46' Labor Direct Labor !I$ 7,059.98:1 (from labor daily worksheet) Overhead See Overhead Worksheet 1'$ 2,102.55"1 Delivery Transportation 1$ (from Trans & Reserve worksheet) Total Before Marglnl'$ 9,881.99'1 Reserve Margin Held in Reserve 1$ 630.77 I 10,512:75'1 876.06' (from Trans & Reserve worksheet) Total Bid Yearlyl'$ Monthly :$ DAS Form #12 J Revision 10..03 Page 1 I Summary Sheet ~ . RAW MATERIALS Supplies Pathway Enterprises, Inc. City of Ashland The Grove 2010-2011 Raw Materials: This category Is often spelled out in the Request for Offer (RFO). language such as "Items to be provided by Contractor" will usually reflect Supplies or Raw Materials. In the case of a" Service Contract this will likely include not only supplies required to perform the service each month, but also Equipment & Tools. In the case of a commodity contract the Raw Materials will be figured on a Per Item Manufactured basis. Oregon Department of Administrative Services Project Costing Worksheet A custodial contract, for example. may require the following for month - Supplies: Paper products and soap Cleaning chemicals or products Spray bottles Broom and dustpan Floor Wax Scrub brushes or scouring pads Per Use/Per Item Manufactured. Supplies 1 2 ,3 4 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 2E 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Item Unit Units Needed Monthly Annual Price Per Month Cost Cost Pine Q Disinfectant $ 4.80 0,1666 $ "-'O,80~ ,$> 9,60 Cream Cleanser $ 2.91 0.1666 $ ,:"<-'0;4S: ;$~___::,:'~5.82 Glass Cleaner $ 6.29 0.1666 $, \,::"<,~1W5r ~$f,!'~\','~~"> 1 2,57;: He. Du Cleanser $ 4.80 0.1666 $ 'to:aOi f$l!>?'/;',~~'::~: 9:601 24 oz Bottle & tn er $ 2.27 0.1666 $:.!';~ ',0"/;'.0:381 ~$R"~..;,.;',i:;4!54 Ac lic Bowl Mops $ 1,71 0,5000 $;: r{'.ax 0'.a6~ !n~::~;i}:10:26 Scrapper W/blades $ 6.51 0.1El66 ~ $~:,:"/:::::;'<:-'1mSI 1$ri~1~,13:0r: I OZ Pumps $ 2.31 0.1666 '$>>':;',,:::';}":, 0;381 l$lft~>~;;A~62! Paper Filter $ 21 ,10 0.3332 $)<;~:;':J;~~:i,'7f. 031 [$H:.~~;.;;.,.;84:3T Sid Loop end Mo $ 5.65 0,3332 '$!f::~,t~'i:':::;:;:1 ~S8! ;$~'te22:59' 24" Dust mop $ 4.26 0.1666 '$,; """,,: 0:7j,1l f$~t,;;-.::'j a:52 DoodlebuQ BN Pads $ 1 ,18 0.1666 $:i;,:~,<"~:;0.20J !$~'C::,CtS.;2:36 Duster - expandable $ 5,75 0.1666 $i?:;::!;' ':!:$0:961' '$~'fPL1 1\50~ Spot Awav $ 2.74 0.3332 $',,,2,;':'.' ':0:9U [$k,<:{10.96 Cleanin Pads $ 4.70 0.1666 $., ,~,--'" Oqal ;$t'~.,;:,':, ~", 9~'40: Wax Mo $ 6.80 O,1E66 :$l' 61~13! i$WN.~'Sq3~59- $,: '-,II':! !$lli'::!:'~:) 'i'.'C"'" $:' .. " :X:..'f...,B~ !$~~t~:.', " ,$:" ,':;;",:,. ':':JiI [$~:;;:f:~!di';- -"" .. -..... ,. " $., c~:;:::;'::;ti:t ;$t1;.:;';):-,.(:'f:' - . $. ,,' .':)~~ :$rf;;.:~, " ..,'- - $',' , ,"", :;:~j:'; ,$[',,', , - ~$') -,,".'>' l$;'~ ";~';'f $' 1$[" c, $ ,,>\;;';: r$t,,~' - $ "":.' ,,',,0<. f$t'.i,J:; -- $ ,;; :$)),:i; : $, ,. "i"; i$k,~:~;;1',:: - " '$ ,--' ':"""~ir !$~t\!:'t:;::L;;',. $ ,--h__~~'" ! $r;~:~'-~: - "",,-.\":.;-:, ,$, \..~:::.:l![dlfn;';:('"i ,$ "'~',f:~ i$~:<t~'1';:'~:' - $' , Vi"". I$:~::.- - $, "~' f:.'~. i$.'i:'l . - $ "';;;,::J'~ i.$;f"~ J "". - $' "::i'~~': i$:{;"" ", " '$ "~~,~ i$~ ";""'. , Total $ ~19A4'i '$', 233~29; ,,. .. .. "" ,- '" >, 'Afe;~S.i~.gf..ll.Ema.f~ forinY.@_~iie'l:_ _ _ .__.1 Monthly Cost = Monthly cost is computed by mUltiplying the total unit cost by the units needed per month. Annual Cost = Annual cost is computed by monthly cost times 12 months. DAS Form #12 J Revision 10-03 Page 2 Supplies Sheet .- , " D ,"- . " o ~ .9 ~ . 3 l!! c; CT ~ ~ ~ ,g: C;..c c: N i;' Z ~!l! E ::IEe'fi (I) (/) <liC) j ~~.~~ ~ O:wg~'ga. 1-......uE ~ ~tTI ~ ~ ::E ~ ~~ e 3:.9-:s 0 lU < 5-C'lI~..!2 a:: w 0.. u g >- '" " . E ~ .. cr w a ~ :s . !" . . - . . u . 'i: ~ . " '" 0 ~;: ~~ i g .5<.> E- ~ u ~ .~ "n. C ~ :!. . c c o a e o " . ~" . 0 E~ gp= o . t; E c( i= ~ f o . <.> 0 OJ <.> " <IJ ut~lI!U)"" c o jj " u . . c . ~ . ~ ~~~ ~~~ ~5~ &~.s d'S g. "" . . c . ,- . j].5 OJ] E . " E ~~ ~~ ~ -.. li" ~ .~~ I ""'" ti . "e ~ . 5 ~ j ~ ., o U ~ . . " 8 . ,5 ." c o " o ~ . ;; c ]j c .. E g . " u . ;; ~ ~ ~ " " ~ " o . ~ , U .E o '~.gi.E , , . "'"g:a 1:~~ ~.!!!~ . 0'=0"0 ,u;: ;'* G1"'-= c - >- <lI ~8~.o ~g~~ E~i::,g ot::l!1tI E &. cn"CI C . j C o C 0 ~ . a:...'C~ ~ 0 1II CD .!1~:: ~. .....- .c ai~~S e>:J.Q .e-~e~ ::I ell III 0 g-~==;; '" :J ClJ C ;S-g ~cQ o=<CJ!! >,0..... l:: c: Sell lU 0 0 ::: -oz. c " ~ . u e ~ . ~ lOg8~8 <ii_Mcici"-lo ga~?F!?Cf ~ u - . ~> Wlo'tiR~~ o~ .. C " -lii~88~8 .~8~gg~g ~~[CIT~~ *,*'$.?f!.?f!. tiGl8~~~~ . . e" n."' .... ~ocoo gL.~q~!fl:q u~~~~~~ ~ t ,".. :.': r. 50.. ._" ,., i ; , ~!'!~~~ c ?f!.~**,* .2 &~~~g~ . s ,.-,' ~ ~ ~ g. t I' en. ". u lL~ cro o <.> ~~#N~~t!~~~~~(\j~~ .,!-~~~~~ == il.:l .- !'Io . 'E .~ ,,~ 88888 "':dcilrio 000<00 '<tN'<I" N "N . utWlolt...... ~ . _ C C 0 E~ ~. '5 :il g -g tZ'~B~ lU ~=fiL.~L. g~~g~ "OL.(!!.c"E .!: 8 x 0 :J ~U:w::i!:m .....N(')..,.IO<Dr--(Om~::~~:!~ . " {!. " . E ~ 3, cr w " <D ro " ~ ;;; o >- . ti 8 . ;; o c o € o '" 1ii :; ~ C o " ~ ~ 13 ,E g ~ ~ ~ " ~ ~:;? 'e- ~ "'- ~ 8 ~ .!!! ~;; ;.2 ~ 5~ai ~ E 6 ~ Ulc5~~ ~~~~~'[. ~ ~~.~,gJ~,~~ 0._ l::- 2: l:: .E~-81fi(llm~.= -... ECUE:;::.o r'll~~'~ii~! '~8iij~~;:-8~ 'I~~~~~~~~ = ~'c ~~ ~2; cO:E~ffiQj~-a~ IDID>--O'cE::: ~l~ ~ ~ : .s ~ 81ii l!!!~.c=firt5=o8 ~~~~E.~~~'E EI"CI l!!'s;. fi e.s;. (ll :::J ~2ao.~:;o.-go ~ (II -::: 0.,_::: Ql ID olE B"S Ql="S C:'~ i::: ti (j) E ~ = E Jg 0. 3::(ll'~~tl';i:~5~ ....,Ql.Q"CI Ql "CI "CI >-"CI ~~= ~ 2 'e- 2 2 .c 2 .,..,~o~o.,~(IIz.~ <II... eo..... o"S 0. 0. e~g-~~g~3g <( ~ 00 w m 0 :E o- n n n n D n n i!~~: g~g CII.l!l>~ u50 ~ :5 :u ~ - 1ii ~ 0."0 C 0 :I ~~jjj.e ;Q~ '., c R ,S!, .! c( -- .2 ':: 2 u ~ li"'i:: 0. 1lI Q1u~ e- . . n. " ~ . c M . a o n. , NM ;;;~ E- &~ ~.~ co: . i "~ 2w ~'> 0"" 5"' l:i O~ . . - I! 888 ~o~f.~ liSt' ~ r: L 0888 0000 8888888 dcidcidci~ ~ i ~~ ~. ~. o. .s~ .. - . su E _ ." ." ~l . E < ~ o . . ~ o 3' ~ F;: ii,~:~ o m 1.\-', lioq~<t II ~ ':;; ,: p:!.~ ~ ~~~lfj .............. .. " ........................... ~ Z;>: .- E" ol :sgs~k:\) <I", -I. ,', ',' -, .-'t'f<(~l' ",,-.I '" .. ,~.'. ~ .... ~ E iI !;., lfi ^~ 2I..!! S t\ (., =..~......... . ;( .,' ~ ~]. !i.: ':; '.' _ " ............ ...~...... ~ ~ ~ ~>; " oJ.~, f; " "~:,, ~ i r~ ), .;;; ~ ~{ ~ 5~;; _.,' _ H o .......................................~ . ~! -. .. ~~ 5 .~ 5~g o. ~ ~:r\;:, 1o?~~0 '; ........................................... :~ ~ 'Q...,.; E. :!! E o 1:.::: ~ . -, ,', ~~ Eic . .. '" ;. ........................... !d i!s'" 3lS ....e., ~3. Ul~ l.l ..........................,......... . u " ~ <i ~ .g~ ~ ., "., ...................................... :i .~ ~ ~1l . , . ~!!~ ,_n '. - " . _ 8 ~a~"" ~3:~ ., " ~.. 5 '210!= ~ ;:'~ ';; a~ ~ ~ .-N..,....l()"'I'-<o"'e::~~:!:~ " . ~ " .. ~ . ~ ., , ~o~ ~~J: ~ . ~ . , . ~ ~ .. ~ . j ~ ~ E w .. ~ ti ~ B . ~ 8 ~ ~ ~ .t:. ;g 0 I~j . ~ 2" . E ~~ J!i! ]2 ~~ .i:- ~!ij ~ ~~ ~ E~ "' H > u 0 n ~~ ~ . > .~ Sg ~ ~ ~ E 8.5 E . :s~ ~8 . Cllll .2.;;;~ fi ;j. ~.!!-5 8. '5 8 -6 ii g ~! ~ ~j~ =>& ~..& ~t~ ~ ~ 0.<: 2' g ~ l!!OI~15E 5E:;; ii!& U'l U,., . ~.!:,s l!:'lij lC! e.2 dI '" ~O ~ ~....~ ~E~"""2 ~S dI C - '" [';~~:5@~ti~ l5e~.~_~ 8.~~~ ~~"".2.9 III III 8 CI s:;&~~~~:a'E~ (lS:;IlIc:c:ll.!!E__ .sA'~'e.e.~~~~ l5 'l~~< ~ ~~~~o ~ l'I'~.21:t [[:;;:;; g~ ffi~ '- 1'~~~~~5a.E15.., ~.~ ~ :r..-........d1d1+>g 8..e.-- Igr~ E]ii s J!!:@]! 'ii", ~ -0'<:- 8. '~I;- e .s .s .9 i.L~ -5 ~ _ dI ~ :l 1-0 ~ &.g.g.g '" '" 'E:Z;"'. 1:: ,., E' ..&..<::....,.,uu....EM~..Q'" 1"3'..<:: 2' g g> g' 55'" 8 r{:! all;' jl'H:ii'ii'~;;;;~ : ~ ~ h ., j> '" "';e.g. c: c: ~..Q]I ~ "3 ~ :ii "3"3::J"3EE >.(l(lE", c]l E E E E-=-=tfe15 !2.--"5 .1211 >. >. >. 8 8 g iil '" l8 E e!; .c.c..Q.... c: c: - -.;I >. e ~ilialal1!1!:s:s 8~ ~~ 8.5 '-''0 ~ 'S ::J ::J c: c: '" 8 ' ~ ~Ii fE'~~:S:S;S ","-;:li!: !:mu8S8EEg~~~~~ . ....... ..... ~i~~i::d ~j~j~ ~~d!2:2e::;; !.:I....:I~ 'f:.g.g.g ~ ~ t! .g E ~"ii 0: .0 (/I (/IlIl III ~ ';i lIl,=" (; '" ti tE:;j B~ ~~~~ 5 21 ~~ ,; ~. >5 .!! a.li. fill;-a j.g8 -H ~p ~ -, --a8. E"' ,'. n" h~ o a> ~~: .!!!".. .'= :: g'1 !I'D; .~, .~~ ! ~t }:~~ ,~ f~ ~E~ €'~ ~ ~ :J o 8.-g :;1!~ '.2 ~ 0I.!!! 1}~ ~ ull... .8~~ ~d ~~~ uU:.. li1:-" .. ~ .2"8- H~ s"- "J! -~o ,- ~~dJ ~f! il~- "x.:g .a"'j ~~::J 8.8.g, ,. . e:g'" a 8 ~ jl..~ ~Rs ._'~ i ~ ~> .8g'8. '., ~ii ~~~ ~:g~ n 1;. !:!;s 'Ei"''g ~~: !o. z~~ .t: 012 .!!c,- z~i t;..._ ~ g~ =ti ~ r!.6 n~ ~~~ . ~i::il "[~;~ ....:8ii g>;'g'E . 0 ~~ 8~ ~ ~1iE8. ..:2,-~ &.~~.. .F. <>'u 8..:: &~: ~ . < "ii;;'" ~;lii.Ei ~ g':l~ CI Oz,a.i!: ~~ e~-g i~::si ~.lZ ~ ; * !.8.e-,g>8 8.[g~:S E ",,'E CI 8~~-;;;~ =:;;~-mi ~"5.Ec: !;J-g11~ l;1ii '":l 8. ..... 010_ ~~~;A' ~ ~.2 'ii 11 ~ilj ;~i Ii... fi" E t! S 1J,~ 8 i fi': . ~ 1!~s~.8 -.t:"E-"C: ~.!!I..'El'l 1!i:i.C:dJ. ~g~Si .s liI 8 ~.t: 10 .!Ioout;. i~:~.~~ :iii~i~t 1) l!!~~"! t;.8~'5 ~g g~; e~-5 !'"'-C1Lr..'" .e; ~ ~ g.~ 8.~5.s=E:; ~.s ~ ~: l! !~I!~..~ :!~dJ.ig j!: dJ t; 1i Q, e ',S>l;;2 ~Q, ll.!lri-s"<f! [!J!l~illl a~8i~~ 'l:i~<ic:'O.5 .:!.. 'g g:l t: '"-s t;};.!! ~ i"liij..'ECI g-~"~ g,g. 8 ii~~:; 8- 3I.tl.'-E'" .sl!!g-.Emli' ~.. ~ -g ~ ~ ::J.a ~ 8;.~ ~!!!lf 1;ls dJ llii.;.9';~ 'BF~ ~81l~~~ r;1!~<.l~~ ~8.&:-~W ~ O.!l! g'~ li Jh::!ll~il:;:- ~.l!I~".t:u :>.....x-"'.. ~.2i;~~ s~z~;".~ Cli:i.cf.lZ...... ~1! a ;'~.e .!I;..s~~ 2n~21!=B "':!!!o.!.o;;-5 .~~~t~[ ~ ~ ~ !"~ t;-.... liO ~-;;t :;;F~ :; B g..~ 8 l? Ji~85~~ .. ~1ll;l:i j ~..~~it ~:; 1! ~ 8. .8i~".t:N .._:.=~'Oa i~~.!!~~ !!l ~~ ~ ~ ~ rE s f..=:::.. o~~i~~ j!i. . I 3~ ~i g! . . .st "" &[ Is ~" 'ii~ [~ ii 'l ,. ~~ t~ -C[ f[ , ~ ." CI ~ os 1! !i d. 8.; e a ~ S .~ 11_ ~_ ., -< ~ 8.ti ~ ., ~ ~~ 1Oli' iE ~l s.>< g,,; <l,~ 1iI"' i~< g..8 1; &!.2 0 t 1i; g.~~ "i:a~~ ~i~~~ o.a ! ~ , ~ " ~ o [ i , ~ .;'l5 ~~ .- . . .~ .- i~ >. et; ~8 .~ [~ ~~ "" ~s !~ ~N . . 'N ... .~ "0 g v. ;~ :511 ];. - , Be ~:i !~ :58- ~o '0 Ed ,g ~if .- 3~ fl8 ii .= 6~ {~ eE .~ li &i' ~il , > o' c> "" " H '" .. , . ~~ o' u. .. i~ ..:=." .. EO -. ." ~! .. .. a .. ". ~! E":; :If 8.e' a- E ~. -::g..-:.. ~dE '1'. 80<:1 g~a '"' ~i~ 'Dli-~ ~~ g. is.. .. . ~,~ "iii.!.!.!!! 102::5 _i: ~ ~R- ~.]; ... ~:l8 . 1 f ~ . . j il I E .. ! ~ . i ~ [ ~ c o . E . ~ " . " ! ,. , I , ~~ ~- "I ~~ .. . OVERHEAD OVerheadClnls Palhway EnterprTe City cfAthland Th8 Grove2010-2011 There are many dIfferent ways organizations allocate overhead Internally (e.g., Percent of total costs, dollar figure sum, as a percent of dIrect labor, etc). In the space provided below, IndIcate how your organIzatIon allocates overhead to this particular contract, what Items go Into your overhead, and what that overhead amount Is (whether as a percent or exact amount) ONgon Department of Admnlstrwtlv. Servlen ProJec;t Costing WorbhHt IFILL IN ONLY ONE OF THE THREE METHODS DETAILED BELOW! Percent of Total Cost Method: For everydol18r"penlp'od~cjng a nnalproduct, or p'ovidin911.ervTce,. cerlaln percentage of1hatdollar I. required for overhead. To calculale the ovemeed pe,centage, it is best to have ~nancl.1 records 'D. ynu, organiza!lonlllll1gob.ck.~...-ormore.AddIDg.lhe'th.e.pendUl!'lh.lrnak.up1heoverne.dCO!lI{see w&r..heel below). Now ndd!his figure 1,,!tIe R_ malerla/a, Direcllab... and Deliveryf... a Illtal cost Q;vide lhe figure for overhead by lhe ~gure f"rtctal CD$\$. The result is a percentlhatrepre8ents overhead as a percentageoflhel"talCllII.lffinanclnl,eCDrds.rnnctav.illbleestiIJ'l8lnlheoverheade.pensesasbeslYOU can. eWtnale olllercoslS asb...! you can, and l/$etlle same fllflllUla to gel a percenl3ge. 1_ Enter Overhead as a Percent of Total Costs 20,""' OR 2. Enter Allocated Overhead as I DoUar-Flgure Sum OR Dollar-Figure Sum Method: Youoenentel'lhedDhr.mountYOUlrelllooatingtoovefheadinlheboxlfyou.reoonftdentlhllyoucan dOCIle ""emend Ilems I"this particullr project. You can \1M Ihe WOl'kIhm 88 a tool (if needed) toldenti oostl. 3. Overhead as II Percent of Totlll Direct LlIbor Hours Percent of Total Direct labor Method: ToldentJJyOVefhadcosl:s,yooneedlhe financial rKOl'lbfcryourorganlnllon or c1vtslon lor lh epntye81.tnpulanlhe 008tS oflh.. en!lrn entity as deiajl&d balow. Line Items which ara not detailed below 8hould b. Inplll int" lhe cens markad .other";pleaulncludeadllscriptioo.WI1.t\">uaretrylnlltodelerminels.p....e<:fllage,lherel...a, do rotgross up lhe ....pens...,... Inftadon... to conlorm I" !tIa o...trent year !>udget. Ned. input into Ihe od bel_lha totaIlll'edleborlrour spaid OUlbyyOlJ" entirecrgari2ation forlhenmeperioll_Thesefigure8shouldba fDUnd on lheye!r end pII')'I"DIl report. Do not include hmn which can ba classified a. managem.n! or administrative c0113. ~ncludlng lhese CIIIIIs Into1l1e d~ectlabOl' :~~~= :!:~::~; ~C;U~o::.~~~:=:~.::::::~ 7;r~:~~e~ine~~m Ollllt by<Mfinlllhe total TctalAnnU11 Direct L.bcrHcu," Time lequired tD c:omplete contrlct InplllTCItlIltromWCIlksh....looBelow Overhe8dpeflabcrhour '" TotaIA!SignedOv"i1>Il~d WORK AREA: Worksheet Total AnnulIl 0 erat/ons INDIRECT COSTS ORGANIZATION DEPARTMENTAL Man8g"mentS81.rl... Man8g"mentPeyrllllTuExpIlmll MlnegementMedlcaflnsunwtce Man811emenlPenalcn Plan E:i:pense S81"" & Admlnistrnllve S81.rle. SaI",,&Adminlatrllllve PaytcII TuExpeMa Sale11&AdmlnlstrlliveMedcatlnsurance Sale8 & Admlnlstrllllve Pen81"n Plan Erpenu Office Rent Ad'\Iertislng and Public EduceUcn Background Chech & Urina/ytlll Prole..lonal& AoccunUngIAudilFeell Training & WDrker Safety Insurance T....... Ubllti... Property TaxeslLloensewees euel&Subsaipllon. DepfedaliCfHllficebuftling OeprednllllfHlf!lceaq.rlpmenl RepllTrs&Malnmnanoe_offlce ClefmlngllndMalnlenance OffioeE.ppmentRISn!aI 0fII0e Supp~1!S P"smge&f'relght Rehab MisceUanecusExpeMe BadDebl:s Other:' Other:' Other:' Other.' TOTAL INDIRECT COSTS Use the area below to show how you arrived at the final figure that you show as your total Overhead CPI_lramBLS~"'tw:towl _l_"........_....,.,_ Tolal ,- ,- 1.$ DASFoon'12J Revilioo10-03 P1ll'85 Ovnrl>Pd Computellon Sheet ,. 'I', " . Delivery & Reserve Pathway Enterprises, Inc, City of Ashland The Grove 2010-2011 This category covers any costs associated with delivering your product or service to the buyer. A service contract, for example, will likely include the costs associated with getting the individuals who will perform the service to the place where the service will be performed, Gas, oil, vehicle maintenance and repair are all part of Delivery costs, Most often these costs can be recovered by charging a certain amount per mile, The State of Oregon reimburses 36 cents per mile for its employees who use their own vehicles on State business, That's not to say your costs may be less or more, The labor required (the driver and the workers if they are on the ciock), should be captured in Direct Labor. If your costs are greater than the state ail owed cost, piease provide a detailed schedule on how you arrived at your cost per mile, Oregon Department of Administrative Services Project Costing Worksheet Services Contract 1 2 3 4 Miles Per Rate Per Daily Services per Annual Delivery Description Service Mile Cost Year Trans Cost caravan :$ - '$ -,,~"., $ - i$ , c, $ - $ / " $ - '$, - '$ - $ - Margin The law allows a "margin held in reserve" This is usually added as a percentage after all other costs have been calculated, The margin % can vary depending on the product or service being offered and organizationai, contractual and market variabies specific to the project. Some research will likely be , required to come up with a percentage that not only allows for inventory and equipment replacement, but is in alignment with industry standards and fair market value, Any percentage higher than six percent (6%) will have to be justified to DAS, Enter as a % of "Total Before Margin" 60%1 DAS Form #12 J Revision 10-03 Page 6 Trans-Delivery and Margin Sheet i . CiTY RECORDER CITY OF ASHLAND 20 E MAIN ST. ASHLAND, OR 97520 (541) 488-5300 Page 1/1 ~., :,t: 1.~::: -DATE:-;,,;;" .~~li .. ;:,;-~pb~NOMBEFf d::l 7/22/2010 09690 VENDOR: 005727 PATHWAY ENTERPRISES INC 655 WASHINGTON STREET ASHLAND, OR 97520 SHIP TO: Ashland Building Maintenance (541) 488-5358 90 N MOUNTAIN AVENUE ASHLAND, OR 97520 FOB Point: Terms: Net Req. Del. Date: Speciallnst: Req. No.: Dept.: Contact: Dale Peters Confirming? No .J;:;:auanm:;,~,: Y":-Onlt;} >:::,~'~ ~'i:" :-~~,:'. .~., '..:'.. ~: ,'.. " . Descriptidn .. 'f>:, '" ~,"". . -:. :';"~'. : .:: nJ"lfP.fiC'Et'-' !, '~"-lI':'_"'.' .' '. "'. Exb_Rrlce~;\" _~:~ THIS IS A REVISED PURCHASE ORDER Janitorial Services - FY 2011 73,560.32 Per attached QRF Costing Workbook for. Janitorial and Grounds Maintenance Processed change order 11/17/2010 2,280.22 Compensation will increase in the amount of $2,280.22 for the current year due to the living wage increase from $12.96 to $13.40 per hour effective June 30, 2010. .. ."~- ~> ".. '- .. . SUBTOTAL 75840.54 BILL TO: Account Payable TAX 0.00 20 EAST MAIN ST FREIGHT 0.00 541-552-2028 TOTAL 75,840.54 ASHLAND, OR 97520 ~bcouni:1Nurjf6i(~!ft f?jzfCP.fOjeci'Numtjer:;t;U~~ t;~:- ~tAOiPunt~~\U:;: ~ X~cC'o;':'unt~~uro&er1;1~ ~l~;:'l;<~roJecet.fume:e~I$! lI1iit~a E 41 0.08.24.00.60235 75 840.54 . .d-;( ~ /.7 ';/,7~.. Author~Slgnature VENDOR COPY . I }fORM #121 !:!;i"i':~~J'::~"rc .7;;)\".-;-:';>":.":"'f'X';"~. .~'."-;::...,f'" "I ~::;:. ~';:',7.~r,,- _;" ': "::-. " .. ""::;-.. ..~'''',-';~-"': -'" i '''''1rI=RMISPIAl'lE 'PR0'eIiU~.EMENTi ;.+.....~,....._.~,_....;",._.c. _,_ _.,~_ '"_\" _~'__'--"';"'''''''''~__~'_'__'''',,"'h_~ ~~ ____.,._...___~. CONTRACT AMENDMENT APPROVAL REQUEST FORM Request for a Change Order CITY Of ASHLAND Description of Contract Amendment resulting from an Intermediate Procurement: Supplier / Contractor: ~ ~~"'&..Vu_ c:.g.. p p.-/ i1"otal amount of contract f ;? r IT amenament: Purchase Order Number: 0 '7' 6 '9 {/ Description: c.;::n -::-7 ") if-.-"d ~o/' tfl-r; tLf' 0~v~-~ ~ attached contract amendment ;"i~.:o;_ ~:'.:y .::.>~. '""':-':.,,-: r;":-r-.':" "r; eontract.'Amendment Original contract amount $ 7";: c; 6 O. '!!::>- . Total amount of Drevious contract amendments -.1.QQ..., % of original contract 3 / % of original contract .:2, :2- g a :;:2..:;2.../ % of original contract $ 7.c;- t;p ~?Y. 5"~ t' p '3.t % of original contra~t , Amount of this contract amendment TOTAL AMOUNT OF CONTRACT Is the total amount of the cumulative amendments less than or equal to 25'1~ of the original contract amount? YES ............... NO' 'If "No', a Special Procurement is required for the amount that exceeds authority. Council approved on (Date) In accordance with OAR 137-047-0800, the amendment is: 1) Within the scope of procurement 2) Necessary to comply with a change in law that affects performance of the contract. 3) Results from renegotiation of the terms and conditions, including the contract price making it advantageous to the contracting agency a) Provided goods and services are the same as in the unamended contract b) The amended contract does not have a total term greater than allowed in the solicitation document YES .....----. NO' 'If "No', a Special Procurement is required for the amount that does not meet these criteria. Council approved on (Date) Project Number ______ - ___ Account Numbe~~ ,:. ~e ~-Y!?-'?~"-!.-3...5',.f;~nt Number . - . . --- -- -- -- ------ Account Number ___ - __' __ - __ - ______ Account Number ___ - __ - __ - __ - ______ 'Expenditure must be charged to the a count numbers for the financials to reflect the actuat expenditures accurataty. Affach ex/Ill pages if needed. Reviewed by: \'(\lAM,r'AC ELL- Department Head / Not Approved Date:) ~ou 10 Date: 11- '1~,;2L)I"O Prepared by: Department: F.a'" \ ',-to<:.~S Comments: Funds appropriated for current fiscal year: €0 NO Comments: -"'/.:l- .? Finance Director ,'- It/, ~ IJ . Date Form #12 - Contract Amendment Approval Request Form -INTERMEDIATE PROCUREMENT, Page 1 of 1, 11/1/2010