subject
Mathematics, 17.10.2021 05:20 Morghan7153

Formulate and solve the following linear program: A firm wants to determine how many units of each of two products (products A and E) they should produce to make the most money. The profit in the manufacture of a unit of product A is $100 and the profit in the manufacture of a unit of product E is $87. Although the firm can readily sell any amount of either product, it is limited by its total labor hours and total machine hours available. The total labour hours per week are 4,000. Product A takes 5 hours of labour per unit and product E takes 7 hours of labour per unit. The total machine hours are 5,000 per week. Product A takes 9 hours of machine time per unit and product E takes 3 hours of machine time per unit.

Write the Objective Function and Constraints for this problem.
Solve for the best mix of product A and E using Microsoft Excel solver, and

Report the maximum value of the Objective function.
Please provide screen shots or scanned images of your Microsoft Excel Solver Reports.

ansver
Answers: 2

Another question on Mathematics

question
Mathematics, 21.06.2019 16:20
Find the slope of the line that contains the following points. r(-2, 4), s(6, -2)
Answers: 1
question
Mathematics, 21.06.2019 16:40
What is the solution of the systems of equations? y=2/3x+3 x=-2
Answers: 2
question
Mathematics, 21.06.2019 19:00
Gh bisects fgi. find the measure of hgi •15° •21° •10° •8°
Answers: 2
question
Mathematics, 21.06.2019 19:50
On a piece of paper graft y+2> -3x-3 then determine which answer matches the graph you drew
Answers: 2
You know the right answer?
Formulate and solve the following linear program: A firm wants to determine how many units of each...
Questions
question
English, 17.12.2021 04:00
question
Mathematics, 17.12.2021 04:00
Questions on the website: 13722362