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
| File | Type | Posted |
|---|---|---|
| Scheudle H - PayPoint Merchant Integration Guide.pdf | ||
| Schedule G - Electronic Receipt Processing Standard.pdf | ||
| Schedule C - Insurance Requirements - Standard 4 Umbrella Cyber Crime.docx | DOCX document | |
| Standard Contract Terms.docx | DOCX document | |
| Schedule D - Service Level Agreement - Services & Commodities.docx | DOCX document | |
| Schedule F - Federal Provisions Addendum.docx | DOCX document | |
| Schedule A - Statement of Work - Services & Commodities.docx | DOCX document | |
| Proposal Instructions.docx | DOCX document | |
| Schedule B - Pricing.docx | DOCX document |
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 1 | Year 2 | |||||||||
| MVH CT Estimated Volumes to Calculate Annual Food Cost | Unit of Measure | Estimated Number of Members | Estimated Number of Meals per Day | Units Per Year | Estimated Annual Cost ($) | Unit of Measure | Estimated Number of Members | Estimated Number of Meals per Day | Units Per Year | Estimated Annual Cost ($) |
| Breakfast - Regular / Modified | Meal | 123 | 1 | 44895 | Meal | 123 | 1 | 44895 | ||
| Lunch - Regular / Modified | Meal | 123 | 1 | 44895 | Meal | 123 | 1 | 44895 | ||
| Dinner - Regular / Modified | Meal | 123 | 1 | 44895 | Meal | 123 | 1 | 44895 | ||
| Employee and Guest Meals | Meal | 100 | 36500 | Meal | 100 | 1 | 36500 | |||
| Large Portion - Entrée | Each | 70 | 18200 | Each | 70 | 25550 | ||||
| Large Portion - Non-Entrée | Each | 40 | 10400 | Each | 40 | 14600 | ||||
| Always Available Entrée | Each | 610 | 222650 | Each | 610 | 222650 | ||||
| Always Available Regular Side | Each | 4335 | 1582275 | Each | 4335 | 1582275 | ||||
| Snacks and Nourishments | Each | 2560 | 934400 | Each | 2560 | 934400 |
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 Cost | ERROR:#DIV/0! | $0.00 | ERROR:#DIV/0! | $0.00 | |
| Consumable Supplies | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Salaries and Wages | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Payroll Taxes and Fringe Benefits | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Equipment and Service Ware | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Overhead Expenses | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Fixed Monthly Management Support Fee | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Total Year 1 | ERROR:#DIV/0! | $0.00 | Total Year 2 | ERROR:#DIV/0! | $0.00 |
| Michigan Veteran Homes - D.J. Jacobetti (MVHDJJ) |
TABLE 1 - Estimated Annual Food Cost
| Year 1 | Year 2 | |||||||||
| MVHDJJ Estimated Volumes to Calculate Annual Food Cost | Unit of Measure | Estimated Number of Members | Estimated Number of Meals per Day | Units Per Year | Estimated Annual Cost ($) | Unit of Measure | Estimated Number of Members | Estimated Number of Meals per Day | Units Per Year | Estimated Annual Cost ($) |
| Breakfast - Regular / Modified | Meal | 101 | 1 | 36865 | Meal | 101 | 1 | 36865 | ||
| Lunch - Regular / Modified | Meal | 102 | 1 | 37230 | Meal | 102 | 1 | 37230 | ||
| Dinner - Regular / Modified | Meal | 103 | 1 | 37595 | Meal | 103 | 1 | 37595 | ||
| Employee and Guest Meals | Meal | 15 | 5475 | Meal | 15 | 5475 | ||||
| Large Portion - Entrée | Each | 60 | 21900 | Each | 60 | 21900 | ||||
| Large Portion - Non-Entrée | Each | 35 | 12775 | Each | 35 | 12775 | ||||
| Always Available Entrée | Each | 510 | 186150 | Each | 510 | 186150 | ||||
| Always Available Regular Side | Each | 3615 | 1319475 | Each | 3615 | 1319475 | ||||
| Snacks and Nourishments | Each | 2135 | 779275 | Each | 2135 | 779275 |
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 Cost | ERROR:#DIV/0! | $0.00 | ERROR:#DIV/0! | $0.00 | |
| Consumable Supplies | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Salaries and Wages | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Payroll Taxes and Fringe Benefits | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Equipment and Service Ware | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Overhead Expenses | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Fixed Monthly Management Support Fee | ERROR:#DIV/0! | ERROR:#DIV/0! | |||
| Total Year 1 | ERROR:#DIV/0! | $0.00 | Total Year 2 | ERROR:#DIV/0! | $0.00 |
File details come from the government source that posted it. Updated .