Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored 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

The Brand Management Audit

Authors: Mr Don Knight

1st Edition

0273649345, 978-0273649342

More Books

Students also viewed these Accounting questions

Question

1. Explain how business strategy affects HR strategy.

Answered: 1 week ago