Empanada De Escamosa Sales Forecast

Units Sold Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23
Product/Service A 750 900 1200 1400 1450 1500 1500 1570 1700 1800

Unit Price
Product/Service A ₱ 45.00 ₱ 45.00 ₱ 45.00 ₱ 45.00 ₱ 45.00 ₱ 45.00 ₱ 45.00 ₱ 45.00 ₱ 45.00 ₱ 45.00

Sales Growth Rate

Product/Service A 0% 20% 33% 17% 4% 3% 0% 5% 8% 6%

Revenue (Units Sold * Unit Price)

Product/Service A ₱ 33,750.00 ₱ 40,500.00 ₱ 54,000.00 ₱ 63,000.00 ₱ 65,250.00 ₱ 67,500.00 ₱ 67,500.00 ₱ 70,650.00 ₱ 76,500.00 ₱ 81,000.00
Total Revenue ₱ 33,750.00 ₱ 40,500.00 ₱ 54,000.00 ₱ 63,000.00 ₱ 65,250.00 ₱ 67,500.00 ₱ 67,500.00 ₱ 70,650.00 ₱ 76,500.00 ₱ 81,000.00

Unit COGS
Product/Service A ₱ 4.50 ₱ 4.50 ₱ 4.50 ₱ 4.50 ₱ 4.50 ₱ 4.50 ₱ 4.50 ₱ 4.50 ₱ 4.50 ₱ 4.00

Margin Per Unit (Unit Price - Unit COGS)

Product/Service A ₱ 40.50 ₱ 40.50 ₱ 40.50 ₱ 40.50 ₱ 40.50 ₱ 40.50 ₱ 40.50 ₱ 40.50 ₱ 40.50 ₱ 41.00

Gross Profit (Revenue - COGS or Margin Per Unit * Units Sold)

Product/Service A ₱ 30,375.00 ₱ 36,450.00 ₱ 48,600.00 ₱ 56,700.00 ₱ 58,725.00 ₱ 60,750.00 ₱ 60,750.00 ₱ 63,585.00 ₱ 68,850.00 ₱ 73,800.00
Total Gross Profit ₱ 30,375.00 ₱ 36,450.00 ₱ 48,600.00 ₱ 56,700.00 ₱ 58,725.00 ₱ 60,750.00 ₱ 60,750.00 ₱ 63,585.00 ₱ 68,850.00 ₱ 73,800.00
 Year 1
Nov-23 Dec-23 Total Units Sold
1900 1950 17620

Avg Unit Price

₱ 45.00 ₱ 45.00 ₱ 45.00

Avg Growth Rate

6% 3% 9%

Total Revenue
₱ 85,500.00 ₱ 87,750.00 ₱ 792,900.00
₱ 85,500.00 ₱ 87,750.00 ₱ 792,900.00

Avg COGS
₱ 4.00 ₱ 4.00 ₱ 4.38

Avg Margin
₱ 41.00 ₱ 41.00 ₱ 40.63

Total Gross Profit

₱ 77,900.00 ₱ 79,950.00 ₱ 716,435.00
₱ 77,900.00 ₱ 79,950.00 ₱ 716,435.00
 Year 1: Units Sold Year 1: Revenue
2500 ₱100,000.00
₱90,000.00
2000 ₱80,000.00
₱70,000.00
1500 ₱60,000.00
₱50,000.00
1000 ₱40,000.00
₱30,000.00
500 ₱20,000.00
₱10,000.00
0 ₱-
Jan-23 Mar-23 May-23 Jul-23 Sep-23 Nov-23
Jan-23

Feb-23

Mar-23

Apr-23

May-23

Jun-23

Aug-23

Sep-23

Oct-23

Nov-23

Dec-23
Jul-23
Product/Service A Product/Service A

Year 1: Gross Profit Year 1: Growth Rate

₱90,000.00 35%
₱80,000.00 30%
₱70,000.00 25%
₱60,000.00
₱50,000.00 20%
₱40,000.00 15%
₱30,000.00 10%
₱20,000.00 5%
₱10,000.00
₱- 0%
Jan-23 Apr-23 Jul-23 Oct-23

Feb-23

Sep-23
Jan-23

Mar-23

May-23

Jun-23

Jul-23

Aug-23

Nov-23

Dec-23
Apr-23

Oct-23
Product/Service A Product/Service A

2500
3-Year Units Sold

2000

1500

1000

500

0
Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23

Product/Service A

90000
3-Year Gross Profit
80000
70000
60000
50000
40000
30000
20000
10000
0
Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23

Product/Service A

3-Year Growth Rate

0.35
0.3
 3-Year Growth Rate
0.35
0.3
0.25
0.2
0.15
0.1
0.05
0
Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23

Product/Service A
Sales Forecast Template
By Vertex42.com
https://www.vertex42.com/ExcelTemplates/sales-forecast.html

© 2016 Vertex42 LLC

This spreadsheet, including all worksheets and associated content is a

copyrighted work under the United States and other copyright laws.

Do not submit copies or modifications of this template to any website or

online template gallery.

Please review the following license agreement to learn how you may or
may not use this template. Thank you.

See License Agreement

https://www.vertex42.com/licensing/EULA_privateuse.html

Do not delete this worksheet.