Loading...
HomeMy WebLinkAbout2014-197 Contract - Pathway Enterprises Contract for Janitorial Services - Ashland Parks & Recreation CITY OF CONTRACTOR: Pathway Enterprises, Inc. -ASHLAND CONTACT: Richard Simpson, Contract Services Director 20 East Main Street Ashland, Oregon 97520 ADDRESS: 1600 Skypark Drive, Suite 101 Telephone: 541/488-6002 Medford, Oregon 97504 Fax: 544/488-5311 TELEPHONE: 541-973-2728 DATE AGREEMENT PREPARED: Jul 8, 2014 FAX: 541-973-2729 BEGINNING DATE: Jul 2, 2014 COMPLETION DATE: June 30, 2015 COMPENSATION: $55,392.24 per pricing proposal and costing workbook attached as Exhibit C. GOODS AND SERVICES TO BE PROVIDED: Janitorial services for Pioneer Hall, Community Center, Parks Office, Nature Center, Senior Center, and Oak Knoll Pro Shop per pricing proposal and costing workbook attached as Exhibit C. Approved by City Council July 1, 2014. 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 the compensation stated above, 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 27913.220, 27913.225, 27913.230, 27913.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 $20,142.20 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 b City under an of the follow in Contract for Janitorial Services, Revised 07/08/2014, Page 1 of 5 conditions: i. If City funding from federal, state, county or other sources is not obtained and continued at levels 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. Contract for Janitorial Services, Revised 07/08/2014, Page 2 of 5 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 insurer(s) to the City. e. Additional Insured/Certificates of Insurance. Contractor shall name The City of Ashland, Oregon, and its elected officials, officers and employees as Additional Insureds on any insurance policies required herein but only with respect to 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. Contract n CiV.of Ashland By ` By > ux s 9: ° S nature Department Head Print Name Print Name Title Date Please submit a W-9 with the signed contract. Purchase Order No. Contract for Janitorial Services, Revised 07/08/2014, 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. ✓ (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. d/ (6) 1 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. Contracto (Dat ) Contract for Janitorial Services, Revised 07/08/2014, Page 4 of 5 ® DATE (MM/DD/YYYY) CERTIFICATE OF LIABILITY INSURANCE 6/26/2014 THIS CERTIFICATE IS ISSUED AS A MATTER OF INFORMATION ONLY AND CONFERS NO RIGHTS UPON THE CERTIFICATE HOLDER. THIS CERTIFICATE DOES NOT AFFIRMATIVELY OR NEGATIVELY AMEND, EXTEND OR ALTER THE COVERAGE AFFORDED BY THE POLICIES BELOW. THIS CERTIFICATE OF INSURANCE DOES NOT CONSTITUTE A CONTRACT BETWEEN THE ISSUING INSURER(S), AUTHORIZED REPRESENTATIVE OR PRODUCER, AND THE CERTIFICATE HOLDER. IMPORTANT: If the certificate holder is an ADDITIONAL INSURED, the policy(ies) must be endorsed. If SUBROGATION IS WAIVED, subject to the terms and conditions of the policy, certain policies may require an endorsement. A statement on this certificate does not confer rights to the certificate holder in lieu of such endorsement(s). PRODUCER NAMEACT Marcene Forney Ashland Insurance Inc PHONE (541) 857-0679 FAX , (541) 857-9883 (A/C No Fxtl, (AIC 801 O'Hare Parkway, Ste 101 -ADDRESS* MImarcenef@ashlandinsurance.com INSURERS AFFORDING COVERAGE NAIC # Medford OR 97504 INSURERANew Hampshire Insurance Co INSURED INSURER B :SAIF Corporation Pathway Enterprises, Inc. INSURER C:Philadel hia Insurance 3850 1600 Skypark Drive, Suite #101 INSURER D: INSURER E : Medford OR 97504 INSURER F: COVERAGES CERTIFICATE NUMBER:CL1462604889 REVISION NUMBER: THIS IS TO CERTIFY THAT 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. LIMITS SHOWN MAY HAVE BEEN REDUCED BY PAID CLAIMS. INSR ADDL SUBR POLICY EFF POLICY EXP LIMITS LTR TYPE OF INSURANCE WAR VJVD POLICY NUMBER MMIDDIYYYY MM/DD/YYYY GENERAL LIABILITY EACH OCCURRENCE $ 1,000,000 DAMAGE T RENTED 100,000 X COMMERCIAL GENERAL LIABILITY PREMISES Ea occurrence $ A CLAIMS-MADE OCCUR 1LX0240593930000 /1/2014 /1/2015 M ED EXP (Any one person) $ 5,000 PERSONAL & ADV INJURY $ 1,000,000 GENERAL AGGREGATE $ 3,000,000 GEN'L AGGREGATE LIMIT APPLIES PER: PRODUCTS - COMP/OP AGG $ 3,000,000 X POLICY PRO LOC $ .IFrT AUTOMOBILE LIABILITY Ea aBINEDISINGLE LIMIT 1,000,000 X ANY AUTO BODILY INJURY (Per person) $ `L ALL OWNED SCHEDULED 1CA0645980540000 /1/2014 /1/2015 BOOILY INJURY (Per accident) $ AUTOS AUTOS NON-OWNED PROPERTY DAMAGE $ Per accident HIRED AUTOS AUTOS Uninsuredmotoristcombined $ 1 000,000 X UMBRELLA LIAB HOCCUR EACH OCCURRENCE $ 3,000,000 A EXCESS LIAB CLAIMS-MADE AGGREGATE $ DED RETENTION lUD0428658860000 /1/2014 /1/2015 $ B WORKERS COMPENSATION W C STATU- O'H- fL- AND EMPLOYERS' LIABILITY Y I N ANY PROPRIETOR/PARTNER/EXECUTIVE ❑ N / A E.L. EACH ACCIDENT $ 500,000 OFFICER/MEMBER EXCLUDED? 24679 /1/2014 /1/2015 E.L. DISEASE - EA EMPLOYE $ 500,000 (Mandatory in NH) If yes, describe under D ESC RIPTION OF OPERATIONS below E.L. DISEASE -POLICY LIMIT $ 500,000 C Professional Liability HSD843162 /1/2014 /1/2015 Aggregate Limit 3,000,000 Occurrence per incident 1,000,000 DESCRIPTION OF OPERATIONS I LOCATIONS I VEHICLES (Attach ACORD 101, Additional Remarks Schedule, If more space is required) CT # 627 CERTIFICATE HOLDER CANCELLATION SHOULD ANY OF THE ABOVE DESCRIBED POLICIES BE CANCELLED BEFORE THE EXPIRATION DATE THEREOF, NOTICE WILL BE DELIVERED IN ACCORDANCE WITH THE POLICY PROVISIONS. City of Ashland Attn : Accounts Payable AUTHORIZED REPRESENTATIVE 20 E Main St Ashland, OR 97520 Marcene Forney/MARC ACORD 25 (2010/05) ©1988-2010 ACORD CORPORATION. All rights reserved. INSO25 r7mnn.t ni Tho Arr)Pn nmmg% nnrl Innn me rcnichcrcrl morkc of Annon i AIM% ISSA rEntet-1---wises- rye, ai ! Rebecca Simpson; CEO June 3, 2014 Rachel Dials Recreation Superintendent City of Ashland 340 S. Pioneer Street Ashland, OR 97520 Ms. Dials, I have prepared our janitorial service pricing proposal for the City of Ashland Parks based on the upcoming living wage of $14.42 per hour. I have incorporated additional items that we have been performing but have not included in our past costing. Specifically, I included the following: 1. High speed burnishing the Community Center weekly (52 hours + supplies) 2. High speed burnishing the Pioneer Center twice monthly (24 hours + supplies) 3. High speed burnishing the Senior Center twice monthly (24 hours + supplies) 4. Additional cleaning in the Nature Center due to increased size (15 minutes added per service) I propose that our price increase from $51,504.12 to $55,392.24 for a total annual increase of $3,888.12. The updated changes for 2014-2015 services are as follows - Monthly 2013-2014 2014 - 2015 Pioneer Hall & Community Ctr 1637.64 1662.13 Parks Office 422.4 428.58 Nature Center 324.45 381.57 Senior Center 1308.27 1373.80 Oak Knoll Pro Shop 266.77 270.22 Carpet and Hard Floors 332.48 499.72 Difference Total 4,292.01 4,616.02 324.01 i IVEEnterprises. I nc.- Rebecca Simpson; CEO Annual 2013-2014 2014-2015 Pioneer Hall & Community Ctr 19,651.68 19,945.56 Parks Office 5,068.8 5,142.96 Nature Center 3,893.4 4,578.84 Senior Center 15,699.24 16,485.6 Oak Knoll Pro Shop 3,201.24 3,242.64 Carpet and Hard Floors 3,989.76 5,996.64 Difference Total 51,504.12 55,392.24 3,888.12 In total we propose an increase of 7.55% for our current services. 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 the people of the City of Ashland. Sincerely, Richard Simpson Contract Services Director Pathway Enterprises, Inc. 1600 Skypark Drive, Suite 101 Medford, OR 97504 Office (541) 973-2728 Cell (541) 601-4550 Fax (541) 973-2729 4 F i y • I ~y 41 ~ • t I M w I I DEPARTMENT OF ADMINISTRATIVE SERVICES Request for Price Approval For Janitorial Services , Contract # (Product or Service) Total Price: $ 55.392.24 , per year (month, year, each, doz.) Requesting Agency: Ashland Parks & Recreation Requesting QRF: Path3m Ente riser= Tnc. Agency and QRF agree the proposed price and supporting documentation meets the requirements of OAR-125-055-0030. date: Z Authorized Agency Signature Contact: Kati Olson. Purc , kari_olson(@a~hlandor.us , phone #541-488-5354 Email Address ` r ^ f ti~ date: 71171 Z6 14 Authorized QRF igaatwre phone # 4 r - t110 t Email Address DAS has reviewed the submitted documentation supporting the price offered by the QRF and approves the price for procurement of the ab -stated produc r service in accordance with OAR 125-055-0030. Z - , date: Z J AS Coordinator ' 3/19/2013 Costing Workbook For Janitorial & Grounds Maintenance Contracts Under the ; n li i Rehabilitation Facilities Program rt1 OF 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 07302007 Project Costing Worksheet The summary sheet is linked to the other sheets in this workbook. Any area shaded in light green is either a formula or linked to another work sheet. The only manual input to this sheet will be to input the QRF name. The costs are to be divided into five categories: Raw Materials, Labor, Overhead, Delivery and Reserve Costs. Raw materials consist of supplies, small equipment & tools, and large or special equipment. Each category is detailed on the following sheets. Labor costs is direct labor used to produce or service the contract. Overhead costs is a line item charge which is computed on the overhead sheet. Transportation or delivery and reserve computations are also completed on the following sheets. All these costs will vary depending upon your organization and the specifications for the project. Each sheet will have an example calculation and further instructions for completion. QRF Name Pathwa Enter rises Inc. Project Ci of Ashland Parks and Recreation Nature Center 13-14 Executive Director Signature: Raw Materials Per Time Use - Supplies (from supplies worksheet) Is 332.16 Equipment, Tools & Subcontracting (from small equipment worksheet) $ 44.03 Subtotal1 $ 376.19 Labor Direct Labor (from labor daily worksheet) $ 3,149.55 Overhead See Overhead Worksheet r$ 778.41 Delivery Transportation (from Trans & Reserve worksheet) $ Total Before Margin $ 4,304.14 Reserve Margin Held in Reserve (from Trans & Reserve worksheet) $ 274.73 Total Bid Yearly $ 4,578.87 Monthly $ 381.57 DAS Form #12 J Summary Sheet Revision 10-03 Pagel RAW MATERIALS Oregon Department of Administrative Services Supplies Project Costing Worksheet Pathway Enterprises Inc. Cit of Ashland Parks and Recreation Nature Center 13-14 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 Use/Per Item Manufactured - Supplies Item Unit Units Needed Monthly Annual Price Per Month Cost Cost 1 SCRUBBING SPONGES $ 1.36 1.0000 $ 1.36 $ 16.32 2 CREAM CLEANSER $ 3.06 0.5000 $ 1.53 $ 18.36 3 #66 DISINFECTANT CLEANER $ 42.40 0.0500 $ 2.12 $ 25.44 4 #64 NUETRAL CLEANER $ 88.00 0.0500 $ 4.40 $ 52.80 5 #70 WASHROOM CLEANER $ 97.44 0.0250 $ 2.44 $ 29.23 6 #61 GLASS CLEANER $ 85.20 0.0250 $ 2.13 $ 25.56 7 UTILITY BRUSH $ 2.74 0.0840 $ 0.23 $ 2.76 8 ANGLER BROOM $ 6.27 0.0840 $ 0.53 $ 6.32 9 TOILET SCRUB BRUSH $ 4.35 0.0840 $ 0.37 $ 4.38 10 VINYL GLOVES LARGE $ 9.89 0.3000 $ 2.97 $ 35.60 11 LAMBSWOOL DUSTER $ 4.90 0.0840 $ 0.41 $ 4.94 12 DUSTPAN $ 2.52 0.0840 $ 0.21 $ 2.54 13 $ $ 14 $ $ 15 $ $ 16 $ $ 17 SPRAY BOTTLES $ 1.90 0.2500 $ 0.48 $ 5.70 18 MOP HANDLE $ 6.29 0.0840 $ 0.53 $ 6.34 19 LARGE MOP HEADS $ 5.20 0.3300 $ 1.72 $ 20.59 20 ORANGE GEL EXTREME $ 8.27 0.2000 $ 1.65 $ 19.85 21 14" WINDOW SQUEEJIE $ 8.95 0.0840 $ 0.75 $ 9.02 22 14" STRIP WASHER $ 4.37 0.0840 $ 0.37 $ 4.40 23 PRO BUCKET $ 21.98 0.0840 $ 1.85 $ 22.16 24 MR CLEAN MAGIC ERASER $ 5.51 0.3000 $ 1.65 $ 19.84 25 $ $ 26 $ $ 27 $ $ 28 $ $ 29 $ $ 30 $ $ 31 $ $ 32 $ $ 33 $ $ 34 $ $ 35 $ $ 36 $ $ 37 $ $ 38 $ $ 39 $ $ 40 $ $ 41 $ $ 42 $ $ 43 $ $ 44 $ $ 45 $ $ 46 $ $ 47 $ $ 48 $ $ 49 $ $ 50 $ $ Total $ 27.68 $ 332.16 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 N C N E n LU W N y d L •c1 L Y O U7 O d > O1 t9 Yi Ui Vf to .m c m q 0 C O O ° O E U N O. M 7 N m N E a y ¢ E U a ° N M d ~ » of °o O aci ~ E U N aav d z p E 'F ~ N ❑ Ov o c U O 00 N v U m N o c p 'c 0 ° rs f» 0 'Q o u` o o ~ O .o ~ A a`= o m a ° o °o c U y m O N r ~ N N 7 C e e N O m m N A U C ~ N L N d V O. C CL a) U 0 N C ❑ a ° N O_ 0 R ca L u G N N N N N N N N N N N N N N N N N N N O u° .R u di N p m E an d `o ? O E N C_ 3 c O O O O U YJ N c -6 V m u j c°~ m O w O Cm') N .C W N 3 n r > > N ° .O .0.. .L-U .N.. 0 ° `m a E m ` 'c ~ n 3 N a c N~ m~ 0 3 = a m a t L C U N~ ~ E .1- O m ~ v m `UC0- a .v c o°o E 0- O O ly N N N3 U L N O j, CO a ° w a c m UN 0 Z O° to EA 3 C N N C ~ N Ul w N W > l6 N -4) O d j j p 1 w =p p- 'cc o N ° m a w 0 a° 0 0 0 m - w m z_ 3 N m rn c rn 0 -a 'E N U 0. N N n N j_ N L N d C N N O> U fn N N y S N f6 Joa ma dm o ova a'cf-w m` E 0 E aL E«N. n p-' 0.a n mm 3 R °a ad~w ca v.3~ 3.fl u! °0 m m 0.0n t °O-Eo w c ❑YV Q C N U R N E ¢ N E o. rn- m❑ N' m o_ 0 u n 0. "3 L N O C •aL. N a U W L O O C N lQ 0 0 K W aU o 30 ~U W mU ~U `O Ow ~N(") V ~n cormmo~~2 r2 mr -mmo u n n n n n u ~ ~ ~ ~ ~ N N m ° Y d C U R y N O 'C O N U C C d U 0 N C a U~ U Ea E E >>a Q u a La 'c `o Em p_ cn3 ° d m c w °orn v mw-° a o m m ¢ m u.c -010m~ J ov'o v c~N r ~~m w m cd o coal O a N O N O U o a N o .`c0 cmc;_;m E CL ~ ° 0. 3 m o p N m 0 c IL- mFn In Lop o z' ❑ LL O co N ' a 0 poop ~ O N O 2 O G J m a a ry N N Zy ~a rr' LLLx ~dc°o H 2 >3 c JN go cE - - a rn 3y mo-'.2 SEt _ Ea 2 a E 9 y ~ - ~~C mt -1L N } ^ 3 Qc E~ _ oEo - ~ a` i- a r ° E~ L E E 'o n3 ~Ev N E N V b - _ F N a° m r r - E TJN - 3:~a RE m o __oF-`mN m~ H w H w Jwj.~. w H H H w w w w w H H w - 3 p a ° p v°v it v xoi E O mq c Y mom DNyc~m E Em H ' o _ x o a r° n o 3> ~"•4 o m tw' m ~E`m' iu - o HHHHwwwwwwwww wwHw _ o m tam `w a S t ° , x i o `m c w w9~ ` c= m rn m - aEg ~u.o 3 m t O n ~_c°12• - ,ig .mc O m a m m e i Ogee ~ E_E_ -~`Em` 3 n map EU t 'o o~ wE E°_ma E33ETm _ °1 ' A t o E t m E x _ m_ m x 3 E =2 n' o ° nE 3 0,2 0 y Oc A E2 7~ a > o m _ m u` E E m Z. IR j n v E= A m; m c > v H _ N ~ HHHHHHw NwwHwH HHHH n 2 ° - ~ 3= O O `m m W V H N C 7 N o m E m E Y e °m .Q t E« m _ E N ° oo _°m ~ °mFm E~ 3° o a ~ ~ u n UI l0 3 H H 'O Z ~ NLL~ aai Q I m3E L mw E3 m'om' o.Q ova _y aE wwwwHHwww vv m Eaw .;o °032_' Ew Q c Q c ~ m; m m E u c_ m 0 ~ - ° m 3r.E v c Em A;v E I m o o f 'o . t m - ~ a - w m r ~m _ ai E«O _ LOv-_ E c ^mv mmr $ - am~m6 aao o E v EyE~'o~p m ~ a N N m N 2. a U _ H T 1= m m~ _ mix a v E o.t 12 w om2 o ommo~... y v om~3 °m _ c o i- .m N m v -c- aEn~- Eo E °.E a O m ~ an `a m ~Q ° °mm m - ~ v= t=m c mN m N~LUo 00 o, 9Eg u¢_ H o 11 0 0 IL T I L L UI u~ rc~ v v p> `o 00.9 5 T- R O" t m m ° AL a E u o O ` c ? L - E. 5 2 m 3 m m E' Z H m N c o- mL ° ao. ° ° ° v u~ c~Ya y ° E _ =Em oat G32° u c E c c c c n m m- a o a5 5,>.>.w a mgr as m Ea° « iy `v i. m.o 2 .o c~E EEEooooaa aZm t ..cvo m ` ~E - ~o OELUc 5 -5 'E 5 5 fil a m E E E O ~L L E E k' d ~ Q mUUUU _ o F-F-F-F-~i (5 EcR O a ¢ u - ~N M emmr m Nm a aormrn p n n n n n n n n n n ii n ~ m mad, S E ~ ° J r~ 2 N [`l ` a a a a I= a E i w ao` # o 3 y N N h m C N_ u J E L_ m y ~ m - LL'y aQ` o 0 OVERHEAD Oregon Department of Administrative Services Overhead Costs Project Costing Worksheet Pathway Enterpris City of Ashland Parks and Recreation Nature Center 13-14 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 producing a final product, or providing a service, a certain percentage of that dollar is 1. Enter Overhead as a Percent of Total Costs required for overhead. To calculate the overhead percentage, it is best to have financial records for your 17.00 % organization that go back a year or more. Add together the expenditures that make up the overhead cost (see worksheet below). Now add this figure to the Raw materials, Direct labor and Delivery for a total cost. Divide the figure for overhead by the figure for total costs. The result is a percem that represents overhead as a percentage of the total cost. If financial records are not available estimate the overhead expenses as best you OR can, estimate other costs as best you can, and use the same formula to get a percentage. 2. Enter Allocated Overhead as aDollar-Figure Sum Dollar-Fig You can enter theure Sum Method: dollar amount you are allocating to overhead in the box if you are confident that you can allocate overhead Items to this particular project. You can use the Worksheet as a tool (if needed) OR to identify your costs. 3. Overhead as a Percent of Total Direct Labor Hours Percent of Total Direct Labor Method: To identify overhead costs, you need the financial records for your organization or division forthe past year. Input all the costs of the entire entity as detailed below. Line Items which are not detailed below should be input into the cells marked "other` please include a description. What you are trying to determine is a percentage, therefore, do not gross up the expenses for inflation or to conform to the current year budget. Next, input into the cell below the total direct labor hours paid out by your entire organization for the same period. These figures should be found on the year end payroll report. Do not include hours which can be classified as management or administrative costs. (Including these costs into the direct labor hour total will deflate the actual costs.) The worksheet will compute the overhead as a line hem cost by dividing the total projected labor hours for the contract into the total projected labor hours for the cunent year. Total Annual Direct Labor Hours Input Total from Worksheet on Below Overhead per labor hour 5 Time required to complete contract 178 Total Assigned Overhead S 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 Expense Management Medical Insurance Management Pension Plan Expense Sales & Administrative Salaries Sales & Administrative Payroll Tax Expense Sales & Administrative Medical Insurance Sales & Administrative Pension Plan Expense Office Rent Advertising and Public Education Background Checks & Urinalysis Professional & Accounting 1 Audit Fees Training & Worker Safety Insurance Telephone Utilities Property Taxes/LicensesiFees Dues & Subscriptions Depreciation-office building Depreciation-office equipment Repairs & Maintenance-office Cleaning and Maintenance Office Equipment Rental Office Supplies Postage & Freight Rehab Miscellaneous Expense Bad Debts Other:' Other Other Other: TOTAL INDIRECT COSTS S S CPI Factor from BLS (see link below) 3.15% 3.15% Idn, /wiw+bls aovRO9/rtwstreau ht. Total $ DAB Form #12 J Revision 10-03 Page 5 Overhead Computation Sheet Delivery & Reserve Oregon Department of Administrative Services Pathway Enterprises Inc. Project Costing Worksheet Cit of Ashland Parks and Recreation Nature Center 13-14 The State of Oregon reimburses employee use of their own vehicles on State business by the mile . The amount reimbursed per mile is based on a federal guideline which can be retrieved by following the link below to the GSA web site. This standard reimbursement is the standard for QRF cost calculation. Gas, oil, vehicle maintenance and repair are considered part of Delivery costs. The labor required (the driver and the workers if they are on the clock), should be captured in the Direct Labor worksheet. Vehicle costs may only be captured in the "Equipment, Tools & Subcontracts" spreadsheet or "Trans & Reserve" spreadsheet within this workbook. It is not permissable to capture costs in both spreadsheets. It is permisible to use this spreadsheet to capture vehicle costs for the following situations: (a) Transporting the individuals who will perform the service to the location where the service will be provided. (b) Services dependent on vehicle in the provision of that service. GSA - Privately Owned Vehicle (POV) Mileage Reimbursement Rates Services Contract Miles Per Rate Per Daily Services per Annual Delivery Descri tion Service Mile Cost Year Trans Cost 1 $ - $ - 2 $ - $ - 3 $ - $ - 4 $ - $ - $ - $ - Margin The law allows a "margin held in reserve". 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 cost of contract 6.0% DAS Form #12 J Revision 10-03 Page 6 Trans-Delivery and Margin Sheet ti ng Workbook For Janitorial Grounds Maintenance Contracts r the uaffT%ml1 Rehabilitation Facilities r Y;n i A AF ~ ■ e a` ■ s p F O clr: Oregon State Department of Administrative Services Procurement, Fleet, and Surplus Services 1225 Ferry Street SE, 1-1140 Salem, Oregon 97301 (503) 378-0542 SUMMARY OF ANNUAL COSTS Oregon Department of Administrative Services 07302007 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 Pathway Enterprises Inc. Project City of Ashland Parks and Rec Oak Knoll Pro Shop estrooms Executive Director Signature: Raw Materials Per Time Use - Supplies (from supplies worksheet) Is 182.55 Equipment, Tools & Subcontracting (from small equipment worksheet) $ 24.00 Subtotal1 $ 206.55 Labor Direct Labor (from labor daily worksheet) $ 1,998.53 Overhead See Overhead Worksheet $ 551.24 Delivery Transportation (from Trans & Reserve worksheet) $ 291.72 Total Before Margin $ 3,048.04 Reserve Margin Held in Reserve (from Trans & Reserve worksheet) $ 194.56 Total Bid Yearly $ 3,242.60 Monthly $ 270.22 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 Parks and Rec Oak Knoll Pro Shop Restrooms 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 Use/Per Item Manufactured - Supplies Item Unit Units Needed Monthly Annual Price Per Month Cost Cost 1 SCRUBBING SPONGES $ 1.36 0.5000 $ 0.68 $ 816 2 CREAM CLEANSER $ 3.06 0.2500 $ 0.77 $ 9.18 3 #66 DISINFECTANT CLEANER $ 42.40 0.0250 $ 1.06 $ 12.72 4 #64 NUETRAL CLEANER $ 88.00 0.0250 $ 2.20 $ 26.40 5 #70 WASHROOM CLEANER $ 97.44 0.0250 $ 2.44 $ 29.23 6 #61 GLASS CLEANER $ 85.20 0.0250 $ 2.13 $ 25.56 7 UTILITY BRUSH $ 2.74 0.0835 $ 0.23 $ 2.75 8 ANGLER BROOM $ 6.27 0.0840 $ 0.53 $ 6.32 9 TOILET SCRUB BRUSH $ 4.35 0.0840 $ 0.37 $ 4.38 10 VINYL GLOVES LARGE $ 9.89 0.1500 $ 1.48 $ 17.80 11 LAMBSWOOL DUSTER $ 4.90 0.0840 $ 0.41 $ 4.94 12 DUST PAN $ 2.52 0.0840 $ 0.21 $ 2.54 13 $ - $ - 14 $ $ 15 $ $ 16 $ $ 17 SPRAY BOTTLES $ 1.90 0.2500 $ 0.48 $ 5.70 18 MOP HANDLE $ 6.29 0.0840 $ 0.53 $ 6.34 19 LARGE MOP HEADS $ 5.20 0.1700 $ 0.88 $ 10,61 20 $ - $ - 21 $ $ 22 $ $ 23 $ $ 24 MR CLEAN MAGIC ERASER $ 5.51 0.1500 $ 0.83 $ 9.92 25 $ - $ 26 $ $ 27 $ $ 28 $ $ 29 $ $ 30 $ $ 31 $ $ 32 $ $ 33 $ $ 34 $ $ 35 $ $ 36 $ $ 37 $ $ 38 $ $ 39 $ $ 40 $ $ 41 $ $ 42 $ $ 43 $ $ 44 $ $ 45 $ $ 46 $ $ 47 $ $ 48 $ $ 49 $ $ 50 $ $ Total $ 15.21 $ 182.55 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 H c d E 0 v w N y d d U L > N d 'Y US O d ~ fA to f9 e9 of jp C N y O O c U a R v v E N d C C N N u E } c U Q •o y ~ Q c a` ~ es c H E CL E 'm o• o p~~ 4t ~ w c U o O m U d ~ O N ~ y U 0 0 +L-' U N O p a j o a n ~ o Od a d o N p ~ T a`= c 0 m a 3 O U O m ~ C f..l } N O N N a. ~ ~ d 3 » N d e L C O d C m U L i0 r N U L .U d O ~ L d O d C M ° d o o d m c ❑ a o m m •R c N a U _ L ti C N N N N` N N N N N N N N N N N N N N Y O m E d ~ ai m 0 m c- E c m U O d j C O d N d N O a 3 O O « rd.. d CLO.. '(0 E Q N > O N O a L)) U w EO O d d a E d 0. C > •C o o. o o c_ a v m N m N o L C U N d. .d0 U O ~ d O 0o N ~ .L.. a ~ (6 d c 0- L L o R N O- O L N O d C E N V a 'V 'C U^ 6 U N N 3 T U C o ID . ° » °c cow. m aNi Y m d > an d a E o d N ~d >"-s~E- .O N L w a T d d U N d C7 m w m v N o 0 ~ E N v NY z m m rn c ~a'c -'6-6 E c d o c > d W E 75 Q O .a (L O. d U U C U p a 7 yl > C N M E E w d wH `m E aoa oE3 wow adi d ca 3a ~a Y d a a T Q cwL ~ c16i¢o° do` w U rnw m mo d d~ ~ E¢ d E o. rna m c y C S a m (Q T j a aE~0 E Q o' m= a O W L d o c y m o O'wdU Fo- a ar QC) W tO U~U O O d d NM V M(O I~m00 V N(Oh o] mo II II II II II 11 II N' N d R K r N y d y ..N. C L d L L d d R y:-, O •C O E m r c d U d N } U U 6 o f mmo `o `m d 7# c w o m rT N- d o. in u 'O c m LL c d ~ N jp C o d d a R J « ' t 5 5 m c m O N_ U O U 0 Q b y U O 1 N O C "C C d C d d d ~ GO ~ O F- MEW 3 =$OZ t5ozm N 0 E L c ❑ LL o N Q d N Z o Q Z N ` o _ F o € m m` G m c Z ~ c - C j~ _ H c a m V w wen w.A w w w ww .wwww ww `S~Ea-, 'mE C V V N - 6 EEoam 311 E 6 E ❑ n 3 c~ m E m ~ ou ° - --oF Na ~ o m N _ 03= - E -ma°v p e n i Y y a t ~ N y ~ ~ n `m K a z'd y o~m .E Em mF f, 3 - xR~od .dey mEA 3mcs~ W 0 _ o E ~=EdX~ Gl ui N o o LL G 3 a y m w me O O& -a -~~~~L =o z~ vFm ~EE3~ rw J ° 0 0 °E --`E`m~° 3 w a c ~a,`m ° E E 'm C E3 3 E? - y° - « d m E x o m E o - a°, - _ c o m c c i a m u o aa,°° Dcamiom m° m E o ma .Ea; - - ~E y o oET- m3 m as p > > c v F °w y r .z m '3= o m w www wwww wwww o «-°`-$`mm mW o _ ~c o= E~E°~A 3p 'N Y a.cm a£ mo °Z .8, -g oa 3a oa y° d'zN a ~ tnw a m v " - m° w a Q u t d o ~ a c m Y c a 'o mo U E E m s u d E a - "o eu m~0 _ °poa-_ m _ w aN ~ mrY E= `m= ~ mtiEm c E_ a A6o naop ° ua mom E"41 rn` ~ mN~~ am: - cma~m~ - ~ Enc V mL > w o o ° m Uc `'suosl-`3 - -a -°o.E ae c -c- - - E2 E N w v°i v m °c' E c t F m °m - C~\ ~ OI W d~ L E u d~~ N ~ o ~ ~ ~n ° O O C C~ O N o F, c n y° _ --T, d ; A LL T° L L ~ T~ N Yo b t m o ~ y ` onnn00 E`o E~ ` m .`_x `sue! 03~ a;. c d y -`mN X > 0 0 0 ~S c ~x_a w ° o - cEm m 3« .Y" a`N a~uv° °~'E d~nf Do-o t~ a _ c ~ 3 S E L C C °I C T a N U N~ N d um E m - 3 U n 3 aaaacc mn m - a `oadmo 3 E E -T-°,°~ E" =ed .L 3¢m° °v E= `wo EEEc°~ENm10E 'E - a;= 3=LLVr = _ m n - li m a w c `o _ a d v v m«« v a E me 'o u°i v a 5 3 c c w o N" Y m m r y o . L QOQ~3`c3o S? mm EE EE53~~ '-mo vmN du E~'ms ~~,~~U "~v Joau ~m Qm UUUU - c ° FFF 17- ~ 'm me 3 O n ¢ m- ~ N M < N ro r m ~ M ~ N ~ ~ ~ m N II 11 II II II II II 11 II II 11 II = 0 0 0 0 ~ j Y J= # o as ~ a a E N m `o O N fll N 41 m C N a E O `m v O K 0 o a OVERHEAD Oregon Department of Administrative Services Overhead Costs Project Costing Worksheet Pathway Enterpris City of Ashland Parks and Rec Oak Knoll Pro Shop Restrooms 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 producing a final product, or providing a service, a certain percentage of that dollar is 1. Enter Overhead as a Percent of Total Costs required for overhead. To calculate the overhead percentage, it is best to have financial records for your 17.00 % organization that go back a year or more. Add together the expenditures that make up the overhead cost (see worksheet below). Now add this figure to the Raw materials, Direct labor and Delivery for a total cost. Divide the figure for overhead by the figure for total vests. The result is a percent that represents overhead as a percentage of the total cost. If financial records are not available estimate the overhead expenses as best you OR can, estimate other costs as best you can, and use the same formula to get a percentage. 2. Enter Allocated Overhead as a Dollar-Figure Sum Dollar-Figure Sum Method: You can enter the dollar amount you are allocating to overhead in the box if you are confident that you can allocate overhead items to this particular project. You can use the Worksheet as a tool (if needed) OR to identify your costs. 3. Overhead as a Percent of Total Direct Labor Hours (Percent of Total Direct Labor Method: I To identify overhead costs, you need the financial records for your organization or division for the past year. Input all the costs of the entire entity as detailed below. Line items which are not detailed below should be input into the cells marked "other"; please include a description. What you are trying to determine is a percentage, therefore, do not gross up the expenses for inflation or to conform to the current year budget. Next, input into the cell below the total direct labor hours paid out by your entire organization for the same period. These figures should be found on the year end payroll report. Do not include hours which can be classified as management or administrative costs. (Including these costs into the direct labor hour Iota[ will deflate the allual costs.) The worksheet will compute the overhead as a line Hem cost by dividing the total projected labor hours for the contract into the total projected labor hours for the current year. Total Annual Direct Labor Hours Input Total from Worksheet on Below Overhead per labor hour $ Time required to complete contrail 113 Total Assigned Overhead 5 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 Expense Management Medical Insurance Management Pension Plan Expense Sales & Administrative Salaries Sales & Administrative Payroll Tax Expense Sales & Administrative Medical Insurance Sales & Administrative Pension Plan Expense Office Rent Advertising and Public Education Background Checks & Urinalysis Professional & Accounting / Audit Fees Training & Worker Safety Insurance Telephone Utilities Property Taxes/Licenses/Fees Dues & Subscriptions Depreciation-office building Depreciation-office equipment Repairs & Maintenance-office Cleaning and Maintenance Office Equipment Rental Office Supplies Postage & Freight Rehab Miscellaneous Expense Bad Debts Other:' Other: Olher:• Other:• TOTAL INDIRECT COSTS 5 S CPI Factor from BLS 1- li tnk belmv) 3.15% 3.15% hno uwww.ms aoWrc9'mos_ hl. Total $ DAB Form #12 J Revision 10-03 Page 5 Overhead Computation Sheet Delivery & Reserve Oregon Department of Administrative Services Pathway Enterprises Inc. Project Costing Worksheet Cit of Ashland Parks and Rec Oak Knoll Pro Shop Restrooms The State of Oregon reimburses employee use of their own vehicles on State business by the mile . The amount reimbursed per mile is based on a federal guideline which can be retrieved by following the link below to the GSA web site. This standard reimbursement is the standard for QRF cost calculation. Gas, oil, vehicle maintenance and repair are considered part of Delivery costs. The labor required (the driver and the workers if they are on the clock), should be captured in the Direct Labor worksheet. Vehicle costs may only be captured in the "Equipment, Tools & Subcontracts" spreadsheet or "Trans & Reserve" spreadsheet within this workbook. It is not permissable to capture costs in both spreadsheets. It is permisible to use this spreadsheet to capture vehicle costs for the following situations: (a) Transporting the individuals who will perform the service to the location where the service will be provided. (b) Services dependent on vehicle in the provision of that service. GSA - Privately Owned Vehicle (POV) Mileage Reimbursement Rates Services Contract Miles Per Rate Per Daily Services per Annual Delivery Description Service Mile Cost Year Trans Cost 1 Service Vehicle from SOU 5.5 0.51 $ 2.81 104 $ 291.72 2 $ - $ 3 $ - $ - 4 $ - $ - $ 2.81 $ 291.72 Margin The law allows a "margin held in reserve". 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 cost of contract 6.0% DAS Form #12 J Revision 10-03 Page 6 Trans-Delivery and Margin Sheet Costing Workbook or Janitorial rounder Maintenance Contracts Under the Qualified Rehabilitation Fnnili i Program ~ F ~ O r ~ f pl Oregon State Department of Administrative Services Procurement, Fleet, and Surplus Services 1225 Ferry Street SE, U140 Salem, Oregon 97301 (503) 378-0642 SUMMARY OF ANNUAL COSTS Oregon Department of Administrative Services 07302007 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 Pathway Enterprises Inc. Project City of Ashland Parks and Recreation Office 13-14 Executive Director Signature: Raw Materials Per Time Use - Supplies (from supplies worksheet) Is 332.16 Equipment, Tools & Subcontracting (from small equipment worksheet) $ 44.03 Subtotal1 $ 376.19 Labor Direct Labor (from labor daily worksheet) $ 3,58192 Overhead See Overhead Worksheet $ 874.31 Delivery Transportation (from Trans & Reserve worksheet) $ - Total Before Margin $ 4,834.41 Reserve Margin Held in Reserve (from Trans & Reserve worksheet) $ 308.58 Total Bid Yearly $ 5,142.99 Monthly $ 428.58 DAS Form #12 J Revision 10-03 Pagel Summary Sheet RAW MATERIALS Oregon Department of Administrative Services Supplies Project Costing Worksheet Pathway Enterprises Inc. City of Ashland Parks and Recreation Office 13-14 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 Use/Per Item Manufactured - Supplies Item Unit Units Needed Monthly Annual Price Per Month Cost Cost 1 SCRUBBING SPONGES $ 1.36 1.0000 $ 1.36 $ 16.32 2 CREAM CLEANSER $ 3.06 0.5000 $ 1.53 $ 18.36 3 #66 DISINFECTANT CLEANER $ 42.40 0.0500 $ 2.12 $ 25.44 4 #64 NUETRAL CLEANER $ 88.00 0.0500 $ 4.40 $ 52.80 5 #70 WASHROOM CLEANER $ 97.44 0.0250 $ 2.44 $ 29.23 6 #61 GLASS CLEANER $ 85.20 0.0250 $ 2.13 $ 25.56, 7 UTILITY BRUSH $ 2.74 0.0840 $ 0.23 $ 2.76 8 ANGLER BROOM $ 6.27 0.0840 $ 0.53 $ 6.32 9 TOILET SCRUB BRUSH $ 4.35 0.0840 $ 0.37 $ 4.38 10 VINYL GLOVES LARGE $ 9.89 0.3000 $ 2.97 $ 35.60 11 LAMBSWOOL DUSTER $ 4.90 0.0840 $ 0.41 $ 4.94 12 DUSTPAN $ 2.52 0.0840 $ 0.21 $ 2.54 13 $ $ 14 $ $ 15 $ $ 16 $ $ 17 SPRAY BOTTLES $ 1.90 0.2500 $ 0.48 $ 5.70 18 MOP HANDLE $ 6.29 0.0840 $ 0.53 $ 6.34 19 LARGE MOP HEADS $ 5.20 0.3300 $ 1.72 $ 20.59 20 ORANGE GEL EXTREME $ 8.27 0.2000 $ 1.65 $ 19.85 21 14" WINDOW SOUEEJIE $ 8.95 0.0840 $ 0.75 $ 9.02 22 14" STRIP WASHER $ 4.37 0.0840 $ 0.37 $ 4.40 23 PRO BUCKET $ 21.98 0.0840 $ 1.85 $ 22.16 24 MR CLEAN MAGIC ERASER $ 5.51 0.3000 $ 1.65 $ 19.84 25 $ $ - 26 $ $ 27 $ $ 28 $ $ 29 $ $ 30 $ $ 31 $ $ 32 $ $ 33 $ $ 34 $ $ 35 $ $ 36 $ $ 37 $ $ 38 $ $ 39 $ $ 40 $ $ 41 $ $ 42 $ $ 43 $ $ 44 $ $ 45 $ $ 46 $ $ 47 $ $ 48 $ $ 49 $ $ 50 $ $ Total $ 27.68 $ 332.16 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- c d E o. o- w aNi m u d >t s `d U) o d ° en rn » en es •R c N NO y 0 0 O 'c U a m ai E v c C4 o N m cU a •a rn ~ a d U E CL d N K 6 E G a Z N C O O U F N ~ c U U ° m d ~ M ° d O U1 u o°O w U °D N o o a c o - ~ es us r n u` ° o d U N O ~ ❑ d = 'p T a e c O d a y O O C } m N O e) -0 N « ~ d » » d e a ~ C d Cl) N O N A d) L U d ~ ~ d d U O. M C d d O d m c o (L o " m c_ w p N N N N N N N N N N N N N N N N N N N N .Lm. N R O m E an d a N C O d U N U w E c N O ~ d V ud O a U ~O ntd.. d tD V .NC d 3 O_ ~ 7 N N N~~ U r `o d a s E d o. 'c Z 'c n 3 N C d C m N d > d d a ~ r ~~ENE=0 O - .d C N (6 L 0- .a « m N O o °o E `m n .2 V O O_ O d a) p d c E M N T O "OO a C U 0 w $j U C J d ~ U O. = a d w U o n~D d T; C: 0 C3, 0 w fA fA " T O O d N C U d O N d ai w O a N m .0. " d _E o N o s a w -O~ T d ai d 0 o R d T 'O N 2 'O L m U w O U E N N z N a°i m e a 'c v v d r ov E c d o d 3 c m ~ oN~ n ccp; c o~ o~~ n?v J q'f m 3 a y d w " fL d w o. a C Q N~ a d 3 Y ° o c a ~ Z `m E U E y o ° as n mw c°a ° N~-w c ~ N E .L. _ n a d d c T 3 a a W I°- d o E a° n L °-Eo' w❑wJ d d o n U F' - c a x R j n d (p C L L' U OI "O "6 "O T •O Q G w d U a O 0 R N U C m d O d d a d E Q d E `oa a c m N 'v i a u u m T i 3 `o L) m w -5 E 5 a U m n E E 3 oa L~ N o ~w R m m o u E Q O d O a L d O c y m o w a U o 3 0 > ¢ 0 U W m U~5 U F' j O S C d _ U d N M V v1 (O I~ fq O O N M V O r W m O II II It It II 11 11 y N d 0- y 0 C C d U C C v U d N Y= U U 6 E a c« w O 3 O d a m sr N d N `d d a 0 aUi d Q O) LL c N j R R J p U 'O u 3 cam` 4: TR ~ «a d O d d C C N A C 'O N M y U d O Q d N U ~ O O pl U O d ~ d T d C y d ❑ ~ ~ O d 3 i 3 o N E F min d❑Z R ❑ l°i O N a d ore o~ N m [V G o O [V ° 2 O ~ J N Q m N ~ L .2 'z o HwHHHw HHHHHHwHHHHHHH of CU MAT - vEn Z' 92 ~U~ LL R o E e o E a w .3 1. 1. r° ~ ° E 1 L o r W N A a s=° L N E E on3 dmom n a u°~. c E.S O° G d N - ~ m a E 1 C ° 'II d R 'a°O N - a y N Y 1 E c- - _ ~e m ° c3v'' v ma' > 3 .301 ° E Em zy w mE0 W110 O w w H H H w H H H H H H H _ o ° a r w E E .2yEmaxi= x - „ W t wp O~ILN E C T y m ~ - O m e t ti O a - c_ cy, - m2 R m F a E r m IT O ° u? --_E~; a ee _ - Eu Oc > ° E EmE E';3Ec' - m ° LSmEx _ m- v Uzo W I`_ o a n _E ~°n j mg fall, HH.HH HHHH N - L O t0 T w o - c` E~ o~ a o c c o: °o°o°o o m _ Fcd m` Eoc Ed Ec o En ~~E o~mm inN _ °1E~ o va E5 ° v ~ ° ~3 cEL~ mE m n m~ N9m m- a N~ H H w w H H H H H H H O C = 3° NC ~.QC~`y~ mW N eX mE cc Ha -mg ~Ev r 3 ° oa ..°o 'w i=m Elm v m ~enH a 2 y _ n noYO Eg ~ Q~w - ~u'~r mw ~v 1O ~ i `w o m . Y T P c 30 °°3D as Em wF ^ v m Eta Q m o' a c c` 1O c U w E a ~ E m a 9 Miss ° r: E v o m rna ° E y s-cNOU o ai m~0 - °v Ea - xaN'em~10~c m- vmmc_ m °E moHVie nIoN,!Evmm a0 EE r IV-so ~ c m c°, m 111143 -Em E \ o= t ° ~n m" c mEc dEa`01, > L N y y WHOM ~ E - ~N o v n a n n° o c c ° maw a' m ° f m N NTT T NN 2LLL °.TSt _ c eaa > ~a an00 E`o v `T o _ ma`'' - N c~~~ m - u y a° m ~t'w 'm m ~ on Na E 14 ,v_ Zpi ~cG Ey cc c cO. ~°n °NC ma " my=' E`U a - n~ =v _om ojv Av T~ Ra BEET E _ `m o a E a a~ x°c-n r3 me -au E EE Ea UUma age de cU En ALE g:e J T 3 ~u` O m o m w m m c c v o E «tv. a o a o Q, - ~ u°. a Om mz c p g n`° nn an= ~ H mt w ill! -IM v U5`N aa m o 0 0 0 E o _ ymE 1g . O 1 . Joau -1O,y~ QoiUU UU-- ° FF F F oa n ¢ m - ta I' N t7 V N N n W ^ ^ ' t' m w N II II II II II H II II II II II II N n V ~ N O R ~ R- m d Y L ~ = 0 0 0 0 ~ J d J x Y a E o. ~o 3 41 fq N N m C N_ d F q E E - J O `w = ¢ v O D Q Q O K OVERHEAD Oregon Department of Administrative Services Overhead Costs Project Costing Worksheet Pathway Enterpris City of Ashland Parks and Recreation Office 13-14 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 producing a final product, or providing a service, a certain percentage of that dollar is 1. Enter Overhead as a Percent of Total Costs required for overhead. To calculate the overhead percentage, It is best to have financial records for your 17.00 % organization that go back a year or more. Add together the expenditures that make up the overhead cost (see worksheet below). Now add this figure to the Raw materials, Direct labor and Delivery fora total cost. Divide the figure for overhead by the figure for total costs. The result is a percent that represents overhead as a percentage of the total cost. If financial records are not available estimate the overhead expenses as best you OR can, estimate other costs as best you can, and use the same formula to get a percentage. 2. Enter Allocated Overhead as a Dollar-Figure Sum Dollar-Figure Sum Method: You can enter the dollar amount you are allocating to overhead in the box if you are confident that you can allocate overhead Items to this particular project. You can use the Worksheet as a tool (if needed) OR to identify your costs. Percent of Total Direct Labor Method: 3. Overhead as a Percent of Total Direct Labor Hours To identify overhead costs, you need the financial records for your organization or division for the past year. Input all the costs of the entire entity as detailed below. Line items which are not detailed below should be input into the cells marked 'other; please include a description. What you are trying to determine is a percentage, therefore, do not gross up the expenses for inflation or to conform to the current year budget. Next, input into the cell below the total direct labor hours paid out by your entire organization for the same period. These figures should be found on the year end payroll report. Do not include hours which can be classified as management or administrative costs. (Including these costs into the direct labor hour total will deflate the actual costs) The worksheet will compute the overhead as a line hem cost by dividing the total projected labor hours for the contract into the total projected labor hours for the curcenl year. - - - - - Total Annual Direct Labor Hours Input Total from Worksheet on Below Overhead per labor hour $ - Time required to complete contract 203 Total Assigned Overhead $ E 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 Expense Management Medical Insurance Management Pension Plan Expense Sales & Administrative Salaries Sales & Administrative Payroll Tax Expense Sales & Administrative Medical Insurance Sales & Administrative Pension Plan Expense Office Rent Advertising and Public Education Background Checks & Urinalysis Professional & Accounting /Audit Fees Training & Worker Safety Insurance Telephone Utilities Property Taxes/Licenses/Fees Dues & Subscriptions Depreciation-office building Depreciation-office equipment Repairs & Maintenance-office Cleaning and Maintenance Office Equipment Rental Office Supplies Postage & Freight Rehab Miscellaneous Expense Bad Debts Other: ` Other:' Other.' Other:' TOTAL INDIRECT COSTS $ $ CPI Factor from BLS (see link bHm) 3.15% 3.15% h1c IMaw+bls -1r,11-treau htm Total $ DAS Form #12 J Revision 10-03 Page 5 Overhead Computation Sheet Delivery & Reserve Oregon Department of Administrative Services Pathway Enterprises Inc. Project Costing Worksheet Cit of Ashland Parks and Recreation Office 13-14 The State of Oregon reimburses employee use of their own vehicles on State business by the mile . The amount reimbursed per mile is based on a federal guideline which can be retrieved by following the link below to the GSA web site. This standard reimbursement is the standard for QRF cost calculation. Gas, oil, vehicle maintenance and repair are considered part of Delivery costs. The labor required (the driver and the workers if they are on the clock), should be captured in the Direct Labor worksheet. Vehicle costs may only be captured in the "Equipment, Tools & Subcontracts" spreadsheet or "Trans & Reserve" spreadsheet within this workbook. It is not permissable to capture costs in both spreadsheets. It is permisible to use this spreadsheet to capture vehicle costs for the following situations: (a) Transporting the individuals who will perform the service to the location where the service will be provided. (b) Services dependent on vehicle in the provision of that service. GSA - Privately Owned Vehicle (POV) Mileage Reimbursement Rates Services Contract Miles Per Rate Per Daily Services per Annual Delivery Description Service Mile Cost Year Trans Cost 1 $ - $ - 2 $ - $ - 3 $ - $ - 4 $ - $ - $ - $ - Margin The law allows a "margin held in reserve". 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 cost of contract 6.0% DAS Form #12 J Revision 10-03 Page 6 Trans-Delivery and Margin Sheet Costing For Janitorial Grounds Maintenance Contracts r h Qualified, 2-- 9Gja ili ti n Facilities Program Y l OF 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 07302007 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 Pathway Enterprises Inc. Project Ci of Ashland Parks Facility Floors 13-14 Executive Director Signature: Raw Materials Per Time Use - Supplies (from supplies worksheet) Is 739.40 Equipment, Tools & Subcontracting (from small equipment worksheet) $ 213.41 Subtotal l $ 952.81 Labor Direct Labor (from labor daily worksheet) $ 3,664.57 Overhead See Overhead Worksheet $ 1,019.42 Delivery Transportation (from Trans & Reserve worksheet) $ Total Before Margin $ 576 3-6- Reserve Margin Held in Reserve (from Trans & Reserve worksheet) $ 359.80 Total Bid Yearly $ 5,996.60 Monthly $ 499.72 DAS Form #12 J Revision 10-03 Pagel Summary Sheet RAW MATERIALS Oregon Department of Administrative Services Supplies Project Costing Worksheet Pathway Enterprises Inc. City of Ashland Parks Facility Floors 13-14 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 Use/Per Item Manufactured - Supplies Item Unit Units Needed Monthly Annual Price Per Month Cost Cost 1 Pro Strip 74.22 0.08333 $ 6.18 $ 74.22 2 Optimum Finish 10.2 0.3333 $ 3.40 $ 40.80 3 Grease Lightning 8.64 0.08333 $ 0.72 $ 8.64 4 Via Fresh Lemon Drop 15.81 0.08333 $ 1.32 $ 15.81 5 Defoamer 16 0.08333 $ 1.33 $ 16.00 6 Black Pads 20" 4.45 0.3333 $ 1.48 $ 17.80 7 Green Pads 20" 4.45 0.3333 $ 1.48 $ 17.80 8 Doodle Bu Pads 1.8 0.5 $ 0.90 $ 10.80 9 Nuetral Cleaner SE#64 22.81 0.08333 $ 1.90 $ 22.81 10 Blue Tae 826 0.5 $ 4.13 $ 49.56 11 Rags 19.99 0.0833 $ 1.67 $ 19.98 12 Carpet Cleaning Solution SE#62 19.05 0.0833 $ 1.59 $ 19.04 13 Nitrile Gloves Large 7.85 0.08333 $ 0.65 $ 7.85 14 Finish Mop Heads 7.21 0.25 $ 1.80 $ 21.63 15 Mop Heads 13.11 0.3333 $ 4.37 $ 52.43 16 Mop Handles 7.59 0.1667 $ 1.27 $ 15.18 17 Broom 11.67 0.0833 $ 0.97 $ 11.67 18 Dust Pan 6.29 0.0833 $ 0.52 $ 6.29 19 Finish 12.25 1 $ 12.25 $ 147.00 20 White Pads 20 4.45 1 $ 4.45 $ 53.40 21 One Ste 18.45 0.5 $ 9.23 $ 110.70 22 $ $ 23 $ $ 24 $ $ 25 $ $ 26 $ $ 27 $ $ 28 $ $ 29 $ $ 30 $ $ 31 $ $ 32 $ $ 33 $ $ 34 $ $ 35 $ $ 36 $ $ 37 $ $ 38 $ $ 39 $ $ 40 $ $ 41 $ $ 42 $ $ 43 $ $ 44 $ $ 45 $ $ 46 $ $ 47 $ $ 48 $ $ 49 $ $ 50 $ $ Total $ 61.62 $ 739.40 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 N O O H C d E O_ L W d d U d L Y d co O d > OI to e9 tlf E9 t9 p C aD O O M 0 0 0 N p d N O O M N 0 0 tri tri vi 'c U o. m W co M W N M N m E N d cc d c c a o co } Q E V M N Q m O d N E `o - O ZZ 0 N c U 0 o m rn d u m o o M o 0 o d O y u o mOO MtOO to w d U N N m N m r O 0 a` o - ~ eA eH e9 ei of of t» r a p a e o 0 o a e o_ U 0 0 0 0 0 0 0 N d r (Q d U N L ° d = p T d a V 0 0 o M o 0 0 t0 O O M 0 0 0 C O d m 0 0 t7 N O N N} NNMM C4 W ^ O N d en e» e» u9 rn rn e» d e w e ~ e a e ~ c d M o o M M ° c M N t n MM to n M M L d U L U d d U d M 3 ° `m d o d m c o" a 0° m m m c a U « p c N N N N N N N N N N N N N N N N N N NLO m E d d ° 0 0` E c N v n U ° L U ydj oc d L U Y d M77m'7 (O m d C N p C _ M N N M N M M c w O E Q 7 N O .O N tIl U ~N. O d y a E d o_ 3 j c _ w O O ZC p ~ d $ r L Ti d E n E a ° rnoooooo daa mm w c o I~oooooo E Tv~ `tv 9 p 0 0 o0 0 0 oa d o d E a d u U m N m W~ N N U 3 o y N«d o a d d U d d ° L ~ a c d « m._ o o y N y ID d Ol w N d 0 6 .C d E 0 o d ~ ~ a ~ - 'a o w ~ ~ Eo N m L` d o N•rn LU m e «m utyou, ° ° TE a d tov tai E3 N°t~oma'c a ci .0 s o p c d c > c m .T u Q T a J C V- U U N C p- C N N C p> w w d 3 p_ d d d U ~_s 3 En N d E z m E v Q. cl) Q ~a m 3Y ° u c'° u~zQ~mx c' w E N.c E w n ~O m a ° Nw~ N C°a O'yF-WUK dN T.3.. TCT wF d° E pon w o Eo wowu' m c° U F d a a > ~ w w a'ci U Q o U :E } w F W c« d o d d er ma d E g`al'a m~p<nwaa N .v fl. m Tj Q Q m T o p d y d O U W U U` W .OC N o c N U E O d L.-NM V tOmh.m M O3 u1ml~Mm O II II 11 II 11 II 11 C C d y U~ N d y O Y O E ms m dud H}= UjU >5a e EP a o. d Q v a L 'c o ~ E c«3 `o d c w U L ° C N d N O d d' O d d Q m LL C a N N C Y C J N 3 o0w ~a0 ~o d ao` m C C A C O y d p U .J Q N U O a N O O ` # E O -ad >•d„m 0'oc o N E F mmcn =at]zd O LL D w co 0 0 w O lV O 6 6 6 6 6 6 6 6 6 m o ~ J O o O N m Q m - Nm v'~i nn vvm Z f p, N N N m , m t 82 m h a " 2 Z c - 'm"E ad n 'c z - < wui enwwwwe»en .nw - ScdE_a 2- °E C V N N N N N N N N N _ o "y` g oEAH_ m `oy i=n r- - 1- E 3r c Ea 1. E E a ` N OeN hNla-ipN _ c E mN a eao t _ ; v o f m ° F y w _ www wenw ; N E p N m r d 'o t a ul y E cA NvvAivn _ om s aZ.= omo .E EN mF F= i;> x A o w -g g r y r m E" 3~ c t~ E p w a» - o t o `m a y L x E _ o E xm m m W 3 C. m m N m c` LL Z, 6 m « O 4 - r o c -°Fc DEv3c U o u EE EE 3 TITTI - ES m E6 2.1 tSm3x - d- a T- 11-t- dY c - E aZL3 m EW T NNE m ~3 a m-. 0..O aaN 9L 13 m m yF . W - y Oc w a v o m m o~~ $ m c - c E w E c o ma Em3 --at'm d rn N a ~E 53 _ vErH mi am T a m ' Hvv~idei T ~Z 14 v N_- N F m m T ? 3 u to en N f9 eA G O C ~ a~ v m mt' ~ E JC O Nom- m id 3 m 19° to bi e e e y O L - pC m o mQ 63 m y _ _ ` \ N Y o m ns. NO oZ -m x oa m m m ~p m v ~ml-n c 3 m oa ~zy m a m m 0 T _ y a m m W N < o ry o e m o E o ¢ - m x3 E d r v - E 3 16 1~ 16 a=' a a- u t o m u c Hy `o i ~ ww v ET. vim 3° ca _L E~ ~ `mL m - mESam~ Ao cQi moo 000 00o N3^E jEm ~-o~ ~~m E °o`a.yN° - E r Cm~aaims0 - mvc-. Eo m`-'6 ca`'. m r m °I ~~`emoae c vNS E c aZ n om.1;c 6 a`o.o >`ma-« m m2 E H. E_ E« a N F N n n N N» a N a L N_ _ - x _ E a S wwww ww«n. wen w103 cc o-`o``001=3 a _ c~ ° r L° rJ rr n m v m °c_' E t E - \ jZ5 o a 3E ~`o mo `m c `mckb t o a -9~E _ m ram El- v c 0 m 9 v f E _ m N m o U 3 m m E g E v E Q V V O R V V O N L LL T L L O d •m`.• L E - a E~ voav_vaavov ~ ~ana00 E`a~ Tn>, Ee°, `m ax w y 3.-~~ v d ca n zg0 °`co~`m ~i a c ° - z m «m m cEm _ °o a~°n oo >.J .N o 0 0__ cy-s a m ° co -n~°'c ~ oL a ~ L a mom m ~t uoi 'w v'i v E1 3a E mr nr _ '102 Yu ov o nnan~ ~ c n'0 03 _-o- oE I «m m L Ea _ - mu. muJ.LL E Boa Tna °u u'OEwa wE yZm a~'Vtn 3IiUt m L W G Y ma LL = na=a ~ o w w m mt t. 3 t.. a0 _ om _ -AIL m J T` N Ux a T. x ] j Qc c m Ti ? w Y n 1 m e m a c_ w 5 0 0 o I-m mIto Uxy-2 mm EEEEn as ~yc2 mx ET~~U `~a .K QQ o o o :ct >E' _ mUU " mU c c o E 'o JoaG aaUUaa 2 Z'aU Qm UU o c) f HFF-~ li m° oa m c 3 O E ¢ ma -N~vv~ co nm N eo~m rn n n u n n n n n n n II n = 0 0 0 0~~ O j~~ x N e'> a a a a ma E N q~ ac °a `oyw'w'r'nm ~ in "a° E 3 t m E ~ _ 6 F ep fn - C O u` = C O K O 0 Q R OVERHEAD Oregon Department of Administrative Services Overhead Costs - Project Costing Worksheet Pathway Enterpris City of Ashland Parks Facility Floors 13-14 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 producing a final product, or providing a service, a certain percentage of that dollar is 1. Enter Overhead as a Percent of Total Costs required for overhead. To calculate the overhead percentage, it is best to have financial records for your 1 00 organization that go back a year or more. Add together the expenditures that make up the overhead cost (see worksheet below). Now add this figure to the Raw materials, Direct labor and Delivery for a total cost. Divide the figure for overhead by the figure for total costs. The result is a percent that represents overhead as a percentage of the total cost. If tinanolal records are not available estimate the overhead expenses as best you OR can, estimate other costs as best you can, and use the same formula to gat a percentage. 2. Enter Allocated Overhead as a Dollar-Figure Sum DollarFigure Sum Method: You .o; nter the dollar amount you are allocating to overhead in the box if you are confident that you can allocate overhead items to this particular project. You can use the Worksheet as a tool (if needed) OR to identify your costs. 3. Overhead as a Percent of Total Direct Labor Hours Percent of Total Direct Labor Method: To identify overhead costs, you need the financial records for your organization or division for the past year. Input all the costs of the entire entity as detailed below. Line items which are not detailed below should be input into the cells marked "other: please include a description. What you are trying to determine is a percentage, therefore, do not gross up the expenses for inflation or to conform to the current year budget. Next, input into the cell below the total direct labor hours paid out by your entire organization for the same period. These figures should be found on the year end payroll report. Do not include hours which can be classified as management or administrative costs. (Including these costs into the direct labor hour total will deflate the actual costs.) The worksheet will compute the overhead as a line item cost by dividing the total projected labor hours for the contract into the total projected labor hours for the current year. Total Annual Direct Labor Hours Input Total from Worksheet on Below Overhead per labor hour S Time required to complete contract 207 Total Assigned Overhead 5 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 Expense Management Medical Insurance Management Pension Plan Expense Sales & Administrative Salaries Sales & Administrative Payroll Tax Expense Sales &Administrative Medical Insurance Sales & Administrative Pension Plan Expense Office Rent Advertising and Public Education Background Checks & Urinalysis Professional & Accounting / Audit Fees Training & Worker Safety Insurance Telephone Utilities Property Taxes/Licenses/Fees Dues & Subscriptions Depreciation-office building Depreciation-office equipment Repairs & Maintenance-office Cleaning and Maintenance Office Equipment Rental Office Supplies Postage & Freight Rehab Miscellaneous Expense Bad Debts Other** Other: Other:' Other: TOTAL INDIRECT COSTS $ S CPI Factor from BLS (see link below) 3.15% 3.15% hir, L +w.bls-/roalmostreou htm Total S DAB Form #12 J Revision 10-03 Page 5 Overhead Computation Sheet Delivery & Reserve Oregon Department of Administrative Services Pathway Enterprises Inc. Project Costing Worksheet Cit of Ashland Parks Facility Floors 13-14 The State of Oregon reimburses employee use of their own vehicles on State business by the mile . The amount reimbursed per mile is based on a federal guideline which can be retrieved by following the link below to the GSA web site. This standard reimbursement is the standard for QRF cost calculation. Gas, oil, vehicle maintenance and repair are considered part of Delivery costs. The labor required (the driver and the workers if they are on the clock), should be captured in the Direct Labor worksheet. Vehicle costs may only be captured in the "Equipment, Tools & Subcontracts" spreadsheet or "Trans & Reserve" spreadsheet within this workbook. It is not permissable to capture costs in both spreadsheets. It is permisible to use this spreadsheet to capture vehicle costs for the following situations: (a) Transporting the individuals who will perform the service to the location where the service will be provided. (b) Services dependent on vehicle in the provision of that service. GSA - Privately Owned Vehicle (POV) Mileage Reimbursement Rates Services Contract Miles Per Rate Per Daily Services per Annual Delivery Description Service Mile Cost Year Trans Cost 1 $ - $ - 2 $ - $ 3 $ - $ - 4 $ - $ - $ - $ Margin The law allows a "margin held in reserve". 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 cost of contract 6.0% DAS Form #12 J Revision 10-03 Page 6 Trans-Delivery and Margin Sheet Costing Workbook For Janitorial reruns Maintenance Contracts r t calif Rehabilitation Facilities Program i NCf ' A F- t- 101 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 07302007 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 Pathway Enterprises Inc. Project Parks and Recreation Pioneer Hall & Community Center 13-14 Executive Director Signature: Raw Materials Per Time Use - Supplies (from supplies worksheet) $ 1,129.76 Equipment, Tools & Subcontracting (from small equipment worksheet) $ 44.03 Subtotal1 $ 1,173.79 Labor Direct Labor (from labor daily worksheet) $ 14,184.28 Overhead See Overhead Worksheet $ 3,390.74 Delivery Transportation (from Trans & Reserve worksheet) $ - Total Before Margin $ 18,748.80 Reserve Margin Held in Reserve (from Trans & Reserve worksheet) 1,196.73 Total Bid Yearly $ 19,945.53 Monthly $ 11662.13 DAS Form #12 J Revision 10-03 Pagel Summary Sheet • RAW MATERIALS Oregon Department of Administrative Services Supplies Project Costing Worksheet Pathway Enterprises Inc. Parks and Recreation Pioneer Hall & Community Center 13-14 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 Use/Per Item Manufactured - Supplies Item Unit Units Needed Monthly Annual Price Per Month Cost Cost 1 SCRUBBING SPONGES $ 1.36 3.0000 $ 4.08 $ 48.96 2 CREAM CLEANSER $ 3.06 1.0000 $ 3.06 $ 36.72 3 #66 DISINFECTANT CLEANER $ 42.40 0.2500 $ 10.60 $ 127.20 4 #64 NUETRAL CLEANER $ 88.00 0.5000 $ 44.00 $ 528.00 5 #70 WASHROOM CLEANER $ 97.44 0.0250 $ 2.44 $ 29.23 6 #61 GLASS CLEANER $ 85.20 0.0250 $ 2.13 $ 25.56 7 UTILITY BRUSH $ 2.74 0.0840 $ 0.23 $ 2.76 8 ANGLER BROOM $ 6.27 0.0840 $ 0.53 $ 6.32 9 TOILET SCRUB BRUSH $ 4.35 0.0840 $ 0.37 $ 4.38 10 VINYL GLOVES LARGE $ 9.89 1.2500 $ 12.36 $ 148.35 11 LAMBSWOOL DUSTER $ 4.90 0.0840 $ 0.41 $ 4.94 12 DUST PAN $ 2.52 0.0840 $ 0.21 $ 2.54 13 $ $ 14 $ $ 15 $ $ 16 $ $ 17 SPRAY BOTTLES $ 1.90 0.2500 $ 0.48 $ 5.70 18 MOP HANDLE $ 6.29 0.0840 $ 0.53 $ 6.34 19 LARGE MOP HEADS $ 5.20 0.5000 $ 2.60 $ 31.20 20 ORANGE GEL EXTREME $ 8.27 0.2000 $ 1.65 $ 19.85 21 14" WINDOW SQUEEJIE $ 8.95 0.0840 $ 0.75 $ 9.02 22 14" STRIP WASHER $ 4.37 0.0840 $ 0.37 $ 4.40 23 PRO BUCKET $ 21.98 0.0840 $ 1.85 $ 22.16 24 MR CLEAN MAGIC ERASER $ 5.51 1.0000 $ 5.51 $ 66.12 25 $ $ 26 $ $ 27 $ $ 28 $ $ 29 $ $ 30 $ $ 31 $ $ 32 $ $ 33 $ $ 34 $ $ 35 $ $ 36 $ $ 37 $ $ 38 $ $ 39 $ $ 40 $ $ 41 $ $ 42 $ $ 43 $ $ 44 $ $ 45 $ $ 46 $ $ 47 $ $ 48 $ $ 49 $ $ 50 $ $ Total $ 94.15 $ 1,129.76 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 c d E n W N y °f d U L d Y U) O > 0 V3 t9 t9 fA fA C M Ch ° O N O O O C U O. d ; N N O N V M d } Q U Q d o t/1 F p d ~ ei rn O E U Q 4 d y q 0 ~aE °c o a Z 0 F N o O U N c U 0 o m d ~ w o o° O to auiV mN o c a` 'c 0 as of O - o _ o e n u` o o C o` = o d a 3 y O O C N } m N N ei eA m a c N U L- O N L y d n .-M 3 m a a) co m d U N C O a ° N C CL a W L U C_' _ N N N N N N N N N N N N N N N N N N N N N O L y d U N N E di o E o U N L) N C -O U d N 3 0 y O O W d N L~ N N 3 n CO - N OO N y~ d U .y-' ~ O d N Q G~ ~-'C~~ C 0 3 N c c a O - a Q N N~ L L C U O O.~ E o 0 U L CO p n O .O asi 0 a) ° E O d ~ d ~O N ~ U N N 3 T U C ° a ° w O _O 'd6 C C T° O d N O C U m AHi _ R U d w N ai N> O C E E O l0 a - - O N U S D vydi L W a T d d N U 1p T y Ur N d a ~6 U O d d E N c d " wo•o U oa c 0 t2 B S c r U y ° '=1n N d 0= N N U_~a N n N N N d N LL' (6 L C' a m d m jY0 y dm C " w N o > Q U1 am) o N T C T wt° v E ay°' oE~ ~ a " iaa T~ F c~ ° 0 a. a X d j d `1 R L U U .L- m O N (0 T Q d UQ0 o oC mN w ~ s ~ c N'u n E w `m O.LC m~ tom o.E '05 c°i nE L` y O C d a U N L N O C N (6 O O KwEL CL °o UUW ca C) H o a d N M V v) O ti O O O N V l0 t0 m O) O 11 II II 11 11 II II N 0 N G y C d d ~ C L d y L L N } L) U E E. Ed n 00.3 O d d a x c w E v mN-° w a o a° m c L) Q Ol LL C N -O C J 2 d m c~y ccd w c a 'o N(`7 O .C N -10 C d N 7 a E d 3 N O o d N d O c n~a](n = &OZ N LL Q N ~ lY O r n N 0 2 O ~ J O Q % ^ - m a m Z C N V O w r o N «W 3~~ ~'E QCE - Q wwwwwww wwww _ yn ~ -c H c`m -d Ea 2of c U N N N U Q p - - C ° N Is o Ey° F - oEo m a `op i-a °E~to i lnro' m E O - o N O1 °v O E wwwww ° off. www w w w w w w w w w w ° o - ~a 3 ° W a ^ a °~o~ - EO °v 9 0 U GA 9 Y N"OO aywcyC ~ d `o ?Zm c3 e o - x ma r= . 3 y~~Em E Em `w T 3~d c sy O _ n mE~ rEm v E 2 y E v x W 3 c w` al ° - m e v Oa - c - t~ ~ vHN ~E~3~ SNw °u ~a _ aEn 3 - ° _ E It -8 785 ~9 15 -2. R pe IE EEr ~ ds tSmE~ - v- y o m t ° a~ E E o Z O d e o $ o.a ~ m rnF www ~ v _ O HHH c~oi - -E`oma T ° O E > E o a E n E 3 0 m v m H _ v E o ma 'Ed - _ v °3 W n yo nELm 21 n _ 3 a E. R a m o ri . . . . . . . . . . n - m e T w - w~ H N H M H H w H w w w w w H w w H H H w 6 ~ a .n ~ j 3~ O ER c ° o _ dam mm o.w ~a - mm E a y c c m 3 e O 3: BE 21. 1. E m v y L _ _ y d e g N m w ` m Nry°a -v o Q •'no d~« to 3 s qN~V L`m o a°°~ .'E° E E 3- .30 `a j>, ~ wwwwwwwww ww v v cm Ea T~ vd - t ~rn c a= c c_ m0 E- '25 7~E E' is m m - a'a o rno o E° U LEu; E 0110«O - - °Oa-_ Ea m rnF w' amN371~'a momma EN Et = Ea o•~° .°c a ° N N y y mm ~Ec tF v.za E« E \ 6,0 =ate rnrn~ ~aL o` -"-oE ma WAN o ~ ~ na c U T °3-'LU ? jmm oL E c ~AE.EE N N N y IL T L L d E p .o O O E `o E 01 .L `mo = w 3n n~ m v. v a To 0o c.o y vi n y o0 0 > o N a o o c'~ L c f Y v d `o o ; c E m .3 t @~< ° -o u u ° E ~ EL mC C C T T~ U N.N_. 0 D T y E m 3U p d y~ ooa->. >..'=amyNaa mEa° mNU a.. T~ ma n m°c `v _ E EEEooumawEOzd <o°°O E- r 0 NOTTTTUU1~Ev1N T ? E a3« 6Q 3~I~Uc `w u c v n a n o w .n c c a w w a -a°1 wa'~ o y o m d d w tt ° o E n o _ n o - G3a Yo>>3c c~oNN y vL 'o n M d 3 v a° E F= E E« r- - m y Eay ` m m o E E D o c .°lc :c E o o f > U E° 5sa amUUU__~~~~~~ ~3 oa Q„- N. I V N f O I N MZ~ ~2 1 O ^ N I I 11 I I 11 11 I I I I 11 11 I I I I I C 2 0 0 0 r-. ~ a` J 2 N J a a E a E N m o` o 3 N N N N m e N_ f A E Ly°' `u E__J LLH a ~ ' n > Z5 d = c o~ 0 o a` ac OVERHEAD Oregon Department of Administrative Services Overhead Costs Project Costing Worksheet Pathway Enterpris Parks and Recreation Pioneer Hall & Community Center 13-14 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 producing a final product, or providing a service, a certain percentage of that dollar is 1. Enter Overhead as a Percent of Total Costs required for overhead. To calculate the overhead percentage, it is best to have financial records for your 17.00 % organization that go back a year or more. Add together the expenditures that make up the overhead cost (see worksheet below). Now add this figure to the Raw materials, Direct labor and Delivery for a total cost. Divide the figure for overhead by the figure for total costs. The result is a percent that represents overhead as a percentage of the total cost. If financial records are not available estimate the overhead expenses as best you OR can, estimate other costs as best you can, and use the same formula to get a percentage. 2. Enter Allocated Overhead as a Dollar-Figure Sum Dollar-Figure Sum Method: You can enter the dollar amount you are allocating to overhead in the box if you are confident that you can allocate overhead items to this particular project. You can use the Worksheet as a tool (if needed) OR to identify your costs. 3. Overhead as a Percent of Total Direct Labor Hours Percent of Total Direct Labor Method: To identify overhead costs, you need the financial records foryour organization or division forthe past year. Input all the costs of the entire entity as detailed below. Line items which are not detailed below should be input into the cells marked "other; please include a description. What you are trying to determine is a percentage, therefore, do not gross up the expenses for inflation or to conform to the current year budget. Next, input into the cell below the total direct labor hours paid out by your entire organization for the same period. These figures should be found on the year end payroll report. Do not include hours which can be classified as management or administrative costs. (Including these costs into the direct labor hour total will deflate the actual costs.) The worksheet will compute the overhead as a line item cost by dividing the total projected labor hours for the contract into the total projected labor hours for the current year. Total Annual Direct Labor Hours Input Total from Worksheet on Below Overhead per labor hour $ Time required to complete contract 802 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 DEPARTMENTAL that you show as your total Overhead Management Salades Management Payroll Tax Expense Management Medical Insurance Management Pension Plan Expense Sales & Administrative Salaries Sales & Administrative Payroll Tax Expense Sales & Administrative Medical Insurance Sales & Administrative Pension Plan Expense Office Rent Advertising and Public Education Background Checks & Urinalysis Professional & Accounting / Audit Fees Training & Worker Safety - Insurance Telephone Utilities Property Taxes/Licenses/Fees Dues & Subscriptions Depreciation-office building Depreciation-office equipment Repairs & Maintenance-office Cleaning and Maintenance Office Equipment Rental Office Supplies Postage & Freight Rehab Miscellaneous Expense Bad Debts Other: Other:' Other Other: TOTAL INDIRECT COSTS $ $ CPI Factor from BLS (see link below) 115% 3.15% =F111 oovlro9~mostreau."1 $ DAB Form #12 J - Revision 10-03 Page 5 Overhead Computation Sheet Delivery & Reserve Oregon Department of Administrative Services Pathway Enterprises Inc. Project Costing Worksheet Parks and Recreation Pioneer Hall & Community Center 13-14 The State of Oregon reimburses employee use of their own vehicles on State business by the mile . The amount reimbursed per mile is based on a federal guideline which can be retrieved by following the link below to the GSA web site. This standard reimbursement is the standard for QRF cost calculation. Gas, oil, vehicle maintenance and repair are considered part of Delivery costs. The labor required (the driver and the workers if they are on the clock), should be captured in the Direct Labor worksheet. Vehicle costs may only be captured in the "Equipment, Tools & Subcontracts" spreadsheet or "Trans & Reserve" spreadsheet within this workbook. It is not permissable to capture costs in both spreadsheets. It is permisible to use this spreadsheet to capture vehicle costs for the following situations: (a) Transporting the individuals who will perform the service to the location where the service will be provided. (b) Services dependent on vehicle in the provision of that service. GSA - Privately Owned Vehicle (POV) Mileage Reimbursement Rates Services Contract Miles Per Rate Per Daily Services per Annual Deliver Description Service Mile Cost Year Trans Cost 1 $ - $ - 2 $ - $ - 3 $ - $ - 4 $ - $ - $ - $ - Margin The law allows a "margin held in reserve". 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 cost of contract 6.0% DAS Form #12 J Revision 10-03 Page 6 Trans-Delivery and Margin Sheet Costing Workbook For Janitorial rounds airy Contracts Under the Qualified Rehabilitation Facilities Program i, r ~y si . ii Sol U F -.0 I8~•r,~ g, j Oregon State Department of Administrative Services Procurement, Fleet, and Surplus Services 1225 Ferry Street SE, 1.1140 Salem, Oregon 97301 (503} 378-4642 r z ~ SUMMARY OF ANNUAL COSTS Oregon Department of Administrative Services 07302007 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 followng 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 Pathway Enterprises Inc. Project Ci of Ashland Parks and Recreation Senior Center Executive Director Signature: Raw Materials Per Time Use - Supplies (from supplies worksheet) Is 870.96 Equipment, Tools & Subcontracting (from small equipment worksheet) $ 44.03 Subtotal 1 $ 914.99 Labor Direct Labor (from labor daily worksheet) $ 11,778.96 Overhead See Overhead Worksheet $ 2,802.56 Delivery Transportation (from Trans & Reserve worksheet) $ Total Before Margin $ 15,496.51 Reserve Margin Held in Reserve (from Trans & Reserve worksheet) $ 989.14 Total Bid Yearly $ 16,485.65 Monthly $ 1,37180 DAS Form #12 J Revision 10-03 Pagel Summary Sheet RAW MATERIALS Oregon Department of Administrative Services Supplies Project Costing Worksheet Pathway Enterprises Inc. Cit of Ashland Parks and Recreation Senior Center 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 Use/Per Item Manufactured - Supplies Item Unit Units Needed Monthly Annual Price Per Month Cost Cost 1 SCRUBBING SPONGES $ 136 1.0000 $ 1.36 $ 16.32 2 CREAM CLEANSER $ 3.06 1.0000 $ 3.06 $ 36.72 3 #66 DISINFECTANT CLEANER $ 42.40 0.1000 $ 4.24 $ 50.88 4 #64 NUETRAL CLEANER $ 88.00 0.1000 $ 8.80 $ 105.60 5 #70 WASHROOM CLEANER $ 97.44 0.0250 $ 2.44 $ 29.23 6 #61 GLASS CLEANER $ 85.20 0.0250 $ 2.13 $ 25.56 7 UTILITY BRUSH $ 2.74 0.0840 $ 0.23 $ 2.76 8 ANGLER BROOM $ 6.27 0.0840 $ 0.53 $ 6.32 9 TOILET SCRUB BRUSH $ 4.35 0.0840 $ 0.37 $ 4.38 10 VINYL GLOVES LARGE $ 9.89 0.5000 $ 4.95 $ 59.34 11 LAMBSWOOL DUSTER $ 4.90 0.0840 $ 0.41 $ 4.94 12 DUSTPAN $ 2.52 0.0840 $ 0.21 $ 2.54 13 PRO STRIP $ 48.26 0.2000 $ 9.65 $ 115.82 14 OPTIMUM FINISH $ 52.16 0.3000 $ 15.65 $ 187.78 15 BLACK PADS 20" $ 19.24 0.1500 $ 2.89 $ 34.63 16 FOLEX CARPET CLEANING SOLUTION $ 16.21 0.1200 $ 1.95 $ 23.34 17 SPRAY BOTTLES $ 1.90 0.2500 $ 0.48 $ 5.70 18 MOP HANDLE $ 6.29 0.0840 $ 0.53 $ 6.34 19 LARGE MOP HEADS $ 5.20 0.5000 $ 2.60 $ 31.20 20 ORANGE GEL EXTREME $ 8.27 0.2000 $ 1.65 $ 19.85 21 14" WINDOW SQUEEJIE $ 8.95 0.0840 $ 0.75 $ 9.02 22 14" STRIP WASHER $ 4.37 0.0840 $ 0.37 $ 4.40 23 PRO BUCKET $ 21.98 0.0840 $ 1.85 $ 22.16 24 MR CLEAN MAGIC ERASER $ 5.51 1.0000 $ 5.51 $ 66.12 25 $ $ - 26 $ $ 27 $ $ 28 $ $ 29 $ $ 30 $ $ 31 $ $ 32 $ $ 33 $ $ 34 $ $ 35 $ $ 36 $ $ 37 $ $ 38 $ $ 39 $ $ 40 $ $ 41 $ $ 42 $ $ 43 $ $ 44 $ $ 45 $ $ 46 $ $ 47 $ $ 48 $ $ 49 $ $ 50 $ $ Total $ 72.58 $ 870.96 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 y 4i a O O C d E a w a m U d L > N d Y fn O > d C N 0 y O O O 'c U a m a V id N E d C N a y } c U 0 a` Q di a9 of c H E ~ o- 01 ~ m 0 CL E Z 0 #_E o ° O U ~ N c U o O m O N u o°° L d L1 N O O ~ C a` 'c r o n U d U N ~ o f6 ° d =L. O T a`= c 0 m a O O U U y cd C c N } ~ N O C d N fA fA N m a Of Om7 VOl U r d m U L U N ~ N 3 L d U n C M a `m o d I] a c o o m R ~ y a p C N N N N N N N N V ,N N N N N N N N N N N m .t... N .d '•C- m E ~ ai m ° N w C- O C N U N V ~ O L U j C O m d 0 rL. d c0 V t m m 3 O d N C rL,,, m~~ n O d y N o a m (q ~ U ..N. D_ 3 N Q E m n C C N Z C iU O O C_ 'm0 m m N N E a E a o .L.. = c v m ` `m L c o 0 o E- m a N O O N r d N SL O a m 0 C E U a 'd0 .0 'C u N~ U O 2i (°j C a o o v w o o. r m 'c a C d d w 0° r d d 'O a C C T O~ O m N ` A A 7 U C d C OO C N o y -~O W > wp 0- ° C E N d d t x N V y m L L 0) t U (0 N T N L N Am CD m d d N a w0 U O 75 n ci a L `o n o L O 'O E R C N o N= U C d C a d= -Q C s 3 C N N d O 2 K d (Q U d d N _n N ro ¢ N w m X j O p N O. H w N E U m w = C O O a a d d N U C O O a N Q C .N N E L_ E ..N.. n W H d m a D n' o f w p l j w m c a 03 a s Q c a'~i m m c t Y c~ OI Y ° a ~ a a u O 'C 10 N U C lp N O O m .O m pI T U¢ O L° H o c CL L) m m o it `m o v E ¢ o' m= o v '3 d O. L a) o c y m o R'waU o d N Q~ oUw mU~U c N j O d d N m '7 V1 (D h [D O ~2 ` O r V LL1 .m - n m O co 11 it 11 11 II II II C N N U N r r e- r 10 y N r IA d L C C L V Cl d d O 'C O E E mr d > 5a3 N c} e U ~ n > 0 ¢ a d c 0 a `oE '9 mdd `o `m d mat c w o rn N- a w u LL C d d N jp O a d d ¢ C c a m 3 c 3 c~ z w 2 0 15 E-Od dCE1 W # t 3_ 3 m C ETC o y E o mmrn = Z M ° o 0 'h LL Q a> 0 of s i o a o ° `r Z y m o ~ a N _ t LL m ~ v m e m a "cZ ccc°Ln _ i3 c J .3 ~ cE.N ~ - -d Ea 2' of C V N N V N V _ _ E" N Y M E E am y= 3 'oa ra ~ - - `o'E~~c m N N try w m^~ E o°3 am cmEm ~ i'o° 0 1~ m c E'S° Ob O d o _-FinN O1 0 x rs m 3 0 3 - yv E -oo°o o 11 .~y - _ No a~.. ohm E Em mr F i ~ '3i Y Aom r y v m E E 3 v - o w w w w w w en w w w w w w w w w w w w w _ o E d cm H a d x` x m W mN ~ _ aci Eoo°ILo E - ~ n 3 n :E °E Ewe E.33E> - m E o t.'c~.mEx a . m 3 NF m L- 'gym Ocm - w k ~a o c o - m-° - - c~ oo E> -E o- E -o Ea N~3 _o~aai rn N - e E~ o maE~ 3 a T n a n n m m rn~w wwww a oc dvEOd^ t.e E= o m~do m 3a;v S:g m . or `a`° a.to.. m o °Z 'm Fcm oa 3 c a E ~ N o 3e»~' a Z'm m m v m - LL ui m° wn ~ m am Q.~ m c m a u 'o ? a 'o -o aL ru a--' m0 n ~1°ya~me C mNS E `-c° m- c 01tiE c r'n° ~ E '-~nvor~v ' ano m-°o m E3N .°_:.c3 uEciy a- m om- m ~ o o 'o = E ~ o o ep _ _ c ai_ m Npm c_ Em E O T I L O O N N y m N Q] c E _ t F. a Z d - 4 4 1 u O L A w« H y y o ca o cca«O Qa ^~a of `mom n°. EO a3i ° ~mm c0 - ~UL F m o.E ao t0 t E E^ u¢ - - e V N N y LL T L L O o` T UI r W E E J= y N o O L ~ o m o. o,6 c x~ ~`rv O> 3aa`00 Eo ul anT E" ~ -x au a ~ ~ 00> SoEmL ° . 0 0 0__« Svs a w c c °o'='~ T Amy mv° m s uoi vi 3 u v ° EM 3a E -uv 3 xo- or mrnrnrn~~° ooN~ va > `Em..- 3U m m~ E Y c c c °n omyN.na mEa ~i.t~ - '03 oc w _ a a annc c~ m eu __5. o~Em om -`m ~ N 03303~~jm NoEn ~'Zd ~ c3¢~ -Ou NmvN - a;Vra 3cUo`m 10~ _c m~Ea Es E a Em o z o a°w` `o~= EE Imoddmw««v3E ao = - lom ELa ~~T`3«o~omm'-Y35a3cc~oyy x do ~ m mtc ooa`o mm E E E E--v~ sE~ d cm~ ~`~~3U "~a aa c o 0 o n n c r t t E o a> E c 3 O n ¢ m JOaU ~N-tQ, ¢ m UU 0o c ° FF-H F ~i - ~ N m< N m n m ` N--- rn N I I II I I II II I I 11 I I II 11 II 11 n a ~ w _ `o C ` a n a a d a E N 'm S °o 3 N N N N m C m- f~ E- t m aF ~ y.~ O `u = o K OVERHEAD Oregon Department of Administrative Services Overhead Costs Project Costing Worksheet Pathway Enterpris City of Ashland Parks and Recreation Senior Center 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 producing a final product, or providing a service, a certain percentage of that dollar is 1. Enter Overhead as a Percent of Total Costs required for overhead. To calculate the overhead percentage, it is best to have financial records for your 17.00% organization that go back a year or more. Add together the expenditures that make up the overhead cost (see worksheat below). Now add this figure to the Raw materials, Direct labor and Delivery for a total cost. Divide the figure for overhead by the figure for total costs. The result is a percent that represents overhead as a percentage of the total cost. If financial records are not available estimate the overhead expenses as best you OR can, estimate other costs as best you can, and use file same formula to get a percentage. 2. Enter Allocated Overhead as a Dollar-Figure Sum Dollar-Figure Sum Method: You can enter the dollar amount you are allocating to overhead in the box if you are confident that you can allocate overhead Items to this particular project. You can use the Worksheet as a tool (if needed) OR to identify your costs. 3. Overhead as a Percent of Total Direct Labor Hours Percent of Total Direct Labor Method: To identify overhead costs, you need the financial records for your organization or division for the past year. Input all the costs of the entire entity as detailed below. Line items which are not detailed below should be input into the cells marked "other': please include a description. What you are trying to determine is a percentage, therefore, do not gross up the expenses for inflation or to conform to the current year budget. Next, input into the cell below the total direct labor hours paid out by your entire organization for the came period. These figures should be found on the year end payroll report. Do not include hours which can be classified as management or administrative costs. (Including these costs into the direct labor hour total will deflate the actual costs.) The worksheet will compete the overhead as a line item cost by dividing the total projected labor hours for the contract into the total projected labor hours for the current year. - - - - - Total Annual Direct Labor Hours Input Total from Worksheet on Below Ovemead per labor hour $ Time required to complete contract 666 Total Assigned Overhead 5 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 Expense Management Medical Insurance Management Pension Plan Expense Sales & Administrative Salaries Sales & Administrative Payroll Tax Expense Sales & Administrative Medical Insurance Sales & Administrative Pension Plan Expense Office Rent Advertising and Public Education Background Checks & Urinalysis Professional & Accounting / Audit Fees Training & Worker Safety Insurance Telephone Utilities Property Taxes/Licenses/Fees Dues & Subscriptions Depreciation-office building Depreciation-office equipment Repairs & Maintenance-office Cleaning and Maintenance Office Equipment Rental Office Supplies Postage & Freight Rehab Miscellaneous Expense Bad Debts Other:' Other:' Other: Other: TOTAL INDIRECT COSTS $ 5 CPI Fodor from BLS (see link below) 315% 3.15% httvr~www_bls aovlro3~mastreau.M1tm Total $ DAS Form #12 J Revision 10-03 Page 5 Overhead Computation Sheet Delivery & Reserve Oregon Department of Administrative Services Pathway Enterprises Inc. Project Costing Worksheet Cit of Ashland Parks and Recreation Senior Center The State of Oregon reimburses employee use of their own vehicles on State business by the mile . The amount reimbursed per mile is based on a federal guideline which can be retrieved by following the link below to the GSA web site. This standard reimbursement is the standard for QRF cost calculation. Gas, oil, vehicle maintenance and repair are considered part of Delivery costs. The labor required (the driver and the workers if they are on the clock), should be captured in the Direct Labor worksheet. Vehicle costs may only be captured in the "Equipment, Tools & Subcontracts" spreadsheet or "Trans & Reserve" spreadsheet within this workbook. It is not permissable to capture costs in both spreadsheets. It is permisible to use this spreadsheet to capture vehicle costs for the following situations: (a) Transporting the individuals who will perform the service to the location where the service will be provided. (b) Services dependent on vehicle in the provision of that service. GSA - Privately Owned Vehicle (POV) Mileage Reimbursement Rates Services Contract Miles Per Rate Per Daily Services per Annual Delivery Description Service Mile Cost Year Trans Cost 1 $ - $ - 2 $ - $ - 3 $ - $ - 4 $ - $ - $ - $ - Margin The law allows a "margin held in reserve". 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 cost of contract 6.0% DAS Form #12 J Revision 10-03 Page 6 Trans-Delivery and Margin Sheet Page 1 / 1 i ASHLAND PARK COMMISSION 20 E MAIN ST. DATE FPO NUMBER ASHLAND, OR 97520 7/25/2014 00368 (541) 488-5300 VENDOR: 003566 SHIP TO: PATHWAY ENTERPRISES INC 1600 SKY PARK DR STE 101 MEDFORD, OR 97504 FOB Point: Req. No.: Terms: net Dept.: Req. Del. Date: Contact: Rachel Dials Special Inst: Confirming? NO Quantity Unit Description Unit Price Ext. Price Janitorial Services - FY 2015 55,392.24 Contract for Janitorial Services Beqinninq date: July 2, 2014 Completion date: June 30, 2015 SUBTOTAL, 55 392.24 BILL TO: TAX 0.00 FREIGHT 0.00 TOTAL 55;392.24 Account Number Project Number Amount Account Number Project Number Amount E 211.12.02.06.60416 55,392.24 !1~ 1~ ~sll Authorized S ature 2~~~ VENDOR COPY FORM #3 CITY OF ASHLAND REQUISITION Date of request: Required date for delivery: _ Vendor Name e:~ et Address, City, State, Zip y V Contact Name & Telephone Number Fax Number SOURCING METHOD ❑ Exempt from Competitive Bidding ❑ Emergency ❑ Reason for exemption: ❑ Invitation to Bid (Copies on file) ❑ Form #13, Written findings and Authorization ❑ AMC 2.50 Date approved by Council: ❑ Written quote or proposal attached ❑ Written quote or proposal attached ❑ Small Procurement COOP rative Procurement Less than $5,000 ❑ Request for Proposal (Copies on file) State of Oregon ❑ Direct Award Date approved by Council OR ~ " ❑ Verbal/Written quote(s) or proposal(s) ❑ State of Washington Intermediate Procurement ❑ Sole Source Contract # ~r~ GOODS & SERVICES ❑ Applicable Form (#5,6, 7 or 8) ❑ Other government agency contract $5.000 to $100.000 ❑ Written quote or proposal attached Agency ❑ (3) Written quotes and solicitation attached ❑ Form #4, Personal Services $5K to $75K Contract PERSONAL SERVICES Intergovernmental Agreement ❑ Special Procurement $5,000 to $75,000 ❑ Form #9, Request for Approval ❑ Agency ❑ Less than $35,000, by direct appointment ❑ Written quote or proposal attached Date original contract approved by Council: ❑ (3) Written proposals/written solicitation Date approved by Council:. (Date) ❑ Form #4, Personal Services $5K to $75K Valid until: -(Date) I Description of SERVICES Total Cost $ . Item # Quantity nit Description of MATERIALS Unit Price Total Cost TOTAL COST ❑ Per attached quotelproposal $ Z l Project Number Account NumberzL(_A-L421-04. ~AOylt~~ ')/15gZ Account Number Account Number *Expenditure must be charged to the appropriate account numbers for the financials to accurately reflect the actual expenditures. IT Director in collaboration with department to approve all hardware and software purchases: IT Director Date Support-Yes/No By signing this requisi 'on form, l certify that the City's public contracting requirements have been satisfied. Employee: ` G Department Head: O (Equal to or greatrar than $5,000) Department Manager/Supervisor: City Administrator: L r- - ' p (Equal,to or greater than $25,000) Funds appropriated for current fiscal year CYES~ % NO I /L Finance Director (Equal to orgreater t an $5,000) Date Comments: Form #3 - Requisition