Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem Definition: The Northern Food Bank serves over 5 0 0 low - income and homeless families in 5 counties struggling with food insecurity. The
Problem Definition:
The Northern Food Bank serves over lowincome and homeless families in counties struggling with food insecurity. The food bank distributes customized meal kits containing recipes and pantry ingredients tailored by family size several times per week.
There are four meal kit offerings: Individual person Small Family people Medium Family people and Large Family people Each requires different ingredients and quantities to meet nutritional guidelines.
However, fluctuating ingredient donations, limited storage, and tight volunteer packing capacity constraints total weekly meal kits. But total demand, especially from big families, often exceeds what's available. Each week, the cost of the meal kits Northern Food Bank can provide is $ Due to storage limits there is a weekly cap of individual kits and for premade small kits. They have enough freezer capacity to stock medium kits. Since large kits require a significant amount of storage space, the weekly capacity for them is at kits.
Therefore, similar to airline ticket revenue management, the food bank needs an optimization model to determine the right mix of meal kits to prepare during each distribution bank to maximize vulnerable community members supported under constrained supplies while prioritizing larger families.
The problem is to optimize the preparation of meal kit types to maximize the total family members served under changing ingredient availability and logistical constraints.
Problem Formulation: We define the sets, parameters, and variables used to formulate the problem.
Sets:
K : the type of kits individual small, medium, large
F : the family sizes member, members, members, members, etc.
Parameters:
Dkf : demand for meal kits of type k prepared for families of size f
Skf : supply of ingredients available for meal kits of type k prepared for families of size f
Ckf : capacity constraint for meal kits of type k for families of size f
Pkf : cost constraint weekly for meal kits of type k for families of size f
Decision variables:
Xkf: The number of meal kits of type k prepared for families of size f
Objective function:
Maximize total family members served Xkf f
Constraints:
Demand:
Xkf Dkf
Supply:
Xkf Skf
Cost:
Xkf Pkf
Capacity:
XI
Xs
Xm
XL
Sign restriction:
Xkf
Solve this on Excel
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