Mathematics
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.

answer
Answers: 2

Other questions on the subject: Mathematics

image
Mathematics, 21.06.2019 23:00, DisneyGirl11
In an equilateral triangle, each angle is represented by 5y+3. what is the value of y? a. 9.7 b. 10.8 c. 11.4 d. 7.2
Answers: 1
image
Mathematics, 21.06.2019 23:10, krystalhurst97
What is the distance between the points (2, 5) and (5,9)?
Answers: 1
image
Mathematics, 22.06.2019 00:00, xcorojm
What is the value of the product (3-2i)(3+2i)?
Answers: 2
image
Mathematics, 22.06.2019 01:30, icee13
One of the solutions to x2 - 2x – 15 = 0 is x = -3. what is the other solution? ox=-5 ox= -1 0 x=1 x = 5
Answers: 2
Do you know the correct answer?
Formulate and solve the following linear program: A firm wants to determine how many units of each...

Questions in other subjects:

Konu
Mathematics, 27.02.2020 04:44