Sage Assessment

This is an individual assignment and 15% of the unit mark and covers learning outcomes 1 and 4 for Toolbox:

1) Apply the use of relevant IT skills required in the accounting occupations

4) Recognise key employability qualities, such as written and oral communication, team-working and problem-solving skills

Submission Date and Hand in Requirements:

Please submit your Sage pdf reports and word document via Moodle using the CW3-Sage dropbox on the Assessments tab.

Please enter your student ID number on all pieces of work submitted Reminders:

Do not include your name on your work – your Student Number (in the footer) is all that is needed.
Keep it simple – no artwork / uni logos, please.
Please use a sans serif font ideally Arial, 12 point.
Submit your work as a word document and the Sage reports as PDF files.
File name: the name MUST be your student This may seem like a small point, but it’s vital for the course administrator and the marker.

Word Count:

The word count should not exceed 1000 words. Words that exceed the permitted word count will not be read beyond the stated word count. A falsely stated

word-count is an assessment offence.

Case Study – 30 marks

Company Profile:

Carly Simon & Cass Elliot were senior managers at one of London’s top marketing consultancies, and in May 2021 they launched Blue Sky Experiential Marketing Ltd.

The company sees themselves as some of the brightest minds in the world of experiential marketing and believe that there is a gap in the market for a genuine high quality customer experience. Most of their customers are producers of food or beverages and Blue Sky attend events or gatherings to give out samples directly to engage consumers and encourage them to participate in the brand experience.

In plain language, this means that they set up stalls at festivals, train stations, race meetings, in fact anywhere there are likely to be large crowds and get consumers to try

their customer’s products. An example is they recently set up a stall at the British Grand Prix at Silverstone, they recruited 10 agents & gave out samples of the popular Energy drink Red-Pig.

Required:

Carly and Cass expect their recent investment in Sage Business Cloud to enable them to manage their business more effectively. They want an accountant – you – to design a monthly performance package for review every month, using the information entered onto Sage and the reports produced from Sage. They expect actions, insight and recommendations to improve the quality of Sage output which they can use to improve business performance.

Initially they require information on how the company has performed for the period from 1^st May 2021 to 31^st July 2021.

TASK 1 (8 marks) – 8 individual PDF files

Sage Reports to be uploaded as PDF files:

Trial balance “As of: 31 July 2021”

Profit or Loss Account for July 2021

Profit or Loss Account for the first quarter of trading – May to July 2021

Balance Sheet at: 31^st July 2021

Aged Debtors “As of: 31 July 2021”

Aged Creditors “As of: 31 July 2021”

Sales Day Book after session 1 31 July 2021

Purchases Day Book after session 2 31 July 2021

(one mark for each correct report, total 8 marks)

Create a Report in one document, for the following 3 Tasks: Task 2 (12 marks total)

Create a Table of Key Performance Indicators for the owners to manage the business

Using the Sage reports, compute the following KPIs and present them in an easy to understand format for ongoing use and future enhancement.

Gross Profit Margin – July month and Quarter 1
Net Profit Margin – July month and Quarter 1

● Current ratio

Return on Capital Employed

● Debtor Days (Trade receivables Days)

(one mark for each correct KPI, max of 5 marks for presentation / format / communication, total 12 marks)

Task 3 (4 marks total)

Make 2 recommendations for how to use more functionality of Sage Business Cloud to make it deliver more valuable insights or productivity gains for Carly and Cass.

(Max 2 marks for each recommendation, total 4 marks)

Task 4 (6 marks total)

Make 3 recommendations to improve the bank balance within the next month.

(Max 2 marks for each recommendation, total 6 marks)

Total Marks available 30, which will be weighted to be 15% of the Toolbox unit mark.