Solve the following LP problem using Excel: Maximize profit=3X+2Y subject to the constraints 6X+12Y60 7X+Y20 4X-Y1 X,Y0

Fantastic news! We've Found the answer you've been seeking!

Question:

Solve the following LP problem using Excel: Maximize profit=3X+2Y subject to the constraints 6X+12Y≤60 7X+Y≤20 4X-Y≥1 X,Y≥0

You need step by step using Excel using the format below showing the formulas


	X	Y
Variables
objective coefficient
restrictions:
Constraint 1
Constraint 2
Constraint 3
			LHS	Sign	right side

Related Book For answer-question

Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science

ISBN: 978-0324656633

5th edition

Authors: Cliff T. Ragsdale

See More Books

Posted Date: May 27, 2023 05:17 AM

See More Questions

Solve the following LP problem by using the graphical procedure and by using Excel: Maximize profit = 4X + 5y Subject to the constraints 5X + 2y < 40 3X + 6y < 30 X <7 2X y > 3 x,y >0
Solve the following LP problem using level curves. MAX: 4X1 + 5X2 Subject to: 2X1 + 3X2 120 4X1 + 3X2 140 X1 + X2 80 X1, X2 0
Solve the following LP problem by using the graphical procedure and by using Excel: Minimize cost = 4X + 7 Y subject to the constraints 2X + 3y > 60 4X + 2y > 80 X <24 x,y >0
A production line will be used to manufacture an item. The line will be operated with using the same personnel during single shift operations. During the initial line certification, the first item...
An arched tunnel is driven in moderately blocky and seamy, wet ground at a depth of 1,970 ft. The tunnel is 14 ft wide by 11 ft high; the back arch is semi-circular. (a) Specify a suitable steel set...
In Exercises use integration to find a general solution of the differential equation. dy dx sin 2x
After determining that computer controls are valid, Hastings is reviewing the sales system of Rosco Corporation to determine how computer assisted audit techniques may be used to assist in performing...
Anton Blair is the manager of a medium- size company. A few years ago, Blair persuaded the owner to base a part of his compensation on the net income the company earns each year. Each December he...
John is currently a class 2 real estate agent. He has become concerned that the agency may not be up-to-date with the Code of Conduct for agents and conflicts of interest. He suspects that the agency...
Fourth-Sixth-Twelfth Bank currently pays an annuall dividend of $1.40 per share. After extensive analysis, you forecast that the Bank's stock will continue to pay the $1.40 dividend for four years....
Ayala Corporation incurred the following costs during the current year in relation to property, plant and equipment: Cash paid for purchase of land Mortgage assumed on the land purchased, including...
Do you think the relative uncertainty of the velocity will be larger than the relative uncertainties of the time and distance measurements, in between the relative uncertainties of the time and...
Two identical charges, each 7.6x10-5 C are separated by 0.11 m. What is the force of repulsion? Find the resistance of a small motor that draws 0.750 A on 115V. How much power is required to operate...
(1) Which of the following salts is the strongest base? (a) NaCIO4 (b) KCIO3 (d) KCIO (2) Which of the following salts would raise the pH of a solution when added? (a) KBr (b) KNO (c) NH4Cl (4) The...
Spring 1 is stretched and stores 2 J of elastic potential energy. An identical spring, spring 2, is stretched and stores 18 J of elastic potential energy. What is the ratio of the displacement of...
A senior manager of your company comes to you with a new gamified assessment that a large assessment firm has presented during a tech conference. The manager downloaded and played the game on her...
Use the graph of the polynomial function f(x) (a) to solve f(x) = 0, and (b) find the factorization of f(x). 3 f(x) = 0.5x +0.5x + 4.5x 4.5 (a) x = (Use a comma to separate answers as needed. Type...
Integration is a vital concept when applied in one?s life. Integrating your life means making ideal choices. Perfect choices on the other go in line with quality decisions. Quality decisions lead to...
The XYZ Company produces two products. The total profit achieved from these products is described by the following equation: Every 1,000 units of X1 requires one hour of time in the shipping...
Use Holts method to create a model that minimizes the MSE for the data set. Use Solver to estimate the optimal values of and . a. What are the optimal values of and ? b. Prepare a line graph...
A major city in the northeast wants to establish a central transportation station from which visitors can ride buses to four historic landmarks. The city is arranged in a grid, or block, structure...
Briefly describe what quality control is all about, and explain the three statistical types of control.
Briefly explain the budgetary variances and the way it is used.
Briefly describe the two most common types of budget.

Solve the following LP problem using Excel: Maximize profit=3X+2Y subject to the constraints 6X+12Y60 7X+Y20 4X-Y1 X,Y0

Question:

Expert Answer:

ANSWER Explanation Solution I We hav... View the full answer

Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science

Students also viewed these general management questions