Meal_Prep_Budget_Personnel_Justification_Forms_RFP_20230501.xlsx

XLSX spreadsheet 36 KB Posted

Attached to
Meal Preparation Services - Food & Friends Senior Meals
Solicitation number
S-X15050-00006759
Issued by
Jackson County, Oregon

About this file

This document is a Meal Preparation Budget Worksheet related to a contract opportunity for Meal Preparation Services in Marion County and the City of Salem, Oregon. The worksheet includes budget projections for Fiscal Years 2024-2026, with a total anticipated number of 235,000 meals to be prepared over the base contract period. The worksheet details line item costs for personnel, including salaries, wages, benefits, and payroll taxes, as well as materials and services such as accounting, advertising, food packaging, and raw food. The contract opportunity is being offered by the State of Oregon, with Marion County and the City of Salem identified as the participating jurisdictions.

The pricing terms include a unit cost per meal, with the worksheet projecting a unit cost of $0.000 per meal. The document does not mention any set-asides, incumbent providers, or specific funding sources. However, it does outline the expected personnel requirements, including drivers, a driver/kitchen supervisor, and other unspecified positions, with a total of 2.5 Full-Time Equivalent (FTE) positions projected across the three-year contract period.

View the file

Other files

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

Meal Preparation Meal Preparation Budget Worksheet

Proposer:

Anticipated Number of Meals for Base Contract: 235,000

Fiscal Year 2024 - July 1, 2023 to June 30, 2024Fiscal Year 2025 - July 1, 2024 to June 30, 2025Fiscal Year 2026 - July 1, 2025 to June 30, 2026
Line Item DescriptionFood PreparationPersonnel ManagementTotalFood PreparationPersonnel ManagementTotalFood PreparationPersonnel ManagementTotal
Personnel:
Salaries/Wages (from Personnel Worksheets)- 0- 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Benefits (from Personnel Worksheets)- 0- 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subtotal Personnel:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Materials and Services:
Accounting Services- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Advertising- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Dues and Memberships- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Food Packaging- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Information Systems Support- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Insurance- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Laundry/Linen- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Legal Services- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Licenses and Permits- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Office Supplies- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Other (Specify): _______________________- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Other (Specify): _______________________- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Other (Specify): _______________________- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Postage/Freight- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Printing/Copying- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Professional Dietician- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Raw Food- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Rentals and Leases- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Repairs and Maintenance- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Seminar Registration Costs- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Telephone/Fax- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Training Costs/Materials- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Trash Removal- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Travel- 0- 0$ - 0- 0- 0$ - 0- 0- 0$ - 0
Subtotal Materials and Services:$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Indirect Charges (Proposer rate for all programs)$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Profit (% of Personnel and M&S only)
0.00%$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
TOTAL$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Unit Cost Per Meal$0.000$0.000$0.000$0.000$0.000$0.000$0.000$0.000$0.000
Profit % of TotalERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!

Personnel Prep & Drivers

PERSONNEL JUSTIFICATION FORM - FOOD PREPARATION & PACKAGING AND DRIVERS

Proposer:

