Previous PageTable Of ContentsNext Page


Annexes


Annexes

Annex 1

1. PROJECT TITLE: BUNKHOUSE FOR FISH DRYING

2. LOCATION: Nibaliw, San Fabian, Pangasinan

3. TECHNICAL SPECIFICATIONS: (Please refer to the Schematic Diagrams for details)

Scheme No. 1:

Scheme No. 2:

4. INVESTMENT REQUIRED:

Two schemes were prepared based on the floor finishing: Scheme 1 - with concrete flooring and Scheme 2 - natural earthfill flooring costing as follows (Annex 1):

 

TOTAL COST

Scheme 1 -

P 34,500.00

Scheme 2 -

30,000.00

To reduce cost for both schemes, the existing drying trays being used by the proponent may be utilized with minor modifications.

The proposed structure has an estimated economic life of 10 years with minor repairs at 5 X. of total cost every three years. Hence, depreciation cost is estimated at :

 

DEPRECIATION COST

 

ANNUAL

MONTHLY

Scheme 1 -

P 3,450

P 287.50

Scheme 2 -

3,000

250.00

5. COMPARATIVE INCOME AND COST PROFILES

 

WITHOUT BUNKHOUSE

WITH BUNKHOUSE

   

SCHEME 1

SCHEME 2

GROSS SALES

P 531,250

P 717,188

P 717,188

Less: Cost of Raw Mat'ls/Inputs

     

Fresh Fish

414,000

57.2,270

532,270

Salt

17,010

22,050

22,050

Packaging Mat'ls

1,275

1,722

1,722

TOTAL

P 432,285

P 556,042

P 556,042

NET SALES

P 98,965

P 161,146

P 161,146

Less: Optng. Costs

     

Labor Cost

6,000

7,800

7,800

Rep & Maint. Cost

42

144

125

Deliver Expense

2,125

2,870

2,870

Depreciation Cost

186

427

332

TOTAL

P 8,353

P 11,241

P 11,127

GROSS PROFIT

P 90,612

P 149905

P 150,019

Less: Interest Exp.

-

82

769

NET PROFIT

P 90,612

P 149,823

P 149,250

6. PROFITABILITY INDICATORS

Return On Investment (%)

20.6

25.0

24.8

Payback Period (Months)

-

4.01

4.03

Profit Margin (%)

91.6

93.0

92.6

BILL OF MATERIALS

PROJECT: PROPOSED BUNKHOUSE FOR DRYING FISH (Scheme 1)

LOCATION: Nibaliw. San Fabian, Pangasinan

CODE

DESCRIPTION

QTY

UNIT

UNIT COST

TOTAL COST

REMARKS

I

Excavation

2.3

cum

     

II

Backfilling

         

III

Concrete and Masonry

         
 

Portland Cement

25

bags

100/bag

P 2,500.00

 
 

Ordinary Sand

2.5

cum

240/cum

600.00

 
 

Ordinary Gravel

3.5

cum

350/cum

1,225.00

 
 

150 mm CHB (ord.)

220

pcs

650/pc

1,430.00

 
 

10 mm RSB x 6.00 mm

10

pcs

48/pc

480.00

 
 

12 mm RSB x or., mm

15

pcs

60/pc

900.00

 
 

6.1 # 16 Wire

2

kl

30/kl

60.00

 
       

SUB-TOTAL

P 7,195.00

 
             

IV

Carpentry

         
 

Nets (use nets second)

24

lnm

500.0

P 500.00

 
 

Bamboo

30

pcs

45/DC

1,350.00

 
 

4x4x12 Oost Coco lu

6

pcs

7.50/bdf

720 00

 
 

2x6x10 GIRTS

3

pcs

7.55g/bdf

450.00

 
 

2x5x10 Rafter

13

pcs

7.50/bdf

812.50

 
 

2x3x10 Purlins

35

pcs

7.50/bdf

1,312.50

 
 

2x3x8 Vert/Hor. stud

60

pcs.

7.50/bdf

1,800. 00

 
 

2x3x8 Shelves Framing

45

pcs.

7.50/bdf

1,350.00

 
 

2x2x10 Shelves Framing

160

pcs.

7.50/bdf

4,000.00

 
       

SUB-TOTAL

P 12,655.0

 
             

V

Roofing

         
 

Corr. Plastic Roofing

33

pcs

120/pc

P 3,960.00

 
       

SUB-TOTAL

P 3,960.00

 
             

VI

Miscellaneous H'ware

         
 

#5 CWN

6

kls

27.50/kl

P 165.00

 
 

#4 CWN

6

kls

27 50/kl

165.00

 
 

#3 CWN

8

kls

27 50/kl

220.00

 
 

#2 CWN

5

kls

27.50/kl

137.50

 
 

#1 CWN

3

kls

27.50/kl

82.50

 
 

Roofing Nail (Umbrella)

2

kls

60/kl

120.00

 
 

1/8x2x12 Post Scrap/Bolts & Nuts

6

sets

70/set

420.00

 
       

SUB-TOTAL

P 1,310.00

 
       

SUB-TOTAL

P 25,120.00

 
         

8,792.00

 
         

439.60

 
             
       

GRAND TOTAL

P 34,351.60

 
       

SAY

P 34,500.00

 

I TOTAL MATERIAL COST

II LABOR COST (35%)

III CONTIGENGENCIES (5%)

NOTE:

PROJECT: PROPOSED BUNKHOUSE FOR DRYING FISH (Scheme 1)

LOCATION: Nibaliw. San Fabian, Pangasinan

CODE

DESCRIPTION

QTY

UNIT

UNIT COST

TOTAL COST

REMARKS

I

Excavation

         

II

Backfilling

         

III

Concrete and Masonry

         
 

Portland Cement

10

bags

100/bag

P 1,000.00

 
 

Ordinary Sand

2.5

cum

240/cum

360.00

 
 

Ordinary Gravel

3.5

cum

350/cum

525.00

 
 

150 mm CHB (ord.)

220

pcs

650/pc

1,430.00

 
 

10 mm RSB x 6.00 mm

10

pcs

48/pc

480.00

 
 

6.1 # 16 Wire

2

kl

30/kl

60.00

 
       

SUB-TOTAL

P 3,855.00

 
             

IV

Carpentry

         
 

Nets (use nets second)

24

lnm

500.0

P 500.00

 
 

Bamboo

30

pcs

45/DC

1,350.00

 
 

4x4x12 Oost Coco lu

6

pcs

7.50/bdf

720 00

 
 

2x6x10 GIRTS

6

pcs

7.55g/bdf

450.00

 
 

2x6x10 GIRTS

3

pcs

7.55g/bdf

360.00

 
 

2x5x10 Rafter

13

pcs

7.50/bdf

812.50

 
 

2x3x10 Purlins

35

pcs

7.50/bdf

1,312.50

 
 

2x3x8 Vert/Hor. stud

60

pcs.

7.50/bdf

1,800. 00

 
 

2x3x8 Shelves Framing

35

pcs.

7.50/bdf

1,050.00

 
 

2x2x10 Shelves Framing

160

pcs.

7.50/bdf

4,000.00

 
       

SUB-TOTAL

P 12,355.0

 
             

V

Roofing

         
 

Corr. Plastic Roofing

33

pcs

120/pc

P 3,960.00

 
       

SUB-TOTAL

