TOTALPRICE.xlsx
XLSX spreadsheet 17 KB Posted
- Attached to
- In-home care services for OCWCOG.
- Solicitation number
- S-R02706-00002817
- Issued by
- Lane County, Oregon
About this file
This document is an Excel spreadsheet titled "TOTALPRICE.xlsx" that is an attachment to a state and local contract opportunity for in-home care services in Linn, Benton and Lincoln counties in Oregon. The spreadsheet contains fields for the proposer to enter information such as the blended hourly rate, units to be purchased, personnel costs, benefits, and other service and supply expenses for each scenario. The contract opportunity is being issued by the Oregon Cascades West Council of Governments (OCWCOG) and covers the service area of Linn County, Albany City, and Albany City.
The spreadsheet provides a template for the proposer to detail their total projected costs, including personnel costs, benefits, and other service and supply expenses. The form has cells for the proposer to enter the number of direct service positions, the percentage of program support, and the grand total expense for each line item. The total office costs are then calculated based on the entered information.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| NOTICE OF INTENT TO AWARD.pdf | ||
| OFFICEPRICE.xlsx | XLSX spreadsheet | |
| Amendment 3 - Bid Opening Information.pdf | ||
| Blue Mountain Community College Bookstore RFP 4.12.22.pdf | ||
| Notification of Bidders.pdf | ||
| Amendment 2.pdf | ||
| OCWCOG SDS - In-home Services on OregonBuys.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Total Price
| FORMS ATTACHMENT B: TOTALPRICE.XLS |
| TOTAL COSTS, ALL LOCATIONS |
| Instructions: Enter projected numbers in fields highlighted yellow. All other fields will auto-populate. |
| Complete a new spreadsheet for each scenario, for each office |
| 1. PROPOSER NAME: |
| 2. SCENARIO#: |
| 3. BLENDED |
HOURLY RATE:
4. UNITS TO BE
PURCHASED:
| 5. ITEMIZED PROJECTED COSTS | |||||||
| PERSONNEL COSTS | # of | Direct Service | % of | Program Support | % of | GRAND | |
| Positions (by job category) | Positions | FTE | Expense - Total Salary | Grand Total | Expense - Total Salary | Grand Total | TOTAL |
| EXAMPLE | 3 | 0.75 | 5000 | 25.00% | 15000 | 75.00% | $20,000 |
| 1 | 5 | 2000 | 20.00% | 8000 | 80.00% | $10,000 | |
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 |
| Direct Service | % of | Program Support | % of | GRAND | |||
| BENEFITS/FRINGE/OTHER | |||||||
| PERSONNEL | Total Expense | Grand Total | Total Expense | Grand Total | TOTAL | ||
| Benefits | 10000 | 66.67% | 5000 | 33.33% | $15,000 | ||
| FICA | ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | ||||
| Workers' Comp | ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | ||||
| Unemployment | ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | ||||
| Leave | ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | ||||
| Medical/Dental Ins. | ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | ||||
| Retirement | ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | ||||
| Other (Specify): | ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | ||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0 | |||||
| SUBTOTAL PERSONNEL | |||||||
| COSTS | $17,000.00 | 37.78% | $28,000.00 | 62.22% | $45,000.0 | ||
| Direct Service | % of | Program Support | % of | GRAND | |||
| SERVICE & SUPPLIES | Expense | Grand Total | Expense | Grand Total | TOTAL | ||
| Rent/Lease | 2000 | 25.00% | 6000 | 75.00% | $8,000.00 | ||
| Utilities (gas, electric, etc) | ERROR:#DIV/0! | ERROR:#DIV/0! | $0.00 | ||||
| Janitorial/Maintenance | ERROR:#DIV/0! | ERROR:#DIV/0! | $0.00 | ||||
| Advertising | ERROR:#DIV/0! | ERROR:#DIV/0! | $0.00 | ||||
| Postage | ERROR:#DIV/0! | ERROR:#DIV/0! | $0.00 | ||||
| Printing | ERROR:#DIV/0! | ERROR:#DIV/0! | $0.00 | ||||
| Office supplies | ERROR:#DIV/0! | ERROR:#DIV/0! | $0.00 | ||||
| Equipment | ERROR:#DIV/0! | ERROR:#DIV/0! | $0.00 | ||||
| Equipment repair | ERROR:#DIV/0! | ERROR:#DIV/0! | $0.00 | ||||
| Training | ERROR:#DIV/0! | ERROR:#DIV/0! | $0.00 | ||||
| Travel (exclude mileage) | ERROR:#DIV/0! | ERROR:#DIV/0! | $0.00 | ||||
| Mileage | ERROR:#DIV/0! | ERROR:#DIV/0! | $0.00 | ||||
| Audit | ERROR:#DIV/0! | ERROR:#DIV/0! | $0.00 | ||||
| Consulting | ERROR:#DIV/0! | ERROR:#DIV/0! | $0.00 | ||||
| Insurance | ERROR:#DIV/0! | ERROR:#DIV/0! | $0.00 | ||||
| Administrative fee | ERROR:#DIV/0! | ERROR:#DIV/0! | $0.00 | ||||
| Other (specify): | ERROR:#DIV/0! | ERROR:#DIV/0! | $0.00 | ||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0.00 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0.00 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0.00 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0.00 | |||||
| ERROR:#DIV/0! | ERROR:#DIV/0! | $0.00 | |||||
| SUBTOTAL SERVICE & SUPPLIES | $2,000.00 | 25.00% | $6,000.00 | 75.00% | $8,000.00 |
| TOTAL OFFICE COSTS | $19,000.00 | 35.85% | $34,000.00 | 64.15% | $53,000.0 | ||
| BLENDED HOURLY RATE: | 0 | ||||||
| UNITS TO BE PURCHASED: | 0 | ||||||
| COST OF UNITS BY | |||||||
| HOURLY RATE | $0 |
Sheet1
File details come from the government source that posted it. Updated .