Manage Finances for SIT60316 - Advanced Diploma of Hospitality Management at Australian Ideal College

Australian Ideal College
Registered as Australian Ideal College Pty Ltd
RTO No.: 91679 | CRICOS Provider Code: 03053G
Sydney Campus: Level 7 & 8, 75 King Street, Sydney NSW 2000 Australia
Adelaide Campus: Level 3, 21-23 Rundle Mall, Adelaide SA 5000 Australia
Hobart Campus: GRD Floor, 116 Murray Street, Hobart TAS 7000 Australia
T: [phone] (Sydney) | [phone] (Adelaide) | [phone] (Hobart)
E: [e-mail] | W: www.aic.edu.auEducating for Excellence
Assessment Submission Sheet
Course SIT60316 - Advanced Diploma of Hospitality Management
Unit BSBFIM601 Manage Finances
Assessor Name
Student Name
Student ID
Due Date
Please read and sign this assessment coversheet and submit it together with your assessment to
your Assessor by the due date.
Student Declaration
I declare that the work submitted is my own, and has not been copied or plagiarised from any person
or source.
I have read the Plagiarism Policy and Assessment Appeal and Reassessment Policy in the Student
Handbook and I understand all the rules and guidelines for undertaking assessments.
I understand that by typing my full name in the student field this is equivalent to a hand-written
signature.
I give permission for my assessment material to be used for continuous improvement purposes.
Student
Signature
Date
Submitted
Assessor Use Only
Assessment Items Result
Task 1 Case Study S NS
Task 2 Report S NS
Task 3 Report S NS
Final Result for this unit C NYC
Student Declaration: I declare that I have been
assessed in this unit, and I have been advised of
my result. I am also aware of my appeal rights.
Assessor Declaration: I declare that I have
conducted a fair, valid, reliable and flexible
assessment with this student, and I have
provided appropriate feedback.
Signature Signatur
e
Date
Assessor’s Final Comments
AIC-UP-BSBFIM601-V4.0 Page 1 of 26

Australian Ideal College
Registered as Australian Ideal College Pty Ltd
RTO No.: 91679 | CRICOS Provider Code: 03053G
Sydney Campus: Level 7 & 8, 75 King Street, Sydney NSW 2000 Australia
Adelaide Campus: Level 3, 21-23 Rundle Mall, Adelaide SA 5000 Australia
Hobart Campus: GRD Floor, 116 Murray Street, Hobart TAS 7000 Australia
T: [phone] (Sydney) | [phone] (Adelaide) | [phone] (Hobart)
E: [e-mail] | W: www.aic.edu.auEducating for Excellence
Task 1
Assessment Instructions
This is an individual assessment. This assessment requires you to determine the requirements to
undertake budgeting, financial forecasting and reporting requirements for an organisation. You will also
need to review the case study provided and prepare a budget (in electronic spreadsheet format) and
budget notes for distribution and implementation in the organisation.
Procedure
Read the case study.
Analyse the case study information (including business plan summary and previous financial data)
and complete the following.
Develop a sales budget, profit budget, cash flow budget and debtor ageing summary using
electronic spreadsheets (as separate worksheets) making sure each budget is divided into
quarterly periods and that you use previous financial data to determine allocations for
resources.
Ensure each budget you prepare complies with the organisational and policies and
procedures as provided.
Develop budget notes which include:
identification of reasons for previous profits and losses
your comment on the effectiveness of existing financial management approaches
all assumptions and basis that have been made or used to form budgets
any relevant notes regarding implementation and monitoring of budget expenditure.
To be deemed competent you will need to successfully demonstrate the following:
You must provide:
a completed annual budget in a single spread sheet with a separate sheet for each budget
component. You must print out all worksheets and submit to your trainer.
budget notes
evidence you have reviewed the case study information provided by submitting an appropriate
budget with budget notes
AIC-UP-BSBFIM601-V4.0 Page 2 of 26