P 3,960.00

 
             

VI

Miscellaneous H'ware

         
 

#5 CWN

6

kls

27.50/kl

P 165.00

 
 

#4 CWN

6

kls

27 50/kl

165.00

 
 

#3 CWN

8

kls

27 50/kl

220.00

 
 

#2 CWN

5

kls

27.50/kl

137.50

 
 

#1 CWN

3

kls

27.50/kl

82.50

 
 

Roofing Nail (Umbrella)

2

kls

60/kl

120.00

 
 

1/8x2x12 Post Scrap/Bolts & Nuts

6

sets

70/set

420.00

 
       

SUB-TOTAL

P 1,310.00

 
       

SUB-TOTAL

P 21,480.00

 
         

7,518.00

 
         

375.90

 
             
       

GRAND TOTAL

P 29,373.90

 
       

SAY

P 30,000.00

 

I TOTAL MATERIAL COST

II LABOR COST (35%)

III CONTIGENGENCIES (5%)

NOTE:

PROPOSED BUNKHOUSE FOR FISH DRYING

ASSUMPTIONS TO THE FINANCIAL PROJECTIONS

SPECIES

VOLUME

FREQUENCY

TOTAL VOL. PER MONTH W/O B'HSE

TOTAL VOL PER MONTH W/ B'HSE

COST PER

WITHOUT BUNKHOUSE

WITH BUNKHOUSE

 

(kg)

 

(kg)

(kg)

KG

 

SCHEME 1

SCHEME 2

BOLASI

450

4 x/week

7,200

9,257

P20.00

144,000

185,140

185,140

TUYO

15 boxes

daily

9,000

11,571

30.00

270,000

347,130

347,130

 

@ 30 kgs

             
     

TOTAL

20,828

 

414,000

532,270

532,270

SPECIES

TOTAL VOLUME PER MONTH

RATIO OF SALT TO FISH

TOTAL VOL. OF SALT

COST OF SALT

WITHOUT BUNKHOUSE

WITH BUNKHOUSE

 

WITH

W/O

 

WITH

W/O

/ SACK

 

SCHEME 1

SCHEME 2

BOLASI

9,257

7,200

1 SACK TO

31

24

315

P 7,560

P 9,765

P 9,765

     

10 BOXES

           

TUYO

11,571

9,000

-DO-

39

30

315

9,450

12,285

12,285

TOTAL

           

P 17,010

P 22,050

P 22,050

 

WITHOUT

WITH BUNKHOUSE

 

BUNKHOUSE

(Both Schemes)

No. of Persons

10

13

No. of Mandays/ Month *

10

10

Rate Per Day

60

60

TOTAL LABOR COST

P 6,000

P7,800

* Every other day

Total Production Per Month

P 8,500

P 11,475

No. Of Boxes required

425

574

Cost per Box

3

3

Total Cost of boxes

1,275

1,722

No. of Boxes Per Month

425

574

Delivery Cost Per 80x

5

5

TOTAL

P 2,125

P 2,870

Production Per Month (kg)

8,500

11,475

Average Price Per Kilo

P 62.50

P 62.50

Sales Per Month

P 531,250

P 717,188

 

SCHEME 1

SCHEME 2

 

LBP LOAN

EQUITY

TOTAL PROJECT COST

LBP LOAN

EQUITY

TOTAL PROJECT COST

Bunkhouse Capital Cost

P 34,500

 

P 34,500

P 30,000

 

P 30,000

Incremental Cost of

           

Fresh Fish

118,270

 

118,270

118,270

 

118,270

Salt

5,040

 

5,040

5,040

 

5,040

Packaging Materials

447

 

447

447

 

447

Incremental Optng. Cost

           

Labor Cost

 

P 1,800

1,800

 

P 1,800

1,800

Delivery Expenses

 

745

745

 

745

745

SOB-TOTAL

P 158,257

P 2,545

P 160,802

P 153,757

P 2,545

P 156,302

Cost without Bunkhouse

           

Cost of Fish

 

414,000

414,000

 

414,000

414,000

Cost of Salt

 

17,010

17,010

 

17,010

17,010

Cost of Pckg'g. Mat'ls.

 

1,275

1,275

 

1,275

1,27S

Optag. Costs - Labor

 

6,000

6,000

 

6,000

6,000

Delivery Expense

 

2,125

2,125

 

2,125

2,125

SUB-TOTAL

P -

440,410

440,410

 

440,410

440,410

TOTAL PROJECT COST

P 158,257

P 442,955

P 601,212

P 153,757

P 442,955

P 596,712

The loan is payable in 12 months at 14 X interest per annum.

MONTH

 

SCHEME 1

SCHEME 2

 

TOTAL AMORTIZATION

PRINCIPAL

INTEREST

BALANCE

TOTAL AMORTIZATION

PRINCIPAL

INTEREST

BALANCE

0

-

-

-

123,673.00

-

-

 

119,173.00

1

11,104.24

9,661.39

1,442.85

114,011.61

10,700.20

9,309.85

1,390.35

109,863 15

2

11,104.24

9,774.11

330.14

104,237.50

10,700.20

9,418.46

1,281.74

100,444.69

3

11,104.24

9,888.14

216.10

94,549.36

10,700.20

9,528.35

1,171.85

90,916.34

4

11,104.24

10,003.50

100.74

84,345.87

10,700.20

9,639.51

1,060.69

81,276.83

5

11,104.24

10,120.21

984.04

74,225.66

10,700.20

9,751.97

948.23

71,524.86

6

11,104.24

10,238.28

865.97

63,987.38

10,700.20

9,865.74

834.46

61,659.12

7

11,104.24

10,357.72

746.52

53,629.66

10,700.20

9,980.84

719.36

51,618.28

8

11,104.24

10,478.56

625.68

43,151.10

10,700.20

10,097.29

602.91

41,580.99

9

11,104.24

10,600.81

50".43

32,550.28

10,700.20

10,215.09

485.11

31,365.90

10

11,104.24

10,724.49

379.75

21,825.79

10,700.20

10,334.26

365.94

21,031.64

11

11,104.24

10,849.61

254.63

10,976.19

10,700.20

10,454.83

245.37

10,576.80

12

11,104.24

10,976.19

128.06

-

10,700.20

10,576.80

123.40

-

TOT

123,250.88

123,673.00

9,577.91

-

128,402.40

119,173.00

9,229.40

-

NOTE: Some figures may not add up to totals due to rounding.

ITEM

TOTAL COST

LIFE SPAN (yrs)

WITHOUT BUNKHOUSE

WITH BUNKHOUSE

       

SCHEME 1

SCHEME 2

Drying Trays

10,000

8

104

   

