TSC Financial Plan
TSC Financial Plan
TSC Financial Plan
₱49,722.42
₱49,722.42 ₱21,930.00
₱25,840.00 ₱3,859.28
₱3,859.28 ₱24,650.43
₱24,650.43
₱75,500.00
₱75,500.00 ₱1,000.00
₱1,000.00 ₱350.00
₱350.00 ₱180,922.13
₱180,922.13 ₱780,987.91
₱780,987.91
₱0.00 ₱44,358.25
₱44,358.25 ₱736,629.67
₱736,629.67
₱0.00
₱0.00 ₱0.00
₱0.00 ₱736,629.67
₱736,629.67 #REF!
₱102,391.52 ₱102,391.52
₱634,238.14 ₱634,238.14
2023 INCOME STAT
January February March April
Net Sales ₱103,383.61 ₱105,047.68 ₱110,882.16 ₱117,518.96
CoGS ₱7,032.00 ₱7,175.00 ₱7,585.00 ₱7,858.22
Gross Profit ₱96,351.61 ₱97,872.68 ₱103,297.16 ₱109,660.74
Operating Expenses
Advertisement and other Promotions ₱4,213.53 ₱4,220.19 ₱4,243.53 ₱4,270.08
Supplies Expense ₱1,920.00 ₱1,920.00 ₱2,700.00 ₱1,980.00
Utilities Expense ₱351.69 ₱366.69 ₱376.69 ₱379.69
Rent Expense ₱2,185.00 ₱2,185.00 ₱2,294.25 ₱16,674.38
Administrative
Salaries and Wages Expense ₱5,500.00 ₱5,500.00 ₱5,500.00 ₱5,500.00
Hiring and processing Expense ₱1,000.00 ₱0.00 ₱0.00 ₱0.00
Rent Expense ₱0.00 ₱0.00 ₱0.00 ₱15,000.00
Business Permits ₱350.00 ₱0.00 ₱0.00 ₱0.00
Total Operating Expenses ₱15,520.22 ₱14,191.88 ₱15,114.47 ₱43,804.14
Operation Profit ₱80,831.39 ₱83,680.80 ₱88,182.69 ₱65,856.60
Other Income ₱0.00 ₱0.00 ₱0.00 ₱0.00
Other Expenses ₱10,311.42 ₱4,511.42 ₱4,511.42 ₱23,511.42
Earnings Before Interest and Taxes ₱70,519.97 ₱79,169.38 ₱83,671.27 ₱42,345.18
Interest Earned ₱0.00 ₱0.00 ₱0.00 ₱0.00
Interest Expenses ₱0.00 ₱0.00 ₱0.00 ₱0.00
Total Interest Earned and Expensed ₱0.00 ₱0.00 ₱0.00 ₱0.00
Earnings Before Taxes ₱70,519.97 ₱79,169.38 ₱83,671.27 ₱42,345.18
Business Tax (13.9%) ₱0.00 ₱0.00 ₱32,437.13 ₱0.00
Net Income After Taxes and Interest ₱70,519.97 ₱79,169.38 ₱51,234.15 ₱42,345.18
2023 INCOME STATEMENT
May June July August September October November
₱119,328.30 ₱117,670.84 ₱118,336.47 ₱119,002.09 ₱125,261.50 ₱127,827.60 ₱148,242.17
₱8,082.06 ₱7,978.32 ₱8,048.88 ₱8,098.27 ₱8,526.42 ₱8,783.52 ₱10,351.35
₱111,246.24 ₱109,692.52 ₱110,287.59 ₱110,903.82 ₱116,735.08 ₱119,044.09 ₱137,890.82
₱4,406.68 ₱51,456.68
₱4,060.00 ₱27,790.00
₱531.69 ₱5,038.28
₱16,786.95 ₱156,331.78
₱10,500.00 ₱81,000.00
₱0.00 ₱1,000.00
₱15,000.00 ₱135,000.00
₱0.00 ₱350.00
₱51,285.32 ₱457,966.74
₱89,840.31 ₱906,141.24
₱0.00 ₱0.00
₱4,511.42 ₱101,156.13
₱85,328.89 ₱804,985.11
₱0.00 ₱0.00
₱0.00 ₱0.00
₱0.00 ₱0.00
₱85,328.89 ₱804,985.11
₱30,333.75 ₱111,892.93
₱54,995.15 ₱693,092.18
2024 INCOME STAT
January February March April
Net Sales ₱146,596.59 ₱149,237.97 ₱156,171.59 ₱159,803.49
CoGS ₱10,215.00 ₱10,423.00 ₱10,987.00 ₱11,281.00
Gross Profit ₱136,381.59 ₱138,814.97 ₱145,184.59 ₱148,522.49
Operating Expenses
Advertisement and other Promotions ₱4,386.39 ₱4,396.95 ₱4,424.69 ₱4,439.21
Supplies Expense ₱2,070.00 ₱2,070.00 ₱2,850.00 ₱2,130.00
Utilities Expense ₱527.69 ₱528.69 ₱561.69 ₱586.69
Rent Expense ₱16,710.00 ₱16,710.00 ₱16,710.00 ₱16,710.00
Administrative
Salaries and Wages Expense ₱5,500.00 ₱5,500.00 ₱5,500.00 ₱5,500.00
Hiring and processing Expense ₱1,000.00 ₱0.00 ₱0.00 ₱0.00
Rent Expense ₱15,000.00 ₱15,000.00 ₱15,000.00 ₱15,000.00
Business Permits ₱350.00 ₱0.00 ₱0.00 ₱0.00
Total Operating Expenses ₱45,544.08 ₱44,205.64 ₱45,046.38 ₱44,365.90
Operation Profit ₱90,837.51 ₱94,609.33 ₱100,138.22 ₱104,156.59
Other Income ₱0.00 ₱0.00 ₱0.00 ₱0.00
Other Expenses ₱10,311.42 ₱4,511.42 ₱4,511.42 ₱23,511.42
Earnings Before Interest and Taxes ₱80,526.09 ₱90,097.91 ₱95,626.80 ₱80,645.17
Interest Earned ₱0.00 ₱0.00 ₱0.00 ₱0.00
Interest Expenses ₱0.00 ₱0.00 ₱0.00 ₱0.00
Total Interest Earned and Expensed ₱0.00 ₱0.00 ₱0.00 ₱0.00
Earnings Before Taxes ₱80,526.09 ₱90,097.91 ₱95,626.80 ₱80,645.17
Business Tax (13.9%) ₱0.00 ₱0.00 ₱37,008.86 ₱0.00
Net Income After Taxes and Interest ₱80,526.09 ₱90,097.91 ₱58,617.94 ₱80,645.17
2024 INCOME STATEMENT
May June July August September October November
₱164,425.91 ₱162,444.87 ₱163,435.39 ₱164,425.91 ₱172,019.87 ₱176,312.12 ₱204,376.78
₱11,660.00 ₱11,502.00 ₱11,597.00 ₱11,673.00 ₱12,289.00 ₱12,659.00 ₱14,919.00
₱152,765.91 ₱150,942.87 ₱151,838.39 ₱152,752.91 ₱159,730.87 ₱163,653.12 ₱189,457.78
₱4,630.71 ₱53,707.72
₱4,210.00 ₱29,590.00
₱768.69 ₱7,438.28
₱16,710.00 ₱200,520.00
₱10,500.00 ₱81,000.00
₱0.00 ₱1,000.00
₱15,000.00 ₱180,000.00
₱0.00 ₱350.00
₱51,819.40 ₱553,606.00
₱140,663.10 ₱1,328,921.98
₱0.00 ₱0.00
₱4,511.42 ₱113,889.19
₱136,151.68 ₱1,215,032.80
₱0.00 ₱0.00
₱0.00 ₱0.00
₱0.00 ₱0.00
₱136,151.68 ₱1,215,032.80
₱48,815.33 ₱168,889.56
₱87,336.34 ₱1,046,143.24
INCOME STATEME
2022 Jan 2022 Feb 2022 Mar 2022 Apr
Net Sales ₱73,273.10 ₱73,298.30 ₱79,201.78 ₱80,433.98
CoGS ₱4,791.00 ₱4,818.00 ₱5,246.00 ₱5,332.59
Gross Profit ₱68,482.10 ₱68,480.30 ₱73,955.78 ₱75,101.40
Opex - Variable ₱3,210.77 ₱2,507.69 ₱2,349.31 ₱2,416.99
Opex - Fix ₱6,991.69 ₱11,141.69 ₱11,921.69 ₱11,201.69
Operation Profit ₱58,279.64 ₱54,830.91 ₱59,684.78 ₱61,482.72
Other Income ₱0.00 ₱0.00 ₱0.00 ₱0.00
Other Expenses ₱5,800.00 ₱0.00 ₱0.00 ₱19,000.00
Earnings Before Interest and Taxes ₱52,479.64 ₱54,830.91 ₱59,684.78 ₱42,482.72
Interest ₱0.00 ₱0.00 ₱0.00 ₱0.00
Earnings Before Taxes ₱52,479.64 ₱54,830.91 ₱59,684.78 ₱42,482.72
For year 2022, it is anticipated that The Southside Cartel will garner a total Net Sales of 1,030,605. A significant increase in
Taxes
projected that it will gain from the latter part of the ₱0.00 ₱0.00
first quarter to the year up ₱23,212.35 ₱0.00
until the end of the year. It is also observed tha
Net Income After Taxes and Interest ₱52,479.64 ₱54,830.91 ₱36,472.43 ₱42,482.72
building program. It is expected that by the year 2022, The SouthSide Cartel would hire at least a three-part team consisting
Laguna.
INCOME STATEMENT 2022 SUMMARY
2022 May 2022 Jun 2022 Jul 2022 Aug 2022 Sep 2022 Oct 2022 Nov 2022 Dec
₱82,543.13 ₱85,184.51 ₱83,203.47 ₱83,533.64 ₱88,156.06 ₱90,467.27 ₱104,334.51 ₱106,975.89
₱5,463.00 ₱5,649.00 ₱5,529.00 ₱5,551.00 ₱5,886.00 ₱6,045.00 ₱7,125.00 ₱7,260.00
₱77,080.13 ₱79,535.51 ₱77,674.47 ₱77,982.64 ₱82,270.06 ₱84,422.27 ₱97,209.51 ₱99,715.89
₱2,464.67 ₱2,585.74 ₱2,510.31 ₱2,516.63 ₱2,651.12 ₱2,715.87 ₱2,834.84 ₱3,007.90
₱11,141.69 ₱16,921.69 ₱11,141.69 ₱11,201.69 ₱11,921.69 ₱11,141.69 ₱16,141.69 ₱18,281.69
₱63,473.76 ₱60,028.08 ₱64,022.47 ₱64,264.32 ₱67,697.24 ₱70,564.71 ₱78,232.98 ₱78,426.30
₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00
₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱19,558.25 ₱0.00
₱63,473.76 ₱60,028.08 ₱64,022.47 ₱64,264.32 ₱67,697.24 ₱70,564.71 ₱58,674.74 ₱78,426.30
₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00
₱63,473.76 ₱60,028.08 ₱64,022.47 ₱64,264.32 ₱67,697.24 ₱70,564.71 ₱58,674.74 ₱78,426.30
605. A significant increase in the month of March is due to the projection of an increase in sales. Advertising efforts also play a role in the increase, hav
₱0.00that there
e year. It is also observed ₱23,071.85
is an increase in₱0.00
other expenses₱0.00
present in₱27,241.78 ₱0.00 of The SouthSide
the month of April because ₱0.00 Cartel's
₱28,865.54
projected team
₱63,473.76 ₱36,956.22 ₱64,022.47 ₱64,264.32 ₱40,455.46 ₱70,564.71 ₱58,674.74 ₱49,560.76
t a three-part team consisting of one photograper, one model, and one staff member. Taxes paid during the year is based of the local cost of tax in
4
TOTAL
₱1,030,605.63
₱68,695.59
₱961,910.04
₱31,771.85
₱149,150.28
₱780,987.91
₱0.00
₱44,358.25
₱736,629.67
₱0.00
₱736,629.67
le in the increase, having
₱102,391.52
rtel's projected team
₱634,238.14
ocal cost of tax in
INCOME STATEME
2023 Jan 2023 Feb 2023 Mar 2023 Apr
Net Sales ₱103,383.61 ₱105,047.68 ₱110,882.16 ₱117,518.96
CoGS ₱7,032.00 ₱7,175.00 ₱7,585.00 ₱7,858.22
Gross Profit ₱96,351.61 ₱97,872.68 ₱103,297.16 ₱109,660.74
Opex - Variable ₱2,878.53 ₱2,900.19 ₱3,042.78 ₱778.08
Opex - Fix ₱12,641.69 ₱11,291.69 ₱12,071.69 ₱43,026.07
Operation Profit ₱80,831.39 ₱83,680.80 ₱88,182.69 ₱65,856.60
Other Income ₱0.00 ₱0.00 ₱0.00 ₱0.00
Other Expenses ₱10,311.42 ₱4,511.42 ₱4,511.42 ₱23,511.42
Earnings Before Interest and Taxes ₱70,519.97 ₱79,169.38 ₱83,671.27 ₱42,345.18
Interest
Earnings Before Taxes ₱70,519.97 ₱79,169.38 ₱83,671.27 ₱42,345.18
Taxes ₱0.00 ₱0.00 ₱32,437.13 ₱0.00
Net Income After Taxes and Interest ₱70,519.97 ₱79,169.38 ₱51,234.15 ₱42,345.18
Income Summary for Year 2023 The expected Net Sales of The Southside Cartel in the year 2023 will be Php 1,464,170.75. The South
expense will amount to Php 441,267.81 with the opening of the physical facility, thus procuring an Operating profit of Php 906,141.24. T
Php 693,092.18.
INCOME STATEMENT 2023 SUMMARY
2023 May 2023 Jun 2023 Jul 2023 Aug 2023 Sep 2023 Oct 2023 Nov 2023 Dec
₱119,328.30 ₱117,670.84 ₱118,336.47 ₱119,002.09 ₱125,261.50 ₱127,827.60 ₱148,242.17 ₱151,669.36
₱8,082.06 ₱7,978.32 ₱8,048.88 ₱8,098.27 ₱8,526.42 ₱8,783.52 ₱10,351.35 ₱10,543.73
₱111,246.24 ₱109,692.52 ₱110,287.59 ₱110,903.82 ₱116,735.08 ₱119,044.09 ₱137,890.82 ₱141,125.63
₱797.31 ₱810.68 ₱810.35 ₱815.01 ₱861.05 ₱891.31 ₱1,046.97 ₱1,066.68
₱42,877.72 ₱48,639.19 ₱43,009.19 ₱42,919.19 ₱43,717.57 ₱42,887.69 ₱47,967.49 ₱50,218.64
₱67,571.21 ₱60,242.64 ₱66,468.05 ₱67,169.62 ₱72,156.47 ₱75,265.09 ₱88,876.36 ₱89,840.31
₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00
₱4,511.42 ₱4,511.42 ₱4,511.42 ₱4,511.42 ₱4,511.42 ₱4,511.42 ₱26,730.51 ₱4,511.42
₱63,059.79 ₱55,731.22 ₱61,956.63 ₱62,658.20 ₱67,645.05 ₱70,753.67 ₱62,145.85 ₱85,328.89
The Southside Cartel is forecast to earn a total net profit of Php 2,026,928.98 in 2024. The rise in revenue due to the consistent in
According to these, the Gross Profit for the year 2024 is forecast to rise to Php 1,882,527.98. By managing their branch in Metro M
year 2024, the forecasted total Net income of The Southside Cartel is Php 1,046,143.24.
INCOME STATEMENT 2024 SUMMARY
2024 May 2024 Jun 2024 Jul 2024 Aug 2024 Sep 2024 Oct 2024 Nov 2024 Dec
₱164,425.91 ₱162,444.87 ₱163,435.39 ₱164,425.91 ₱172,019.87 ₱176,312.12 ₱204,376.78 ₱207,678.50
₱11,660.00 ₱11,502.00 ₱11,597.00 ₱11,673.00 ₱12,289.00 ₱12,659.00 ₱14,919.00 ₱15,196.00
₱152,765.91 ₱150,942.87 ₱151,838.39 ₱152,752.91 ₱159,730.87 ₱163,653.12 ₱189,457.78 ₱192,482.50
₱1,189.70 ₱1,173.78 ₱1,182.74 ₱1,188.70 ₱1,263.08 ₱1,297.25 ₱1,497.51 ₱1,527.71
₱43,151.69 ₱48,931.69 ₱43,301.69 ₱43,211.69 ₱43,931.69 ₱43,151.69 ₱48,151.69 ₱50,291.69
₱108,424.51 ₱100,837.40 ₱107,353.96 ₱108,352.51 ₱114,536.10 ₱119,204.18 ₱139,808.58 ₱140,663.10
₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00
₱4,511.42 ₱4,511.42 ₱4,511.42 ₱4,511.42 ₱4,511.42 ₱4,511.42 ₱39,463.57 ₱4,511.42
₱103,913.09 ₱96,325.98 ₱102,842.54 ₱103,841.09 ₱110,024.68 ₱114,692.76 ₱100,345.02 ₱136,151.68
₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00
₱103,913.09 ₱96,325.98 ₱102,842.54 ₱103,841.09 ₱110,024.68 ₱114,692.76 ₱100,345.02 ₱136,151.68
₱0.00 ₱39,042.91 ₱0.00 ₱0.00 ₱44,022.46 ₱0.00 ₱0.00 ₱48,815.33
₱103,913.09 ₱57,283.07 ₱102,842.54 ₱103,841.09 ₱66,002.23 ₱114,692.76 ₱100,345.02 ₱87,336.34
n revenue due to the consistent increase in positive customer reviews would result in an increase in the Cost of Goods Solds of Php 144,401.00.
managing their branch in Metro Manila, Operation profit wil result to 1,328,921.98. Taxes remain at 13.9% of net earnings and are paid quarterly. For
4
TOTAL
₱2,026,928.98
₱144,401.00
₱1,882,527.98
₱14,685.72
₱538,920.28
₱1,328,921.98
₱0.00
₱113,889.19
₱1,215,032.80
₱0.00
₱1,215,032.80
₱168,889.56
₱1,046,143.24
Php 144,401.00.
re paid quarterly. For the
Sales for Jan-Mar 2021
Sales per Week/Drop (in Units)
Month Place TOTAL
1st 2nd 3rd 4th 5th
January Instagram Shop 15 34 36 31 26 142
Physical Store 10 2 4 2 4 22
February Instagram Shop 21 18 25 13 22 99
Physical Store 8 6 0 15 8 37
March Instagram Shop 25 31 54 24 15 149
Physical Store 10 0 0 6 12 28
To compute for Southside's forecasted sales for the next three years, the business
consultants used the weighted moving average approach and a combination of
intellectual guesses on what months sales will increase and decrease considering internal
factors, external factors, and proposed marketing strategies discussed in previous
chapters.
Giveaways(Promotional Expense) for 2021
Pieces (Vouchers/Cash Giveaways/Discounts)
Month
1st 2nd 3rd 4th
Jan 1 4+(Php 200) (Php50) 5+(Php 350)
Feb - (Php50) - -
March - - 1-
April (Start of collab w - - 3
(per week yung nakalagay here)
1
Discounts)
5th
(Php 400)
-
-
For Year 1-3
The tables below show the projected Income Statements of The Southside Cartel for the next three
units of both the Instagram store, partner physical store, and emerging owned physical store. The co
more stable than the simple moving average approach. The selling price used is Php 475 pesos wh
internal and external market factors were also considered in the computation of sales forecasts. The
can also be seen on the previous chapters and the KPI/KRA table. The external factors include peak
explanation on the method of forecasting sales and COGS will be presented later in the Projected S
The business does not include sales discount because of Southside's payment-first-policy. Trade dis
in the operating expenses (OPEX) and not on sales discount since they are not implementing credit
expenses for the past 3 months. Expenses for utilities such as water, WiFi, and electricity were estim
rent expenses were also added: (1) is the rent for the racks of Chamberlair (a partner physical store
emerging physical store in 2023. Additional expenses for their physical store opening in 2023 were a
how much a student and amateur staff price their services since the consultants were not looking fo
estimates provided by the owners, along with additional expenses related to plans and strategies me
2022-2024. The consultants included the expenses incurred for the socio-economic plan on the othe
of 4 projects and expenses for each are declared on Chapter 7. No other income were declared sinc
Income Summary for Year 2023 The expected Net Sales of The Southside Cartel in the year 2023
approval rating on its Instagram interface and its other promotional methods. Fixed operating expen
procuring an Operating profit of Php 906,141.24. Tax obligations are still paid quarterly, which is 13.
is Php 693,092.18.
Income Summarythe
for projection
the Year 2022:
of an increase in sales. Advertising efforts also play a role in the
quarter to the year up until the end of the year. It is also observed that there is
SouthSide Cartel's projected team building program. It is expected that by the
Income Summary for the Year 2024:
The Southside Cartel is forecast to earn a total net profit of Php 2,026,928.98 in 202
would result in an increase in the Cost of Goods Solds of Php 144,401.00. According
By managing their branch in Metro Manila, Operation profit wil result to 1,328,921.98
the forecasted total Net income of The Southside Cartel is Php 1,046,143.24.
Southside Cartel for the next three (3) years. The net sales computed stems out from the computation of gross sale in
rging owned physical store. The consultants used the weighted moving average approach to forecast sales as this this
g price used is Php 475 pesos which is extracted from the average price of the products listed in Chapter 1. Multiple
omputation of sales forecasts. The internal factors were adjusted based on the timeline of departmental plans which
e. The external factors include peak seasons and the establishment of their own physical store. A more in-depth
presented later in the Projected Sales Budget.
de's payment-first-policy. Trade discounts given to consumers are interpreted as promotional expense and is declared
e they are not implementing credit sales. The business owners provided the consultants with estimates of their general
ter, WiFi, and electricity were estimated based on its fraction in a normal household utility expense. Two categories of
amberlair (a partner physical store) which is 10% of the South Side Cartel's sales in that store and (2) rent for
ysical store opening in 2023 were also accounted for. Additionally, rates for hiring the workers are estimated based on
he consultants were not looking for professionals to reflect the business brand - for the broque and boujee. The
s related to plans and strategies mentioned in previous chapters, were used in forecasting the expenses for years
he socio-economic plan on the other expenses account since it is not part of their normal operations. They were a total
No other income were declared since all of it will be offset upon donations.
Southside Cartel in the year 2023 will be Php 1,464,170.75. The Southside Cartel shall continously improve its
al methods. Fixed operating expense will amount to Php 441,267.81 with the opening of the physical facility, thus
are still paid quarterly, which is 13.9% of the total earnings as stated by the owner. Overall, the Net Profit for year 2023
sing efforts also play a role in the increase, having projected that it will gain from the latter part of the first
. It is also observed that there is an increase in other expenses present in the month of April because of The
ogram. It is expected that by the year 2022, The SouthSide Cartel would hire at least a three-part team
t profit of Php 2,026,928.98 in 2024. The rise in revenue due to the consistent increase in positive customer reviews
olds of Php 144,401.00. According to these, the Gross Profit for the year 2024 is forecast to rise to Php 1,882,527.98.
ion profit wil result to 1,328,921.98. Taxes remain at 13.9% of net earnings and are paid quarterly. For the year 2024,
Cartel is Php 1,046,143.24.
mputation of gross sale in
forecast sales as this this
ed in Chapter 1. Multiple
epartmental plans which
e. A more in-depth
Explanation
i. Vertical Analysis The Gross Sales is expected to increase gradually in the years 2022-2024. However, a decrease of Gross Profit was also fo
amount of Cost from Service rendered. The percentage of Net Sales in juxtaposition with Gross Sales were maintained at 69.51%, as well as the S
30.49%. Operating Expenses in proportion to the sales are expected to fluctuate from 2022-2024 due to the planned opening of the physical store
the remaining accounts of profits, earnings and taxes. Overall, the forecast have seen a Net Profit range of 33% to 43% in proportion to the Gross
manage to procure more sales over the years; however, percentage of Net Profit shall decrease in 2023 with the significant increase of expenses,
least percentage of expenses recorded.
i. Horizontal Analysis The business anticipates an increase of Gross Sales within the years with the enhanced marketing strategies. Sales Disco
equivalently, as well as Net Sales at 38.44% in 2022-2023 and 42.07% in 2023-2024. Gross Profit has also increased by 38% in 2022-2023 and 4
Expenses and Other Expenses were seen with a double surge from 2023-2024 at 153.13% and 128.04% respectively; thus, Operating Profit only i
years which is a low increase compared to the 46.66% increase in 2022-2023. Overall, Net Profit is seen with a half increase in 2022-2023, but on
2024.
HORIZONTAL
2022-2023 2023-2024
PESO △% PESO △%
₱809,607.58 38.44% ₱623,744.97 42.07%
₱246,849.35 38.44% ₱190,179.84 42.07%
₱562,758.23 38.44% ₱433,565.13 42.07%
₱44,338.23 44.31% ₱31,367.19 45.66%
518,420.00 38.00% 402,197.94 41.81%
₱95,639.26 20.88% ₱277,044.61 153.13%
422,780.74 46.66% 125,153.33 16.03%
NOTES:
2022 SALE
January February March
Less/Add: Add 0.5% Add 5%, 1%, & 2%
Internal Factors
Marketing Note 8, 9, 10
Human Resource
Operations Note 38 & 39
Socioeconomic Summer
External factors Season
Gross Sales (in Units) IG shop 185 185 201
Gross Sales (In Units) Physical Store 37 37 39
Total Gross Sale (pesos) ₱105,413.76 ₱105,450.00 ₱113,943.00
Selling Price ₱475.00 ₱475.00 ₱475.00
Sales Discount ₱0.00 ₱0.00 ₱0.00
Sales Return ₱32,140.65 ₱32,151.71 ₱34,741.22
NET SALES (pesos) ₱73,273.10 ₱73,298.30 ₱79,201.78
NOTES:
2023 SALE
January February March
Less/Add: Add 0.8% Add 0.8% Add 5% , 0.8%, 0.3%
Internal Factors
Marketing note 11 note 11 note 11
Human Resource
Operations note 44
Socioeconomic Summer
External factors Season
Gross Sales (in Units) IG shop 267 272 288
Gross Sales (In Units) Physical Store 46 46 48
Total Gross Sale (pesos) ₱148,732.00 ₱151,126.00 ₱159,519.73
Selling Price ₱475.00 ₱475.00 ₱475.00
Sales Discount ₱0.00 ₱0.00 ₱0.00
Sales Return ₱45,348.39 ₱46,078.32 ₱48,637.56
NET SALES (pesos) ₱103,383.61 ₱105,047.68 ₱110,882.16
NOTES:
2024 SALE
January February March
Less/Add: Add 0.8% Add 0.8% Add 5%. , 0.8%
Internal Factors
Marketing note 11 note 11 note 11
Human Resource
Operations
Socioeconomic Summer
External factors Season
Gross Sales (in Units) IG shop 384 392 413
Gross Sales (In Units) Physical Store 60 60 60
Total Gross Sale (pesos) ₱210,900.00 ₱214,700.00 ₱224,675.00
Selling Price ₱475.00 ₱475.00 ₱475.00
Sales Discount ₱0.00 ₱0.00 ₱0.00
Sales Return ₱64,303.41 ₱65,462.03 ₱68,503.41
NET SALES (pesos) ₱146,596.59 ₱149,237.97 ₱156,171.59
The net sales computed stems out form the computation of gross sale in units of both the Instagram store, partner phys
owned physical store. The consultants used the weighted moving average approach to forecast sales as this this mo
average approach. The selling price used is Php 475 pesos which is extracted from the average price of the products l
internal and external market factors were also considered in the computation of sales forecasts. The internal factors
timeline of departmental plans which can also be seen on the previous chapters and the KPI/KRA table. The external fa
and the establishment of their own physical store. The business does not include sales discount because of Southside'
Discounts given to consumers are interpreted as promotional expense and is declared in the OPEX.
2021 SALES FORECAST
April May June July August September
Add 5% & 10% & 1.8%
Add 5%& 1% Add 10% Add 0.5% Add 5%
Note 36
Note 11
Note 41
Summer Summer Bermonths
Season Season Season
204 209 216 211 212 224
40 41 42 41 41 43
₱115,715.70 ₱118,750.00 ₱122,550.00 ₱119,700.00 ₱120,175.00 ₱126,825.00
₱475.00 ₱475.00 ₱475.00 ₱475.00 ₱475.00 ₱475.00
₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00 ₱0.00
₱35,281.72 ₱36,206.88 ₱37,365.50 ₱36,496.53 ₱36,641.36 ₱38,668.94
₱80,433.98 ₱82,543.13 ₱85,184.51 ₱83,203.47 ₱83,533.64 ₱88,156.06
Note 7
Bermonths Bermonths
Season Season Christmas NOTES:
170 175 195 1882 2285
36 37 39 403
₱97,850.00 ₱100,700.00 ₱111,150.00 ₱1,085,275.25
₱475.00 ₱475.00 ₱475.00
₱0.00 ₱0.00 ₱0.00 ₱0.00
₱29,736.62 ₱30,602.73 ₱33,778.49 ₱329,815.15
₱68,113.39 ₱70,097.27 ₱77,371.52 ₱755,460.10
Bermonths Note 53
Bermonths
Season Season Christmas
230 271 276 2624 3121 36.62%
44 45 48 498
₱130,150.00 ₱150,100.00 ₱153,900.00 ₱1,482,672.46
₱475.00 ₱475.00 ₱475.00
₱0.00 ₱0.00 ₱0.00 ₱0.00
₱39,682.74 ₱45,765.49 ₱46,924.11 ₱452,066.83
₱90,467.27 ₱104,334.51 ₱106,975.89 ₱1,030,605.63
Bermonths Note 53
Bermonths
Season Season Christmas
474 559 569 5419 6139 38.44%
60 60 60 720
₱253,650.00 ₱294,025.00 ₱298,775.00 ₱2,916,025.00
₱475.00 ₱475.00 ₱475.00
₱0.00 ₱0.00 ₱0.00 ₱0.00
₱77,337.89 ₱89,648.22 ₱91,096.50 ₱889,096.02
₱176,312.12 ₱204,376.78 ₱207,678.50 ₱2,026,928.98
2021 COST OF GOODS SOLD
January February March
Gross Sales (in Units) IG shop 142 99 149
Gross Sales (In Units) Physical Store 22 37 28
Selling Price ₱475.00 ₱475.00 ₱475.00
Total Gross Sale (pesos) ₱77,900.00 ₱64,600.00 ₱84,075.00
COGS ₱2,750.00 ₱500.00 ₱5,000.00
When asked what their cost of goods sold were for the past 3 months, the business owners gave the business consultants an
business consultants assigned the lowest amount (Php500) to the month with the lowest sales, the average amount (Php2,750
sales. The forecasted COGS was computed using the weighted moving average approach based on the historical COGS and
owners gave the business consultants an estimate of Php500-Php5,000 per month. In order to distribute the COGS for the historical sales,
west sales, the average amount (Php2,750) to the month with moderate sales, and the highest amount (Php5,000) to the month with the hig
roach based on the historical COGS and increases/decreases in sales due to internal and external factors.
2022
Jan Feb Mar Apr May June July Aug
Expected Sales in Units 222 222 240 244 250 258 252 253
Add: Desired Ending Inventory 53 53 53 53 53 53 53 53
Total needed Inventory 275 275 293 297 303 311 305 306
2023
Jan Feb Mar Apr May June July Aug
Expected Sales in Units 313 318 336 356 361 356 358 360
Add: Desired Ending Inventory 43 43 43 43 43 43 43 43
Total needed Inventory 356 361 379 399 404 399 401 403
2024
Jan Feb Mar Apr May June July Aug
Expected Sales in Units 444 452 473 484 498 492 495 498
Add: Desired Ending Inventory 33 33 33 33 33 33 33 33
Total needed Inventory 477 485 506 517 531 525 528 531
consultants first estimated the monthly inventories needed for 2021. The owners goal for the ending inventory is
to clear it per drop (sold out) but as a starting business this is hard to achieve hence, we decreased it bit by bit,
specifically 10 units per January. Th owners said they could tolerate up to 30k pesos of ending inventory which is
63 units (475 pesos of selling price)This decreased is also influenced by the marketing strategies proposed. Per
the owners estimated ending inventory, they usually have aroun 40-35% left in a 200-250 monthly pieces. With
this, we assumed 37% of 225 units (average of the range) for beginning inventory of January 2021 and worked
our ways towards the next months.
ly)
63 63 63 63
202 206 212 234 2266
58 58 58 58 701
262 269 311 319 3056
43 43 43 43 526
379 387 449 459 4425
33 33 33 33 406
521 534 619 629 6129
or the ending inventory is
we decreased it bit by bit,
of ending inventory which is
strategies proposed. Per
250 monthly pieces. With
anuary 2021 and worked
FINANCIAL RATIOS
Return on Investment 2022 2023 2024
906.05% 770.10% 697.43%
Net Profit ₱634,238.14 ₱693,092.18 ₱1,046,143.24
Initial Investment ₱70,000.00 ₱90,000.00 ₱150,000.00
Payback Period 2022 2023 2024
0.50 0.56 0.48
Total Investment ₱320,000.00 ₱390,000.00 ₱500,000.00
Annual Net Income ₱634,238.14 ₱693,092.18 ₱1,046,143.24
Breakeven Units 2022 2023 2024
321 936 1,140
Fixed Costs ₱149,150.28 ₱441,267.81 ₱538,920.28
Selling Price ₱475.00 ₱475.00 ₱475.00
Variable Costs (per unit) ₱10.18 ₱3.77 ₱2.39
The ROI values of 906.05%, 770.10%, and 697.43% are decreasing as the years pro
has still a good probability of gaining back their investments per their company's perf
owners are putting in more investments, but are not used actively in the reflected yea
Explanation for payback
The payback period indicates how long the business can recover the investments ma
per year were based from the expected plans and strategies for that specific year. Th
of Php 634,238.14 at the end of the year will have a 0.50 years (6 months) payback
return of Php 693,092.18 at the end of the year and will have a 0.56 years (6.72 mon
2024 that has a return of Php 1,046,143.24 will have a 0.48 years (5.76 months) pay
2022, 0.56 years for 2023, and 0.48 years for 2024 to reach their breakeven point pe
Explanation for businesses.
Breakeven Given that it will take Southside less than a year to recover their investm
The Breakeven Units is the number of units of goods or services that a company nee
financial losses but also make no profit. The fixed costs and variable costs per unit w
planned expansion of the business in the years 2023-2024, the amount of fixed cost
expected, the breakeven units for years 2023 and 2024 also increase because of thi
brings to the business is definitely worth the increase in breakeven units.
ss can recover the investments made for a specific year. The values provided for the total investment
strategies for that specific year. The Php 320,000.00 total investment made in 2022 that has a return
a 0.50 years (6 months) payback period. For the year 2023, the Php 390,000.00 investment has a
nd will have a 0.56 years (6.72 months) payback period. Lastly, the Php 500,000.00 investment made in
ve a 0.48 years (5.76 months) payback period. It will take The Southside Cartel about 0.50 years for
4 to reach their breakeven point per year. A shorter payback period is generally preferred for all
han a year to recover their investments per year, the business won't have high financial risks.
ods or services that a company needs to sell in order to break even, or in other words, to suffer no
costs and variable costs per unit were derived from the income statement summaries. Due to the
023-2024, the amount of fixed costs relatively increase based on the expansion expenses per year. As
2024 also increase because of this. This isn't necessarily bad, since the value that the expansion
ase in breakeven units.