Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2 3 Harvest Food Bank ( HFB ) is an organization that provides donated food to people in need across the state of South Carolina.
Harvest Food Bank HFB is an organization that provides donated food to people in need across the state of South Carolina. One of HFBs main goals is to efficiently use its budget and resources to increase food and dollar donations, which it raises through various promotional initiatives and events. HFB holds different kinds of promotional initiatives that are listed in the accompanying spreadsheet Download accompanying spreadsheet. HFB can hold a number of events throughout the year for each initiative. For example, HFB can hold up to food drives a year for the food drive initiative. Each event consumes HFBs resources, eg paid staff, volunteers. The per event resource need for each event is given the associated spreadsheet.Each event may bring in dollar or food donations. For example, food drives bring pounds of food but $ donations whereas Church Drives II bring pounds of food and $ Some other events may bring both food and dollar donations.The objective of the organization is to maximize the number of meals yielded. Because HFB aims to ultimately serve food to people and uses meals served per year as a performance metric, the food and dollar donations from each promotional initiative must be converted into a final mealsyield metric. Per HFBs guidance, you must use the conversion standard of one meal pounds of food a dollar donation of cents to calculate the meals yield per event, which constitute the objective function coefficients in the optimization model.For any event where there are food donations, the organization must spend $ per meal for the distribution of the collected foods. The organization would like the donations collected from promotional initiatives to cover the cost of the distribution. How many events of each initiative should the organization hold to maximize the total mealsyielded?a Write the mathematical formulation and solve this problem using Excel. Please write the optimal objective function value in the space below and submit the
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started