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
| File | Type | Posted |
|---|---|---|
| Vendor Questions Worksheet.docx | DOCX document | |
| Schedule A - Statement of Work - Services & Commodities.docx | DOCX document | |
| Schedule F - Federal Provisions Addendum.docx | DOCX document | |
| Bidder Q&A RFP 260000002176.docx | DOCX document | |
| Scheudle H - PayPoint Merchant Integration Guide.pdf | ||
| Standard Contract Terms.docx | DOCX document | |
| Schedule G - Electronic Receipt Processing Standard.pdf | ||
| Schedule B - Pricing.docx | DOCX document | |
| Schedule C - Insurance Requirements - Standard 4 Umbrella Cyber Crime.docx | DOCX document | |
| Proposal Instructions.docx | DOCX document | |
| Schedule D - Service Level Agreement - Services & Commodities.docx | DOCX document | |
| Confidential Treatment Form.docx | DOCX document |
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 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 .