QuestionSolve the following linear programming problem by usingMS Solver.• Solution in MS Excel file.• Carry out the sensitivity analysis for CI and C3.Max. Z = 6X, + 2.5 X, + 4X3Subject to:2X, + 3X2 +5X3<=50004X, + 2X, + 3X;<=70006X, + 4X, +2.5X3<=5000>= 0X2>=0X3>= 0

Given LP: Max Z = 6X1+2.5X2+4X3Subject to -2X1+3X2+5X3≤ 50004X1+2X2+3X3≤ 70006X1+4X2+2.5X3≤…

Answered: Question Solve the following linear…

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

QUESTION 2 Molitup Limited (ML) manufactures three products: Product MM, Product LL and Product TT. The contribution per unit of the respective products is as follows: Product MM Product LL Product TT Contribution per unit £600 £500 £800 Three processes are required for the manufacture of these products: Process Alpha, Process Beta and Process Gamma. The processing time (in hours) required for the manufacture of a unit of each product is as follows: Product MM Product LL Product TT Process Alpha Process Beta Process Gamma 20 30 40 80 60 20 50 90 60 The monthly availability of Process Alpha, Process Beta and Process Gamma are limited to 40,000 hours, 80,000 hours and 50,000 hours respectively. The objective of the company is to maximise contribution.
Question 5 The management of CDC Construction Pioneers have decided to build 900 new apartments in the Kasoa area due to the influx of immigrant workers into the country. Two Architectural Companies have provided building plans and technical schematics for the project. Management are happy with the proposals of both Standard apartment and Deluxe apartment. After investigating the steps involved in construction, management determined that each apartment complex built will require some resources. Management analysed each of the bids and concluded that if the plans of Standard apartment are built, it requires 0.7 days in foundation works, 0.5 days in the masonry, 1 day in finishing, and 0.1 days in painting works. Deluxe apartment will require 1 day in foundation works, 0.83 days in the masonry, 0.67 days in finishing, and 0.25 days in the painting works. Management estimate that, 630 days for foundation works, 600 days for masonry, 708 days for finishing and 135 days for painting works…
QUESTION 8 One of the construction companies in one of the countries has employed engineer A is an architecture engineer. He was assigned to work on one of the projects owned by the government which is a building of five floors. He came to know that the specifications of the building foundation are not according to the standards. He informed his supervisor engineer B about the problem but he asked him to say nothing about it otherwise he will be fired from the company. The construction of the building has been resumed and knows the project has been completed and received by the government. a. What is the moral dilemma here? b. What he should do? c. What are the moral values here?
Question 3 To keep up with the market demands, Dolphin Technologies allows overtime for each of the two departments. The cost per hour of overtime for the Chip Manufacturing Department is $20, and $12 for Case Fabricating Department. Formulate a linear programming model can be used to determine the optimal production quantities if overtime is made available.
Question 2: Consider the following model: Minimize Z = 3x, + 2x2, subject to 2r, + x2 2 10 -3x, + 2x2 s 6 2 6 X1 + X2 and X, 2 0, X2 2 0. Part a) Solve it using graphical technique. Part b) Write its dual model and explain how we can find dual optimal solutions from primal solutions.
Question 5: Suppose a brewery uses a Cobb-Douglas production function for his production. He studies the production process and finds the following. An additional machine-hour of fermentation capacity would increase output by 500 bottles per day (i.e. MPK = 500). An additional man-hour of labor would increase output by 1000 bottles per day (i.e. MPL = 1000). The price of a man-hour of labor is $50 per hour. The price of a machine-hour of fermentation capacity is $5 per hour. 3. Suppose that the price of a machine-hour of fermentation capacity rises to $25 per hour. How does this change the answer from part 1?
Question 9
QUESTION THREEGiven the LP below:a) Solve the problem using big M-methodMinimize Z = 3X1 +4X2s.t 4X1 + X2 ≥ 30−X1 − 4X2 ≤ −184X1 + 3X2 ≥ 28X1, X2, ≥ 0
Question 35 In a Goal Program formulation, what statement below best represents a situation in which the Weight factor for a particular % Deviation is given a particularly high value? Cannot be determined (subject to problem data) It begins to approach a Hard Constraint It will distort the Decision Variable solution At some value the Solver solution will be infeasible
Linear programming question
Question 6 Shawna is the marketing manager for Yummy Marinades and Dips. The company wants to should introduce a new cooking sauce product line with the brand Con-Cook-Tions. Shawna is deciding if she would initially do a test market in selected cities on the East Coast or do a big national product launch. The cost of doing the test market is $150,000. If Shawna does the test market, she has to wait for the results of the test market before she decides to do a nationwide launch of Con-Cook-Tions. The probability of a positive response from the test market result is estimated to be 0.6. Alternatively, Shawna could also decide to bypass the test market and go ahead with the national launch. If Con-Cook-Tions is launched nationally and becomes a huge success, the company estimates that it will realize an annual profit of $1.6 million. If the launch fails and the market reacts negatively to the sauces, Yummy will incur a loss of $700,000. Shawna company believes the probability of success…
Question THREE: Suppose you are given a set of data for output at a company which manufactures detergents over a period of time. You have determined a relation between total operating cost and the quantity produced and is given by the linear regression model as follows: TC=20,000+2,500Q, where TC=Total Operating Cost (in $) per annum and Q = Quantity produced per annum Required: i. Determine the total operating cost in the event that quantity of production is at 4,500, 12,500 and 7,000units. ii. What do you think would be your reservations in relaying on the linear regression model for budgetary planning purposes?

SEE MORE QUESTIONS

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

Question Solve the following linear programming problem by using MS Solver. • Solution in MS Excel file. • Carry out the sensitivity analysis for Cl and C3. Max. Z= 6X, + 2.5 X, + 4X3 Subject to: 2X, + 3X2 + 5X, <=5000 4X, + 2X, + 3X, <=7000 6X, + 4X, + 2.5X, <=5000 X, >= 0 X2 >= 0 X3 >= 0