Optimal mix of processes zone; BC Petrol daily demands
Not what you're looking for?
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.
Purchase this Solution
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
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 ...
Purchase this Solution
Free BrainMass Quizzes
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
Basics of corporate finance
These questions will test you on your knowledge of finance.