BK Chemical Corporation
David, the General Manager of the New South Wales Division of BK Chemical Corporation, received notification from MaxEnergy that natural gas supplies were being rapidly depleted and that they would introduce “rolling brownouts”, temporary and periodic curtailments of natural gas supplies, if necessary.
The natural gas shortage was created by the unprecedented heat wave of the summer. Electrical generating plants were operating at capacity to supply electricity to operate air conditioning and refrigeration units. Although long-range plans called for these utility companies to convert to coal, oil, or nuclear fuel, natural gas remained the dominant boiler fuel.
In the event of a shortage, MaxEnergy, the main producer and distributor of natural gas in the region, would allocate gas to its customers under the following provisions established by the Federal Commission:
First Priority: Residential and commercial heating and cooling
Second Priority: Commercial and industrial firms that use natural gas as a source of raw material Third Priority: Industrial firms that use natural gas as a boiler fuel.
In the communication, David learned that most of BK Chemical's uses were in the second and third priority classifications. Hence, BK Chemical would probably be subjected to “rolling brownouts”, the temporary and periodic curtailments of natural gas supplies.
In order to ensure gas supply, MaxEnergy needed to make sure its pipeline pressures to be above certain levels, yet excess usage could drive the pressures low. Therefore, MaxEnergy monitored its pipeline pressures and planned to encourage usage reductions to maintain minimum levels.
MaxEnergy preferred that its customers initiate the reduction process to minimise the effect on their industrial processes. MaxEnergy was authorised, however, to curtail supplies unilaterally if the pipeline pressure fell below minimum levels.
Curtailment Plan
As the general manager, David needed to determine for BK Chemical which of its products would be least affected by a gas curtailment. Plants of the BK New South Wales Division are located in the suburbs of New Castle and Wollongong. Both of these areas would be included in the curtailment region in the event of a brownout.
In BK Chemical’s production, all gas purchased was used as boiler fuel except BK's ammonia operations. In its ammonia plant, gas was used as a source of raw materials (the manufacture of ammonia uses natural gas in the steam reforming process). That is, for all ammonia related products, natural gas was a form of raw materials. In a detailed discussion with the CEO of
MaxEnergy, David learned that MaxEnergy would not specify the products to be curtailed. The curtailment procedure would be based primarily on a customer's usage pattern. Hence, BK Chemical had the flexibility to absorb curtailments where they would have minimum impact on profits.
Based on this information, David called a staff meeting to discuss a contingency plan for allocation of natural gas among the firm's products if curtailments became a reality. The specific objective was to minimise the impact on profits contribution. After a week of study, the information in Tables 1 and 2 was presented to David.
Table 1 Contribution to Profit
Product | Contribution to profit ($/Ton) |
Ammonia | 80 |
Ammonium phosphate | 120 |
Ammonium nitrate | 140 |
Urea | 140 |
Hydrofluoric acid | 90 |
Chlorine | 70 |
Caustic soda | 60 |
Vinyl chloride monomer | 90 |
Table 2 Operational Data
Product | Capacity (tons/day) | Production Rate (% of capacity) | Natural Gas Consumption (1,000 cu. ft./ton) |
Ammonia | 1500 | 80 | 8 |
Ammonium phosphate | 600 | 90 | 10 |
Ammonium nitrate | 700 | 70 | 12 |
Urea | 200 | 80 | 12 |
Hydrofluoric acid | 800 | 70 | 7 |
Chlorine | 1500 | 80 | 18 |
Caustic soda | 1600 | 80 | 20 |
Vinyl chloride monomer | 1400 | 60 | 14 |
It is clear that, from Table 1, different products have different contributions to the company’s profit. David realised that he needs to be careful in deciding the production plan in order to minimise impact on the total profit. Currently BK Chemical's contract with MaxEnergy specified a maximum of 90,000 x 103 cu.ft. per day for its production. However, curtailments are projected to be based on actual usage rather than contractual maximums. Based on the data in Table 2, David calculated that the current natural gas usage is 85,680 x 103 cu. ft. per day. Through communication with MaxEnergy, David learned that MaxEnergy projects curtailments in the range of 20 to 40 percent.
Business Report
To investigate options and plan for potential curtailments, David asked you, a graduate in Supply Chain Analytics, to analyse the situation and submit a report to him. In this report, you are expected to cover the following aspects.
From the analytical side, to complete the report, you will need to solve one or more linear program problems, interpret the results, and make use of the sensitivity analysis reports.
Formatting Requirements
For proper business communication, your report should also conform to the following requirements.
Introduction
The following pages discuss the business problem pertaining to New South Wales Division of BK Chemical Corporation.
The problem has occurred due to shortage of natural gas which in turn is due to unprecedented heat wave of the summer. Hence, the main producer and distributer of natural gas in the region, MaxEnergy has issued a notification that natural gas supplies were getting depleted rapidly and ‘rolling brownouts’ will be introduced as a temporary curtailment measure as necessary. Further, in the event of shortage, the available gas will be allocated under the following provisions established by the Federal Commission:
David, the General Manager of the New South Wales Division of BK Chemical Corporation, needs to come up with a contingency plan so as to tackle this expected shortage of natural gas supply (BK Chemical Corporation Case Study, 2020).
Business Problem
David, the General Manager of the New South Wales Division of BK Chemical Corporation, has learnt that all of BK Chemical's uses were in the third priority classification, except ammonia operations which is the second priority classification. Hence, BK Chemical would probably be subjected to “rolling brownouts”, the temporary and periodic curtailments of natural gas supplies.
MaxEnergy has notified that the natural gas supply may be reduced in the range of 20 per cent to 40 per cent of existing contracted supply. BK Chemicals has a contract of a maximum of 90,000 x 103 cu.ft. per day for its production.
However, MaxEnergy would not specify the products to be curtailed. The curtailment procedure would be based primarily on a customer's usage pattern. Hence, BK Chemical had the flexibility to absorb curtailments where they would have minimum impact on profits (BK Chemical Corporation Case Study, 2020).
David has acquired following data related to profit and operations regarding various products:
Product | Contribution to profit ($/Ton) |
Ammonia | 80 |
Ammonium phosphate | 120 |
Ammonium nitrate | 140 |
Urea | 140 |
Hydrofluoric acid | 90 |
Chlorine | 70 |
Caustic soda | 60 |
Vinyl chloride monomer | 90 |
Product | Capacity (tons/day) | Production Rate (% of capacity) | Natural Gas Consumption (1,000 cu. ft./ton) |
Ammonia | 1500 | 80 | 8 |
Ammonium phosphate | 600 | 90 | 10 |
Ammonium nitrate | 700 | 70 | 12 |
Urea | 200 | 80 | 12 |
Hydrofluoric acid | 800 | 70 | 7 |
Chlorine | 1500 | 80 | 18 |
Caustic soda | 1600 | 80 | 20 |
Vinyl chloride monomer | 1400 | 60 | 14 |
In consultation with the company’s CEO, it has been determined that the main target of nullifying the impact of natural gas supply reduction should be to minimise the impact on profit. In other words, profit maximisation is contingency plan’s main target under given situations of natural gas supply reduction.
Business Problem for BK Chemicals
The business problem for BK Chemicals is to arrive at such production level of various products that the impact of natural gas supply shortage is minimized with respect to the overall profit.
In other words, profit maximization under the given constraints, that is, reduction in natural gas supply needs to be attained (Cooper, 2014).
The above identified business problem for BK Chemicals can be solved with the help of Linear Programming as it is an optimization technique that can be effectively used to maximize or minimize a target value by finding values of the variables that impact the target value. The constraints need to be linear and also the objective function needs to be linear (Sierksma & Zwols, 2015).
These conditions are satisfied in the above scenario and hence, we can use the linear programming technique to find the contingency plan for BK Chemicals in order to tackle the anticipated natural gas supply reduction.
The linear objective function will aim to maximize the contribution or profit from different product lines. This will be done by changing the values of the variable named ‘Production Rate (% capacity)’. In turn, this will be lead to automatic change in production, natural gas consumption and profit contribution.
The constraints include the limit to supply of natural gas consumption (Dantzig & Thapa, 1997).
The variables can be defined as:
Product | Variable (Production Rate %) |
Ammonia | a |
Ammonium phosphate | b |
Ammonium nitrate | c |
Urea | d |
Hydrofluoric acid | e |
Chlorine | f |
Caustic soda | g |
Vinyl chloride monomer | h |
The linear objective function can be defined as follows for the base case (Dantzig, 1982):
Maximise Profit (p) = 80*1500a + 120*600b + 140*700c + 140*200d + 90*800e + 70*1500f + 60*1600g + 90*1400h
Subject to:
a, b, c, d, e, f, g, h >= 0
a, b, c, d, e, f, g, h <= 100
8*1500a + 10*600b + 12*700c + 12*200d + 7*800e + 18*1500f + 20*1600g + 14*1400h <= 90000
The above function defines variables a-h that indicate production capacity percentage for each of the products. The objective linear function defines the sum total of the profit contribution from production of each product line.
The constraints define the production rate percentage that must lie between 0% to 100% for any of the products. Further, the last constraint defines the sum total of the natural gas consumption corresponding to the production of each product line.
The Solver function in MS-Excel was used to solver the above linear program as follows (MacDonald, 1995):
Product | Capacity (tons/day) | Natural Gas Consumption (1,000 cu. ft./ton) | Contribution to profit ($/Ton) | Production | Natural Gas Usage | Profit Contribution | Production Rate (% of capacity) |
Ammonia | 1,500 | 8 | $80 | 1,200 | 9,600 | $96,000 | 80 |
Ammonium phosphate | 600 | 10 | $120 | 540 | 5,400 | $64,800 | 90 |
Ammonium nitrate | 700 | 12 | $140 | 490 | 5,880 | $68,600 | 70 |
Urea | 200 | 12 | $140 | 160 | 1,920 | $22,400 | 80 |
Hydrofluoric acid | 800 | 7 | $90 | 560 | 3,920 | $50,400 | 70 |
Chlorine | 1,500 | 18 | $70 | 1,200 | 21,600 | $84,000 | 80 |
Caustic soda | 1,600 | 20 | $60 | 1,280 | 25,600 | $76,800 | 80 |
Vinyl chloride monomer | 1,400 | 14 | $90 | 840 | 11,760 | $75,600 | 60 |
90,000 | 85,680 | $5,38,600 |
This represents the current scenario, whereby the total profit is $538,600 and natural gas consumption is 85,680 cubic units which is less than the available 90,000 cubic units. When Solver function was applied to maximize the overall profit by tweaking the production rate (in yellow), the result is as follows:
Product | Capacity (tons/day) | Natural Gas Consumption (1,000 cu. ft./ton) | Contribution to profit ($/Ton) | Production | Natural Gas Usage | Profit Contribution | Production Rate (% of capacity) |
Ammonia | 1,500 | 8 | $80 | 1,500 | 12,000 | $1,20,000 | 100 |
Ammonium phosphate | 600 | 10 | $120 | 600 | 6,000 | $72,000 | 100 |
Ammonium nitrate | 700 | 12 | $140 | 700 | 8,400 | $98,000 | 100 |
Urea | 200 | 12 | $140 | 200 | 2,400 | $28,000 | 100 |
Hydrofluoric acid | 800 | 7 | $90 | 800 | 5,600 | $72,000 | 100 |
Chlorine | 1,500 | 18 | $70 | 1,500 | 27,000 | $1,05,000 | 100 |
Caustic soda | 1,600 | 20 | $60 | 450 | 9,000 | $27,000 | 28.125 |
Vinyl chloride monomer | 1,400 | 14 | $90 | 1,400 | 19,600 | $1,26,000 | 100 |
90,000 | 90,000 | $6,48,000 |
By running all products at 100% capacity (except Caustic soda), the profit has increased from $538,600 to $648,000 whereby all of available 90,000 cubic units of natural gas are being utilized.
The variables can be defined as:
Product | Variable (Production Rate %) |
Ammonia | a |
Ammonium phosphate | b |
Ammonium nitrate | c |
Urea | d |
Hydrofluoric acid | e |
Chlorine | f |
Caustic soda | g |
Vinyl chloride monomer | h |
The linear objective function can be defined as follows for the 20% reduction case:
Maximise Profit (p) = 80*1500a + 120*600b + 140*700c + 140*200d + 90*800e + 70*1500f + 60*1600g + 90*1400h
Subject to:
a, b, c, d, e, f, g, h >= 0
a, b, c, d, e, f, g, h <= 100
8*1500a + 10*600b + 12*700c + 12*200d + 7*800e + 18*1500f + 20*1600g + 14*1400h <= 72000
The above function defines variables a-h that indicate production capacity percentage for each of the products. The objective linear function defines the sum total of the profit contribution from production of each product line.
The constraints define the production rate percentage that must lie between 0% to 100% for any of the products. Further, the last constraint defines the sum total of the natural gas consumption corresponding to the production of each product line. The availability of natural gas has reduced by 20% to reach 72,000 cubic units from earlier 90,000 cubic units.
The Solver function in MS-Excel was used to solver the above linear program as follows:
Product | Capacity (tons/day) | Natural Gas Consumption (1,000 cu. ft./ton) | Contribution to profit ($/Ton) | Production | Natural Gas Usage | Profit Contribution | Production Rate (% of capacity) |
Ammonia | 1,500 | 8 | $80 | 1,500 | 12,000 | $1,20,000 | 100 |
Ammonium phosphate | 600 | 10 | $120 | 600 | 6,000 | $72,000 | 100 |
Ammonium nitrate | 700 | 12 | $140 | 700 | 8,400 | $98,000 | 100 |
Urea | 200 | 12 | $140 | 200 | 2,400 | $28,000 | 100 |
Hydrofluoric acid | 800 | 7 | $90 | 800 | 5,600 | $72,000 | 100 |
Chlorine | 1,500 | 18 | $70 | 1,000 | 18,000 | $70,000 | 66.66666667 |
Caustic soda | 1,600 | 20 | $60 | - | - | $- | 0 |
Vinyl chloride monomer | 1,400 | 14 | $90 | 1,400 | 19,600 | $1,26,000 | 100 |
72,000 | 72,000 | $5,86,000 |
By running all products at 100% capacity (except Caustic soda and chlorine), the profit is still higher at $586,000 as compared to current scenario where profit is only $538,600.
The variables can be defined as:
Product | Variable (Production Rate %) |
Ammonia | a |
Ammonium phosphate | b |
Ammonium nitrate | c |
Urea | d |
Hydrofluoric acid | e |
Chlorine | f |
Caustic soda | g |
Vinyl chloride monomer | h |
The linear objective function can be defined as follows for the 40% reduction case:
Maximise Profit (p) = 80*1500a + 120*600b + 140*700c + 140*200d + 90*800e + 70*1500f + 60*1600g + 90*1400h
Subject to:
a, b, c, d, e, f, g, h >= 0
a, b, c, d, e, f, g, h <= 100
8*1500a + 10*600b + 12*700c + 12*200d + 7*800e + 18*1500f + 20*1600g + 14*1400h <= 54000
The above function defines variables a-h that indicate production capacity percentage for each of the products. The objective linear function defines the sum total of the profit contribution from production of each product line.
The constraints define the production rate percentage that must lie between 0% to 100% for any of the products. Further, the last constraint defines the sum total of the natural gas consumption corresponding to the production of each product line. The availability of natural gas has reduced by 40% to reach 54,000 cubic units from earlier 90,000 cubic units.
The Solver function in MS-Excel was used to solver the above linear program as follows:
Product | Capacity (tons/day) | Natural Gas Consumption (1,000 cu. ft./ton) | Contribution to profit ($/Ton) | Production | Natural Gas Usage | Profit Contribution | Production Rate (% of capacity) |
Ammonia | 1,500 | 8 | $80 | 1,500 | 12,000 | $1,20,000 | 100 |
Ammonium phosphate | 600 | 10 | $120 | 600 | 6,000 | $72,000 | 100 |
Ammonium nitrate | 700 | 12 | $140 | 700 | 8,400 | $98,000 | 100 |
Urea | 200 | 12 | $140 | 200 | 2,400 | $28,000 | 100 |
Hydrofluoric acid | 800 | 7 | $90 | 800 | 5,600 | $72,000 | 100 |
Chlorine | 1,500 | 18 | $70 | 0 | 0 | $0 | 0 |
Caustic soda | 1,600 | 20 | $60 | - | - | $- | 0 |
Vinyl chloride monomer | 1,400 | 14 | $90 | 1,400 | 19,600 | $1,26,000 | 100 |
72,000 | 54,000 | $5,16,000 |
By running all products at 100% capacity (except Caustic soda and chlorine), the profit is a little lower at $516,000 as compared to current scenario where profit is $538,600.
Some of the assumptions are clear from the case study itself, such as:
Some of the additional assumptions that can be drawn are (Lewis, 2008):
The above discussion can be summarized as follows with respect to profit maximisation and product lines:
Natural Gas Constraint (1,000 cu. ft./ton) | Natural Gas Consumption (1,000 cu. ft./ton) | Profit Contribution | |
Current Scenario | 90,000 | 85,680 | $5,38,600 |
Maximized Base Case | 90,000 | 90,000 | $6,48,000 |
20% Reduction Case | 72,000 | 72,000 | $5,86,000 |
40% Reduction Case | 54,000 | 54,000 | $5,16,000 |
From the above table, it is clear that BK Chemicals is not attaining the profit maximization objective even under current scenario. With the given numbers and 90,000 cubic units of natural gas, the company can increase its profit from $538,600 to $648,000. This indicates operational inefficiency and lack of analysis prior to announcement of the natural gas curtailment plans.
Further, if we compare the current scenario with 20% reduction case where profit will be maximised, then we can see that profit actually goes up from $538,600 to $586,000. This indicates that due to the act of creating contingency plan, the 20% reduction in natural gas supply may actually benefit the company by increasing overall profit through adjustment of various product lines.
However, if we compare the current scenario with 40% reduction case where profit will be maximised, then we can see that profit reduces from $538,600 to $516,000. This is the only scenario where the company will face an impact on profit.
Product | Current Scenario | Maximized Base Case | 20% Reduction Case | 40% Reduction Case |
Ammonia | 80.0 | 100.0 | 100.0 | 100.0 |
Ammonium phosphate | 90.0 | 100.0 | 100.0 | 100.0 |
Ammonium nitrate | 70.0 | 100.0 | 100.0 | 100.0 |
Urea | 80.0 | 100.0 | 100.0 | 100.0 |
Hydrofluoric acid | 70.0 | 100.0 | 100.0 | 100.0 |
Chlorine | 80.0 | 100.0 | 66.7 | 0.0 |
Caustic soda | 80.0 | 28.1 | - | - |
Vinyl chloride monomer | 60.0 | 100.0 | 100.0 | 100.0 |
From the above table, we can see that as soon as natural gas supply is reduced by 20%, caustic soda production goes to zero. This is due to combination or one of the factors that this product line has the lowest profit contribution of $60/ton and it uses the highest quantity of natural gas at 20,000 cubic units/ton. Hence, this is the least profitable product line under given constraints.
The next in line is Chlorine product line whose production rate reduces to 66.7% under 20% natural gas reduction scenario and further reduces to zero under 40% natural gas reduction scenario. This is due to combination or one of the factors that this product line has the second lowest profit contribution of $70/ton and it uses the second highest quantity of natural gas at 18,000 cubic units/ton. Hence, this is a very low profit product line under given constraints.
Hence, it is recommended that in order to attain the profit maximisation objective, the company should first maximise the base case scenario such that profit increases to $648,000. This can be easily achieved by tweaking the production rates of various products. As and when the natural gas supply is curtailed by 20% and 40%, BK Chemical can use the above provided production rates keeping in mind the profit maximisation objective. The company should also consider alternative products instead of caustic soda and chlorine such that profit can be increased further.