professional ethics practice paper
PRACTICE ASSESSMENT
Spreadsheets software
AAT Level 3 Diploma in Accounting
Assessment book
Candidate
This practice assessment is for familiarisation purposes only and must not be used in place of a ‘live’ assessment.
When you feel prepared to sit the live assessment please contact your Training Provider who can schedule a live assessment for you.
Practice assessment
This case study is in two parts.
You have 2 hours and 30 minutes (plus 15 minutes reading time) to complete the tasks and a high degree of accuracy is required.
You are required to download or open an Excel spreadsheet called Assessment data that contains data you require for this assessment.
You MUST save your work at regular intervals during this assessment to prevent you losing work.
All spreadsheets should be titled and contain a footer with your name, date and AAT membership number.
JA Muddlestone is a wholesaler of surplus stocks, which they resell to small traders, either via the sales team or over the internet on EBid.
You are employed as an accounts clerk in JA Muddlestone. The computer system has crashed and the back up will not load due to a technical problem.
The accountant has asked you to collate some figures into a spreadsheet to give an overview of the activity for the last year.
Over the past year the monthly results have been as follows:
Sales revenue
January £42,980
February £55,980
March £92,600
April £118,206
May £117,420
June £120,115
Expenses
January £15,390
February £23,602
March £28,750
April £35,060
May £37,420
June £38,790
Cost of sales
January £14,620
February £17,940
March £21,405
April £29,800
May £30,650
June £34,020
Part 1
Task 1.1
Prepare a spreadsheet, showing all the figures displayed on page 2. Formulate cells for January to show gross profit and profit for the period then copy these formulas into the remaining cells. Gross profit is sales
Spreadsheets software
AAT Level 3 Diploma in Accounting
Assessment book
Candidate
This practice assessment is for familiarisation purposes only and must not be used in place of a ‘live’ assessment.
When you feel prepared to sit the live assessment please contact your Training Provider who can schedule a live assessment for you.
Practice assessment
This case study is in two parts.
You have 2 hours and 30 minutes (plus 15 minutes reading time) to complete the tasks and a high degree of accuracy is required.
You are required to download or open an Excel spreadsheet called Assessment data that contains data you require for this assessment.
You MUST save your work at regular intervals during this assessment to prevent you losing work.
All spreadsheets should be titled and contain a footer with your name, date and AAT membership number.
JA Muddlestone is a wholesaler of surplus stocks, which they resell to small traders, either via the sales team or over the internet on EBid.
You are employed as an accounts clerk in JA Muddlestone. The computer system has crashed and the back up will not load due to a technical problem.
The accountant has asked you to collate some figures into a spreadsheet to give an overview of the activity for the last year.
Over the past year the monthly results have been as follows:
Sales revenue
January £42,980
February £55,980
March £92,600
April £118,206
May £117,420
June £120,115
Expenses
January £15,390
February £23,602
March £28,750
April £35,060
May £37,420
June £38,790
Cost of sales
January £14,620
February £17,940
March £21,405
April £29,800
May £30,650
June £34,020
Part 1
Task 1.1
Prepare a spreadsheet, showing all the figures displayed on page 2. Formulate cells for January to show gross profit and profit for the period then copy these formulas into the remaining cells. Gross profit is sales