Given the following LP model and answer questions below:Max. 23X1+ 9X2+ 18X3+14X4S.T:5X1 + 8X2 +11X3 + 6X4 = 3017X1 + 9X2 + 25X3>= 4010X1 ++ 12X4 <= 40114X2+ 15X4 <= 80X1, X2, X3, X4 >= Zero1. The slack/surplus variable for the constraints are:2. If the profit/unit of X4 decrease to 8 JD, the value of theoptimal solution will be:3. If constraint (3) is modified to (>=), determine what willhappen to the optimal solution:4. If constraint (2) is modified to (<=), the binding constraintsis/are:

Note: - As we can answer up to three subparts we will answer the first three subparts here. If you…

Answered: Given the following LP model and answer…

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

Similar questions

Answer the following questions based on the following Sensitivity Report. Microsoft Excel Sensitivity Report Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$19 Acres to Plant Watermelons 60 256 28.5 66.33333333 $C$19 Acres to Plant Cantaloupes 40 284.5 99.5 28.5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$11 Water Used per hour) 6,000 1 6000 1500 1000 $F$19 Acres Planted per hour) 100 199 100 20 20 1. How much can the price of watermelons drop before it isn't optimal to plant any watermelons? (round to 2 decimal places) 2. How much does the price of cantaloupes have to increase before it is optimal to only grow cantaloupes? (round to 2 decimal places)
Use the information below to answer question 2x + 3y + 3z = 2 4x – 3y – 6z = 2 10x – 6y + 3z = 0 1. Given values – 144, -192, and 96 for Dx, Dy, and Dz respectively and D = 144. Then the solution to the system for x, y and z are: A. -1, -1.33, and 0.67 B. -0.47, -0.63 and 0,30 C. 0.5, 0.67 and-0.33 D. 0.73, 0.98 and -0.49
Choose the correct letter of answer Sister Company has given the following production model : Max 18x; s.t. 9x ≤ 45; x ≥ 0. Using the trial and error method, identify the optimal solution value of x. a. 7b. 9c. 12d. 5
1. Given the LP model below. Do the following: a. Formulate the new LP model. b. Set up the initial table then identify the optimum column, pivotal row, entering variable out, going variable, Zj row entries, and Cj n-Zj row entries Maximize eamings = $0.80xX₁ + $0.40X₂ + $1.20X3 - $0.10X4 subject to X₁ + 2X₂ + X3 + 5X₁150 X₂ 4X₂ + 8X₂ = 70 6X₁ + 7X₂ + 2X3 - X₂ 120 X₁, X₂, X₁, X₁Z 0
Mop and Broom Manufacturing has tracked the number of units sold of their most popular mop over the past 24 months. This is shown. Month 1 2 3 4 5 6 7 8 Sales Month 238 249 254 267 277 282 402 296 9 10 11 12 13 14 15 16 Sales 300 327 346 349 353 364 373 363 Month + 17 18 19 20 21 22 23 24 Sales 361 381 375 383 384 401 409 403 a. Develop a linear trend line for the data. (Round your answers to 2 decimal places, e.g.,25.28.) Sales = (month) b. Compute a correlation coefficient for the data and evaluate the strength of the linear relationship. (Round your answer to 2 decimal places, the tolerance is +/-0.01.) Correlation coefficient is . It indicates linear relationship. (Use not rounded amounts to answer this question.) c. Using the linear trend line equation, develop a forecast for the next period,month 25. (Round your answer to 2 decimal places, the tolerance is +/-0.01. Do not round intermediate results used to achieve this answer.) Forecast for month 25 =
A company with a capacity of 3,000 units a month has fixed costs of P1,500 a month and labor costs of P10 a unit. Material costs are P5 per unit. The company has been producing at 80 percent of capacity and selling its product for P20. 1What would its net income be at 100 percent at capacity 1.2What would its net income be at 120 percent of capacity if it is assumed that 20 percent more products could be produced on overtime at an extra P3 labor cost per unit for all production above 100 percent?
A careful analysis of the cost of operating an automobile was conducted by accounting manager Dia Bandaly. The following model was developed: y = 3,600+ 0.16x, where y is the annual cost and x is the miles driven. a) If the car is driven 15,000 miles this year, the forecasted cost of operating this automobile = $ b) If the car is driven 26,000 miles this year, the forecasted cost of operating this automobile = $ (enter your response as a whole number). (enter your response as a whole number).
Consider the following linear programming problem Max. Z = 9X₁ + 16X₂ Subject to: C1: C2: C3: C4: C5: Variable Cells X₁ 2X₁ X₁ X₁ Microsoft Excel 16.0 Sensitivity Report Worksheet: [Question Sensitivity analysis.xlsx]Sheet2 Report Created: 10/24/2021 10:45:53 AM $B$5 Values x1 $C$5 Values x2 $D$10 C5Z $D$6 C1Z $D$7 C2Z $D$8 C3Z $D$9 CAZ X₂ This problem was solved using MS Solver of MS Excel. Following is the output of the solution. 3 6 3X₂ 0 0 X₂ Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease 6 3 24 9 3 Constraints Cell Name Value Price R.H. Side 05500 -5 5 15 3 0 0 0 3 24 10 0 Final Shadow Constraint Allowable Allowable Increase Decrease 1E+30 5 1E+30 24 10 6 3 3 1E+30 1E+30 7.5 3 18 1 3 1E+30 Write your report on the sensitivity analysis of constraints C2 and C3
Hi! How do you solve this qn using Excel Solver? The SurveyMonkey firm has been contracted to conduct a survey on the party preference in thecoming election. The firm must assign interviewers to conduct the survey. The interviews are to beconducted by telephone and in person. One person can conduct 80 telephone interviews or 40personal interviews in a single day. The following criteria have been established by the firm in orderto ensure a representative survey:• At least 3,000 interviews must be conducted.• At least 1,000 interviews must be by telephone.• At least 800 interviews must be personal. Due to urgency of the project, the interviews must be conducted within one day. An interviewerconducts only one type of interview on the day. The cost is $50 per day for a telephone interviewerand $70 per day for a personal interviewer. The firm wants to know the number of interviewers tohire in order to minimize the total cost of the survey. a) Formulate a linear programing model for this…

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

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

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS