Explore BrainMass

Explore BrainMass

    Optimal mix of processes zone; BC Petrol daily demands

    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!

    BC Petrol manufactures three chemicals at their chemical plant in Kentucky: BCP1, BCP2, and BCP3. These chemicals are produced in two production processes known as zone and man. Running the zone process for an hour costs $48 and yields three units of BCP1, one unit of BCP2, and one unit of BCP3. Running the man process for one hour costs $24 and yields one unit of BCP1 and one unit of BCP2. To meet customer demands, at least 20 units of BCP1,10 units of BCP2, and 6 units of BCP3 must be produced daily. Assuming a linear relationship, use Excel Solver to determine the optimal mix of processes zone and man to minimize costs and meet BC Petrol daily demands.

    Use excel solver.

    © BrainMass Inc. brainmass.com March 4, 2021, 10:39 pm ad1c9bdddf
    https://brainmass.com/business/organizational-behaviour/optimal-mix-of-processes-zone-bc-petrol-daily-demands-349828

    Solution Preview

    See the attached file. Thanks

    "BC Petrol manufactures three chemicals at their chemical plant in Kentucky: BCP1, BCP2, and BCP3. These chemicals are produced in two production processes known as zone and man. Running the zone process for an hour costs $48 and yields three units of BCP1, one unit of BCP2, and one unit of BCP3. Running the man process for one hour costs $24 and yields one unit of BCP1 and one unit of BCP2. To meet customer demands, at least 20 units of BCP1,10 ...

    Solution Summary

    This post addresses how to determine the optimal mix of processes zone, to minimize costs and meet BC Petrol daily demands by using Excel solver

    $2.49

    ADVERTISEMENT