Banera (35 pcs X 140/pc.

4,900

5

82

82

82

Bunkhouse

         

Scheme 1

34,500

10

 

345

-

Scheme 2

30,000

10

 

-

250

     

186

427

332

Annex 2

FINANCIAL FEASIBILITY STUDY FOR VARIOUS FISHERY PRODUCTS IN CAPIZ AND PANGASINAN

1. Bottled Cooked Shrimp Paste

1.1 Project Cost and Financing Plan

To implement the project, a total of P24,575.00 is required. Breakdown of the project cost and the corresponding fund sources are presented below:

Item

LBP Loan

W.A. Equity

Total Project Cost

Cost of Raw Mat'ls/

     

Ingredients

P6,125

-

6,125

(Item 3, App. 1)

     

Bottles

7,000

-

7,000

       

Facilities & Equipment:

     

Salting Vats

 

P1,500

1,500

Working Table

 

1,200

1,200

Gas Stove

1,000

-

1,000

Pressure Cooker

5,000

-

5,000

Weighing Scale

400

-

400

Misc. Kitchen Tools

500

-

500

       

Operating Costs:

     

Fuel/Water

-

50

50

Labor Cost

-

300

300

Transportation Cost

-

1,400

1,400

Misc. Optng. Cost

-

100

100

       

TOTAL

P20,025

P4,550

P24,575

Percent of Total (%)

81.5

18.5

100.0

1.2 Result of Financial Projections

Through a series of financial projections shown in Schedules 1-A to 1-C, the project's financial profitability was appraised.

The project is expected to generate total sales revenues amounting to P67,200.00 per month yielding an average monthly net profit of P7,078.00

(Schedule 1-A).

As shown in Schedule 1-B, the project will be able to provide its cash requirements for operations as well as amortize the loan and the corresponding interest payments as presented in Schedule 1-C.

1.3 Measures of Financial Profitability

Selected profitability indicators were estimated using the financial projections, the results of which are as follows:

Return on Investment (ROI):

28.9%

Payback Period:

3.47 Months

Profit Margin :

48.1%

1.4 Break-Even Point Analysis

Since the project is a manufacturing concern, break-even point analysis is very significant. With the use of the break-even formula, the following break-even points were arrived at:

Break-even Sales Volume Per Month:

170 bottles

Break-even Selling Price:

P10.736/bottle

Therefore, on a monthly basis the project should be able to sell 170 bottles of cooked shrimp paste in order to cover all costs including interest payments on the LBP loan. At this sales volume level, the project would neither incur loss nor make a profit. The project's sales volume should never go beyond this level.

Similarly, selling price per bottle should not be lower than P10.736. It is this price which covers both variable and fixed costs, but provides no profit.

1.5 Conclusion as to Financial Viability

The results of this study indicate that the project is highly profitable. Coupled with its economic significance, in the micro scale, of increasing the value-added to the raw materials, the project is highly recommended for financing.

Appendix 1

ASSUMPTIONS TO THE FINANCIAL PROJECTIONS

1. Production Cycle:

One week (7 Man-days)

Preparation of Shrimp:

One Man-day

Fermentation:

Six Man-days

Cooking, bottling, washing and labelling:

One Man-day

2. No. of Production Cycles Per Month: Four

3. Raw Materials Cost per Cycle (Variable Costs)

Kind

Qty.

Unit

Unit Cost

Total Cost

Small Shrimps

100

kg.

P15.00

P1,500.00

Salt

20

kg.

4.00

80.00

Corn Oil

13

gal.

269.23

3,500.00

Garlic

5

kg.

120.00

600.00

Sugar

20

kg.

16.00

320.00

Vinegar

25

liter

5.00

125.00

TOTAL

     

P6,125.00

Cost of Raw Materials/Ingredients Per Month' P24,500.00

4. Operating Expenses Per Cycle (Variable Costs)

Item

Amount

Fuel/Water

P 50.00

Labor Cost (3 man-days x P100/day)

300.00

Transportation Cost (P1.00 per bottle)

1,400.00

Miscellanous Expenses

100.00

TOTAL

P1,850.00

Total Operating Costs Per Month: P7,400.00

5. Computation of Depreciation Cost

Item

Qty.

Unit Cost

Total Cost

Est. Life

Annual Dep'n

       

(Yrs.)

Cost

Salting Vats

2 pcs.

P750

P1,500

10

P 150

Working Table

1 pc.

1,200

1,200

8

150

Gas Stove

1 pc.

1,000

1,000

10

100

Pressure Cooker

1 pc.

5,000

5,000

10

500

Weighing Scale

1 pc.

400

400

8

50

Misc. Kitchen Tools

1 set

500

500

8

62.50

TOTAL

       

P1,012.50

Total Monthly Depreciation Cost

       

84.375

6. Cost of Bottles

1,400 pcs. x P5.00/bottle

Per Cycle : P7,000.00

 

Per Month : 28,000.00

7. Pricing Scheme

 

Cost Per Bottle

Variable Costs:

 

Raw Mat'ls/Ingredients

P4.375

Bottles

5.000

Operating Costs

1.321

SUB-TOTAL

P10.696

Fixed Costs:

 

Depreciation Cost

0.015

Interest Expense

0.025

SUB-TOTAL

P 0.040

TOTAL COST PER BOTTLE

P10.736

MARK-UP (12% of Total Cost)

1.264

SELLING PRICE PER BOTTLE

P12.000

8. Sales Revenues

Per Week (1,400 bottles x P12.00/bottle):

P16,800.00

Per Month (5,600 bottles x P12.00/bottle):

67,200.00

2. Smoked fish

2.1 Project Cost and Sources of Funds

Implementation-of the project necessitates the following cost components which will be drawn from the fund sources as indicated- below:

Item

LBP Loan

Pax Equity

Raw Materials/Ingredients

   

(Item 3, Appendix 2)

   

a. Milkfish Traditional

P1,300

-

b. Milkfish Deboned

1,480

-

c. Small Fish

 

2,000

Packaging Materials

   

(Item 4, Appendix 2)

   

a. Milkfish Traditional

P 60

-

b. Milkfish Deboned

60

-

c. Small fish

72

-

Facilities and Equipment

   

Smoke House

P1,000

-

Working Table

-

P1,200

Cooking Vat

1,000

-

Basins/Pails

1,000

-

Weighing Scale

400

-

Plastic Sealing Machine

2,000

-

Misc. Kitchen Tools

500

-

TOTAL

P5,900

P1,200

Operating Costs: P 350

The project may be implemented using either of the following three options based on the type of smoked fish products:

The project cost and fund sources for each option is hereunder-presented for comparison:

Item

LBP Loan

Pax Equity

Total Project Cost

OPTION 1: Milkfish - Traditional

     

Raw Mat'ls/Ingredients

P1,300

-

P1,300

Packaging Materials

60

-

60

Facilities & Eqpmt.

5,900

P1,200

7,100

Operating Expenses

-

350

350

TOTAL

P7,260

P1,150

P8,810

Percent of Total (%)

82.5

17.5

100.0

       

OPTION 2: Milkfish - Deboned

     

Raw Mat'ls/Ingredients

P1,480

-

P1,480

Packaging Materials

60

-

60

Facilities & Eqpmt.

5,900

P1,200

7,100

Operating Expenses

-

350

350

TOTAL

P7,440

P1,150

8,990

Percent of Total (%)

82,8

17.2

100.0

       

OPTION 2: Small Fish

     

Raw Mat'ls/Ingredients

P2,000

-

P2,000

Packaging Materials

72

-

72

Facilities & Eqpmt.

5,900

P1,200

7,100

Operating Expenses

-

350

350

TOTAL

P7,972

P1,550

9,522

Percent of Total (%)

83,7

16.3

100.0

2.2 Results of Financial Projections

Using accepted tools for financial analysis, the project's financial profitability under the different options was assessed the results of which are shown in Schedules 2-A to 2-C and summarized below:

Financial Results

 

Option 1

Option 2

Option 3

Total Monthly Sales

(P)

8,400

9,600

11,520

Gross Profit On Sales

(P)

2,960

3,440

3,232

Average Monthly Net Profit

(P)

1,426

1,905

1,693

2.3 Measures of Financial Profitability

The following profitability indicators were selected and estimated: for the three alternatives:

Financial Indicators

 

Option 1

Option 2

Option 3

Return on Investment

(%)

16.2

21.2

17.8

Payback Period

(Mos.)

6.2

4.7

5.6

Profit Margin

(%)

48.2

55.4

52.4

2.4 Break-Even Point Analysis

Project operations should be guided by the breakeven points in terms of sales volume and selling price per unit on a monthly basis as indicated below for each options:

Break-Even Points

 

Option 1

Option 2

Option 3

Break-Even Sales Volume Per Mo.

(Packs)

228

175

242

Break-Even Selling Price Per Unit

(P/pack)

34.68

37.68

38.99

Therefore, in: order to operate at break-even monthly sales volume should never be lower than the figures indicated. Correspondingly, with selling prices at break-even point, the project will recover both the fixed and variable costs.

2.5 Conclusion as to Financial Viability

On the basis of the above indicators Option 2 is recommended for implementation. As shown in Schedule 2-B, the project under Option 2 will be able to provide the daily cash requirements for the operation, as well as the loan amortizations according to the schedule (Schedule 2-C).

Appendix 2

ASSUMPTIONS TO THE FINANCIAL PROJECTIONS

1. Production Cycle:

One Day

2. No. of Production Cycles Per Month:

Four (4)

3. Paw Materials and Ingredients (Variable Costs) Per Cycle

Unit

Milkfish Traditional

Deboned

Small Fish

 

kg.

kg.

kg.

Quantity

20

20

40

Unit Cost

P65.00

P74.00*

P50.00

Total Cost Per Cycle

P1,300.00

P1,480.00

P2,000.00 .

Total Cost Per Month

5,200.00

5,920.00

8,000.00

*Includes cost of fish (three pieces per kilo) of P65.00 per kilo and labor cost for deponing of P3.00 per piece.

4. Packaging Materials

 

Milkfish

 
 

Traditional

Deboned

Small Fish

No. of Kilos Per Cycle

20

20

40

No. of Pieces Per Kilo

3

3

 

No. of Pieces/kg. Per Pack

1 pc.

1 pc.

1/2 kg.

No. of Packs Per Cycle

60

60

72

Cost of Packaging Mat'.ls. Per Piece

P1.00

P1.00

P1.00

Total Cost Per Cycle.

60.00

60.00

72.00

Per Month

240.00

240.00

288.00

6. Operating Costs per Cycle (Variable Costs)

Item

Amount

Fuel/Water

P 50.00

Labor Cost (2 mandays x P100/day)

200.00

Misc. Expenses

100.00

TOTAL

P 350.00

Total Operating Cost Per Mo:

P1,400.00

7. Computation of Depreciation Cost

ITEM

QTY.

UNIT COST

TOTAL COST

EST. LIFE SPAN. (Yrs.)

ANNUAL DEP'N.

Smoke House

         

(Barrel Type)

1

P1,000

P1,000

10

P 100

Working Table

1

1,200

1,200

8

150

Cooking Vat

1

1,000

1,000

8

125

Basin/Pails.

1 set

1,000

1,000

5

200

Weighing Scale

1

400

400

5

80

Plastic Sealing Machine

1

2,000

2,000

8

250

Misc. Kitchen Tools

1 set

500

500

5

100

TOTAL

   

P7,100

 

P1,005

Total Depreciation Cost Per Month: P 83.75

8. Selling Prices and Sales Revenues

Option

Selling Price Per Pack

No. of Packs Per Cycle

Sales Per Cycle

Per Mo.

Milkfish:

       

Traditional

P 35.00

60

P2,100

P8,400

Deboned

40.00

60

2,400

9,600

Small Fish

40.00

72

2,880

11,520

9. Pricing Scheme

 

Cost Per Pack

 

Milkfish

Small Fish

 

Traditional

Deboned

 

Variable Costs

     

Raw Mat'ls/Ingredients

P 21.67

P24.67

P 28.00

Packaging Materials

1.0.0

1.00

1.00

Operating Costs

5.83

5.83

4.86

SUB-TOTAL

P 28.50

P 31.50

P 33.86

Fixed Costs

     

Depreciation Cost

     

(P83.75 / 4 cycles - No. of Packs)

P 0.34

P 0.34

P 0.34

Interest Expense .

     

(Ave. Mo. Int / 4 cycles - No. of Packs )

0.21

0.21

0.19

       

SUB-TOTAL

P 0.55

P 0.55

P 0.53

TOTAL COST PER PACK

P29.05

P32.05

P34.39

MAPK-UP

5.95

7.95

5.61

Percent of Total Cost (%)

(20)

(25)

(16)

SELLING PRICE PEP PACK

P35.00

P40.00

P40.00

10. The loan is payable within a period of six months at 14% interest per annum.

Schedule 2-A1

SMOKED FISH

OPTION 1: MILKFISH-TRADITIONAL

PROJECTED INCOME STATEMENT

 

1

2

3

4

5

6

GROSS SALES

8,400

8,400

8,400

8,400

8,400

8,400

Less: Cost of Sales

           

Raw Material/Ingredients

5,200

5,200

5,200

5,200

5,200

5,200

Packaging Materials

240

240

240

240

240

240

TOTAL

5,440

5,440

5,440

5,440

5,440

5,440

GROSS PROFIT ON SALES

2,960

2,960

2,960

2,960

2,960

2,960

Less: Operating Costs

1,400

1,400

1,490

1,400

1,400

1,400

Depreciation Cost

84

84

84

84

84

84

TOTAL

1,484

1,484

1,484

1,484

1,484

1,484

Operating Profit

1,476

1,476

1,476

1,476

1,476

1,476

Less: Interest Expense

85

71

57

43

29

1

NET PROFIT

1,391

1,405

1,419

1,433

1,447

1,461

Computation of:

1. Return On Investment

 

   

2. Payback Period

 

   

3. Profit Margin

 

   

4. Break-Even Analysis

 

4.1 Break-Even Sales Volume Per Month

 

   

   

4.2 Break-Even S.P. Per Unit

 

   

   

Schedule 2-A2

SMOKED FISH

OPTION 2: DEBONED MILKFISH

PROJECTED INCOME STATEMENT

 

1

2

3

4

5

6

GROSS SALES

9,600

9,600

9,600

9,600

9,600

9,600

Less: Cost of Sales

           

Raw Material/Ingredients

5,920

5,920

5,920

5,920

5,920

5,920

Packaging Materials

240

240

240

240

240

240

TOTAL

6,160

6,160

6,160

6,160

6,160

6,160

GROSS PROFIT ON SALES

3,440

3,440

3,440

3,440

3,440

3,440

Less: Operating Costs

1,400

1,400

1,400

1,400

1,400

1,400

Depreciation Cost

84

84

84

84

84

84

TOTAL

1,484

1,484

1,484

1,484

1,484

1,484

Operating Profit

1,956

1,956

1,956

1,956

1,956

1,956

Less: Interest Expense

87

87

87

87

87

87

NET PROFIT

1,869

1,883

1,897

1,912

1,926

1,941

Computation of:

1. Return On Investment

 

   

2. Payback Period

 

   

3. Profit Margin

 

   

4. Break-Even Analysis

 

4.1 Break-Even Sales Volume Per Month

 

   

   

4.2 Break-Even S.P. Per Unit

 

   

   

Schedule 2-A3

SMOKED FISH

OPTION 3: SMALL FISH

PROJECTED INCOME STATEMENT

 

1

2

3

4

5

6

GROSS SALES

11,520

11,520

11,520

11,520

11,520

11,520

Less: Cost of Sales

           

Raw Material/Ingredients

8,000

8,000

8,000

8,000

8,000

8,000

Packaging Materials

288

288

288

288

288

288

TOTAL

8,288

8,288

8,288

8,288

8,288

8,288

GROSS PROFIT ON SALES

3,323

3,323

3,323

3,323

3,323

3,323

Less: Operating Costs

1,400

1,400

1,400

1,400

1,400

1,400

Depreciation Cost

84

84

84

84

84

84

TOTAL

1,484

1,484

1,484

1,484

1,484

1,484

Operating Profit

1,748

1,748

1,748

1,748

1,748

1,748

Less: Interest Expense

93

93

93

93

93

93

NET PROFIT

1,655

1,670

1,685

1,701

1,716

1,732

Computation of:

1. Return On Investment

 

   

2. Payback Period

 

   

3. Profit Margin

 

   

4. Break-Even Analysis

 

4.1 Break-Even Sales Volume Per Month

 

   

   

4.2 Break-Even S.P. Per Unit

 

   

   

Schedule 2-B

SMOKED FISH

OPTION 2: MILKFISH - DEBONED

PROJECTED CASH FLOW STATEMENT

 

0

1

2

3

4

5

6

CASH BALANCE, BEG.

-

1,890

2,639

3,388

4,137

4,886

5,635

Sources of Funds

 

.

       

.

Loan Proceeds

7,440

           

Equity

1,550

           

Sales

-

9,600

9,600

9,600

9,600

9,600

9,600

TOTAL CASH AVAILABLE

8,990

11,490

12,239

12,988

13,737

14,486

15,235

APPLICATION OF FUNDS:

             

Facilities & Equipment

7,100

           

Raw Materials & Ingredients

 

5,920

5,920

5,920

5,920

5,920

5,920

Packaging Mat'ls.

 

240

240

240

240

240

240

Operating Exp. *

 

1,400

1,400

1,400

1,400

1,400

1,400

Loan Amortization

 

1,291

1,291

1,291

1,291

1,291

1,291

TOTAL CASH OUTFLOW

7,100

8,851

8,851

8,851

8,851

8,851

8,851

CASH BALANCE, ENDING

1,890

3,388

4,137

4,886

5,653

6,384

 

* Net Depreciation Cost

Schedule 2-C

SMOKED FISH

LOAN AMORTIZATION SCHEDULE

OPTION 1: MILKFISH TRADITIONAL

MONTH

TOTAL AMORTIZATION

PRINCIPAL

INTEREST

BALANCE

0

-

 

-

7,260.00

1

1,259.89

1,175.19

84.70

6,084.81

2

1,259.89

1,188.90

70.99

4,895.92

3

1,259.89

1,202.77

57.12

3,693.15

4

1,259.89

1,216.80

43.09

2,476.35

5

1,259.89

1,236.80

28.89

1,245.36

6

1,259.89

1,245.00

14.53

-

TOTAL

7,559.34

7,260.00 *

299.32 *

-

OPTION 2 : MILKFISH - DEBONED

0

-

-

-

7,440.00

1

1,291.12

1,204.32

82.80

6,235.81

2

1,291.12

1,218..37

72.75

5,017.92

3

1,291.12

1,232.59

58.53

3,784.15

4

1,291.12

1,246.97

44.15

2,537.35

5

1,291.12

1,261.51

29.61

1,276.36

6

1,291.12

1,276.22

14.89

-

TOTAL

7,746.72

7,440.00 *

306.74

-

OPTION 3: SMALL FISH

0

-

-

-

7,972.00

1

1,383.44

1,290.44

93.00

6,681.56

2

1,383.44

1,305.49

77.55

5,376.07

3

1,383.44

1,320.72

62.72

4,055.34

4

1,383.44

1,336.13

47.21

2,719.21

5

1,383.44

1,351.72

31.72

1,367.49

6

1,383.44

1,567.49

15.95

-

TOTAL

8,300.64

7,972.00 *

3:28.67

-

* May not add up to totals due to rounding.

3. Tuna ham

3.1 Project Cost and Financing Plan

A total of P32,143.00 is required to implement the project. This amount will be sourced and utilized as follows:

Item

LBP Loan

Pax Equity

Total Project Cost

Cost of Raw Mat'ls./Ingredients

P13,753

-

P13,753

- Packaging Materials

-

P 240

240

Facilities & Eqpmt.

     

Refrigerator

15,000-

-

15,000

Smoke House -

-

800

800

Kitchen Utensils

-

800

800

Plastic Sealer

1,000

-

1,000

Operating Costs

     

Electricity/Water/Fuel

-

150

150

Labor Cost

-

300

300

Misc. Expenses

-

100

100

TOTAL

P29,753

P2,390

P32,143

Percent of Total (%)

92.6

7.4

100.0

3.2 Results of Financial Projections

A series of financial projections was undertaken to ascertain the financial profitability of the project. The results are shown in Schedules 3-A to 3-C.

The project will generate gross sales amounting to P76,000.00 per month yielding an average monthly net profit of PS,471.50 (Schedule 3-A).

No serious cash flow problem is foreseen as the project is expected to generate adequate funds to sustain its operation and pay for its-debt-service obligations as presented in Schedule 5-C.

3.3 Measures of Financial Profitability

The project has been found to be financially viable based on the following indicators

Return on Investment (ROI):

17.02%

Payback Period:

5.87 Months

Profit Margin

8.2

3.4 Break-Even Point Analysis

Using the break-even formula, determination of the break-even points will provide very important guideposts in the operation of the project. On a monthly basis, the project should be able to dispose 10.31 packs of tuna ham to cover all costs including interest payments on the. loan. At this level of sales volume, the project will just break-even, i.e., no loss nor profit. The project's sales volume should at all times never be lower than this level.

On the other hand, selling price should never go beyond P146.32 per pack in order to cover both variable and fixed costs. However, there is no profit at the break-even selling-price.

Please refer to Schedule 3-A for details.

3.5 Conclusion a- to Financial Viability

The ensuing study, therefore, points out the financial profitability of the project which also demonstrates how fish processing technologies can add economic value to fishery products and help expand the income opportunities of women in fishing communities.

The potentials : of the finished product in the export market is another plus factor that should be developed through technology improvement, quality control and packaging innovations, among others.

The project is, therefore, recommended for financing.

Appendix 3

ASSUMPTIONS TO THE FINANCIAL PROJECTIONS

1. Production Cycle : One Week

Preparation of tuna fillets:

One man-day

Curing:

Five man-days

Washing/draining, smoking and cooling/packing:

One man-day

2. No. of Production Cycles Per Month: Four

3. Production Volume

Per cycle:

100 Packs

Per Month:

400 Packs

4. Raw Materials Cost Per Cycle (Variable Costs)

Kind

Unit

Qty.

Unit Cost

Total Cost

Fresh Tuna

kg.

300

P50.00

P15,000.00

Sugar

kg.

30

20.00

600.00

Salt

kg.

31

3.87

120.00

White wine

liter

24

23.25

558.80

Salt Peter

tsp.

31

0.59

20.00

Ascorbic acid

pc.

124

0.81

100.00

Pineapple Juice

gal.

4

65.00

260.00

Brown Sugar

kg.

4

15.50

62.00

Bay leaves

gram

100

0.33

33.00

TOTAL

     

P16,753.00

Cost of Raw Mat'ls./Ingredients Per Mo:

P61,012.00

5. Operating Expenses Per Cycle (Variable Casts)

Item

Amount

Electricity/Water/Fuel

P150.00

Labor Cost (3 man-days x P100/day)

300.00

Miscellanous Expenses

100.00

TOTAL

P550.00

Total Operating Costs Per Mo.:

P2,200.00

6. Computation of Depreciation Cost

Item

Qty.

Unit Cost

Total Cost

Est. Life Span (yrs.)

Annual Dep'n.

Refrigerator

1

P15,000

P15,000

10

P1,500

Smoke House

1

800

800

8

100

Kitchen Utensils

1 set

800

800

8

100

Plastic Sealer

1

1,000

1,000

8

125

TOTAL

   

P17,600

 

P1,825

Total Monthly Depreciation Cost: P152.08

7. Cost of Packaging Materials

Per Cycle (100 pcs. x P2.40/pc.):

P240.00

Per Month (400 pcs. x 2.40/pc.):

960.00

8. Pricing Scheme

 

Cost Per Pack

Variable Costs

 

Paw Materials/Ingredients

P 137.53

Packaging Materials

2.40

Operating Costs

5 50

SUB-TOTAL

P 145.43

Fixed Costs:

 

Depreciation Cost

P 0.38

Interest Expense*

0.51

SUB-TOTAL

P 0.89

TOTAL COST PER PACK

P 146.32

MARK-UP (23% of Total Cost)

33.68

SELLING PRICE PEP PACK

P 180.00

* Based on average monthly interest.

9. Sales Revenues

Per Week:

 

Tuna Ham (100 packs x P180/pack)

P18,000.00

Fresh Head & BeIly Scrap (50 kgs. x P20/kg.)

1,000.00

Total Sales Per Week

P19,000.00

Per Month

P76,000.00

10. The loan is payable within six months at 14/. interest per annum.

Schedule 3-A

TUNA HAM MAKING

PROJECTED INCOME STATEMENT

 

1

2

3

4

5

6

GROSS SALES

76,000

76,000

76,000

76,000

76,000

76,000

Less: Cost of Sales

           

Raw Material/Ingredients

67,012

67,012

67,012

67,012

67,012

67,012

Packaging Materials

960

960

960

960

960

960

TOTAL

67,972

67,972

67,972

67,972

67,972

67,972

GROSS PROFIT ON SALES

8,028

8,028

8,028

8,028

8,028

8,028

Less: Operating Costs

2,200

2,200

2,200

2,200

2,200

2,200

Depreciation Cost

152

152

152

152

152

152

TOTAL

2,352

2,352

2,352

2,352

2,352

2,352

Operating Profit

5,676

5,676

5,676

5,676

5,676

5,676

Less: Interest Expense

347

291

234

177

118

60

NET PROFIT

5,392

5,385

5,442

5,499

5,558

5,616

Computation of:

1. Return On Investment

 

   

2. Payback Period

 

   

3. Profit Margin

 

   

4. Break-Even Analysis

 

4.1 Break-Even Sales Volume Per Month

 

   

   

4.2 Break-Even S.P. Per Unit

 

   

   

Schedule 3-B

TUNA HAM MAKING

PROJECTED CASH FLOW STATEMENT

 

0

1

2

3

4

5

6

CASH BALANCE, BEG.

-

14,543

15,208

15,873

16,538

17,203

17,868

SOURCES OF FUNDS:

             

Loan Proceeds

29,753

           

Equity

2,390

           

Sales

 

76,000

76,000

76,000

76,000

76,000

76,000

TOTAL CASH AVAILABLE

32,143

90,543

91,208

91,873

92,538

93,203

93,868

APPLICATION OF FUNDS:

             

Facilities & Equipment

17,600

           

Raw Materials & Ingredients

 

67,012

67,012

67,012

67,012

67,012

67,012

Packaging Mat'ls.

 

960

960

960

960

960

960

Operating Exp. *

 

2,200

2,200

2,200

2,200

2,200

2,200

Loan Amortization

 

5,163

5,163

5,163

5,163

5,163

5,163

TOTAL CASH OUTFLOW

17,600

75,335

75,335

75,335

75,335

75,335

75,335

CASH BALANCE, ENDING

14,543

15,208

15,873

16,538

17,203

17,868

18,533

* Net Depreciation Cost

Schedule 3-C

TUNA HAM MAKING

LOAN AMORTIZATION SCHEDULE

MONTH

TOTAL AMORTIZATION

PRINCIPAL

INTEREST

BALANCE

0

 

-

-

29,753.00

1

5,163.28

4,816.16

347.12

24,936.84

2

5,163.28

4,872.35

290.93

20,064.50

3

5,163.28

4,929.19

234.09

15,135.31

4

5,163.28

4,986.70

176.58

10,104.61

5

5,163.28

5,044.88

118.40

5,103.73

6

5,163.28

5,103,73 *

59.54

 

TOTAL

30,979.68

29,753.00 *

1,226.66 *

 

* May not add up to totals due to rounding.

4. Oyster sauce

4 1 Project Cost and Sources of Funds

The project requires a total amount of P14,868.00 for its implementation. The sources and uses of funds are as follows:

Item

LBP Loan

Pax Equity

Total Project Cost

Cost of Raw Mat'ls. Ingredients

P 998

-

P 998

Bottles

1,600

-

1,600

Facilities & Eqpmt.:

     

Pressure Cooker

5,000

-

5,000

Osterizer

2,000

-

2,000

Gas Stove

1,500

-

1,500

Cooking Kettles

1,000

-

1,000

Working Table

-

P1,200

1,200

Weighing Scale

400

-

400

Misc. Kitchen Tools

500

-

500

Operating Costs:

     

Fuel/Water

-

50

50

Transportation Cost

-

320

320

Labor Cost

-

200

200

- Misc. Expenses

-

100

104

TOTAL

P2,998

P1,870

P14,868

Percent of Total (%)

87,4

12.6

.100.0

4.2 Results of Financial Projections

As shown in Schedules 4-A to 4-C, the project has been found to be financially profitable. In fact, it is expected to generate sales amounting to P17,920..00 per month yielding an average monthly net profit of P4,645.00

Income and cash flow projections indicate continuous profitable project operation wit-in no cash flow problem. Funds generated from operations will be able to provide the daily cash requirements of the project as well as the loan amortizations to be paid to the bank.

4.3 Measures of Financial Profitability

To assess the profitability of the project, the following financial indicators were computed and summarized below:

Return on Investment (ROI):

31.24%

Payback Period:

3.20 Months

Profit Margin:

61.7%

4,4 Break-Even Point analysis

Like any manufacturing concern, break-even point analysis is a very significant tool for financial analysis. Using the break-even formula, the following breakeven points were computed:

Break-Even Sales volume Per Mo.:

54.19

Bottles Break-Even Selling Price Per Unit:

P10.371

4.5 Conclusion as to Financial Viability

The project is highly profitable as indicated by the results of the study. It is likewise economically desirable since the processing technology increases the value-added to the raw materials.

It is therefore recommended for financing.

APPENDIX 4

ASSUMPTIONS TO THE FINANCIAL PROJECTIONS

1. Production Cycle: One day

No. of Cycles

- Per Week:

One

- Per Month:

Four

2. Production Volume

- Per Cycle:

320 Bottles

- Per Month:

1,280 Battles

Raw Materials and Ingredients (Variable Casts) Per Cycle

Kind:

Unit

Qty.

Unit Cost

Total Cost

Oyster Meat

kg.

10

P 10.00

P 100.00

Brown Sugar

kg.

6

16.00

96.00

Corn Starch

kg.

1.6-

20.00

32.00

HVP

gram

2,580

0.237

611.00

Caramel Color

liter

7

20.714

145.00

Sodium Benzoate

gram

-24

0.0625

1.50

Salt

kg.

2.7

4.44

12.00

TOTAL

     

P 997.50

Cost of Paw Materials/Ingredients Per Mo.:

P3,990.00

4. Cost of Bottles

Per Cycle (320 bottles x P5.00/bottle):

P1,600.00

Per Month (320 bottles x 4 x P5.00/bottle):

6,400.00

5. Operating Costs Per Cycle (Variable Costs)

Item

Amount

Fuel/Water

P 50.00

Transportation Cost (320 bottles x P1.00/bottle)

320.00

Labor Cost (2 man-days x P100.00/day)

200.00

Miscellaneous Expenses

100.00

TOTAL COST

 

- Per Cycle

P670.00

- Per Month

P2 680;00

6. Computation of Depreciation Cost

Item

Qty.

Unit Cost

Total Cost

Est. Life Span (Yrs.)

Annual Dep'n.

Pressure Cooker

1

P5,000

P5,000

10

P500

Osterizer

1

2,000

2,000

8

250

Gas Stove

1

1,500

1,500

8

187.50

Cooking Kettles

2

500

1,000

8

125

Working Table

1

1,200

1,200

8

150

Weighing Scale

1

400

400

5

100

Misc. Kitchen Tools

1 set

500

500

5

100

TOTAL DEPRECIATION COST

     

- Annual

P1,392.50

       

- Per Month

P 116.04

7. Pricing Scheme

 

Cost Per Bottle

Variable Costs:

 

Raw Materials/Ingredients

P 3.117

Bottle

5.000

Operating Costs

2.094

SUB-TOTAL

P10.211

Fixed Costs:

 

Depreciation Cost

P 0.014

Interest Expense

0.011*

SUB-TOTAL

P 0.025

TOTAL COST PER BOTTLE

P10.236

MARK-UP (36X. of Total Cost)

3.764

SELLING PRICE PER BOTTLE

P14.000

* Based on Average Monthly Interest.

8. Sales Revenues

Per Cycle (320 x P14.00/bottIe):

P 4,480.00

Per Month (320 x 4 cycles/week x P14.00/bottle):

17,920.00

9. The loan is payable within a period of six months at 14% interest per annum.

Schedule 4-A

OYSTER SAUCE MAKING

PROJECTED INCOME STATEMENT

 

1

2

3

4

5

6

GROSS SALES

17,920

17,920

17,920

17,920

17,920

17,920

Less: Cost of Sales

           

Raw Material/Ingredients

3,990

3,990

3,990

3,990

3,990

3,990

Packaging Materials

6,400

6,400

6,400

6,400

6,400

6,400

TOTAL

10,390

10,390

10,390

10,390

10,390

10,390

GROSS PROFIT ON SALES

7,530

7,530

7,530

7,530

7,530

7,530

Less: Operating Costs

2,680

2,680

2,680

2,680

2,680

2,680

Depreciation Cost

116

116

116

116

116

116

TOTAL

2,796

2,796

2,796

2,796

2,796

2,796

Operating Profit

4,734

4,734

4,734

4,734

4,734

4,734

Less: Interest Expense

152

127

102

77

52

26

NET PROFIT

4,582

4,607

4,632

4,657

4,682

4,708

Computation of:

1. Return On Investment

 

   

2. Payback Period

 

   

3. Profit Margin

 

   

4. Break-Even Analysis

 

4.1 Break-Even Sales Volume Per Month

 

   

   

4.2 Break-Even S.P. Per Unit

 

   

   

Schedule 4-B

OYSTER SAUCE MAKING

PROJECTED CASH FLOW STATEMENT

 

0

1

2

3

4

5

6

CASH BALANCE, BEG.

-

3,268

5,862

8,456

11,050

13,644

16,238

SOURCES OF FUNDS:

             

Loan Proceeds

12,998

           

Equity

1,870

           

Sales

-

17,920

17,920

17,920

17,920

17,920

17,920

TOTAL CASH AVAILABLE

14,868

21,188

23,782

26,376

28,970

31,564

34,158

APPLICATION OF FUNDS:

             

Facilities & Equipment

11,600

           

Raw Materials & Ingredients

 

3,990

3,990

3,990

3,990

3,990

3,990

Packaging Mat'ls.

 

6,400

6,400

6,400

6,400

6,400

6,400

Operating Exp. *

 

2,680

2,680

2,680

2,680

2,680

2,680

Loan Amortization

 

2,256

2,256

2,256

2,256

2,256

2,256

TOTAL CASH OUTFLOW

11,600

15,326

15,326

15,326

15,326

15,326

15,326

CASH BALANCE, ENDING

3,268

5,862

8,456

11,050

13,644

16,238

18,832

* Net Depreciation Cost

Schedule 4-C

OYSTER SAUCE MAKING

LOAN AMORTIZATION SCHEDULE

MONTH

TOTAL AMORTIZATION

PRINCIPAL

INTEREST

BALANCE

0

     

12,998.00

1

2,255.64

2,104.00

151.64

10,894.00

2

2,255.64

2,128.55

127.09

8,765.45

3

2,255.64

2,153.38

102.26

6,612.06

4

2,255.64

2,178.50

77.14

4,433.52

5

2,255.64

2,203.92

51.72

2,229.63

6

2,255.64

2,222.63

26.01

-

TOTAL

13,533.84

12,998.00

535.86

 

* May not add up to totals due to rounding.

5. French style bottled herring

5.1 Project Cost and Financing Scheme

The project :requires an investment amounting to P19,623.00 for implementation to be financed according to the following scheme:

Item

LBP Loan

Pax Equity.

Total Project Cost

Cost of Raw Materials/Ingredients (Item 4, Appendix 5)

P5,323

-

 

P5,323

     

Bottles

4,500

-

4,500

Facilities & Eqpmt. (Item 7, Appendix .5)

8,400

-

8,400

Operating Costs (Item 6, Appendix 5)

-

P1,400

1,400

TOTAL

P18,223

P1,400

P19,623

Percent of. Total (%)

92.87

7.13

100.00

5.2 Results of Financial Projections

The-project's financial profitability was appraised through a series of financial projections and analyst 5 the results of which are presented in Schedules 5-A to SC.

The project its expected to generate total. sales revenues reaching P50,400.00 per month yielding an average monthly net profit of P5,300.00 (Schedule 5-A).

As shown in Schedule 1-B, the project's cash requirements will be adequately. provided from its operation, and at the sane time,. providing for its debt-service obligations.

5.3 Measures of Financial Profitability

Selected profitability indicators were estimated using the financial projections. The results are as follows:

5.4 Break-Even Point Analysis

Being a manufacturing concern, the project should observe and be guided by the break-even points which have been computed and are hereunder presented:

Break-even Sales Volume Per Month:

136 Bottles

Break-even Selling Price Per Unit:

P12.53

It is significant to note 'that at the break-even sales . volume level, all costs including- interest payments on-the loan are covered. However, the project will neither make profit nor incur looses. The project, therefore', should be able to sell more-than this breakeven sates volume per month.

Similarly, selling price per bottle should not be lower than P12.53. It is this price per unit which covers both- variable and fixed costs, but provides no profit.

5.5 Conclusion as to Financial Viability

This study indicates that the project is highly viable from the financial standpoint. At the same time, it is economically significant due to its ability to add more economic value to the fishery raw materials which would otherwise have lower economic value without the introduction of the processing technology.

All these benefits will redound to the socio-economic uplifting of the women-participants through improvement of their income opportunities.

APPENDIX 5

ASSUMPTIONS TO THE FINANCIAL PROJECTIONS

1. Production Cycle

One day

2. No. of Production Cycles Per Month:

Four (once a week)

3. Production Volume

 

Per Cycle:

900 Bottles

Per Month:

3,600 Bottles

4. Paw Materials and Ingredients (Variable Costs ) Per Cycle

Kind

Unit

Qty.

Unit Cost

Total Cost

French Herring

kg.

100

P 15.00

P 1,500

Corn Oil

liter

56.25

53.33

3,000

Pickles

kg.

1

100.00

100

Cloves

gal.

2

120.00

240

Oil

gal.

2

120.00

240

Bay Leaves

gram

100

0.33

33

Black Pepper

kg.

0.25

160.00

40

Hot Pepper (Sili)

pc.

900

0.033

30

Salt

kg.

35

4.00

140

TOTAL

     

P5.323

Total Cost of Raw Mat'ls./Ingredients Per Month:

P21,292

5. Bottles

Per Cycle (900 bottles x P5.00/bottle):

P 4,500

Per Month (900 bottles x 4 cycles x P5.00/bottle):

18,000

6. Operating-Costs-Per Cycle (Variable Costs)

Item

Amount

Fuel/water

P 100.00

Transportation Cost

900.00

Labor Cost (3 man-days x P100/day)

300.00

Miscellaneous Expenses

100 00

TOTAL COST

 

- Per Cycle

P1,400.00

- Per Month

P5,600.00

7. Computation of Depreciation Cost

Item

Qty.

Unit Cost

Total Cost

Est.Life Span (Yrs.)

Annual Dep'n.

Pressure Cooker

1

P 5,000

P 5,000

10

P 500

Gas Stove

1

1,000

1,000

8

125

Working Table

1

1,200

1,200

8

150

Weighing Scale

1

400

400

5

80

Cooking Kettle

1

300

300

8

37.50

Misc. Kitchen Tools

1 set

500

500

5

100

TOTAL -

P8,400

 

P992.50

   

Total Depreciation Cost Per Month:

P 82.71

8. Pricing Scheme

 

Cost Per Bottle

Variable Costs:

 

Raw Materials/Ingredients

P. 5.914

Bottle

5.000

Operating Costs

1.556

SUB-TOTAL

P12.470

Fixed Costs:

 

Depreciation Cost

P 1.103

Interest Expense

0.139*

SUB-TOTAL

P 1.242

TOTAL COST PER BOTTLE

P13.712

MARK-UP (2.1% of Total Cost)

0.288

SELLING PRICE PER BOTTLE

P14.000

* Based-on average monthly interest.

9. Sales Revenues

Per Cycle (900 battles x P14/bottle):

P 12,600.00

Per Month (900 bottles x 4 cycles x P14/bottle):

50,400.00

10. The loan is payable in six months at 14X interest per annum.

Schedule 5-A

FRENCH STYLE BOTTLED HERRING

PROJECTED INCOME STATEMENT

 

1

2

3

4

5

6

GROSS SALES

50,400

50,400

50,400

50,400

50,400

50,400

Less: Cost of Sales

           

Raw Material/Ingredients

21,292

21,292

21,292

21,292

21,292

21,292

Packaging Materials

18,000

18,000

18,000

18,000

18,000

18,000

TOTAL

39,292

39,292

39,292

39,292

39,292

39,292

GROSS PROFIT ON SALES

11,108

11,108

11,108

11,108

11,108

11,108

Less: Operating Costs

5,600

5,600

5,600

5,600

5,600

5,600

Depreciation Cost

83

83

83

83

83

83

TOTAL

5,683

5,683

5,683

5,683

5,683

5,683

Operating Profit

5,425

5,425

5,425

5,425

5,425

5,425

Less: Interest Expense

213

178

143

108

73

36

NET PROFIT

5,212

5,247

5,282

5,317

5,352

5,389

Computation of:

1. Return On Investment

 

   

2. Payback Period

 

   

3. Profit Margin

 

   

4. Break-Even Analysis

 

4.1 Break-Even Sales Volume Per Month

 

   

   

4.2 Break-Even S.P. Per Unit

 

   

   

Schedule 5-B

FRENCH STYLE BOTTLED HERRING

PROJECTED CASH FLOW STATEMENT

 

0

1

2

3

4

5

6

CASH BALANCE, BEG.

-

11,223

13,569

15,915

18,261

20,607

22,953

SOURCES OF FUNDS:

             

Loan Proceeds

18,223

           

Equity

1,400

           

Sales

-

50,400

50,400

50,400

50,400

50,400

50,400

TOTAL CASH AVAILABLE

 

61,623

61,623

61,623

61,623

61,623

61,623

APPLICATION OF FUNDS:

             

Facilities & Equipment

8,400

           

Raw Materials & Ingredients

 

21,292

21,292

21,292

21,292

21,292

21,292

Packaging Mat'ls.

 

18,000

18,000

18,000

18,000

18,000

18,000

Operating Exp. *

 

5,600

5,600

5,600

5,600

5,600

5,600

Loan Amortization

 

3,162

3,162

3,162

3,162

3,162

3,162

TOTAL CASH OUTFLOW

8,400

48,054

48,054

48,054

48,054

48,054

48,054

CASH BALANCE, ENDING

11,223

13,569

15,915

18,261

20,607

22,953

25,299

* Net Depreciation Cost

Schedule 5-C

FRENCH STYLE BOTTLED HERRING

LOAN AMORTIZATION SCHEDULE

MONTH

TOTAL AMORTIZATION

PRINCIPAL

INTEREST

BALANCE

0

-

-

-

18,223.00

1

3,162.38

2,949.78

212.60

15,273.22

2

3,162.38

2,984.19

178.19

2,289.02

3

3,162.38

3,019.01

143.37

9,270.01

4

3,162.38

3,054.23

108.15

6,215.78

5

3,162.38

3,089.86

72.52

3,125.91

6

3,162.38

3,125.91

 

-

TOTAL

18,974.30

18,223.00

751.30

-

* May not add up to totals due to rounding.

Previous PageTop Of PageTable Of ContentsNext Page