Question: Using Excel, can you please show the formula used to calculate the solution for A, B and C. Objective function Maximize profit = 40(800)A +

Using Excel, can you please show the formula used to calculate the solution for A, B and C.

Objective function

Maximize profit = 40(800)A + 50(700)B + 60(800)C

Constraints

Labor: 4A +4B +5C <= 80

Raw material #1:

200A + 300B +300C <= 6,000

Raw material #2:

600A + 400B +500C <= 5,000

The solution is:

A = 0

B = 0

C = 10

Z = 480000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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 Mathematics Questions!

Q:

Given the information on the LP model given above, please fill out and add any additinal information needed to the Excel format of the LP model given below! Topic: The management problem I would like...

Q:

Given the information on the LP model given above, please fill out and add any additinal information needed to the Excel format of the LP model given below! Topic: The management problem I would like...

Q:

Above is the management problem I choose to solve using an LP model. We can find the decision variables, the algebraic formulation of the problem, and different parameter halues that U have selected...

Q:

PLEASE: DO NOT OPEN TAB(s) ON YOUR BROWSER OTHE DO NOT SEND THE SOLUTION FILE TO YOUR EM DO NOT OPEN ANY COURSE MATERIAL . SAVE YOUR FILE AS: CIS623_FinalExam_YourName Refresh your browser before...

Q:

betalt Meded Ohjet e Alle VA Cell Nam 03 Dec Vans . 23 1300 Shaw Name Vale Game Allwe Ino De 10000 2011 1000 097 Dono SES Control 10 1. We Ww The thing wrogram Care FY Adjustable Cells Cell Name $C$3...

Q:

Please answer the part EFGH. thanks! Question 5. (22 points) OPTIMAL PRODUCT MIX AND WHAT-IF QUESTIONS AU Electronics manufactures is the supplier of components C1, C2 and C3 for the production of...

Q:

Problem 1 (100 marks) Liberty Taxes is a Vancouver based firm specializing in preparing Canadian Income Tax forms for their individual and corporate clients. Liberty processes only two types of...

Q:

can you please solve this in formula form on excel with the formulas written out so i can see where the answers cam from please! can can you please solve it in formula form as well show the formula...

Q:

Simple Linear Romanian Brey's Accounting & Tax Services is a small accounting fim in Sioux City, I which completes taxes for individuals. Hvery yow, firms like Bret's decide how much they will charge...

Q:

Answer #3 only Purpose To assess your ability to: solve basic linear programming problems by using Excel Solver solve basic linear programming problems by using a graphical solution perform...

Q:

What is polystyrene? The following processes result in a stronger polystyrene polymer. Explain why in each case. a. Addition of catalyst to form syndioracric polystyrene b. Addition of 1,3-butadiene...

Q:

Prove that from any point (a, b) four normals can be drawn to the rectangular hyperbola xy = c and that if the coordinates of the four feet of the normals P, Q, R, S be (x, y), i = 1, 2, 3, 4. Then...

Q:

For any transaction exceeding $ 1 0 , 0 0 0 in cash, a US business or financial institution must file a currency transaction report with which organization? FinCEN IRS FATF US Treasury

Q:

and Susan are facing an important decision. After discussing different financial scenarios, the two computer engineers felt it was time to finalize their cash flow projections and move to the next...