Question
2. Due to the increasing demand for essential items, Quant Goods Company decided to increase the weekly production amounts. The local grocery stores reached out
2. Due to the increasing demand for essential items, Quant Goods Company decided to increase the weekly production amounts. The local grocery stores reached out to the company to sign a short-term contract to receive these items from Quant Goods. They noted that the demand for toilet papers, hand sanitizers, chicken breast, and ground beef in three neighborhoods (neighborhood A, B, C) is significantly N. Orkun Baycik, 2020 high. Due to production capacities, Quant Goods cannot supply for all three neighborhoods. Below are the details about the demand and production processes: Quant Goods must produce at least 1000 rolls of toilet papers per week, at least 50 bottles of hand sanitizers, at least 125 pounds of chicken breast, and at least 150 pounds of ground beef for neighborhood A if they decide to sign a contract with this neighborhood. Quant Goods must produce at least 1200 rolls of toilet papers per week, at least 100 bottles of hand sanitizers, at least 75 pounds of chicken breast, and at least 100 pounds of ground beef for neighborhood B if they decide to sign a contract with this neighborhood. Quant Goods must produce at least 800 rolls of toilet papers per week, at least 80 bottles of hand sanitizers, at least 95 pounds of chicken breast, and at least 120 pounds of ground beef for neighborhood C if they decide to sign a contract with this neighborhood. Quant Goods can produce at most 2500 rolls of toilet papers, 100 bottles of hand sanitizers, and 400 pounds of meat (chicken breast and ground beef in total) per week. Producing each roll of toilet paper costs $0.5, each hand sanitizer bottle costs $0.65, and each pound of meat costs $0.70. Quant must decide which neighborhood stores to contract with and determine the production quantities while minimizing the total production costs and satisfying all the requirements listed above.
(a) Define your decision variables.
(b) Write the mathematical model that can be used to solve this problem (must provide the objective function and constraints mathematically). Note that simply providing the Excel solver input will not earn any credit.
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