sza2016
sza2016
19.10.2021 • 
Mathematics

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, andReport the maximum value of the Objective function.Please provide screen shots or scanned images of your Microsoft Excel Solver Reports.

Solved
Show answers

Ask an AI advisor a question