project feasibility and evaluation slung drinking water sec 2 group 6
Post on 04-Apr-2018
214 Views
Preview:
TRANSCRIPT
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
1/114
1
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
2/114
2
Preface
Drinking water industry is an important role in Thailand. It is a major factor in theneed for human consumption. The water business is growing rapidly. Thats why we try to
create the business drinking water business. Slung is a name of our drinking water
company. We produce bottled water glass. Slung drinking water distributes drinking water to
hotels and restaurants in Chiang Rai. Although drinking water business will not be profitable
in the short term, but long-term drinking water business that stable and gain more profit. With
a far-reaching vision of our business Slung drinking water will continue to grow in the future.
Sincerely You
Group number 6 Section 2
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
3/114
3
Table of Content
Chapter 1 Introduction 8
1.1
Background and Significance of the Project 9-111.2 Project Objectives 111.3 Benefits of project 111.4 Activities/Time frames 12
Chapter 2 Industry profile 13
2.1 Nature of Industry 14
2.2 Situation of Industry 14-15
2.3 Product/Service 15-16
Chapter 3 Market Feasibility Study 17
3.1 General Environment Analysis 18
3.1.1 Political 18
3.1.2 Economic 18-19
3.1.3 Social 19
3.1.4 Environment 19
3.1.5 Technology 19-20
3.2 Competition Analysis 20
3.2.1Competition Analysis 20-21
3.2.2 Customer Analysis 22-28
3.2.3 Competitive Analysis 293.3 STP Analysis 29
3.3.1 Segmentation 29-30
3.3.2 Targeting 30
3.3.3 Positioning 31
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
4/114
4
Table of Content (cont)
3.4Marketing Mix Strategy 313.4.1 Product 313.4.2 Price 313.4.3 Promotion 313.4.4 Place 31
3.5Sale Forecast 32-363.6Marketing Expense 37-393.7Conclusion 40
Chapter 4 Technical Feasibility study 40
4.1 Cost of investment 41
4.1.1 Pre- operation cost 41
4.1.2 Investment Cost 41
Chapter 5 Operation 42
5.1 Production and Operational 43
5.1.1 Product Characteristics 43
5.1.2 Specification 44
5.1.3 Production and Service Process 45-46
5.1.4 Location 47
5.1.5 Facility Layout 47-49
5.1.6 Machines, Equipments, Tools 50-54
Chapter 6 Administration Cost 55
6.1 Management Analysis 56-59
6.2 Employees Cost 60
Chapter 7Financial Analysis 61
7.1 Statement of Cash flow 62-66
7.2 Balance Sheet 67-76
7.3 Income Statement 77-90
Chapter 8 Risk Management 91
8.1 External Risk 92
8.1.1 Risk of technological changing 92-93
8.1.2 Risk of competition in marketing 93
8.1.3 Risk of substitute product 93
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
5/114
5
Table of Content (cont)
8.1.4 Risk of changing customer needs 93
8.1.5 Risk of natural disasters 94
8.2 Internal Risk 94
8.2.1 Risk of human resource 94
8.2.2 Risk of machine performance 95
8.2.3 Risk of quality of the product 95
8.2.4 Risk of healthy and safety 95-96
8.2.5 Financial Risk 96-110
Chapter 9 Conclusion 111
9.1 Conclusion 112
Reference 113
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
6/114
6
Table of figure
Figure 1 Number of visitors of Chiang Rai. 10Figure 2 Number of tourist in the Chiang Rai 10
Figure 3 Market share in brand of drinking water business in Thailand 15
Figure: 4 Thailand Gross Domestic Products (GDP) 17
Figure: 5 Singha drinking water logo 19
Figure: 6 Crystal drinking water 20
Figure: 7 Chang drinking water logo 20
Figure 8 Hotels in Chiang Rai 29
Figure 9 Slung drinking water positioning 30
Figure 10 Glass bottle 42
Figure 11 MAXI cap 42
Figure 12 Slung drinking water logo 43
Figure 13 Life drinking water process chart 43
Figure 14 Aquacheme Co.,Ltd 43
Figure 15 Companies who use the service from Aquacheme. 44
Figure 16 Land Bandu, Chiang Rai 45
Figure 17 Location 45
Figure 18 Life drinking water factory overview 46
Figure 19 Office layout 46
Figure 20 Factory layout 47
Figure 21 Toilet layout 47
Figure 22 Parking lots layout 47
Figure 23 Guardhouse layout 48
Figure 24 Lockers fire extinguishers and fire equipment 5 species. 48
Figure 25 Emergency lighting 48
Figure 26 Fire alarm bells 48
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
7/114
7
Table of Table
Table 1 Activity Time 12
Table 2 Brand of water thet to transfer in Hotel of Chiang Rai 20Table 3 The number of hotel in Chaing Rai 22- 25
Table 4 The number of restaurantin Chaing Rai 25- 28
Table 5 Sale Forecast Calculation 34-35
Table 6 Total sale 35-36
Table 7 Marketing Expense 39-40
|Table 8 Investment Cost 41
Table 9 Machine, Equipment , Tools 53
Table 10 Machine (Office Equipment ) 54
Table 11 Employees Cost 60
Table 12 Statement of Cash flow 62-66
Table 13 Balance sheet 67-76
Table 14 Income Statement 77-78
Table 15 Income Statement Sixth Year-Eighth Year 79
Table 16 Sale Decrease 97-103
Total 17 Cost and Expense increase 104-109
Total 18 First Year-Fifth Year 110
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
8/114
8
Chapter 1: Introduction
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
9/114
9
1.1Background and Significance of the Project
Slung is a name of drinking water brand. Slung in Northern Thai language is mean
water dipper. Slung Company provides pure drinking water to serve to 1 to 5 stars hotel in
Chiang Rai. Slung Drinking Water has located at Ban Du, Chiang Rai.
Chiang Rai is the northernmost large city in Thailand far from Bangkok 824 km.
Chiang Rai has 18 districts. 124 Tombons. 1,751villages.The northern near Tachileik city and
have high way line with Burma. In the future that have relation bridge Thailand-Laos 4
position R3A road that Chiang Kong (R=road, 3=Thai, China, Laos, A=Asia). However,
Chiang Rai has National Park, Forest Park, Arboretum, National Reserved Forest this
attraction tourist to travel destination.
Source: 202.129.0.133/createweb/00000/00000-1011.html
http://www.chiangraifocus.com/guidebook/chiangrai/
Chiang Rai is the province that most famous about tourist attraction. So, in every year
the tourists from several countries would like to come to. Following fig4ure1 and figure2 that
show the number of visitors Chiang Rai. When the visitors come to Chiang Rai increase our
company will get profit as well follow to the number of tourists stay at hotel
Number of Citizen of Chiang RaiThe district of
Chaingrai
Number of Citizen Number of Men Number of Women
Meung Chaing Rai 223,725 107,640 116,085
Viang Chai 44,036 21,717 22,319
Chaing Khong 62,328 31,128 31,200
Teung 84,018 41,908 42,110
Phan 124,364 61,240 63,124
Pa Dad 26,362 13,165 13,197
Mae Jun 99,273 48,131 51,142
Chaing San 50,323 24,779 25,554
Mae Sai 85,266 40,703 44,563
Measuay 79,938 40,446 39,492
Viang Pa Pao 67,092 33,550 33,542
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
10/114
10
Payamengrai 41,952 21,030 20,922
ViangKan 31,254 15,885 15,369Khuntal 32,341 16,039 16,302
Mae Fah Luang 69,567 34,525 35,042
Mea Lao 30,631 15,022 15,609
Viang Chaing Rung 26,740 13,335 13,405
Doi Luang 19,008 9,647 9,361
Total 1,198,218 589,890 608,328
Figure 1 Number of visitors of Chiang Rai.
Source: http://service.nso.go.th/nso/nsopublish/districtList/S010107/th/36.htm
Number of tourist in the Chiang Rai
Figure 2 Number of tourist in the Chiang Rai
Source: 2555 .
. . 5710
From Figure 2, Year 2012 expect to have the amount of tourist will increase 12.9
percentage per year. We expect to have visitors to visited in Chaing Rai amount of 2,876,717
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
11/114
11
people. Since year 2011, Chaing Rai province have great cerebration because its have 750
anniversary and to have encourage tourism too much. Moreover, Chaingmai have the
international horticulture exposition royal flora ratchaphruek, so Chaing Rai have to receive
the benefit of tourist that to travel to Chaingmai and to travelling continue Chaing Rai.
We brimming with confidence in the future prospects of our company. Slung drinking
water has cleaner international production standard achievement. You can also be confident
about the absolute cleanliness of every drop of Slung drinking water. We promise that we will
produce drinking water to Chiang Rai people forever.
1.2Project Objectives
1. To analyze about current situation in drinking water industry.
2. To know about trouble and solution which possible when during the business
3. To calculate and estimate about profit and financing after running business
4. To know about possible and suitable of drinking water business
5. Analysis of key supply-side and demand trends
6. Detailed segmentation of international and local products
7. Historic volumes and values, company and brand market shares
8. Five year forecasts of market trends and market growth
1.3Benefits of project
1. Received knowledge about competitive and trouble of drinking water industry
2. Understand in structure of drinking water business
3. Know about technical of strategy for use or apply to belong with drinking water business
4. To be able to calculate and estimate in financial of drinking water industry
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
12/114
12
1.4 Activities/Time frames
NO. Time Activity
1 17 Nov 13 Topic submission
2 19-24 Nov 2013 Discussion about information of firm
3 week 3 Planning to process organization
4 week 4 Separate duty of each person
5 week 5 Find out of information of our business
6 week 6 Start working
7 week 7 Promote product
8 week 8 Collect information
9 week 9 Prepare for project presentation
Table 1 Activity Time
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
13/114
13
Chapter 2: Industry Profile
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
14/114
14
2.1 Nature of Industry
Water is essential to human life. In the past, water is easy to find in river or lagoon,
but in present to have the growth of social, advances of technology, and environment changes.
Its make the result in river or lagoon is not clean. United States Environmental Protection
Agency said that 80% of all diseases to caused from impure drinking water and more toxic
contamination; which make to easy illness of human.
Water makes up 70-75% of the body weight of the average human being. People can
survive about 4 weeks by without food but no longer than 3 days by without water. Water has
many different functions inside the body. It forms the bulk of blood and tissue fluid and it s
essential for transporting nutrients, hormones and waste products around the body. Water
helps to control the delicate balances within the cells.
Nowadays the drinking water company has a high market value approximately 4000
million baht per year and to have investors combination both small and large around 2000
person. Drinking water is tending to grow more several factors. For example the degradation
of natural water resources which follow to development of economic and industrial. In
addition, the amount of population that more increased in everyone, so its make that people
want to use more water.
Source:
http://boc.dip.go.th/index.php?option=com_content&view=article&id=386&Itemid=48
2.2 Situation of Industry
Drinking waters are industry influence business in Thailand, It is the main factor of
daily life especially in urban society. The behaviors of Thai peoples have change from past.
Now a day Thai people need quality product and concern about health that are the reason of
business to growth quickly.
Drinking water continued to see healthy growth in 2011, boosted by the ongoing
marketing activities for leading brands like Crystal from Serm Suk PCL, Namthip from Thai
Namthip Co Ltd, Nestl Pure Life from Nestl (Thailand) Ltd, Singha from Boon Rawd
Brewery Co Ltd, and Chang from Thai Beverage PCL. Still bottled water continued to
dominate more than 90% of both total value and volume sales. The rest was accounted for by
http://boc.dip.go.th/index.php?option=com_content&view=article&id=386&Itemid=48http://boc.dip.go.th/index.php?option=com_content&view=article&id=386&Itemid=48 -
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
15/114
15
functional bottled water and carbonated bottled water with 8% and 1% value shares,
respectively.
Source:http://www.euromonitor.com/bottled-water-in-thailand/report
There are many drinking water company in Thailand, This business have a high
industry. There are 8 brands such as Sigha, Nestle pure life, Crystal, Chang, Siam, Nam Tip,
Neptune and Sprinkle.
Source:http://pantavanij.blogspot.com/2010/04/13.html
Market share of drinking water Business in Thailand
Figure 3 Market share in brand of drinking water business in Thailand
Salung drinking water distributes to all offices in Chiang rai. Package of Slung
drinking waters are gallon and contain 18.9 liter, which convenient for office because the
office use cooler is mainly. Life drinking water tried to make a difference to compete with
other company. Our company focuses to be clean drinking water for good health of customer.
Our drinking water pass to percolate and the package pass through several step of cleaning for
receive quality product
2.3 Product/Service
Slung drinking water provides drinking water and serves to customers. The main
target group is the 1-5 star hotels in Chiang Rai. The most important issue which Slung drink
always concern is quality. Our company chooses glass bottles instead of plastic bottles
because of the remarkable feature of its clear and it wont cause odor or taste of the water
changes will not change shape when its transporting and handling goods. And it can maintain
the product for long life more than it can be recycled. Its stable when its stack and save ourmoney.
19%
10%
10%
61%
Market share of drinking water Business in
Thailand
Sigha Nestle pure life Crystal Other
http://www/http://www/http://www/http://pantavanij/http://pantavanij/http://pantavanij/http://pantavanij/http://www/ -
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
16/114
16
The safety accessibility of drinking water is major concerns throughout the world.
NSF international accredited by the American National Standards Institute (ANSI). Slung
drink is NSF international standard drinking water. And we got the certificate from Thai Food
and Drug Administration (FDA, 2009).
Our product contains 500ml of water. We use water from groundwater sources. Our
product is processed by RO and UV and the price is 60 Baht per 24 bottles. We sell only the
pack of 24 bottles Promotion.
Slung drinking water satisfies customer by deliver the product punctually. The main
target is group is the 1-5 star hotels in Chiang Rai. Our product can shipping directly to
customer for convenience. Customer can comment about product and service about our
company.
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
17/114
17
Chapter 3:Market Feasibility study
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
18/114
18
3.1 General Environment Analysis
3.1.1 Political
The Government has set a policy to encourage both Thais and foreigners to travel
more in Thailand in order to double the countrys tourism earnings in the next five years.Deputy Prime Minister and Minister of Tourism and Sports, Mr. Chumpol Silapa-archa, said
that a target had been set to increase Thailands tourism income to more than one trillion baht
by 2016, compared to 590 billion earned in 2010. According to Mr. Sombat, during the past
few years, around 14.5-16 million tourists visited Thailand annually. The Ministry of Tourism
and Sports expects that the number of international visitors will increase to 30 million in the
next five years (Governments Policy on Tourism, 2010).
From Governments policy on tourism,The Ministry of Tourism and Sports expects
that the number of international visitors will increase to 30 million in the next five yearswill
result in a lot of tourists come to Chiang Rai.If a growing number of tourists increase, thehotels access number will increase as well. Our business will be getting more profitable in
next 5 years too.
3.1.2 Economic
Figure: 4 Thailand Gross Domestic Products (GDP)
Refer to Gross Domestic Product of Thailand since 2002-2012; it demonstrates that
Thai economic has grown in further; furthermore Gross Provincial Product (GPP) of Chiang
Rai also increases every year as well. The Gross Domestic Product (GDP) in Thailand was
worth 345.65 billion US dollars in 2011, according to a report published by the World Bank.
The GDP value of Thailand is roughly equivalent to 0.56 percent of the world economy. GDP
in Thailand is reported by the World Bank Group. Historically, from 1960 until 2011,
Thailand GDP averaged 85.5 USD Billion reaching an all time high of 345.7 USD Billion in
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
19/114
19
December of 2011 and a record low of 2.8 USD Billion in December of 1960. The gross
domestic product (GDP) measures of national income and output for a given countrys
economy. The gross domestic product (GDP) is equal to the total expenditures for all final
goods and services produced within the country in a stipulated period of time. This page
includes a chart with historical data for Thailand GDP (Trading economics, 2012).
3.1.3 Social
Chiang Rai is the center travel of northern part of Thailand that attractive to people
who want to travel in attraction place in Chiang Rai because Chiang Rai is peace town which
appropriate to tourist want to relax and rest.There have many green natural, cultural attract
place. From Association of Tourism and Sports in Chaing Rai have organized festival for
attraction tourist every year as flower festival. In addition Chiang Rai has boundaries near
Myanmar, Laos and China; tourist can easy to travel around near bounder such as tourist can
shop products in cheap price. So, this is the reason that why tourist want to travel in Chiang
Rai.
3.1.4 Environment
The current environmental problems considered top priorities issues that we need to
pay attention because natural resources are used for the purpose in daily activities of humans;
it rapidly declines natural resource. We can see the changes of the environment and natural
variability explicitly. Slung Drinking water is an organization that recognizes the need for
environmental protection throughout and dedicated to operate within the framework of
environmental policy, we have developed the system. Combination with the environment is
substantial to reflect the companys position in the environment and to set an example to other
industries in terms of environmental management. The process has been established for the
protection of both water and air pollution, such as wastewater treatment (Sermsuk ,2012).
For the environmental management as well as research and development packaging
them a glass bottle instead of plastic bottles because, feature is clear The glass will not cause
smell or taste of the water like some kinds of plastic packaging and glass containers will not
change shape when force during transportation. Also can maintain the quality of the product
can also to used for glass recycling have on the stack is stable and easy to transport ( Pirun
,2009).
3.1.5 Technology
Nowadays, Technology is more importance for daily life of everyone; we are
becoming to the globalization period. Internet is provided for people and Internet is vary
necessary to everyone must use for learning new technology, connect or contact people for
increase new relationship, listening to music, play games, or used for research information
educational academic entertainment for relax or can get new information from many ways.
For example, tour company have provide website to offer information to customer which
make customer easy to find about package tour such as Chiang Rai tour company have to set
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
20/114
20
website for customer can look about information of them company always time; the website is
name ashttp://www.chiangrai-tour.com/. Customer can plan trip before decision to buy trip.
3.2 Competition Analysis
3.2.1 Competitors Analysis
Slung Drinking water has serve to 1 to 5 stars hotel in Chaing Rai. The business that
produce drinking water have many business which have same objective as to send drinking
water in hotel, but we will focus on the competition company have 3 companies who serve
pure drinking water in hotel around Chiang Rai have as; Singha Drinking water, Chang
Drinking water and Crystal Drinking water below as ;
Table 2 Brand of water thet to transfer in Hotel of Chiang Rai
Figure:5 Singha drinking water logo
Singha Corporation Co., Ltd. is a subsidiary of Boon Rawd Brewery Co., Ltd., the
first and largest Brewery of Thailand. The company was incorporated to oversee the beverage
business of Boon Rawd Brewery Co., Ltd. and is responsible for the operation and marketing
of beer, soda water, drinking water and various energy drinks and beverage producers. At
present,Boon Rawd Brewery is the owner of Singha,Leo , B ing,Purra,Pun
Dee,andMasita trademarks. They provide both PETE and glass bottles. For glass bottles
to sell 60 baht/pack per1 pack has 24 bottles.
Source: http://www.boonrawd.co.th/brb/en/01_learning.html
Brands Price Unit Price/Unit
Singha drinking water 60 24 2.50
Crystal drinking water 60 24 2.50
Chang drinking water 60 24 2.50
http://www/http://www/http://www/http://www/ -
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
21/114
21
Figure:6 Crystal drinking water
Crystal is a popular brand in Thailand. They are the fist brand to get the standard of
NSF (The National Sanitation Foundation) in USA. Crystal water is under the slogan Kid Ja
Duem Nam Duem Cryatal(If you think drinking the water you should select Crystal). They
provide both PETE and glass bottles. For glass bottles to sell 60 baht per pack, 1 pack has 24
bottles.
Source: http://www.crystal.co.th/index.html
Figure:7 Chang drinking water logo
Thai Drink Co., Ltd plans to achieve the sales target for the second half this year at 20
litres of Chang drinking water, distributed via nationwide channels. With regards to current
drinking water market, Mr Marut is of the view that some players have aggressively launched
marketing campaigns to snatch the market of drinking water worth 18,000 million.
Meanwhile, the bottled water market has exhibited a steady growth in line with the rising
consumption of bottled water over the past five years. Thai Drinks managing director
believes that there is still room for the company growth, which will be driven by its extensive
range of product portfolio to meet different consumer need. They provide both PETE and
glass bottles. For glass bottles to sell 60 baht per pack, 1 pack has 24 bottles.
Source:http://www.thaibev.com/en08/detailnews.aspx?ngID=338&tngID=1
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
22/114
22
3.2.2 Customer Analysis
The target group that Slung Drinking water want to serve as 1- 5 star in hotel and
restaurant in Chiang Rai . Our company is dependent on hotels to distribute our products
which we act as suppliers business to business (B2B), which are not our direct customers and
we need to have enough products to meet demand of thehotels.All hotels have room amount 4,348 rooms in 1-5 stars hotels in Chiang Rai. Each
room has to serve drinking water at lease 2 bottle per day and amount 114 restaurants. We can
guarantee that consumers will get drinking water to more quality and clean always and we
provide drinking water to follow right production standard from the national Sanitation
Foundation; which to the opportunity of our company to distribute our product.
HOTEL IN CHIANG RAI
No
.
Name Location Season Star Room
sHigh Low
1. Anantara Golden Triangle Resort & Spa Chiang Saen Nov-Fab Mar-Oct 5 77
2. Katiliya Mountain Resort & Spa Mae Chan Nov-Fab Mar-Oct 5 53
3. Le Meridian Chiang Rai Resort & Spa Muang Nov-Fab Mar-Oct 5 159
Total 289
No
.
Name Location Season Star Room
sHigh Low
1. Phowadol Resort & Spa Muang Nov-Fab Mar-Oct 4 154
2. Golden Pine Resort & Spa Muang Nov-Fab Mar-Oct 4 80
3. Laluna Hotel Resort & Spa Muang Nov-Fab Mar-Oct 4 79
4. Teak Garden Spa Resort Muang Nov-Fab Mar-Oct 4 72
5. The Mantrini Boutique Resort Muang Nov-Fab Mar-Oct 4 63
6. Poonyamantra Resort Mae Chan Nov-Fab Mar-Oct 4 65
7. Imperial River House Resort Muang Nov-Fab Mar-Oct 4 368. Imperial Golden Triangle Resort Chiean Sean Nov-Fab Mar-Oct 4 73
9. Phu Chaisai Mountain Resort & Spa Mae Chan Nov-Fab Mar-Oct 4 50
10. Dusit Island Resort Chiang Rai Muang Nov-Fab Mar-Oct 4 271
11. Wiang Inn Hotel Muang Nov-Fab Mar-Oct 4 260
12. The Legend Chiang Rai Boutique River
Resort & Spa
Muang Nov-Fab Mar-Oct 4 78
13. Suanthip Vana Resort Mae Suay Nov-Fab Mar-Oct 4 30
14. Homestay Chiang Rai Muang Nov-Fab Mar-Oct 4 6
15. Rasa Boutique Hotel Chiang Rai Muang Nov-Fab Mar-Oct 4 30Total 1,347
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
23/114
23
No
.
Name Location Season Star Room
sHigh Low
1. Greater Mekong Lodge Chiang Saen Nov-Fab Mar-Oct 3.5 56
2. Doi Tung Lodge Mae Fah
Luang
Nov-Fab Mar-Oct 3.5 47
3. Rimkok Resort Hotel Muang Nov-Fab Mar-Oct 3.5 256
Total 359
No
.
Name Location Season Star Rooms
High Low
1. Akha River House Muang Nov-Fab Mar-Oct 3 5
2. Wangcome Hotel Chiang Rai Muang Nov-Fab Mar-Oct 3 215
3. Huai Khum Village Resort Muang Nov-Fab Mar-Oct 3 80
4. Baan Suan River View Resort Muang Nov-Fab Mar-Oct 3 31
5. Inn Come Hotel Muang Nov-Fab Mar-Oct 3 110
6. Plam Garden Hotel Chiang Rai Muang Nov-Fab Mar-Oct 3 33
7. Baan Nattawadee Muang Nov-Fab Mar-Oct 3 15
8. Ban Khun Yom Hotel Muang Nov-Fab Mar-Oct 3 40
9. Mohnfahsai Home Resort Muang Nov-Fab Mar-Oct 3 19
10. Thammachart Resort Muang Nov-Fab Mar-Oct 3 50
11. Rai Saeng Arun Muang Nov-Fab Mar-Oct 3 14
12. Santico Resort Chiang Saen Nov-Fab Mar-Oct 3 20
13. Bura Resort Chiang Rai Muang Nov-Fab Mar-Oct 3 8
14. Ban Chomna Resort Muang Nov-Fab Mar-Oct 3 15
15. Maesalong Villa Muang Nov-Fab Mar-Oct 3 74
16. Wanasom Wellness & Asthetic Resort Mar Salong Nov-Fab Mar-Oct 3 60
17. Serene at Chiang Rai Hotel Muang Nov-Fab Mar-Oct 3 52
18. Siam Triangle Hotel Chiang Saen Nov-Fab Mar-Oct 3 52
19. De River Boutique Resort Chiang Saen Nov-Fab Mar-Oct 3 24
20. Prai Nurn Resort Chiang Saen Nov-Fab Mar-Oct 3 6
21. Saenphu Place Hotel Muang Nov-Fab Mar-Oct 3 98
22. Luck Swan Resort & Spa Muang Nov-Fab Mar-Oct 3 36
23. Monmaen Resort & Spa Muang Nov-Fab Mar-Oct 3 13
24. Nak Nakara Hotel Muang Nov-Fab Mar-Oct 3 25
25. Chayadel Resort Muang Nov-Fab Mar-Oct 3 14
26. Baan Soontree Resort Muang Nov-Fab Mar-Oct 3 20
27. Kong Garden View Resort Muang Nov-Fab Mar-Oct 3 32
28. Pimann Inn Hotel Muang Nov-Fab Mar-Oct 3 20
29. Golden Land Hotel Muang Nov-Fab Mar-Oct 3 79
30. La Vue En Rose Muang Nov-Fab Mar-Oct 3 28
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
24/114
24
31. Chiang Rai Grand Room Hotel Muang Nov-Fab Mar-Oct 3 70
32. Koko Hut Resort Muang Nov-Fab Mar-Oct 3 8
33. Baan Lanna Hotel Muang Nov-Fab Mar-Oct 3 41
34. Art Ann Hotel Muang Nov-Fab Mar-Oct 3 31
35. Paek Inn Chiang Rai Muang Nov-Fab Mar-Oct 3 14536. At Chiang Rai Resort Muang Nov-Fab Mar-Oct 3 20
37. Ammarin Resort Muang Nov-Fab Mar-Oct 3 20
38. Baan Siam Hotel Muang Nov-Fab Mar-Oct 3 59
Tota
l
1,682
No
.
Name Location Season Star Rooms
High Low
1. Nim See Seang Chiang Rai Muang Nov-Fab Mar-Oct 2.5 792. Chiang Sean River Hill Hotel Chiang Saen Nov-Fab Mar-Oct 2.5 60
Tota
l
139
No. Name Location Season Star Rooms
High Low
1. Khum Chao Resort Mae Sai Nov-Fab Mar-Oct 2 12
2. YMCA International Hotel Chiang Rai Muang Nov-Fab Mar-Oct 2 503. Red Rose Hotel Chiang Rai Muang Nov-Fab Mar-Oct 2 50
4. Pongprabath Resort Muang Nov-Fab Mar-Oct 2 9
5. M Residence & Hotel Muang Nov-Fab Mar-Oct 2 68
6. Diamon Park Inn Chiang Rai & Resort Muang Nov-Fab Mar-Oct 2 78
7. Tree House Residence Muang Nov-Fab Mar-Oct 2 20
8. Baan Bua Guest House Muang Nov-Fab Mar-Oct 2 17
9. Ruean Inn Hotel Muang Nov-Fab Mar-Oct 2 50
10. Wannarit Resident Muang Nov-Fab Mar-Oct 2 5
11. Chote Home Gallery Muang Nov-Fab Mar-Oct 2 16
12. Baan Bua Home stay Muang Nov-Fab Mar-Oct 2 10
13. Ban Lom Jen Home stay Muang Nov-Fab Mar-Oct 2 9
14. Nice Inn Town Residence Muang Nov-Fab Mar-Oct 2 5
15. Golden Triangle Inn Muang Nov-Fab Mar-Oct 2 20
16. Sirin Place Boutique Apartment Muang Nov-Fab Mar-Oct 2 30
17. B2 Night Bazaar Hotel Muang Nov-Fab Mar-Oct 2 30
18. B2 Chiang Rai Hotel Muang Nov-Fab Mar-Oct 2 30
19. The Room Resident Chiang Rai Muang Nov-Fab Mar-Oct 2 20
20. Sukthavorn Residence Muang Nov-Fab Mar-Oct 2 13
Total 512
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
25/114
25
No
.
Name Location Season Star Rooms
High Low
1. Nantathong Place Muang Nov-Fab Mar-Oct 1 20
Table 3 The number of hotel
Total: 4,348 Rooms
There are 4,348 rooms in 1-5 stars hotels in Chiang Rai. In the hotel provide at least 2
bottles per room. The consumers have drinking water to quality also. This is the opportunity
of our company to distribute our product. We provide pure drinking water with the standard
and certificated form Food and Drug Administration.
RESTAURANT IN CHIANG RAI PROVINCE
Location: Muang Chiang Rai
No. Name
1. Pong Chaingrai Radnha
2. look chin pla sod dee
3. Ha Yak look chin pla100%
4. Nayok Yuyen
5. Muang Tong
6. Yunnan
7. Saharoad
8. Hlee Ocha
9. Clock tower
10. Imperial Golden Triangle Resort
11. Rawin
12. Udummit Coffee
13. Tee Noi
14. Ice-cream Salim -Tum Tim Krop
15. MK - Sukki
20. Khawtum Nayok
21. Khawtum Fha Sang
22. Khawtom Meena
23. J. Jarern Chai
24. China Town
http://www.moohin.com/food/033/food009.shtmlhttp://www.moohin.com/food/033/food010.shtmlhttp://www.moohin.com/food/033/food010.shtmlhttp://www.moohin.com/food/033/food011.shtmlhttp://www.moohin.com/food/033/food011.shtmlhttp://www.moohin.com/food/033/food011.shtmlhttp://www.moohin.com/food/033/food010.shtmlhttp://www.moohin.com/food/033/food009.shtml -
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
26/114
26
25. Kuay TeawNam-ngeaw
26. Kuay Teaw Nam-ngeaw Nongbua
27. Kuay Teaw Sri boon ruang
28. Nay Hung
30. Nuea wua rod yeam
31. Ba-Mhee Chaing rai
32. Vegetarian Hall53
33. Kuay Teaw Ruea Yok loa
34. Kong Nae
35. Jintanas Chicken
36. Kar Moo Rabemg Tong
37. KruaAromdee
38. Kum Jaw Nang
39. K Luie Hot-Pot
40. Jae Dang
41. Chum Cha
42. Chaleng Barn
43. Fishing Park chan maung
44. Chaing Rai In
45. C&C
46. Shum Ka Nom Jean Bubfea.
47. Toob Sing
48. Nakronprathom
49. Nakronprathom2
50. .Ban Kanum Jean
51. Banwiream
52. Peasa Hot-Pot
53. Pan Oha
54. Phat Buree
55. Fha Sai Hot-Pot
60. Mae Pim
61. Yungtong
62. Rhat Buree
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
27/114
27
63. Rim Nam
64. Lap Pla Ha Yaek
65. Lotuse Bakery House
66. Dusit Island Resort Chiang Rai
67. Weang Tan
68. Sri Trung
69. Nung Bua
70. Eak Ocha
71. Krua Season Nam Krun
72. The Golden Tringel
73. Restaurant Lotus Chiang Rai
74. Aea Restaurant
75. Khaw Soi Poor Jai
76. Khaw Soi Essalam
77. Tong Tung
78. Tork Tong
79. Phoo Thai Kai Yang
80. Rean Mai
81. Laddawan Lu mangda
82. Lap Panang
83. Lung Suk Carabow
84. Weang In Cafe
85. Sbangha Khan Tok
86. Slung Khum
87. Lu Lum
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
28/114
28
Location: Mae Sai
No. Name
1. Jing lai shun
2. New Somboon
3. Khee Pochana4. Rabeang Keaw
5. Rim Nam
6. Klua Pian Thong
7. Pa Nang
8. Mae ouy keaw
Location: Chiang RaiMae Sai
No. Name
1. Doi Aob Garden
2. Song Nutrition
3. Souvenir and Canteen
4. Sakina
5. Laos Sookie style
Location: Mae Chan District
No. Name
1. Kun Tum Bistro
2. Rim Chan Inn
3. Anong Lanna noodle style
4. Chan Kum house
Location: Doi Mae Salong, Mae Fah Luang District
No. Name
1. Mae Salong coffee conner
2. Sakoora
3. Aim Nutrition
4. Wang Phu Tan
Location: Chiang Saen Distrist
No. Name
1. Kung Tan 5 Chiang
2. Chiang Saen Riverside Restaurant
3. Thi Kitchen
4. Rabiang Khong
5. Rim Khong
6. 3 Ying
Table 4 The number of restaurant of Chaing Rai
Total:114 restaurants
http://www.moohin.com/food/033/food097.shtmlhttp://www.moohin.com/food/033/food103.shtmlhttp://www.moohin.com/food/033/food104.shtmlhttp://www.moohin.com/food/033/food104.shtmlhttp://www.moohin.com/food/033/food103.shtmlhttp://www.moohin.com/food/033/food097.shtml -
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
29/114
29
3.2.3Competitive AnalysisDrinking water industry has high competition because it easy to produce the important
problem is a lot of competition in the same product almost of their drinking water suitable
with household and peoples. This is a reason why our industry focuses in hotel. Characteristic
of glass bottles water have three important competitions are Singha, Chang and Crystal. We
believe that we will focus at the low price than competitor. And for the result we will got
much of market share by contact with hotel. Slung drinking water has National Sanitation
Foundation (NSF) and Corporate Social Responsibility (CSR), so we ensure hotels will
choose Slung drinking water.
3.3 STP Analysis
3.3.1 Segmentation
Life Drink segment customers which are hotels in Chiang Rai by using demographical
factor. The stars of each hotel demonstrate the reputation. The customer of Life Drink water is
every one. Starting with child, youth to old age as well. Future, water is to be a great tasting,
natural, low calorie.
Major Factors in Considering Hotel Standard
The major factors taken into consideration in the assessment and certification of an individualhotel and resort property are:
Physical aspectsSuch as location and surrounding
Construction aspectThe physical structure of the hotel, system in place, security system, etc.
Facilities for hotel guests
Taking into consideration guests who are resident at the hotel as well as guests who
frequent the hotel and use services provided.
Quality of service and the ability of maintain qualityIncludes such criteria as personality, the quality of services, cleanliness, hygiene, etc.
The maintenance of the hotel and the above mentioned facilitiesThe Thai hotel standard covers three aspects
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
30/114
30
The standard of construction and facilities The standard of maintenance The standard of services
According to Tourism Authority of Thailand, this classified hotel in Chiang Rai into 7 classes.
We also use this assessment criterion to segment our customer too.
Figure 8 Hotels in Chiang Rai
3.3.2 Targeting
After we got 7 segmentations of our customer, we found the highest number of hotel is
in 3 to 5 star hotel. Therefore, we focus on this kind of hotel because we strongly believe this
all those 3 to 5 star hotel have high purchasing power as well.
1 star 2 star 2.5 star 3 star 3.5 star 4 star 5 star
1
20
2
38
3
15
3
Number Of Hotel In Chiang Rai
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
31/114
31
3.3.3 Positioning
CSR
No NSF NSF
No CSR
Figure 9 Slung drinking water positioning
We have to make the decision to choose the position of the product in for the
investment and the image of the product that the company needs. Slung drinking water set
the positioning following figure 8. We provide drinking water in low price but high quality.
We ensure that our company has high quality because the company has been certified by
NSF.
3.4 Marketing Mix Strategy
3.4.1 Product
- Our product contains 500 ml of water. We use water from groundwater sources. Our
product is processed by RO and UV. Moreover, product is also including with Ozone .
- Our product is contain in crystal plastic bottle and crystal water
- The label is including with brand, capacity, manufacture, point and registration.
3.4.2 Price- The price is 60 Bath per 24 bottles. We sell only the pack of 24 bottles
3.4.3 Promotion- Free delivery
3.4.3 Place
- We focus on all Hotels and restaurant in Chiang Rai to main customer because they need to
use water every day for their customer. Moreover, to sell in only Chiang Rai it also reduces
cost and support the business together for entrepreneur in Chiang Rai
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
32/114
32
3.5 Sale ForecastFor the based year of sale forecast, we found the number of 1-5 stars hotel rooms in
Chiang Rai which are 4,348 rooms. We try to catch 20% of all room which is 869.6 rooms.
Each room provides 2 bottles of water in mini bar. Our sale is 1,739.2 bottles a day in
based sale. There are 24 bottles in one pack. So, we have to provide 72.4 packs per one day.For a month selling, there are 2173.9 packs which are produced. After our firm run the
business and be able to expand number of customer, we found that the sale is going
to increase 25% from the same month of last year. Tourism seasonal is also important
for our business. The sale of high season (November to February) is increased 50%
from based year follow number of tourist and hotel reservation.
Sale forecasting in hotels
Hotel rooms 4348
Forecasted 20% 869.6
Provides 3 bottles/room 2608.8
24 bottles/pack 108.7
Sale forecast/month 3261
Sale increase 45 percent in high season 4728.45
For the based year of sale forecast, we found the number of 1-5 stars hotel rooms in
Chiang Rai which are 4,348 rooms. We try to catch 20% of all room which is 869.6 rooms.
Each room provides 2 bottles of water in mini bar. Our sale is 1,739.2 bottles a day in based
sale. There are 24 bottles in one pack. So, we have to provide 72.4 packs per one day. For a
month selling, there are 2173.9 packs which are produced. After our firm run the business and
be able to expand number of customer, we found that the sale is going to increase 25% from
the same month of last year. Tourism seasonal is also important for our business. The sale of
high season (November to February) is increased 50% from based year follow number of
tourist and hotel reservation. We also forecast restaurants at Chiang Rai too. In Chiang Rai
have 114 restaurants. We try to sell 30% of all restaurants in Chiang Rai. The sale is going to
increase 10% for every year. At high season we can increase sale more than other season.
Than the sale of high season is 50% every year at high season.
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
33/114
33
Sale for casting in restaurants
Restaurant 114
Forecasted 30% 34.2
Provides 16 bottle/Restaurant 547.2
24 bottle /pack 22.8
Sale forecast/month 684
Sale increase 50% in high season 1026
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
34/114
34
Table: Sale Forecast Calculation
Year 1
Product Price Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Unit Sale 60 4,286 4,286 2,857 2,857 2,857 2,857 2,857 2,857 2,857 2,857 4,286 4,286 40,000
Year 2
Product Price Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Unit Sale 60 5,135 5,135 3,469 3,469 3,469 3,469 3,469 3,469 3,469 3,469 5,135 5,135 48,292
Year 3
Product Price Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Unit Sale 60 5,922 5,922 4,561 4,561 4,561 4,561 4,561 4,561 4,561 4,561 5,922 5,922 60,176
Year 4
Product Price Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Unit Sale 60 7,988 7,988 7,277 7,277 7,277 7,277 7,277 7,277 7,277 7,277 7,988 7,988 90,168
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
35/114
35
Year 5
Product Price Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Unit Sale 60 9,461 9,461 6,307 6,307 6,307 6,307 6,307 6,307 6,307 6,307 9,461 9,461 88,300
Table 5 Sale Forecast Calculation
Total sale
Year 1
Product Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Revenue 257,160 257,160 171,420 171,420 171,420 171,420 171,420 171,420 171,420 171,420 257,160 257,160 2,400,000
Year 2
Product Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Revenue 308,100 308,100 208,140 208,140 208,140 208,140 208,140 208,140 208,140 208,140 308,100 308,100 2,897,520
Year 3
Product Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Revenue 355,320 355,320 273,660 273,660 273,660 273,660 273,660 273,660 273,660 273,660 355,320 355,320 3,610,560
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
36/114
36
Year 4
Product Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Revenue 479,280 479,280 436,620 436,620 436,620 436,620 436,620 436,620 436,620 436,620 479,280 479,280 5,410,080
Year 5
Table 6 Total sale
Product Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Revenue 567,660 567,660 378,420 378,420 378,420 378,420 378,420 378,420 378,420 378,420 567,660 567,660 5,298,000
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
37/114
37
3.6 Marketing ExpenseFirst year we invite F&B manager of 82 hotels to grand opening atSaunTung and
Khomin Chiang Rai for promote people and tourist in Chiang Rai. The grand opening we
select Ton Aor Studio to set up the event. Ton Aor Studio will provide and design the entire
event. The cost is 200,000 Bath.Source: Ton Aor Studio
We create web-site to show the overview of Slung drinking water and more
information about company. The topic in web-site can divide into 5 topics.
1. Overview of company 2. Contact 3.Product and process 4.CSR and 5.Online shop
The web hosting is www.hostinglotus.com.
Source:http://www.hostinglotus.com/
We create brochure for 82 hotels in Chiang Rai and provide every years on January,
April, and October. We put the brochure at lobby of 82 hotels in Chiang RaiThe content in
brochure is show the map and attractions in Chiang Rai.Source: Muang Rung printing
We create bin that screen our logo to provide at tourist attraction in Chiang Rai such
as Chiang Rai walking street, Doi Tung, Phu Che Fah and Night bazaar for tourist and people
to throw the garbage. And to show the brand to know around Chiang Rai.
Source:http://www.weloveshopping.com/template/a21/showproduct1.php?pid=17464355&sh
opid=234522&showm=&groupproduct=1212301
In year 3-5, we support scholarship for Suksasongkraw Maechan School for students
who have good academic 10 people on Children's Day and support for team Chiang Rai
united
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
38/114
38
Marketing expense
Year 2 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Brochure 5,400 - - 5,400 - - - - - 5,400 - - 16,200
Trash 8,000 - - - - - - - - - - - 8,000
Web-site 289 - - - - - - - - - - - 289
Total 13,689 - - 5,400 - - - - - 5,400 - - 24,489
Year 3 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Brochure 5,400 - - 5,400 - - - - - 5,400 - - 16,200
Trash - - - - - - - - - - - - -
Web-site 289 - - - - - - - - - - - 289scholarship 20,000 - - - - - - - - - - - 20,000
support CRUTD 20,000 - - - - - - - - - - - 20,000
Total 45,689 - - 5,400 - - - - - 5,400 - - 56,489
Year 1 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Brochure 5,400 - - 5,400 - - - - - 5,400 - - 16,200
Trash 40,000 - - - - - - - - - - - 150,000
Web-site 289 - - - - - - - - - - - 289
Grand opening 150,000 - - - - - - - - - - - 150,000
Total 195,689 - - 5,400 - - - - - 5,400 - - 316,489
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
39/114
39
Year 4 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Brochure 5,400 - - 5,400 - - - - - 5,400 - - 16,200
Trash - - - - - - - - - - - - -
Web-site 289 - - - - - - - - - - - 289
scholarship 20,000 - - - - - - - - - - - 20,000
support CRUTD 20,000 - - - - - - - - - - - 20,000
Total 45,689 - - 5,400 - - - - - 5,400 - - 56,489
Year 5 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Brochure 5,400 - - 5,400 - - - - - 5,400 - - 16,200
Trash - - - - - - - - - - - - -
Web-site 289 - - - - - - - - - - - 289
scholarship 20,000 - - - - - - - - - - - 20,000
support CRUTD 20,000 - - - - - - - - - - - 20,000
Total 45,689 - - 5,400 - - - - - 5,400 - - 56,489
Table 7 Marketing Expense
3.7 ConclusionLife provides water drink to 1-5 star hotels in Chiang Rai. We forecast sale drink in 5 years. Income of Life drink will increase everyyear. The base unit we need to sell in every month is 2,713 bottles. So, we have to provide 72.40 packs per one day. Our product is processed by
RO and UV. Singha drinks and Crystal are the Slung competitive. We sell 60 baht per pack. One pack has 24 bottles. We set the promotion by
not chart about delivery. November-February is high season and March-October is low season of our product. We forecast our sale about
2,900,000 baht per year
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
40/114
40
Chapter 4:
Technical Feasibility Study
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
41/114
41
4.1 Cost of investment
4.1.1 Pre- operation cost
Slung Drinking water hired Aquacheme Co.Ltd to install operating produce and
process of slung drinking water. The reason that we select Aquacheme Co.Ltd because they
have a broad knowledge of applied science, such as chemical engineering, mechanical
engineering, electrical engineering and electronics. Aquacheme Co.Ltd has 34 year history of
providing the highest quality service standards and to offer the most competitive price in the
industry. All units are factory tested to ensure the quality of all products. The pre- operation
cost has amount 229,000 Baht.
Souce: http://www.aquacheme.com/
4.2.2 Investment Cost
Investment Cost Cost
Land 1,700,000
Equipment in factory 229,000
Building 2,408,610
Machine (Office Equipment ) 147,750
Supply 145,640
Car 798,000
Total 5,429,000
Table 8 Investment Cost
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
42/114
42
Chapter 5: Operation
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
43/114
43
5.1 Production and Operational
5.1.1 Product Characteristics
Figure 10 Glass bottle
Slung drinking water provides the water into the glass bottle. Size of glass bottle is
500ml. Glass bottles can be reused several times and high durability. The glass bottle can help
reduce the amount of garbage on the planet. We use high quality of glass and we focus on
good clean. We purchase glass bottle from Tan Soon Huat and Wellgrow Glass Industries.
More than 30 years experience in manufacturing glass bottles up to 1.3 million barrels per day
(120 tons), or 39 million bottles per month with a unique technique. Slung serviced from Tan
Soon Huat and Wellgrow Glass Industries both of purchase glass bottles and printing on glassbottles.
Source:http://www.xn--12cb8cydc8m6b.net/
Figure11 MAXI cap
Maxi cap.Under a rubber cap, liner are edge leakage. Easy to open, easy to drink Price
per Case (Case contains 9,500 pieces). We purchase from K. Panit Company.
Source:http://www.lek11.com/?lang=th
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
44/114
44
5.1.2 Specification
Figure12 Slung drinking water logo
Outstanding design, outstanding quality by Slung drinking water is the slogan of our
product. Highlight of the drinking water is a unique design to make it easier to remember.
Slung drinking water standard by NSF / ANSI, this is regulated by NSF International. Which
guarantee that our drinking water is clean and pure 100%.
5.1.3 Production and Service Process
Production
Figure13 Life drinking water process chart
Slung choose from Aquacheme Co.,Ltd. installed a water filtration system for drinking
water. Aquacheme Co., Ltd. Introduced to produce integrated drinking water and fill drinking
water into bottles.
Figure14 Aquacheme Co.,Ltd
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
45/114
45
Why we select Aquacheme?
1. Aquacheme Co.,Ltd have over 34 years experience in Water Treatment Industry.
2. Hundreds of commercial/industrial systems in operation.
3. Aquacheme Co.,Ltd products are being used in over 100 countries worldwide.
4. From packaged systems to custom engineered systems.
5. Aquacheme Co.,Ltd have the expertise to provide systems for drinking water, boiler feed
water, seawater desalination, ultrapure water, water reuse and other applications.
6. Aquacheme Co.,Ltd offer the most competitive price in the industry. All units are factory
tested to insure the quality of all products.
7. Aquacheme Co.,Ltd customers include major national and international companies in every
field of application.
8. Aquacheme Co.,Ltd stock more components for all sizes of RO systems than any other
company.
Aquacheme products are used by companies all over the country across many
industries. Listed below are just a few of those companies:
Figure15Companies who use the service from Aquacheme.
Source: http://www.aquacheme.com/
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
46/114
46
5.1.4 Location
Figure16 Land Bandu, Chiang Rai
Figure17 Location
This land is located at Bandu, Chiang Rai Thailand. Rates 1,700,000 Baht. Our land
consists of two major parts is office and factory drinking water
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
47/114
47
5.1.5 Facility Layout
Figure 18 Life drinking water factory overview
Figure 19 Office layout
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
48/114
48
Figure 20 Factory layout
Figure 21 Toilet layout
Figure 22 Parking lots layout
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
49/114
49
Figure 23 Guardhouse layout
Figure 24 Lockers fire extinguishers and fire equipment 5 species.
Figure 25 Emergency lighting
Figure 26 Fire alarm bells
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
50/114
50
5.1.6 Machines, Equipments, Tools
Aquacheme offers a wide array of products to help you improve the performance of
your Water Treatment System:
1. Water Filters
1.1 Sand Filter
1.2 Anthracite Filter
1.3 Carbon Filter
1.4 De-Iron Filter
1.5 Softener
1.6 Demineralized System or De-Ionized System
1.7 Reverse Osmosis System (RO)
http://www.aquacheme.com/en/products/water-filters.htmlhttp://www.aquacheme.com/en/products/sand-filter.htmlhttp://www.aquacheme.com/en/products/anthracite-filter.htmlhttp://www.aquacheme.com/en/products/carbon-filter.htmlhttp://www.aquacheme.com/en/products/de-iron-filter.htmlhttp://www.aquacheme.com/en/products/water-softeners.htmlhttp://www.aquacheme.com/en/products/drinking-water-treatment.html##http://www.aquacheme.com/en/products/industrial-reverse-osmosis-systems.htmlhttp://www.aquacheme.com/en/products/industrial-reverse-osmosis-systems.htmlhttp://www.aquacheme.com/en/products/drinking-water-treatment.html##http://www.aquacheme.com/en/products/water-softeners.htmlhttp://www.aquacheme.com/en/products/de-iron-filter.htmlhttp://www.aquacheme.com/en/products/carbon-filter.htmlhttp://www.aquacheme.com/en/products/anthracite-filter.htmlhttp://www.aquacheme.com/en/products/sand-filter.htmlhttp://www.aquacheme.com/en/products/water-filters.html -
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
51/114
51
2. Water Filter Media
2.1 Sand
2.2 Anthracite
2.3 Manganese Sand
2.4 Ion Exchange Resin
- Strong Acid Cation Exchange Resin
- Strong Base Anion Exchange Resin
2.5 Cartridge Replacement
- 1, 5, 10, 50
- Length 10", 20", 39", 40"
http://www.aquacheme.com/en/products/water-filter-media.htmlhttp://www.aquacheme.com/en/products/sand.htmlhttp://www.aquacheme.com/en/products/anthracite.htmlhttp://www.aquacheme.com/en/products/manganese-sand.htmlhttp://www.aquacheme.com/en/products/ion-exchange-resin.htmlhttp://www.aquacheme.com/en/products/water-filter-cartridges.htmlhttp://www.aquacheme.com/en/products/water-filter-cartridges.htmlhttp://www.aquacheme.com/en/products/ion-exchange-resin.htmlhttp://www.aquacheme.com/en/products/manganese-sand.htmlhttp://www.aquacheme.com/en/products/anthracite.htmlhttp://www.aquacheme.com/en/products/sand.htmlhttp://www.aquacheme.com/en/products/water-filter-media.html -
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
52/114
52
3.
3.1 Boiler Compound
- Scale Preventer
- Corrosion Preventer
3.2 Cooling
- Anti Lichen
- Anti Calces and Rust
3.3 ALUM, LIME, Flocculant or Polymer
3.4 HCl 35%, NaOH
4. Measuring Chemical Pump
5. Other equipment such as Ejector, Strainer and etc.
For the price of all drinking water systems and packaging is 229,000
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
53/114
53
No. Product Detail Unit Price/Unit Total
1 Glass bottle
500ml
10,000 4.8 48,000
*2 MAXI cap 1cases
(1 case=
9,500
pieces)
5,900per
case
5,900
3 Plastic case 417 220 91,740
4 Suzuki carry
lpg
2 399,000 798,000
Total 943,640
Table 9 Machine, Equipment , Tools
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
54/114
54
Machine (Office Equipment )
No. Item Quantity Price/unit Total
1 Desk 5 3,590 17,950
2 Office chair 5 1,490 7,450
3 Sofa 1 13,950 13,950
4 Phone 3 270 810
5 Air condition 2 15,500 31,000
6 Computer 4 16,500 66,000
7 Printer 1 3,900 3,900
8 Calculator 5 120 600
9 Cabinet 1 4,590 4,590
10 Paper 10 150 1500
Total 147,750
Table 10 Machine (Office Equipment )
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
55/114
55
Chapter 6:Administration Cost
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
56/114
56
6.1 Management Analysis
Slung Drinking water has good employees that have more quality and to have
appropriate ability which follow to each duties that company want to receive to work incompany. In Slung Drinking water have the people who work in company amount 17peoples;
have general manager 1 position, marketing manager 1 position, accountant 1 position,
coordination 1 position, maintenance technician 1 position, workman 6 positions,
housekeeper 1 position, security guard 1 position, shipper 2 position and driver 2 position. We
believe that all employees that we choose them which to make slung company to achieve the
goal too fast.
The qualification of each position which Slung Drinking water use criterion making adecision to select employees.
Ownership is importance person who have a leader of Slung Drinking water.Ownership may be corporeal (title to a tangible object such as a house) or incorporeal
(title to an intangible object, such as a copyright, or a right to recover debt).
Possession does not necessarily mean ownership because not automatically transfer
title.
Source: http://www.businessdictionary.com/defination/ownership.html/
General Manager is primarily responsible for guiding employees in achieving thegoals and ambitions of the organization. They ensure that all processes and practices
are working in a proper manner. They discuss with other members of the top
management and devise any specific goals, which are to be accomplished within a
certain time period. As they oversee all processes, they have to pay minute attention to
monthly or quarterly functioning of each individual practices. They need to hire well-
experienced and efficient managers for handling the operations of individual practices
in a company.
Source: http://humanresources.about.com/od/glossarym/g/manager.htm
Qualification
- Bachelors degree of management or a field relate to slung companys specialty- To have experience to work more than 3 years- Male or Female, age 26- 45 years old
Marketing Manager performs many duties aimed at developing and implementingthe long-term and short-term marketing strategies of his employer. The broad scope of
this task requires him to interact heavily with various departments of his firm
http://www.businessdictionary.com/defination/ownership.html/http://www.businessdictionary.com/defination/ownership.html/ -
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
57/114
57
including research and development, manufacturing, supply chain, sales and in some
industries, legal and compliance. Depending on the size of his organization, a
marketing manager may also oversee a team of junior marketing professionals.
Source:http://www.knowthis.com/principles-of-marketing-tutorials/what-is-
marketing/role-of-marketing/
Qualification
- Bachelors degree of marketing or a field relate to slung companys specialty- If you ever have experience; Slung Drinking water will special considered.- Male or Female, age 23- 35 years old- Monitoring and analyzing market trend.- Strong verbal and written communication skill.
Accountant is Slung Drinking water has to manage revenue and expense for examplethat management the cost of production, the cost of income of employees and it has
manager to manage for money and divided for the revenue and expense. Accountants
who specialize in management accounting analyze and record financial data for their
employer or client to ensure they make wise business choices.
Source:http://www.associatedcontent.com/article/346256/the_role_of_accounting_in_business.html
Qualification
- To have graduated from high vocational Certificate in accounting program- Male or Female, age 23-35 years old- Be able to use Microsoft Office program- Be able to management accounting duties also include completing performance
evaluations, overseeing assets and expenses, preparing budgets and writing
reports.
Coordinator is someone whose task is to see that work goes harmoniously.Coordinator can also be another name for an administrative assistance, or sometimes
an employee slightly higher-ranking than admin assistance. However, the term can
refer to a position within an organization or business significant responsibilities for
acting as a liaison between departments.
Source: http://en.wikipedai.org/wiki/Coordinator
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
58/114
58
Qualification
- To have graduated from grade 12 of high school or vocational certificate- Male or Female, age 22-30 years old- Good communications skills- Good attention to detail- To have high responsibility and have good relationship
Maintenance Technician is somebody who maintain the day-to-day operations and toassume responsibility for maintaining the physical asset of property under the
direction of the property.
Source: http://wiki.answer.com/Q/what_is_a_Maintenace_technican
Qualification
- To have graduated from grade 12 of high school or vocational certificate inengineer program
- Male or Female, age 22-35 years old- Good command English- Good knowledge of Microsoft office program
Workman is a man who performs manual labor for wages. The role has work insideSlung Drinking water which production slung drinking water.
Qualification
- To have graduate from lower secondary school or upper level- Male, age 20-30 years old
Housekeeper is a person, often hired, who does or directs the domestic work andplanning necessary for inside slung company, as cleaning company
Source: http://www.dictinary.reference.com/browser/housekeeper
Qualification
- Male or Female, age 20 years oldupper than year- To have graduate from lower secondary school or upper level- Have more experience about cleaning
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
59/114
59
Shipper is someone who send goods for shipment, by packaging, labeling andarranging for transit, or who coordinates the transports of goods
Qualification
- To have graduate from lower secondary school or upper level- Male, age 2030 years old- To have driver License and can drive car- To have knowledge about Chiang Rai Province- To have strong man
Driver is a person or thing that drives car and to tranfer goods to customer aspuchuation.
Qualification
- To have graduate from lower secondary school or upper level- Male, age 2030 years old- To have driver License and can drive car- To have knowledge about Chiang Rai Province-
To have honest and punctuation Security Guard is a person hired by a private organization to guard a physical plant
and maintain order.
Qualification
- To have graduate from lower secondary school or upper level- Male, age 2030 years old- To have honest and punctuation
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
60/114
60
6.2 Employees Cost
Position Quantity Monthly Salary
General Manager 1 23,000
Marketing Manager 1 15,000
Accountant 1 12,000
Maintenance Technician 1 10,000
Coordinator 1 9,000
Workman 6 9,000
Housekeeper 1 9,000
Security Guard 1 9,000
Shipper 2 9,000
Driver 2 9,000Total 17 177,000
Table 11 Employees Cost
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
61/114
61
Chapter 7: Financial
Analysis
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
62/114
62
7.1 Statement of Cash flow
irst year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Cash flow from operating
ctivity
Net income -532,598 -41,255 -126,095 -131,495 -126,095 -126,095 -126,095 -126,095 -126,095 -131,495 -41,255 -41,255 -1,675,923Adjustment to reconcile net
come to net
Cash provide by operating activity
ncrease in Inventory - 2,000 450 600 150 50 150 50 100 50 50 50 50 500
Depreciation Expense 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 122,500
Net cash provided by operatingctivity 15,500 17,950 18,100 17,650 17,550 17,650 17,550 17,600 17,550 17,550 17,550 17,550 123,000
Cash flows from investing activity
Net cash provided by operating
ctivity
Cash Flow from financing activity
Cash paid for dividend - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 600,000
Net cash used in financing
ctivity - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 600,000
Net increase in cash - 567,098 - 73,305 - 157,995 - 163,845 - 158,545 - 158,445 - 158,545 - 158,495 - 158,545 - 163,945 - 73,705 - 73,705 - 2,152,923
ash balance at beginning of year 4,800,000 4,232,902 4,159,597 4,001,602 3,837,757 3,679,212 3,520,767 3,362,222 3,203,727 3,045,182 2,881,237 2,807,532
ash balance at end of year 4,232,902 4,159,597 4,001,602 3,837,757 3,679,212 3,520,767 3,362,222 3,203,727 3,045,182 2,881,237 2,807,532 2,733,827
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
63/114
63
Second year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Cash flow from operating activity
Net income -6,604 9,685 -89,375 -94,775 -89,375 -89,375 -89,375 -89,375 -89,375 -94,775 9,685 9,685 -703,349Adjustment to reconcile net income
to net
Cash provide by operating activity
Increase in Inventory - 300 - 100 - 100 - 100 - 100 - 200 - 100 - 50 - 150 - 200 - 50 - 100 - 850
Depreciation Expense 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 122,500
Net cash provided by operatingactivity 17,200 17,400 17,400 17,400 17,400 17,300 17,400 17,450 17,350 17,300 17,450 17,400 121,650
Cash flows from investing activity
Net cash provided by operating
activity
Cash Flow from financing activity
Cash paid for dividend - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 600,000
Net cash used in financing activity - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 600,000
Net increase in cash - 39,404 - 22,915 - 121,975 - 127,375 - 121,975 - 122,075 - 121,975 - 121,925 - 122,025 - 127,475 - 22,865 - 22,915 - 1,181,699
cash balance at beginning of year 2,733,827 2,694,423 2,671,508 2,549,533 2,422,158 2,300,183 2,178,108 2,056,133 1,934,208 1,812,183 1,684,708 1,661,843
cash balance at end of year 2,694,423 2,671,508 2,549,533 2,422,158 2,300,183 2,178,108 2,056,133 1,934,208 1,812,183 1,684,708 1,661,843 1,638,928
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
64/114
64
Third year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Cash flow from operating activity
Net income 13,616 56,905 -23,855 -29,255 -23,855 -23,855 -23,855 -23,855 -23,855 -29,255 56,905 56,905 -17,309
Adjustment to reconcile net income
o net
Cash provide by operating activity
Increase in Inventory
-
1,800
-
100
-
600 200
-
1,500
-
1,100 - 600 - 1,300 300 700 300 - 2,500
-
8,000
Depreciation Expense 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 122,500
Net cash provided by operatingctivity 15,700 17,400 16,900 17,700 16,000 16,400 16,900 16,200 17,800 18,200 17,800 15,000 118,300
Cash flows from investing activity
Net cash provided by operating
ctivity
Cash Flow from financing activity
Cash paid for dividend
-
50,000
-
50,000
-
50,000
-
50,000
-
50,000
-
50,000
-
50,000
-
50,000
-
50,000
-
50,000
-
50,000
-
50,000-
600,000
Net cash used in financing
ctivity - 50,000
-
50,000
-
50,000
-
50,000
-
50,000
-
50,000
-
50,000
-
50,000 - 50,000
-
50,000
-
50,000
-
50,000
-
600,000
Net increase in cash-20,684 24,305
-56,955
-61,555
-57,855
-57,455
-56,955
-57,655
-56,055
-61,055 24,705 21,905
-499,009
cash balance at beginning of year 1,638,928 1,618,244 1,642,549 1,585,594 1,524,039 1,466,184 1,408,729 1,351,774 1,294,119 1,238,064 1,177,009 1,201,714
cash balance at end of year 1,618,244 1,642,549 1,585,594 1,524,039 1,466,184 1,408,729 1,351,774 1,294,119 1,238,064 1,177,009 1,201,714 1,223,619
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
65/114
65
Fourth year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Cash flow from operating
activity
Net income 137,576 180,865 139,105 133,705 139,105 139,105 139,105 139,105 139,105 133,705 180,865 180,865 1,247,548
Adjustment to reconcile net
ncome to net
Cash provide by operating
ctivity
Increase in Inventory 9,800 - - - - - - - - - - - -
Depreciation Expense 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 122,500
Net cash provided by operatingactivity 27,300 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 122,500
Cash flows from investing
ctivity
Net cash provided by operating
activity
Cash Flow from financing
ctivity
Cash paid for dividend
-
50,000
-
50,000
-
50,000
-
50,000
-
50,000
-
50,000
-
50,000
-
50,000
-
50,000
-
50,000
-
50,000
-
50,000-
600,000
Net cash used in financing
activity
-
50,000 - 50,000
-
50,000
-
50,000 - 50,000
-
50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000
-
600,000
Net increase in cash 114,876 148,365 106,605 101,205 106,605 106,605 106,605 106,605 106,605 101,205 148,365 148,365 770,048
cash balance at beginning of year 1,223,619 1,338,495 1,486,860 1,593,465 1,694,670 1,801,275 1,907,880 2,014,485 2,121,090 2,227,695 2,328,900 2,477,265
cash balance at end of year 1,338,495 1,486,860 1,593,465 1,694,670 1,801,275 1,907,880 2,014,485 2,121,090 2,227,695 2,328,900 2,477,265 2,625,630
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
66/114
66
Table 12 Statement of Cash flow
ifth year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total
Cash flow from operating
ctivity
Net income 225,956 269,245 80,905 75,505 80,905 80,905 80,905 80,905 80,905 75,505 269,245 269,245 1,169,092
Adjustment to reconcile net income
net
Cash provide by operating activity
ncrease in Inventory - - - - - - - - - - - - -
Depreciation Expense 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 122,500Net cash provided by operating
ctivity 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 17,500 122,500
Cash flows from investing activity
Net cash provided by operating
ctivity
Cash Flow from financing activity
Cash paid for dividend-50,000
-50,000
-50,000
-50,000
-50,000
-50,000
-50,000
-50,000
-50,000
-50,000
-50,000
-50,000 - 600,000
Net cash used in financing
ctivity - 50,000 - 50,000 - 50,000 - 50,000 - 50,000 - 50,000
-
50,000 - 50,000 - 50,000
-
50,000 - 50,000 - 50,000 - 600,000
Net increase in cash 193,456 236,745 48,405 43,005 48,405 48,405 48,405 48,405 48,405 43,005 236,745 236,745 691,592
ash balance at beginning of year 2,625,630 2,819,086 3,055,831 3,104,236 3,147,241 3,195,646 3,244,051 3,292,456 3,340,861 3,389,266 3,432,271 3,669,016
ash balance at end of year 2,819,086 3,055,831 3,104,236 3,147,241 3,195,646 3,244,051 3,292,456 3,340,861 3,389,266 3,432,271 3,669,016 3,905,761
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
67/114
67
7.2 Balance sheet
First year
ASSET Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Assets
Cash 4,232,902 4,159,597 4,001,602 3,837,757 3,679,212 3,520,767 3,362,222 3,203,727 3,045,182 2,881,237 2,807,532 2,733,827
Inventories (Ending
Inventory) 2000 1550 950 800 750 600 550 450 400 350 300 250
Total Current Assets 4,234,902 4,161,147 4,002,552 3,838,557 3,679,962 3,521,367 3,362,772 3,204,177 3,045,582 2,881,587 2,807,832 2,734,077
Non Current Assets
Land 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000
Building 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610
Office Equipment 147,750 147,750 147,750 147,750 147,750 147,750 147,750 147,750 147,750 147,750 147,750 147,750
Vehicle 798,000 798,000 798,000 798,000 798,000 798,000 798,000 798,000 798,000 798,000 798,000 798,000
Supply 145,640 145,640 145,640 145,640 145,640 145,640 145,640 145,640 145,640 145,640 145,640 145,640
Accumulated Depreciation
-
17,500
-
35,000
-
52,500
-
70,000
-
87,500
-
105,000
-
122,500
-
140,000
-
157,500
-
175,000
-
192,500-
210,000
Total Non current assets 5,182,500 5,165,000 5,147,500 5,130,000 5,112,500 5,095,000 5,077,500 5,060,000 5,042,500 5,025,000 5,007,500 4,990,000
TOTAL ASSETS 9,417,402 9,326,147 9,150,052 8,968,557 8,792,462 8,616,367 8,440,272 8,264,177 8,088,082 7,906,587 7,815,332 7,724,077
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
68/114
68
LIABILITY ANDEQUITY
Non current Liability
Long term Debt 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000
Total Non currentiaabilities 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000
EQUITY
Retaines Earnings -582,598 -673,853 -849,948 -1,031,443 -1,207,538 -1,383,633 -1,559,728 -1,735,823 -1,911,918 -2,093,413 -2,184,668 -2,275,923
Total Equity -582,598 -673,853 -849,948 -1,031,443 -1,207,538 -1,383,633 -1,559,728 -1,735,823 -1,911,918 -2,093,413 -2,184,668 -2,275,923
Total liabilities & Equity 9,417,402 9,326,147 9,150,052 8,968,557 8,792,462 8,616,367 8,440,272 8,264,177 8,088,082 7,906,587 7,815,332 7,724,077
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
69/114
69
Second year
ASSET Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Assets
Cash 2,694,423 2,671,508 2,549,533 2,422,158 2,300,183 2,178,108 2,056,133 1,934,208 1,812,183 1,684,708 1,661,843 1,638,928
Inventories (Ending
Inventory) 550 650 750 850 950 1150 1250 1300 1450 1650 1700 1800
Total Current Assets 2,694,973 2,672,158 2,550,283 2,423,008 2,301,133 2,179,258 2,057,383 1,935,508 1,813,633 1,686,358 1,663,543 1,640,728
Non Current Assets
Land 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000
Building 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610
Office Equipment 147,750 147,750 147,750 147,750 147,750 147,750 147,750 147,750 147,750 147,750 147,750 147,750
Vehicle 798,000 798,000 798,000 798,000 798,000 798,000 798,000 798,000 798,000 798,000 798,000 798,000
Supply 145,640 145,640 145,640 145,640 145,640 145,640 145,640 145,640 145,640 145,640 145,640 145,640
AccumulatedDepreciation
-227,500
-245,000
-262,500
-280,000
-297,500
-315,000
-332,500
-350,000
-367,500
-385,000
-402,500
-420,000
Total Non current assets 4,972,500 4,955,000 4,937,500 4,920,000 4,902,500 4,885,000 4,867,500 4,850,000 4,832,500 4,815,000 4,797,500 4,780,000
TOTAL ASSETS 7,667,473 7,627,158 7,487,783 7,343,008 7,203,633 7,064,258 6,924,883 6,785,508 6,646,133 6,501,358 6,461,043 6,420,728
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
70/114
70
LIABILITY ANDEQUITY
Non current Liability
Long term Debt 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000
Total Non currentliaabilities 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000
EQUITY
Retaines Earnings -2,332,527 -2,372,842 -2,512,217 -2,656,992 -2,796,367 -2,935,742 -3,075,117 -3,214,492 -3,353,867 -3,498,642 -3,538,957 -3,579,272
Total Equity -2,332,527 -2,372,842 -2,512,217 -2,656,992 -2,796,367 -2,935,742 -3,075,117 -3,214,492 -3,353,867 -3,498,642 -3,538,957 -3,579,272
Total liabilities &
Equity 7,667,473 7,627,158 7,487,783 7,343,008 7,203,633 7,064,258 6,924,883 6,785,508 6,646,133 6,501,358 6,461,043 6,420,728
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
71/114
71
Third year
ASSET Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Assets
Cash 1,618,244 1,642,549 1,585,594 1,524,039 1,466,184 1,408,729 1,351,774 1,294,119 1,238,064 1,177,009 1,201,714 1,223,619
Inventories (Ending
Inventory) 3600 3700 4300 4100 5600 6700 7300 8600 8300 7600 7300 9800
Total Current Assets 1,621,844 1,646,249 1,589,894 1,528,139 1,471,784 1,415,429 1,359,074 1,302,719 1,246,364 1,184,609 1,209,014 1,233,419
Non Current Assets
Land 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000
Building 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610
Office Equipment 147,750 147,750 147,750 147,750 147,750 147,750 147,750 147,750 147,750 147,750 147,750 147,750
Vehicle 798,000 798,000 798,000 798,000 798,000 798,000 798,000 798,000 798,000 798,000 798,000 798,000
Supply 145,640 145,640 145,640 145,640 145,640 145,640 145,640 145,640 145,640 145,640 145,640 145,640
Accumulated
Depreciation
-
437,500
-
455,000
-
472,500
-
490,000
-
507,500
-
525,000
-
542,500
-
560,000
-
577,500
-
595,000
-
612,500
-
630,000
Total Non current assets 4,762,500 4,745,000 4,727,500 4,710,000 4,692,500 4,675,000 4,657,500 4,640,000 4,622,500 4,605,000 4,587,500 4,570,000
TOTAL ASSETS 6,384,344 6,391,249 6,317,394 6,238,139 6,164,284 6,090,429 6,016,574 5,942,719 5,868,864 5,789,609 5,796,514 5,803,419
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
72/114
72
LIABILITY AND
EQUITY
Non current Liability
Long term Debt 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000
Total Non currentliaabilities 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000
EQUITY
Retaines Earnings -3,615,656 -3,608,751 -3,682,606 -3,761,861 -3,835,716 -3,909,571 -3,983,426 -4,057,281 -4,131,136 -4,210,391 -4,203,486 -4,196,581
Total Equity -3,615,656 -3,608,751 -3,682,606 -3,761,861 -3,835,716 -3,909,571 -3,983,426 -4,057,281 -4,131,136 -4,210,391 -4,203,486 -4,196,581
Total liabilities &
Equity 6,384,344 6,391,249 6,317,394 6,238,139 6,164,284 6,090,429 6,016,574 5,942,719 5,868,864 5,789,609 5,796,514 5,803,419
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
73/114
73
Fourth year
ASSET Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Assets
Cash 1,338,495 1,486,860 1,593,465 1,694,670 1,801,275 1,907,880 2,014,485 2,121,090 2,227,695 2,328,900 2,477,265 2,625,630
Inventories (EndingInventory) 0 0 0 0 0 0 0 0 0 0 0 0
Total Current Assets 1,338,495 1,486,860 1,593,465 1,694,670 1,801,275 1,907,880 2,014,485 2,121,090 2,227,695 2,328,900 2,477,265 2,625,630
Non Current Assets
Land 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000
Building 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610
Office Equipment 147,750 147,750 147,750 147,750 147,750 147,750 147,750 147,750 147,750 147,750 147,750 147,750
Vehicle 798,000 798,000 798,000 798,000 798,000 798,000 798,000 798,000 798,000 798,000 798,000 798,000
Supply 145,640 145,640 145,640 145,640 145,640 145,640 145,640 145,640 145,640 145,640 145,640 145,640
Accumulated Depreciation
-
647,500
-
665,000
-
682,500
-
700,000
-
717,500
-
735,000
-
752,500
-
770,000
-
787,500
-
805,000
-
822,500
-
840,000
Total Non current assets 4,552,500 4,535,000 4,517,500 4,500,000 4,482,500 4,465,000 4,447,500 4,430,000 4,412,500 4,395,000 4,377,500 4,360,000
TOTAL ASSETS 5,890,995 6,021,860 6,110,965 6,194,670 6,283,775 6,372,880 6,461,985 6,551,090 6,640,195 6,723,900 6,854,765 6,985,630
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
74/114
74
LIABILITY AND EQUITY
Non current Liability
Long term Debt 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000
Total Non current
liaabilities 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000
EQUITY
Retaines Earnings -4,109,005 -3,978,140 -3,889,035 -3,805,330 -3,716,225 -3,627,120 -3,538,015 -3,448,910 -3,359,805 -3,276,100 -3,145,235 -3,014,370
Total Equity -4,109,005 -3,978,140 -3,889,035 -3,805,330 -3,716,225 -3,627,120 -3,538,015 -3,448,910 -3,359,805 -3,276,100 -3,145,235 -3,014,370
Total liabilities & Equity 5,890,995 6,021,860 6,110,965 6,194,670 6,283,775 6,372,880 6,461,985 6,551,090 6,640,195 6,723,900 6,854,765 6,985,630
-
7/29/2019 Project feasibility and evaluation Slung Drinking Water Sec 2 Group 6
75/114
75
Fifth year
ASSET Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Assets
Cash 2,819,086 3,055,831 3,104,236 3,147,241 3,195,646 3,244,051 3,292,456 3,340,861 3,389,266 3,432,271 3,669,016 3,905,761
Inventories (Ending Inventory) 0 0 0 0 0 0 0 0 0 0 0 0
Total Current Assets 2,819,086 3,055,831 3,104,236 3,147,241 3,195,646 3,244,051 3,292,456 3,340,861 3,389,266 3,432,271 3,669,016 3,905,761
Non Current Assets
Land 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000 1,700,000
Building 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,408,610 2,4
top related