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
NonProduction 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
NonProduction 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 nonproduction costs
(15%) = NP (NP margin is 15%)
NP = £1460,000 x 15% = £219,000
Nonproduction 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
NonProduction 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 (Covid19)
 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 offtopic 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