Question: Solve the following LP problem, which involves three decision variables, by using Excel: Minimize cost = 10.50X + 4.60Y + 12.20Z subject to the constraints

Solve the following LP problem, which involves three decision variables, by using Excel:

Minimize cost = 10.50X + 4.60Y + 12.20Z
subject to the constraints

5X + 4Y ≥ 200
4X − 6Y + 8Z ≥ 360
X ≤ 0.40(X + Y + Z)
Z ≥ Y
X, Y, Z ≥ 0

Step by Step Solution

★★★★★

3.37 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

answer The optimal so... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Managerial Decision Modeling Business Analytics With Spreadsheet Questions!

Q:

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

Q:

Solve the following LP problem graphically: Minimize cost = 24X + 15Y Subject to: 7X + 11Y 77 16X + 4Y 80 X,Y 0

Q:

Solve the following LP problem graphically. Then set up a simplex tableau and solve the problem using the simplex method. Indicate the corner points generated at each iteration by the simplex method...

Q:

2-14: Solve the following LP problem 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 2-18: Solve the following LP problem by using...

Q:

I would like an excel doc with columns and rows showing. One doc with just answers , one doc with the formulas expande d. This is the only way I can understand the answers and how to do the problem....

Q:

MATH 106 Week 8 LEO Discussion Topic Exercises Version: 2015-1 Linear Programming 1. Graphically solve the following: Maximize , subject to: f 6x y 2. x y 8 3x y 0 y 0 Solve the given linear...

Q:

1. (3 points) What most motivates a business to be concerned with cent of the resources? Resources are limited and valuable B. Efficient resource use increases business costs C. Efficient resources...

Q:

How do I formulate question 3 as a transportation problem? ADM2302 Section M, N and P Solution Assignment # 2 SOLUTION Assignment # 2 LP Formulations and Applications ADM2302 students are reminded...

Q:

Here is the new homework question. Please review the General Homework instructions due to the instructor being so strict. Were there any podcasts or Homework document notes that you needed me to...

Q:

his in thee happen Grope 211 (The Reddy Milks Company) Naka Midas produive both posterior and exterior paints from two raw materials, Aft the Filming table provides the basic date of the problem The...

Q:

Prepare a fictional data set in SPSS with following variables and 72 objects Gender (Female - Male) Height (in centimeters) (Between 150 cm and 185 cm) Weight (in kilograms) (Between 42 kg and 175...

Q:

Refer to information from QS 7-8A. Luna Company assigns variable overhead at the rate of $1.75 per unit of production. Fixed overhead equals $5,000,000 per month. Prepare a factory overhead budget...

Q:

Current Attempt in Progress Flounder Company, organized in 2 0 2 0 , has the following transactions related to intangible assets. \ table [ [ 1 2 ? 2 2 , Purchased patent ( 5 - year life ) , $ 1 , 0...

Q:

a. What are the fixed inputs and variable inputs in the production of cups of frozen yogurt?

Q:

33 White & Becker Tools (W&B) requires 2,000 electric motors next month for its product line of weed trimmers. Each motor is composed of three components: a coil, a shaft, and housing. W&B has the...

Q:

29 Rollins Publishing needs to decide what textbooks from the table at the top of the next column to publish. Table for Problem 29 DEMAND FIXED COST VARIABLE COST SELLING PRICE Book 1 9,000 $12,000...

Q:

28 The Columbia Furniture Mart manufactures desks, tables, and chairs. In order to manufacture these products, Columbia must rent the appropriate equipment at a weekly cost of $2,000 for desks,...

Q:

D Question 16 1 pts Winston Baker wants to invest $24,500 in a spa that his sister is starting. He will triple his investment in five years. What is the rate of return that Winston is being promised?...

Q:

The Kansas City Chiefs are deciding whether to offer a contract extension to Tyreek Hill. Suppose the contract would give him a signing bonus of $20 million up front (i.e. today) and $25 million...

Q:

What specific ethical concerns/risks might arise as a result of selecting participants from one's personal networks? Outline strategies that can minimize such risks in qualitative studies.