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:30
What is the first step of an indirect proof of a number that is divisible by two
Answers: 2
question
Mathematics, 21.06.2019 20:20
Elena is paid a constant rate for each hour she works. the table shows the amounts of money that elena earned for various amounts of time that she worked.
Answers: 2
question
Mathematics, 21.06.2019 22:30
What is the distance from zero if a quadratic function has a line of symmetry at x=-3 and a zero at 4
Answers: 1
question
Mathematics, 21.06.2019 23:30
Solve for x and select the correct answer
Answers: 3
You know the right answer?
Formulate and solve the following linear program: A firm wants to determine how many units of each...
Questions
question
Chemistry, 11.12.2021 01:00
question
Mathematics, 11.12.2021 01:00
question
Chemistry, 11.12.2021 01:00
question
Biology, 11.12.2021 01:00
question
History, 11.12.2021 01:00
question
Social Studies, 11.12.2021 01:00
Questions on the website: 13722363