FREE Trial

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

XY
Variables
objective coefficient
restrictions:
Constraint 1
Constraint 2
Constraint 3
LHSSignright side

Expert Answer:

Answer rating: 100% (QA)

ANSWER Explanation Solution I We hav View the full answer


answer-question
Related Book For  answer-question
Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science

Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science

ISBN: 978-0324656633

5th edition

Authors: Cliff T. Ragsdale

See More Books
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.
Posted Date: May 27, 2023 05:17:14
See More Questions

Students also viewed these general management questions

Q:
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
A:
tr mso height source auto col mso width source auto br mso data placement same cell style0 mso number format General text align general vertical align bottom white space nowrap mso rotate 0 mso backgr......
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
A:
X 100 75 50 25 0 2......
Q:
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:
tr mso height source auto col mso width source auto br mso data placement same cell style0 mso number format General text align general vertical align bottom white space nowrap mso rotate 0 mso backgr......
Q:
Prove that opposite sides of a quadrilateral circumscribing a circle subtend supplementary angles at the centre of the circle.
A:
The detailed......
Q:
A student organization uses the proceeds from a particular soft-drink dispensing machine to finance its activities. The price per can had been $0.75 for a long time, and the average daily revenue...
A:
1 mean daily revenue since the change 2 H 0 75 3 H a 75 4 a 0 05 6 The sample w......
Q:
The bank portion of the bank reconciliation for Helene Company at November 30, 2012, was as follows. The adjusted cash balance per bank agreed with the cash balance per books at November 30. The...
A:
a HELENE COMPANY Bank Reconciliation December 31 2012 Cash balance per bank state......
Q:
Elizabeth Tailors Inc. has assets of $8,540,000 and turns over its assets 1.8 times per year. Return on assets is 16.5 percent. What is the firms profit margin (returns on sales)?
A:
Elizabeth Tailors Inc Sales Assets x T......
Q:
Camacho Chemical Company uses an average cost processing system. All materials are added at the start of the production process. Labor and overhead are added evenly at the same rate throughout the...
A:
Units to Account for Beginning work in process 1 000 Started 5 000 Quanti......
Q:
According australian taxation law, determine whether the sceneria is assessable income. Scenaria: Kim sold a rare sculpture for $2,000 during the 30 June 2022 financial year. Kim had purchased the...
A:
Under Australian taxation law the sale of a collectible such as a rare sculpture may be subje......
Q:
Finn Fixes is a new charity that repairs donated cars for use by unemployed job seekers. Finn collects the cars from area junkyards. The first year Finn is in operation, jobs programs bought cars...
A:
The first year cash profit is 7 000 The accrual basis profit is 2 00......
Q:
Canadian Bacon Inc. financial statements are presented in the table below: Based on the information in the table, and using cost of goods sold and a 365-day year, calculate Days of Sales in Inventory...
A:
Days Sales in Inventory Days Sales in Inventory Inv......
Q:
Do you think the court was justified in refusing to enforce the partnership agreement in OCA v. Hodges ? Would you support an amendment to the state's professional corporation statute to permit...
A:
I m unable to access specific court cases or legal reading materials as my training data only goes u......
Q:
Let x-3xy-4y - 2x-27y - 35 = 0. dy da Use partial derivatives to calculate dy da (3-1) at the point (3,-1). dy Hint: If you call f(x, y) = 1x + 3xy+-4y+2x+-27y + -35, then da 11 -(1)
A:
Here we want to find the value od dy dx at the point 3 1 for t......
Q:
Your team has organized a competition for young people at your youth centre. The competition was promoted by posting on Twitter and Facebook announcements from the centre's accounts, and around 120...
A:
To obtain feedback and evaluate the communication strategy for the competition I would suggest utilizing a multi faceted approach that includes both q......
Q:
Oakridge Corporation has provided the information that follows related to its calculation of earnings per share for 2023. Its common shares and bonds were outstanding during the entire year. Net...
A:
Let s calculate Oakridge Corporation s 2023 basic and diluted earnings per share EPS step by step 1 Calculate Basic EPS Basic EPS is calculated by div......
Q:
Assume that X Company has three service departments A,B,C and two producing departments X and Y. Percentage of Service Total Costs A B P100,000 P200,000 B 25% -- P300,000 C- A REQUIRED: 1. Determine...
A:
Answer a Direct Method X Y A P 85 714 P 114 286 B 33 333 66 667 C 60 000 240 000 Total 179 047 420 953 Explanation Under the direct method the costs of service departments are allocated directly to th......
Q:
A charge of mass 5.0 10 -4 kg, is suspended at rest between two charged parallel plates connected to a 12 V battery. The distance between the two plates is 0.05 m. What is the sign of the charge on...
A:
Final answer q 2 0410 5 C The sign on the charged......
Q:
Select the correct answer for each of the following questions. 1. On December 31, 20X3, Saxe Corporation was merged into Poe Corporation. In the business combination, Poe issued 200,000 shares of its...
A:
1 d 2 900 000 New APIC Balance existing APIC on Poe s books APIC from new stock......
Precalculus A Problems Oriented Approach 6th Edition - ISBN: 0534402127 - Free Book