Homework Help is Here – Start Your Trial Now!
Business
Operations Management
3-4) How many pounds of beans will Taco Loco have left over if they produce the optimal quantity of products X, Y, and Z? A) 28.73 B) 39.27 C) 0 D) 1E + 30 3-5) What is the increase in revenue if Taco Loco purchases 20 pounds of cheese for $1 and uses it optimally? A) $0 B) $9.09 C) $29.00  D) $158.18

3-4) How many pounds of beans will Taco Loco have left over if they produce the optimal quantity of products X, Y, and Z? A) 28.73 B) 39.27 C) 0 D) 1E + 30 3-5) What is the increase in revenue if Taco Loco purchases 20 pounds of cheese for $1 and uses it optimally? A) $0 B) $9.09 C) $29.00  D) $158.18

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
See similar textbooks
icon
Related questions
Question

3-4) How many pounds of beans will Taco Loco have left over if they produce the optimal quantity of products X, Y, and Z?

A) 28.73

B) 39.27

C) 0

D) 1E + 30

3-5) What is the increase in revenue if Taco Loco purchases 20 pounds of cheese for $1 and uses it optimally?

A) $0

B) $9.09

C) $29.00 

D) $158.18



Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SC$4 1.45 14 0.63 5.33 $D$4 Y 8.36 13 8 0.56 SES4 -0.818 17 0.818 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$6 Beef 28 0.45 28 10.22 SF$7 Cheese 80 1.45 80 46 5.33 $F$8 Beans 39.27 68 1E+30 28.73
Transcribed Image Text:Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SC$4 1.45 14 0.63 5.33 $D$4 Y 8.36 13 8 0.56 SES4 -0.818 17 0.818 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$6 Beef 28 0.45 28 10.22 SF$7 Cheese 80 1.45 80 46 5.33 $F$8 Beans 39.27 68 1E+30 28.73
Тасо Loco Taco Loco is considering a new addition to their menu. They have test marketed a number of possibilities and narrowed them down to three new products, X, Y, and Z. Each of these products is made from a different combination of beef, beans, and cheese, and each product has a price point. Taco Loco feels they can sell an X for $17, a Y for $13, and a Z for $14. The company's management science consultant formulates the following linear programming model for company management. Max R = 14Z+ 13Y + 17X %3D subject to: Beef 2Z + 3Y + 4X< 28 Cheese 9Z + 8Y+11X<80 Beans 4Z +4Y + 2X < 68 X,Y,Z >0 The sensitivity report from the computer model reads as follows:
Transcribed Image Text:Тасо Loco Taco Loco is considering a new addition to their menu. They have test marketed a number of possibilities and narrowed them down to three new products, X, Y, and Z. Each of these products is made from a different combination of beef, beans, and cheese, and each product has a price point. Taco Loco feels they can sell an X for $17, a Y for $13, and a Z for $14. The company's management science consultant formulates the following linear programming model for company management. Max R = 14Z+ 13Y + 17X %3D subject to: Beef 2Z + 3Y + 4X< 28 Cheese 9Z + 8Y+11X<80 Beans 4Z +4Y + 2X < 68 X,Y,Z >0 The sensitivity report from the computer model reads as follows:
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.
SEE MORE TEXTBOOKS