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?
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.
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...
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.
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...
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?
-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...
All products have different price demand elasticities. For example, many food items have elastic demand due...
All products have different price demand elasticities. For example, many food items have elastic demand due to the substitutes available. Select a good or service (NOTE: Do not pick a class of goods but a specific good) that has not already been selected by another student and describe in three separate short paragraphs: First paragraph: The good's or services' price demand elasticity and income elasticity. Discuss which of the elasticity rules you used to determine your answer. Note - do...
Duo Co needs to increase production capacity to meet increasing demand for an existing product, ‘Quago’,...
Duo Co needs to increase production capacity to meet increasing demand for an existing product, ‘Quago’, which is used in food processing. A new machine, with a useful life of four years and a maximum output of 600,000 kg of Quago per year, could be bought for $800,000, payable immediately. The scrap value of the machine after four years would be $30,000. Forecast demand and production of Quago over the next four years is as follows: Year 1 2 3...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT