Question

In: Accounting

2. Due to the increasing demand for essential items, Quant Goods Company decided to increase the...

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.

Solutions

Expert Solution

Quantity
Items Units Cost Neighbourhood Capacity
A B C
Toilet Papers Rolls P             0.50           1,000           1,200               800           2,500
Hand Sanitizers Bottles Q             0.65                 50               100                 80               100
Chicken Breast Pounds R             0.70               125                 75                 95               400
Ground Beef Pounds S             0.70               150               100               120

Quant has to satisfy all the requirements of neighbourhoods if they take the contract

It can be seen from the above table that it cannot satisfy two neighbuorhoods at a time as capacity of handsanitizers is 100 bottles and AB, AC, BC, ABC combined together cannot fulfill demand of individual neighboorhoods at available capacity

Since there are capacity constraints to individual item, variables P, Q, R, S is assigned to items.

Ojective Function : Min Cost = 0.5P + 0.65Q+ 0.7R + 0.7Q (to be analysed for neighbourhood A,B, C individually)

Constraints: P <= 2500, Q <=100, R+S <=400


Related Solutions

why is the price elasticity of demand larger for non-essential goods than for essential good?
why is the price elasticity of demand larger for non-essential goods than for essential good?
Due to the market expectations about increasing inflation and in order to increase liquidity in the...
Due to the market expectations about increasing inflation and in order to increase liquidity in the banking industry, the Fed decides to increase required reserve ratio to 15%. At the same time the Fed decrease the actual supply by 1,000 million dollars. What is the change in total trading cash volume in this economy
The MarsX Space Vehicles Company has been very successful. Due to an increase in demand for...
The MarsX Space Vehicles Company has been very successful. Due to an increase in demand for its STS’s, the company had to hire thousands of scientists, engineers and staff from all over the world. As we all know, not all countries use the same system of measurements. The U.S., Liberia and Burma use the English system; while the rest of the world uses the metric system. In addition scientists use specific scales for some of their applications. To avoid confusion...
When prices increase the interest rate effect A. will increase and the aggregate demand for goods...
When prices increase the interest rate effect A. will increase and the aggregate demand for goods and services will decrease. B. will decrease and the aggregate demand for goods and services will decrease. C. will not be affected. D. will increase and the aggregate demand for goods and services will increase.
Assuming an increase in demand for export goods, explain the change in demand curve and labor...
Assuming an increase in demand for export goods, explain the change in demand curve and labor supply, if any.
You are the operations manager at, Sports Unlimited, a firm manufacturing sporting goods. Due to increasing...
You are the operations manager at, Sports Unlimited, a firm manufacturing sporting goods. Due to increasing demand for your products, you are looking into the possibility of outsourcing some of your operations to other countries. After an initial research you have identified 6 critical factors in your location decision. These are: stability of exchange rates, society value of quality work, availability of skilled work force, time orientation attitudes, availability of efficient transportation infrastructure, and government regulation of businesses. The countries...
The demand for skilled workers in the United States has been increasing. To increase the supply...
The demand for skilled workers in the United States has been increasing. To increase the supply of skilled workers, many argue that immigration reform to allow more skilled labor into the United States is needed. Explain whether you agree or disagree. Be thorough please.
Exercise 1.5* 1. Describe the effect on the demand curve due to an increase in (a)...
Exercise 1.5* 1. Describe the effect on the demand curve due to an increase in (a) the price of substitutable goods; (b) the price of complementary goods; (c) advertising expenditure. 2. If the line, P = -Q + 6, is sketched with P on the horizontal axis and Q on the verti- cal axis, find the gradient, m, and the vertical intercept, c. 3. If the demand function of a good is 2P + 3Qp = 60 where P and...
-Demand increases due to increasing interest in a superfood. -Heat wave hurt production – further adding...
-Demand increases due to increasing interest in a superfood. -Heat wave hurt production – further adding to the price hikes. In some cases, supermarket prices for avocado prices doubled in less than six months last year. -consumer prices could skyrocket further if a much-discussed import tax is applied to goods coming into the U.S. from Mexico. According to following conditions above, 1. Describe how the avocado market is impacted in this report. Which curves (i.e., supply and/or demand) are shifting...
a) Increasing the flow rate of the mobile phase would 1. increase longitudinal diffusion. 2. increase...
a) Increasing the flow rate of the mobile phase would 1. increase longitudinal diffusion. 2. increase broadening due to mass transfer. 3. increase broadening due to multiple paths. b) How many 50 mL extractions will it take to remove 95% of Compound A that is in 20 mL of water, if K = 0.3?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT