ACC 2100 Management Accounting
Project description
Using the textbook: Management Accounting, Information for Creating and Managing Value 7th Edition by Lang field-Smith K,Thorne H, Smith D and Hilton R. And use an excel spreadsheet file in which at least 3 separate
worksheets (1 for each question) should be created to answer each question.
.
Assessment Description
Objective: The objective of this assignment is to effectively work in teams to formulate and recommend
possible solutions in practical scenarios using management accounting techniques and tools, especially
excel spreadsheets
Required:
Work in teams (groups) of 3 members (please get your lecturer’s prior approval to change the team size)
to complete the case studies using the excel spreadsheet program as noted in the details of assignment.
Any work which has been copied or shared between teams or groups will result in a Fail grade for all
students concerned. This assignment must be your teams own work and all members of the team will be
awarded the same team mark. Your team’s work must not be copied directly from any source.
Please check the marking rubric for each part to ensure that you have followed all the guidelines for
presenting your work. The assignment will need to be submitted electronically on the portal by the due
date. Please make sure you follow the guidelines especially those relating to the presentation of written
work, late assignment policy, and academic integrity.
DETAILS OF ASSIGNMENT: CASE STUDIES USING EXCEL SPREADSHEET
Students are required to complete the following questions taken from the prescribed textbook;
Management Accounting, Information for Creating and Managing Value 7th Edition by Langfield-Smith K,
Thorne H, Smith D and Hilton R.
Please note that you are required to use an excel spreadsheet file in which at least 3 separate
worksheets (1 for each question) should be created to answer each question. You may have more
than 3 worksheets in your file if you wish to. Each question carries a total mark of 15; 3 of these marks will be allocated for spreadsheet design and the remaining 12 marks per question to the technical content.
The questions required to be completed are:
Case Study 1: Chapter 9 – Problems: P 9.30 using an excel spreadsheet answer all requirements
(pages 424 – 425) 15 Marks
Case Study 2: Chapter 5 – Problems: P 5.33 using an excel spreadsheet answer all requirements
(page 210 – 211) 15 Marks
Case Study 3: Chapter 18 – Cases: C18.31 using an excel spreadsheet answer all requirements
(pages 832 – 833)
ACC 2100 Management Accounting
Borrowing needed
The excel spreadsheet well
designed (easy to understand,
applicable and appropriate) and are outstandingly well linked, so that simulation is possible. 20.00
12.00
3.00
5.00
CS 2
1(a)
(b)
(c)
2 Chapter 5 – Problems: P 5.33
Calculation of equivalent units
Calculation of unit costs
Analysis of total costs
Prepare Journal Entry
The excel spreadsheet well
designed (easy to understand,
applicable and appropriate) and are outstandingly well linked, so that simulation is possible. 20.00
4.00
4.00
4.00
3.00
5.00
CS 3
1
2
3
4
5
6 Chapter 18 – Cases: C18.31
Break-even calculation
Sales units required
Revised break-even
Selling price calculation
Break-even at 50000 units
Graph
The excel spreadsheet well
designed (easy to understand,
applicable and appropriate) and are outstandingly well linked, so that simulation is possible. 35.00
4.00
5.00
4.00
5.00
5.00
6.00
6.00