revised aspects 3

8/9/2019 Revised Aspects 3

1/81

EXECUTIVE SUMMARY

Camote Snack Bar, which is the proposed product, is intended towardshelping parents in providing their children while in school a much healthier snackitem. It is of varying ingredients made up of the healthy vegetable which is the

camote. With the abundance of benefits that people can obtain from thisvegetable, the researchers perceived the opportunity to conduct this study on !roposed !roduction of Camote Snack Bar and its "istribution to Selected!rivate #lementary and Secondary School Canteens in Cebu City.$

%or the proposed pro&ect, the proponents recommend the soleproprietorship form of business organi'ation. (he sole proprietor will finance theinitial capital re)uirement since the proposed pro&ect is a small scale business.(he initial capital re)uired is ! *+,-/.// which will be used to defrayproduction cost and operating e0penses. (he prospective owner will take on theduties of a manager and cashier. (he business will also employ one 12bookkeeper who will receive a retainer3s fee of !hp *,///.// per month, one 12

helper4delivery man and two 1*2 production workers who will each be paid at adaily rate of !hp *-/.//. (he employees will also be provided with variousbenefits such as SSS, !hilhealth, !56IBI5 and 7 thmonth pay.

(he pro&ect intends to market its product to all students in privateelementary and secondary schools in Cebu City. (wenty 1*/2 private schoolcanteens in Cebu City were identified by the proponents and si0teen 182responded to the survey. Survey results showed that there is a demand for theproduct. (he price will be at !hp 8/.// per pack for / pieces. (he term of salewill be consignment as preferred by the target market

(he proposed production area will be in (res de bril Street, 9abangon,Cebu City. (his location is recommended for this business because it is within

Cebu City which is the target of the pro&ect and is also accessible to its mainsource of raw materials which are camote, all6purpose flour, baking powder,baking soda, sugar, among others.

(he proposed pro&ect would be re)uired to register at "(I, BI:, SSS;embership, !hil


2/81

CHAPTER II

TECHNICAL ASPECT

(he technical aspect is the discussion of the basic structure and operation

flow of the pro&ect. It is one of the essentials of the study because this factor

responds to the technicalities and basic structure of the proposed study. (his

includes the description of the nature of the business, the kind of products

produced, and the significant factors that could help prevent losses commonly

caused by technical incompetence. (his provides the ways and means by which

a product may be done efficiently and effectively. Strategies are substantially

planned to minimi'e cost and to avoid miscalculations. It needs careful and

thorough e0amination as it is indispensable to the success of the business

operation and would affect the viability as well as the profitability of the entity.

(his chapter aims to choose the procedures to be used, layout, structural

design, materials and other technical factors that would minimi'e cost and

ma0imi'e profit.

!:>"?C( "#SC:I!(I>@


3/81

vitaminsA manganese, copper, potassium, iron, itamin #, C, B8, B*, and . It3s

like a combination of rice and vegetables in a single package. lso, it is high in

dietary fiber and low fat content good for the heart and tummy and good for

diabetics.

Camote snack bar intends to provide teenagers and children healthy fun

snack which would combat their hunger in between meals throughout their

tedious study loads.

!:>"?C(I>@ %9>W

!roduction flow involves a series of links in a production chain. It is very

important for the entrepreneurs to identify these processes that add value

enabling them to enhance these processes to the on6going benefit of their

business. Below are the procedures to be followed. flowchart is shown on page

-.

. Purchasing of Raw Materials

(he proponents advised that the gathering of the camote will be on

Saturdays before a week of operation and be stored in the storage area at

a room temperature.

2.

2.

Figure 1


4/81


5/81

In the bowl of a stand mi0er fitted

with the paddle attachment combine

the eggs, washed sugar, vegetable

oil and mashed camote on medium

speed until light and fluffy.

6.

Mixing of Dry ngredients

In a large bowl, whisk together the

sifted flour, baking powder, baking

soda, iodi'ed salt and potassium

sorbate.

D%or every */ pieces of camote snack bars, + eggs, * cups mashed

camote, E cup vegetable oil, *47 cups washed sugar,* cupsall6purpose

flour, * teaspoons baking powder, teaspoon baking soda, teaspoon

iodi'ed salt are needed. !otassium sorbate is also added. (he above

measurements must be coupled */ times to produce +// pieces in a

single batch.

Figure 5

Figure 6


6/81

!. Preheating the "#en at $!%& ' for %

minutes

(. Placing of Cut )lacine on the )reased

Molder

Cut the glacine paper into - 0 7

inches. Simultaneously, grease the molders with butter.

Figure 8

*. Preparing the

Batter

?sing stand mi0er, mi0 the

dry

ingredients into the camote mi0ture until &ust combined. "o not over mi0.

!our half of 47 cup of the batter into the greased molder, then put a

considerable amount of chocolate bar before pouring the other half.

Sprinkle the local vermicelli.

Figure

Figure !


7/81

+,. Ba-ing

Bake for *-67/ minutes at 7F-G %.

(ransfer to a wire rack and allow to cool down completely.

Figure 1"

++. Pac-aging and ealing!ack and seal the camote snack bars using polypropylene and a plastic

impulse sealer.

Figure 11


8/81

Figure 12

Pr#$u%&i#' F(#)%*+r&


9/81

:W ;(#:I9S

>ne important consideration that consumers look into is the ingredients

that compose the product. It is apparent that the ingredients will determine the

nutritional value of the product.

Sweet potato, commonly known as Camote$ is the main ingredient of the

product. (here is an abundant supply of camote since the root crop grows on

!hilippine soil. It will be purchased at the Carbon ;arket. (he secondary

ingredients include all6purpose flour, baking soda, baking powder, iodi'ed salt,

washed sugar, local vermicelli, chocolate filling and eggs. !otassium sorbate is

added to preserve the product. (hough they are readily available from

supermarkets, they will be bought from wholesale dealers near Carbon ;arket to

save costs.

#H?I!;#@( @" (>>9S

itchen utensils and e)uipment have essential roles in the production

process. (hese will speed up the progress of operation.

,i&%*e' Su--(ie

(hese include apron, chopping board, ladle, cooking pot, hairnet, kitchen

knife, weighing scale, kitchen towel, measuring cups, measuring spoons,

molders, baking pan, spoon, fork, pot holder, wooden spatula, and strainer.

C(e+'i'g u--(ie

Include rags, brooms, dustpans, garbage cans, floor mop, furniture polish,

dishwashing li)uid and sponge.

/00i%e u--(ie


10/81

>ffice supplies include ball pen, short bond paper, calculator, fastener,

folder, &ournals, log book, pencil, marker, puncher, receipts, scissors, scotch tape,

staple wire, and stapler.

P+%+gi'g u--(ieInclude glacine, polyethylene, and polypropylene. (he polyethylene and

polypropylene including the design shall be ordered from Williams Commercial

Company Inc. located at *F #dison Street, 9ahug Cebu City.

Pr#$u%&i#' Eui-e'&

Includes gas stove, oven, refrigerator, stand mi0er, chiller, plastic impulse

sealer, weighing scale, food containers, and stand fan.

e(ier Eui-e'&

(his will be used in transporting the finished products. "elivery e)uipment

shall include trike.

Fur'i&ure +'$ Fi7&ure

(he proposed pro&ect needs filing cabinet, fire e0tinguisher, office chair,

office table, production chair and production table for filing and storing papers

and for all other business purposes.

!:>"?C(I>@ SC


11/81

;onday to %riday.

T+(e 1

T+ +'$ T+ Tieuri'g M#'$+ Fri$+

T+

T+ &iei' 1

%#-(e&e-r#%e i'

i'u&e

N#. #0Pr#%ee i' + $+

T#&+(A((#&&e$

T+ Tiei' i'u&e

.2 Washing of camote - * /

*.2 Boiling of camoteD Cutting of glacine

7/ * 8/

7.2 Cooling down - * /

+.2 !eeling and mashing ofboiled camote

7/ * 8/

-.2 !reparing the camote mi0ture 7/ * 8/

8.2 ;i0ing of dry ingredients / * */

.2 !reparing the batterD!reheating the oven 1- mins.2

*- * -/

K.2 Baking D !lacing of cut glacine on thegreased molders

-/ * //

/.2 !ackaging and Sealing +/ * /

(otal task time in minutes **- * +-/

Break (ime / * */

ddA / minutes the production

can afford a delay

/

(otal task time in minutes +/

"ivide 8/

Working hours a day

"aily estimated production by * employees is estimated to produce //


12/81

pieces. >ne batch of production is e)uivalent to + hours and it can produce +//

pieces of camote snack bar.

day L hours4+ hours

L * batches 0 +// pieces

L // pieces per day

(he table below shows the annual production capacity of the business.

T+(e 2

Pr#$u%&i#' C+-+%i&

Pr#$u%&i#' C+-+%i& Per +9i' -ie%e: U'i& Pr#$u%e$

4"" -ie%e -er +&%* 7 2 +&%*e -er $+8""

Mu(&i-( &*e 'uer #0 )#ri'g $+ i'+ e+r

952 )ee 7 5 $+ -er )ee:26" $+

A''u+( Pr#$u%&i#' C+-+%i& 2"8;""" -ie%e"?C(I>@ 9>C(I>@

Several factors are to be ade)uately considered in choosing a plant si'e.

(he ideal workplace must be located where minimum cost of production and

distribution possible. clean and uncontaminated surrounding must also be

considered since the business is into food products. %urthermore, pro0imity of

raw materials and target market, availability of utilities, lease rate and many more

shall be considered in selecting the production site.

(he proposed production site is recommended to be located at 7776-

(res de bril Street, 9abangon, Cebu City. It is only /6- minutes away from the


13/81

suppliers of raw materials. It is a favorable area since the water and electricity

supply is abundant. In addition, telecommunication service of !9"( is very

favorable to the proposed site. (he location is also very accessible since it is

only along the road. But most importantly, the proposed site is only a short

distance away from the target market of the business which is the private school

elementary and secondary school students of Cebu City. (he rent for the

production location is !8,/// per month. %igure below shows the location map of

the proposed production site.

Figure 13L#%+&i#' M+-

Pr#$u%&i#' L+#u&9ayout design concerns the physical placement of resources such as

e)uipment and storage facilities. 9ayout design is important because it can have

a significant effect on the cost and efficiency of an operation and can entail

substantial investment in time and money.(he workplace needs a total area of / meters by / meters which is

considered enough to be the production area. %igure below shows the production

site layout of the proposed business.


14/81

Figure 14Pr#$u%&i#' L+#u&

?(I9I(I#S

?tilities are basic necessities that must be considered in every business

undertaking. (he type of utilities needed depends upon the si'e and nature of the

business. !roduction activities cannot be made possible without the use of

utilities. (he following are the utilities needed for the business.

>+&er

Water supply plays a vital role in business operations especially in the

daily activities of the business. !rocesses involving the production of raw

materials to finished products involve water especially in the cleaning and

washing of utensils and e)uipments used in the production of camote snack bar.


15/81

Water will be provided by ;etropolitan Cebu Water "istrict 1;CW"2. (his

water supply has been checked and approved by the "epartment of 2.

Te(e-*#'e

Communication is important in the daily activities of the business since it

provides means to have regular communication with the suppliers and

customers. !hilippine 9ong "istance (elecommunication 1!9"(2 will be the

provider of communication line of the proposed pro&ect.

WS(# "IS!>S9 ;@5#;#@(

side from the economic benefits this study has to offer, there are wastes

that need to be disposed of properly. (hese wastes may come from the

materials and ingredients necessary for the production of the camote snack bars.

(hese include the followingA

S)ee& P#&+ Pee(

Sweet potato peels need not be disposed of. (hey can be recycled and


16/81

there are many ways on how to do so. (hese can be made into sweet potato

skin crisps. (hese peels can also be sold at a low cost to companies or

businesses using sweet potato peels in their operations.

>+&er

%or the waste water generated after the washing of raw material, this will

be disposed through the drainage system of the building rented.

P(+&i% +&eri+( +'$ #&*erIn this proposed pro&ect, trash bins will be situated inside and outside the

production area. !lastic or paper bags should outline the inside of the trash bins

for easy disposal and to prevent unwanted odors. 5arbage will also be

segregated accordingly. %or biodegradable waste, a compost pit will be dug at

the back of the production site. %urthermore, there will be proper segregation for

non6 biodegradable waste products, which are regularly collected by the

barangay garbage truck.

CHAPTER VI

FINANCIN? ASPECT

;oney is an essential element in the formation of new businesses. (his

allows them to take advantage of opportunities to grow, employ local workers and

in turn support other businesses and local government through the remittance of

income ta0es.


17/81

(he financing aspect helps the management to determine the initial capital

needed in the establishment to initially implement and to sustain the regular

operations of the business.

S#ur%e #0 Fi'+'%i'g

Since the form of business to be adopted is a sole proprietorship, the

funds will be provided by the sole proprietor.


18/81

>#ri'g C+-i&+(

:aw ;aterials @ote F +,-.//

!ackaging Supplies @ote F,7K.//

>ffice Supplies @ote K ,*--.//

Cleaning Supplies @ote / -.//

:ent #0pense @ote *,///.//

Salaries #0pense @ote * -,///.//

!rofessional %ee

#0pense@ote 7 *,///.//

?tilities #0pense @ote + F,///.//

dvertising #0pense @ote - *,*-/

Communication #0pense @ote 8 ,F/.// KF,+F.//

T#&+( P 241;58".""

N#&e 1

Pr#e%& Fe+ii(i& C#&

e%ri-&i#' T#&+( A#u'&

#ncoding and !rinting ! //.//

Bookbinding and !hotocopy ,///.//

(ransportation ,///.//

9etterhead 7-.//

Bond !aper 7//.//

White #nvelope with 9etterhead 7/.//

!roduct #0perimentation 8//.//

%ree taste Sampling *-/.//

%ood 1:esearcher and !anelist2 8//.//

5rammar test *//.//


19/81


20/81

Chiller unit */,///.// */,///.//

!lastic ImpulseSealer

* units ,-/.// *,7//.//

Weighing Scale * units //.// *//.//

%ood Containers + pcs. -/.// 7,+//.//

Stand %an unit ,F//.// ,F//.//

T#&+( P";5"".""

N#&e 4

Fur'i&ure +'$ 0i7&ure

e%ri-&i#' Bu+'&i& U'i& C#& T#&+( A#u'&

!roduction (able * units *,///.// +,///.//

>ffice (able unit ,///.// ,///.//

!lastic Chairs + pcs. //.// +//.//

%ire #0tinguisher * units *,///.// +,///.//

#0haust %an unit ,*//.// ,*//.//

Wall %an * units -/.// 7//.//

(ray :ack * trays K//.// ,//.//

T#&+( P 12;"".""

N#&e 5

C##i'g u&e'i(

e%ri-&i#' Bu+'&i& U'i& C#& T#&+( A#u'&

Baking !an / pcs. F/.// ! F//.//

;oulders *// pcs. /.// *,///.//

Cooking !ot * pcs. ,*/.// *,*+/.//

Washbasin * pcs. *//.// +//.//


21/81

;i0ing Bowl *pcs. /+K.// *,/K.//

!eeler * pcs. 8/.// */.//

Spatula * pcs. F/.// +/.//

itchen nife * pcs. -/.// //.//

;easuring cups * sets 8-.// 7/.//

;easuring spoons * sets -/.// //.//

Spoons - pcs. /.// -/.//

%ork - pcs. /.// -/.//

9adle * pcs. +/.// /.//

Strainer pc. -/.// -/.//

!otholder * pcs. *-.// -/.//


22/81

N#&e 6

e(ier Eui-e'&

e%ri-&i#' Bu+'&i& U'i& Pri%e T#&+( A#u'&

(rike unit +/,///.// P 4";""".""

N#&e 8

N#&e

R+) M+&eri+(

e%ri-&i#' Bu+'&i& U'i& C#& T#&+( A#u'&

#ggs /F trays */.// *,+/.//

Washed Sugar *F/ kilos +.// *,K8/.//

egetable >il +/ kilos 8/.// *,+//.//

Camote K8 kilos -.// *,K+/.//

ll !urpose %lour **+ kilos +-.// /,//.//

Baking !owder kilos 8/.// +/.//

Baking Soda + kilos 7-.// +/.//

Iodi'ed Salt + kilos -.// 8/.//

Butter */ bars 78.// F*/.//

Chocolate filling +/ kilos *-.// -,///.//

9ocal ermicelli4;i0Color

*/ kilos *-.// *,-//.//

!otassium Sorbate + kilos F*.// *.//P 48;158.""


23/81

P+%+gi'g Su--(ie


5lacine -F.* packs /.// -F*.//

!olypropylene 8 rolls +//.// 8,+//.//

!olyethylene * rolls +77.- 8F

(otal P ;83!.""

N#&e !

/00i%e Su--(ie


Bond !aper ream -/.// ! -/.//

Columnar @otebook - pcs. */.// //.//

Ball pen / pcs. -.// -/.//

!encils 8 pcs. 7.// .//

Stapler unit -.// -.//

Staple Wires bo0 -.// -.//

Cellophane (ape pcs. *.// 8.//

Inventory ControlSheet

* pads 8-.// 7/.//

"elivery Sheet + pads F/.// */.//

>rder Sips pad K.// K.//

Calculator unit 7/.// 7/.//

T#&+( P 1;255.""

N#&e 13

Pr#0ei#'+( Fee E7-e'e

(he professional fee for the bookkeeper3s monthly retainer3s fee is

P 2;"""."".


24/81

N#&e 14

U&i(i&ie E7-e'e

e%ri-&i#' T#&+( A#u'&

%uel #0penses ! ,+//.//

9!5 //.//

9ight and !ower +,///.//

Water //.//

T#&+( P ;""".""

N#&e 16

C#u'i%+&i#' E7-e'e


;obile !hone unit ,///.// ! ,///.//

Sun Sim Card */.//

9oad 1Sun2 -/.//

N#&e 15

A$er&ii'g E7-e'e

e%ri-&i#' T#&+( A#u'&

!osters -//.//

%ree (asting ,F-/.//

T#&+( P 2;25".""


25/81

T#&+( P 1;1".""

CHAPTER ii

FINANCIAL ASPECT

>ne of the primary purposes of engaging in a business venture is to earn.

(hus, it is very significant to pro&ect the financial aspect of the proposed

undertaking. (he financial aspect )ualifies the result of the marketing, technical,

management, ta0ation, and legal phases and e0presses in peso terms the

possible profitability of the proposed pro&ect.

(o carefully e0amine the financial progress of this proposed business and

to effectively come up with the pro&ected financial statements, a series of

assumptions are made. (his aspect is accomplished with forecasts and practical

conservative assumptions.

5#@#:9 SS?;!(I>@S


26/81


27/81

/. (he rent e0pense is sub&ect to -= creditable withholding ta0 per month.

. :etainer3s fee will remain constant for the ne0t - years.

*. (here will be no additional employees for the ne0t - years.

7. Sales are on consignment basis. (hus, unsalable goods in the custody

of school canteen operators shall be included in the consignor3s

inventory.

+. ll purchases are on a cash basis.

-. Cost of raw materials will increase by * = per year starting in the

second year.

8. ?tilities #0penses will increase by *= annually and allocated as followsA

!roduction>verhead

dministrative Selling

#lectricity /= */=

Water /= */=

%uel /= K/=

9!5 //=

F. :epairs and maintenance will start on the second year. !rovisions for

the repairs and maintenance of delivery vehicle, oven, stand mi0er and

refrigerator will be -= of their cost and will increase by -= per year and

allocated as followsA

!roduction >verhead Selling

"elivery ehicle */= /=

>ven //=

:efrigerator //=

Stand ;i0er //=

Chiller //=

. !romotion will be done annually and increased by *= e0cept for free

tasting.


28/81

K. ll fi0ed assets are assumed to have no salvage value.

*/. Straight line method of recording depreciation will be utili'ed and the

allocation for depreciation are as followsA

!roduction >verhead dministrative Selling

>ven //=

:efrigerator //=

Stand ;i0er //=

"elivery ehicle */= /=

Chiller //=

*. (he estimated useful life of the noncurrent assets are as follows

**. (he cost of purchasing gas stove, plastic impulse sealer, weighing scale,

food containers, stand fan, production table, office table, plastic chairs, fire

e0tinguisher, e0haust fan, wall fan and tray rack shall be e0pensed outright.*7. @o additional furniture and fi0tures to be purchased for the ne0t five years.*+. (he prices of cleaning, and office supplies and cooking utensils will

increase by *= annually.

*-. ?nits process during the day should be finished within the same day, thus

there will be no work in process inventory.

*8. (he 7thmonth pay shall be e)ual to one 12 month basic salary.

*F. #mployees will be given SSS, !


29/81

compensation of each employee will not reach the amount !hp

*/,///.// in pursuance to : K-/+.

*K. (he following items for the last month of the year will be accruedAa. SSS Contributionb. !hilutright #0penses are charged to dministrative #0pense

during the first year of operation.

33. !ercentage (a0 is 7= based on gross sales.

PR/ECTE STATEMENT /F FINANCIAL PERF/RMANCE

F#r &*e e+r e'$e$ e%eer 31; 2"15@2"1!

2"15 2"16 2"1 2"18 2"1!

Sales * F*,/

//,78*,

8,+,

K-,8*-,

/K,FF+,8

K9essA Cost of

Sales 7 -KK,*+7,/--,/

/,*/,KF

*,K+,7-

K ,*F,F

F*

5ross !rofit*,F

-F7/F,

/878F,*

*7+7/,F

-/-/*,

+F

9essA >perating

#0penses/

8,+FK

7+,-

7-,87*

7F,7/

7,/8

Ne& I'%#e12;28

12;!48

231;5!"

2!3;44!

364;832


30/81

STATEMENT /F FINANCIAL P/SITI/NA #0 e%eer 31; 2"15@2"1!

S%*e$u(e

2"15 2"16 2"1 2"18 2"1!

ASSETS

Curre'& Ae&

Cash8*,+

8F*+K,K

8F7+-,-

K+-7,*

/F-,K*

/

:aw ;aterials Inventory - *,88- 7,/8 -,/- 8,+/K F,K

T#&+( Curre'& Ae&F-,

7*87,F

F778/,8

+*+8K,8

F-KK,

N#'@ Curre'& Ae&

"elivery ehicle, net 7/7F,88

F77,88

F*K,88

F*-,88

F*,88F

Stand ;i0er7

7,*-/

/,*-/

F,*-/ +,*-/,*-/

>ven 7* F,88F

7,88F

K,88F -,88F ,88F

:efrigerator 77 8,7 +,F7 7,77 ,K7

-7

Chiller 7+,-+

*8,/+

*7,-+

*,/+

*,-+*

T#&+( N#'@Curre'& Ae&K7,7/

F,+/

87,-/

+,8/

77,F/


31/81

T/TAL ASSETS268;4

4"342;1

81424;1

51518;2

25633;51

!

S%*e$u(e

2"15 2"16 2"1 2"18 2"1!

LIADILITIES AN/>NERS EBUITY

Curre'& Li+i(i&ie

ccrued !hilhealth + ,*// ,*// ,*// ,*// ,*//

ccrued !56IBI5 +7 8// 8// 8// 8// 8//

ccrued SSS +- ,-K/ ,-K/ ,-K/ ,F+8 ,F+8ccrued ?tilities - -,7F +,K*/ -,/++ -,F -,*8/

ccrued !ercentage (a0 + 7,*/ 7,+8- 7,F*/ +,/87 +,+7F

Withholding ta0 payable *8 *,F// 7,8// 7,8// 7,8// 7,8//

T#&+( Curre'& Li+i(i&ie+,-

-,7F

--,F-

+8,7

/ 8,+*

/)'er Eui&

>wnerNs #)uity*+,-

/*-7,

-7*8,

/8+/,7

KF-/,+

-

ddA @et Income *,*F

F*,K+

*7,-K/

*K7,++K

78+,7*

9essA Withdrawal6

1//,///2

1-/,///2

1*//,///2

1*-/,///2

T#&+( /)'er Eui& 25

3;85832

6;8"64"

8;3! 5"

1;84561

6;6

T/TAL LIADILITIES AN/>NERS EBUITY

268;44"

342;181

424;151

518;225

633;51!

PR/ECTE STATEMENT /F CASH FL/>S

F#r &*e Ye+r E'$e$ e%eer 31; 2"15@2"1!


32/81

2"15 2"16 2"1 2"18 2"1!

@et Income 19oss2 *,*FF*,K+

*7,-

K/*K7,++

K78+,7

*

"epreciation ,8K* +,K// +,K//

+,K// +,K//

Increase in ccrued ?tilities -

,7F 1+-2

*+ *F KIncrease in ccrued !56IBI5

8// / / / /

Increase in ccrued SSS ,-K/ / / -8 /

Increase in ccrued!hilwner*+,-

/

Withdrawals1//,/

//21-/,///2

1*//,///2

1*-/,///2

Ne& C+* Pr#i$e$ Fi'+'%i'g A%&ii&ie

*+,-/

1//,///2

1-/,///2

1*//,///2

1*-/,///2


33/81

Increase in Cash8*,+8

FF,-//

K-,8*+

/F,88

*,F7

ddA Cash, beg8*,+8

F*+K,K

8F7+-,-K

+-7,*/

F

C+*; e'$162;46

24!;!6

345;5

!1

453;2"

581;!2

"

S%*e$u(e 1

SALES V/LUME IN PAC,S

S%*##(Ye+r

A''u+( Pr#$u%&i#'C+-+%i&

N#. #0 M#'&* #0/-er+&i#'

T#&+( S+(e i'P+%

*/- */,// F 12;133

*/8 *,87* * 21;632

*/F **,+KF * 22;4!

*/ *7,7KF * 23;3!

*/K *+,777 * 24;333

S%*e$u(e 2

?R/SS SALES

S%*e$u(e 2"15 2"16 2"1 2"18 2"1!

Sales in !acks *,7

7 *,87* **,+KF *7,7KF *+,777

Selling !rice 8/.// 87.// 88.- 8K.+8 F*.K7?r# S+(e i'Pe#

28;"""

1;362;816

1;488;1!5

1;625;1"!

1;4;61!

S%*e$u(e 3

C/ST /F ?//S S/L


34/81

S%*e$u(e 2"15 2"16 2"1 2"18 2"1!

"irect ;aterials + 7-,788 8-,--- FF,KF F*,88- -7,*K*

"irect 9abor

F/,/// */,/// */,/// */,/// */,///!roduction>verhead K

FF,FF

*F8,+--

*7,/-8

*K,8K+

*K,+FK

C#& #0 ?##$S#($ 5!!;243

1;"55;"1"

1;12";!2

1;1!4;35!

1;21;2

S%*e$u(e 4

IRECT MATERIALS USE

S%*e$u(e 2"15 2"16 2"1 2"18 2"1!

#ggs +K,8/

/F8,-

FK*,F

-F*/,+

K/**K,

--

Washed Sugar +K,-

/F8,7

+K*,-

8+*/,*

/**K,8

*8

egetable >il +8,/

/77,/K

F78,+

*7K,+8

F+7,/K

Camote +*/,-

/+/,-+

+++,*F

++,7+

F-*,FK

-

ll !urpose %lour +F/,-8

/7K,/

/F-,F

K88-,F

8,/

Baking !owder + 7,78/ 8,8K F,** F,K7 ,8*/

Baking Soda + K/ ,K7 *,/ *,7/* *,-+

Iodi'ed Salt + +*/ *F K/+ KF ,/FF

Butter + -,/+/ K,K*K/,+

7,+

/*,K*

K

9ocal ermicelli4;i0Color +

F,-//

7+,+F8

7F,8+

+,

++,K+

Chocolate filling +7-,//

/7F,*

7K,7

-+,F

/++,7*

/

!otassium Sorbate + *,/8 *,7K *,*8K *,+/F *,--7

T#&+( ire%& M+&eri+(351;3

66658;5

551;!

182;6

65853;2

!2


35/81

S%*e$u(e 4A

IRECT MATERIALS 9-er i'gre$ie'&:

2"15 2"16 2"1 2"18 2"1!

Egg

:e)uirement per day 1pc.2 8/ 88 F7 / F

@o. of working days in theyear +/ *8/ *8/ *8/ *8/

(otal re)uirements in units **,+// +7,*8+ ++,KK- +8,FK+ +,888

Cost per unit +.// +./ +.* +.-/ +.F*

T#&+( ire%& M+&eri+( 8!;6""16;51

1!2;5

21";4!

"22!;85

5

>+*e$ Sug+r 2"15 2"16 2"1 2"18 2"1!

:e)uirement per day 1kg2 7.7* 7.- +.+ +.K -.-


(otal re)uirements in units ,8- 7,8/* 7,F+8 7,K8 +,/-

Cost per unit +.// +.K8 -.+ -7.K -8.8

T#&+( ire%& M+&eri+( 8!;51"16;34

11!2;56

421";28

"22!;62

6

Vege&+(e /i( 2"15 2"16 2"1 2"18 2"1!

:e)uirement per day 192 *.// *./ *.8 *.*- *.7+


(otal re)uirements in units */ -+ -8* -- 8/

Cost per unit 8/.// 8.*/ 8+.*8 8F.+F F/.-

T#&+( ire%& M+&eri+( 16;8"" 33;"! 36;142 3!;46 43;"!8


36/81

C+#&e 2"15 2"16 2"1 2"18 2"1!

:e)uirement per day 1kg2 K. /.K /.8/ ./* .+8@o. of working days in theyear +/ *8/ *8/ *8/ *8/

(otal re)uirements in units

,7F*.

//

*,8+K.

K*

*,F--.

K*

*,88.

-

*,K/.

/Cost per unit - -.7/ 8./F 8.F F.F

T#&+( ire%& M+&eri+( 2";58" 4";544 44;24 48;34 52;!5

A(( Pur-#e F(#ur 2"15 2"16 2"1 2"18 2"1!

:e)uirement per day 1kg2 .*/ .8- *. *.8/ 7./@o. of working days in theyear +/ *8/ *8/ *8/ *8/

(otal re)uirements in units ,-8 7,/* 7,-/ 7,*F8 7,+/F

Cost per unit +-.// +-.K/ +.*/ -/.8/ -7.7

T#&+( ire%& M+&eri+( ";56"13!;""

151;!

6165;6

1181;"1

1

D+i'g P#)$er 2"15 2"16 2"1 2"18 2"1!

:e)uirement per day 1kg2 /.+/ /.+* /.+7 /.+- /.+F@o. of working days in theyear +/ *8/ *8/ *8/ *8/

(otal re)uirements in units -8 / * F **

Cost per unit 8/.// 8.*/ 8+.*8 8F.+F F/.-T#&+( ire%& M+&eri+( 3;36" 6;61! ;228 ;8!3 8;62"

D+i'g S#$+ 2"15 2"16 2"1 2"18 2"1!

:e)uirement per day 1kg2 /.*/ /.* /.** /.** /.*7@o. of working days in theyear +/ *8/ *8/ *8/ *8/

(otal re)uirements in units * -+ -8 - 8

Cost per unit 7-.// 7-.F/ 7F.+K 7K.78 +.77

T#&+( ire%& M+&eri+( !8" 1;!31 2;1"8 2;3"2 2;514

I#$iGe$ S+(& 2"15 2"16 2"1 2"18 2"1!

:e)uirement per day 1kg2 /.*/ /.* /.** /.** /.*7@o. of working days in theyear +/ *8/ *8/ *8/ *8/


37/81

(otal re)uirements in units * -+ -8 - 8

Cost per unit -.// -.7/ 8./F 8.F F.F

T#&+( ire%& M+&eri+( 42" 82 !"4 !8 1;"

Du&&er 2"15 2"16 2"1 2"18 2"1!

:e)uirement per day 1bar2 .// ./+ ./ .* .F@o. of working days in theyear +/ *8/ *8/ *8/ *8/

(otal re)uirements in units +/ *F/ * *K* 7/+

Cost per unit 78.// 78.F* 7.-8 +/.+ +*.-

T#&+( ire%& M+&eri+( 5;"4" !;!2! 1";843 11;84" 12;!2!

L#%+( Veri%e((i


38/81

S%*e$u(e 5

DU?ETE MATERIAL INVENT/RY; EN

S%*e$u(e 2"15 2"16 2"1 2"18 2"1!

"irect ;aterials ?sed +7-,7

888-,-

--FF,K

FF*,8

8--7,*

K*

Du$ge&e$ M+&eri+( I'e'r;e'$

12;665

13;8"6

15;"51

16;4"!

1;8!1

S%*e$u(e 6

DU?ETE MATERIALS PURCHASES

S%*e$u(e 2"15 2"16 2"1 2"18 2"1!

"irect ;aterials ?sed +7-,7

888-,-

--FF,K

FF*,8

8--7,*

K*

ddA ;aterial Inventory, end -*,88

-7,/

8-,/-

8,+/

KF,K

(otal "irect ;aterials78+,/

78F*,7

8F7*,K

8FKK,/

F-F,

7

9essA ;aterials Inventory, beg /*,88

-7,/

8-,/-

8,+/

K

T#&+( ire%& M+&eri+(364;"

3165!;6

!61!;1

6284;"

24854;

4


39/81

S%*e$u(e

LAD/R

+i(R+&e

E&i+&e$

N#. #0)#ri'g$+ i' +

#'&*

M#'&*(

S+(+r

N#. #0M#'&

*

N#. #0>#re

r

T#&+(S+(+r

2"15!roductionstaff *-/ */

-,/// F *

F/,///

"elivery;an *-/ */

-,/// F

7-,///

T#&+(

1"5;"""


-,/// * *

*/,///

"elivery;an *-/ */

-,/// *

8/,///

T#&+(18";"""


-,/// * *

*/,///

"elivery;an *-/ */

-,/// *

8/,///

T#&+(18";"""

2"18!roductionstaff *87 */

-,*-/ * *

*8,///

"elivery;an *87 */ -,*-/ * 87,///

T#&+(18!;"""

2"1!!roductionstaff *87 */

-,*-/ * *

*8,///

"elivery;an *87 */

-,*-/ *

87,///

T#&+(

18!;"""


40/81

S%*e$u(e 8

ALL/CATI/N /F LAD/R

T#&+(S+(+r

A((#%+&

e$ ire%&L+#r

T#&+(

C*+rge ire%&L+#r

A((#%+&e$

Se((i'gE7-e'e

T#&+( C*+rge T#&+( Se((i'gE7-e'e

2"15

!roduction staff

F/,/// //=

F/,///

"elivery;an

7-,/// //=

7-,///

T#&+(

";""" 35;"""

2"16

!roduction staff

*/,/// //=

*/,///

"elivery;an

8/,/// //=

8/,///

T#&+(

12";""" 6";"""

2"

1

!roductio

n staff

*/,/// //=

*/,///"elivery;an

8/,/// //=

8/,///

T#&+(

12";""" 6";"""

2"18

!roduction staff

*/,/// //=

*/,///

"elivery;an

8/,/// //=

8/,///

T#&+(

12";""" 6";"""

2"1!

!roduction staff

*/,/// //=

*/,///

"elivery;an

8/,/// //=

8/,///


41/81

T#&+(

12";""" 6";"""

S%*e$u(e !

PR/UCTI/N /VERHEA

S%*e$u(e 2"15 2"16 2"1 2"18 2"1!

Fi7e$#lectricity andWater #0pense +

7/,//

+F,*7*

+,+K

+K,8+

-/,+K7

:epairs and;aintenance ** 6 7,-// 7,8F- 7,-K +,/-*

"epreciation#0pense 78

8,*-

,F//

,F//

,F//

,F//

!hil


42/81

S%*e$u(e 1"

/PERATIN? EXPENSES

S%*e$u(e 2"15 2"16 2"1 2"18 2"1!

Se((i'g E7-e'e

dvertising #0pense **,*-/ -/ -*/ -7 -+

?tilities #0pense K,*/

-,+** -,F7

8,/+-

8,788

:epairs and;aintenance ** 6 ,8// ,8/ ,F8+ ,-*"epreciation

#0pense 78

,8F 7,*// 7,*// 7,*// 7,*//

9abor 7-,///

8/,/// 8/,///

8/,///

8/,///

!hil


43/81

Cost ,->ther >utright#0penses 7F

*,/// 6 6 6 6

T#&+(A$i'i&r+&ie

E7-e'e

5

;15

3

5;565 35;!41

3

6;32

3

6;622T#&+( /-er+&i'gE7-e'e

116;4!

134;858

135;632

13;3"1

138;"16

S%*e$u(e 11

RETAINERS FEE

2"15 2"16 2"1 2"18 2"1!

:etainerNs %ee 2;"""."" 2;"""."" 2;"""."" 2;"""."" 2;""".""

S%*e$u(e 12

AVERTISIN? EXPENSES

2"15 2"16 2"1 2"18 2"1!

!osters -// -/ -*/ -7 -+

%ree tasting ,F-/ 6 6 6 6

T#&+( 2;25" 51" 52" 531 541

S%*e$u(e 13

ELECTRICITY AN >ATER EXPENSE

M#'&*( 2"15 2"16 2"1 2"18 2"1!

#lectricity

+,/// *,/// +,K8/ +K,K7K -/,K7 -,++F

Water// K,8// /,// /,-+ ,7 ,88K

T#&+( 4;8"" 3;6"" 5!;"4" 6";523 62;"51 63;116

S%*e$u(e 14

ALL/CATI/N /F ELECTRICITY AN >ATER EXPENSE


44/81

:atio 2"15 2"16 2"1 2"18 2"1!

!roduction>verhead

/=

7/,// +F,*7* +,+K +K,8+ -/,+K7

dministrative#0pense

*/=

F,-*/ ,/ *,/- *,+/ *,8*7

T#&+(

1""

3;6"" 5!;"4" 6";523 62;"51 63;116

S%*e$u(e 15

ACCRUE UTILITIES EXPENSE@ ELECTRICITY AN >ATER

2"15 2"16 2"1 2"18 2"1!

?tilities #0pense7F,8// -K,/+/ 8/,-*7 8*,/- 87,8

ddA ccrued?tilities, beg. 6 -,7F +,K*/ -,/++

-,F

(otal7F,8// 8+,+ 8-,++7 8F,/K- 8,*F

9essA !ayments

!rior 6 -,7F +,K*/ -,/++-,F

Current7*,**K -+,*/ --,+/ -8,/ -F,-F

A%%rue$ U&i(i&ieE7-e'e; e'$

5;31.43

4;!2" 5;"44 5;11 5;26"

S%*e$u(e 16

FUEL EXPENSE

M#'&*

( 2"15 2"16 2"1 2"18 2"1!

%uel#0pense 1;4""

!;8""

1;136

1;4!

1;828

18;185


45/81

S%*e$u(e 1

ALL/CATI/N /F FUEL EXPENSE

R+&i# 2"15 2"16 2"1 2"18 2"1!

Selling #0pensesK/=

,*/ -,+** -,F7 8,/+- 8,788

!roduction>verhead

/=

K/ ,F+ ,F+ ,F7 ,

T#&+(

1""

!;8"" 1;136 1;4! 1;828 18;185

S%*e$u(e 18

LIBUEFIE PETR/LEUM ?AS

M#'&*( 2"15 2"16 2"1 2"18 2"1!

9!5

8""

5;6""

!;!2

!;!88

1";188

1";3!1

S%*e$u(e 1!

SUMMARY /F UTILITIES EXPENSE ALL/CATI/NS


46/81

2"15 2"16 2"1 2"18 2"1!

!roduction >verhead78,

88/-,

F78/,

-+8,

88*,

F/7

dministrative #0penseF,

-*/,

/*,

/-*,

+/*,

8*7

Selling #0pense,

*/-,

+**-,

F78,

/+-8,

788T/TAL UTILITIES

EXPENSE 53;""" 85;!68 8;!!" !";"6 !1;6!2

S%*e$u(e 2"

REPAIRS AN MAINTENANCE

2"15 2"16 2"1 2"18 2"1!

>ven 6 ,/// ,/-/ ,/7 ,-

:efrigerator 6 7-/ 78 78 +/-

Stand ;i0er 6 F-/ F *F 8

Chiller 6 ,/// ,/-/ ,/7 ,-

"elivery ehicle 6 *,/// *,// *,*/- *,7-

T#&+( 6 5;1"" 5;355 5;623 5;!"4

S%*e$u(e 21

ALL/CATI/N /F REPAIRS AN MAINTENANCE /F ELIVERY VEHICLE

2"15 2"16 2"1 2"18 2"1!

!roduction >verhead 6 +// +*/ ++ +87

Selling #0penses 6 ,8// ,8/ ,F8+ ,-*

T#&+( 6 2;""" 2;1"" 2;2"5 2;315

S%*e$u(e 22

SUMMARY /F REPAIRS AN MAINTENANCE ALL/CATI/NS


47/81


48/81

ALL/CATI/N /F RENT EXPENSE

2"15 2"16 2"1 2"18 2"1!

!roduction>verhead

+7,*// -F,8// -F,8// -F,8// -F,8//

dministrative#0penses

/,// +,+// +,+// +,+// +,+//

T#&+(54;""" 2;""" 2;""" 2;""" 2;"""

S%*e$u(e 26

>i&**#($i'g T+7 #' Re'&

2"15 2"16 2"1 2"18 2"1!

:ent #0pense-+,/// F*,/// F*,/// F*,/// F*,///

Withholding ta0 -= -= -= -= -=

Withholding ta0payable

*,F// 7,8// 7,8// 7,8// 7,8//

S%*e$u(e 2

PAC,A?IN? EXPENSE

2"15 2"16 2"1 2"18 2"1!

5lacine +7 F/ * ++ F!olypropylene19aminated%le0ible!ackaging2

+,-77 F,78/ K,F* K8,7+ /,7/

!olyethylene 8,/8

F/,

8,*+

K,8K

K*,8

F

T#&+( 55;"38 !8;!56 1"3;88 1"8;85 114;14


49/81

S%*e$u(e 28

EPRECIATI/N EXPENSE /F CAPITALIE

FIXE ASSETS

Bu+'&i&

U'i&C#&

T#&+(C#&

Ue0u(Li0e

A''u+(e-re%i+&i#'

>ven */,/// */,/// - +,///

:efrigerator F,/// F,/// - ,+//

Stand ;i0er -,/// -,/// - 7,///

"elivery ehicle +/,/// +/,/// / +,///

Chiller */,/// */,/// *,-//T#&+(e-re%i+&i#' 1"2;""" 14;!""

S%*e$u(e 2!

ALL/CATI/N /F EPRECIATI/N EXPENSE@ELIVERY VEHICLE

R+&i# 2"15 2"16 2"1 2"18 2"1!

!roduction>verhead

*/=

+8F // // // //

Selling #0penses/=

,8F 7,*// 7,*// 7,*// 7,*//

T#&+(2;333 4;""" 4;""" 4;""" 4;"""

S%*e$u(e 3"

D//, VALUE@ELIVERY VEHICLE


50/81

2"15 2"16 2"1 2"18 2"1!

Cost +/,/// +/,/// +/,/// +/,/// +/,///

9essA ccumulated

"epreciation *,77

78,77

7/,77

7+,77

7,77

7

D## V+(ue 3;66 33;66 2!;66 25;66 21;66

S%*e$u(e 31D//, VALUE@STAN MIXER

2"15 2"16 2"1 2"18 2"1!

Cost -,/// -,/// -,/// -,/// -,///9essA

ccumulated

"epreciation ,F-/ +,F-/ F,F-/ /,F-/ 7,F-/

D## V+(ue 13;25" 1";25" ;25" 4;25" 1;25"

S%*e$u(e 32

D//, VALUE@/VEN

2"15 2"16 2"1 2"18 2"1!

Cost */,/// */,/// */,/// */,/// */,///9essA

ccumulated

"epreciation *,777 8,777 /,777 +,777 ,777

D## V+(ue 1;66 13;66 !;66 5;66 1;66


51/81

S%*e$u(e 33

D//, VALUE@REFRI?ERAT/R

2"15 2"16 2"1 2"18 2"1!

Cost F,/// F,/// F,/// F,/// F,///9essA

ccumulated

"epreciation F *,*F 7,8F -,/F 8,+F

D## V+(ue 6;183 4;83 3;383 1;!83 583

S%*e$u(e 34

D//, VALUE@CHILLER

2"15 2"16 2"1 2"18 2"1!

Cost */,/// */,/// */,/// */,/// */,///9essA

ccumulated

"epreciation ,+- 7,K- 8,+- ,K- ,+-

D## V+(ue 18;542 16;"42 13;542 11;"42 8;542

S%*e$u(e 35EPRECIATI/N EXPENSE@STAN MIXER; /VEN; REFRI?ERAT/R AN

CHILLER

2"15 2"16 2"1 2"18 2"1!

>ven *,777 +,/// +,/// +,/// +,///

:efrigerator F ,+// ,+// ,+// ,+//

Stand ;i0er ,F-/ 7,/// 7,/// 7,/// 7,///Chiller ,+- *,-// *,-// *,-// *,-//

e-re%i+&i#' C*+rge$ 6;358 1";!"" 1";!"" 1";!"" 1";!""

Pr#$u%&i#' /er*e+$


52/81

S%*e$u(e 38

,ITCHEN SUPPLIES

2"15 2"16 2"1 2"18 2"1!

S%*e$u(e 36

SUMMARY /F EPRECIATI/N EXPENSE ALL/CATI/NS

2"15 2"16 2"1 2"18 2"1!

!roduction>verhead 8,*- ,F// ,F// ,F// ,F//Selling#0pense 8F 7*// 7*// 7*// 7*//

T#&+( 8;6!2 14;!"" 14;!"" 14;!"" 14;!""

S%*e$u(e 3

/THER /UTRI?HT EXPENSE

2"15 2"16 2"1 2"18 2"1!

!lastic Impulse Sealer *,// 6 6 6 6

5as stove K// 6 6 6 6

Weighing Scale *// 6 6 6 6

Storage bo0 7,+// 6 6 6 6

Stand %an ,F// 6 6 6 6

!roduction (able +,/// 6 6 6 6>ffice (able ,/// 6 6 6 6

!lastic Chairs +// 6 6 6 6

%ire #0tinguisher +,/// 6 6 6 6

#0haust %an ,*// 6 6 6 6

Wall %an 7// 6 6 6 6

(ray :ack ,// 6 6 6 6

T#&+( 21;""" 6 6 6 6


53/81

Baking pan F// F+ F* F+7 F-

;oulders *,/// *,/+/ *,/ *,** *,8-

Washbasin +// +/ +8 +*+ +77

Cooking pot *,*+/ *,*- *,77/ *,7FF *,+*-

;i0ing Bowl *,/K *,+/ *,7 *,**8 *,*F

!eeler */ ** *- *F 7/

Wooden Spatula +/ +7 +8 +K -*

itchen nife // /* /+ /8 /

;easuring caps 7/ 77 7- 7 +

;easuring spoons // /* /+ /8 /

Spoons -/ - -* -7 -+

%ork -/ - -* -7 -+

9adle / * 7 - F

Strainer -/ -7 -8 -K 8*!otholder -/ - -* -7 -+


54/81

S%*e$u(e 4"

PHILHEALTH C/NTRIDUTI/N

N#.T#&+

(M#'&*(

A''u+( T#&+(

C*+rge$

C*+rge$

#0

M#'&*(

M#'&*(

C#'&riu&i#'

C#'&riu&i#'

C#'&riu&i#

'

Pr#$u%&i#

'Se((i'g

Ye+r

E-(#ee

S+(+r

S+(+r ER EE ER EE

/er*e+$

E7-e'e

2"15

!roductionWorker *

-,///

/,///

*//

*//

*,//

*,// -,8//

5;6""

"elivery;an

-,///

-,///

*//

*//

,+//

,+// *,// 2;8""

+/

/

+/

/

+,*

//

+,*

// 8;4""

5;6""

2;8""

2"16

!roductionWorker *

-,///

/,///

*//

*//

+,//

+,// K,8//

!;6""

"elivery;an

-,///

-,///

*//

*//

*,+//

*,+// +,// 4;8""

+//

+//

F,*//

F,*//

14;4"" !;6""

4;8""

2"1

!roductionWorker *

-,///

/,///

*//

*//

+,//

+,// K,8//

!;6""

"elivery;an

-,///

-,///

*//

*//

*,+//

*,+// +,// 4;8""


55/81

+//

+//

F,*//

F,*//

14;4""

!;6"" 4;8""

2"18

!roduction

Worker

* -,*

-/

/,-

//

*/

/

*/

/

+,

//

+,

//

K,8//

!;6""

"elivery;an

-,*-/

-,*-/

*//

*//

*,+//

*,+//

+,//

4;8""

+//

+//

F,*//

F,*//

14;4""

!;6""

4;8""

2"1!

!roductionWorker

* -,*-/

/,-//

*//

*//

+,//

+,//

K,8//

!;6""

"elivery;an

-,*-/

-,*-/

*//

*//

*,+//

*,+//

+,//

4;8""

+//

+//

F,*//

F,*//

14;4""

!;6""

4;8""

S%*e$u(e 42

PA?@IDI? C/NTRIDUTI/N

N#. T#&+(M#'&*(

A''u+( T#&+(C*+rge$

C*+rge$

S%*e$u(e 41

ACCRUE PHILHEALTH C/NTRIDUTI/N

2"15 2"16 2"1 2"18 2"1!

!hil


56/81

#0M#'&*(

M#'&*(

C#'&riu&i#'

C#'&riu&i#'

C#'&riu&i#'

Pr#$u%&i#' Se((i'g

Ye+r

E-(#ee

S+(+r

S+(+r

ER

EE ER EE

/er*e+$

E7-e'e

2"15

!roductionWorker *

-,///

/,///

//

//

,+//

,+// *,// 2;8""

"elivery;an

-,/// -,///

//

//

F//

F// ,+// 1;4""

*//

*//

*,//

*,// 4;2"" 2;8"" 1;4""

2"16

!roductionWorker *

-,///

/,///

//

//

*,+//

*,+// +,// 4;8""

"elivery;an

-,/// -,///

//

//

,*//

,*// *,+// 2;4""

*//

*//

7,8//

7,8// ;2"" 4;8"" 2;4""

2"1

!roductionWorker *

-,///

/,///

//

//

*,+//

*,+// +,// 4;8""

"elivery;an

-,/// -,///

//

//

,*//

,*// *,+// 2;4""

*//

*//

7,8//

7,8// ;2"" 4;8"" 2;4""

2"18

!roductionWorker *

-,*-/

/,-//

//

//

*,+//

*,+// +,// 4;8""

"elivery;an

-,*-/ -,*-/

//

//

,*//

,*// *,+// 2;4""


57/81

*//

*//

7,8//

7,8// ;2"" 4;8"" 2;4""

2"1!

!roductionWorker *

-,*-/

/,-//

//

//

*,+//

*,+// +,// 4;8""

"elivery;an

-,*-/ -,*-/

//

//

,*//

,*// *,+// 2;4""

*//

*//

7,8//

7,8// ;2"" 4;8"" 2;4""

S%*e$u(e 43

ACCRUE PA?@IDI? C/NTRIDUTI/N

2"15 2"16 2"1 2"18 2"1!

!ag6ibig Contribution+,*// F,*// F,*// F,*// F,*//

ddA !ag6ibig Contribution, beg 8// 8// 8// 8//

(otal+,*// F,// F,// F,// F,//

9essA!ayments

!rior8// 8// 8// 8//

Current7,F/ 8,8// 8,8// 8,8// 8,8//

A%%rue$ P+g@iigC#'&riu&i#'; e'$

6"" 6"" 6"" 6"" 6""

S%*e$u(e 44

SSS C/NTRIDUTI/N


58/81

N#. T#&+( M#'&*( A''u+( T#&+(C*+rge$

C*+rge$

#0M#'&*(

M#'&*(

C#'&riu&i#' C#'&riu&i#'

C#'&riu&i#'

Pr#$u%&i#'

Se((i'g

Ye

+r

E-(#

ee

S+(

+r

S+(+r

ER EE ER EE

/er*

e+$

E7-e'

e

2"15

!roductionWorker *

-,///

/,///

787

8F

-,/8 *,77+ F,+*/ ;42"

"elivery;an

-,/// -,///

787

8F

*,-+7 ,8F 7,F/ 3;1"

F*F

777

F,8*K 7,-/ 11;13"

;42" 3;1"

2"16

!roductionWorker *

-,///

/,///

787

8F

,FK +,// *,F*/

12;2"

"elivery;an

-,/// -,///

787

8F

+,78/ *,/// 8,78/ 6;36"

F*F

777 7,/FK

8,// 1!;"8"

12;2" 6;36"

2"1

!roductionWorker *

-,///

/,///

787

8F

,FK +,// *,F*/

12;2"

"elivery;an

-,/// -,///

787

8F

+,78/ *,/// 8,78/ 6;36"

F*F

777 7,/FK

8,// 1!;"8"

12;2" 6;36"

2"18

!roductionWorker *

-,*-/

/,-//

7KK

7

K,-8K

+,7KK 7,K8

13;!68

"elivery;an

-,*-/ -,*-/

7KK

7

+,F+ *,*// 8,K+ 6;!84

FKF

78F +,7-7

8,-KK 2";!52

13;!68 6;!84

2"1!

!roductionWorker *

-,*-/

/,-//

7KK

7

K,-8K +,7KK 7,K8

13;!68

"elivery;an

-,*-/ -,*-/

7KK

7

+,F+ *,*// 8,K+ 6;!84

FKF

78F

+,7-7

8

,-KK 2";!52

1

3;!68 6;!84

S%*e$u(e 45

ACCRUE SSS C/NTRIDUTI/N


59/81

2"15 2"16 2"1 2"18 2"1!

SSS Contribution,7/ K,// K,// */,K-* */,K-*

ddA !ag6ibig Contribution,beg ,-K/ ,-K/ ,-K/ ,F+8

(otal,7/ */,8F/ */,8F/ **,-+* **,8K

9essA!ayments

!rior,-K/ ,-K/ ,-K/ ,F+8

CurrentK,-+/ F,+K/ F,+K/ K,*/8 K,*/8

A%%rue$ SSS C#'&riu&i#';e'$

1;5!" 1;5!" 1;5!" 1;46 1;46

S%*e$u(e 46

13TH M/NTH PAY

N#. T#&+( T#&+(C*+rge$

C*+rge$

#0M#'&*(

M#'&*(

13&*M#'&*

Pr#$u%&i#'

Se((i'g

Ye+r

E-(#ee

S+(+r

S+(+r

Fr+%&i#' P+

/er*e+$

E7-e'e

2"15

!roductionWorker *

-,///

/,///

F4*

,888

11;666

"elivery;an

-,///

-,///

F4*

*,KF 2;!1

14;583

11;666 2;!1

2"16

!roductionWorker *

-,///

/,///

/,///

1";"""

"elivery;an

-,///

-,///

-,/// 5;"""

15;"""

1";""" 5;"""

2" !roduction - / 1


60/81

1 Worker * ,/// /,/// ,/// ";""""elivery

;an -

,///-

,/// -

,/// 5;"""

/,///

1";""" 5;"""

2"18

!roductionWorker *

-,*-/

/,-//

/,-//

1";5""

"elivery;an

-,*-/

-,*-/

-,*-/ 5;25"

15;5"

1";5"" 5;25"

2"1!

!roductionWorker *

-,*-/

/,-//

/,-//

1";5""

"elivery

;an

-

,*-/

-

,*-/

-

,*-/ 5;25"15

;5"1

";5"" 5;25"

S%*e$u(e 4

PERCENTA?E TAX

2"15 2"16 2"1 2"18 2"1!

5ross Sales

F*,///

,78*,8

,+,K-

,8*-,/K

,FF+,8K

;ultiplied byA!ercentage (a0 :ate 7= 7= 7= 7= 7=

T#&+(21;84" 4";884 44;646 48;53 53;23!

S%*e$u(e 48ACCRUE PERCENTA?E TAX

2"15 2"16 2"1 2"18 2"1!

!ercentage (a0 #0pense*,+/ +/,+ ++,8+8 +,F-7 -7,*7K


61/81

ddA ccrued !ercentageta0, beginning 7,*/ 7,+8- 7,F*/ +,/87

(otal*,+/ ++,//+ +, -*,+F+ -F,7/

9essA !ayments

!rior7,*/ 7,+8- 7,F*/ +,/87

Current,F*/ 7F,+K +/,K*- ++,8K/ +,/*

A%%rue$ Per%e'&+ge &+7;e'$

3;12" 3;465 3;2" 4;"63 4;43

S%*e$u(e 4!

/FFICE SUPPLIES

Bu+'&i& 2"15 2"16 2"1 2"18 2"1!

Bondpaper ream -/ -7 -8 -K 8*

Columnar @otebook - pcs. // /* /+ /8 /

Ball pen / pcs. -/ - -* -7 -+

!encils 8 pcs. K K K

Stapler unit - - 8 8 8

Staple Wires bo0 - - 8 8 8

Cellophane (ape pcs. 8 F F- F *

Inventory Control Sheet * pads 7/ 77 7- 7 +

"elivery Sheet + pads */ *8 *K *KF 7/7

>rder Slips pad K K */ */ *

Calculator unit 7/ 78 7*7 7*K 778

T#&+(1;25

51;28

"1;3"

61;33

21;35

8

S%*e$u(e 5"

CLEANIN? SUPPLIES

2"15 2"16


62/81

Broom F- FF

"ust !an F- FF

5arbage Bag -/ -

Scissors *- *8

:ags */ */

5arbage Cans // /*%loor ;ap -/ -7

"ishwashing and 9i)uid Soap 7// 7/8

"iswashing Sponge */ */

T#&+( 815 831

S%*e$u(e 51

PR/ECT FEASIDILITY C/ST

2"15 2"16

#ncoding and !rinting // 6

Bookbinding and !hotocopy ,/// 6

(ransportation ,/// 6

9etterhead 7- 6

Bond !aper 7// 6

White #nvelope with 9etterhead 7/ 6

!roduct #0perimentation 8// 6

%ree taste Sampling *-/ 6%ood 1:esearcher and !anelist2 8// 6


63/81


64/81

Sales F*,/// ,78*,8 ,+,K- ,8*-,/K ,FF+,8K9essAariableCost

+*,K+ F8K,/F 77,++ K/7,+K7 KFK,8F8

Contribution;argin

7-,/8 -K7,FKK 8-+,F-+ F*,88 FK+,K+7

9essA%i0edCost

7/*,F7

+*/,-

+*7,8+

+*,8F

+7/,

Ne& I'%#e 12;28 12;!48 231;5!" 2!3;44! 364;832


65/81

%I@@CI9 S((#;#@(S @9JSIS

%inancial statement analysis is a process of reviewing and evaluating a

companyNs financial to gain an understanding of the financial health of the

company and enabling a more effective decision making.

%inancial statements act as the language of business. (hese financial

records must be evaluated through financial statement analysis to become more

useful to investors, shareholders, managers and other interested parties.Below are the techni)ues used to aid in financial statements analysis.Te& #0 Liui$i&

9i)uidity refers to the ability of the business to pay its obligations in cash

as they mature.Current Ratio

Current Ratio /Current Assets

Current Liabilities

(he results above show that the business can pay the currently

maturing debts on time with its available current assets.


66/81

Wor-ing Capital / Current 0ssets1 Current ia3ilities

(he result above indicates that the business has e0cess net

working capital. It means that the business invested the e0cess current

assets in the operations of the business. (he business could have

invested the e0cess cash to get returns on investment to minimi'e

opportunity cost.

Wor-ing Capital 4urno#er

Wor-ing Capital 4urno#er /Net Sales

Average Working Capital

S%*##( Ye+r Ne& S+(eAer+ge >#ri'g

C+-i&+(

>#ri'gC+-i&+(

Tur'#er

*/- F*,/// 8/,--/ +.-7

*/8 ,78*,8 *+,F+K +.FK

*/F ,+,K- +*/,+* 7.-+*/ ,8*-,/K -F,-/F *.+

*/K ,FF+,8K F++,F* *.7

S%*##( Ye+r Curre'& Ae&Curre'&

Li+i(i&ie

Ne& >#ri'g

C+-i&+(

*/- F-,7 +,- 8/,--/

*/8 *87,FF7 -,7F- *+,7K

*/F 78/,8+* -,F-+ 7++,

*/ +8K,8F 8,7/ +-7,*7F

*/K -KK, 8,+* -*,K8K


67/81

S%*##( Ye+r>#ri'g

C+-i&+(; Deg>#ri'g

C+-i&+(; E'$

Aer+ge>#ri'gC+-i&+(

*/- 8/,--/ 8/,--/

*/8 8/,--/ *+,7K *+,F+K

*/F *+,7K 7++, +*/,+*

*/ 7++, +-7,*7F -F,-/F

*/K +-7,*7F -*,K8K F++,F*

(he results show an increasing working capital turnover. It indicates

ineffective use of working capital to generate sales.

Te& #0 S#(e'%

Solvency is the ability of a business to meet its long6term financial

obligations.

5uity Ratio

5uity RatioLTotal Owner

's Equity

Total Assets

S%*##( Ye+r T#&+( /)'er Eui& T#&+( Ae& Eui& R+&i#

*/- *-7,- *8,++/ K-=

*/8 7*8,/8 7+*, K8=

*/F +/,7KF +*+,- K8=

*/ -/,+- -,**- KF=

*/K 88,8FF 877,-K KF=

(he table above shows an increasing e)uity ratio. It denotes that

the resources provided for by the owners are increased due to income

generated from its operations. (his also means that the company


68/81

resources were mostly financed by the owner.

De3t Ratio

De3t Ratio /Total Liabilities

Total Assets

S%*##( Ye+r T#&+( Li+i(i&ie T#&+( Ae& e& R+&i#

*/- +,- *8,++/ -=

*/8 -,7F- 7+*, +=

*/F -,F-+ +*+,- +=

*/ 8,7/ -,**- 7=

*/K 8,+* 877,-K 7=

(he table shows a low debt ratio. It indicates that the creditor3s

relative share over the resources of the firm is low.

De3t1to1euity Ratio

De3t1to1euity Ratio /Total Liabilities

Total Owne r's Equity

S%*##( Ye+r T#&+( Li+i(i&ieT#&+( /)'er

Eui&e&@

Eui& R+&i#

*/- +,- *-7,- 8=

*/8 -,7F- 7*8,/8 -=

*/F -,F-+ +/,7KF +=*/ 8,7/ -/,+- 7=

*/K 8,+* 88,8FF 7=

(he table shows a low debt6to6e)uity ratio. It means that less debt

is used to finance the operations of the business. It also indicates that

owner3s e)uity is a ma&or source in financing the operation compared to


69/81

debt.

Te& #0 Pr#0i&+i(i&

!rofitability is the ability of the business to generate profit.

Return on ales

Return on ales /Net Income

Net Sales

S%*##( Ye+r Ne& I'%#e Ne& S+(e

Re&ur' #'

S+(e*/- *,*F F*,/// *=

*/8 F*,K+ ,78*,8 7=

*/F *7,-K/ ,+,K- 8=

*/ *K7,++K ,8*-,/K =

*/K 78+,7* ,FF+,8K *=

(he table shows an increasing return on sales. It shows that the

amount of return to owners for every peso sales is increasing. (he

increasing return on sales indicates proper handling of cost and e0penses

during the operating cycle.

Return on 5uity

Return on 5uity /

Net Income

Average Owner 's Equity

S%*##( Ye+r Ne& I'%#eAer+ge/)'erEui&

Re&ur' #' Eui&


70/81

*/- *,*F *-7,- -=

*/8 F*,K+ *K/,77* 8/=

*/F *7,-K/ *F,F7+ /8=

*/ *K7,++K *8*,-*/ *=

*/K 78+,7* 7*K,+/ =

(he table shows an increasing return on e)uity. It means that the

return of the owners and potential investors on their investments is

increasing. It indicates efficient use of the resources of the business.

Dre+@ee' A'+(i

Break6even point in !esos LCost

Contribution argin!atio

S%*##( Ye+r Fi7e$ C#&C#'&riu&i#'M+rgi' R+&i#

Dre+@ee'P#i'& i' Pe#

*/- 7/*,F7 +7.*F= 8KK,8*-

*/8 +*/,- +7.-F= K8-,F*/F +*7,8+ ++.//= K8,*

*/ +*,8F ++.+/= K8+,*-/

*/K +7/, ++./= K8/,F+

Contribution ;argin :atio LContribution argin"esos

Sales"esos

S%*##(Ye+r

C#'&riu&i#'

M+rgi'9i' -e#:

S+(e i' Pe#C#'&riu&i#'M+rgi' R+&i#

*/- 7-,/8 F*,/// +7=

*/8 -K7,FKK ,78*,8 ++=

*/F 8-+,F-+ ,+,K- ++=


71/81

*/ F*,88 ,8*-,/K ++=

*/K FK+,K+7 ,FF+,8K +-=

Break6even point in !ieces L

CostContribution argin per #nit

S%*##( Ye+r Fi7e$ C#&C#'&riu&i#'

M+rgi' Per P+%Dre+@ee'

P#i'& i' U'i&

*/- 7/*,F7 *-.K8 ,88/

*/8 +*/,- *F.+- -,77*

*/F +*7,8+ *K./ +,-+/

*/ +*,8F 7/.+ 7,7*/K +7/, 7*.8F 7,88

Contribution ;argin per !ack LContribution argin"esos

Sales#nits

S%*##( Ye+r C#'&riu&i#'M+rgi' 9i' -e#:

S+(e i'P+%

C#'&riu&i#'M+rgi' -er u'i&

*/- 7-,/8 *,77 *-.K8

*/8 -K7,FKK *,87* *F.+-

*/F 8-+,F-+ **,+KF *K./

*/ F*,88 *7,7KF 7/.+

*/K FK+,K+7 *+,777 7*.8F

(he table above shows the break6even point in pesos and units. It

shows that there is a decreasing break6even point. It means that the

company has an increasing operating income. bove the breakeven point


72/81

is the profit area, thus, the further breakeven in units4pesos decrease, the

more it is profitable.

P++% Peri#$

S%*##(Ye+r

I'e&e'& e

re%#ere$

Ne&C+*I'0(#)

12Pree'&V+(ueF+%r

Pree'&V+(ue

#0 C+*I'0(#)

D+(+'%e

P++% Ye+r

*/- *+,-/8*,+8

F/.K ++,-K- K8,K-

*/8 K8,K-*+K,K8

F/./ KK,KF7 6 /.+

.+

(he table shows a payback period of .+ years. It means that the

business can recover the initial investment for a period of year and

about 8 months.

Sensitivity Analysis

Sensitivity nalysis is a techni)ue used to determine how different values

of an independent variable will impact a particular dependent variable under a

given set of assumptions. (his techni)ue is used within specific boundaries that

will depend on one or more input variables.

(his feasibility study containedpro&ected data which are developed under

specific assumptions. Sensitivity nalysis is very useful when attempting to

determine the impact the actual outcome of a particular variable will have if it

differs from what was previously assumed. By creating a given set of scenarios,

the analyst can determine how changes in one variable1s2 will impact the target


73/81

variable.

S%e'+ri# 1 S%e'+ri#

2

S%e'+ri# 3

V+ri+(e "ecrease Increase Increase "ecrease

S+(e -= 6 -=

ire%& L+#r F= F=

ire%& M+&eri+( -= -=

Fue( E7-e'e -= -=

>+&er E7-e'e -= -=

E(e%&ri%i& E7-e'e-= -=

LP? -= -=

/00i%e Su--(ie

E7-e'e

-= -=

C(e+'i'g Su--(ie

E7-e'e

-= -=

,i&%*e' Su--(ie -= -=

P+%+gi'g E7-e'e -= -=

C#u'i%+&i#'

E7-e'e

-= -=

A$er&ii'g E7-e'e -= -=

Re-+ir +'$

M+i'&e'+'%e

-= -=

Re'& E7-e'e -= -=

13&* M#'&* P+ F= F=

Re&+i'er Fee F= F=

(he rates used above were taken from the "epartment of 9abor and


74/81

#mployment Statistics and Consumer !rice Inde0 by Commodity 5roup,

!hilippines. Below are the pro&ectedStatement of %inancial !erformanceof the

proposed business based on the above scenarios.


75/81

Scenario


F#r &*e e+r e'$e$ e%eer 31; 2"15@2"1!

2"15 2"16 2"1 2"18 2"1!

Sales * 8K,8// ,*K+,8F- ,+7,F- ,-+7,-+ ,8-,

9essA Cost of Sales 7 -KK,*+7 ,/--,// ,*/,KF* ,K+,7-K ,*F,FF*

5ross !rofit K*,7-F *7K,88- *K*,7 7+K,+K+ ++,F

9essA >perating

#0penses / 8,+FK 7+,- 7-,87* 7F,7/ 7,/8

Ne& I'%#e 924;122: 1"4;8" 15;181 212;1!3 26;1"1


76/81

Scenario *


F#r &*e e+r e'$e$ e%eer 31; 2"15@2"1!

2"15 2"16 2"1 2"18 2"1!

Sales * F*,/// ,78*,8 ,+,K- ,8*-,/K ,FF+,8K

9essA Cost of Sales 7 8*K,*F7 ,/F,KF ,FF,**K ,*-+,**+ ,77-,+K

5ross !rofit K,F*F *-+,7 7/,K88 7F/,- +7K,*

9essA >perating

#0penses / ,*- 7F,+* 7F,K+/ 7K,8- +/,7KNe& I'%#e 91!;3!8: 11;6! 13;"26 231;234 2!8;31


77/81

Scenario 7PR/ECTE STATEMENT /F FINANCIAL PERF/RMANCE

F#r &*e e+r e'$e$ e%eer 31; 2"15@2"1!

2"15 2"16 2"1 2"18 2"1!

Sales * 8K,8// ,*K+,8F- ,+7,F- ,-+7,-+ ,8-,

9essA Cost of Sales 7 8*K,*F7 ,/F,KF ,FF,**K ,*-+,**+ ,77-,+K

5ross !rofit 8*,7*F 8,8K *78,--8 *K,87/ 7-/,7K/

9essA >perating

#0penses / ,*- 7F,+* 7F,K+/ 7K,8- +/,7K

Ne& I'%#e 955;!8: 4!;556 !8;616 14!;!! 21";"""


78/81

Comparative :esults

/rigi'+( S%e'+ri# 1 S%e'+ri# 2 S%e'+ri# 3

Ne& I'%#e 2"15 *,*F 1*+,**2 1K,7K2 1--,FK2

2"16 F*,K+ /+,/F F,8KF +K,--8

2"1 *7,-K/ -F, F7,/*8 K,88

2"18 *K7,++K **,K7 *7,*7+ +K,KFK

2"1! 78+,7* *F8,/ *K,F7 */,///

Re&ur' #' 2"15 /./- 6/. 6/./K 6/.7/

Eui& 2"16 /.8/ /.+ /.- /.7

2"1 ./8 ./K /.8K /.K/

2"18 .* .- /.7 *.-+

2"1! . .7 /.K+ -./F

Dre+ee' 2"15 8KK,8*- F-,+FF FF-,KF7 +,K*

P#i'& i' Pe# 2"16 K8-,F ,/78,-7K ,/F7,KK/ ,8*,KK

2"1 K8,* ,/7/,F8 ,/8,K7 ,-+,K8

2"18 K8+,*-/ ,/7*,*F+ ,/8K,-7 ,-+,*7

2"1! K8/,F+ ,/*8,FF7 ,/87,K+- ,+F,*/FDre+ee' 2"15 ,88/ 7,+ *,K77 +,F-

P#i'& i' U'i& 2"16 -,77* F,7K F,/+F K,+7*

2"1 +,-+/ 8,+/+ 8,+ ,7FK

2"18 7,7 -,8++ -,7KK F,-/

2"1! 7,88 +,*/ +,-K 8,--

P++% Peri#$ .+ *. *./7 more than - years


79/81


80/81

nalysis

s reflected in the comparative results, the pro&ect is more sensitive to

changes in the revenues than on the changes of its cost and e0penses. (he

business will not be able to generate income on the first year of operations in the

given scenarios but shows net income on the succeeding years even at a worst

case in scenario 7. ll scenarios have negative return on e)uity on the first year

which means that there is low return on e)uity. very high return on e)uity on

the fifth year in scenario 7 is due to the unchanged cost of withdrawal by owner

with respect to the scenarios used. s shown above, scenario 7 has higher set of

breakeven in units compared to the * other scenarios presented. n increasing

breakeven point means a decreasing operating income. (his means that

scenario 7 has a lower chance of generating net income because its sales in

packs to breakeven almost reaches the number of packs that the business can

sell. Business will be able to recover the initial cost of its investment less than 7

years e0cept for scenario 7.


81/81

revised aspects 3

Documents