You are now required to deliver your budget presentation to the Executive team of Skyward. Using the FNSACC523_AE_Sk3of3_Appx3_Skyward_Budget_Report_Presentation_template found in you will design and deliver a presentation that must include:

• an identified audience for your presentation
• a high-level overview of the budget summary including:
  • key budget figures (sales, gross profit, net profit)
  • graphs and visuals
  • forecasting, circumstances, assumptions, risks and contingencies.

Skyward Travel/1.A
Cost of Goods Sold Budget
For the year ended 30 June 2024
	2022/23 Full Year Actual	% Increase	2023/24 Full Year Budget	1st Quarter Jul-Sep	2nd Quarter Oct-Dec	3rd Quarter Jan-Mar	4th Quarter Apr-Jun	Check Total
				35%	20%	15%	30%	100%
flights	1,225,897	20%	1,471,076	514,877	294,215	220,661	441,323	1,471,076
in-country tours	1,350,897	8%	1,458,969	510,639	291,794	218,845	437,691	1,458,969
in-country accommodation	402,395	8%	434,587	152,105	86,917	65,188	130,376	434,587
in-country tour insurance.	124,773	25%	155,966	54,588	31,193	23,395	46,790	155,966
Total Cost of Sales	3,103,962		3,520,598	1,232,209	704,120	528,090	1,056,179	3,520,598

Skyward Travel/1.B
Employee Costs Budget
For the year ended 30 June 2024
	2022/23 Full Year Actual	% Increase	2023/24 Full Year Budget	1st Quarter Jul-Sep	2nd Quarter Oct-Dec	3rd Quarter Jan-Mar	4th Quarter Apr-Jun	Check Total
				35%	20%	15%	30%	100%
Permanent Staff - 30 FTE	781,266	6.5%	832,048	208,012	208,012	208,012	208,012	832,048
Casual Staff - Seasonal	1,085,800	7.2%	1,163,978	407,392	232,796	174,597	349,193	1,163,978
Superannuation	196,042	11%	219,563	67,694	48,489	42,087	61,293	219,563
Payroll Tax	93,727	5.02%	111,223	34,292	24,562.68	21,320	31,049	111,223
Total Employee Costs	2,156,835		2,326,811	717,390	513,859	446,015	649,547	2,326,811

Skyward Travel/1.C
Utilities and Rent Budget by State
For the year ended 30 June 2024
	% Increase	NSW	VIC	QLD	TOTAL
Electricity	8.0%	6,076	4,555	2,806	13,437
Water	8.0%	675	538	383	1,596
Internet/Phone	3.5%	2,877	1,592	826	5,295
Database/Computer systems	3.5%	9,923	7,554	3,611	21,088
TOTAL UTILITIES		19,551	14,240	7,626	41,417
Rent % Increase by State		5.5%	4.8%	4.2%
Rent		226,825	157,200	67,730	451,755
Skyward Travel
Actual Utilities and Rent Expenditure by State
For the year ended 30 June 2023
		NSW	VIC	QLD	TOTAL
Electricity		5,626	4,218	2,598	12,442
Water		625	498	355	1,478
Internet/Phone		2,780	1,538	798	5,116
Database/Computer systems		9,587	7,299	3,489	20,375
Rent		215,000	150,000	65,000	430,000
TOTAL		233,618	163,553	72,240	469,411

Skyward Travel/1.D
Quarterly Budgeted Income Statement
Year ___________
	2022/23 Full Year Actual	2023/24 Full Year Budget	1st Quarter	2nd Quarter	3rd Quarter	4th Quarter	Comment/Assumption
			35%	20%	15%	30%
Sales	6,681,900	7,583,957	2,654,385	1,516,791	1,137,593	2,275,187	Increase by 13.5%
Less Cost of Sales	3,103,962	3,520,598	1,232,209	704,120	528,090	1,056,179	as per working in 1A cost of sale
Gross profit	3,577,938	4,063,358	1,422,175	812,672	609,504	1,219,008
Gross Profit %	54%	54%	54%	54%	54%	54%
Less operating expenses:
Employee Expenses	2,156,835	2,326,811	717,390	513,859	446,015	649,547	as per working in 1B employee costs
Advertising	28,700	29,418	7,354	7,354	7,354	7,354	increase by 2.5%
Rent	430,000	451,755	112,939	112,939	112,939	112,939	as per working 1C utilities and rent
Other Operating Expenses	32,950	33,609	8,402	8,402	8,402	8,402	increase 2%
Utilities	39,411	41,417	10,354	10,354	10,354	10,354	as per working 1C utilities and rent
Insurance	100,300	106,820	26,705	26,705	26,705	26,705	6.5% Increase
Depreciation of Office Equipment	25,800	25,800	6,450	6,450	6,450	6,450	Depreciation method is straight line and is the expense is expected to be the same as 2022/23 financial year. It reported monthly
Accounting Fees		20,000	5,000	5,000	5,000	5,000	Annual cost of Azure Accountants and Financial Services budgeting services $20,000, (Paid monthly)
Total operating expenses	2,813,996	3,035,629	894,595	691,064	623,220	826,751
Net profit	763,942	1,027,729	527,581	121,608	-13,716	392,257
Net Profit %	11%	14%	20%	8%	-1%	17%

Appendix 1: Skyward Budget Report Presentation GUIDELINES

Budget Presentation 2022/2023 Skyward

Table 2 Budget Overview 2022/2023 Skyward

Budget Overview

Budget presentation audience

List here who you will present this report to

Summary

Here, provide a summary of the key areas of your budget (tab 1D of your spreadsheet) such as the sales, GP, GP%, total expenses, NP, and NP%. Then include some graphs that give a visual. Some examples might be a pie chart of the sales by qtr, pie chart breaking down expenses, bar chart comparing actual to budget.

Table 2 Forecasting 2022/2023 Skyward

Forecasting

Feasibility

List here the budget objectives from your Commentary file and dicuss how achievable they are

Changes to circumstances

From your commentary file

Assumptions

From your commentary file

Parameters

From your commentary file

Table 3 Risks and Contingency Recommendations 2022/2023 Skyward

Risk and Contingency Recommendations

Risks

From your commentary file

Contingencies

From your commentary file