Linear optimization problem

profilehello1
Sinofert.docx

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

24

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.