Answered step by step
Verified Expert Solution
Link Copied!

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.

23Harvest Food Bank (HFB) is an organization that provides donated food to people in need across the state of South Carolina. One of HFB's 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 13 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 4200 food drives a year for the food drive initiative. Each event consumes HFBs resources, e.g., 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 300 pounds of food but $0 donations whereas Church Drives II bring 0 pounds of food and $825. 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 meals-yield metric. Per HFBs guidance, you must use the conversion standard of one meal =1.3 pounds of food = a dollar donation of 20 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 $0.20 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 meals-yielded?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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer

12th Edition

978-0073526706, 9780073526706

Students also viewed these General Management questions