Schedule B, Attachment 1 - MVH CT & MVHDJJ Pricing Worksheet.xlsx

XLSX spreadsheet 24 KB Posted

Attached to
Nutritional Services at MVH CT and MVHDJJ
Solicitation number
RFP 171 260000002176 3
Issued by
Luce County, Michigan

About this file

This is a pricing worksheet for Request for Proposal No. 260000002176 issued by the State of Michigan for nutritional services at two Michigan Veteran Homes: Chesterfield Township (MVH CT) and D.J. Jacobetti (MVHDJJ). The worksheet establishes estimated annual food volumes and pricing structures for a two-year contract period. For MVH CT, estimated volumes include 123 members with approximately 44,895 meals per meal period annually for breakfast, lunch, and dinner, plus 100 employee and guest meals, 70 large portion entrees, 40 large portion non-entrees, 610 always available entrees, 4,335 regular sides, and 2,560 snacks and nourishments. For MVHDJJ, the operation is smaller with 101-103 members across breakfast, lunch, and dinner service, 15 employee and guest meals, 60 large portion entrees, 35 large portion non-entrees, 510 always available entrees, 3,615 regular sides, and 2,135 snacks and nourishments. Year 1 and Year 2 volumes remain consistent across both facilities.

Bidders are required to provide percentage allocations and estimated annual costs across seven cost categories: Food Cost, Consumable Supplies, Salaries and Wages, Payroll Taxes and Fringe Benefits, Equipment and Service Ware, Overhead Expenses, and Fixed Monthly Management Support Fee. The percentage allocations for each category must total 100 percent for both Year 1 and Year 2. Bidders must complete separate pricing breakdowns for each facility and submit total estimated annual costs for both years. The worksheet contains formula errors in the provided template, indicating that bidders will need to populate the pricing fields with their specific cost proposals and allocations.

View the file

Other files

Show all 12

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

Sheet1

STATE OF MICHIGAN
Request for Proposal No. 260000002176
SCHEDULE B, ATTACHMENT 1- MVH CT & MVHDJJ PRICING WORKSHEET

Michigan Veteran Homes - Chesterfield Township (MVH CT)

TABLE 1 - Estimated Annual Food Cost

Year 1Year 2
MVH CT Estimated Volumes to Calculate Annual Food CostUnit of MeasureEstimated Number of MembersEstimated Number of Meals per DayUnits Per YearEstimated Annual Cost ($)Unit of MeasureEstimated Number of MembersEstimated Number of Meals per DayUnits Per YearEstimated Annual Cost ($)
Breakfast - Regular / ModifiedMeal123144895Meal123144895
Lunch - Regular / ModifiedMeal123144895Meal123144895
Dinner - Regular / ModifiedMeal123144895Meal123144895
Employee and Guest MealsMeal10036500Meal100136500
Large Portion - EntréeEach7018200Each7025550
Large Portion - Non-EntréeEach4010400Each4014600
Always Available EntréeEach610222650Each610222650
Always Available Regular SideEach43351582275Each43351582275
Snacks and NourishmentsEach2560934400Each2560934400

TABLE 2 - Pricing Breakdown

Cost Category Year 1 Bidder % Allocation (Must = 100%) Year 1 Bidder Estimated Annual Cost ($) Year 2 Bidder % Allocation (Must = 100%) Year 2 Bidder Estimated Annual Cost ($)

Food CostERROR:#DIV/0!$0.00ERROR:#DIV/0!$0.00
Consumable SuppliesERROR:#DIV/0!ERROR:#DIV/0!
Salaries and WagesERROR:#DIV/0!ERROR:#DIV/0!
Payroll Taxes and Fringe BenefitsERROR:#DIV/0!ERROR:#DIV/0!
Equipment and Service WareERROR:#DIV/0!ERROR:#DIV/0!
Overhead ExpensesERROR:#DIV/0!ERROR:#DIV/0!
Fixed Monthly Management Support FeeERROR:#DIV/0!ERROR:#DIV/0!
Total Year 1ERROR:#DIV/0!$0.00Total Year 2ERROR:#DIV/0!$0.00
Michigan Veteran Homes - D.J. Jacobetti (MVHDJJ)

TABLE 1 - Estimated Annual Food Cost

Year 1Year 2
MVHDJJ Estimated Volumes to Calculate Annual Food CostUnit of MeasureEstimated Number of MembersEstimated Number of Meals per DayUnits Per YearEstimated Annual Cost ($)Unit of MeasureEstimated Number of MembersEstimated Number of Meals per DayUnits Per YearEstimated Annual Cost ($)
Breakfast - Regular / ModifiedMeal101136865Meal101136865
Lunch - Regular / ModifiedMeal102137230Meal102137230
Dinner - Regular / ModifiedMeal103137595Meal103137595
Employee and Guest MealsMeal155475Meal155475
Large Portion - EntréeEach6021900Each6021900
Large Portion - Non-EntréeEach3512775Each3512775
Always Available EntréeEach510186150Each510186150
Always Available Regular SideEach36151319475Each36151319475
Snacks and NourishmentsEach2135779275Each2135779275

TABLE 2 - Pricing Breakdown

Cost Category Year 1 Bidder % Allocation (Must = 100%) Year 1 Bidder Estimated Annual Cost ($) Year 2 Bidder % Allocation (Must = 100%) Year 2 Bidder Estimated Annual Cost ($)

Food CostERROR:#DIV/0!$0.00ERROR:#DIV/0!$0.00
Consumable SuppliesERROR:#DIV/0!ERROR:#DIV/0!
Salaries and WagesERROR:#DIV/0!ERROR:#DIV/0!
Payroll Taxes and Fringe BenefitsERROR:#DIV/0!ERROR:#DIV/0!
Equipment and Service WareERROR:#DIV/0!ERROR:#DIV/0!
Overhead ExpensesERROR:#DIV/0!ERROR:#DIV/0!
Fixed Monthly Management Support FeeERROR:#DIV/0!ERROR:#DIV/0!
Total Year 1ERROR:#DIV/0!$0.00Total Year 2ERROR:#DIV/0!$0.00

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