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 2
Issued by
Kent County, Michigan

About this file

This is a pricing worksheet for nutritional services at two Michigan facilities: MVH CT (Michigan Valley Hospital Connecticut) and MVHDJJ (Michigan Valley Hospital Diagnostic and Judicial Judgment). The worksheet establishes the pricing structure for food service operations at both locations, with line items covering various meal categories, dietary accommodations, and ancillary food service components. The pricing framework appears designed to capture unit costs for breakfast, lunch, dinner, and specialized meals across different patient or resident populations, enabling transparent cost comparison among potential bidders.

The pricing worksheet functions as Schedule B, Attachment 1, serving as the standardized pricing template that bidders must complete and submit as part of their proposals. This document allows the state of Michigan to evaluate vendor pricing on a consistent basis across all responding contractors, facilitating competitive analysis and cost-effective selection. Key pricing elements are organized by meal type and service category, with designated fields for unit pricing that enable direct comparison of proposed costs. The worksheet is essential to the procurement evaluation process, as it ensures all bidders present their pricing in identical formats and allows the contracting agency to assess total cost of ownership for nutritional services delivery across both facilities over the contract term.

View the file

Other files

Show all 11

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 .