Meal Preparation Budget 2024 - July 1, 2023 - June 30, 2024Meal Preparation Budget 2025 - July 1, 2024 - June 30, 2025Meal Preparation Budget 2026 - July 1, 2025 - June 30, 2026
Number of PersonsPosition or TitleHourly Rate# Hours Per Day on Project# Days Service on Project for Fiscal YearCostNumber of PersonsPosition or TitleHourly Rate# Hours Per Day on Project# Days Service on Project for Fiscal YearCostNumber of PersonsPosition or TitleHourly Rate# Hours Per Day on Project# Days Service on Project for Fiscal YearCost
1Jackson County Driver 1$ - 07248$ - 01Jackson County Driver 1$ - 07248$ - 01Jackson County Driver 1$ - 07248$ - 0
1Jackson County Driver 2$ - 05248$ - 01Jackson County Driver 2$ - 05248$ - 01Jackson County Driver 2$ - 05248$ - 0
1Driver/Kitchen Supervisor$ - 08248$ - 01Driver/Kitchen Supervisor$ - 08248$ - 01Driver/Kitchen Supervisor$ - 08248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
3SUBTOTAL PERSONNEL WAGE COSTTOTAL FTE2.50$ - 03SUBTOTAL PERSONNEL WAGE COSTTOTAL FTE2.50$ - 03SUBTOTAL PERSONNEL WAGE COSTTOTAL FTE2.50$ - 0
Employer Payroll TaxesWage CapRateCostEmployer Payroll TaxesWage CapRateCostEmployer Payroll TaxesWage CapRateCost
FICA/MEDEmployer FICA/Medicare Tax7.65%$ - 0FICA/MEDEmployer FICA/Medicare Tax7.65%$ - 0FICA/MEDEmployer FICA/Medicare Tax7.65%$ - 0
FUTAFederal Unemployment Tax (Capped at $7,000 annual wages)$ 7,000.006.00%$ - 0FUTAFederal Unemployment Tax (Capped at $7,000 annual wages)$ 7,000.006.00%$ - 0FUTAFederal Unemployment Tax (Capped at $7,000 annual wages)$ 7,000.006.00%$ - 0
SUTAState Unemployment Tax (Enter Proposer's current rate)$ 50,900.00$ - 0SUTAState Unemployment Tax (Enter Proposer's current rate)$ 50,900.00$ - 0SUTAState Unemployment Tax (Enter Proposer's current rate)$ 50,900.00$ - 0
PLOEmployer Cost of Paid Leave Oregon0.40%$ - 0PLOEmployer Cost of Paid Leave Oregon0.40%$ - 0PLOEmployer Cost of Paid Leave Oregon0.40%$ - 0
Workers' CompWorkers' Compensation Coverage (Enter Proposer's current rate as % of wage cost)$ - 0Workers' CompWorkers' Compensation Coverage (Enter Proposer's current rate as % of wage cost)$ - 0Workers' CompWorkers' Compensation Coverage (Enter Proposer's current rate as % of wage cost)$ - 0
Employer Costs for Employee Benefits - Enter Annual Cost per Employee or Accrual RateAnnual CostAccrual RateCostEmployer Costs for Employee Benefits - Enter Annual Cost per Employee or Accrual RateAnnual CostAccrual RateCostEmployer Costs for Employee Benefits - Enter Annual Cost per Employee or Accrual RateAnnual CostAccrual RateCost
MedicalEmployer Cost of Benefits - Medical, Dental, Vision$ - 00.00%$ - 0MedicalEmployer Cost of Benefits - Medical, Dental, Vision$ - 00.00%$ - 0MedicalEmployer Cost of Benefits - Medical, Dental, Vision$ - 00.00%$ - 0
HSAEmployer Provided Health Savings Account$ - 00.00%$ - 0HSAEmployer Provided Health Savings Account$ - 00.00%$ - 0HSAEmployer Provided Health Savings Account$ - 00.00%$ - 0
401(k)Employer 401(k) Contribution/Match$ - 00.00%$ - 0401(k)Employer 401(k) Contribution/Match$ - 00.00%$ - 0401(k)Employer 401(k) Contribution/Match$ - 00.00%$ - 0
Paid LeaveAccrual Rate for Paid Leave - Holiday, Vacation, and Sick0.00%$ - 0Paid LeaveAccrual Rate for Paid Leave - Holiday, Vacation, and Sick0.00%$ - 0Paid LeaveAccrual Rate for Paid Leave - Holiday, Vacation, and Sick0.00%$ - 0
$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0
$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0
$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0
$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0
SUBTOTAL PERSONNEL TAXES AND BENEFITS$ - 0SUBTOTAL PERSONNEL TAXES AND BENEFITS$ - 0SUBTOTAL PERSONNEL TAXES AND BENEFITS$ - 0
TOTAL PERSONNEL EXPENSE$ - 0TOTAL PERSONNEL EXPENSE$ - 0TOTAL PERSONNEL EXPENSE$ - 0

Personnel Management

PERSONNEL JUSTIFICATION FORM - MANAGEMENT

Proposer:

Meal Preparation Budget 2024 - July 1, 2023 - June 30, 2024Meal Preparation Budget 2025 - July 1, 2024 - June 30, 2025Meal Preparation Budget 2026 - July 1, 2025 - June 30, 2026
Number of PersonsPosition or TitleHourly Rate# Hours Per Day on Project# Days Service on Project for Fiscal YearCostNumber of PersonsPosition or TitleHourly Rate# Hours Per Day on Project# Days Service on Project for Fiscal YearCostNumber of PersonsPosition or TitleHourly Rate# Hours Per Day on Project# Days Service on Project for Fiscal YearCost
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
$ - 0248$ - 0$ - 0248$ - 0$ - 0248$ - 0
0SUBTOTAL PERSONNEL WAGE COSTTOTAL FTE0.00$ - 00SUBTOTAL PERSONNEL WAGE COSTTOTAL FTE0.00$ - 00SUBTOTAL PERSONNEL WAGE COSTTOTAL FTE0.00$ - 0
Employer Payroll TaxesWage CapRateCostEmployer Payroll TaxesWage CapRateCostEmployer Payroll TaxesWage CapRateCost
FICA/MEDEmployer FICA/Medicare Tax7.65%$ - 0FICA/MEDEmployer FICA/Medicare Tax7.65%$ - 0FICA/MEDEmployer FICA/Medicare Tax7.65%$ - 0
FUTAFederal Unemployment Tax (Capped at $7,000 annual wages)$ 7,000.006.00%$ - 0FUTAFederal Unemployment Tax (Capped at $7,000 annual wages)$ 7,000.006.00%$ - 0FUTAFederal Unemployment Tax (Capped at $7,000 annual wages)$ 7,000.006.00%$ - 0
SUTAState Unemployment Tax (Enter Proposer's current rate)$ 50,900.00$ - 0SUTAState Unemployment Tax (Enter Proposer's current rate)$ 50,900.00$ - 0SUTAState Unemployment Tax (Enter Proposer's current rate)$ 50,900.00$ - 0
PLOEmployer Cost of Paid Leave Oregon0.40%$ - 0PLOEmployer Cost of Paid Leave Oregon0.40%$ - 0PLOEmployer Cost of Paid Leave Oregon0.40%$ - 0
Workers' CompWorkers' Compensation Coverage (Enter Proposer's current rate as % of wage cost)$ - 0Workers' CompWorkers' Compensation Coverage (Enter Proposer's current rate as % of wage cost)$ - 0Workers' CompWorkers' Compensation Coverage (Enter Proposer's current rate as % of wage cost)$ - 0
Employer Costs for Employee Benefits - Enter Annual Cost per Employee or Accrual RateAnnual CostAccrual RateCostEmployer Costs for Employee Benefits - Enter Annual Cost per Employee or Accrual RateAnnual CostAccrual RateCostEmployer Costs for Employee Benefits - Enter Annual Cost per Employee or Accrual RateAnnual CostAccrual RateCost
MedicalEmployer Cost of Benefits - Medical, Dental, Vision$ - 00.00%$ - 0MedicalEmployer Cost of Benefits - Medical, Dental, Vision$ - 00.00%$ - 0MedicalEmployer Cost of Benefits - Medical, Dental, Vision$ - 00.00%$ - 0
HSAEmployer Provided Health Savings Account$ - 00.00%$ - 0HSAEmployer Provided Health Savings Account$ - 00.00%$ - 0HSAEmployer Provided Health Savings Account$ - 00.00%$ - 0
401(k)Employer 401(k) Contribution/Match$ - 00.00%$ - 0401(k)Employer 401(k) Contribution/Match$ - 00.00%$ - 0401(k)Employer 401(k) Contribution/Match$ - 00.00%$ - 0
Paid LeaveAccrual Rate for Paid Leave - Holiday, Vacation, and Sick0.00%$ - 0Paid LeaveAccrual Rate for Paid Leave - Holiday, Vacation, and Sick0.00%$ - 0Paid LeaveAccrual Rate for Paid Leave - Holiday, Vacation, and Sick0.00%$ - 0
$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0
$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0
$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0
$ - 00.00%$ - 0$ - 00.00%$ - 0$ - 00.00%$ - 0
SUBTOTAL PERSONNEL TAXES AND BENEFITS$ - 0SUBTOTAL PERSONNEL TAXES AND BENEFITS$ - 0SUBTOTAL PERSONNEL TAXES AND BENEFITS$ - 0
TOTAL PERSONNEL EXPENSE$ - 0TOTAL PERSONNEL EXPENSE$ - 0TOTAL PERSONNEL EXPENSE$ - 0

File details come from the government source that posted it. Updated .