Diligently address the criteria in the THE MARKING RUBRIC as you plan, create, evaluate, and improve upon your model and report
Strategic Management Accounting –Spreadsheet Model and Report Marking Rubric
| Criteria | High Distinction | Distinction | Credit | Pass | Fail |
| Knowledge and application of sustainabilityframeworks, theories and concepts and responsibilities in a business context.
(15%) |
Rigorously applies sophisticated and insightful knowledge sustainability frameworks, theories and concepts and responsibilities in a business context. | Effectively applies very good
knowledge of sustainability frameworks, theories and concepts and responsibilities in a business context. |
Applies sound knowledge of sustainability frameworks, theories and concepts and responsibilities in a business context. | Applies adequate knowledge of some aspects of sustainability frameworks, theories and concepts and responsibilities in a business context but has some gaps in knowledge in some of these areas. | Based on inadequate application, demonstrates limited knowledge of sustainability frameworks, theories and concepts and responsibilities in a business context. |
| Knowledgeand application of ethical frameworks, theories and concepts and responsibilities in a business context.
(15%) |
Rigorously applies sophisticated and insightful knowledge of ethical frameworks, theories and concepts and responsibilities in a business context. | Effectively appliesvery good
knowledge of ethicalframeworks, theories and concepts and responsibilities in a business context. |
Appliessound knowledge of ethical frameworks, theories and concepts and responsibilities in a business context. | Applies adequate knowledge of aspects of ethicalframeworks, theories and concepts and responsibilities in a business context but demonstrates some gaps in knowledge in some of these areas. | Based on inadequate application, demonstrates limited knowledge of ethical frameworks, theories and concepts and responsibilities in a business context. |
| Capacity to take on board diverse stakeholder interests in a business decision making context.
(10%) |
Demonstrates capacity to accurately elicit,interpret and embrace the interests of diverse stakeholders, evidenced through the rigorous application of highly professional, socially responsible, ethical and sustainable approaches to decision making in a business context. | Demonstrates ability to elicit and interpretthe interests of diverse stakeholders through the application of professional, socially responsible, ethical and sustainable approaches to decision making in a business context. | Demonstrates appreciation of the interests of most stakeholders through the application of socially responsible, ethical and sustainable approaches to decision making in a business context. | Demonstrates awareness of the need to consider the interests of key stakeholders when making decisions in a business context. | Demonstrates limited awareness of the need to consider the interests of stakeholders when making decisions in a business context. |
| Knowledge and application of the relevant legislation/standards/codes of conduct /universal principles associated with social responsibility, ethical conduct and sustainable practice in a business context.
(10%) |
Rigorously applies sophisticated knowledge of relevant legislation/standards/codes of conduct/universal principles associated with social responsibility, ethical conduct and sustainable practice in a business context. | Effectively applies comprehensiveknowledge of relevant legislation/standards/codes of conduct/universal principles associated with social responsibility, ethical conduct and sustainable practice in a business context. | Applies sound knowledge of relevant legislation/standards/codes of conduct/universal principles associated with social responsibility, ethical conduct and sustainable practice in a business context. | Applies adequateknowledge of relevant legislation/standards/codes of conduct/universal principles associated with social responsibility, ethical conduct and sustainable practice in a business context. | Based on inadequate application, demonstrates limited or no knowledge of relevant legislation/standards/codes of conduct/universal principles associated with social responsibility, ethical conduct and sustainable practice in a business context. |
| Capacity to develop a spreadsheet model that meet’s the user’s needs.
(25%) |
All user’s requirements are incorporated into the model in ways that effectively increase the usability, effectiveness, or efficiency of the spreadsheet. | All user’s requirements are incorporated into the model, but some are not effectively or efficiently applied. | Minor omissions in meeting the user’s requirements. | Some of the user’s requirements are incorporated into the model. | Significant omissions in attempting to meet the user’s requirements. |
| Knowledge and application of sound principles of spreadsheet design.
(25%) |
Model is accurate, usable, flexible and auditable. | Model attempts to be accurate, usable, flexible and auditable but there are some oversights. | Model is missing, or does not achieve, one of the important features of accuracy, usability, flexibility, or auditability. | Model is missing, or does not achieve, two of the important features of accuracy, usability, flexibility, or auditability. | Model is missing, or does not achieve, three or more of the important features of accuracy, usability, flexibility, or auditability. |
Description
You will develop collaborative skills through the production of a strategic management project using Microsoft Excel.
This is a group assignment (of 3-4 students). Design a spreadsheet model to address the business problem and meet the user's requirements: Assignment Task ACC610 2019 ATMC.docx
You will demonstrate a capacity for socially responsible and sustainable approach to buiness decisions.
Resources
This reading addresses the important issue of ethics – and the ethical evaluation of sustainability issues.
The extract Ethics of Sustainability Textbook extract.docx
focuses on specific aspects that will be useful for your assignment.
You may also wish to access the complete book – it is available at:
(http://rio20.net/wp-content/uploads/2012/01/Ethics-of-Sustainability-Textbook.pdf Accessed 14/01/2019)
Note that this will NOT be examined in the final examination.
The features of a good spreadsheet model can be found in this document: Instruction document for Excel Spreadsheet.docx
A spreadsheet model that illustrates some of the principles of good spreadsheet design: My Learning Model.xlsm
Rubric
Pay careful attention to the marking rubric: Marking Rubric Report.docx
Mulga Meadows
Mulga Meadows is a gold mining company that operates open-pit mines in Western Australia.
Potential sites are spread throughout the state. In addition to the quality of the deposit, issues of transportation, native title, and facilities for employees are also important considerations in determining which potential sites will be developed.
Extraction involves mining large quantities of ore that are then processed as per the flow chart below (see Figure 1)[3].
Figure 1 – Gold mining process flow chart
Required:
Create a spreadsheet to allow scenario planning for Mulga Meadows. You can focus on any aspect (or combinations) of the company’s operation (such as site feasibility analysis, mining, processing, or rehabilitation). Your model will:
Identify at least three stakeholders affected by the operations of the business (in terms of the sustainability criteria in requirement 2).
Identify at least 3 sustainability criteria, at least one in each of the categories of economic, social, and environmental performance.
Identify and justify where you obtained each criteria and how it is measured.
Provide an ethical evaluation of each criteria (maximum 100 words each).
Identify a legislative requirement relating to the operations of the business.
Identify at least four choices that will affect your criteria.
Your model should allow you to input choices and see the effect on the criteria. This will require you to make assumptions about the relationships between the choices and performance criteria that should be clearly stated and able to be adjusted.
(Note that throughout your work on the assignment it will be important that you plan, apply, and reflect upon your teamwork. You will report on your application of good team-management processes in the oral presentation.)
Required
Can you please focus on the Red highlighted point for the word document 50% theory part
For excel sheet 50 % please find the attached link u will get knowledge how to do excel part.
