BC Petrol manufactures three chemicals at their chemical plant in Kentucky: BCP1, BCP2, and BCP3. These chemicals are pr

[answerhappygod]

Bc Petrol Manufactures Three Chemicals At Their Chemical Plant In Kentucky Bcp1 Bcp2 And Bcp3 These Chemicals Are Pr 1 (123.54 KiB) Viewed 58 times

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 $40 and yields four units of BCP1, one unit of BCP2, and one unit of BCP3. Running the man process for one hour costs $30 and yields two unit of BCP1 and one unit of BCP2. To meet customer demands, at least twenty four units of BCP1, fourteen units of BCP2, and seven units of BCP3 must be produced daily. Assuming a linear relationship, use the Excel Solver to determine the optimal mix of processes zone and man to minimize costs and meet BC Petrol daily demands. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to the 1 decimal place.) Hours to run zone Hours to run man Total cost BCP1 BCP2 BCP3 Produced