IT Applications for Management Accounting
Spring 2017
Resit Coursework Brief
Handout: 13th March 2017
Deadline for Submission: 2:00pm, Thursday 27th
April 2017
Submit this coursework through the Student Portal with a Turn-it-in Report
Word Limit: 2,000 words (Plus or minus 10%)
Learning outcomes assessed:
• Demonstrate competence in the application of Microsoft Excel functions
• Demonstrate an understanding of investment appraisal techniques
• Use Microsoft excel functions to capital budgeting situations
Make management decisions based on results
obtained from their spreadsheet analysis
This coursework is worth 100% of the total marks for this module.
Module Code Module Title Spring 2017 Coursework Brief
GSM LONDON Page 1 of 13
Coursework Instructions
Please read carefully
• Carefully read the module handbook, the marking criteria and the grade
descriptors.
Academic Misconduct
You are responsible for ensuring you understand the policy and regulations
about academic misconduct. You must:
• Complete this work alone except where required or allowed by this
assignment briefing paper and ensure it has not been written or composed
by or with the assistance of any other person.
• Make sure all sentences or passages quoted from other people’s work in
this assignment (with or without trivial changes) are in quotation marks, and
are specifically acknowledged by reference to the author, work and page.
Module Code Module Title Spring 2017 Coursework Brief
GSM LONDON Page 2 of 13
Blank
Module Code Module Title Spring 2017 Coursework Brief
GSM LONDON Page 3 of 13
Assignment Questions
Question 1
River Machining Ltd. manufactures machine tools to customers’ orders. It has
five departments: three production departments (machining, assembly and
finishing) and two service departments (maintenance and canteen). Budgeted
overhead costs for the coming year are provided below:
Overheads £
Supervisors Salaries;
Machining 380,000
Assembly 100,000
Finishing 330,000
Maintenance 220,520
Canteen 212,654
Rent and Rates 400,000
Machine Insurance 116,055
Machine Depreciation 68,000
Production supervisors’ salaries 60,080
Heating and Lighting 25,300
The following additional information is provided on the five departments at River
Machining Ltd.
Departments
Machining Assembly Finishing Maintenance Canteen
floor area (sq. meters) 1,600 1,100 2,000 400 400
Machine Value (£’000) 68,000 15,000 32,000 1,000 500
Direct labour hours 2,300 4,600 1,100
Maintenance dept.
overheads apportioned 20% 45% 35%
Canteen dept. overheads
apportioned 25% 40% 35%
Direct Labour rates £22.00 £15.00 £14.00
You are required to:
Write a report (800 words) to the management of River Machining Ltd. advising
them on the pricing of a unit of machine tool. Your report should be based
entirely on the analysis of your model for the overhead analysis sheet and
should cover the following:
Module Code Module Title Spring 2017 Coursework Brief
GSM LONDON Page 4 of 13
• A discussion of the allocation and apportionment of overheads to each of
the five departments, comparing the total overheads in each department
with the aid of a chart generated from your model.
• A discussion of the total product price and how it was built up – using the
overhead absorption rate. You will need to prepare a standard cost card
showing the budgeted total cost of one unit of machine tool using the
information on each unit of machine tool provided below:
i. Direct materials – £175.50 per unit
ii. Direct Labour – Machining dept. -2.5 hours
– Assembly dept. – 1.5 hours
– Finishing dept. – 1.0 hours
iii. The company applies a 25% mark-up on total unit cost in order to
set the selling price.
• Suppose rent and rates doubled, propose a strategy of passing on the
increase to the customers by specifying a new selling price for the
product which maintains River Machining Ltd.’s 25% mark-up.
Total marks for this Question: 40
Question 2
Timber Plc manufactures and sells different types of furniture: dining room table
and chairs, garden table and chairs, classroom table and chairs, kitchen
cabinets, and chest of drawers. Their products are packaged in pellets and are
sold throughout the country. Information on the number of pellets sold for each
type of furniture in 2016 is provided in the table below. A recent survey shows
that there is a growing demand for bedroom furniture like and wardrobes and
storage chests for children’s toys etc.
Module Code Module Title Spring 2017 Coursework Brief
GSM LONDON Page 5 of 13
Dining
Tables
Dining
Chairs
Garden
Tables
Garden
Chairs
Classroom
Tables
Classroom
Chairs
Kitchen
Cabinets
Chest of
Drawers
January 274 904 797 820 350 350 797 1020
February 707 632 809 292 272 272 809 2192
March 369 574 261 704 234 234 261 1704
April 752 723 884 823 212 212 884 1823
May 483 306 404 249 154 154 404 2249
June 257 229 556 933 111 111 556 933
July 542 488 842 449 0 20 842 3449
August 501 863 812 649 0 34 812 1649
September 277 390 397 470 890 890 397 470
October 467 716 225 208 180 180 225 3208
November 629 357 659 608 90 90 659 1608
December 223 796 208 544 254 254 208 3544
The selling price information is also provided below;
Dining Tables £785
Dining Chairs £179
Garden Tables £340
Garden Chairs £ 56
Classroom Tables £ 88
Classroom Chairs £ 37
Kitchen Cabinets £229
Chest of Drawers £465
I. Using the information provided above calculate the monthly revenue for
each product sold. Your answer must show monthly totals as well as
overall totals.
II. The C.E.O has just received an enquiry from a prospective customer
about the possible supply of wardrobes and toy storage chests. The
factory supervisor has provided a rough idea of the production costs
incurred in the manufacture of the different type of wardrobe they could
manufacture. They are however still awaiting more information from the
customer in order to provide a more accurate quote for the toy storage
Module Code Module Title Spring 2017 Coursework Brief
GSM LONDON Page 6 of 13
unit. See below for the costs involved in the manufacture of the different
wardrobes;
Wardrobe A Wardrobe B
Labour 2 hours @ £9.75/hr Labour 5 hours @ £5.00/hr
Material A 5.5m @ £2.08/m Material A 7m @ £4.35/m
Material B 3.75m @ £6.30/m Material B 3.75m @ £6.30/m
Variable o/h 2hrs @ £4.80/hr Variable o/h 1.5hrs @ £9.20/hr
The company adds a mark-up of 25% to its costs when arriving at its
selling price.
Using the information above produce a standard cost card for wardrobes
A and B. Your answer should include the proposed selling price.
III. The two companies have reached an agreement and the customer has
placed an order for two hundred and fifty units of wardrobe B every
month but this will increase by 50% from July onwards. Produce a
budget showing the expected units sold and revenue obtained for this
new line.
Total marks for this Question: 40
Question 3
In approximately 800 words write a personal reflection on the impact this module has
had on you and also discuss how you would use Excel in a business environment.
Total marks for this Question: 20
Total Marks 100
End of Assignment Brief
Module Code Module Title Spring 2017 Coursework Brief
GSM LONDON Page 7 of 13
Module Code Module Title Spring 2017 Coursework Brief
GSM LONDON Page 8 of 13
Marking Criteria
GENERIC ASSESSMENT MARKING CRITERIA LEVEL 4
KNOWLEDGE &
UNDERSTANDING
INTELLECTUAL & COGNITIVE SKILLS Graduate Skills: transferable, employability, practical
and academic skills
Factual and
conceptual
knowledge and
understanding; use
of class materials;
independent
reading
Critical thinking;
conceptualisation; creativity;
synthesis, analysis and evaluation;
application; problem solving and
research/investigation
Written, oral and presentation skills; interpersonal,
group and teamwork skills; leadership skills; numeracy;
digital skills; practical, professional and academic skills
(including referencing/presentation
MARKI
NG
BAND
MODULE
LEARNING
OUTCOMES
CLASSIFICATI
ON
WEIGHTED AT 45% WEIGHTED AT 30% WEIGHTED AT 25%
86 –
100%
Achieved at
this level
FIRST (1ST) Includes all required
factual content,
accurately
summarised.
Well developed, relevant, reasoned
introduction and conclusions.
Within word count or presentation time.
Includes relevant
factual content only.
Clearly and logically structured
material.
Accurate spelling, grammar, punctuation, paragraphing.
Accurate
identification of
relevant concepts,
theories and/or
principles,
appropriate to this
level.
Information or data selected from a
good range of primary and
secondary sources, and
categorised, analysed or evaluated
using relevant methods or
techniques.
Fluent, interesting writing style, appropriate to the
assignment OR engaging, confident, audible and wellpaced presentation.
Excellent
understanding of
factual and
conceptual material,
relative to this level.
Well developed, coherent
arguments, referencing primary
and secondary literature.
Appropriate visual presentation, including font, spacing,
margins, headings, graphics, images and appendices.
Calculations are
accurate, clearly set
out, with
explanations.
Well-developed integration of
theory and practice, for this level,
using defined conceptual
frameworks.
Correct use of academic conventions, references and
bibliography.
Independent, wideranging reading and
research, from both
primary and
secondary sources,
appropriate to this
level.
Very good application of numerical
and statistical methods to defined
problems.
Outstanding, consistent delivery of group work
obligations, for this level.
Substantiated, relevant
recommendations. Very good
awareness of ethical issues, where
relevant.
Insightful reflection on own strengths and weaknesses in
relation to defined professional and practical skills.
70 –
85%
Achieved at
this level
FIRST (1ST) Includes all required
factual content,
accurately
summarised.
Well developed, relevant
introduction and conclusions.
Within word count or presentation time.
Includes relevant
factual content only.
Clearly structured material. Accurate spelling, grammar, punctuation, paragraphing.
Accurate
identification of
relevant concepts,
theories and/or
principles,
appropriate to this
level.
Information or data selected from
relevant primary and secondary
sources, and categorised, analysed
or evaluated using relevant
methods or techniques.
Fluent writing style, appropriate to the assignment OR
engaging, audible and well-paced presentation.
Very good
understanding of
factual and
Coherent arguments, referencing
primary and secondary literature.
Appropriate visual presentation, including font, spacing,
margins, headings, graphics, images and appendices.
Module Code Module Title Spring 2017 Coursework Brief
GSM LONDON Page 9 of 13
conceptual material,
relative to this level.
Calculations are
accurate, clearly set
out, with
explanations.
Very good integration of theory and
practice, for this level, using
defined conceptual frameworks.
Correct use of academic conventions, references and
bibliography.
Independent, wideranging reading and
research, from both
primary and
secondary sources,
appropriate to this
level.
Good application of numerical and
statistical methods to defined
problems.
Very good, consistent delivery of group work obligations,
for this level.
Relevant recommendations. Good
awareness of ethical issues, where
relevant.
Good reflection on own strengths and weaknesses in
relation to defined professional and practical skills.
60 –
69%
Achieved at
this level
UPPER
SECOND (2:1)
Includes most
required factual
content, mostly
accurately
summarised.
Relevant introduction and
conclusions.
Within word count or presentation time.
Includes relevant
factual content only.
Clearly structured material. Mostly accurate spelling, grammar, punctuation,
paragraphing.
Mainly accurate
identification of
relevant concepts,
theories and/or
principles,
appropriate to this
level.
Information or data selected from
some relevant primary and
secondary sources, and
categorised, analysed or evaluated
using relevant methods or
techniques but with some gaps or
misunderstandings.
Mainly fluent writing style, appropriate to the
assignment OR mainly engaging, audible and well placed
presentation.
Sound
understanding of
factual and
conceptual material,
relative to this level.
Mostly coherent arguments,
referencing primary and secondary
literature.
Mostly appropriate visual presentation, including font,
spacing, margins, headings, graphics, images and
appendices.
Calculations are
mainly accurate,
mostly clearly set
out, with mostly
good explanations.
Good integration of theory and
practice, for this level.
Mostly correct use of academic conventions, references
and bibliography.
Independent
reading and
research from
sufficient and
mostly authoritative
primary and
secondary sources,
appropriate to this
level.
Mainly good application of
numerical and statistical methods
to defined problems, with some
gaps, errors or misunderstandings.
Consistent delivery of group work obligations, for this
level.
Some relevant recommendations.
Satisfactory awareness of ethical
issues, where relevant.
Clear reflection on own strengths and weaknesses in
relation to defined professional and practical skills.
50 –
59%
Achieved at
this level
LOWER
SECOND (2:2)
Includes essential
required factual
content, but with
some gaps or
misunderstandings.
Adequate introduction and
conclusions.
Within 10% of word count or presentation time.
Includes some
irrelevant factual
content.
Mostly clearly structured material. Some mistakes in spelling, grammar, punctuation,
paragraphing.
Module Code Module Title Spring 2017 Coursework Brief
GSM LONDON Page 10 of 13
Some identification
of relevant
concepts, theories
and/or principles,
appropriate to this
level.
Information or data selected from
mainly secondary sources, and
categorised, analysed or evaluated
using mostly relevant methods or
techniques but with gaps or
misunderstandings.
Writing style is appropriate but not always fluent OR a
presentation that is not always engaging, audible or well
placed.
Adequate
understanding of
factual and
conceptual material,
relative to this level.
Limited arguments, referencing
mostly secondary literature.
Inconsistent visual presentation, including font, spacing,
margins, headings, graphics, images and appendices.
Calculations may
have inaccuracies,
or issues relating to
set out and
explanation.
An adequate attempt to relate
theory to practice, for this level,
using defined conceptual
frameworks.
Inconsistent use of academic conventions, references
and bibliography.
Some independent
reading and
research from
mainly secondary
sources,
appropriate to this
level.
Adequate application of numerical
and statistical methods to defined
problems, with gaps, errors or
misunderstandings.
Inconsistent delivery of group work obligations, for this
level.
Basic recommendations.
Satisfactory awareness of ethical
issues, where relevant.
Some evaluation of own strengths and weaknesses in
relation to defined professional and practical skills.
40 –
49%
Marginal
achievement
at this level
THIRD (3RD) Includes limited
required factual
content, with many
gaps or
inaccuracies.
Basic introduction and conclusions. Within 10% of word count or presentation time.
Includes
considerable
irrelevant factual
content.
Unevenly structured material. Frequent mistakes in spelling, grammar, punctuation,
paragraphing.
Limited
identification of
relevant concepts,
theories and/or
principles,
appropriate to this
level.
Information or data selected from
secondary sources, and poorly
categorised, analysed or evaluated
using inappropriate methods or
techniques.
Awkward or inappropriate writing style OR a
presentation that is not engaging, audible or well placed.
Limited
understanding of
factual and
conceptual material,
relative to this level.
Sense of emerging argument,
mainly descriptive or personal
opinion, with little reference to
literature.
Clear but inappropriate visual presentation, including
font, spacing, margins, headings, graphics, images and
appendices.
Calculations are
often inaccurate,
with many issues
relating to set out
and explanation.
Limited attempt to relate theory to
practice, using defined conceptual
frameworks.
Inconsistent or incomplete use of academic conventions,
references and bibliography.
Limited
independent
reading and
research from
secondary sources,
appropriate to this
level.
Weak application of numerical and
statistical methods to defined
problems, with many gaps or
errors.
Unreliable delivery of group work obligations, for this
level.
Recommendations lack clarity or
may be incomplete. Little
awareness of ethical issues, where
relevant.
Limited reflection on own strengths and weaknesses in
relation to defined professional and practical skills.
30 –
39%
Marginal
failure at this
level
FAIL.
POSSIBLE
COMPENSATI
ON.
Includes insufficient
required factual
content, with
significant gaps or
Incoherent or irrelevant
introduction and conclusions.
More than 10% outside word count or presentation time.
Module Code Module Title Spring 2017 Coursework Brief
GSM LONDON Page 11 of 13
inaccuracies.
Includes substantial
irrelevant factual
content.
Incoherently structured material. Serious mistakes in spelling, grammar, punctuation,
paragraphing.
Very limited or
inaccurate
identification of
relevant concepts,
theories and/or
principles,
appropriate to this
level.
Little selection of information or
data, and little attempt at collation,
categorisation, analysis or
evaluation.
Poor writing style OR a presentation that is not engaging,
audible or well placed.
Very limited
understanding of
factual and
conceptual material,
relative to this level.
Little or no argument, entirely
descriptive or personal opinion,
with no reference to literature.
Poor visual presentation, including font, spacing,
margins, headings, graphics, images and appendices.
Calculations are
mostly inaccurate,
or incorrectly set
out or explained.
Theory only sporadically related to
practice, using defined conceptual
frameworks.
Inaccurate or incomplete use of academic conventions,
references and bibliography.
Minimal
independent
reading and
research,
appropriate to this
level.
Very weak application of numerical
and statistical methods to defined
problems, with significant errors.
Poor delivery of group work obligations, for this level.
Irrelevant recommendations. Little
or no awareness of ethical issues,
where relevant.
Very limited reflection on own strengths and weaknesses
in relation to defined professional and practical skills.
16 –
29%
Not achieved
at this level
FAIL. NO
COMPENSATI
ON.
Includes almost no
required factual
content, and with
very significant
inaccuracies.
Incoherent or missing introduction
and conclusions.
More than 10% outside word count or presentation time.
Includes mainly
irrelevant factual
content.
Very incoherently structured
material.
Serious and extensive mistakes in spelling, grammar,
punctuation, paragraphing.
No identification of
relevant concepts,
theories and/or
principles.
No evidence of the selection,
categorisation, analysis or
evaluation of information or data.
Incoherent writing style OR an inaudible, poorly paced
and unengaging presentation.
No understanding of
factual and
conceptual material,
relative to this level.
No argument, entirely descriptive
or personal opinion, with no
reference to literature.
Very poor visual presentation, including font, spacing,
margins, headings, graphics, images and appendices.
Calculations are
inaccurate, with no
explanations.
Theory not related to practice. Very inaccurate or no use of academic conventions,
references and bibliography.
No independent
reading and
research,
appropriate to this
level.
Minimal application of numerical
and statistical methods and
techniques to defined problems,
with significant errors.
Very poor delivery of group work obligations, where
relevant.
No recommendations. No
awareness of ethical issues, where
relevant.
Minimal or no evaluation of own strengths and
weaknesses in relation to defined professional and
practical skills.
0 – 15% Not achieved
at this level
FAIL. NO
COMPENSATI
ON.
Does not include
required factual
content.
No introduction and conclusions. More than 10% outside word count or presentation time.
Module Code Module Title Spring 2017 Coursework Brief
GSM LONDON Page 12 of 13
Includes entirely
irrelevant factual
content.
Very incoherently structured
material.
Serious and extensive mistakes in spelling, grammar,
punctuation, paragraphing.
No identification of
relevant concepts,
theories and/or
principles.
No evidence of the selection,
categorisation, analysis or
evaluation of information or data.
Incoherent writing style OR an inaudible, poorly paced
and unengaging presentation.
No understanding of
factual and
conceptual material.
No argument, entirely personal
opinion, with no reference to
literature.
Exceptionally poor visual presentation, including font,
spacing, margins, headings, graphics, images and
appendices.
Calculations are
missing, with no
explanations.
Theory not related to practice. No use of academic conventions, references and
bibliography.
No independent
reading and
research,
appropriate to this
level.
No application of numerical and
statistical methods to defined
problems.
No delivery of group work obligations, for this level.
No recommendations. No
awareness of ethical issues, where
relevant.