Australian Ideal College
Registered as Australian Ideal College Pty Ltd
RTO No.: 91679 | CRICOS Provider Code: 03053G
Sydney Campus: Level 7 & 8, 75 King Street, Sydney NSW 2000 Australia
Adelaide Campus: Level 3, 21-23 Rundle Mall, Adelaide SA 5000 Australia
Hobart Campus: GRD Floor, 116 Murray Street, Hobart TAS 7000 Australia
T: [phone] (Sydney) | [phone] (Adelaide) | [phone] (Hobart)
E: [e-mail] | W: www.aic.edu.auEducating for Excellence
Task 1
b. Development of budget notes
Identifying the reasons for past profit & losses
On the basis of analysis performed between previous years and upcoming year trend in profits and
losses pertaining to Houzit Pty limited, it has been identified the trend of increasing trend of growth in
sales remains the same for the accounting year 2022 / 2023 despite the fact that the upcoming trading year
would be quite difficult as compared to previous years. The reason behind this increase in sales was the
reduction in prices to ensure similar growth in sales even in the difficult trading conditions. Also, the
advertisement budget has increased for the year 2022 / 2023 through which Houzit would be able to
secure greater market share even in the contracted market, thus accounted for higher expenses and
accordingly losses. Further, to ensure growth in the sales of Houzit, there are higher anticipated
expenditure in terms of wages and salaries in order to encourage better efforts from casual staff through
offering commissions for higher sales made by them. In addition to this, a new product has been added to
the existing product line that is, lighting fixture which is anticipated to have contribution of around 20%
of total sales which acts as an element due to which there are higher profits for Houzit in 2022 / 2023. At
last, the reason for which the profit are in the upcoming year's budget is due to the lower interest expenses
resulting from repayment of principal loan amount.
Therefore, all these reasons listed above contributed towards low profitability of Houzit in an attempt to
maintain the similar sales growth.
Along with this, there are losses attributed to the increase in expenses on account of inflation as
well as luxury car bought by CEO but there is an increasing trend in last many year's gross profit.
Commenting on the effectiveness of existing approaches of financial management
The current financial management approach is quite ineffective which can be explained
through the example that Houzit made unnecessary expense for the purchase of luxury car which is fuel
inefficient and have attracted luxury car tax which is not a profitable deal for Houzit and by avoiding this
expenditure they could save much towards higher profitability. Another, ineffective decision made by
management is that of the increment in advertisement budget which leads to higher expenditure but lower
profitability for the business (Mora and Triana, 2018). So, at this point it could be said that management
could resort to some other strategies in an attempt to maintain sales growth. At last, it could be said that
the decision to lower the prices is not effective in the scenario of increasing expenses as a result of rise in
inflation. Therefore, instead of raising price, the prices has been lowered which doesn't seems to be
effective approach of financial management team at Houzit.
Assumptions and basis made or used for creating budget
There are certain assumptions and basis that are used or made while preparing a budget for 2022 / 2023,
such as the following:
1. All the costs are increased to the extent of rise in inflation that is, 4% followed by their respective
behaviour in previous year.
2. On the basis of sales growth determined for the last three years, the budgeted sales has been increased
by the same proportion that is, 8%.
3. The balance of debtors at the ending of each quarter has been kept at 20% of the sales made during that
particular quarter.
4. It has been assumed that the expenses such as depreciation, bank charges and fringe benefit tax would
remains the same as it was in previous year.
Notes associated with the implementation & monitoring of budget expenditure
1. To ensure better monitoring of budgeted expenditure, all the time sheets needs to be approved &
AIC-UP-BSBFIM601-V4.0 Page 3 of 26

Australian Ideal College
Registered as Australian Ideal College Pty Ltd
RTO No.: 91679 | CRICOS Provider Code: 03053G
Sydney Campus: Level 7 & 8, 75 King Street, Sydney NSW 2000 Australia
Adelaide Campus: Level 3, 21-23 Rundle Mall, Adelaide SA 5000 Australia
Hobart Campus: GRD Floor, 116 Murray Street, Hobart TAS 7000 Australia
T: [phone] (Sydney) | [phone] (Adelaide) | [phone] (Hobart)
E: [e-mail] | W: www.aic.edu.auEducating for Excellence
authorized (Ahrens, Ferry and Khalifa, 2018).
2. All the service invoices needs to be signed & linked with the respective purchase order.
3. Performance of reconciliation must be ensured between third party bank statements and company's
books.
4. Appropriate communication between department and employees at head office and shop floor to ensure
required lines of feedback and proposing a solution for the correction of errors along with making sure
that new strategy devised at top level has been communicated to them.
AIC-UP-BSBFIM601-V4.0 Page 4 of 26

