Help with Management Accounting Decision and Control mock question
lj1994
Registered Posts: 2
Hi
Can anyone help me understand how to get the sales figure from question 6 in the Decision and Control Level 4 mock?
Inventory holding period is 45 days
Average inventory £225,000
Gross profit margin 20%
Selling costs 2% of sales
Admin cost 3.5% of sales
Net assets £1,837,000
They want to know what the sales, cost of sales, gross profit, selling costs, admin costs and net profit are.
I've worked out cost of sales as £1,825,000.
The answer shows sales as £2,281,250 but I can't work out how they got this figure.
Thanks in advance.
Can anyone help me understand how to get the sales figure from question 6 in the Decision and Control Level 4 mock?
Inventory holding period is 45 days
Average inventory £225,000
Gross profit margin 20%
Selling costs 2% of sales
Admin cost 3.5% of sales
Net assets £1,837,000
They want to know what the sales, cost of sales, gross profit, selling costs, admin costs and net profit are.
I've worked out cost of sales as £1,825,000.
The answer shows sales as £2,281,250 but I can't work out how they got this figure.
Thanks in advance.
0
Comments

Cost of Sales is worked off the inventory average holding number so you would be correct in your answer of £1,825,000
The calculation for the above figure is Inventory Value £225,000 / Average holding Period 45 x 365 Days in the year.
The question then says gross profit is 20% to calculate the Sales figure from cost of sales you would do the following
Calculated COS £1,825,000 / 80 x 100 which would then give you as the answer states £2,281,250. To double check this is correct if you then deduct COS £1,825,000 from the sales figure it will give you a gross profit figure of £456,250. If you divide this by your calculated sales figure of £2,281,250 and multiply it by 100 you will see you get back to 20% GPM0 
That's brilliant. Thank you so much for your help!0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 18.9K For AAT students
 234 NEW! Qualifications 2022
 133 General Qualifications 2022 discussion
 7 AAT Level 2 Certificate in Accounting
 31 AAT Level 3 Diploma in Accounting
 55 AAT Level 4 Diploma in Professional Accounting
 8.9K For accounting professionals
 23 coronavirus (Covid19)
 272 VAT
 91 Software
 272 Tax
 135 Bookkeeping
 7.3K General accounting discussion
 201 AAT member discussion (AATQB, MAAT, FMAAT and AAT Licensed Accountants and Bookkeepers)
 3.8K For everyone
 39 AAT news and announcements
 352 Feedback for AAT
 2.8K Chat and offtopic discussion
 586 Job postings
 17 Who can benefit from AAT?
 36 Where can AAT take me?
 44 Getting started with AAT
 26 Finding an AAT training provider
 47 Distance learning and other ways to study AAT
 25 Apprenticeships
 65 AAT membership