Loading...
HomeMy WebLinkAbout2011-172 Contract - Pathway Enterprises Page 1 / 1 CITY OF CITY RECO,R A _ S H LA N D DATE PO NUMBER 20 E MAIN ST. 7/2112011 10330 ASHLAND, OR 97520 (541)488-5300 VENDOR: 005727 SHIP TO: Ashland Building Maintenance PATHWAY ENTERPRISES INC (541)488-5358 655 WASHINGTON STREET 90 N MOUNTAIN AVENUE ASHLAND, OR 97520 ASHLAND, OR 97520 FOB Point: Req.No.: Terms: Net Dept.: Req. Del.Date: contact. Dale Peters Special Inst: Confirming? No Quantity '':Unit - - - "Description '.Unif Prlce Ext:,Price.;" Janitorial Services FY 2012 76,511.58 Contract for Goods and Services Beginning date: July 1, 2011 Completion date: June 30, 2012 Insurance required/On file Approved by City Council July 19, 2011 SUBTOTAL 76 511.58 BILL TO:Account Payable TAX 0.00 20 EAST MAIN ST FREIGHT 0.00 541-552-2028 TOTAL 76,511.58 ASHLAND, OR 97520 Account Number !Project.Number - - Amount' Account Numtier'. ,Project Numberr r ,Amount E 410.08.24.00.60235 E 000251.999 76 511.58 Autho6Zed Signature' VENDOR COPY FORM,#3 C I T Y OF A regUUt f0f &I �'Farcii se Order ASHLAND REQUISITION Date of request: Required date for delivery: Vendor Name Y—z 4a-R /e ;EE Address,City,State,Zip Contact Name&Telephone Number Fax Number SOLICITATION PROCESS ❑ Exempt from Competitive Bidding ❑ Emergency ❑ Written Findings(Form attached) ❑ Invitation to Bid (Copies on file) ❑ Written findings attached ❑ Quote or Proposal attached Dale approved by Council: ❑ Quote or Proposal attached ❑ Small Procurement Cooperative Procurement Less than$5,000 ❑ Request for Proposal (Copies on file) ate of Oregon Note:Total contract amount,including any Dale approved by Council: Contract# 6 e p amendments may not exceed$6,000 ❑ Slate of Washington Intermediate Procurement ❑ Sole source Contract# GOODS&SERVICES ❑ Written Findings(Form attached) ❑ Other government agency contracAPP-11"e-p- $5,000 to$100.000 ❑ Quote or Proposal attached Agency O7�y 9 — I ❑ (3)Written quotes attached Contract# PERSONAL SERVICES ❑ Special Procurement ❑ Intergovernmental Agreement $5,000 to$75,000 ❑ Written Findings(Form attached) Agency ❑ Less than$35,000,by direct appointment ❑ Quote or Proposal attached Contract# ❑ 3 Written proposals attached Dale approved by Council: Dale approved by Council: Description of SERVICES Total Cost ��-C Z`- ��YL cc-C Std//�//L-CL� _.., � � �✓,..i' � .< � ... r� Item # Quantity Unit Description of MATERIALS Unit Price Total Cost TOTAC:COStu"i ❑ Per attached QUOTE Project Number_���?5/ 9`�Account Number___-__-_ •__•______ AccountNumber___•__•__- Account Number -__-__-__- Account Number___-__•__•__•______ 'Expenditure must be charged to the appropriate account numbers for the financials to reflect the actual expenditures accurately. Attach extra pages if needed. By signing this requisition form,l certify that the information provided above meets the City's public contracting requirements,and the documentation can be provided upon request. Employee Signature. Department Head Signature: o�lAr� �- Additional signatures(if applicable): //�� Funds appropriated for current fiscal year: (�S / NO 7 aZ ?d r Finance Director D to Comments: G:FinanceTrocedurelAPTonnslForm#3-Requisition.doc Updated on:61232011 Contract for Janitorial Services FY 2011 - 2012 Q 1 T Y' O F CONTRACTOR: Pathway Enterprises, Inc. ASHLAND CONTACT: Richard Simpson 20 East Main Street Ashland, Oregon 97520 ADDRESS: 655 Washington Street, Ashland, OR 97520 `Telephone: 541/488-6002 Fax: 541/488-5311 TELEPHONE: 541-488-1536 DATE AGREEMENT PREPARED: 06/27/2011 FAX: BEGINNING DATE: July 1, 2011 COMPLETION DATE: June 30, 2012 COMPENSATION: Total annual cost: $76,511.58, Per the Pathway letter dated June 15, 2011 and Costing Workbook for Janitorial & Grounds Maintenance Contracts under the Qualified Rehabilitation Facilities Program QRF attached as Exhibit C. GOODS AND SERVICES TO BE PROVIDED: Janitorial services per the attached Costing Workbook. ADDITIONAL TERMS: NOW THEREFORE, pursuant to AMC 2.50.090 and after consideration of the mutual covenants contained herein the CITY AND CONTRACTOR AGREE as follows: 1. All Costs by Contractor: Contractor shall, provide all goods as specified above and shall at its own risk and expense, perform any work described above and, unless otherwise specified, furnish all labor, equipment and materials required for the proper performance of such work. 2. Qualified Work: Contractor has represented, and by entering into this contract now represents, that any personnel assigned to the work required under this contract are fully qualified to perform the work to which they will be assigned in a skilled and worker-like manner and, if required to be registered, licensed or bonded by the State of Oregon, are so registered, licensed and bonded. Contractor must also maintain a current City business license. 3. Completion Date: Contractor shall provide all goods in accordance with the standards and specifications, no later than the date indicated above and start performing the work under this contract by the beginning date indicated above and complete the work by the completion date indicated above. 4. Compensation: City shall pay Contractor for the specified goods and for any work performed, including costs and expenses, the sum specified above. Payments shall be made within 30 days of the date of the invoice. Should the contract be prematurely terminated, payments will be made for work completed and accepted to date of termination. Compensation under this contract, including all costs and expenses of Contractor, is limited to $25,000.00, unless a separate written contract is entered into by the City. 5. Ownership of Documents: All documents prepared by Contractor pursuant to this contract shall be the property of City. 6. Statutory Requirements: ORS 279B.220, 279B.225, 2798.230, 279B.235, ORS Chapter 244 and ORS 670.600 are made part of this contract. 7. Living Wage Requirements: If contractor is providing,services under this contract and the amount of this contract is$18,890 or more, Contractor is required to comply with chapter 3.12 of the Ashland Municipal Code by paying a living wage, as defined in this chapter, to all employees performing work under this contract and to any subcontractor who performs 50% or more of the work under this contract. Contractor is also required to post the notice attached hereto as Exhibit B predominantly in areas where it will be seen by all employees. 8. Indemnification: Contractor agrees to defend, indemnify and save City, its officers. employees and agents harmless from any and all losses, claims, actions, costs, expenses,judgments, subrogations, or other damages resulting from injury to any person (including injury resulting in death), or damage (including loss or destruction) to property, of whatsoever nature arising out of or incident to the performance of this contract by Contractor(including but not limited to, Contractor's employees, agents, and others designated by Contractor to perform work or services attendant to this contract). Contractor shall not be held responsible for any losses, expenses, claims, subrogations, actions, costs, judgments, or other damages, directly, solely, and proximately caused by the negligence of City. 9. Termination: a. Mutual Consent. This contract may be terminated at any time by mutual consent of both parties. b. City's Convenience. This contract may be terminated at any time by City upon 30 days' notice in writing and delivered by certified mail or in person. C. For Cause. City may terminate or modify this contract, in whole or in part, effective upon delivery of written notice to Contractor, or at such later date as may be established by City under any of the following conditions: i. If City funding from federal, state, county or other sources is not obtained and continued at levels Contract for Janitorial Services, Revised 06/30/2011, Page 1 of 5 sufficient to allow for the purchase of the indicated quantity of services; ii. If federal or state regulations or guidelines are modified, changed, or interpreted in such a way that the services are no longer allowable or appropriate for purchase under this contract or are ' no longer eligible for the funding proposed for payments authorized by this contract; or iii. If any license or certificate required by law or regulation to be held by Contractor to provide the services required by this contract is for any reason denied, revoked, suspended, or not renewed. d. For Default or Breach. i. Either City or Contractor may terminate this contract in the event of a breach of the contract by the other. Prior to such termination the party seeking termination shall give to the other party written notice of the breach and intent to terminate. If the party committing the breach has not entirely cured the breach within 15 days of the date of the notice, or within such other period as the party giving the notice may authorize or require, then the contract may be terminated at any time thereafter by a written notice of termination by the party giving notice. ii. Time is of the essence for Contractor's performance of each and every obligation and duty under this contract. City by written notice to Contractor of default or breach, may at any time terminate the whole or any part of this contract if Contractor fails to provide services called for by this contract within the time specified herein or in any extension thereof. iii. The rights and remedies of City provided in this subsection (d) are not exclusive and are in addition to any other rights and remedies provided by law or under this contract. e. Obligation/Liability of Parties. Termination or modification of this contract pursuant to subsections a, b, or c above shall be without prejudice to any obligations or liabilities of either party already accrued prior to such termination or modification. However, upon receiving a notice of termination (regardless whether such notice is given pursuant to subsections a, b, c or d of this section, Contractor shall immediately cease all activities under this contract, unless expressly directed otherwise by City in the notice of termination. Further, upon termination, Contractor shall deliver to City all contract documents, information, works-in-progress and other property that are or would be deliverables had the contract been completed. City shall pay Contractor for work performed prior to the termination date if such work was performed in accordance with the Contract. 10. Independent Contractor Status: Contractor is an independent Contractor and not an employee of the City. Contractor shall have the complete responsibility for the performance of this contract. 11. Non-discrimination Certification: The undersigned certifies that the undersigned Contractor has not discriminated against minority, women or emerging small businesses enterprises in obtaining any required subcontracts. Contractor further certifies that it shall not discriminate in the award of such subcontracts, if any. The Contractor understands and acknowledges that it may be disqualified from bidding on this contract, including but not limited to City discovery of a misrepresentation or sham regarding a subcontract or that the Bidder has violated any requirement of ORS 279A.110 or the administrative rules implementing the Statute. 12. Asbestos Abatement License: If required under ORS 468A.710, Contractor or Subcontractor shall possess an asbestos abatement license. 13. Assignment and Subcontracts: Contractor shall not assign this contract or subcontract any portion of the work without the written consent of City. Any attempted assignment or subcontract without written consent of City shall be void. Contractor shall be fully responsible for the acts or omissions of any assigns or subcontractors and of all persons employed by them, and the approval by City of any assignment or subcontract shall not create any contractual relation between the assignee or subcontractor and City. 14. Use of Recyclable Products: Contractor shall use recyclable products to the maximum extent economically feasible in the performance of the contract work set forth in this document. 15. Default. The Contractor shall be in default of this agreement if Contractor: commits any material breach or default of any covenant, warranty, certification, or obligation it owes under the Contract; if it loses its QRF status pursuant to the QRF Rules or loses any license, certificate or certification that is required to perform the work or to qualify as a QRF if Contractor has qualified as a QRF for this agreement, institutes an action for relief in bankruptcy or has instituted against it an action for insolvency; makes a general assignment for the benefit of creditors; or ceases doing business on a regular basis of the type identified in its obligations under the Contract; or attempts to assign rights in, or delegate duties under, the Contract. 16. Insurance. Contractor shall at its own expense provide the following insurance: a. Worker's Compensation insurance in compliance with ORS 656.017, which requires subject employers to provide Oregon workers' compensation coverage for all their subject workers b. General Liability insurance with a combined single limit, or the equivalent, of not less than Enter one: $200,000, $500,000, $1,000,000, $2,000,000 or Not Applicable for each occurrence for Bodily Injury and Property Damage. It shall include contractual liability coverage for the indemnity provided under this contract. C. Automobile Liability insurance with a combined single limit, or the equivalent, of not less than Enter one: $200,000, $500,000, $1,000,000, or Not Applicable for each accident for Bodily Injury and Property Damage, including coverage for owned, hired or non-owned vehicles, as applicable. d. Notice of cancellation or change. There shall be no cancellation, material change, reduction of limits or intent not to renew the insurance coverage(s) without 30 days' written notice from the Contractor or its insurers to Contract for Janitorial Services, Revised 06/30/2011, Page 2 of 5 the Csy. e. Additional Insured/Certificates of Insurance. Contractor shall name The City of Ashland, Oregon, and its elected officials, offigers and employees as Additional Insureds on any insurance policies required herein but only with respecfto Contractor's services to be provided under this Contract. As evidence of the insurance coverages required by this Contract, the Contractor shall furnish acceptable insurance certificates prior to commencing work under this contract. The contractor's insurance is primary and non-contributory. The certificate will specify all of the parties who are Additional Insureds. Insuring companies or entities are subject to the City's acceptance. If requested, complete copies of insurance policies, trust agreements, etc. shall be provided to the City. The Contractor shall be financially responsible for all pertinent deductibles, self-insured retentions and/or self- insurance. 17. Governing Law; Jurisdiction; Venue: This contract shall be governed and construed in accordance with the laws of the State of Oregon without resort to any jurisdiction's conflict of laws, rules or doctrines. Any claim, action, suit or proceeding (collectively, "the claim") between the City (and/or any other or department of the State of Oregon) and the Contractor that arises from or relates to this contract shall be brought and conducted solely and exclusively within the Circuit Court of Jackson County for the State of Oregon. If, however, the claim must be brought in a federal forum, then it shall be brought and conducted solely and exclusively within the United States District Court for the District of Oregon filed in Jackson County, Oregon. Contractor, by the signature herein of its authorized representative, hereby consents to the in personam jurisdiction of said courts. In no event shall this section be construed as a waiver by City of any form of defense or immunity, based on the Eleventh Amendment to the United States Constitution, or otherwise, from any claim or from the jurisdiction. 18. THIS CONTRACT AND ATTACHED EXHIBITS CONSTITUTE THE ENTIRE AGREEMENT BETWEEN THE PARTIES. NO WAIVER, CONSENT, MODIFICATION OR CHANGE OF TERMS OF THIS CONTRACT SHALL BIND EITHER PARTY UNLESS IN WRITING AND SIGNED BY BOTH PARTIES. SUCH WAIVER, CONSENT, MODIFICATION OR CHANGE, IF MADE, SHALL BE EFFECTIVE ONLY IN THE SPECIFIC INSTANCE AND FOR THE SPECIFIC PURPOSE GIVEN. THERE ARE NO UNDERSTANDINGS, AGREEMENTS, OR REPRESENTATIONS, ORAL OR WRITTEN, NOT SPECIFIED HEREIN REGARDING THIS CONTRACT. CONTRACTOR, BY SIGNATURE OF ITS AUTHORIZED REPRESENTATIVE, HEREBY ACKNOWLEDGES THAT HE/SHE HAS READ THIS CONTRACT, UNDERSTANDS IT, AND AGREES TO BE BOUND BY ITS TERMS AND CONDITIONS. 19. Nonappropriations Clause, Funds Available and Authorized: City has sufficient funds currently available and authorized for expenditure to finance the costs of this contract within the City's fiscal year budget. Contractor understands and agrees that City's payment of amounts under this contract attributable to work performed after the last day of the current fiscal year is contingent on City appropriations, or other expenditure authority sufficient to allow City in the exercise of its reasonable administrative discretion, to continue to make payments under this contract. In the event City has insufficient appropriations, limitations or other expenditure authority, City may terminate this contract without penalty or liability to City, effective upon the delivery of written notice to Contractor, with no further liability to Contractor. 20. Prior Approval Required Provision. Approval by the City of Ashland Council or the Public Contracting Officer is required before any work may begin under this contract. 21. Certification. Contractor shall sign the certification attached hereto as Exhibit A and herein incorporated by reference. Contractor: City of Ashla By 'Signature ` D�epa`rtmCent Head O�Q COL-SlYV�vsa�'� �JOwYbCUI'� `N\,o , R f:A.,54 Print Name Print Name klel Title Date W-9 One copy of a W-9 is to be submitted with the signed contract. Purchase Order No. L P VE 0 FORM Kc_ Signature Date Contract for Janitorial Services, Revised 06/30/2011, Page 3 of 5 EXHIBIT A CERTIFICATIONS/REPRESENTATIONS: Contractor, under penalty of perjury, certifies that (a) the number shown on the attached W-9 form is its correct taxpayer ID (or is waiting for the number to be issued to it and (b) Contractor is not subject to backup withholding because (i) it is exempt from backup withholding or (ii) it has not been notified by the Internal Revenue Service (IRS) that it is subject to backup withholding as a result of a failure to report all interest or dividends, or (iii) the IRS has notified it that it is no longer subject to backup withholding. Contractor further represents and warrants to City that (a) it has the power and authority to enter into and perform the work, (b) the Contract, when executed and delivered, shall be a valid and binding obligation of Contractor enforceable in accordance with its terms, (c) the work under the Contract shall be performed in accordance with the highest professional standards, and (d) Contractor is qualified, professionally competent and duly licensed to perform the work. Contractor also certifies under penalty of perjury that its business is not in violation of any Oregon tax laws, and it is a corporation authorized to act on behalf of the entity designated above and authorized to do business in Oregon or is an independent Contractor as defined in the contract documents, and has checked four or more of the following criteria: ✓ (1) 1 carry out the labor or services at a location separate from my residence or is in a specific portion of my residence, set aside as the location of the business. V/ (2) Commercial advertising or business cards or a trade association membership are purchased for the business. ✓ (3) Telephone listing is used for the business separate from the personal residence listing. ✓ (4) Labor or services are performed only pursuant to written contracts. ✓ (5) Labor or services are performed for two or more different persons within a period of one year. ✓ (6) I assume financial responsibility for defective workmanship or for service not provided as evidenced by the ownership of performance bonds, warranties, errors and omission insurance or liability insurance relating to the labor or services to be provided. Contractor (Date) Contract for Janitorial Services, Revised 06/3012011, Page 4 of 5 Pathway MEAMREP, �� ISSATh- Enteirpm` es gl'�IPi IOCdIIC� I liOc CP. June 15,2011 Kari Olson Purchasing Representative City of Ashland 90 N.Mountain Ave. Ashland,OR 97520 Ms. Olson, I have prepared our Janitorial pricing proposal for the City of Ashland based on the current Living Wage data. Overall,by incorporating the new Living Wage our annual price for services is increased from$75,840.54 to$76,511.58 for a total annual increase of$671.04. The updated changes for 2011 services are as follows— • The Living Wage increased from$13.40 per hour to$13.53 per hour. The following chart reflects the changes contained in the attached costing spreadsheets. CITY OF ASHLAND COSTING CHANGES 2011 -2012 2010-2011 2011 -2012 Increase Amount THE GROVE 10,512.75 10,605.31 92.56 SERVICE CENTER 9,916.47 10,003.24 86.77 STREET AND SHOP 4,416.09 4,450.80 34.71 POLICE DEPARTMENT 11,705.31 11,809.44 104.13 CITY HALL 12,897.88 13,013.57 115.69 COMMUNITY DEVELOPMENT 19,456.98 19,636.31 179.33 MUNICIPAL COURT 6,935.06 6,992.91 57.85 TOTAL ANNUAL COST 75,840.54 76,511.58 671.04 TOTAL MONTHY COST 6,320.05 6,375.97 55.92 t Pathway_ M 1 MEMBER. bilet p�lA.lf Inc On��P3 IOC:dllil.� mt name In total we propose an increase of less then I%for the upcoming year. Pathway Enterprises,Inc. truly appreciates the partnership we have with you and we hope to continue providing an expanding variety of services to 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 , �Rbe CERTIFICATE OF LIABILITY INSURANCE OP ID DL DATE(MM/DDYYri) PATHW-1 O5 09 Ill PRODUCER THIS CERTIFICATE IS ISS AS A MATTER OF INFORMATIM r ONLY AND CONFERS NO RIGHTS UPON THE CERTIFICATE Western States Ins. - Medford HOLDER.THIS CERTIFICATE DOES NOT AMEND,EXTEND OR 38 N. Central Ave Suite 100 ALTER THE COVERAGE AFFORDED BY THE POLICIES BELOW Medford OR 97501 Phone: 541-779-1321 Pax:541-779-9187 INSURERS AFFORDING COVERAGE NAIC# INSURED INSURER A: Philadelphia Ins Cc INSURER B: Pathway Enterprises, Inc. INSURER C: 655 Washington St INSURER D: Ashland OR 97520 INSURER E: COVERAGES THE POLICIES OF INSURANCE LISTED BELOW HAVE BEEN ISSUED TO THE INSURED NAMED ABOVE FOR THE POLICY PERIOD INDICATED.NOTWITHSTANDING ANY REQUIREMENT,TERM OR CONDITION OF ANY CONTRACT OR OTHER DOCUMENT WITH RESPECT TO WHICH THIS CERTIFICATE MAY BE ISSUED OR MAY PERTAIN,THE INSURANCE AFFORDED BY THE POLICIES DESCRIBED HEREIN IS SUBJECT TO ALL THE TERMS,EXCLUSIONS AND CONDITIONS OF SUCH POLICIES.AGGREGATE LIMITS SHOWN MAY HAVE BEEN REDUCED BY PAID CLAIMS. IN5K ADD L POLICY LTR NSR TYPEOFINSURANCE POLICY NUMBER DATE MMIDD/YYYY DATE MM/DDIYYYOY LIMITS GENERAL LIABILITY EACH OCCURRENCE $ 11 000,OOO • X X COMMERCIAL GENERAL LIABILITY PHPK565846. 05/11/11 05/11/12 PREMISES(Ea occuence $ 100,000 CLAIMS MADE OCCUR NED EXP(Any one Person) $ 5000 PERSONAL S ACV INJURY $ 1,000,000 X Professional Liab GENERAL AGGREGATE $3,000,000 GEN'L AGGREGATE LIMIT APPLIES PER: PRODUCTS-COMPIOPAGG $3,000,000 X POLICY PRO- LOC AUTOMOBILE LIABILITY COMBINED SINGLE LIMIT $ 1,000,000 • X X ANY AUTO PHPK565846 05/11/11 05/11/12 (Ea accident) ALL OWNED AUTOS BODILY INJURY SCHEDULEDAUTOS (Per Person) $ HIRED AUTOS BODILY INJURY NON-OWNED AUTOS v�Ji� .f (Peracciderd) $ PROPERTY DAMAGE $ (Per accident) GARAGE LIABILITY AUTO ONLY-EA ACCIDENT $ ANY AUTO EA ACC $ OTHER THAN AUTO ONLY: AGG S EXCESS/UMBRELLA LIABILITY EACH OCCURRENCE j$ 3,000,000 • X X OCCUR F_] CLAIMS MADE PEM306719 - 05/11/11 05/11/12 AGGREGATE JS3,000,000 E DEDUCTIBLE - $ X RETENTION $10,000 $ WORKERS COMPENSATION AND EMPLOYERS'LUsILITY YIN TORYLIMRS I ITR ANY PROPRIEiOR/PARTNERIEXECUTIVq­­, E.L.EACH ACCIDENT $ OFFICER/MEMBER EXCLUDED? E.L.DISEASE-EA EMPLOYE $ If yes,describe under SPECIAL PROVISIONS below E.L.DISEASE-POLICY LIMIT $ OTHER EER ON OF OPE RATIONS/LOCATIONS/VEHICLES I EXCLUSIONS ADDED BY ENDORSEMENT I SPECIAL PROVISIONS ficate holder is additional insured. CERTIFICATE HOLDER CANCELLATION SHOULD ANY OF THE ABOVE DESCRIBED POLICIES BE CANCELLED BEFORE THE EXPIRATION DATE THEREOF,THE ISSUING INSURER WILL ENDEAVOR TO MAIL 30 DAYS WRITTEN NOTICE TO THE CERTIFICATE HOLDER NAMED TO THE LEFT,BUT FAILURE TO 00 SO SHALL City of Ashland IMPOSE NO OBLIGATION OR LIABILITY OF ANY KIND UPON THE INSURER,ITS AGENTS OR Attn: Xari Olson REPRESENTATIVES. 90 N Mountain AUTHORIZED R RESENTATIVE ' Ashland OR 97520 ACORD 25(2009101) TION. All rights reserved. The ACORD name and logo are registered'marks of ACORD ' www.saif.com OREGON WORKERS COMPENSATION CERTIFICATE OF INSURANCE �sa F CERTIFICATE HOLDER: CITY OF ASHLAND ATT KARI OLSON 90 N MOUNTAIN ASHLAND, OR 97520 The policy of insurance listed below has been issued to the insured named below for the policy period indicated. The insurance afforded by the policy described herein is subject to all the terms, exclusions and conditions of such policy. POLICY NO. POLICY PERIOD ISSUE DATE 524679 04/01/2011 to 04/01/2012 07/06/2011 INSURED: BROKER OF RECORD: PATHWAY ENTERPRISES ASHLAND INSURANCE INC 655 WASHINGTON ST 801 O'HARE PARKWAY #101 ASHLAND, OR 97520-3705 MEDFORD, OR 97504 LIMITS OF LIABILITY: Bodily Injury by Accident $500,000 each accident Bodily Injury by Disease $500,000 each employee Body Injury by Disease $500,000 policy limit DESCRIPTION OF OPERATIONS/LOCATIONS/SPECIAL ITEMS: IMPORTANT: The coverage described above is in effect as of the issue date of this certificate. It is subject to change at any time in the future. This certificate is issued as a matter of information only and confers no rights to the certificate holder. This certificate does not amend, extend or alter the coverage afforded by the policies above. AUTHORIZED REPRESENTATIVE 3r� r IZ�c(d�► President and CEO 400 High Street SE Salem,OR 97312 P:800.285.8525 F:503.373.8020 Polle y_CertlPotes_CertificateOtInsurance • o 0 • m • : z •59 DEPARTMENT OF ADMINISTRATIVE SERVICES Request for Price Approval For Janitorial Services Contract#QRF (Product or Service) S -e 76 rta-� Total Price: "�-6S40 54— z per FY 2011-2012 (month, year, each, doz.) Requesting Agency: City of Ashland Requesting QRF: Pathway Enterprises Agency and QRF agree the proposed price and supporting documentation meets the requirements of OAR 125-055-0030. date: z-c!� -, -- \1 Authorized Agency Signature phone# Email Address date: 6/Z-�ho I L Authorized QRF Signatur phone# 54 �-X001 —�{5Sp Email Address DAS/SPO has reviewed the submitted documentation supporting the price offered by the QRF and approves the price for procurement of the above stated product or service in accordance with OAR 125-055-0030. date: DAS QRF Coordinator Revised State Procurement Office 1/26/2009 Achieving Results Together Costing Workbook For Janitorial & Grounds Maintenance Contracts Under the Qualified Rehabilitation Facilities Program c �7: 3�. d I 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 cgsTs 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 ORF 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. ORF Name Pathwa ,Ente 2dsesSlna.. Project Cit of AShland201n-2012 Cit .Hall Executive Director Signature: Raw Materials Per Time Use-Supplies (from supplies worksheet) .$` ."'-. i ,!�233d29: Equipment,Tools&Subcontracting (from small equipment worksheet) ,$' " J486:17' Subtotal 1 $; �" 719.46. Labor Direct Labor (from labor daily worksheet) I$ :. •. 81910:59.' Overhead See Overhead Worksheet 1$ .' '2,60217.1. Delivery Transportation (from Trans&Reserve worksheet) .$ •'': Total Before Margin 1 12,232:76 Reserve Margin Held in Reserve (from Trans&Reserve worksheet) Total Bid Yearly![ ;_.. 13'013.571 Monthly $ 1.084t4fi' DAS Form#12 J Revision 10-03 Page 1 Summary Sheet D � N x ° L 9� `9 es a t = Z E- , .s s ea j s .S �N ° �.E_sv a ez ° 5^ 0 9 w u c 3vA x @snsm� A,", NF f F d ^ ,R mO gi 9rq 3� c ° x Nile qq LN � OO~.2 >o �frL 8Y O � c'O `m g [!A 1 L HIM xo `e3 32 milli! as vm 8 - a 1111p 3 ^ ^z =xoN cog vil; 5 � 89 2' $ H pO �'^ Y°° o E 'c me a i.� Sn oN grz° a°.n o x o g �5 0$ 925 mW Ea i $5 so 3Ss d � E? 90 a°S 8n u� may» 41 3+ xQQ2 2 at oY Nawwww»:. - °m@ @ Egg c 4 u. Ems' � E v � m m°� Cg' 8m •`�- °� € ° " v ma 5 am5 osF ry do u u m c$v N1 HIM F . . O wv � u n a All Hill Ea 8 it Klima: 12 111 a�. E8� HIM c p _II Je.wU. u�m L,°' np Zt` �"' c•C ina;; `-3 3 oac i°9 ^' vie o ° EE°'E 9 ENg oNm cN j1111110115-11 HIS �IN gs aj QQaca=HIE m8a 3m 12 Ste ..�_ ITRI c5 > ; °.o `o E° 8� gv -i' ^ ' u 5m<-m °c „m 9 .c,.o EEanBE ' �omE `mE gmma9c°r ADC 9�5 €EE °°a5s8 � ° o e3o°6 "I,.a MISScS „„ xt e9z- aSn .Em op5r6- >^af m ° OOOOOn° c- u EZr °3 if 1gC 8m�33 e° _H V1 Y N N n m O ' N Y Y • 6 b p. E• willNa „w q � p HIM g9 : '9i ° � - ° E VI I N m C N a° 3 w S O Gn #C • �F J RAW MATERIALS Oregon Department of Administrative Services Supplies Project Costing Worksheet Pathway Enterprises, Inc. City of Ashland 2011-2012 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.In the rase 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 Broom and dustpan Cleaning chemicals or products Floor Wax Spray bottles Scrub brushes or scouring pads Per Use/Per Item Manufactured-Supplies Item Unit Units Needed Monthly Annual Price Per Month Cost Cost 1 Pine Q Disinfectant $ 4.80 0.1666 '$'- '0:807:$;t.=-.'A.'60 2 Cream Cleanser $ 2.91 0.1666 i$ ..';O.A&i$ ;,5182. 3 Glass Cleaner $ 6.29 0.1666 P$,-., .A'051 I$-, 121571 4 Heavy Duty Cleanser $ 4.80 0.1666 $` -.?;0:801 i$�.; '9:60; 5 Oder Countemctant $ 30.65 6 Carpet Lane $ 5.00 7Carpet Shampoo $ 13.01 $':" +`$ :'! a�'-:rt 8 24 oz Bottle&trigger $ 2.27 0.1666 $ 9 Acrylic Bawl Mops $ 1.71 0.5000 i$;r- i'isi0t861i I$8Fwa;100:26': 10 Scrapper W/blades $ 6.51 0.1666 i$FI_;'V!$1 081 11 1 OZ Pumps $ 2.31 0.1666 '$'=,irdati0t38i t$ a's`'»'4:621 12 Paper Filter $ 21.10 0.3332 :$11 .,:7031 i$E,ro;"8427t 13 Std Loop end Mop $ 5.65 0.3332 t$„.< d -V881 I$EV'%-22:'59➢ 14 24"Dust mop $ 4.26 0.1666 -$t"',--_:Ot741 ftEZi =f8!52: 15 Doodlebuc I BN Pads $ 1.18 0.1666 $ - :0!201 2.361 16 Duster-expandable $ 5.75 0.1666 i$tit:%:iiv e0!9601$i?: i?ti'.1,1:501 17 Spot Away $ 2.74 1 0.3332 $4Fi i.i +1oS91k i$9 4 P.10!96i. 18 Cleaning Pads $ 4.70 0.1666 $4Sc:-,w i:.028t!$i.01,G19:40i 19 Wax Mop $ 6.80 0.1666 <$',::.,-.,::.11131?$i 1-? O13159: 21 22 - 24 $ 25 29 $. 30 38 $C. v : 39 .$., +$� .... Total '$- : :19:44' ;$,'�:y;;233:29' Areas.ingreeri,are�fprmuladriven. 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 limes 12 months. DAB Farm#12 J Revision 10-03 Page 2 Supplies Sheet 0 0 E E n w O L W d y H D � c EC y q 9 N Q o N F O E U E Y r a N y C V O p OI m V U (O V p b D O N 0 ! y `o a`rf 0 7wwwwH 0 0 u 0 0 0 0 0 0 d y ^ A Q= T a� c 0 d a O A O O Cl O C U d m o o m o mmmn m=" 11 � y_ 1Up $i v Odd y O (Oj d ., niti] .. . TI Cy rn N N N N = L y E c_ E c o w f M y O a V d y N IO IO Q t0 ` y J O 9 j 0 d mmmNm L N ' W O 3 j 0 C w 9 d N y W J E a E `o CL °o. ,E -p `m B V 9 A ?` Ud C O ^ y O p « O y N Co J o E E ' C N E La � H o a o= °m c o h NNUi« VyN nSyH Ea !"yi ip Lq� a nL = � N JNINO �n ..h CHTd 6L fIID�E UJd ... J yO !? E � � I o u . I °n c o a w p r a a Ti n a F __ cm noa SoE mr !!wi ° ?' aa Ta a U W L X N > C A d d T Q O A y A O U y U J am A r an 3 �5 ° N c $tm a� Ea''-' i:mm a o Edo _ ? � W N ° O O j .dtt O C 0 A J O O °o �$ ILL m 'Q13 Dow A U U F- y oa E � NmQ :O (D I� oJmO � � � Q �n II 11 II II 11 II II C N d H n ' «h CI y N 0 4 V;L c a a d » c r = U ] U Em ai.am o Yaau 7E u c c 3 d c W °° m m LL C w Q O O _ O a d T O y 7 LL O E = I-C ° E LL - p K • OVERHEAD Orogon Department of Administrative Services r Overhead Costs Project Coding worsened Pathway Enteryrls City of Ashland 2011-2012 City Hell 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) FILL IN ONLY ONE OF THE THREE METHODS DETAILED BELOW! Percent of Total Cost Method: For every dollar spent pmnudng a MW product or providing a service,a crown percentage of Mat dollar Is 1. Enter Overhead as a Percent of Total Costs moored for overhead To calculate Me overhead percentage,it Is best to have flnawlal records for your Y000% dogrouation tooled back ayearcr more.Add togetherdoexpanditure9that makeup MewerMatl cost(see worhsM1eet bMOw). Now and this figure to Me Raw,materials,Dtrec't labor and Delivery for a tobl cost Divide the figure for overhead by the figure for bbl costs.The result Is a percent Met repressors werthead as Peroalag8 of the best Wit If financial records are not wallabk estima@ the awarded exile pare as best you OR cark esdmae other Wses as best you ran,and use the same formula to gel a Percentage. 2.-Enter Allocated Overhead as a Dollar-Figure Sum Dollar-Figure Sum Method: YOU Car enter the Jolla arteuM yov me albpolirg to overhead N Me box If you ae pang�rzll)albwne overhead Items to tie particular project You ran use Me WorWMet Bs a tool( OR to Identify your costa. 3.Overhead as a Percent of Total Direct Labor Hours Percent of Total Direct Labor Method: To Inertly overhead costs,you need the firendal reports fa yea orgarruPUon or division fM de past year.Input all the costs of Me ense eery we detailed below.Lee Items wNNM we not defense been shoud be input Into the calls marked 'otho1;please bxlnde a description.what you am trying b diderro ee h a percentage,therefore,do not gross up We rsxpa¢es for inflation or to ponbrm b Me currant year bagel Next.Ingo Into the cep below the total direct labor hours pad Out by your entire organization for Me same pered.These figures should be found on The year end payroll repoM1 Do rot [miude hours which can be Classified as management w adminlatreUve WSYs.(Inr1 WRg Mete Costs line the direct labor hour hotel will deflate Me actual costs.)The wodaheet will pompub Me moribund as a line Item wet by dMillrg the bbl roiled labor hours for the contract Into Me bbl projected labor fours for Me cunW red. Total Arenrm of.labor lbws Input Total from Worksheet on Scow Overhead per labor hour S Time roeuired a complete contract 'f"520 Total Assigned oaemead Worksheet WORK AREA: Total Annual Operations Use the area below to show how you arrived at the final figure INDIRECTCOSTS OROAhD TkgN DEPARTMENTAL that you show as your total Overhead _ Managementsabies Management Payroll Tax Expense Management Medical Insurance Management Pension Plan Expense Sales S Adm ialumilve Saladea Sales 8 Administrative Payroll Tax Expense Sales Is Admtrl54a We Medical Insurance Sales S AdmlNstrxpve Pension Pipe Expense Office Rent AdwemMrg and Public Education Background Checks 8 Urinalysis Professional&Accounprg I Audit Fees Training a Works Safety Insurance Tempts ve UGptles PmPeny Taxea2lttn eYFees Dues B Subso lmons Depr W iapml-0mce build, Depreclalimwfllce equipment Repairs 8 MainlerlanC fflce Clearing and MaInlerlance Office Equipment Rental Others Supplies Postage a Freight Rehab Miscellaneous Expense Ban Deble Other.• - Oer- - Other Other- •._ TOTAL INDIRECT COSTS oPlF:corm,eta l.eslwre.mwl issx issx nuerTw TOlal S OAS Form a12 J Revision 1643 Page 5 Overhead computation SM1est ueuvery a rceserve. vregon uepar[ment or raammistracuve aervices Pathway_Enterprises, Inc. Project Costing Worksheet City of Ashland 2011-2012 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 greater than the state allowed cost, please provide a detailed schedule on how you arrived at your cost per mile. Services Contract Miles Per Rate Per Daily Services per Annual Delivery Description Service Mile Cost Year Trans Cost 1 caravan _$ '<$ . 3 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% DAS Form#12 J Revision 10-03 Page 6 Trans-Delivery and Margin Sheet Costing Workbook For Janitorial & Grounds-Maintenance Contracts Under the Qualified Rehabilitation Facilities Program f yr, Y Oregon State Department of Administrative Services Procurement, Fleet, and Surplus Services 1225 Ferry Street SE, U140 Salem, Oregon 97301 (503) 378-4642 t 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 ,Ente dses;anc., Project I City of Ashland 2011-2012 Comrnunity Development Executive Director Signature: Raw Materials Per Time Use-Supplies (from supplies worksheet) `!. x.233:29 Equipment,Tools&Subcontracting (from small equipment worksheet) $. 486:171 Subtotal 1 .$Y" 719.46 Labor Direct Labor (from labor daily worksheet) $- :. :1. 13;811.41:: Overhead See Overhead Worksheet .$'. :c-3,927.26' Delivery Transportation (from Trans&Reserve worksheet) $ Total Before Margin Reserve Margin Held in Reserve (from Trans&Reserve worksheet) $ . : ;-1,178:18 Total Bid Yearly[ 636.31: Monthly $: " _: .:= 1,636.36! DAS Form#12 J Revision 10-03 Page 1 Summary Sheet RAW MATERIALS Oregon Department of Administrative Services Supplies Project Costing Worksheet Pathway Enterprises, Inc. Citv of Ashland 2011-2012 Community Development • Raw Materials: This categoryjs 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 Broom and dustpan Cleaning chemicals or products Floor Wax Spray bottles Scrub brushes or scouring pads Per Use/Per Item Manufactured-Supplies Item Unit Units Needed Monthly Annual Price Per Month Cost Cost 1 Pine Q Disinfectant $ 4.80 0.1666 ,$„ -50805 I$ui!. .A9!60t_ 2 Cream Cleanser $ 2.91 0.1666 3 Glass Cleaner $ 6.29 0.1666 4$1 I$*R;t:%%12'.57 4 Heavy Duty Cleanser $ 4.80 0.1666 P$, d080F i$ea-ut<.::i9:60i 8 24 oz Bottle&trigger $ 2.27 0.1666 !$:-d,'U0!381 I$9L:V4".54.' 9 Acrylic Bowl Mops $ 1.71 0.5000 1$y;.;; °'dAO!861[$Airrl:X1026: 10 Scrapper Wlblades $ 6.51 0.1666 t$G:'-i+T 1.551!081 I$i -141 3!01& 11 1 OZ Pumps $ 2.31 0.1666 I$Ioi:-§",(XOt381 I$T WWV!6Z 12 Paper Filter $ 21.10 0.3332, !$8::: tby7?031 I$4F'ftt84!37* 13 Std Loop end Mop $ 5.65 0.3332 1$'a:.=r�.':+asryii881 I$A:'«:T.M22!59i 14 24"Dust mop $ 4.26 0.1666 P$E_'S:iiK='?Ot7.tI I$i'K�NU8!52: 15 Doodlebug BN Pads $ 1.18 0.1666 S$E,w!;:,10!201 i$&FiE42F36 16 Duster-expandable $ 5.75 0.1666 ;$.*:di.;„>a"','0!96f I$(etflfSiL'1i1!SOi 17 Spot Away $ 2.74 0.3332 18 Cleaning Pads $ 4.70 0.1666 i$"s2':r tiyfOt781 4$111+0' ;!AU9'40t 19 Wax Mop $ 6.80 0.1666 i$Li`--%r+€:.<t?131 i$4"Ywi;&13!591 24 25 26 27 $ 4 i$"ws 29 31 - $h P% '`ti I$rr:A rr-,SOf 35 39 Ql Total I,$ x19:44, ;$";-%.23329: Areas!injjgreen are formula,driven 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 ♦ F° N E n N J d d V U t W L N d 0 m > m winwww S c n o 0 0 0 N m O O N O cU n J y� mmm m � m 0 r d E U¢ F c Z N N O H o 0 m U a � r 0 o v p m u c `Ooci -' t d U ' m n m e a� •4 r,:: 0 L Jwwwww ' C z e e o n •°N m d N O� T ye C O O a - o yl m O O m O O N m O O [V O U Y m v m m v O HE S CcJ �+ w i wwww `:!�A •h � N .. y £ $ y d c v � � •'1 �' } - ° 0 N N. . . c — v ry c N - N N O 2` m H E u 3 E o n d m m m N m •S c > m E m d C C N Z v m a m 0 o _ E _ ° .. m o °o °om °o n � d m o E a 0 a NN 'E U P N P N Q N N >i 3 W 0 D C b '•.��� C'j T d N J o E u C y a d Ea v d at rn�% c U o 00 «° C cUi N gv N` $E n Cm .i Sn n° d N E n a'c �' L.Jdm'7 d 2C♦I C G N Cn.°v d.0 C J c C d m UM nv U E 83 c O !il T J T E 42 C T oa 'G pia Ja ¢ cwtx m5n mry c .c > rS Q3Q v n, L T�o d N UQ o `OE O C C S N N a SC m00 o° °'O j I.'. N .m v n mIm 2 MoU« :, o m n E : a° 5 E 3 1 v 0 O C N m J O K w a U $ a 3 m S LL W mQ?�i now m U 2 U r o .W C d n� L G U N yC l N d LN(I M N pl y ?a C C`n° 11 d d �C d y C G N U :5 d > $ E E a>nN o 3 d m c v gE '3muo .E o u a ¢ O 11 C d 9 N N J O O O t m u a o 'cad -0 c v c c u w a N O O N d € C r m m m = Z A W N N'g D K e o8888oao888$?8 TqO °g e Q tli h p w� 9 Em cr55 a. LL m°o 9g$g ° TE day ov oE�y $ ap� 5 E Ly me E mss gFe $ gS OSm SXxx J `@ 8 d zap a°HMy s $8 m i c E g° q e@ m o ° mE mr'c °Sm a 8m N~wainwwwww w.�.s so 8�t �b� €� �'@ E � ijE uq Z^SX Nc El Yksyo ° �ww I E 8 8 E E nd E O l9 a w X 18 x a m LL = 8?� gg r m8 o�BeEm �«n oe cen{ u9An� Gn E�yv u TQ m y 3g I' m Ex° _.�CQOOmmmo A _ me oq r y mjmrie� �ZLLL TT� � OL °Y 08C ° $ mgpQ zOO C m$ E gsIns, 8°E16 g3'.r .Q a,�E e9m� 8 � vg � 3 $ e4m UE °cawnE8i 53 °c o5 'E oE $ 8 ° mg Em E E E E?? m a.? `ohs E6 $L' figE Or `oc� o° X88 m n r33 `0E �'a � ?oa i.? o4oa `e c58 a. ,E x =o3 a 0 4ae I E E E nnn n'p'!? m» Ei' °6 �e E EAstC of 3c4 ¢ E o y ga�. '':m UUUUES°r��F=�i iim°m.6 Sau F iEopo � f o9 � yi oo Y 5 a an 8 L a E a m a d `s s OVERHEAD Oregon Department Project Costing smoothest OvetM1ead coats ,pa,sm,Ed",City of Asiband 2011-2612 CommuNN DevHlapmant There are many different ways organlzalions 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 organlzatlon 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) FILL IN ONLY ONE OF THE THREE METHODS DETAILED BELOW! Percent of Total Cost Method: For every dollar spent Pmdudtg a arm pro most,or proNdkg a servtoe,a cdaln pecmtage of Mal does,Is 1. Enter Overhead as a Percent of Total Costs reeulred for overhead.Tp calMate the overhead porcenmge,it b best to M1dxa ilnaMal,earns mrour 2000% organbatlon Mat go back a War or more.Add together MeexpendMaes that make up Meovedtea,l cost(ses wohsheel below).Nov add Me figure m the Raw materials,Direct later and Delivery for a mml cost Divots the ngure for overhead by Me figure for tome cogs.The result Is a percent Mat represents overhead as a percentage of Me load cost. If tnencial records are not available eshmate Me overtxn,d expenses As best you OR an,estimate order costs as best Wu can,and me Me some formula to gel a percentage. 2. Enter Allocated Overhead as a Dollar•Fgur¢Sum Dollar-Figure Sum Method' You cent mitt Me tlolmr amount Wu are albcetinp b overheatl Moral x if Wu me conndeM that Wu ran atbcem overhe�iharm .so ed.rpmlect Vou anroe Me Worksheet asatool Qf needed) OR mm INW Percent of Total Direct Labor Method: 3.Overhead as a Percent of Total Direct Labor Hours To itlentiy method, est.Wuneed Me finandal records for Wur olgamiam,or division for the past year.InPta alt Me ask of the entire arty as detailed below.IJta Items which are ct detailed below should be Inpul Into Me calk mauled -omse:please Include a dem-pbon.What Wu are trygg to demrtnlne is a percenage,therefore,ho Trot gross up the embrace Wrapper,m to condom to tie cumnl year budget Next mpot lab me cell baba the tome new labor hours pad pN by War entire mganlzatbn mr the same pabou These figures shod as foex,w ere year end pa mat report Do rot indeed lours witch can he classified as management or adeinktrahe costs.(Indixf,Mess ask I.the direct labor hour mml will deflate Me actual cools.)The wohaMet wnl comp1M he ovenezd as'a Ida Item cost by dhtdhg Me keel projected labor hours for the contract Into Me total projected labor holes mr Me camenl War. Tool Annual Direct Labor Hours Input Total Mom Worksheet on Fasdw Ovehead per labor lour 3 Tema phimol to complete entrad r ane Total Assigned Ovedaad - .. Worksheet WORK AREA: Total Annual O orations Use the area below to show how you arrived at the final figure INDIRECTCOSTS ORGANIZATION DEPARTMENTAL that you show as your total Overhead Management Salaries Management Payroll Tax Expene Menagement Medical Imlaance Management Pttabn Pl.Expttao Sales 8 Aemingumove Salaries Sales 8 AMninisbative Pad to Tae Expense Sales 8 Pende grasre Medical Imurance Sales 8 AdmosbariMe Persian Plan Expense Add ReM AaCiggicing ant Public Educatbn 6ackgmund Checks rfingI ci Training rial8Accoaating lAutlli Fees Inalnitg 8 Worker Safety Telephone Telephone UhtiMec Subscriptions, Fen Dues 8 SubwiDtlom Depredatlm-once W diry DepredatbrroMce e adpmd d Raairs 8 Msime,mrro¢se Clearing,Ecand vent Rated Ofnce supplies Rental Omre Supplies Rehab 8 Freight Rehab Bad Debts Expense D s Order'; Order:'' OOxr Other^. TOTAL INDIRECT COSTS Total con rwmaeneu lwmwt�.t tssx telex DAS Form#12 J Page s Overhead Computation Sheet Vm,ICMn 1rMt ueuvery ag rceserve Oregon ueparunent or Amnnnsaauve aervwea Pathway Enterprises, Inc. Project Costing Worksheet City of Ashland 2011-2012 Community Development 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 greater than the state allowed cost, please provide a detailed schedule on how you arrived at your cost per mile. Services Contract Miles Per Rate Per Daily Services per Annual Delivery Description Service Mile Cost Year Trans Cost 1 caravan $ $, 2 3 4 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% DAS Form#12 J Revision 10-03 Page 6 Trans-Delivery and Margin Sheet Costing Workbook For Janitorial & Grounds Maintenance Contracts Under the Qualified Rehabilitation Facilities Program O C F . 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 COPTS 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 :Ente rise Inc. Project Cit of Ashland 2011-2012 Municipal Court Executive Director Signature: - Raw Materials Per Time Use-Supplies (from supplies worksheet) $ 233+29 Equipment,Tools&Subcontracting (from small equipment worksheet) '$. 486:17 Subtotal 114 719.46-- Labor Direct Labor (from labor daily worksheet) Overhead See Overhead Worksheet $ "%=1;398.58. Delivery Transportation (from Trans&Reserve worksheet) Total Before Margin I $'. 6.573.33 Reserve Margin Held in Reserve (from Trans&Reserve worksheet) 419.57 Total Bid Yearly _J.:+.- 6,992.91' Monthly.$..' < 582.74' DAS Form#12 J Revision 10-03 Page 1 Summary Sheet RAW MATERIALS Oregon Department of Administrative Services Supplies Project Costing Worksheet Pathway Enterprises, Inc. City of Ashland 2011-2012 Municipal Court Raw Materials: This categoryis 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 Broom and dustpan Cleaning chemicals or products Floor Wax Spray bottles Scrub brushes or scouring pads Per Use/Per Item Manufactured-Supplies Item Unit Units Needed Monthly Annual Price Per Month Cost Cost 1 Pine Q Disinfectant $ 4.80 0.1666 M,: =';=3,:0!804 i$'i' _L'�9'60: 2 Cream Cleanser $ 2.91 0.1666 i$r, ;:r'&0'481!$•x'.'%i 95:82r 3 Glass Cleaner $ 6.29 0.1666 1$,'c3=+:,;x:1!051 I$s7i.;1C%A2!574 4 Heavy Duty Cleanser $ 4.80 0.1666 $ a::.;fi0!8011$SiLF "?9:601, 5 Oder Counteractant $ 30.65 P$;i :a1:Tax,:=. I$SCt4;itiltar«ti" 6 Carpet Lane $ 5.00 7 Carpet Shampoo $ 13.01 1$k >!trs= 1$ 2-ft 8 24 oz Bottle&trigger $ 2.27 1 0.1666 t$5-:53Ot381 I$PA€ia'? 4!541 9 Acrylic Bowl Mops $ 1.71 0.5000 1$5=ee X0!861 I$fc 04101261 10 Scrapper W/blades $ 6.51 0.1666 1$a^> ":W81 I$kZV-w l3!01t 111OZ Pumps $ 2.31 0.1666 7$wAs% ,AOt3811$169rZ4162: 12 Paper Filter $ 21.10 0.3332 ;$eV'1,iW7;031 I$ 1O.W84131rZ 13 Std Loop end Mop $ 5.65 0.3332 t$Irr!:tip"-`W!881 1$%U-, 122!59+ 14 24"Dust mop $ 4.26 0.1666 3$a;`a<; ;;0:7,11 1$5uw&0&52-, 15 Doodlebug BN Pads $ 1.18 0.1666 :$':a= Oi207 I$ 42!36t 16 Duster-e andable $ 5.75 0.1666 v$':A*& 019611$WWAIM50; 17 Spot Away $ 2.74 0.3332 1$&WZ&%10!96t 18 Cleaning Pads $ 4.70 0.1666 !$=;ttft@781 I$105dM19Wi 19 Wax Mop $ 6.80 0.1666 !$ m +..;e4?E1t13t IMAWO3!59t 22 $ :;51$1:: -a1-: b 23 24 25 $ '�'-°. "rtld I$1-A�ss' 27 IWAAR�st, 28 P$'�;;ie..+st;i=.tiLi2 1$& di=e„' . 33 35 Total °$4;:.;';l91441 i$i''123129: Areas; n,g�eertareformula:iirlven _ 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 N O O r E n v U t W N w W 10 y 0 m C O t oy D: r www«i iw . ' w d � b E U E s` F d b j 2 CI O » N O oU m mtpMm _ _ O C C - C u o 0 0 0 o n � mjf O 0 v a rp O O y O C O m t7 O O N C' U m ^ o o m o YO T V m P d d wwwww� '^ N n C V 4 H m S� ti d Eon m .- Ti N y C 00 m m m Lr o u m ymmey t Jy .°_ �O � 'o o m ycom NC! S m E n C aVV"�r O T d N « t U r > =o C Ul 9 s $ m N .cGwa,a Edo o r,, o0000000o w � � � a m n V W V 9 w w N w w •..O a J C U y N PV— d 0 o ON. m g N c N m y o u o V d y° 9 °n E a I.cl N y E E n `o J c .ylm m 0 I o maa Ta 2' 'p E T Q m Q 2 E n LOI'O N �pp 3 N O NNC C y S` O m 0 >L N O C N N O O Y. W LL U 0 S 3 N S I Y V1 ;Q > U W N U '2 U r 09y � NClONlpnof OlO � ' ^ Q ' II 1111 II II 11 II .m� C N N X ' d¢ c m6d a U cO E _ L b $ Y L> E a E E o- of '9mm0 W D m m— D m Q O ` C a g m J O r O d D C m.p� L',O Tq W C O Net y 6 6 p C¢ a N ` = a o .E°c_ 9m1 C ,,,d, a n E o J_ 5 N O O 0 m `D C mmrn =a2 m LL y Q N pK e °°ssooasss000$o8. N a` p � G �. gi S °u9 �oE�9 C LS `ed Fi ~ Box EE u- °5 i - u ! ELI E3 ' m o g x ca ° g g5Y€ m 'sag su9mg v s°, Gz E � ,� aE8`oP so 6 �m x°og � o � g'g@ 3dEEoN � Em Ocoo qEa s a2n �n°° 'o9mm ° riry gE men °s"€ELL " g s3 N~ww 95 S.E'g am €EE UR "m S.so °a 0c aXS°ow $ a ooX gEmm-°°E s Ew aYm n a E v 5E 2 1 0 2 ° § ns° W ;-m ��• a m°$mama F; 3a = _ � `m 3 y 8ymsoEm ga o0 cc5 �_ 9C °- nn p o°ra ?gw n 3 m 4c45 ° �•a$ ° a E°' E n g @ g X l E m s A✓, EE E y_ anad �aSg = g„aim 3 a Td n 8_ Big B nw $ Eq dno° e ° E - Egp � Em Xa = mxoovm°O dm ° C.°5 ���3n o -m°'S a Leg mmc6 E *�ipmw ',:O�nnnOOEoNyvm .E Bey m5c �c$ gZ o B-` v aq c B» ��3z” ,,:��,rmm„33XsNgaE em�£ xomdvg � � 8° �m8 em ng gs� o oaa _ €gypp ocon�`�g a°9n > gaS woe ? E E ran 8 S� c w= o u x x �c - 5555 8 N5 ,��$ nnnn._ 5$ " ° Q 8' s a £ ¢- `” Y•Ea E o o E 9 n $ 52 c Ss`_E 6e'm ����F3 Win ° `fit Qi3� X98 N n a N m n m n n n n n n n n w n n n li OVERHEAD Oregon Department of Administrated Sarvims Overhead Costs Protect Carting weakened PaMwxy Enaspre City of AshlarM 2011-2012 Municipal Court There are marry allHerenl ways organizations allocate overhead Internally(9.g.,Percent of total costs,doll�,ugp as ire labor,etc). In the space provided below,Indicate how your organization allocates overheatl to this particular contract, , what that overheatl amount Is(whether as a percent or exact amount) FILL IN ONLY ONE OF THE THREE METHODS DETAILED BELOWI Percent of Total Cost Method: Fhrevery dollar speed thought a rued product,or pmvMlng,a serNce,a Certain perrentage of and dNSr k 1. Enter Overhead as a Percent of Total Costs reguireed br overnm0.To Calculate MeovehMMl percentage,it k best M nave fitatdkl rmoNS br you 20.00% orgonizaton that go back ay ear or more.Add together Me eupehltlltures Met make up the overhead cost ism workslset below).Now add Mis rive to Me Raw materials.DlrW Ideas and Delivery for a WWI cast Divide Me Nure for overhead by the figure far total ends.The result is a permd dal represents overhead asa percentage of the total Cost. If financial records are not available melanin ins overhead Wpenses as best)Ott OR can,maintain other cons as best you ran,and use the same formula M get a percentage. 2. Enter Allocated Overhead as a Dollar-Figure Sum Dollar-Figure Sum Method: You can enter Me dale amend you are decating to overhead In We has If you are considers Mat you can albcete overheated Items to mis parsctiar project You can hue Vie W Wremdat n a awl Of needed) OR to penalty your ts Percent of Total Direct Labor Method: 3.Overhead asp Percent of Total Direct Leber Hours To identify overhead Costs,you need Me financial records for your organization or dimaton for the past year.Mind all the casts of the entire entity as detailed below.Una items wNCh are act detailed below should be Input led the cells marked "other;please Include a invention,What you am hying 0 determine k a percentage,therefore,do cat gross up the expenaea for Infiaten hr In canfonn to the curter year budget.Nest load Into Me Cdl beWw the bat direct labor Mum added out by your organ oganhown for Me same penoo,These figures should be found on Me year end per poll report Ce not Include thus which can he classified n management or almlNStrdlHe Coss.Onamain,Mess,mss Into Me direct labor Mu bW will engage me Kw ersts.)The wodshat null compute the oveMed as a me than cost by dMNrg Me total projected labor Mutes far We mrltmg Into the total MjWCWd labor Mud for the nment year. Test Annual Direct lards risers I 1 Input Total from Worksheet on Believe Overhead per labor Imur i TmerequlredWcampletemntrag '260 Total Assigned Overhead Worksheet WORK AREA: Total Annual Operations Use the area below to show how you arrived at the final figure INDIRECT COSTS ORGANIZATION I DEPARTMENTAL that you show as your total Overhead Manaperrentselanes Management Payroll Tax Expense Management Medical Insurance Management Person Plan Expenee Sales&Administrative Sudde ce Sales a Aedmirle"We Payroll Tax 6pense $pies B Admin strawe MMral Insurance Sales It AdmlNStraNre Person Plan age. OM.Rem Amnsdaing and Public Education Bedgmurtl Checks E Unand"I. professional&Ac unarg/Audit Fees TralNng 8 Worov Safety Insurance Telephone Utilities Property Tortes l-Icensee Fees Dues A Subscriptions DepreciallenoMce bulding Depreclatimwffice equipment Repairs a Malntehemosaf ere CleaNr,xtd Maintenance OMce Equipment Randall Once$upph. Postage a Freight Renato Miscellaneous ape. Bad Debts Omer.;•: OMer. Other," .. Order TOTAL INDIRECTDOSTS E - — •E_ -t CPIFCiv non eta(w trl bYx.1 I.sev Im ne,fM,, Told E OAS Font g12 J Pape 6 Ovedheatl cong atedde,$hest .e vv,I. weuvery& rceserve uregon uepartmem of Hammisrrative services Pathway Enterprises, Inc. Project Costing Worksheet City of Ashland 2011-2012 Municipal Court 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 greater than the state allowed cost, please provide a detailed schedule on how you arrived at your cost per mile. Services Contract Miles Per Rate Per Daily Services per Annual Delivery Description Service Mile Cost Year Trans Cost 1 caravan 2 3 $.. $.. 4 $. $. .. 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% DAS Form#12 J Revision 10-03 Page 6 Trans-Delivery and Margin Sheet Costing Workbook For Janitorial & Grounds Maintenance Contracts Under the Qualified Rehabilitation Facilities Program yam• ,... , a' 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 ORF 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 :Este rises;Inc:!:- Project I City of.Ashland 2011-2012 Ashland.Police.Department Executive Director Signature: Raw Materials Per Time Use-Supplies (from supplies worksheet) Equipment,Tools&Subcontracting (from small equipment worksheet) $ ":486:17 Subtotal 11;$_. *7,19:46 Labor Direct Labor (from labor daily worksheet) Overhead See Overhead Worksheet 2;361:89; Delivery Transportation (from Trans&Reserve worksheet) Total Before Margin ,$.. >C.. :1.1100:87+: Reserve Margin Held in Reserve (from Trans&Reserve worksheet) :$•.'.. -!- ::908:57:; Total Bid Yearly i$" 1.1,809.44". Monthly.,$,.._ �:. .:'.984:12: DAS Farm#12 J Revision 10-03 Page 1 Summary Sheet RAW MATERIALS Oregon Department or A(Immistramve services Supplies Project Costing Worksheet Pathway Enterprises, Inc. Citv of Ashland 2011-2012 Ashland Police Department 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. A custodial contract,for example,may require the following for month-Supplies: Paper products and soap Broom and dustpan Cleaning chemicals or products Floor Wax Spray bottles Scrub brushes or scouring pads Per UselPer Item Manufactured-Supplies Item Unit Units Needed Monthly Annual Price Per Month Cost Cost 1 Pine Q Disinfectant $ 4.80 0.1666 +$l:e:'---5--0'.80! 2 Cream Cleanser $ 2.91 0.1666 4$- ".a sO%8t i$ .:; ,:.z5'8Z 3 Glass Cleaner $ 6.29 0.1666 �$4'.'. ,'M0511$'i_ 1;12:571`. 4 Heavy Duty Cleanser $ 4.80 0.1666 $""'> 0.801 I$+:^'.. 5 Oder Countemctant $ 30.65 $ •- - It i$Bk"I + = 6 Carpet Lane $ 5.00 ,$,•<_, -"•'fik i$ r -r,- 7Carpet Shampoo $ 13.01 8 24 oz Bottle&trigger $ 2.27 0.1666 01381 9 Acrylic Bowl Mops $ 1.71 0.5000 ?.$tns.-=, 'fi0!861 l$mK 10F26,1 10 Scrapper W/blades $ 6.51 0.1666 t$Ihcir:a4fa1?08!l$Ir�et=:x513!012 11 1 OZ Pumps $ 2.31 0.1666 t$�-1' i l)281 12 Paper Filter $ 21.10 0.3332 t$,-:'a cc-'_.7,?03', i84!37' 13 Std Loop end Mop $ 5.65 0.3332 $ ,1".8811$ s '22!591 14 24"Dust mop $ 4.26 0.1666 $- ,Oi7.1fi 1$4..:. 15 Doodlebug BN Pads $ 1.18 0.1666 $1, 16 Duster-expandable $ 5.75 0.1666 17 Spot Away $ 2.74 0.3332 18 Cleaning Pads $ 4.70 0.1666 19 Wax Mop $ 6.80 0.1666 -TE,1'13F I$ItL. S13!59i 20 32 34 $ isc 35 :$�a 37 $,r2ii 38 $t;:": 39 $i. r :i i$.: - Total '$ 19:445+$'-• `-233:29! Areas in green'are'formula driven 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 0 0 f E v b � W w O � wwwww NC Y n O O O O :... . ii n i p ••:n m O O w O � O d A m O O N O • m C Y 6 m m m m Q d ¢ e rnE ¢ p R K � win w ww: w a O b E E 6 F ~c o m U $ Y = N b O N O O � N °U Q 7 T d° o m a K o 0 o O J mOOwO �' � C O A m O OO fV O e vl } wMNww m u- _ u jy N N N N N L w o ° Y s m m c O A m emi009 . c .rmc m E n m y O T O d t U A C j m a d m r C O m e � _. cut ,Ena Ems ° E m D °o $m °o t o o n d o 0 N « O iy1 P N P N J O y N 3 U C O 9 a'YJ b 7 y y .00 00 r W N EL U a E b w w M w w '• C J C $ N Y O N M r' L_ ° U MI Y K $ Ban a v0u $ cc b m d ca Zia Ja WI- � mE Boa' SS�pE ° � mE IO)L and oaa Ta d T N W U a N 2O OO Y O 0 N$ U W m U 6 Y m Y � c y "pmt c 0 c °v of '3muo ma o e au Q O) LL C N A b l c N 12a. 1.0 i � mmm =02 A y ¢ 'Y p 880$000888888°m,S.8 N :4 T E .....»' MNNNN ys of 2 Z p t 02 Sa ME OF 0 mE E 0 -w- PT f t3 k I f �E RK .OE =2 gE Ell 2 2 8q as 2 8 �E ed �g sE mm mss E 9 R N e E E E � " . 6 d 6 E!2 ME S 3 3 a 8_'s E E E E556'8 0 0 9 GP O. • OVERHEAD Oregon Department of Adminlslative Services ' Overhead!Coats Project Costing Worluhea Paeway EnteryrLs City of ASNand 2011-2012 Ashland Police Department There are merry tllHOrear ways organizations allocate overhead internally(e.g.,Percent of total wets,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) FILL IN ONLY ONE OF THE THREE METHODS DETAILED BELOW! Percent of Total Cost Method: For every dollar spent prod a ng a final product.or Providing a servive,a certain percenage of Val da lar t 1. Enter Overhead as a.Percent of Total Costs. required Or overhead.To calculate Me overhead percentage,it is best b have fimrceW recods for your erganuaMe Nat go back a year or more.Add together Me expendibres that make up the overhead cast(sea worksheet below). Now add Is figure tithe Raw matemis,Direct labor Deft Delivery for a total mat.Divide the figure Or overhead by the figure for WWI cost.The resat is a percent that represents overhead u percentage Of the total cast. If freffawl records are not a+aitable esgmap the overhead exppmss as best you OR con esamate Oliver cast as best you ran,and use the same Warren In get a percentage. 2. Enter Allocated Overhead as a Oollar-Figure Sum Dollar-Figure Sum Method: You Can enter Ve dollar amount you are atlOWting b overhead In the box If you are confident Nat you can alkembe overhead items b the pamotlar poled You cah tae the WOIkaMel As a feel(if neeMdl OR 0 Idenfify your cost. Percent of Total Direct Labor Method: 3.Overhead as.a Percent of Total Direct tabor Hours To Identify overhead cast,you need the financial records for your ogamPaton Or division for the past year.Input all the cost of Me entire entity es daalled below.Line Items wHI are not deal below should be Input into the Celt marked 'offer;please Include a desorption.West you are VNng b determin,t a Percentage,therefore,W net gross up the expenses Or Inflation or to conform b tie cement War budget Next,Input LM the Cel hakew the total dlrerl labor hours pad am by your mom oraan'va5on Or Ve same pence.These figures should be Wood mare year end payroll report W ml mclude Mute which can be classified as management or a "s"We cost.flntludng Ness cost Imo IM Mehl labor hour WWI wig MODOW ffO acbM cash.)The wohsheet will compute the Overheatl as a line Item mat by diviMg Me tout projected labor hours for the contract Into the WWI Peakers,labor Mum far Me anent ne, Toil Annual Direct Labor Hours Input Total Win Worksheet on Below Owria ad yon bbor boa E Time required b complete contract Taal Assigned!Overhead Worksheet WORK AREA: Total Annual Operations Use the area below to show how you arrived at the final figure INDIRECT COSTS ORGANIZATION DEPARTMENTAL that you show as your total Overhead Management Salaries Management Payroll Tax EvDa ne Management McNeal Insurance Management Penmen Plan Expense Sales It Administrable Shades Sales It Administrative Payroll Tea Expense Sales It Administrative Medial Insurance Sales It Administrative Pension Plan Expense Office Rent Acivertaing and Public EdeoNbn Background Checks&Urroyes, Pmfessbnel&Accounting IAMit Fees Taming&worker Safety [a. Telephone Utilities Property Taxesucense sTem Dues It Sub is r efers DepreclatlorwMm builtllm DepredalNroffke eximent Repairs&MalnbmaMeoffim Cleaning and memo. _ Office Equipment Rental Office Supplies Postage&Freight Rehab Mtcdtnmus Expense Bad Debts OVhir.'• Other. Other: Other.• TOTAL INDIRECT COSTS cRF..s.(wew Met 165Y tEa% Total DAS Foam p12 J Revision 1 DAg Papa 5 Overhead Computation Sheet veuvery al rceserve VrUUUII UUPdJtJJIVI It ul^UI I III lau0LIVU acrvmea Pathway Enterprises, Inc. Project Costing Worksheet City of Aehland 2011-2012 Ashland Police Department 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 greater than the state allowed cost, please provide a detailed schedule on how you arrived at your cost per mile. Services Contract Miles Per Rate Per Daily Services per Annual Delivery Description Service Mile Cost Year Trans Cost 1 caravan $ $1 2 $. _ $ 3 ;$ - $ 4 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% DAS Form#12 J Revision 10-03 Page 6 Trans-Delivery and Margin Sheet Costing Workbook For Janitorial & Grounds Maintenance Contracts Under the Qualified Rehabilitation Facilities Program s n 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 manua{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 Ems rises'Inc;r. Project Ashland Service Center 2011-2012 Executive Director Signature: Raw Materials Per Time Use-Supplies (from supplies worksheet) -,.233:29 Equipment,Tools&Subcontracting (from small equipment worksheet) !$ 486AT Subtotal 1 •$:'• 719:46'1. Labor Direct Labor (from labor daily worksheet) '$ -_:'... :—6.6 82.9C Overhead See Overhead Worksheet Delivery Transportation (from Trans&Reserve worksheet) Is �: . --- -�• Total Before Margin $..'.- . .. . . :9403.05, Reserve Margin Held in Reserve (from Trans&Reserve worksheet) $'-. `' ".'- •600:19 Total Bid Yearly l! 10 003.24' Monthly.$. -633.60' DAS Form#12 J Revision 10-03 Page 1 Summary Sheet RAW MATERIALS Oregon Department of Administrative Services Supplies Project Costing Worksheet Pathway Enterprises, Inc. Ashland Service Center 2011-2012 ' Raw Materials: This category it often spelled out in the Request for Offer(RFO).Language such as"Items to be provided by Contactor"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 Broom and dustpan Cleaning chemicals or products Floor Wax Spray bottles Scrub brushes or scouring pads Per Use/Per Item Manufactured-Supplies Item Unit Units Needed Monthly Annual Price Per Month Cost Cost 1 Pine O Disinfectant $ 4.80 0.1666 ;$ ?"::0:80'1 i$:' '--:,9160. 2 Cream Cleanser $ 2.91 0.1666 :$: x:0:482!$:: <. =5:82 3 Glass Cleaner $ 6.29 0.1666 :$ '1•.05u 1$; -: :12.57 4 Heavy Duty Cleanser $ 4.80 0.1666 '$ 0'60.i$5°P ;91601. 8 24 oz Bottle&trigger $ 2.27 0.1666 "'_:+0!381 !$V i;'4154i 9 Acrylic Bowl Mops $ 1.71 0.5000 :$ 086:I$s` ::10.26'. 10 Scrapper W/blades $ 6.51 0.1666 3$. .? "1'.081;$C,'' 313:01*. 11 1 O Pumps $ 2.31 0.1666 '$:; t W389!$$`S 1`4!62'! 12 Paper Filter $ 21.10 0.3332 .$" ='-- "M031 I$e�•£184137,: 13 Ski Loop end Mop $ 5.65 0.3332 1. 14 24"Dust mop $ 4.26 0.1666 i$aS '.-e+40!7.11!$i,,W'x:iwiat52t 15 Doodlebug BN Pads $ 1.18 0.1666 x02011$::2i. ,,,42.361: 16 Duster-expandable $ 5.75 0.1666 i$rf- `-a0:-96! 17 Spot Away $ 2.74 0.3332 :$ 0.91?I$;-'v A0:96t 18 Cleaning Pads $ 4.70 0.1666 .$ '.:'. ,0.7812$st! --`59:40; 19 Wax Mop $ 6.80 0.1666 $ 1139,$'rw' di.73159! 20 $ 22 26 $.l: 27 30 - 31 33 $ 34 $ r"$:.5"• a: 35 $ 39 - Total 1 $. ",.19.441. :,$ 233.29: Areas:m,greeriare;formula!dhven 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 8 ' � E n ' v v r W t Y d�g > m wwwww c q Ip O O N O C U n w J N m 0 N p w c o `dd Q wwwww .I, r d d v E Z c U o w m m U O O N O O 6 O � KMH NVI S e e e e e p O b N O N N O N 6 C O d a n o 0 0 o J N O O N O C O y R ` 6 n y J ` n« ad m c o ° b N N H N ` N N i d b d « o O d b .L.. V y f O N N P N L y y J 0 `o $ _ pmmmNm e � E n � t —.c TimanE � o 0 5 0 °0 °000 OE � � j :2= `m n - O « O n� .L.. ° a y w y wwwww •...IO EO =j -i5 E a v O b d a a 10.J- T d y U 0 p 0 1O U V N E 12 s d s w €I a m �, a Z y J y5 d u @� nEdm da ° d Y QC W r w8 F _c y m eya « o E 'o m._ ilrnt a ?� � a Ta Q ww,N d UQ° o° ot`� a m 6 u °' Lclm u5 nm m25 f Edacd Eo a N °m �« E! n '25 o. � a3md cw$c agNo (v'z o. E � m � � E QQ O :5 L N O b SSC O ('r w O C 'm N J O K W O.Q D vS 3 udi >LL � m tQ � 0U W 0 U F a d N m P N ID I� m N O N h II 11 11 II II 11 II n .� E d a�nd `o y d mat c 0 u ab m LL C d a b b J_ O V_ O V d d d d c H ro_m N _ p Z m O LL b N d ❑ K r oo8s.°0000880000� a a o E �E Ki p m ° �� cEg 5O C mYwwN q0 m0 � o Q8 .E! E 5.T 17 ' Y m g m"e S a sN o § gE§ g s$ 78 �w� a°gY9 5E xxx e8 ti C °Y =g vR E°aE EL !S = So w~w« i6 03 5E5 E �ww,e = "3 p c E m -a°°' 5 O.E OE • E�°,°� a °�, 3 S"° u� E8��8� E = m N = ; e "9 cn3 xk8=°gu ° m i p 5 " Lc 3m cd Eo E E �c @ U g C t @ 6 n C o m °m �8� - -10 aE g"a L £d �so o °OOF ��, •2 9°N N F Na+ - 9x� 2 O LYNN -!W-LTT OS d9 OBE 'L $ ° C 00 s E i69- ,.gyp nT aTaOma`m n;=' l'n ' m�' y5$ OEn9a" 'Q 6oq mS3g 2L 58m $W °Eo ',.rLaSm5,.,m mt ggp E : � E EEEg ' V$a i.E? 3' '.2 ngE9 c°ry Sm� B 3S8 P� . `e ..ijE a'•3•aa'a 3� g c.".v ° E mvE $ 8- O � �°o�� " 0"` g3 � E� no mm 8 ` " � � E � goa - .- 6 a° E E E N« Sin m' in w' m ' w' 6 F $ q > q 0 0 4= • OVERHEAD the.Department of Administagve servlue Overhead Gosh Protect Costing Worksheet Pathway Erm prls Ashland Service Center 2011-2012 There are marry OiHerent ways organizations allocate overhead Internally(e.g.,Percent of total costs,dollar figure sum,as a percent of direct labor,etc). In the space provltletl 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) FILL IN ONLY ONE OF THE THREE METHODS DETAILED BELOW! Percent of Total Cost Method: For every dmiar spent pmdudne a fire)product,tar pmW&g a swrWs.a certain percomme W Nat"ar h 1. Enter Overhead as aPercent of Total Costs required for overhead.To calculate the overhead percentage.It is best up Were launch records for your organtzatlon that go back a year or more,Add together the expenditures that make up Me overhad cost(am workshcet Deem). Now add this figure Wthe Raw matelots.Direct labor am Delivery for a btal cost DWide me egwe for overhead by the fil for total costa.The resua is a lxn'ad but repraenh ovemead as percentage of the Who cost it Wooden records are and amizMe aema @ale ovembed minimal as that you OR can,estimate other costs as best you con,am hue the same formula W gel a percentage. 2. Enter Allocated Overhead as a Dollar-Figure Sum Dollar-Figure Sum Method: You can enter the dollar amount you are allopWirg us balanced In the box If you are comment Nat you can aMwts overhead Items to this paNa/ar lxotact You Win use the WOM1Smet be a taW Of model) OR 0 Identify your cosh s.Overhead as a Percent of Total Direct Labor Hours Percent of Total Direct Labor Method: To identN wormusd cysts,you reed the financial records for yorargar aon or dhnnon far the past year.Input all Me vests of the entire enety,as detailed below.LUhe items which we cot detailed below should be Input into me cells marketl W htY;please Include a description.What you are byhg W determine is a percentage,theretom.do not gross ob Ua mhparees for Inaallon or to wmorm 0 f cunent year budget Next,Input Inb f cad below the total direct Tabor Mum pall out by your entire organization for the same pere d.These figures should be found on its your sM painful report De not Include hws Much can be coasted a management or admhYmtawe cosh.(Inrludcng Same posts Imo the cur act labor hour WWI wilt tlehte the actual cosh.)The worksheet will compute the overhead es a line Item cost by dNdkg me WWI royWted labor hours for the contract Into the tom projected labor Mum for Me cnnent war. Total Amami Direct Lehr homes Input Total from Worksheet on Below Overhead Per labor Mur i Time rewired W complete contract --3 Total Assigned Overhead Worksheet WORK AREA: Total Annual Operations Use the area below to show how you arrived at the final figure INDIRECT COSTS OROANI2ATION DEPARTMENTAL that you show as your total Overhead Management Salaries Management Payroll Tax Expersa Management Medical Ins. Management Pension Plan Expense Sales 8 Adminaba ye Saimes Sales 8 Admiristaave Payroll Tax Expense Sees 6 Administrator Mori Insurance Sales 8 Administrative Pemlon Plan gushes Office Rent Advemshg and Public Education 8a04morN Checks 8 urnmyhis Professbml a Acmrmkrg I Audit Fees Training a Worker Safety Insumece Telephone UWW. Prepeny TaxaAkem sl as Dues It Bothersome DepmclmlonoHice building Depredauorrof ice equlpment Repairs 8 MWnterwhcaonice Clearing and Malntchnce Office Equipment Rental Office Supplies Postage at Freight Rehab Misceltammhs Expeme Ir Bad Debts Other:-::: ' Other.;:-. Other.•r..,s s TOTAL INDIRECT C%FWeM1On BIBIr MI,YV) ta% track Total If '- DAS Form x12 J Revision 1003 Page 5 O+erhead Composition Btleal ueuvery at rceserve vregon uepartmenr or Namimscraave aervices Pathway Enterprises, Inc. Project Costing Worksheet Ashland Service Center 2011-2012 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 greater than the state allowed cost, please provide a detailed schedule on how you arrived at your cost per mile. Services Contract Miles Per Rate Per Daily Services per Annual Delivery Description Service Mile Cost Year Trans Cost 1 caravan 2 3 4 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% DAS Form#12 J Revision 10-03 Page 6 Trans-Delivery and Margin Sheet Costing Workbook" For Janitorial & Grounds Maintenance Contracts Under the Qualified Rehabilitation Facilities Program .4� 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 lPathwav Ente rises,anc.- - Project 10tv of Ashland 201.1-2012 Street and Shop Executive Director Signature: Raw Materials Per Time Use-Supplies (from supplies worksheet) $ .::. 134.25 Equipment,Tools&Subcontracting (from small equipment worksheet) !$ -= - .486:17- Subtotal t i$ .620.41, Labor Direct Labor (from labor daily worksheet) Overhead See Overhead Worksheet $ 890.16. Delivery Transportation (from Trans&Reserve worksheet) Total Before Margini 4,183:75: Reserve Margin Held in Reserve (from Trans&Reserve worksheet) '$ "? '•267:05: Total Bid Yearly�$�`": -: .A'450:80 Monthly:$.. 7 370.90. DAS Form#12 J Revision 10-03 Page i Summary Sheet - RAW MATERIALS Oregon Department of Administrative Services Supplies Project Costing Worksheet Pathway Enterprises, Inc. • Citv of Ashland 2011-2012 Street and Shop • Raw Materials: This category is often spelled out in the Request for Offer(RFO).Language such as"Items to be provided by Comractdr"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 Broom and dustpan Cleaning chemicals or products Floor Wax Spray bottles Scrub brushes or scouring pads Per Use/Per Item Manufactured-Supplies Item Unit Units Needed Monthly Annual Price Per Month Cost Cost 1 Pine Q Disinfectant $ 4.80 0.0833 1$-'.i'`,V,,0!400 i$ %Atr-,�4= 2 Cream Cleanser $ 2.91 0.0833 1$5=t:- c10i2411$s;:fiC".i2!91. 3 Glass Cleaner $ 6.29 0.0833 .$'- ;"zV521 i$t5'r= :629:. 4 Heavy Duty Cleanser $ 4.80 0.0833 t$: . A0`40S 6$Yri;",sc4E80i 5 Oder Counteractant $ 30.65 !$'.�-•rn i r�i l$C1itttC t <+ 6 Carpet Lane $ 5.00 7 Carpet Shampoo $ 13.01 8 Emulsifier Extract $ 2.27 f$�,`saaplid?ai €I$19mRr�t 9 Acrylic Bowl Mops $ 1.71 0.1666 1$-I:"�vk1t0:28t 1$)a'lft,,73i421 10 Scrapper W/blades $ 6.51 0.0833 I$f:^'S 'y0154I',$'P64= 296!511 11 1 OZ Pumps $ 2.31 0.0833 $rS;:§e:U[05191 l$.L4'&x52!31; 12 Paper Filter $ 21.10 0.1666 1$a-Ii'MD3!5211 I$IIW..-e42S18t 13 Std Loop end Mop $ 5.65 0.1666 9$ i?;1•;�:iPa0!9411$PL&B!tl1 E30i 14 24"Dust mop $ 4.26 0.0833 *10'351 1$ :!r'74126? 15 Doodlebug BN Pads $ 1.18 0.1666 =3:13A=01 9$51ka-r2 Qt2i& 16 Duster-expandable $ 5.75 0.1666 ;$Y .:w:v4A-0!961 t$Wk,. 11i50; 17 Spot Away $ 2.74 0.3332 ;$e:'>."'."J40l9111$R:i++.:+ia10!96s 18 24 oz botdelw trigger $ 4.70 0.0833 ?$"tsti�ic'.SO'39k i$1:".i't ;�4"70i 19 Wax mop $ 6.80 0.0833 ?$'f',? !10!57d i$1?S.�r%6°.80t 20 Cleaning Pads $ 4.59 0.1666 4,-:P1 I$>r.D.ti'a:9518i 24 $ .$a: 25 30 4V1 32 35 39 40 M- 91 Total $• ; Ii.ingi 1$1;;,. Xveas;n,green a e forrnula.dnven Monthly Cost= Monthly cost is computed by multiplying the total unit cast by the units needed per month. Annual Cost=Annual cost is computed by monthly cost times 12 months. DAB Form#12 J Revision 10-03 Page 2 Supplies Sheet N 18 C E 77 77 N m N ` c - n0000 -1 O d q y O O N m C U d O N t0 m m tO m ' m E u d i c U i i, x ; m F d d Z p O H N U m C U d p N u O m °oouoi o dU m °m N J mwwwn,-,? ydj d O N N O N � O O IL•° c 0 d D 't f� N I C O N t7 O O N O n wwwww fi o p d oim °v\io �°\i� r i a ?. Ei rno � N �nm v ,. m ° @ a e i 2 sv�a"1!'N N C N N N N N N N N N N N N N N N L r 6 V C U O - f � f c w w EoJ c d d .t-. y m.. rmimeminM L d L 'Z E n o .E E y E w v t m c --c ulna Eu `o E a d c o 000 °a moo 'h'n on y o j•cp E •ri• O W �' U V N O N ''i Q O N N >i U � V D U O U n p�'C O O po m m V d I J C O C 3 E L E N G d N WN € D m •� Td J Nm NNU OWN 2mNN Na yNj {i.d1N = d6t 4Cd J 4y d O i c-. a y E d N E d o s d o d ns K $ E'an dyu osoa cm � c cauS, n � a W 1- N E °1 j i o E O W m 3 = elm o D uw D D >•D ?� W n>•o afJ w E N o `2Um y�` me c v W n E an; d on u¢0 N+ t O $ E d O C 0 «�m? nnO N OU W UU 6d n E H Wad N o'� o m m r m m o N m a n ii n n n n n m t g� NK !d's o' uj o o � w d yN 19 > y U d U C C > V 7 n m 6 E > J a E y D 2 c � EN a�n�O o d d may} c n 6 OI Il d O W N J_ O F C N@ .L..C G>• R 3 N C d O N Ol 5 m� n O D -0 mFa 0 =- OZ m m LL N Q N Sao o� . ............. E . . .6. r 2 spa j5 E o ma E S E E 'E Ux E HA tu- 3 t z x E c E $E ,n8 ag 0 . wF S I J, J ts o EW N -2 -E r5aR em A go -E l I j bad 11 JJ R E E Sa SEE Eo 2 8 0 C 6 wl .5 g _E E E € S E 'ds E E E OE S2 4 -40 C C. e -.0 A s-6 ; §�k E E 0 A saH & 0. 80 Em E .0 E oSXE - 2.6 15 E E-2 rc cE Bp - - -J, -g 9 i e E E E I a -fle - - 6 1 E 4g E 25 E 12 . .. . ... RE �z 0 S E -L A VE El ":d - E E E Eg BE 3 'Cf33 E° 2,c 0. L 9 . - IE P: e= 2219,1 m Z Z as op L 0 OVERHEAD Oregon Depanmentof AdmhJnrative services 0,mmeae COSts Project Coning WodrsM1aet Pathway EnW xIs City of Ashland 2011-2012 Street and Slop Thar¢era marry diHarant ways organizations allocate overhead internally(e.g.,Percent of total costs,dollar figure sum,as a percent of direct labor,etc). In the space provid¢d 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) FILL IN ONLY ONE OF THE THREE METHODS DETAILED BELOW! Percent of Total Cost Method: For every dollar spwd produmg a final prodol,or providing a service,a urban percentage of eat Wn.W 1. Enter Overhead as a.Pereant of Total Costs reautred brovemead.To ralcwate ure ovemead permnmge,it t best b have fimrola records br yme 20Wh crpaniralim that on Cask a year or more.Add together be committees let make up the m,m ead coat(eee wOhsheet belowl.How atld is(pure to the Raw mob tat,Direct labor and Delivery for a total cost Divide be figure far overhead by the figure for total cost.Tice resin U a pemere Mat represent overhead as a percentage of Me tool cost it mwxia records are an available esumaw ace overhead expenses es best sou OR can•estimate other costs as east you can,amuse the same famona b get a mcendage. 2. Enter Allocated Overhead as a Dollar-Figure Sum Dollar-Figure Sum Method: You urn enter the dollar amount yen are allocating 0 overhead In Me box If you are confident chat We can slants Overhead Items be No Damodar project You urn use the WUhkeMet ffi a tool(If neence) OR to Identify met. 3.Overhead as a Percent of Total Direct Labor Hours Percent of Total Direct Labor Method: To identry overhead cost.xlu med Me finamed remMs bur your orgambrocan or div6bn for the past year.Input as me mere of the emrs entity as Widened below.Dne items which are rot devilled below VouM be irgut into the Walt marked -other;please Include a description.What you are Wn,b round he Is a pere"ge,modem,do mt gross up the expenses for Inflation or to conform b 0e current year budget Next.Input Into Me cell blow the bbl direct labor lours paM out by wur were organeabon for the some period.Them figures should be found on he year eM peyron turn Do not Include toes which can be classified as management or admins"he nest.including Corse cost inro tie direct labor lour ball MO deflate the azbel cost.)The wOrI sibeet will mm"Me overhead as a One Item..by divMhg th tots rocacti labor hours for the contract into the bbl tercieved labor Mum he Me mgeM yew. Total Annual Deed Labor Rows Input Total from Workstmet on Below Overhead per labor lour S - T.rmuiretl b complete contract '1 Total Assigned Ovoread $'y Worksheet WORK AREA: Total Annual Operations Use the area below to show how you arrived at the final figure INDIRECTCOSTS ORGANIZATION DEPARTMENTAL that you show as your total Overhead Management Salaries Management Payroll Tax Deems Management Medlcel Imumnce sales&A4N Person Awn Experhm Salles b mlristraWe wades Sales&AdmlasltraWe Payroll Tax Erne Sales&A&IMMlls ive Medical Insurance Sales 8 AdNhistrative Pembn Plan Expense Once Rent Advertising era Public Ednclbn BackgrrouM Chicks S k U s P ,nel Accounting I Audit Fees Thwartp 8 Wo rWar sent, Iruhca TelepM ere re Utilities Progeny Taxcrimo nseslFeee Deesaabxdce od Is Decmdaawromm bhgding Repaint rkeeanam"mce, Repairs 8 m Malutomme to Off.Esip Mnt Rental Office Equipment Renal Omen swWe Postage 6 Freight Rehab Mtcellts Expense Debts Outer.-- ONe it Ocher k, TOTAL INDIRECT COSTS ' 3- � .;S• Wl Feblonaw hew eecd 1M Iass mn1m 1,1eewrtcliftz l Total s DAS Form e12 J Rterlslon 1603 Papa 5 Overhead Computation Sheet uenvery a rreserve vregon uepartment or Aamimstraave services Pathway Enterprises, Inc. Project Costing Worksheet City,df Ashland 2011-2012 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 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. Services Contract Miles Per Rate Per Daily Services per Annual Delivery Description Service Mile Cost Year Trans Cost 1 caravan $: :'. . . . . _$. . :, 3 $ $ 4 $ $ $ $ a 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" 1 6.0% DAS Form#12 J Revision 10-03 Page 6 Trans-Delivery and Margin Sheet Costing Workbook For Janitorial & Grounds Maintenance Contracts Under the Qualified Rehabilitation Facilities Program r 3� 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 Ente rises,Inc. . - Project Ci of Ashland-The Grove 201,1-2012 _ Executive Director Signature: Raw Materials Per Time Use-Supplies (from supplies worksheet) $ 233:29 Equipment,Tools&Subcontracting (from small equipment worksheet) I$ . A—I 486.:17 Subtotal $ Labor Direct Labor (from labor daily worksheet) Overhead See Overhead Worksheet $` .-: - 2;121:06: Delivery Transportation (from Trans&Reserve worksheet) Total Before Margin Reserve Margin Held in Reserve (from Trans&Reserve worksheet) '$- 636.32' Total Bid Yearly 6$:' 10 605:31. Monthly:$. : : _' :883.78! DAS Form#12 J Revision 10-03 Page 1 Summary Sheet RAW MATERIALS Oregon Department of Administrable Services Supplies Project Costing Worksheet Pathway Enterprises, Inc. Cify of Ashland The Grove 2011-2012 Raw Materials: This catggory 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. A custodial contract,for example,may require the following for month-Supplies: Paper products and soap Broom and dustpan Cleaning chemicals or products Floor Wax Spray bottles Scrub brushes or scouring pads Per Use/Per Item Manufactured-Supplies Item Unit Units Needed Monthly Annual Price Per Month Cost Cost 1 Pine 0 Disinfectant $ 4.80 0.1666 $ 0.801!$'t�:ai>6irA9!60> 2 Cream Cleanser $ 2.91 0.1666 ^$ .I- 0481'$°:uui ':;15!82[ 3Glass Cleaner $ 6.29 0.1666 :$'.:.:;-:-'a1i051 I$A?d 'IA12!57i 4 Heavy Duty Cleanser $ 4.80 0.1666 ;$V: !.t 2,,10!801 1$2'kzisrr"A9:60a 8 24 oz Bottle&trigger $ 2.27 0.1666 t$J„ra{;; 0!38➢l$1exf9°.54;' 9Acrylic Bowl Mops $ 1.71 0.5000 ;$S'i;iiNi-10!8611$E'?:"r?;;t1026i 10 Scrapper W/blades $ 6.51 0.1666 i$--A," V081 I$e4;' `A3A1ir 11 !OZ Pumps $ 2.31 0.1666 i:a,AVW38C 1$"-"V'Su4!62➢ 12 Paper Filter $ 21.10 0.3332 $ x.�..6'i.'t7!031 I$?£e!stdir84}3Z: 13 Std Loop end Mop $ 5.65 0.3332 !$s -;�tlf881 1$15 :ei622!59L 14 24"Dust mop $ 4.26 0.1666 ;$fl;:/ iYO}7.11 15 Doodlebug BN Pads $ 1.18 0.1666 $ni'yi0`20➢!$ir`; �i;32E36r 16 Duster-expandable $ 5.75 0.1666 t$tc.c =40!96➢1$'!* hL�dld°.SOi. 17 Spot Away $ 2.74 0.3332 '$rir.-i::-%- 0.911 1$�---;'00196: 18 Cleaning Pads $ 4.70 0.1886 $ -^ 0.'7W l$zn: .::9:406. 19 Wax Mop $ 6.80 0.1666 J031 l$%' ',13:59 i 21 25 $! 4 1$1-11' : t-:.>... 27 $ x I$➢ eY. 29 31 33 35 391 1 401 1 Total 11 19.4411$ ''; 233:29: Areas in green are c!rmula'driven _ 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. i DAS Form#12 J Rpvicinn 1n_n3 Pane 2 Suonlirs Sheet y H v E A m n y O � d ty w d N O q _C y A J N m m m m m c m ° d m0 NHHww. ! w � d d U E b O� ^ O Od 0 o H O A y ° U U A m m Q N • V p 1^O O O N O b V C - � wwwww. ° M O N N O N a� T c 0 v a n o 0 0 0 J o m O O N O t C ° d Ol O C u I 5 !1 TA N HHHNw -;y _i y 'O p y 17 t7 t7 N m . Fi N r .v Nkl t o y v A 19 f N N N N N N N N N N N N N N NL., a A° -N q ai EoDo d d r 0 0 t7 N m tJ m R d J 0 .6 ° —c is o f ° E a ° o00000 1'v m5ga m `w °o °om °o ,n ca y ���ll Tpc E a C 'O HHHNw -IV COVdd N ' E a y d d a dal T m M" m °v l� n S is ti S O _ 3 0 E N _ €I� � c � o c v c 12° C Q Q a e - N 0 C L N 6 d y .0 41 U -IN �.Fcm y�a �� Ta nL :'A:E i4J V � � c p cc EL EDn qq+ u ° � ev QdJ c 'Ciro !_^ E E .y. ¢ _c E C o a' LA, o f J w Q Ju c i0 }I`�v o a Ti a E a Q cwt w U5 0° mtzq cc° >u v 1�- -t d o aw av a am u a13 � no m ' jY °� m E Enm� ° P D U W U 2 U II 11 II 11 11 II C C d A A �- d 0 y O -E O Z:g n E .E 8y ac 3 5 y � 'ram TA .2 m cd .o d ` E c v c°cud o O O °y F m m N = Q 2 m O O 0 1 LLm a .� Q C SE S 0 N 2 i g. Z �E E E E E E R J'8 g 8m uu E E 9 SE E E E Jig E KH, 9, E E E 2P I cn E E sY -E BE -E z ZJ E E' K! 2 glt E ag 0 2 TEk wpm —.- U= L e rO E 0. 20 0 0 3 S -0 ZR t�En 0 Rm 5E E 2 L c I= - 2 . 8 8 Sw` CclO9u&E5� 8 EN c°E EL me EA E EE E % a' e o. o o ga E P: C5 . . . H 3: 8 0 PL . . . . . . . . . . . . ioopo5f o =9 : ; s E ♦ OVERHEAD Overhead casts Dragon Department ofjectCotra SaMest Project Gosling WoMaM1aN Pathway Enbrorls City of ASNaM The Grove 2011-2012 There are mayty tll�drert ways organizations allocate overhead internally(e.g.,Percent of total costs,dollar figure sum,as a percent of direct labor,etc). In the space providetl 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) FILL IN ONLY ONE OF THE THREE METHODS DETAILED BELOW! Percent of Total Cost Method: Far every dollar spent pro dutliq a final product.or providing a service,a cerMln percentage of tint dolor Is 1. Enter Overhead Base Percent of Total Costs me load for overhead.To calculate Me overlwad parcenmpe,it is best to have flnandal records for your 20.pp.A cgencatbn Mat go back a yes,or more.Add together the expendhaes Mal make up Me overhead cost(see _sairsetbebw).Now add Vis figrrem Va Rex matodab.DlM lobar and DelWeryfara m181 cost Divides eafigureforovermadbythefgurebrmmicosb.Then Wlsaper mairepres overhe ma percentage of the total cost. If finermal records are rat available estmam Me overhead expenses as best you OR can,esamate other costs as best you can,and use Inn same formula m get a percentage. 2. Enter Allocated Overhead as a Dollar-Fig ore Sum r� Dollar-Figure Sum Method: 1 ' You can enter pM dollar amount you we opposing to overhead In Me box if)vu&e confident Wt you can allocate overhead Items to this particular project.You can use the Wonsheel as a mot(If needed) OR m identify your costs. a.Overhead as a Percent of Total Direct tabor Hours. Percent of Total Direct Labor Method: To Identify ovemead costs,you need Me findumbal become for your orgaNZatmn or division for the past your.Input al the costs of Me emte entity as reaped below.urns items which s,e rot detailed below should he Input Into the calls marked 'other:please Include a desotiffli What you are tying m Mia mire b a percentage,therefore,des not gmss so the expanses for 1.01mi ,or to conform to Me carer year budget Next,Input Into Me cell for Me real direct labor aura paid out by your entire organlzotlon for Me some period.These figures should be bound on Me year end Wymll report.Do rot Induce home which can be daunted as management or adminfives ve wsb,flncludrg these costs Into the cl ect labor houb mtal wig depate the sound ocide I The wohshaetash comput,Me overhhWd as a pce then cost by chrome the food roMetl labor hours for the contact lMa the tope projected labor hours for to tom0nd War. Total Annual DIM tabor Hours Input Total from Worksheet on Set. Ovehead per labor hour Time required 0 complete coreM Total Assigned Ovemoad 5 Worksheet WORK AREA: Total Annual Operations Use the area below to show how you arrived at the final figure INDIRELTCOSTS offi;AfIZ,TIONI DEPARTMENTAL that you show as your total Overhead Management Salaries Management Payroll T.Expense Management Mad W I Imu2nce Mmags Tai Peekm Plan Expanse Sales 8 Adminlstalve aside, Sales 8 Adommstrefive Payroll Trot Expense Salo 8 Administrative MMCaI Insurance Sales 8 AdmlYSbative Pension Plan Expense Office Rent Advertising and Public Education Background ldraga checks 8 DdnaAsb Profning It lokttolnbg/Audit Fees Insurance eWorker Safely Telephone Telephone pe Propert y srpmes esF e Dues Subscriptions Deprec laorwfice upg Depreda t Ceequtipmeut Repais 8 Mcemb a Clece arat Ma intenance Office Equipment Rental Office Postage Is F ei Refuse 6 Freight Rehab BadDbt Expose Bad Debt Omer.• - - i Otlxr. Omer:' Omer.' TOTAL INDIRECT COSTS S w FCbevn&9(rMlbt I t.Me fi�.s.aemmm® dsbfic Total a I DAS Form a12 J Revision 111-09 Page 5 Overhead Computation Sheet vGU V er y a rceser ve uregon uepartmenr or Aamimsrraave services Pathway Enterprises, Inc. Project Costing Worksheet City of Ashland The Grove 2011-2012 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 0 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. Services Contract Miles Per Rate Per Daily Services per Annual Delivery Description Service Mile Cost Year Trans Cost 1 caravan $ $ 2 $ $ 3 $ :$ 4 $ $ 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% I I, DAS Form#12 J Revision 10-03 Page 6 Trans-Delivery and Margin Sheet