Let x₁ be the number of machine part I X2 be the number of machine part II Objective Function: Max P = 50x₁ + 100x₂ subject to: 10x1 + 5x2 < 2500 4x110x22000 X1+1.5×, < 450 X1, X₂0 Solve the given LP Problem using simplex method and perform the sensitivity analysis. Find the optimality range.

Let x₁ be the number of machine part I X2 be the number of machine part II Objective Function: Max P = 50x₁ + 100x₂ subject to: 10x1 + 5x2 < 2500 4x110x22000 X1+1.5×, < 450 X1, X₂0 Solve the given LP Problem using simplex method and perform the sensitivity analysis. Find the optimality range.

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

Provide a circumstance under which the expected monetary value is appropriate for decision making.
Calculating outcomes as equally likely would BEST describe: O a. Maximax criterion O b. Laplace criterion O c. Regret criterion Od. Maximin criterion Determining the average payoff for each alternative and choosing the one with the BEST payoff is the approach called: ea, maximax O b. minimax regret O c. laplace Od maximin M
How did you find the solutions in the table for the range of optimality for the profit coefficient?
Abc limited has a production capability of 2.4 million units but currently produces less than 1.3 million units. To reach 75% utilization level at which it is beak even point capacity needs to be reduced by 30%. The company plans to reduce capacity to 1.65 million units which is 82% utilization. The managers intends to close 5 factories which employs 16000 employees therefore cutting capacity by 30% which has a utilization of 80%. Come up with three quandratic equations from the above information.
Use the following for the next 2 questions: A company forecasts that it will ship 120,000 boxes of product in June. The product has a monthly turnover of 3. The company plans to use its facility to ship 80,000 boxes and the balance of the 40,000 boxes will ship from a rented facility. Space may be rented for a charge of $7 per box per month with an in-and-out handling charge of $0.45 per box shipped. 1. What is the rented (fixed) storage cost for June? - $280,000 - $180,000 - $42,500 - $250,000 - $93,333 - $153,333 - $173,333 2. What is the rented variable cost for June? - $33,333 - $43,333 - $6,000 - $38,000 - $18,000 - $28,000 - $23,333
Draw a decision tree and determine the best solution
A decision maker faces with the following four alternatives and four states of nature in the profit payoff table below: B. Cal D. Calculate the expected value of perfect to the nearest integer: 1, A2, A3, or A4. 3 States of nature S3 8 0.1
The management of Compton Electronics has done a total cost analysis for three international suppliers ofkeyboards (see Example 14.1). Compton also considers on-time delivery, consistent quality, and environ-mental stewardship in its selection process. Each criterion is given a weight (total of 100 points), and eachsupplier is given a score 11 = poor, 10 = excellent2 on each criterion. The data are shown in the followingtable
A company sells its products to wholesalers in batches of 1,000 units only. The daily demand for its product and the respective probabilities are given below. Demand (Units) Probability 0 0.1 1000 0.3 2000 0.4 3000 0.1 4000 0.1 a. Determine the expected daily demand. b. Assume that the company sells its product at $3.90 per unit. What is the expected daily revenue?
Show solution: The population of Ectenia is 100 people: 40 work full-time, 20 work half-time but would prefer to work full-time, 10 are looking for a job, 10 would like to work but are so discouraged that they have given up looking, 10 are not interested in working because they are full-time students, and 10 are retired. What is the number of unemployed?
A television network earns an average of $1.6 million each season from a hit program and loses an averageof $400,000 each season on a program that turns out to be a flop, and of all programs picked up by thisnetwork in recent years, 25% turn out to be hits and 75% turn out to be flops. a) Construct a decision tree to help the television network identify the strategy that maximizes itsexpected profit in responding to a newly proposed television program. Make sure to label all decisionand chance nodes and include appropriate costs, payoffs and probabilities. b) What should the network do? What is their expected profit? c) The network can conduct market research to determine whether a program will be a hit or a flop. Ifthe market research report is perfectly reliable, what is the most the network should be willing to payfor it? Can you please include pictures of excel sheets. Having trouble determining what the excel sheet should look like
Edwards Machine Tools needs to purchase a new machine. The basic model is slower but costs less, while the advanced model is faster but costs more. Profitability will depend on future demand. The following table presents an estimate of profits over the next three years. Decision Low Medium High Basic Model $75,000 $95,000 $120,000 Advanced Model $60,000 $150,000 $260,000 Given the uncertainty associated with the demand volume and no other information to work with, how would you make a decision? Use the Excel template Decision Analysis and explain your reasoning.