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

This problem has been solved!

Do you need an answer to a question different from the above? Ask your question!

## 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**

## Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science

ISBN: 978-0324656633

5th edition

Authors: Cliff T. Ragsdale

**View Solution**

Create a free account to access the answer

**Cannot find your solution?**

Post a FREE question now and get an answer within minutes.
* Average response time.