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 17:00
Jasmine wants to eat at 8: 00pm her meal takes 65mins to cook what time does she need to put the meal in the oven
Answers: 2
question
Mathematics, 21.06.2019 18:20
What is the solution to the equation? k/6.4=8.7 2.3 5.568 15.1 55.68
Answers: 1
question
Mathematics, 21.06.2019 20:00
Michelle and julie work at a catering company. they need to bake 264 cookies for a birthday party that starts in a little over an hour and a half. each tube of cookie dough claims to make 36 cookies, but michelle eats about 1/5 of every tube and julie makes cookies that are 1.5 times as large as the recommended cookie size.it takes about 8 minutes to bake a container of cookies, but since julie's cookies are larger, they take 12 minutes to bake. a. how many tubes should each girl plan to bake? how long does each girl use the oven? b. explain your solution process what did you make? c. what assumptions did you make?
Answers: 2
question
Mathematics, 22.06.2019 03:30
The area of a square floor on a scale drawing is 64 square centimeters, and the scale drawing is 1 centimeter: 3 ft. what is the area of the actual floor? what is the ratio of the area in the drawing to the actual area? the area of the actual floor is square feet. the ratio of the area in the drawing to the actual area is 1 square centimeter: square feet.
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
English, 14.06.2020 20:57
Questions on the website: 13722362