Explore BrainMass

Explore BrainMass

    Linear programming to find maximum profit using excel solver

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    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 December 24, 2021, 11:57 pm ad1c9bdddf
    https://brainmass.com/math/optimization/linear-programming-maximum-profit-excel-solver-624172

    SOLUTION This solution is FREE courtesy of BrainMass!

    Please check attachment

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

    © BrainMass Inc. brainmass.com December 24, 2021, 11:57 pm ad1c9bdddf>
    https://brainmass.com/math/optimization/linear-programming-maximum-profit-excel-solver-624172

    Attachments

    ADVERTISEMENT