Linear optimization problem
SINOFERT HOLDINGS LIMITED: UREA DISTRIBUTION PLANNING
High transportation costs, imbalance between supply and demand, competition and market volatility had all been listed as challenges to Sinofert’s urea business. The company had invested a great deal of time and money in this business but had still reported losses in 2007 and 2009 and only a small profit in 2008. If the company was to make its urea business profitable, it needed a fresh look and a change in the way of doing business. Chief Analytics Officer (CAO) of Sinofert, Lee Jun, was asked to look at the company’s urea business and to provide recommendations to increase profitability.
COMPANY
Sinofert Holdings Limited (Sinofert) was the largest comprehensive fertilizer enterprise in China with a market capitalization of US$4.2 billion (as of March 26, 2010). Its major shareholders were Sinochem (52 per cent share), a well-known petrochemical company in China with annual sales over US$40 billion, and the Potash Corporation of Saskatchewan (PCS) (20 per cent share), the largest fertilizer company in the world.
Sinofert manufactured fertilizers, sold them in wholesale and retail markets and also conducted research and development on new and improved fertilizers. It also procured end products directly from suppliers for sale to 40,000 customers (small-sized fertilizer wholesalers, retailers and farmers). The end products included urea, diammonium phosphate (DAP) and monoammonium phosphate (MAP) potash. Urea was the biggest volume seller, accounting for 40 per cent of Sinofert’s distribution business.
THE UREA MARKET
Fertilizer (“food’s gold”) had always played a very important role in improving yields in food production. Urea was a major fertilizer, and in 2009 China consumed more than 50 million tons of it. The goal of Sinofert was to maintain the leading position in China’s fertilizer market and to expand its market share in each province.
19
China had many retailers who bought fertilizers from large wholesalers or producers and sold them to farmers. Being a large fertilizer company, Sinofert distributed urea and other fertilizers to different township and county level dealers through its local distribution centres and logistics facilities.
The urea market was volatile, with price variations over time as well as from province to province resulting from fluctuations in supply and demand. In order to plan and monitor the new year’s sales and production, Sinofert would set a yearly sales budget for each province according to market size and sales ability (see Exhibit 1).
China had a total of 190 urea plants based in 14 agricultural provinces. The supply and demand situation was different from province to province, with some provinces unable to balance their own supply and demand. In many cases, urea had to be shipped from an over-supplied province to the under-supplied provinces, resulting in long transportation times and high freight costs.
Sinofert had its own production plants (with a total capacity of two million tons) as well as outsourcing partners who could supply four million tons of urea from 70 plants in China. Among these 70 suppliers, 13 plants were key large-capacity suppliers who were willing to supply and transport their products outside their own provinces. Sinofert had established long-term relationships with these key suppliers through contracts (see Exhibit 2).
Every year, Sinofert set an annual (one-year) quantity contract with these suppliers, but the contract quantities were just estimates and not guaranteed amounts. However, Sinofert had to purchase at least a certain minimum quantity in order to sustain its strong relationship with its key suppliers. Sinofert also had to purchase the exact contract quantity from its owned production plants regardless of market demand. Historically, Sinofert Changshan had supplied a minimum 250,000 tons to Jilin province, and Jiangsu Linggu had supplied a minimum of 200,000 tons to Jiangsu province annually. The 2009 realized supply quantities are summarized in Exhibit 3.
THE CHALLENGES
The market share of Sinofert in the urea business was increasing as a result of its efforts and investment in the business over the last 10 years, but it had not seen the expected financial results. In 2007 and 2009, Sinofert lost money in the urea business, and in 2008 it made a negligible profit. Lee Jun thought that stiff competition, market volatility, high transportation costs (see Exhibit 4), seasonality of urea consumption and a lack of appropriate production and inventory policies were the reasons why Sinofert had not made the profits it had hoped for from urea.
GAME PLAN
Lee Jun sat down at her desk to prepare a game plan to tackle Sinofert’s challenges in the urea business. Her current ideas were to increase sales budgets, evaluate strategic planning for production and transportation and perform a scenario analysis to determine the best future course of action. She hoped that all this would be clearer after a cup of jasmine tea.
Page 2
EXHIBIT 1: MARKET CAPACITY AND SINOFERT'S BUDGET IN CHINA OF MAJOR AGRICULTURE PROVINCES
|
Province\Quantity |
Market size (ton/year) |
Sales Budget (ton/year) |
Min Sales Qty (ton/year) |
Average Selling Prices (RMB/ton) |
|
Heilongjiang |
1,300,000 |
220,000 |
150,000 |
1,917 |
|
Jilin |
1,200,000 |
400,000 |
300,000 |
1,864 |
|
Liaoning |
1,100,000 |
180,000 |
120,000 |
1,880 |
|
Hebei |
3,000,000 |
200,000 |
100,000 |
1,798 |
|
Henan |
6,000,000 |
210,000 |
200,000 |
1,787 |
|
Shandong |
4,500,000 |
500,000 |
270,000 |
1,812 |
|
Jiangsu |
4,500,000 |
450,000 |
200,000 |
1,866 |
|
Anhui |
2,200,000 |
230,000 |
110,000 |
1,842 |
|
Hubei |
2,600,000 |
200,000 |
100,000 |
1,837 |
|
Hunan |
2,300,000 |
200,000 |
80,000 |
1,901 |
|
Jiangxi |
1,500,000 |
270,000 |
180,000 |
1,915 |
|
Fujian |
1,200,000 |
180,000 |
90,000 |
1,960 |
|
Guangdong |
1,200,000 |
230,000 |
170,000 |
1,930 |
|
Guangxi |
1,600,000 |
100,000 |
18,000 |
1,917 |
|
Total |
34,200,000 |
3,570,000 |
2,088,000 |
|
Data in all exhibits from company records.
Page 3
EXHIBIT 2: 2010 YEARLY CONTRACT WITH KEY SUPPLIERS (INCLUDING SINOFERT FACTORY PRODUCTION)
|
Supplier\quantity |
Maximum Capacity (ton/year) |
Contract Qty (ton/year) |
Minimum Qty (ton/year) |
Average Manufacturing Cost (RMB) |
|
Sinofert Pingyuan* |
980,000 |
980,000 |
980,000 |
1700 |
|
Sinofert Changshan* |
300,000 |
300,000 |
300,000 |
1750 |
|
Shanxi Fengxi |
900,000 |
300,000 |
100,000 |
1650 |
|
Shandong Lian Meng |
1,000,000 |
350,000 |
200,000 |
1720 |
|
Shandong Ruixing |
1,000,000 |
300,000 |
200,000 |
1700 |
|
Shandong Lunan |
600,000 |
120,000 |
50,000 |
1700 |
|
Henan Xinlianxin |
1,000,000 |
300,000 |
200,000 |
1700 |
|
Henan Pingdingshan |
400,000 |
100,000 |
30,000 |
1700 |
|
Jiangsu Linggu |
1,000,000 |
450,000 |
300,000 |
1750 |
|
Hebei Zhengyuan |
600,000 |
120,000 |
60,000 |
1700 |
|
Hebei Jinghua |
300,000 |
120,000 |
60,000 |
1700 |
|
Anhui Haoyuan |
300,000 |
100,000 |
80,000 |
1750 |
|
Neimenggu Erduosi |
1,000,000 |
350,000 |
200,000 |
1650 |
|
Totals |
9,380,000 |
3,890,000 |
2,760,000 |
|
* Sinofert owned plants.
Page 4
23
EXHIBIT 3: PLANNED SHIPMENT QUANTITIES 2009
|
Suppliers/ Supplied province |
Sinofert Pingyuan |
Sinofert Changshan |
Shanxi Fengxi |
Shandong Lianmeng |
Shandong Ruixing |
Shandong Lunan |
Henan Xinlianxin |
Henan Pingdingsh an |
Jiangsu Linggu |
Hebei Zhengyuan |
Hebei Jinghua |
Anhui Haoyuan |
Neimeng Erduosi |
|
Heilongjiang |
54,171 |
0 |
13,533 |
14,610 |
30,000 |
30,000 |
13,920 |
0 |
0 |
13,920 |
0 |
0 |
50,456 |
|
Jilin |
44,143 |
292,479 |
6,189 |
3,780 |
20,000 |
10,000 |
16,080 |
0 |
0 |
14,640 |
4,860 |
0 |
14,280 |
|
Liaoning |
49,886 |
0 |
9,344 |
9,900 |
12,000 |
0 |
25,920 |
0 |
0 |
18,004 |
4,500 |
0 |
28,140 |
|
Hebei |
15,574 |
0 |
31,291 |
0 |
10,000 |
20,000 |
0 |
0 |
0 |
30,132 |
47,892 |
0 |
39,060 |
|
Henan |
18,926 |
0 |
67,792 |
0 |
10,000 |
10,000 |
24,360 |
50,000 |
0 |
0 |
0 |
0 |
18,032 |
|
Shandong |
498,726 |
0 |
5,000 |
103,860 |
20,000 |
10,000 |
0 |
0 |
0 |
0 |
5,754 |
0 |
47,880 |
|
Jiangsu |
76,900 |
0 |
19,920 |
44,280 |
10,000 |
0 |
27,000 |
0 |
248,024 |
0 |
4,848 |
0 |
0 |
|
Anhui |
84,857 |
0 |
21,351 |
36,360 |
5,000 |
5,000 |
0 |
0 |
0 |
0 |
4,500 |
31,410 |
21,000 |
|
Hubei |
6,886 |
0 |
51,656 |
0 |
30,000 |
0 |
600 |
20,000 |
0 |
2,192 |
0 |
0 |
0 |
|
Hunan |
17,634 |
0 |
51,440 |
8,100 |
20,000 |
0 |
7,000 |
0 |
0 |
10,560 |
0 |
0 |
0 |
|
Jiangxi |
17,426 |
0 |
12,960 |
5,040 |
10,000 |
0 |
29,260 |
0 |
0 |
14,160 |
0 |
0 |
0 |
|
Fujian |
33,600 |
0 |
726 |
7,020 |
0 |
40,000 |
0 |
0 |
0 |
0 |
0 |
42,750 |
31,080 |
|
Guangdong |
22,229 |
0 |
4,152 |
6,498 |
0 |
0 |
14,652 |
0 |
0 |
15,200 |
0 |
8,700 |
52,983 |
|
Guangxi |
9,514 |
0 |
0 |
5,220 |
0 |
0 |
2,400 |
0 |
0 |
0 |
0 |
0 |
8,400 |
|
Manuf Qty |
950,471 |
292,479 |
295,353 |
244,668 |
177,000 |
125,000 |
161,192 |
70,000 |
248,024 |
118,808 |
72,354 |
82,860 |
311,311 |
Page 5
EXHIBIT 4: AVERAGE FREIGHT FROM FACTORY TO EACH PROVINCIAL MARKET
|
Supplier |
Sinofert Pingyuan |
Sinofert Changshan |
Shanxi Fengxi |
Shandong Lianmeng |
Shandong Ruixing |
Shandong Lunan |
Henan Xinlianxin |
Henan Pingdingshan |
Jiangsu Linggu |
Hebei Zhengyuan |
Hebei Jinghua |
Anhui Haoyuan |
Neimeng Erduosi |
|
Heilongjiang |
119 |
70 |
129 |
136 |
145 |
119 |
185 |
143 |
164 |
120 |
108 |
151 |
155 |
|
Jilin |
101 |
40 |
110 |
119 |
128 |
102 |
167 |
123 |
147 |
101 |
90 |
133 |
137 |
|
Liaoning |
81 |
60 |
91 |
98 |
107 |
82 |
148 |
105 |
126 |
82 |
69 |
112 |
118 |
|
Hebei |
45 |
100 |
45 |
64 |
73 |
47 |
105 |
58 |
92 |
40 |
32 |
69 |
75 |
|
Henan |
83 |
130 |
39 |
85 |
77 |
49 |
84 |
22 |
81 |
70 |
69 |
46 |
59 |
|
Shandong |
58 |
110 |
50 |
53 |
61 |
36 |
119 |
64 |
77 |
62 |
46 |
58 |
89 |
|
Jiangsu |
67 |
150 |
56 |
72 |
65 |
31 |
117 |
54 |
44 |
74 |
57 |
46 |
84 |
|
Anhui |
69 |
140 |
53 |
73 |
65 |
31 |
114 |
41 |
43 |
75 |
58 |
36 |
81 |
|
Hubei |
96 |
150 |
56 |
98 |
90 |
60 |
109 |
39 |
77 |
86 |
82 |
61 |
85 |
|
Hunan |
122 |
160 |
86 |
122 |
114 |
81 |
141 |
74 |
85 |
114 |
107 |
80 |
110 |
|
Jiangxi |
114 |
160 |
88 |
115 |
107 |
72 |
153 |
70 |
66 |
114 |
100 |
71 |
110 |
|
Fujian |
129 |
170 |
102 |
129 |
124 |
86 |
171 |
84 |
66 |
128 |
114 |
85 |
124 |
|
Guangdong |
164 |
170 |
126 |
164 |
161 |
126 |
162 |
119 |
117 |
158 |
149 |
125 |
151 |
|
Guangxi |
156 |
160 |
109 |
157 |
168 |
133 |
152 |
93 |
127 |
148 |
142 |
132 |
144 |
The freight from factory to specific province is average freight because there are different rate to different points in the province.