Weight in Retail PriceQty./Mo.
2024 2025 2026
Qty. Sales in Peso Qty. Sales in Peso Qty. Sales in Peso
100 g 142 685 8220 1167240 8902 1264084 9641 1369022
Total 685 8220 1167240 8902 1264084 9641 1369022
2027 2028
Qty. Sales in Peso Qty. Sales in Peso
10,441 1482622 11,308 1605736
10441 1482622 11308 1605736
Expenses Cost/pc 685pcs. - Total 2024
Qty./Month
Materials:
Pineapple 15 per kg/350 kg 5,250 63000
Sweetener (Sugar) 42 per kg/50 kg 2,100 25200
Salt 29 per kg/25kg 725 8700
Plastic 0.18 per piece/685 pcs 124 1488
Label 0.05 per piece/685 pcs 35 420
Equipment:
Vacuum Fryer 435,085 per piece/1pc 435,085 435,085
Knife 194 per piece/5pcs 970 970
Mandoline slicer 162 per piece/5 pcs 810 810
Disposable Gloves 46 per box (100 pcs) 46 46
Hairnet 67 per piece/5pcs 335 335
Apron 199 per piece/5pcs 995 995
Digital Weighing Scale 1,500 per piece/2pcs 3,000 3,000
Total:
Operating Expenses:
Utilities: 1,470 (Electricity) 4,169 50028
(Water, electricity and 1,400 (Water) 0
Internet) 1,299 (Internet) 0
Labor 416 per day/5 employee 49,920 599040
Rent 7,513 7,513 90156
Insurance 3,628 3,628 43536
Marketing and Advertisi 5,000 5,000 60000
Permit and License 8,980 8,980 8,980
Depreciation 2,511.33 2,511.33 30,136
Total: Initial Investmment 531,196 1,421,925
2024 2025 2026 2027
Revenues 1,167,240 1,264,084 1,369,022 1,482,622
Cost of Goods Sold 697,848 755,769 818,498 886,433
Materials 98,808 107,009 115,891 125,510
Labor 599,040 648,760 702,607 760,923
Gross Profit 469,392 508,315 550,524 596,189
Expenses 283,136 290,593 298,330 306,357
Utilities (3.5%) 50,028 51,779 53,591 55,467
Rent (4%) 90,156 93,762 97,513 101,414
Insurance 43,536 43,536 43,536 43,536
Marketing and Advertising ( 60,000 62,100 64,274 66,524
Permit and License 8,980 8,980 8,980 8,980
Depreciation 30,436 30,436 30,436 30,436
Income Before Taxes 186,256 217,722 252,194 289,832
Tax (30%) 55876.8 65316.6 75658.2 86949.6
Net Income 130,379 152,405 176,536 202,882
2028
1,605,736
960,007
135,927
824,080
645,729
314,683
57,408
105,471
43,536
68,852
8,980
30,436
331,046
99313.8
231,732
2024 2025 2026 2027 2028
Beginning Balance 531,196 220,334 372,739 549,275 752,157
Cash Inflows(Income)
Cash Sales 1,167,240 1,264,084 1,369,022 1,482,622 1,605,736
Total Cash Inflows 1,698,436 1,484,418 1,741,761 2,031,897 2,357,893
Cash Outflows
Materials 98,808 107,009 115,891 125,510 135,927
Labor 599,040 648,760 702,607 760,923 824,080
Equipment 441,241 0 0 0 0
Utilities 50,028 51,779 53,591 55,467 57,408
Rent 90,156 93,762 97,513 101,414 105,471
Insurance 43,536 43,536 43,536 43,536 43,536
Marketing and Advertisi 60,000 62,100 64,274 66,524 68,852
Permit and License 8,980 8,980 8,980 8,980 8,980
Depreciation 30,436 30,436 30,436 30,436 30,436
Owners Withdrawal 55,877 65,317 75,658 86,950 99,314
Total Cash Outflows 1,478,102 1,111,679 1,192,486 1,279,740 1,374,004
Ending Cash Balance 220,334 372,739 549,275 752,157 983,889
2024 2025 2026 2027 2028
ASSETS
Current Asset
Cash at Hand 130,379 152,405 176,536 202,882 231,732
Total Current Asset 130,379 152,405 176,536 202,882 231,732
Fixed Assets 50,000 61,000 100,000 110,000 120,241
Total Fixed Assets
Total Assets 180,379 213,405 276,536 312,882 351,973
LIABILITIES AND EQUITY
Current Liabilities
Income Tax Payable 55,877 65,317 75,658 86,950 99,314
Short Term Payables 0 0 0
Total Current Liabilities 55,877 65,317 75,658 86,950 99,314
Total Liabilities 55,877 65,317 75,658 86,950 99,314
Add: Net Profit 180,379 213,405 276,536 312,882 351,973
Less: Drawings 55,877 65,317 75,658 86,950 99,314
Net Capital 124,502 148,088 200,878 225,932 252,659
Total Liabilities and Equity 180,379 213,405 276,536 312,882 351,973
Year Production Price Expenses ROI
2024 8220 142 1,421,925 -254685
2025 8902 142 980,684 283400
2026 9641 142 980,684 388338
2027 10,441 142 980,684 501938
2028 11,308 142 980,684 625052
Production Value - sales projection
Price - unit cost
Expenses - start up summary 1st year, then less equipment value in the proceeding years
Equipment Value 441,241
ROI
Net Profit Cost of Inve ROI
1,167,240 1,421,925
1,264,084
1,369,022
1,482,622
1,605,736
Total 6,888,704 1,421,925