Australian Ideal College
Registered as Australian Ideal College Pty Ltd
RTO No.: 91679 | CRICOS Provider Code: 03053G
Sydney Campus: Level 7 & 8, 75 King Street, Sydney NSW 2000 Australia
Adelaide Campus: Level 3, 21-23 Rundle Mall, Adelaide SA 5000 Australia
Hobart Campus: GRD Floor, 116 Murray Street, Hobart TAS 7000 Australia
T: [phone] (Sydney) | [phone] (Adelaide) | [phone] (Hobart)
E: [e-mail] | W: www.aic.edu.auEducating for Excellence
Case study
You have recently been appointed as the business manager of Houzit Pty Ltd having been a store
manager for the past three years. Houzit Pty Ltd is a 15 store retail chain located in Brisbane. Houzit is
the leading homewares retailer, catering to the growing need for furnishing new and renovated dwellings
in the greater Brisbane area.
The assortment on offer of bathroom fittings, bedroom fittings, mirrors and decorative items together with
the recently added lighting fixtures has positioned Houzit as a leader in homewares retailing in Australia.
Houzit has grown over the past five years from a single store to the current chain. Houzit prides itself on
superior after sales service which has been a key reason for the continued growth in sales and
corresponding profit increases. Today Houzit employs over 150 staff.
Houzit Pty Ltd is a proprietary limited company (ACN 34 765 234 02) registered with the Australian
Securities and Investment Commission. The registered address is with Houzit’s solicitors (Langs
Lawyers, 535 Queen Street, Brisbane, QLD 4000) and the principle place of business is 505 Boundary
Street Spring Hill Brisbane QLD 4000.
Computer software requirement
The current accounting information system has not adequately provided sufficient analysis of revenue
and expenditure and has made it difficult to make informed estimates of future profits. Estimates have
relied on the ‘gut feel’ of the experienced traders on the board and of the senior managers. The board
sees the need to apply more analysis to past results that they believe could be done with the introduction
of state-of-the-art computer software.
Houzit Pty Ltd wants to upgrade their existing accounting system which will manage the company
accounts more efficiently in the long run. They request that the new system you recommend to them to
be compliant with all legislative and statutory requirements for small to medium businesses.
None of Houzit’s products are GST free however the accounting information system records the GST
collected as well as the input tax credits earned on the purchases of stock and assets. These amounts
are reported and paid in accordance with the business activity statement (BAS) schedule determined by
the Australian Tax Office.
They have 100 fulltime and 50 part-time staff, but only 10 of the staff will have or need access to the
financial system. Some staff are paid on a salary sacrifice arrangement that attracts fringe benefits tax.
The staff with access to the financial system want software that is a single purchase with no ongoing
license fees, and a plan to keep using if for the next 3–5 years, while the organisation continues to grow.
They are anticipating that within five years they will have over 250 full-time staff, and at least 20 staff will
require access to the financial system by then.
The payroll system deducts withholding tax from the employees and remits this along with the firm’s pay
as you go (PAYG) instalment each quarter as reported on the firm’s business activity statement. Income
tax return for the company and its annual statement is completed by the firm’s accountant. Taxes and
fees due are paid by the due dates. Financial records are kept at Houzit’s principle place of business.
Houzit have just upgraded their computers and have five new desktop PCs which will be used by the
finance staff. They are current specification machines with i5 CPUs and 8Gb RAM each, and all have
Windows 10 Professional and Norton’s 360 installed with the professional version of Microsoft Office
Small Business as well. Other staff will use their machines at various times, so it is important that the
software requires a login to access data and that data stored by the software cannot be accessed in any
other way.
AIC-UP-BSBFIM601-V4.0 Page 5 of 26

Australian Ideal College
Registered as Australian Ideal College Pty Ltd
RTO No.: 91679 | CRICOS Provider Code: 03053G
Sydney Campus: Level 7 & 8, 75 King Street, Sydney NSW 2000 Australia
Adelaide Campus: Level 3, 21-23 Rundle Mall, Adelaide SA 5000 Australia
Hobart Campus: GRD Floor, 116 Murray Street, Hobart TAS 7000 Australia
T: [phone] (Sydney) | [phone] (Adelaide) | [phone] (Hobart)
E: [e-mail] | W: www.aic.edu.auEducating for Excellence
Corporate details
Jim Schneider, the CEO, has asked you to prepare some financial budgets for the 2022/23 financial year
as a preliminary overview of the financial year ahead. He asked you to first prepare a 12 months budget
and then break it up over the four quarters. The areas he is particularly interested in seeing is:
Sales budget for 2022/23 by department by quarter.
Profit budget (including detailed expenses) for 2022/23 by quarter.
The cash flow result per quarter of the GST after adjusting the GST collected by the allowable
GST tax credits.
The anticipated aged debtors summary at the end of each quarter.
The CEO wants to be given all the budgets except for the aged debtors budget which the accountant
and accounts receivable clerk can monitor. The CEO produced a summary of the current business plan
that covered the budget year to highlight some of the key goals, objectives and strategies he would like
incorporated into the budget.
AIC-UP-BSBFIM601-V4.0 Page 6 of 26