Problem A-9 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 $49 and yields three units of BCP1, one unit of BCP2, and one unit of BCP3. Running the man process for one hour costs $30 and yields one unit of BCP1 and two unit of BCP2. To meet customer demands, at least twenty four units of BCP1, fifteen units of BCP2, and three 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. (Round your answers to the 1 decimal place.) Decision for zone Decision for man Total cost $ Produced BCP1 BCP2 BCP3
Let,
x1 = number of hours zone process to be run
x2 = number of hours man process to be run
Objective is to minimize cost so objective function z = Min 49x1+30x2
Subject to,
3x1+1x2 >= 24 (Minimum no of units of BCP1)
1x1+2x2 >= 15 (Minimum no of units of BCP2)
x1 >= 3 (Minimum no of units of BCP3)
x1,x2 >= 0 (non-negativity constraint)
Solving in excel solver we get,
x1 = number of hours zone process to be run = 6.6 = Decision for
Zone
x2 = number of hours man process to be run = 4.2 = Decision for
Man
Produced BCP1 BCP2 BCP3
| BCP1 | BCP2 | BCP3 |
| 24 | 15 | 6.6 |
Minimized total cost = $449.4
Solver screenshot

Problem A-9 BC Petrol manufactures three chemicals at their chemical plant in Kentucky: BCP1, BCP2, and...
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 $50 and yields four units of BCP1, one unit of BCP2, and two unit of BCP3. Running the man process for one hour costs $25 and yields one unit of BCP1 and one unit of BCP2. To meet customer demands, at least thirty units...
Dover Chemical Company manufactures specialty chemicals by a series of three processes, all materials being introduced in the Distilling Department. From the Distilling Department, the materials pass through the Reaction and Filling departments, emerging as finished chemicals The balance in the account Work in Process-Filling was as follows on January 1: Work in Process-Filling Department (3,400 units, 60% completed) Direct materials (3,400 x $9.58) Conversion (3,400 60% x $3.90) $32,572 7,956 $40,528 The following costs were charged to Work in...
Dover Chemical Company manufactures specialty chemicals by a series of three processes, all materials being introduced in the Distilling Department. From the Distilling Department, the materials pass through the Reaction and Filling departments, emerging as finished chemicals. The balance in the account Work in Process—Filling was as follows on January 1: Work in Process—Filling Department (2,200 units, 60% completed): Direct materials (2,200 x $12) $26,400 Conversion (2,200 x 60% x $7.8) 10,296 $36,696 The following costs were charged to Work...
Cost of Production Report
Dover Chemical Company manufactures specialty chemicals by a
series of three processes, all materials being introduced in the
Distilling Department. From the Distilling Department, the
materials pass through the Reaction and Filling departments,
emerging as finished chemicals.
The balance in the account Work in Process— Filling was as
follows on January 1, 2014:
Work in Process— Filling Department ( 3,400 units, 60%
completed):
Direct materials ( 3,400 × $ 9.58)
= $ 32,572
Conversion ( 3,400...
Equivalent Units and Related Costs; Cost of Production Report; Entries Dover Chemical Company manufactures specialty chemicals by a series of three processes, all materials being introduced in the Distilling Department. From the Distilling Department, the materials pass through the Reaction and Filling departments, emerging as finished chemicals. The balance in the account Work in Process—Filling was as follows on January 1: Work in Process—Filling Department (5,500 units, 30% completed): Direct materials (5,500 x $13.6) $74,800 Conversion (5,500 x 30% x...
Equivalent Units and Related Costs; Cost of Production Report; Entries Dover Chemical Company manufactures specialty chemicals by a series of three processes, all materials being introduced in the Distilling Department. From the Distilling Department, the materials pass through the Reaction and Filling departments, emerging as finished chemicals. The balance in the account Work in Process—Filling was as follows on January 1: Work in Process—Filling Department (4,500 units, 80% completed): Direct materials (4,500 x $14.5) $65,250 Conversion (4,500 x 80% x...
Equivalent Units and Related Costs; Cost of Production Report; Entries Dover Chemical Company manufactures specialty chemicals by a series of three processes, all materials being introduced in the Distilling Department. From the Distilling Department, the materials pass through the Reaction and Filling departments, emerging as finished chemicals. The balance in the account Work in Process—Filling was as follows on January 1: Work in Process—Filling Department (2,400 units, 70% completed): Direct materials (2,400 x $11.7) $28,080 Conversion (2,400 x 70% x...
Equivalent Units and Related Costs; Cost of Production Report; Entries Dover Chemical Company manufactures specialty chemicals by a series of three processes, all materials being introduced in the Distilling Department. From the Distilling Department, the materials pass through the Reaction and Filling departments, emerging as finished chemicals. The balance in the account Work in Process—Filling was as follows on January 1: Work in Process—Filling Department (1,900 units, 40% completed): Direct materials (1,900 x $16.1) $30,590 Conversion (1,900 x 40% x...
Equivalent Units and Related Costs; Cost of Production Report; EntriesDover Chemical Company manufactures specialty chemicals by a series of three processes, all materials being introduced in the Distilling Department. From the Distilling Department, the materials pass through the Reaction and Filling departments, emerging as finished chemicals.The balance in the account Work in Process—Filling was as follows on January 1:Work in Process—Filling Department (4,200 units, 70% completed): Direct materials (4,200 x $13.8) $57,960 Conversion (4,200 x 70% x...
A manufacturing firm is determining the production and inventory plan to meet demand in the next three months. The production facility can produce at most 400 units in one month. The cost of producing one unit in the next three months are respectively 28, 30, and 40 dollars. The cost of carrying one unit of inventory in the next three months are respectively are 2, 3, and 3 dollars. Assume that the firm has a starting inventory of 20 units....