Explore BrainMass
Share

Explore BrainMass

    Linear programming to find maximum profit using excel solver

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    WORLEY FLUID SUPPLIES PRODUCES THREE TYPES OF FLUID HANDLING EQUIPMENT CONTROL VALVES, METERING PUMPS AND HYDRAULIC CYLINDERS/ ALL THREE PRODUCTS REQUIRE ASSEMBLY AND TESTING BEFORE THEY CAN BE SHIPPED TO CUSTOMERS

    CONTROL VALVE METERING PUMP HYDRAULIC CYLINDER

    assembly time(min) 45 20 30

    testing time (min) 20 15 25

    Profit/Unit $372 $174 $288

    Maximum Sales 20 50 45

    Minimum Sales 5 12 22

    A TOTAL OF 3150 MINUTES OF ASSEMBLY TIME AND 2100 MINUTES OF TESTING TIME ARE AVAILABLE NEXT WEEK

    DEVELOP[ A LINEAR OPTIMIZATION MODEL TO DETERMINE HOW MANY PIECES OF EQUIPMENT THE COMPANY SHOULD MAKE NEXT WEEK TO MAXIMIZE PROFIT CONTRIBUTION

    © BrainMass Inc. brainmass.com October 10, 2019, 8:24 am ad1c9bdddf
    https://brainmass.com/math/optimization/linear-programming-maximum-profit-excel-solver-624172

    Solution Summary

    The solution gives detailed steps on solving a linear programming problem to find maximum profit using excel solver.

    $2.19