Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
8th Edition
ISBN: 9781305947412
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 2, Problem 5QP
a)
Summary Introduction
To identify: The nature of constraint.
b)
Summary Introduction
To identify: The nature of constraint.
c)
Summary Introduction
To identify: The nature of constraint.
d)
Summary Introduction
To identify: The nature of constraint.
e)
Summary Introduction
To identify: The nature of constraint.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
find the
a. decision variables
b. objective function
c. constraints
a.) Formulate a LP model of this problem
Fopic 4- Linear Programming: Appli
eBook
Problem 9-05 (Algorithmic)
Kilgore's Deli is a small delicatessen located near a major university. Kilgore's does a large walk-in carry-out lunch business. The deli offers two luncheon chili specials, Wimpy and Dial 911. At the beginning of the day, Kilgore needs to decide how much of each special to make (he always sells out of whatever he
makes). The profit on one serving of Wimpy is $0.46, on one serving of Dial 911, $0.59. Each serving of Wimpy requires 0.26 pound of beef, 0.26 cup of onions, and 6 ounces of Kilgore's special sauce. Each serving of Dial 911 requires 0.26 pound of beef, 0.41 cup of onions, 3 ounces of Kilgore's special sauce, and 6
ounces of hot sauce. Today, Kilgore has 21 pounds of beef, 16 cups of onions, 89 ounces of Kilgore's special sauce, and 61 ounces of hot sauce on hand.
a. Develop a linear programming model that will tell Kilgore how many servings of Wimpy and Dial 911 to make in order to maximize his profit today.…
Chapter 2 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
Ch. 2 - Prob. 1QPCh. 2 - Prob. 2QPCh. 2 - Prob. 3QPCh. 2 - Prob. 4QPCh. 2 - Prob. 5QPCh. 2 - Prob. 6QPCh. 2 - Prob. 7QPCh. 2 - Prob. 8QPCh. 2 - Prob. 9QPCh. 2 - Prob. 10QP
Ch. 2 - Prob. 11QPCh. 2 - Prob. 12QPCh. 2 - Prob. 13QPCh. 2 - Prob. 14QPCh. 2 - Prob. 15QPCh. 2 - Prob. 16QPCh. 2 - Prob. 17QPCh. 2 - Prob. 18QPCh. 2 - American Auto is evaluating their marketing plan...Ch. 2 - Prob. 20QPCh. 2 - Prob. 21QPCh. 2 - Prob. 22QPCh. 2 - Prob. 23QPCh. 2 - Prob. 24QPCh. 2 - Prob. 25QPCh. 2 - Prob. 26QPCh. 2 - Prob. 1.1CCh. 2 - Prob. 1.2CCh. 2 - Prob. 1.3CCh. 2 - Prob. 1.4CCh. 2 - Prob. 1.5CCh. 2 - Prob. 1.6CCh. 2 - Prob. 1.7CCh. 2 - Prob. 1.8CCh. 2 - Prob. 1.9CCh. 2 - Prob. 1.10C
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- 1. If constraint has a shadow price of $6, Right-Hand-Side (RHS) is 12, allowable increase is 2, allowable decrease is 4. How would objective function change if the RHS of this constrains changes from 12 to 9? Answer___________arrow_forwardIn problems involving maximization and minimization, what is the objective function? States intended outcome in equation form Incorporates constraint of maximum budget Lists set of potential restrictions on the solution Cites constraints to ensure objectivityarrow_forwardProblem 16-15 (Algorithmic) Strassel Investors buys real estate, develops it, and resells it for a profit. A new property is available, and Bud Strassel, the president and owner of Strassel Investors, believes if he purchases and develops this property it can then be sold for $160,000. The current property owner has asked for bids and stated that the property will be sold for the highest bid in excess of $100,000. Two competitors will be submitting bids for the property. Strassel does not know what the competitors will bid, but he assumes for planning purposes that the amount bid by each competitor will be uniformly distributed between $100,000 and $150,000. Develop a worksheet that can be used to simulate the bids made by the two competitors. Strassel is considering a bid of $130,000 for the property. Using a simulation of 1000 trials, what is the estimate of the probability Strassel will be able to obtain the property using a bid of $130,000? Round your answer to 1 decimal place.…arrow_forward
- (c) Suppose that management wants to provide additional security coverage for room 7. Specifically, management wants room 7 to be covered by two cameras. Which constraint would have to change? O Room 1 O Room 2 O Room 3 O Room 4 O Room 5 O Room 6 O Room 7 O Room 8 What should the new constraint be? (d) With the policy restriction specified in part (c), determine how many two-way camera systems will need to be purchased and where they will be located. The gallery should install cameras with (X₁, X2, X3, X4, X5, X6, X7, X8, X9, X10, X11 X12, X13) =arrow_forwardDiscuss the five (5) steps of the Theory of Constraints and apply each to asimulation/assumption of a constraint impacting Jaguar.arrow_forwardvariables $E$11 47000 0 35 7.0000001 8.0000001 BO Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$16 LHS 55000 41 55000 10500 47000 $B$17 LHS 72000 35 72000 10500 47000 $B$18 LHS 80000 -8 80000 47000 10500 10500 $B$19 LHS 47000 0 57500 1E+30 The answers to the questions are found in this sensitivity report. Questions: Write your responses in the space provided 1. What is the range of optimality for the BN and BO variables? write your answers in this format: Lower limit <= Coefficient of BN <= Upper limit. Example 22 <= C of BN <= 40 2. What is the range of feasibility for the constraints located on B17 and B18? 3. If the right-hand side of the constraint located on B17 is decreased by 200, what is the effect on the value of the objective function?arrow_forward
- Next question Use the simplex method to solve the linear programming prob z= 8x1 - 7x2 + 4x3 2x1 Maximize X2 + 8x3 s 40 4x1 - 5x2 + 6x3576 2x1 - 2x2 + 6x3< 32 X120, X2 20, хз 20. subject to Select the correct choice below and, if necessary, fill in the answer boxes to complete your choice. A. The maximum is , X2 =, X3 = S2 = and s3 when X1 S1 = B. There is no maximum.arrow_forwardWhat is a Constraint? * What is Alternative optimal solutions? * Your answer What is Infeasibility? *arrow_forward3 II | Here are the changes to the original problem and the revised conditions for this decision-making problem: With a favorable market, John Thompson thinks a large facility would result in a net profit of $195,000 to his firm. If the market is unfavorable, the construction of a large facility would result in $185,000 net loss. A small plant would result in a net profit of $110,000 in a favorable market, but a net loss of $25,000 would occur if the market was unfavorable. Doing nothing would result in $0 profit in either market conditions. a) Create a decision table, b) What is your recommendation if you would apply the Maximax criterion (Optimistic)? Follow the guidance from your textbook and create a table. c) What is your recommendation if you would apply the Maximin Criterion (Pessimistic)? Follow the guidance from your textbook and create a table. d) What is your recommendation if you would apply the Criterion of Realism (Hurwicz Criterion) with a coefficient of realism a =…arrow_forward
- Problem 7-41 Southern Oil Company produces two grades of gasoline: regular and premium. The profit contributions are $0.30 per gallon for regular gasoline and $0.50 per gallon for premium gasoline. Each gallon of regular gasoline contains 0.3 gallons of grade A crude oil and each gallon of premium gasoline contains 0.6 gallons of grade A crude oil. For the next production period, Southern has 18,000 gallons of grade A crude oil available. The refinery used to produce the gasolines has a production capacity of 50,000 gallons for the next production period. Southern Oil's distributors have indicated that demand for the premium gasoline for the next production period will be at most 20,000 gallons. a. Formulate linear programming model that can be used to determine the number of gallons of regular gasoline and the number of gallons of premium gasoline that should be produced in order to maximize tota profit contribution. If required, round your answers to two decimal places. L Let R = P =…arrow_forward[6] Please carefully read the following scenario:(Image attached)The total number of decision variables in this problem is:A. 5B. 3C. 4D. 2 [7] The total number of constraints in this problem, including non-negativity constraints is: A. 9 B. 5 C. 3D. 7arrow_forwardb) The Scott Tractor Company ships tractor parts from Omaha to St. Louis by railroad. However, a contract limits the number of railroad cars the company can secure on each branch/arc during a week. Given these limiting conditions, the company wants to know the maximum number of railroad cars containing tractor parts that can be shipped from Omaha to St. Louis during a week. Phoenix Des Moines 3 5 6. 6. 1. Dallas 2 Omaha St. Louis 7. 3 Denver 6. ActivateW O 31°Carrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Understanding BusinessManagementISBN:9781259929434Author:William NickelsPublisher:McGraw-Hill Education
Management (14th Edition)ManagementISBN:9780134527604Author:Stephen P. Robbins, Mary A. CoulterPublisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...ManagementISBN:9781305947412Author:Cliff RagsdalePublisher:Cengage Learning
Management Information Systems: Managing The Digi...ManagementISBN:9780135191798Author:Kenneth C. Laudon, Jane P. LaudonPublisher:PEARSON
Business Essentials (12th Edition) (What's New in...ManagementISBN:9780134728391Author:Ronald J. Ebert, Ricky W. GriffinPublisher:PEARSON
Fundamentals of Management (10th Edition)ManagementISBN:9780134237473Author:Stephen P. Robbins, Mary A. Coulter, David A. De CenzoPublisher:PEARSON
Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON