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

60.1K

Verified Solution

Question

Advance Math

  1. Three materials X, Y, and Z are required to produce twoproducts A and B. The profit function of each product is nonlinear.The total profit function for Product A is 80A - A2 and the totalprofit function for Product B is 72B - 0.8B2. Thus, the totalprofit 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) tosolve the nonlinear profit function for this problem. (Note: thisproblem does not have a constraint.) What is the optimal productionquantity for each product? What is the total profit? Why is thesolution optimal? Is the total profit function a function withdecreasing marginal return? Why?

b. Following information about resourcerequirement and availability is given. Formulate the problem withconstraints as a nonlinear programming model on the spreadsheet tomaximize 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 NonlinearSolver. What is the optimal solution? What is the maximum totalprofit?

D. Explain why solutions in (a) and (c) aredifferent.

E. Formulate the problem in (b) as an algebraicmodel.

Answer & Explanation Solved by verified expert
3.9 Ratings (661 Votes)
PLEASE LIKE AND GOOD RATEaThe model is shown belowThe formulas are shown belowThe solver parameters    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students