Feasibility Study
Feasibility Study
Feasibility Study
Project Location
Project Proponent
Project Ownership
Project
:
:
Description
project
Establishing
Pepsi
Cola
nearby areas.
:
100% Personal Funds
The project provides soft drinks in cases to
the store/ restaurant owners. It will provide
employment
Opportunities
and
income
for
: profitable
Barbershops ship
market.
Return On
Investment
Payback Period
Net Present Value
81.36%
:
:
1.5 Years
1,061,649.96
to the target
PART 2: INTRODUCTION
2.1 Background of the Study
In the modern culture, barbershop particularly among younger generation
has become very popular. Salons in various styles are widely patronized by
people at various occasion like dinner parties, marriages, social get together ,
birthday celebrations etc. all children of all ages and groups especially attracted
by the mere mention of the word barbershop. With the growing popularity
the
increasing annually and the demand for haircut also increases and at present
there is a need of a barbershop.
2.2 Statement of the Problem
This is a feasibility study on the proposed project of a Barbershop in a
Bike
What degree of influence in the following five (5) functional aspects of the
Barbershops ship, Zamboanga City.
organization, the people who will be involved both before and during the
operating periods of the enterprise, and then functions. This will answer how the
project should be manage before and during the operating periods, pointing out
the firms or persons involved or to be involved in studying the different aspects of
the project, types of business organization, organizational chart and functions of
each people involved in the project.
Technical Aspect - This aspect will help identify that product could be
produced at the highest possible quality with minimum cost. The composition of
the product specifically relating to physical, mechanical and chemical properties
is described. This also includes the uses of the product. Another relevant
information is the equipment that will be used for the operation of the project.
Location of the process will be considered in this project. It is determined that the
location is desirable in terms of distance to sources of the product and to the
customers. Utility and waste disposal will be taken into account here indicating
specific utilities like electricity , fuel, water, supplies and their respective uses,
quantity required, balances, availability of sources, alternative sources and costs.
are the
following:
Project Cost
Return of Investment
Net Present Value
Other important financial ratios
The clients. This study will enable to serve the community of the west
coast. This will also give them idea of the latest service is offering them.
The Future researchers. This will serve as future reference for all
students undertaking activities relative to the proposed business study.
2.5 Scope and limitations
This feasibility study will confine itself in the determination, analysis
and evaluation of the feasibility and viability of establishing of Barbershops in
the west coast.
Integrated into this project study are the important aspects on market,
organization and management technical, financial, and socio economic impact.
Concerning the financial aspect the five year projection will be drawn to serve as
a guide in the future outlook of the proposed project.
2.6 Methodology
In this feasibility study, the proponent will utilize several methods and
approaches to make a comprehensive and substantial preparation for
consideration. For data gathering various medium will be used like carrying out
and conducting personal survey of the community and barangays of the west
coast. Personal interviews will also be conducted among the various retailers
and the residents for the concerned area. Data gathering instruments like the
questionnaires and interview questions will be prepared by the proponent.
The proponent will also visit the concerned government offices like the
national Statistics Coordinating Board, Department of Trade and Industry, Office
of the City Mayor/Business Permit Office, and the Local Barangay Councils.
strategies which cover promotion, pricing and placement of the product. These
are what the proponent would like to achieve for this project.
The marketing process involves segmenting that market and choosing the
target markets that the business entity can satisfy in a superior way. It must
formulate a broad strategy and determine a specific marketing mix and action
plan to optimize its long-run performance. It defines a set of controls to evaluate
operating results and continue to exist as a learning enterprise constantly
improving its marketing know-how.
As an aspiring entrepreneur , the proponent had an idea of coming up with
the business as he has seen the potential of the business in the market. The
proponent is formerly connected with most barbershops in Zamboanga City and
has seen how profitable a pe rson can be once he is engaging in this type of
business. Having this in mind, the proponent had a chance to talk with the
business owners about business which he could make. However, an idea for a
business is not a sufficient reason to begin straight away, without having thought
clearly about the marketing aspects involved.
Many questions have been considered such as Is there a demand for the
business, are there competitors in the market? The market aspect should be
looked at in turn. In order to analyze the demand of the product in the market, all
information needed were gathered such as the total population of 11 barangays
chosen by the proponent for the operation of the business, total population of
business establishment that sells soft drinks in 11 chosen Barangays were also
determine. The market share of Barbershops and its competitor. Information of
10
the market share were gathered through focused group discussion undertaken
between the proponent and the personnel . Other sources were provided by the
Internet and the Social where an interactions of people from different walks of life
happened. A survey were distributed to the consumers to know their preferences
of Haircut services. To substantiate more the data, the proponent had an
interview with the NSO for the total population of the Zamboanga City ,
particularly the barangays chosen. A data from the licensing office were gathered
to know how many business establishments are registered in the chosen
barangays. From the said information, a demand was determined for the
business. .
11
is increasing the demand for haircut is also increasing that the stores cannot
meet.
For the primary market, this study will include the areas where the density
For the secondary market, the underlying areas outside the perimeter of
the primary market , the residential areas with more populous inhabitants will be
the source of secondary customers.
3.4 Demand
Table 1. Population of Eleven (11) Chosen Barangays for the year 2010
Population
Barangay
( 2010)
Baliwasan
Campo Islam
San Jose Gusu
San Roque
Upper Calarian,
Malagutay
Sinunuc
Cawit
Maasin
Recodo
Ayala
27,664
11,523
24,917
20,974
25,655
5,624
15,926
9,305
6,095
17,754
16,929
12
Population
Barangay
( 2010)
Total Population
182,366
Source: National Statistics Office IX, Office of Zamboanga City
2010
2011
2012
2013
2014
Baliwasan
Campo Islam
San Jose Gusu
San Roque
Upper Calarian,
Malagutay
Sinunuc
Cawit
Maasin
Recodo
Ayala
27,664
11,523
24,917
20,974
25,655
5,624
15,926
9,305
6,095
17,754
16,929
182,366
28,605
11914.78
25764.18
21687.12
26527.27
5815.216
16467.48
9621.37
6302.23
18357.64
17504.59
188566.4
29,577
12319.88
26640.16
22424.48
27429.2
6012.933
17027.38
9948.497
6516.506
18981.8
18099.74
194977.7
30582.75
12738.76
27545.93
23186.91
28361.79
6217.373
17606.31
10286.75
6738.067
19627.18
18715.13
201606.9
31622.57
13171.88
28482.49
23975.27
29326.09
6428.764
18204.92
10636.49
6967.161
20294.5
19351.45
208461.6
Table 3. 60 % of the Total Population of the 12 Barangays who drink soft drink
Demand
In Cases
2010
2011
2012
2013
2014
109,420
4559
113,140
4714
116,987
4874
120,964
5040
125,077
5212
Table three (3) shows that of the total populace of the chosen barangays
60 percent (%) are drinking soft drinks almost everyday. Initially we can conclude
that 109,420 people are drinking soft drinks which is equivalent to 4,559 cases a
day .
13
proponent with the end users. Out of the total population, the respondent came
up with 100 questionnaires for the end users and it shows that out of the total
respondents, 95 percent answered that they are drinking soft drinks.
Thinking
that in every barangay, there are children who are not drinking softdrink, the
proponent made an assumption that the demand will based on 60 % total
Population of those who are drinking soft drinks of the west coast. Although the
store retailers are the primary market of the business. It should take into
consideration the total population of the people in order to know the demand that
every store of the chosen barangays should cater . In the year 2010 the demand
is 4559 cases a day which is equivalent to 109,420 bottles a day . It means that
every day there are people who drink and buy soft drinks. This means that the
business should be able to supply this needs.
In order to determine the demand and supply of the chosen barangays ,
the proponent decided to come up with survey questionnaires intended for the
consumers, store owners and distributors of pepsi. 100 survey questionnaires
were prepared to consumers and store owners. While an interview with the
existing EDS operator( Distributor) were undertaken. To substantiate the study,
the proponent initiated a Focused Group Discussion for the Managers of Pepsi
Cola Product Phillippines. The table below were the results of prepared survey.
14
Responses
Exclusive Coke
Exclusive Pepsi
Non-Exclusive
Number Of Stores
Percent
60
50%
20
17%
30
25%
Do not sell either coke and pepsi
10
8%
TOTAL
120
100%
Table 2.1 shows that among the 120 Stores surveyed , 60 Stores are
exclusive Coke, 20 exclusive pepsi, 30 stores are non exclusive and the
remaining 10 do not sell either coke or pepsi.
Computation 2 : Number of Cases of softdrinks sold in a day
Amount
Number of stores
1-5 cases
80
6-10 cases
20
11 15 cases
16-20 cases
TOTAL
Computation 3: Years of Exclusivity
110
Number of Years
Number of
Members
1 year
57
48%
2 years
18
15%
4%
Non Exclusive
20
16%
TOTAL
15
stores located in remote areas which are hard to penetrate by both coke and
pepsi sales representatives. These EDS operators are not to be considered by
the business. The direct competitor of the business will be Coca Cola Products
Philippines.
During the conduct of interview among the EDS operators (Distributors)
the proponent had an interview with them one by one and asked them the same
questions. Here are the questions ant consolidated answer by the proponent and
the EDS: It was known from the EDS operators that they have an average sales
of 170 cases per day for carbonated drinks. That include Pepsi , Mirinda, 7 up,
Mountain dew and other carbonated drinks. The most sellable is Pepsi 8 oz
which has an average sales of 70 cases a day and followed by mountain dew
with 65 cases . the remaining cases are being shared by other products of pepsi.
Sting , an energy drinks has an average sales of 80 cases a day. while the
rest of the products that falls under non- carbonated drinks are not included here
since the main purpose of the proponent is to sell those products which are
known to be sellable in the market.
The price lists of the products were also provided by the operator and the
corresponding commission per case was also provided.
Pepsi 8 oz earns
17.40 per case, but the rest of the product can be given equal commission just
like pepsi. Sting has a commission of 20 per case
Aside from regular sales, there are special occasions you that EDS
operators are engaging for additional
income such as
Fiesta, wedding ,
Christmas, hariraya and new year. And in every special occasion , an average
sales of 20 cases per occasion is calculated.
Table 4. Total Number of Stores Selling Soft drinks in 11 Barangays
Barangay
Population( 2010)
16
Baliwasan
Campo Islam
San Jose Gusu
San Roque
Upper Calarian,
Malagutay
Sinunuc
Cawit
Maasin
Recodo
Ayala
Suterville
Total number of Stores
Source: City Licensing Office
192
23
121
133
61
6
35
20
22
56
90
39
794
Out of these stores , 135 are shares of pepsi while, 397 belongs to the
market of Coca Coal. 262 stores are still not penetrated by both soft drink
companies and are potential customers of the business. During the conduct of
interview by the proponents, these stores buy pepsi every other day with an
average of 4 cases per transaction.
Daily
Monthly
Annual
2005
2,787
72,462.00
869,544.00
2006
2,973
77,292.80
927,513.60
2007
3,159
82,123.60
985,483.20
2008
3,344
86,954.40
1,043,452.80
2009
3,530
91,785.20
1,101,422.40
17
Daily
3,716
3,902
4,088
4,273
4,459
Monthly
96,616.00
101,446.80
106,277.60
111,108.40
115,939.20
Annual
1,159,392.00
1,217,361.60
1,275,331.20
1,333,300.80
1,391,270.40
Year
2005
2006
1644.8
2007
1747.6
2008
1850.4
2009
1953.2
18
2012
2,268
2013
2,372
2014
2,476
= a+bX
Where Y= Computed value of sales to be predicted (y axis intercept)
a = - bx
b = X Y n X (Slope of the line)
X - n ( x )
x = Independent Variable (Time)
Computation 4:
Year
2005
Time ( X)
1
Supply (Y)
1542
X
1
2006
1644.8
2007
1747.6
2008
1850.4
16
2009
1953.2
25
x=15
y=8,738
x=55
Solve for:
b =xy-nx
x-n(x)
Where :
x=x/n=15/5=3
=/n=8,738/5
= 1,748
XY
1,542
3289.6
5242.8
7401.6
9766
x= 27,242
19
b = 27,242 5 (3 ) (1,748)
55 (5) ( 3 )
= 27,242 26,220
55 45
= 1,040
10
b = 104
a = y bx
= 1,748 104 ( 3 )
= 1,748 312
a = 1,436
Linear Equation : y = a + bx= 1,436 + 104 ( x )
Computation
Year
2010
X= 6
2011
X= 7
2012
X=8
2013
X=9
2014
X = 10
Linear Equation
Y =1,436 + 104 ( 6 )
Y = 1,436 + 104 ( 7 )
Y = 1,436 + 104 ( 8 )
Y = 1,436 + 104 ( 9 )
Y = 1,436 + 104 ( 10 )
Projected Supply
2,060
2,164
2,268
2,372
2,476
Year
2010
Demand
(in cases.)
Supply
(in Cases.)
Demand and
Supply Gap
Market
Share
3,716
2,060
1,656
45%
20
2011
2012
2013
3,902
2,164
1738
45%
4,088
2,268
1820
45%
4,273
2,372
1901
45%
2,476
1983
45%
4,459
2014
Demand and Supply Gap
The prospective demand for the product is not met by the limited supply.
Though the projected daily demand is 1,656 cases, the proponent is only willing
to supply 197 cases assorted soft drinks of pepsi. However , the discrepancy
between the projected daily demand and projected daily supply gives more than
enough assurance that the possibility for good business is high.
Based from the data shown there is still 45 percent of the total populace
who are not serve by the store owners. Possible reason is that there are people
specially from different corners of the barangay are not yet serve by both coke
and pepsi.
Table 11 :
Price Competitiveness
Pepsi
Mountain Dew
7- up
Mirinda
80z
144
144
144
144
12oz
192
192
192
192
1 liter
236
236
236
236
330 ml
420
420
420
420
500 ml
420
420
420
420
1.5 ml
420
420
420
420
21
240ml
200
Sting
330ml
360
Promotion
Considering the high demand of pepsi products , the proposed EDS and
As Exclusive seller of
22
23
Fill up order
form
Territory Manager
approve the form
Filled up form to be
submitted to Order Process
Analyst
Encoding of the order to be
forwarded to Physical Distribution
Department
Physical Distribution Department
Release the order
24
Before the distributor can get soft drinks from the company, he must fill up
the order form and have it signed by the territory manager of the company for
1
0
1
1
0
1
the approval .
After the approval the helper will proceed to the order processing analyst
for assistance and for encoding.
The encoded order will be sent to the Physical Distribution department
The physical distribution receives the order and items will be released
A traffic clerk will check if the items released are correct.
The truck will be ready to depart.
25
The helper will submit the authenticated form to the RSA for the payment
of the cases sold. The distributor gets his share of 17.40 per case as his
commission.
4.5 Operation schedule
Being an EDS operator, 6 working days is required for the selling of the
products. There will be 317 working days in a year. However Sundays can be
utilized in order the distributors can meet his quota.
26
27
Being the simplest form of ownership enjoys among others, the following
recognized advantages:
A.) It is the easiest to form and organize for no form requirements are
required by law, except when the owner shall do businesses under trade
name or style in which case, it is necessary.
B.) To register such name to the Department of Trade and Industry ( Act. No.
3883 as amended by act no. 4147 and Republic Act 863).
C.) To pay a fee in the sum of One hundred forty eight pesos plus
documentary stamp of fifteen pesos the for use of such trade name for five
years (Section 2 Act No. 3883) renewable every five years for similar fee.
D.) It has the quality of simplicity and flexibility in the management and
control.
E.) It is possible for the proponent to engage any time in other business even
those unrelated to his main business.
F.) The proponent may discontinue his business activity and venture another
at his will and discretion.
Thus, the manager is the proponent of this project. The proponent will hire
one(1) driver and three ( 3) helpers for the operation of the project.
28
Activities
Month
Week
DRIVER
29
HELPER 1
HELPER 2
HELPER 3
Minimum Qualification
Legal Age, Master in
Business Administration
with Five ( 5 ) years
Managerial
experience,
fluent
in
Chabacano,
Visayan, English and
Tagalog dialects; and
hardworking .
Position Description
Its function is to insure
that the policies set forth
by
the
Pepsi
Cola
Products Philippines and
the proponents are strictly
followed. Make reports of
sales and recommend
strategy for better sales
and income. He / she
must also plan, direct,
30
1-Driver
3-Helpers
supervise
the
distributorship in its daily
operations. He is also
responsible
for
the
implementation of the
policies and procedures of
the business
Its
function is to do
driving works and other
related work.
Must assist the helper in
the
distribution
of
products
to
different
outlets in Zamboanga City
particularly in the west
coast.
Assist managers and
drivers in the selling of the
products
Facilitate the loading and
reloading to fulls and
emptys
Do maintenance work
Act as tire man
Table 12: Salaries, SSS PHIC & HDMF, 13th Month And Separation Pay
Position
Monthly
Salary
SSS Contrib.
PHIC
Contrib.
HDMF
Contrib.
13th
Month
Pay
Separation
Pay
Total
Annual
Salaries &
Benefits
Manager
15,000.00
608
100
100
15,000.00
7,500.00
212,196.00
Driver 1
6,000.00
304
100
100
6,000.00
3,000.00
87,048.00
Helper 1
3,000.00
152
100
100
3,000.00
1,500.00
44,724.00
Helper 2
3,000.00
152
100
100
3,000.00
1,500.00
44,724.00
Helper 3
3,000.00
152
100
100
3,000.00
1,500.00
44,724.00
Driver 2
31
Total
Grand Total(Annual)
30,000.00
1368
500.00
500
30000
15000
360,000.00
16,416.00
6,000.00
6,000.00
30,000.00
15,000.00
433,416.00
applicants as follows:
A.) All aspirants are treated equally; those who did not meet the minimum
requirements shall be informed immediately.
B.)
Service Incentive Leave of five days after One (1) year of service
2.
3.
32
However, after
rendering one (1) year service with Barbershops ship, employees are entitled to
a five (5)-day service Incentive Leave benefit for each year of service, to start
one (1) year from the date of your initial appointment.
be filed in three (3) days before the date of vacation leave while sick leave
application will be filed on the day of duty`s resumption.
5.5.5 Service Incentive Leave (SIL) Policies:
1.
2.
3.
Should you resign, the proponent shall pay the money equivalent of your
SIL credits except when your service is less than one (1) year.
(1) day absence shall mean Absence Without Leave (AWOL) which can
eventually lead to the termination of the employee.
33
2.
Always record your time in and time out in Daily Time Record (DTR) card.
3.
Notify your superior in case you are sick and could not report for work for
appropriate recording and disposition.
Failure to
comply with the five-day notification would mean the withholding of any
monetary benefit due you.
2. Commission of acts endangering the interest and security the business, such
as drug abuse, dishonesty, theft or any form of deception or fraud.
3.
Conduct and behavior that maligns the image of the business , or inimical
to the morale and harmonious relationship of the employees of the business ,
unbecoming behavior, insubordination, improper acts such as drunkenness,
gambling, excessive borrowing of money or failure to pay debts, gossiping and
revealing confidential information or documents, indiscriminate and official use of
farm equipment and facilities
34
35
resources of the company and analysis regarding with profitability, liquidity and
stability.
The proposed Barbershops , financial management will primarily
concerned with two functions.
2.
Financial Projection is spread over five (5) years to determine the payback period.
3.
The target daily sales of 197 cases and increased by 10% every year of
units of sales volume.
4.
5.
6.
36
7.
8.
9.
Items costing P
2,500.00 and above will be depreciated and all items below this amount
will be expensed.
11.
12.
13.
15.
16.
37
COST
308,000.00
18,000.00
326,000.00
15,000.00
15,000.00
5,000.00
5,881.00
10,000.00
20,881.00
361,881.00
25,000.00
386,881.00
No. of
cases Sold
Commission
Daily
Monthly
Yearly
/case
Income
Income
Income
60.00
60.00
4.00
4.00
6.00
3.00
60.00
17.40
17.40
17.40
17.40
17.40
17.40
20.00
1,044.00
1,044.00
69.60
69.60
104.40
52.20
1,200.00
197.00
124.40
3,583.80
27,144.00 325,728.00
27,144.00 325,728.00
1,809.60
21,715.20
1,809.60
21,715.20
2,714.40
32,572.80
1,357.20
16,286.40
31,200.00 374,400.00
93,178.80
1,118,145.60
Quantity
UNIT
Acquisitio
EUL
Amount of
38
COST
Truck
carts
n Cost
(years)
300,000.
00
5.00
8,000.
00
5.00
308,000.
00
Depreciation
60,000.0
0
1,600.0
0
Acquisition
EUL
Cost
(years)
Amount of
Depreciation
300,000.00
4,000.00
304,000.0
0
Schedule 4: Furniture and Fixtures
TOTAL
DESCRIPTION
Quantity
Steel Cabinet
Tables
TOTAL
UNIT COST
(unit/s)
2
2
6,000.00
3,000.00
9,000.00
12,000.00
6,000.00
18,000.00
61,600
5
5
2,400.00
1,200.00
3,600.00
DESCRIPTION
Folder
Fastener
Clip
Glue
Stapler
Calcuator
Chairs
Staple wire
Stamped Pad
Stamped Ink
Ball pen
Pencil
Bond Paper
Quantity
(unit/s)
30 pieces
2 boxes
2 boxes
2 bottles
1 unit
3
3
1 boxes
1 piece
1 bottle
1 box
1 boxes
1 reams
Total Expense
Schedule 6: Inaugural Expense
UNIT COST
7.00
30.00
30.00
95.00
265.00
500.00
500.00
30.00
70.00
50.00
140.00
60.00
180.00
1,957.00
TOTAL
COST
Preoperating
Expenses
Annual
Cost
210.00
60.00
60.00
190.00
265.00
1,500.00
1,500.00
30.00
70.00
50.00
140.00
60.00
180.00
4,315.
00
420.00
120.00
120.00
380.00
265.00
1,500.00
1,500.00
60.00
70.00
200.00
286.00
240.00
720.00
5,881.0
0
420.00
120.00
120.00
380.00
265.00
1,500.00
1,500.00
60.00
70.00
200.00
286.00
240.00
720.00
5,881.
00
39
QUANTITY
(unit/s)
1 piece
100 pieces
50 heads
3 cases
-
DESCRIPTION
Banner
Balloons
Foods
Drinks
Miscellaneous expenses
Total Inaugural Expenses
UNIT COST
TOTAL COST
600
10
150
150
-
600
1000
7,500.00
450
450
10,000.00
DESCRIPTION
Truck
Multicab
Push Cart
Quantity
(unit/s)
1
UNIT COST
300,000.00
300,000.00
60,000.00
4,000
8,000
1600
304,000.00
308,000.00
TOTAL
Acquisition
EUL
Amount of
Cost
(years) Depreciation
61,600.00
Schedule 8: Salaries, SSS PHIC & HDMF, 13th Month and Separation Pay
Position
Monthly
Salary
SSS
Contrib.
PHIC
Contrib.
HDMF
Contrib.
Manager
15,000.00
608
100
100
Driver 1
6,000.00
304
100
100
Helper 1
3,000.00
152
100
100
Helper 2
3,000.00
152
100
100
13th
Month
Pay
15,000.
00
6,000.0
0
3,000.0
0
3,000.0
0
Separati
on Pay
7,500.00
3,000.00
1,500.00
1,500.00
Total
Annual
Salaries
&
Benefits
212,196.
00
87,048.0
0
44,724.0
0
44,724.0
0
40
Helper 3
Total
Grand Total
( Annual)
3,000.00
152
100
100
30,000.00
1368
500.00
500
3,000.0
0
30000
6,000.0
0
30,000.
00
360,000.00
16,416.0
0
6,000.00
1,500.00
44,724.0
0
15000
15,000.0
0
433,416.
00
DESCRIPTION
Prepaid Smart Card
Prepaid TM/Globe Card
Total
UNIT COST
300
300
600
TOTAL
COST
600
600
1,200.00
Annual
Cost
7,200.00
7,200.00
14,400.00
41
Net Revenue
NET Revenue
2011
2012
1,118,145.60
1,229,960.16
Net Revenue
1,118,145.60
1,229,960.16
2013
2014
2015
1,352,956.18
1,488,251.79
1,637,076.97
1,352,956.18
1,488,251.79
1,637,076.97
2012
2013
2014
30,000.00
31,500.00
33,075.00
34,728.75
36,465.19
0.00
0.00
0.00
0.00
0.00
ADMINISTRATIVE EXPENSES
2015
2,500.00
3,000.00
3,500.00
4,000.00
4,500.00
28,416.00
29,836.80
31,328.64
32,895.07
34,539.83
5,881.00
6,175.05
6,483.80
6,807.99
7,148.39
10,000.00
11,000.00
12,000.00
13,000.00
14,000.00
Organization Cost
15,000.00
Misc. Expense
5,000.00
5,000.00
5,000.00
5,000.00
5,000.00
3,600.00
3,600.00
3,600.00
3,600.00
3,600.00
100,397.00
90,111.85
94,987.44
100,031.81
105,253.41
2014
2015
2011
2012
2013
360,000.00
378,000.00
396,900.00
416,745.00
437,582.25
61,600.00
61,600.00
61,600.00
61,600.00
61,600.00
228,800.00
393,120.00
412,776.00
433,414.80
455,085.54
14,400.00
15,120.00
15,876.00
16,669.80
17,503.29
664,800.00
847,840.00
887,152.00
928,429.60
971,771.08
42
Particulars
2012
2013
2014
2015
Commission Income
1,118,145.60
1,229,960.16
1,352,956.1
8
1,488,251.79
1,637,076.97
765,197.00
937,951.85
982,139.44
1,028,461.41
1,077,024.49
352,9
48.60
292,008.31
370,816.73
459,79
0.38
560,0
52.49
80,884.58
62,602.49
86,245.02
112,937.11
143,015.75
272,064.02
229,405.82
284,571.71
346,853.27
417,036.74
Net income
2011
2012
2013
2014
2015
352,948.60
292,008.31
370,816.73
459,790.38
560,052.49
Ceiling
250,000.00
250,000.00
250,000.00
250,000.00
500,000.00
Balance
102,948.60
42,008.31
120,816.73
209,790.38
60,052.49
30%
30%
30%
30%
30%
variable
30,884.58
12,602.49
36,245.02
62,937.11
18,015.75
Fixed
50,000.00
50,000.00
50,000.00
50,000.00
125,000.00
80,884.58
62,602.49
86,245.02
112,937.11
143,015.75
Rate
Income Tax
43
Pre- OP
2011
2012
2013
2014
2015
Cash Inflows
1,118,145.6
0
Commission Income
Owners Equity
386,881.00
386,881.00
1,229,960.1
6
1,118,145.60
1,229,960.1
6
688,597.00
876,351.85
1,352,
956.18
1,352,956.
18
1,488,
251.79
1,637,
076.97
1,488,251.7
9
1,637,076.9
7
966,861.41
Cash Outflows
Operating Expense(net
of Depreciation)
Income Tax
Fixed Assets
Organizational Cost
326,000.00
60,881.00
62,
602.49
86,
245.02
983,141.94
1,053,106.4
3
1,128,361.6
0
435,145.36
508,715.37
326,000.00
Add: Cash
Balance Begenning
80,884.58
1,015,424.4
9
112,
937.11
920,539.44
60,881.00
15,000.00
703,597.00
957,236.43
414,548.60
272,723.73
369,814.24
475,429.60
748,
153.33
60,881.00
475,429.60
748,153.33
1,117,967.
57
1,117,
967.57
1,553,
112.93
1,553,112.9
3
2,061,828.3
0
44
2011
2012
2013
2014
2015
1,117,967
.57
1,553,112
.93
2,061,828
.30
ASSETS
Current Assets
Cash
475,429
.60
748,153.3
3
475,429.60
748,153.33
1,117,967.57
1,553,112.93
2,061,828.30
300,000.00
8,000
.00
18,000
.00
326,000
.00
61,600
.00
300,000.00
300,000.00
8,000.
00
18,000.
00
326,000.
00
184,800.
00
300,000.00
8,000
.00
18,000
.00
326,000
.00
246,400
.00
300,000.00
8,000.
00
18,000.
00
326,000
.00
308,000
.00
264,400.00
202,800.00
141,200.00
79,600.00
18,000.00
739,829.60
950,953.33
1,259,167.57
1,632,712.93
2,079,828.30
80,884.58
62,602.49
86,245.02
112,937.11
143,015.75
386,881.00
658,945.02
888,350.84
1,172,922.55
1,519,775.82
272,064.02
229,405.82
284,571.71
346,853.27
417,036.74
658,945.02
888,350.84
1,172,922.55
1,519,775.82
1,936,812.56
739,829.60
950,953.33
1,259,167.57
1,632,712.93
2,079,828.30
TOTAL ASSETS
8,000.00
18,000.00
326,000.0
0
123,200.0
0
LIABILITIES AND
OWNERS EQUITY
LIABILITIES :
Income Tax Payable
Owners Equity
Net income
Total Equity
45
-
Decision Parameters
A. Case 0
: Normal Operation
Net Income
272,064.02
Cumulative
272,064.02
386,881.00
501,469.84
786,041.55
1,132,894.82
1,549,931.56
229,405.82
284,571.71
346,853.27
417,036.74
= 1.00
Rate of Return
ROI = Average Net income/ Initial Investment
314,773.53
314,773.53
386,881.00
ROI = 81.36%
0.8136
46
PV Factor of 1@ 10%
Formula: PV=1/(1+i)
Where, i = interest and n = year
YEAR
Y1 (2010)
Y2 (2011)
Y3 (2012)
Y4 (2013)
Y5 (2015)
Annual cash
inflows
414,548.
60
272,723.
73
369,814.24
369,814.
24
508,715.37
B. Case 1
PV of 1 @
10%
0.9091
0.8264
0.7513
0.6830
0.6209
PV of Cash
flows
376,866.
13
225,378.
89
277,841.
44
252,583.
13
315,861.
38
1,448,530.
96
386,881.
00
1,061,649.
96
47
2011
2012
2013
2014
2015
Commission Income
1,006,331.04
1,106,964.1
4
1,217,660.56
1,339,426.61
1,473,369.28
879,597.00
937,951.85
982,139.44
1,028,461.41
1,077,024.49
126,73
4.04
169,012.29
23
5,521.12
310,96
5.20
396,34
4.79
19,846.81
29,753.07
46,380.28
68,289.56
93,903.44
106,887.23
139,259.22
189,140.84
242,675.64
302,441.35
Net income
2011
2012
2013
2014
2015
126,734.04
169,012.29
235,521.12
310,965.20
396,344.79
Ceiling
70,000.00
140,000.00
140,000.00
250,000.00
250,000.00
Balance
56,734.04
29,012.29
95,521.12
60,965.20
146,344.79
20%
25%
25%
30%
30%
11,346.81
7,253.07
23,880.28
18,289.56
43,903.44
8,500.00
22,500.00
22,500.00
50,000.00
50,000.00
19,846.81
29,753.07
46,380.28
68,289.56
93,903.44
Rate
variable
Fixed
Income Tax
Pre- OP
2011
2012
2013
2014
2015
48
1,006,331.0
4
1,
106,964.14
1,217,6
60.56
1,339,4
26.61
1,006,331.0
4
1,106,964.14
1,217,660.5
6
1,339,426.6
1
1,473,369.2
8
802,997.00
876,351.85
920,539.44
966,861.41
29,7
53.07
46,3
80.28
1,015,424.4
9
68,
289.56
Commission Income
Owners Equity
386,881.0
0
386,881.0
0
1,473,
369.28
Cash Outflows
Operating
Expense(net of
Depreciation)
Income Tax
Fixed Assets
Organizational Cost
Total Cash Outflows
19,846.81
326,000.0
0
15,000.00
326,000.0
0
817,997.00
896,198.66
950,292.52
1,013,241.6
9
1,083,714.0
5
60,881.00
188,334.04
210,765.49
267,368.04
459,9
80.53
326,184.92
727,3
48.57
389,655.23
1,053,
533.49
727,348.57
1,053,533.4
9
1,443,188.7
2
60,881.00
60,881.00
249,215.04
249,215.04
459,980.53
2011
2012
2013
2014
2015
249,215.04
459,980.53
727,348.57
1,053,533.49
1,443,188.72
ASSETS
Current Assets
Cash
49
Total Current Assets
249,215.04
459,980.53
727,348.57
1,053,533.49
1,443,188
.72
300,000.00
300,000.
00
300,000.0
0
300,000.00
300,000.00
Equipment
8,000.00
8,000.00
8,000.00
8,000.00
8,000.00
18,000.00
18,000.00
18,000.00
18,000.00
18,000.00
Total
326,000.00
326,000.00
326,000.00
326,000.00
326,000.00
61,600.00
123,200.00
184,800.00
246,400.00
308,000.00
Less: Accum.
Depreciation
264,400.00
202,800.00
141,200.00
79,600.0
0
18,000.00
TOTAL ASSETS
513,615.04
662,780.53
868,548.57
1,133,13
3.49
1,461,188
.72
19,846.81
29,753.07
46,380.28
68,289.5
6
93,903.44
822,168.
29
242,675.
64
1,064,84
3.93
1,064,843
.93
302,441.3
5
1,367,285
.28
LIABILITIES AND
OWNERS EQUITY
LIABILITIES :
Income Tax Payable
Owners Equity
386,881.00
493,768.23
633,027.45
Net income
106,887.23
139,259.22
189,140.84
Total Equity
493,768.23
513,615.04
633,027.45
822,168.29
662,780.53
868,548.57
1,133,133.49
1,461,188.72
Decision Parameters
A. Case 1 : Gross Income Decreased by 10%
1. Projected Payback Period
Year
1 ( 2010)
2 ( 2011)
x
Net Income
106,887.23
139,259.22
Cumulative
106,887.23
246,146.45
386,881.00
50
3 ( 2012)
4 ( 2013)
5 (2014))
189,140.84
242,675.64
302,441.35
435,287.29
677,962.93
980,404.28
= 5.2
196,080.86
386,881.000
0
ROI = 50%
0.5068
Y1 (2010)
Y2 (2011)
Y3 (2012)
Annual cash
inflows
188,334
.04
210,765
.49
PV of 1 @
10%
0.9091
0.8264
0.7513
PV of Cash flows
171,21
4.48
174,17
6.60
200,87
51
267,368.04
267,368
.04
Y4 (2013)
Y5 (2015)
389,655.23
3.61
182,61
2.37
241,93
6.93
970,81
3.99
386,88
1.00
583,93
2.99
0.6830
0.6209
Table 25
C. Case 2
Particulars
2011
2012
2013
2014
2015
Commission Income
1,118,145.60
1,229,960.1
6
1,352,956.18
1,488,251.79
1,637,076.97
831,677.00
1,022,735.8
5
1,070,854.64
1,121,304.37
1,174,201.59
286,46
8.60
207,224.31
28
2,101.53
366,94
7.42
462,87
5.38
60,940.58
39,306.08
59,630.46
85,084.23
113,862.61
225,528.02
167,918.23
222,471.07
281,863.19
349,012.77
Net income
52
2011
2012
2013
2014
2015
286,468.60
207,224.31
282,101.53
366,947.42
462,875.38
Ceiling
250,000.00
140,000.00
250,000.00
250,000.00
250,000.00
Balance
36,468.60
67,224.31
32,101.53
116,947.42
212,875.38
30%
25%
30%
30%
30%
variable
10,940.58
16,806.08
9,630.46
35,084.23
63,862.61
Fixed
50,000.00
22,500.00
50,000.00
50,000.00
50,000.00
60,940.58
39,306.08
59,630.46
85,084.23
113,862.61
Rate
Income Tax
Pre- OP
2011
2012
2013
2014
2015
Cash Inflows
Commission Income
Owners Equity
Total Cash Inflows
1,118,145.60
1,229
,960.16
1,352,956.
18
1,488,251.
79
1,637,076.
97
386,881.00
386,881.00
1,118,145.60
1,229,960.16
1,352,956.18
1,488,251.79
1,637,076.97
961,135.85
1,009,254.64
1,059,704.37
1,112,601.59
Cash Outflows
Operating
Expense(net of Depreciation)
755,077.00
Income Tax
Fixed Assets
Organizational Cost
Total Cash Outflows
60,
940.58
39,306.
08
59,630.
46
85,084.
23
326,000.00
326,000.00
15,000.00
770,077.00
1,022,076.43
1,048,560.72
1,119,334.83
1,197,685.82
53
Net Cash Flows
Add: Cash Balance
Begenning
60,881.00
207,883.73
348,068.60
60,881.00
60,881.00
408,949.60
304,395.46
408,
949.60
616,833.33
368,916.96
616,833.
33
921,228.79
921,228.
79
1,290,145.74
439,391.15
1,290,145.
74
1,729,536.90
2011
2012
2013
2014
2015
408,949.60
616,833.33
921,228.79
1,290,145.74
1,729,536.90
921,228.7
9
1,290,14
5.74
1,729,53
6.90
300,000.0
0
300,000.
00
300,000.0
0
ASSETS
Current Assets
Cash
408,949.6
0
616,833.33
300,000.0
0
300,000.0
0
Equipment
8,000.00
8,000.00
8,000.00
8,000.00
8,000.00
18,000.00
18,000.00
18,000.00
18,000.00
18,000.00
Total
326,000.00
326,000.00
326,000.00
326,000.00
326,000.00
61,600.00
123,200.00
184,800.00
246,400.00
308,000.00
Less: Accum.
Depreciation
54
Net Book Value
264,400.0
0
202,800.0
0
141,200.0
0
79,600.0
0
18,000.0
0
TOTAL ASSETS
673,349.6
0
819,633.3
3
1,062,428.
79
1,369,74
5.74
1,747,53
6.90
60,940.58
39,306.08
59,630.46
85,084.2
3
113,862.6
1
780,327.2
5
222,471.0
7
1,002,798.
33
1,002,79
8.33
281,863.
19
1,284,66
1.52
1,284,66
1.52
349,012.
77
1,633,67
4.28
LIABILITIES AND
OWNERS EQUITY
LIABILITIES :
Income Tax Payable
Owners Equity
Net income
Total Equity
386,881.0
0
225,528.0
2
612,409.0
2
673,349.6
0
612,409.02
167,918.23
780,327.2
5
819,633.33
1,062,428.79
1,369,745.74
1,747,536.90
Decision Parameters
C. Case 2 : Normal Operation
1. Projected Payback Period
Year
1 ( 2010)
x
Net Income
225,528.02
2 ( 2011)
3 ( 2012)
4 ( 2013)
5 (2014))
167,918.23
222,471.07
281,863.19
349,012.77
Cumulative
225,528.02
386,881.00
393,446.25
615,917.33
897,780.52
1,246,793.28
= 12.84
55
X+ 12.84X = 25.68+ 1.0
13.84X = 26.68
X= 2 years
Rate of Return
0.6445
ROI = 64%
0.64
YEAR
Y1 (2010)
Y2 (2011)
Y3 (2012)
Y4 (2013)
Y5 (2015)
Total Present Value of Cash
Inflows
Less: Cost of Investment
Annual cash
inflows
348,06
8.60
207,88
3.73
304,395.46
304,39
5.46
439,391.15
PV of 1 @
10%
0.9091
0.8264
0.7513
0.6830
0.6209
PV of Cash flows
316,4
29.16
171,7
95.11
228,6
92.31
207,9
02.10
272,8
17.97
1,197,6
36.65
386,8
81.00
56
Table 29
D. Case 3
810,7
55.65
2011
Particulars
2012
2013
2014
2015
Commission Income
1,006,331.04
1,106,964.14
1,217,660.56
1,339,426.61
1,473,369.2
8
831,677.00
1,022,735.85
1,070,854.64
1,121,304.37
1,174,201.5
9
174,6
54.04
84,228.29
146,805.92
218,122
.24
299,1
67.68
31,163.51
11,345.66
24,201.48
45,936.67
64,750.30
143,490.53
72,882.64
122,604.44
172,185.57
234,417.38
Net income
2011
2012
174,654.04
84,228.29
Ceiling
140,000.00
Balance
Rate
variable
2013
2014
2015
146,805.92
218,122.24
299,167.68
70,000.00
140,000.00
140,000.00
250,000.00
34,654.04
14,228.29
6,805.92
78,122.24
49,167.68
25%
20%
25%
30%
30%
8,663.51
2,845.66
1,701.48
23,436.67
14,750.30
57
Fixed
Income Tax
22,500.00
8,500.00
22,500.00
22,500.00
50,000.00
31,163.51
11,345.66
24,201.48
45,936.67
64,750.30
Pre- OP
2011
2012
2013
2014
2015
Cash Inflows
Commission
1,006,331.0
4
Income
Owners Equity
386,881.0
0
386,881.0
0
1,1
06,964.14
1,006,331.04
1,106,964.14
755,077.00
961,135.85
1,217,6
60.56
1,339,4
26.61
1,217,660.5
6
1,339,426.6
1
1,009,254.6
4
11,3
45.66
1,059,704.3
7
24,2
01.48
1,473,
369.28
1,473,369.2
8
Cash Outflows
Operating
Expense(net of
Depreciation)
Income Tax
Fixed Assets
Organizational Cost
Total Cash Outflows
31,163.51
1,112,601.59
45,
936.67
326,000.0
0
-
15,000.00
326,000.0
0
770,077.00
992,299.36
1,020,600.3
0
1,083,905.8
5
1,158,538.2
7
60,881.00
236,254.04
114,664.78
197,060.26
411,7
99.82
255,520.76
608,8
60.08
314,831.01
864,
380.84
608,860.08
864,380.84
1,179,211.85
60,881.00
60,881.00
297,135.04
2
97,135.04
411,799.82
58
2011
2012
2013
2014
2015
ASSETS
Current Assets
Cash
297,13
5.04
297,135.04
411,799.82
411,799.82
60
8,860.08
864,38
0.84
1,179,211
.85
608,860.08
864,380.84
1,179,211.85
300,000.00
300,000.00
8,00
0.00
18,00
0.00
326,00
0.00
246,40
0.00
300,000.00
8,000
.00
18,000
.00
326,000
.00
308,000
.00
TOTAL ASSETS
300,000.00
8,00
0.00
18,00
0.00
326,00
0.00
61,60
0.00
300,000.00
264,400.00
202,800.00
141,200.00
79,600.00
18,000.00
561,535.04
614,599.82
750,060.08
943,980.84
1,197,211.85
31,163.51
11,345.66
24,201.48
45,936.67
64,750.30
603,254.17
725,858.60
898,044.17
8,000.00
18,000.00
326,000.00
123,200.00
8,000.00
1
8,000.00
32
6,000.00
18
4,800.00
LIABILITIES AND
OWNERS EQUITY
LIABILITIES :
Income Tax Payable
Owners Equity
386,881.00
530,371.53
59
Net income
Total Equity
72,882.64
143,490.53
530,371.53
561,535.04
122,604.44
172,185.57
234,417.38
603,254.17
725,858.60
898,044.17
1,132,461.55
614,599.82
750,060.08
943,980.84
1,197,211.85
Decision Parameters
C. Case 3 : Combination of 1 and 2
1. Projected Payback Period
Year
1 ( 2010)
2 ( 2011)
3 ( 2012)
x
4 ( 2013)
5 (2014))
Net Income
143,490.53
72,882.64
122,604.44
Cumulative
143,490.53
216,373.17
338,977.60
386,881.00
511,163.17
745,580.55
172,185.57
234,417.38
= 2.3
X= 1.4 years
Rate of Return
0.6445
60
ROI = 64%
0.64
Y1 (2010)
Y2 (2011)
Y3 (2012)
Y4 (2013)
Y5 (2015)
Total Present Value of Cash
Inflows
Less: Cost of Investment
Net Present Value of the
Project (Positive)
Annual cash
inflows
236,25
4.04
116,39
7.49
199,848.84
199,84
8.84
320,331.01
PV of 1 @
10%
0.9091
0.8264
0.7513
0.6830
0.6209
PV of Cash flows
214,7
78.55
96,1
90.88
150,1
46.44
136,4
96.76
198,8
93.52
796,5
06.15
386,8
81.00
409,6
25.15
61
Payback Period
1.5 years
1.8 years
2 years
1.4 years
Return on Investment
81.36 %
50%
64%
64%
Return on Investment
Normal operation ( Case 0) shows 81.36% Return on Investment, while
50%, 64%, 64% for Case 1, 2 and 3 respectively.
Payback Period
Case (0) shows that a 386,881.00 investment can be recovered in 1.5
years . While case 1,2, and 3 be recovered in 1.8, 2 and 1.4 years respectively.
62
PART 7: SOCIO-ECONOMIC
7.1 Brief Introduction
The socio-economic impact of the project will be established clearly to
determine the benefits that would be just to the various stakeholders of the
business. Aside from being viable, the project should also focus on the social
and other economic benefits. This part of the study of the study details the socio
economic contribution of the project to the people of Zamboanga, to the City
Government and other beneficiaries.
As Philippines is concerned, Filipinos` ethical standards are very high.
Even the advanced western nations have much to learn from the Philippine
philosophy.
But business
63
the pillars of the business, b.) Consumers and c.) government, the representative
of the community.
Workers are indeed, the pillars of the business ; they are important part of
the organization to which they belong.
keep them satisfied and gave them their due, for instance, the ethics of salaries
and wages dictate that an employee is entitled to be paid for his productivity.
The wages must be fair so that the labor might be in a position to enjoy a civilized
living.
Distribution is meant for consumption, and hence the satisfaction of the
consumers should be the primary concern of the proposed business.
It is really
the pious right of the consumers to have greater, better and cheaper goods, and
it is the responsibility of the proposed business to fulfill their ambition.
Government is the guardian of the community.
Bureau of Internal Revenue`s rules and regulations and will pay all taxes on time.
The proposed business`s vision enshrines the proponent long-held
philosophy of Profit with Honor (PH) and Unity with Zeal (UZ) .
The proposed
business will generate wealth and profit for its owner at the same time fulfill the
proponent responsibilities and commitments to the customers, employees,
suppliers, sales agents, government and environment.
7.2 Tangible Contributions
7.2.1 Income Tax Generation
64
The project under normal operation gives benefit to the local government through
income taxes.
An average income tax of P 97,136.9906 per year, this can be
used for the government projects such as hospitals, roads, schools and other
infrastructure projects.
7.2.2 Employment Generation
This project employs ten (4) personnel to earn additional income and
uplift their living conditions.
Intangible Contributions
The business establishment will be known as socially responsible
activities. It will help retail stores particularly sari sari store to have convenience
in the selling of the products near the homes of the end users.
65
66
and
support
this
project.
To ensure
its
success
and
endure
67
68
In case 1 when revenue is decreased by 10% the ROI is reduced to 50% and
can be fully recovered for 1.8 years. The positive NPV of 583,932.99, suggests
that the project is still acceptable, generally, the venture is still profitable and
liquid.
In case 2 when operating expenses is increased by 10% , the ROI is
reduced to 64% and can be fully recovered for 2 years . The positive NPV of
810,755.65 suggests that the proposed project is acceptable. As a whole , the
venture is profitable and liquid.
In Case 3, when the worst case scenario would happen which means that
the operating expense is increased by 10% and revenue is decreased by 10%,
the ROI is reduced to 64 % and can be recovered for 1.4 years. The positive
NPV of 409,655.15 still suggests that the project is acceptable.
69
Philippine Government.
1
70
working hours.
9
10
procedures.
11
13
71
REFERENCES
1.
2.
3.
4.
5.
Manage Your Time, Manage Your Work, and Manage Yourself, by: Merrile
E. Douglas and Donna N. Douglas
6.
7.
8.
9.
10.
11.
12.
13.
72
CURRICULUM VITAE
73
Position
Instructor
Agency Connected
Universidad de Zamboanga
Personal
1.
Name
AHMAD A. ALAWADDIN
2.
Sex
Male
3.
Age
35 years old
4.
Civil Status
Single
5.
Citizenship
6.
Place of Birth
Jolo Sulu
7.
Date of Birth
July 7, 1974
8.
Religion
Islam
9.
City Address
10.
Languages
Spoken
11.
Name of Father
12.
Name of Mother
Educational
Background
Graduate
College
Universidad de Zamboanga
2010
Master in Business Administration
Zamboanga City
MEIN College, Inc.
2002
Bachelor of Science in Commerce
Zamboanga City
74
High School
: J-Jireh School
1992
Suterville, Zamboanga City
John Spirig Sr. Memorial Elem. School
Campo Islam , Zamboanga City
Civil Service Professional Eligibility
Elementary
14. Eligibilities
:
Rating: 80.98 %