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 1
Issued by
Michigan

About this file

This is a pricing worksheet for Michigan's Request for Proposal No. 260000002176 concerning nutritional services at two state veteran homes: Michigan Veteran Homes - Chesterfield Township (MVH CT) and Michigan Veteran Homes - D.J. Jacobetti (MVHDJJ). The worksheet provides estimated annual food volumes and associated costs for both facilities across two contract years. MVH CT serves an estimated 123 members with daily meal counts including 123 breakfast meals, 123 lunch meals, 123 dinner meals, 100 employee and guest meals, plus various à la carte items such as large portions, always-available entrees, sides, and snacks totaling approximately 2.9 million units annually. MVHDJJ serves approximately 306 members across breakfast, lunch, and dinner services (101, 102, and 103 members respectively) with similar supplementary meal options, totaling approximately 2.4 million units annually. Bidders are required to complete pricing allocation tables for Year 1 and Year 2 that categorize costs across food, consumable supplies, salaries and wages, payroll taxes and fringe benefits, equipment and service ware, overhead expenses, and fixed monthly management support fees.

The pricing worksheet requires bidders to allocate estimated annual costs across the specified cost categories, with allocations for each category required to total 100 percent for both contract years. The spreadsheet currently contains placeholder errors indicating that bidders must input their proposed costs and percentage allocations for each line item. Bidders must provide separate pricing for each facility, as MVH CT and MVHDJJ are presented as distinct pricing schedules with their own volume estimates and cost breakdowns. The worksheet establishes the cost structure framework but does not specify contract award amounts, funding sources, or whether incumbent contractor information is applicable to this procurement.

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

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 .