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 PDF
OFFICEPRICE.xlsx XLSX spreadsheet
Amendment 3 - Bid Opening Information.pdf PDF
Blue Mountain Community College Bookstore RFP 4.12.22.pdf PDF
Notification of Bidders.pdf PDF
Amendment 2.pdf PDF
OCWCOG SDS - In-home Services on OregonBuys.pdf 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# ofDirect Service% ofProgram Support% ofGRAND
Positions (by job category)PositionsFTEExpense - Total SalaryGrand TotalExpense - Total SalaryGrand TotalTOTAL
EXAMPLE30.75500025.00%1500075.00%$20,000
15200020.00%800080.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% ofProgram Support% ofGRAND
BENEFITS/FRINGE/OTHER
PERSONNELTotal ExpenseGrand TotalTotal ExpenseGrand TotalTOTAL
Benefits1000066.67%500033.33%$15,000
FICAERROR:#DIV/0!ERROR:#DIV/0!$0
Workers' CompERROR:#DIV/0!ERROR:#DIV/0!$0
UnemploymentERROR:#DIV/0!ERROR:#DIV/0!$0
LeaveERROR:#DIV/0!ERROR:#DIV/0!$0
Medical/Dental Ins.ERROR:#DIV/0!ERROR:#DIV/0!$0
RetirementERROR:#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.0037.78%$28,000.0062.22%$45,000.0
Direct Service% ofProgram Support% ofGRAND
SERVICE & SUPPLIESExpenseGrand TotalExpenseGrand TotalTOTAL
Rent/Lease200025.00%600075.00%$8,000.00
Utilities (gas, electric, etc)ERROR:#DIV/0!ERROR:#DIV/0!$0.00
Janitorial/MaintenanceERROR:#DIV/0!ERROR:#DIV/0!$0.00
AdvertisingERROR:#DIV/0!ERROR:#DIV/0!$0.00
PostageERROR:#DIV/0!ERROR:#DIV/0!$0.00
PrintingERROR:#DIV/0!ERROR:#DIV/0!$0.00
Office suppliesERROR:#DIV/0!ERROR:#DIV/0!$0.00
EquipmentERROR:#DIV/0!ERROR:#DIV/0!$0.00
Equipment repairERROR:#DIV/0!ERROR:#DIV/0!$0.00
TrainingERROR:#DIV/0!ERROR:#DIV/0!$0.00
Travel (exclude mileage)ERROR:#DIV/0!ERROR:#DIV/0!$0.00
MileageERROR:#DIV/0!ERROR:#DIV/0!$0.00
AuditERROR:#DIV/0!ERROR:#DIV/0!$0.00
ConsultingERROR:#DIV/0!ERROR:#DIV/0!$0.00
InsuranceERROR:#DIV/0!ERROR:#DIV/0!$0.00
Administrative feeERROR:#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.0025.00%$6,000.0075.00%$8,000.00
TOTAL OFFICE COSTS$19,000.0035.85%$34,000.0064.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 .