Please do not give solution in image formate thanku. You are given the following linear programming model and Excel spreadsheet to solve thisproblem:MAX:Subject to:Constraint 1: 6 X₁ + 4 X2 <= 1500Constraint 2: 4 X₁ + 8 X2 <= 2700Constraint 3: X₂ <= 800X1, X2 >= 012343456789625 X1 + 35 X2ANumber tomake:Unit profit:E5<= 0O B4:C4<= B5:C5D8:D10<=E8:E10BE8:E10 <= D8:D10X1025C64X2035RHS41500Constraints:Constraint 1.Constraint 2Constraint 382700101800Which of the following statements represent constraints 1, 2, and 3 in the Solver Parameters window?DLHSEObjective

Here, the usage must be less then or equal to for available value.Option A is not correct for given…

Answered: You are given the following linear…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter6: Optimization Models With Integer Variables

Section: Chapter Questions

Problem 91P

See similar textbooks

Similar questions

Solve the following Linear Programming model using the graphical method (USING EXCEL){Write the steps of construction} Q1)MaximizeH = x + 3y Objective functionsubject tox + y ≤ 502x + y ≤ 60 x ≥ 0, y ≥ 0
What function does linear programming play in OR?
Create spreadsheets and use Solver to determine the correct volumes to be produced to minimize cost for the following problem. Your company has two trucks that it wishes to use on a specific contract. One is a new truck the company is making payments on, and one is an old truck that is fully paid for. The new truck’s costs per mile are as follows: 54₵ (fuel/additives), 24₵ (truck payments), 36₵ (driver), 12₵ (repairs), and 1₵ (misc.). The old truck’s costs are 60₵ (fuel/additives), 0₵ (truck payments), 32₵ (rookie driver), 24₵ (repairs), and 1₵ (misc.). The company knows that truck breakdowns lose customers, so it has capped estimated repair costs at $14,000. The total distance involved is 90,000 miles (to be divided between the two trucks).
You are to set up a linear program
Facility Location. A paper products manufacturer has enough capital to build and manage some additional manufacturing plants in the United States in order to meet increased demand in three cities: New York City, NY; Los Angeles, CA; and Topeka, KS. The company is considering building in Denver, CO; Seattle, WA; and St. Louis, MO. Max Operating Capacity 400 tons/day 700 tons/day Denver Seattle $10/ton $17/tor $5/ton $11/ton.... $18/ton.... $28/ton Los Angeles Topeka New York City Figure 1: Graphical representation of the given data = • The cost fi of building plants in these cities is fi $10,000,000 in Seattle. Unmet Demand 300 tons/day 100 tons/day 500 tons/day • Due to geographic constraints, plants in Denver and Seattle would have a maximum operating capacity kį of 400 tons/day and 700 tons/day respectively. $5,000,000 in Denver and f2 = • The cost cij per ton of transporting paper from city i to city j is outlined in Figure 1. • The unmet demand d, for Los Angeles, Topeka, and New…
Having trouble setting up the problem using excel solver and inputting the constraints
What is linear programming?
Build and solve the linear programming model using Excel/Solver.
Use simplex method for linear programming. Show solution for each iteration table. Problem: A small firm that assembles computers is about to start production of two new types of personal computers. Each type will require assembly time, inspection time, and storage space. The amount of each of these resources that can be devoted to the production of the computers is limited. The manager of the firm would like to determine the quantity of each computer to produce in order to maximize the profit generated by sales of these computers. In order to develop a suitable model of the problem, the manager has met with design and manufacturing personnel. As a result of those meetings, the manager has obtained the following information: Type 1 Type 2 Profit per unit $60 $50 Assembly time per unit 4 hours 10 hours Inspection time per…
Please answer it immediately sir Linear Programming The Booboo sawmill in Batangas produces pine and oak boards for manufacturing firms. Each month the sawmill must deliver atleast 5 tons of wood to the manufacturer . It takes the sawmill 3 days to produce a ton of pine and a 2 days to produce a ton of oak and the sawmill can allocate 18 days out of a month for this contract. The sawmill can get enough pine to make atleast 4 tons of wood and enough oak to make atmost 7 tons of wood. Determine the number of tons of pine and oak in order to minimize cost, given that pine has a cost of $3 and oak $6 to produce
What are the benefits of linear programming models ?
If a firm wishes to choose at least 2 of 4 possible activities (A, B, C and D), the constraint XÃ + XB + XC + XD ≥ 2 will enforce this relationship in a linear program. True or False True False

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS