BC Petrol manufactures three chemicals at its 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.

  • CreatedApril 09, 2014
  • Files Included
Post your question