Management Accounting Decision and Control Sample assessment 1 task 1.7
Loopster
Registered Posts: 24
Hi,
I am a bit stuck on task 1.7 and would like a bit of help please?
A business with receivables of £120,000 and receivables collection days of 30, operates on a gross profit margin of 25% and a net profit margin of 15%. Fixed production overheads 40% of the total cost of sales.
c) Complete the profit and loss account below using the following performance indicators. Enter all figures as positive numbers - do not enter negative figures.
£
Sales
Variable Production Costs
Fixed Production Costs
Cost of Sales
Gross Profit
Non-Production costs
Net Profit
I don't really understand what to do without further information. Any help will be greatly appreciated.
I am a bit stuck on task 1.7 and would like a bit of help please?
A business with receivables of £120,000 and receivables collection days of 30, operates on a gross profit margin of 25% and a net profit margin of 15%. Fixed production overheads 40% of the total cost of sales.
c) Complete the profit and loss account below using the following performance indicators. Enter all figures as positive numbers - do not enter negative figures.
£
Sales
Variable Production Costs
Fixed Production Costs
Cost of Sales
Gross Profit
Non-Production costs
Net Profit
I don't really understand what to do without further information. Any help will be greatly appreciated.
0
Comments
-
SALES
Receivable collection days (30)= Receivables x 365 (£43,800,000) / Sales
therefore Sales = £1460,000
0 -
(100%) Sales
less VC
less FC
(25%) = GP (GP margin is 25%)
FC = £1460,000 x 40% = £584,000
GP= £1460,000 x 25% = £365,000
VC = £1460,000 - £365,000 - £584,000 = £511,000
COS = VC+FC = £511,000 + £584,000 = £1,095,0000 -
(100%) Sales
less COS
= GP
less non-production costs
(15%) = NP (NP margin is 15%)
NP = £1460,000 x 15% = £219,000
Non-production costs = £365,000 - £219,000 = £146,000
I don't have access to the answers so hopefully they are correct.
1 -
Hi N4T,
Thank you so much for the reply! Apologies, I should have included the answers.
The answers are:
Sales: £1,460,000
Variable Production Cost: £657,000
Fixed Production Cost: £438,000
Cost of Sales: £1,095,000
Gross Profit: £365,000
Non-Production Costs: £146,000
Net Profit: £219,000
You pretty much nailed it, thank you for the workings too, makes complete sense.0 -
Oh I see where I went wrong. I was reading FC to be 40% of sales and not COS. I hope you can see how each part is worked out. Let me know if any part is unclear.0
-
Hi N4T. I can indeed, yes, perfect explanation. I was just banging my head against the wall, I was fine with the rest of the assessment.
Thanks so much! I'll be doing the other practice assessment later so will probably have a couple more queries I should have thought. Thanks again!0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 318 NEW! Qualifications 2022
- 161 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 87 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership