BIZ201 Accounting for Decision MakingQuantum ComputingBUS307 COMMERCIAL BANKINGAssessment 3: Health AssessmentTemplate for Analyzing the LogicNSB303 Partnerships in Health and IllnessCalculate the derivatives

SOLUTION AT Australian Expert Writers

BIZ201 Assessment 3 Brief 20191111 Page 1 of 12
ASSESSMENT BRIEF
Subject Code and Title
BIZ201 Accounting for Decision Making
Assessment
Scenario Analysis – Individual
Individual/Group
Individual
Length
1500 words
Learning Outcomes
b) Apply relevant accounting concepts to simple
business scenarios.
c) Interpret and analyse the information contained
in general purpose financial statements, to
evaluate the overall financial position and
performance of a business.
Submission
By 11:55 pm AEST/AEDT Sunday of Module 4 (Week 9)
Weighting
30%
Total Marks
100 marks
Context:
This assessment is aimed at consolidating knowledge from Modules 1-3. By prescribing this
assessment, you are able to reflect on the understanding of accounting concepts and be
able to apply them to business scenarios like given in this case study.
Instructions:
1. The case study below presents a business scenario. Answer questions in Part 1 and 2 at
the end of this case study.
2. Submit two files; Excel Workbook and the Business Report.
3. For calculation questions show all workings through appropriate Excel formulas. Copy
pasted numbers without appropriate Excel formulas will not be accepted.
4. Submit your assessment files using the following naming convention:
First Name_Last Name_BIZ201_Case_Study A_Assessment3_Workbook.xlsx
First Name_Last Name_BIZ201_Case_Study A_Assessment3_Report.doc
BIZ201 Assessment 3 Brief 20191111 Page 2 of 12
Crystal Hotel Pty Ltd is a privately owned 3.5 stars hotel located in Sydney. The Hotel consists of
160 rooms with maximum capacity of 350 guests, a restaurant with capacity of 150 guests, a
function room with maximum capacity of 250 guests and a conference room with maximum
capacity of 200 guests. The average price per room per night is $150.
While the hotel is located in a very popular location, close proximity to a river and in the city
centre, it is becoming quite out-dated. The owners rely heavily on their corporate clientele. Clients
usually use the hotel for their expat employees. Due to long-term contracts, they pay on credit
with invoices being issued at the end of each month. The hotel is often faced with outstanding
invoices. The owners have so far tolerated it as it usually occurs with their long-term clients.
Additionally, to the accommodation services, they often use hotel facilities for their functions and
conferences.
The hotel is constantly having difficulties retaining a good quality staff as they always get junior
personnel, which once gaining experience will usually leave for better opportunities in hotels with
higher ratings. The biggest issue is to retain high quality personnel in the hotel restaurant, especially
a chef.
The owners would like to increase the hotel star rating by renovating or refurbishing the hotel and
improving their services. They are thinking about building a Wellness Centre on the rooftop of the
hotel, which would include a massage treatment room, gym, spa, sauna and an outdoor pool.
As new plans will require quite extensive capital investment, the owners
would like to know where they stand financially before making any
major decisions. You have been appointed to analyse their financial
statements and to give them an insight on which areas should be
improved and analysed further.
You are expected to conduct the financial statement analysis in an Excel
workbook and then use your findings in creating a business report to be
submitted to the client.
Crystal Hotel Case Study
BIZ201 Assessment 3 Brief 20191111 Page 3 of 12
Part 1 – Excel Workbook Calculations
This Excel Workbook is available on learning portal under assessment section. You will find 6
worksheets within the file. The first 3 contain financial information about the hotel. The final 3
worksheets are for you to complete calculations. All answers to be rounded to 2 decimal places.
You must submit the completed Excel Workbook, Business Report and presentation materials.
1. Vertical Analysis:
a. Conduct a Vertical Analysis of Crystal Hotel’s Statement of Profit and Loss for the
year ended 30 June 2018 using Vertical Analysis P&L worksheet.
b. Conduct a Vertical Analysis of Crystal Hotel’s Statement of Financial Position as at
30 June 2018 using the Vertical Analysis SOFP worksheet.
2. Ratio Analysis:
Conduct a Ratio Analysis using Ratio Analysis worksheet.
Part 2 – Business Report
3. Using the Income Statement Vertical Analysis prepared in Excel workbook, conduct Income
Statement comparative analysis to the industry benchmarks included in Table 1 and Table 2
of the Appendix.
Comment on:
• How the business is performing compared to industry
• Revenue
• Cost of sales
• Personnel costs
• Unallocated Operating costs and
• Total costs proportions
Make recommendations on areas that need improvements or further investigation, based
on the results of your comparative analysis.
4. Using the results of the Ratio Analysis in Excel workbook, comment on Profitability,
Efficiency, Liquidity and Solvency of the business. With reference to the industry data
provided, make recommendations where appropriate.
5. There are additional industry specific performance indicators and benchmarks that the hotel
could use when comparing itself to the industry. Conduct a research and recommend 3
additional industry specific benchmarks the hotel could use in their comparative analysis.
Include a brief explanation of each benchmark you are recommending including formula
where appropriate.
See the Report Format section for guidance on the report structure.
BIZ201 Assessment 3 Brief 20191111 Page 4 of 12
Part 3 – Presentation
In this section you must communicate by presenting your findings to the owners. Prepare a short 5-10 minute
summary of the main findings of your report. It should specifically focus on:
• Your analysis of the current financial status of the hotel
• Your recommendations for the hotel based on your financial analysis
As the future of the hotel is at stake, the owners are likely to ask questions about your analysis and
recommendations. Ensure that you are prepared to defend your arguments and address any concerns.
Although the financial calculations and business report are individual items, if you have reached similar
conclusions, you may undertake this section of the assessment in pairs.
Face to Face On-campus Students
This section of the assessment will take place in class in Week 10 of the trimester. Failure to attend will result
in ‘0’ grade for this section of the assessment.
Online Students
This section of the assessment will take place during Week 10 of the trimester via a synchronous online session
with your Facilitator. You may also submit this section via a pre-recorded video. Failure to attend will result in
‘0’ grade for this section of the assessment.
Submission Instructions
All students must submit via the learning portal the following:
• Completed Excel Workbook containing calculations
• Business Report
• Presentation materials e.g. PowerPoint Slides
BIZ201 Assessment 3 Brief 20191111 Page 5 of 12
Report Format
As this is a business report, the following sections and headings should be included in your write up:
➢ Title Page – including subject name, assessment title, date, your details (student name, ID)
➢ Executive Summary – An executive summary provides a succinct summary of the content within the
report. It presents information in such a way that readers are able to understand the intention and key
elements of the report without having to read the entire document. This section is not included in the
word count and will be approximately 300 words long.
➢ Table of Contents – A summary of the sections and pages numbers
➢ Introduction – The introduction sets the scene and provides context for the aim. It provides background to
the issues being addressed only. (Approximately 10% of word count)
➢ Main Discussion – (Rename the headings/sub-headings to reflect your report). This section should
provide information regarding the analysis you undertook addressing the key deliverables i.e. Part 2
➢ Conclusion – The conclusion restates the aim then provides a brief and concise summary of the discussion
to demonstrate that the aim of the report has been achieved. No new information is to be included in the
conclusion. (Approximately 10% of word count)
➢ References – Please use the correct APA referencing style and list in alphabetical order. It is recommended
that you use reference management software such as EndNote or Mendeley to make the job of
referencing simple and straightforward. Remember, every factual statement in your report will require a
reference. Please see the marking rubric at the end of this document for a guide to how many references
you should be including in this report.
Need to brush up on your referencing? See here for some examples – TUA referencing guide (you must be
logged into the learning portal)
➢ Appendices – This is where you provide supporting material which is unsuitable for inclusion in the body
of the report, but still has some value to contribute to the report. Note – if you have included an
Appendices section in your report, you must mention them in the main body.
BIZ201 Assessment 3 Brief 20191111 Page 6 of 12
Appendix – Industry Data
Table 1 Vertical Analysis of Statement of Profit and Loss based on Number of Rooms
BIZ201 Assessment 3 Brief 20191111 Page 7 of 12
Table 2 Vertical Analysis of Statement of Profit and Loss based on Average Room Price Range
BIZ201 Assessment 3 Brief 20191111 Page 7 of 12
Marking Rubric: Assessment 3
Assessment
Attributes
Fail
(Unacceptable)
0 – 49
Pass
(Functional)
50 – 64
Credit
(Proficient)
65 – 74
Distinction
(Advanced)
75 – 84
High Distinction
(Exceptional)
85 – 100
Grade Description
(Grading Scheme)
Fail grade will be
awarded if a student is
unable to demonstrate
satisfactory academic
performance in the
subject or has failed to
complete required
assessment points in
accordance with the
subject’s required
assessment points.
Pass is awarded for work
showing a satisfactory
achievement of all learning
outcomes and an adequate
understanding of theory and
application of skills. A
consistent academic
referencing system is used
and sources are
appropriately
acknowledged.
Credit is awarded for work
showing a more than
satisfactory achievement of all
learning outcomes and a more
than adequate understanding
of theory and application of
skills. A consistent academic
referencing system is used
and sources are appropriately
acknowledged.
Distinction is awarded for
work of superior quality in
achieving all learning
outcomes and a superior
integration and
understanding of theory
and application of skills.
Evidence of in-depth
research, reading, analysis
and evaluation is
demonstrated. A consistent
academic referencing
system is used and sources
are appropriately
acknowledged.
High Distinction is awarded
for work of outstanding
quality in achieving all
learning outcomes together
with outstanding
integration and
understanding of theory
and application of skills.
Evidence of
in‐depth research, reading,
analysis, original and
creative thought is
demonstrated. A consistent
academic referencing
system is used and sources
are appropriately
acknowledged.
Calculation of
financial metrics
SLO Addressed:
c) Interpret and
analyse the
information
contained in general
purpose financial
statements, to
evaluate the overall
financial position
Demonstrates no
evidence of use excel
formulas and relevant
worksheets to calculate
appropriate ratios.
Demonstrates limited
evidence of use excel
formulas and relevant
worksheets to calculate
appropriate ratios.
Demonstrates consistent
evidence of use excel
formulas and relevant
worksheets to calculate
appropriate ratios.
Demonstrates an advanced
evidence of use excel
formulas and relevant
worksheets to calculate
appropriate ratios.
Consistently demonstrates
an advanced evidence of
use excel formulas and
relevant worksheets to
calculate appropriate
ratios.
BIZ201 Assessment 3 Brief 20191111 Page 8 of 12
and performance of
a business.
15%
Application of Vertical
analysis of financial
statements
SLO Addressed:
c) Interpret and
analyse the
information
contained in
general purpose
financial
statements, to
evaluate the
overall financial
position and
performance of a
business.
18%
Demonstrates no
application of vertical
analysis of Balance Sheet
and Income Statement.
Excel formulas are not
used for calculation.
Demonstrates limited
application of vertical
analysis of Balance Sheet
and Income Statement. Few
correct Excel formulas are
used for calculation.
Demonstrates consistent
application of vertical analysis
of Balance Sheet and Income
Statement. Not all Excel
formulas used for calculation
are correct.
Demonstrates an advanced
application of vertical
analysis of Balance Sheet
and Income Statement.
Most Excel formulas used
for calculation are correct.
Consistently demonstrates
an advanced application of
vertical analysis of Balance
Sheet and Income
Statement. All Excel
formulas used for
calculation are correct.
Comparison of Vertical
analysis of financial
statements calculations
with industry values
including comments on
various types of costs
No understanding of use
Vertical Analysis of
financial statements
calculations prepared in
Excel for comparison to
industry values provided in
the Appendix.
Limited understanding of
use Vertical Analysis of
financial statements
calculations prepared in
Excel for comparison to
industry values provided in
the Appendix.
Demonstrates consistent
understanding of use Vertical
Analysis of financial
statements calculations
prepared in Excel for
comparison to industry values
provided in the Appendix.
Well demonstrated
understanding of use
Vertical Analysis of financial
statements calculations
prepared in Excel for
comparison to industry
values provided in the
Excellent demonstrated
understanding of use
Vertical Analysis of financial
statements calculations
prepared in Excel for
comparison to industry
values provided in the
BIZ201 Assessment 3 Brief 20191111 Page 9 of 12
SLO addressed:
b) Apply relevant
accounting
concepts to
simple business
scenarios.
c) Interpret and
analyse the
information
contained in
general
purpose
financial
statements, to
evaluate the
overall financial
position and
performance of
a business.
18%
No comments on Revenue,
Cost of Sales, Personnel
Costs, Unallocated
Operating Costs and Total
Costs proportions.
Limited comments on
Revenue, Cost of Sales,
Personnel Costs,
Unallocated Operating Costs
and Total Costs proportions.
Some comments on Revenue,
Cost of Sales, Personnel Costs,
Unallocated Operating Costs
and Total Costs proportions.
Appendix.
Good comments on
Revenue, Cost of Sales,
Personnel Costs,
Unallocated Operating Costs
and Total Costs proportions.
Appendix.
Well commented on
Revenue, Cost of Sales,
Personnel Costs,
Unallocated Operating
Costs and Total Costs
proportions.
Understanding of
Profitability, Efficiency,
Liquidity and Solvency
of the business using
ratio analysis with
reference to industry
data
SLO addressed:
b) Apply relevant
accounting
concepts to
simple business
scenarios.
c) Interpret and
No use of ratio analysis to
demonstrate the
understanding of
Profitability, Efficiency,
Liquidity and Solvency of
the business. No reference
to industry data is
provided.
Limited use of ratio analysis
to demonstrate the
understanding of
Profitability, Efficiency,
Liquidity and Solvency of the
business. Limited comments
were made with reference
to industry data provided.
Well-developed use of ratio
analysis to demonstrate the
understanding of Profitability,
Efficiency, Liquidity and
Solvency of the business.
Some comments are made
with reference to industry
data provided.
Thoroughly developed
understanding of
Profitability, Efficiency,
Liquidity and Solvency of the
business by using ratio
analysis. Good comments
were made with reference
to industry data provided.
Highly developed
understanding of
Profitability, Efficiency,
Liquidity and Solvency of
the business by using ratio
analysis. Recommendations
are clearly justified based
on reference to industry
data provided.
BIZ201 Assessment 3 Brief 20191111 Page 10 of 12
analyse the
information
contained in
general
purpose
financial
statements, to
evaluate the
overall financial
position and
performance of
a business.
18%
Application of own
research to further
develop comparative
analysis of hotel
SLO addressed:
b) Apply relevant
accounting
concepts to
simple business
scenarios.
c) Interpret and
analyse the
information
contained in
general
purpose
financial
statements, to
evaluate the
overall financial
position and
No evidence of own
research to provide
examples of three industry
specific benchmarks the
hotel could use for further
comparative analysis. No
explanation of any
benchmark including
formulas is provided.
Limited evidence of own
research to provide
examples of three industry
specific benchmarks the
hotel could use for further
comparative analysis.
Limited explanation of any
benchmark including
formulas is provided.
Consistent evidence of own
research to provide examples
of three industry specific
benchmarks the hotel could
use for further comparative
analysis. Consistent
explanation of each
benchmark including formulas
is provided.
Demonstrates an advanced
evidence of own research to
provide examples of three
industry specific
benchmarks the hotel could
use for further comparative
analysis. Well-developed
explanation of each
benchmark including
formulas is provided.
Highly sophisticated
evidence of own research to
provide examples of three
industry specific
benchmarks the hotel could
use for further comparative
analysis. Thoroughly
developed explanation of
each benchmark including
formulas is provided.
BIZ201 Assessment 3 Brief 20191111 Page 11 of 12
performance of
a business.
10%
Presentation
Interpretation of results,
formulation of solutions
and communication of
ideas
16%
Limited to no
understanding of financial
terms and concepts.
Limited to no knowledge of
financial matters and its
relationship to business
strategy and operations.
Presentation was flawed
and lacked substance and
in key areas
Limited understanding of
financial terms and
concepts.
Limited knowledge of
financial matters and its
relationship to business
strategy and operations.
Presentation was delivered
and contained flaws in the
delivery style
Good understanding of
financial terms and concepts.
Good knowledge of financial
matters and its relationship
business strategy and
operations.
Presentation was delivered
and contained some flaws in
the delivery style
Very good understanding of
financial terms and
concepts.
Very good knowledge of
financial matters and its
relationship to business
strategy and operations.
Presentation was persuasive
and delivered skilfully with
minor flaws in style
Sophisticated understanding
of financial terms and
concepts.
High-level knowledge of
financial matters and its
relationship to business
strategy and operations.
Presentation was highly
persuasive and expertly
delivered.
Correct citation of key
resources and evidence
Overall structure,
appearance and
referencing of the
report are assessed
5%
Demonstrates inconsistent
use of good quality,
credible and relevant
resources to support and
develop ideas. Less than 4
good quality references
provided. Has not correctly
used APA referencing style.
Demonstrates use of
credible and relevant
resources to support and
develop ideas, but these are
not always explicit or well
developed. At least 4 good
quality references provided.
Multiple mistakes and
errors in reference list.
Demonstrates use of high
quality, credible and relevant
resources to support and
develop ideas. At least 6
good quality references
provided. Some mistakes and
errors in reference list.
Demonstrates use of good
quality, credible and
relevant resources to
support and develop
arguments and statements.
Shows evidence of wide
scope within the
organisation for sourcing
evidence. At least 6 good
quality references
provided. Few mistakes and
errors in reference list.
Demonstrates use of high
quality, credible and
relevant resources to
support and develop
arguments and position
statements. Shows evidence
of wide scope within and
without the organisation for
sourcing evidence. At least 8
good quality references
provided. No mistakes and
errors in reference list.

Order from Australian Expert Writers
Best Australian Academic Writers

QUALITY: 100% ORIGINAL PAPERNO PLAGIARISM – CUSTOM PAPER

Assignment status: Already Solved By Our Experts

YOU MAY ALSO READ ...  Explain how the financial statements would differ if another method were used to capture the costs. – Original

(USA, AUS, UK & CA Ph. D. Writers)

CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS

Order from Australian Expert Writers
Best Australian Academic Writers

QUALITY: 100% ORIGINAL PAPER – NO PLAGIARISM – CUSTOM PAPER