Three materials X, Y, and Z are required to produce two products A and B. The...

Three materials X, Y, and Z are required to produce two products A and B. The profit function of each product is nonlinear. The total profit function for Product A is 80A - A2 and the total profit function for Product B is 72B - 0.8B2. Thus, the total profit for producing A and B together is 80A - A2

+ 72B - 0.8B2. (These two profit functions are independent.)

a. Use the Nonlinear Solver (GRG Nonlinear) to solve the nonlinear profit function for this problem. (Note: this problem does not have a constraint.) What is the optimal production quantity for each product? What is the total profit? Why is the solution optimal? Is the total profit function a function with decreasing marginal return? Why?

b. Following information about resource requirement and availability is given. Formulate the problem with constraints as a nonlinear programming model on the spreadsheet to maximize the total profit.

	Product A	Product B	Materials Available (kilograms)
Material X	0.8	1.0	40
Material Y		0.4	10
Material Z	1.2	0.6	42
Profit Function	80A - A2	72B - 0.8B2

C. Solve the problem using the Nonlinear Solver. What is the optimal solution? What is the maximum total profit?

D. Explain why solutions in (a) and (c) are different.

E. Formulate the problem in (b) as an algebraic model.

Solutions

Expert Solution

PLEASE LIKE AND GOOD RATE...

The model is shown below

The formulas are shown below

The solver parameters are shown below

The result is shown below. The optimal values are A = 40 and B = 45 and the profit is 3220.

The model is shown below

The formulas are shown below

The solver parameters are shown below

The result is shown below. The optimal values are A = 24.33, B = 20.52 and the profit is 2495.66

The reason why the results are different is because of the constraints in the part c).

PLEASE LIKE AND RATE GOOD .. IT IS VERY LEANTHY QUESTION.

Colby Messinger answered 1 year ago

Next > < Previous

Related Solutions

There are two companies, X and Y, that produce two identical products, A and B. If...

There are two companies, X and Y, that produce two identical products, A and B. If their labor productivity of the respective products is as follows, determine the following advantages: Product A Product B Company X 100 units per labor hour 30 units per labor hour Company Y 40 units per labor hour 60 units per labor hour Who has the absolute advantage in producing A: ______; Who has the absolute advantage in producing B: ______; Who has the comparative...

If X, Y and Z are three arbitrary vectors, prove these identities: a. (X×Y).Z = X.(Y×Z)...

If X, Y and Z are three arbitrary vectors, prove these identities: a. (X×Y).Z = X.(Y×Z) b. X×(Y×Z) = (X.Z)Y – (X.Y)Z c. X.(Y×Z) = -Y.(X×Z)

KUMA makes three products X, Y, and Z. All three products must be offered for sale...

KUMA makes three products X, Y, and Z. All three products must be offered for sale each month in order to provide a complete market service. The products are fragile and their quality deteriorates rapidly once they are manufactured. The products are produced on two types of machine and worked on by a single grade of direct labour. Five direct employees are paid Ghc 8 per hour for a guaranteed minimum of 160 hours each per month. All of the...

Suppose that there are two consumers A and B and two products x and y. The...

Suppose that there are two consumers A and B and two products x and y. The initial endowment W is such that consumer A is endowed with (WXA, WYA) = (1,8) and consumer B is endowed with (WXB, WXB) = (8,27). Both consumers have standard preferences, and their utility functions are the same and equal to UA(xA, yA) = xA * yA2 UB(xB, yB) = xB * yB2. Question 1 -a Determine consumer A and B’s utility at their initial...

A consumer finds only three products, X, Y, and Z, are for sale. The amount of...

A consumer finds only three products, X, Y, and Z, are for sale. The amount of utility which their consumption will yield is shown in the table below. Assume that the prices of X, Y, and Z are $10, $2, and $8, respectively. The consumer has an income of $74 to spend. Product X Product Y Product Z Quantity Utility Marginal Utility per $ Quantity Utility Marginal Utility per $ Quantity Utility Marginal Utility per $ 1 42 _____ 1...

QUESTION 1 KUMA makes three products X, Y, and Z. All three products must be offered...

QUESTION 1 KUMA makes three products X, Y, and Z. All three products must be offered for sale each month in order to provide a complete market service. The products are fragile and their quality deteriorates rapidly once they are manufactured. The products are produced on two types of machine and worked on by a single grade of direct labour. Five direct employees are paid Ghc 8 per hour for a guaranteed minimum of 160 hours each per month. All...

Suppose there are two countries A and B, and they produce good X and Y. Assume...

Suppose there are two countries A and B, and they produce good X and Y. Assume perfect competitive market and labor is the only factor of production. Answer following questions based on David Ricardo's comparative advantage model. In country A, 2 laborers are required to produce one unit of good X and three laborers are required to produce one unit of good Y. In country B, five laborers are required to produce one unit of good X and six laborers...

Monica's Manufacturing produces three products: X, Y, and Z. It has fixed costs of $18,000. X...

Monica's Manufacturing produces three products: X, Y, and Z. It has fixed costs of $18,000. X Y Z Unit selling price $100 $130 $210 Unit variable costs $60 $30 $180 Labor-hours per unit 4 5 3 a. What is the break-even point (in units) if Monica were to sell only product X? b. What is the break-even point (in units) if Monica sells products X, Y, and Z according to the following sales-mix? X Y Z Sales Mix 55% 15%...

BC Company sells three products, X, Y, and Z. During October, Product X had sales of...

BC Company sells three products, X, Y, and Z. During October, Product X had sales of $500,000; Product Y had sales totaling $300,000; and Product Z reported sales of $200,000. ABC Company as a whole reported total fixed costs of $443,000, a total segment margin of $77,000, and a net income of $53,000. The traceable fixed costs for Product X amounted to $80,000 during October and the traceable fixed costs for Product Z were $60,000 in October. Calculate the traceable...

dKristen Company manufactures three products: X, Y, and Z. The demand for each product is 100...

dKristen Company manufactures three products: X, Y, and Z. The demand for each product is 100 units. The selling price, variable expenses, and contribution margin for one unit of each product follow: Product X Y Z Selling price $140 $300 $390 Less variable expenses (Only Special steel) 50 100 150 Contribution margin $90 $200 $240 Steel need to make 1 unit 1 kg 2 kg 3 kg The same special steel is used for...

Subjects