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:
All lumber to be used are of good quality coco lumber
Flooring shall be of plain cement finish with 12 mm rsb
Seven layers of drying shelves made of bamboo slats on coco lumber framing
Scheme No. 2:
All lumber to be used are of good quality coco lumber
Flooring shall be of natural earthfill flooring
Seven layers of drying shelves made of bamboo slats of coco lumber framing
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:
* ALL LUMBER TO BE USED ARE OF GOOD QUALITY COCO LUMBER
* FLOORING SHALL BE OF PLAIN CEMENT
* SEVEN LAYERS OF DRYING SHELVES MADE OF BAMBOO SLATS ON COCO LUMBER FRAMING
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:
* ALL LUMBER TO BE USED ARE OF GOOD QUALITY COCO LUMBER
* FLOORING SHALL BE OF PLAIN CEMENT
* SEVEN LAYERS OF DRYING SHELVES MADE OF BAMBOO SLATS ON COCO LUMBER FRAMING
PROPOSED BUNKHOUSE FOR FISH DRYING
ASSUMPTIONS TO THE FINANCIAL PROJECTIONS
1. No. of Operating days per auntie : 20
2. The Bunkhouse can accommodate about 1,000 kilograms of fish for drying everyday
3. Volume and cost of fresh fish Per Month
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 | ||||
4. Cost of Salt Per Month
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 | ||||||
5 Labor Cost Per Month
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
6. Packaging Materials
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 |
7. Delivery Expense (Rent of Delivery Jeep Per Month)
No. of Boxes Per Month |
425 |
574 |
Delivery Cost Per 80x |
5 |
5 |
TOTAL |
P 2,125 |
P 2,870 |
8. Production/ Sales Per Month
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 |
9. Total Project Cost
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 |
10. Repair & Maintenance Cost is 5 X of capital cost of Bunkhouse divided by 12 months.
11. Schedule of Loan Amortization
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.
12. Computation of Depreciation Cost
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 | |||
FINANCIAL FEASIBILITY STUDY FOR VARIOUS FISHERY PRODUCTS IN CAPIZ AND PANGASINAN
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.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:
Option 1: Smoking of Milkfish- Traditional Way
Option 2: Smoking of Boneless Milkfish
Option 3: Smoking of Small Fish (Herring and Scads)
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.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 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.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:
a) The project will generate 28.98. return on its initial investment of P19,623.00;
b) This. initial investment will- be recouped within a period of 3.70 months; and
c) Product sales will yield a profit margin of 47.7%.
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.