project feasibility and evaluation slung drinking water sec 2 group 6

Upload: jay-jira

Post on 04-Apr-2018

214 views

Category:

Documents


0 download

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