Reference no: EM132443497
BAO5522 Managerial Accounting Assignment - Victoria University, Australia
Learning outcomes - On successful completion of this unit, students should be able to:
1. Understand the role of managerial accounting in the management process.
2. Appreciate how accounting practice can inform management decisions about planning, action and accountability and reduce risk and uncertainty.
3. Comprehend the language of managerial accounting and its inter-disciplinary nature.
4. Become familiar with the economic, social, environmental and political context that frames managerial accounting practice.
5. Apply enhanced problem solving, analytical, communication and interpersonal skills in providing managerial accounting information.
6. Prepare, analyse, interpret and communicate performance information required for organisational planning, implementation, control and evaluation in terms of:
a. cost accounting systems
b. cost-volume-profit relationships
c. incremental analysis
d. operational and financial budgets
e. capital investments
f. sustainability reporting and performance management frameworks
7. Perform managerial accounting activities using manual and electronic means.
8. Demonstrate technical literacy in applying statistical methods.
9. Apply Excel and Tableau technologies to the computation and display of performance information.
10. Understand and apply ethical considerations in managerial accounting activities.
11. Work effectively and collaboratively in teams.
12. Be reflective about their knowledge, skills, values and on-going professional education.
Assessment 1 - Evaluation of analysis and reporting
The objective of this case study based project is to interrogate the quality of performance information reported by a company about its internal context (organisational health & performance).
1. The big idea: identify and discuss the 'good, the bad and the ugly' of the quality of a company's reported performance information.
In this assignment you will critically interrogate the nature and quality of a company's performance reporting on the key elements of an organisation's INTERNAL CONTEXT (organisational health and organisational performance) - the things that drive and shape sustainable value creation - as outlined in the PWC Value Framework (below). You do not interrogate the EXTERNAL CONTEXT in this assignment.
The objective is for you to learn from measurement and reporting practice while developing and applying technical, analytical, problem solving and communication skills.
2. The PWC Value Framework (see Topic 1 notes for more detail)
Structure - Your report should be about 19 pages long assuming:
An introductory page one.
One page each of the 17 elements for organisational health and organisational performance in the PWC Value Framework taking one page (about ½ the page for the insertion of the item and ½ page for discussion of the comprehensiveness and accessibility).
One page on materiality (here note what materiality is in a paragraph, and insert an example from the report if the company is explicit about materiality).
Assessment 2 - Technical data analysis tasks
Assessed on the level of satisfactory completion of assigned Excel-based Data analysis tasks A to J.
1. The big idea: combine statistical and information technology tools to providing financial and non-financial information for managerial decision making
2. The tasks:
Data analysis task A - Using Tableau's business intelligence analysis to calculate and display cost and quantity relationships.
Data analysis task B - Estimating straight line relationships using regression analysis.
Data analysis task C - Prescriptive analytics using Solver to maximise objectives.
Data analysis task D - Using Excel pivot tables to create dynamic dashboards and prepare Pareto analysis.
Data analysis task E - Using correlations to summarise relationships - executive compensation and return on investment performance.
Data analysis task F - Using Excels present and future value functions in capital budgeting.
Data analysis task G - Using Excel's Solver and applying constraints for resource and process issues.
Data analysis task H - Using excel for testing data on quality control.
Data analysis task I - Applying probabilities to forecasting.
Attachment:- Managerial Accounting Assignment File.rar