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 

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
 18.9K For AAT students
 251 NEW! Qualifications 2022
 139 General Qualifications 2022 discussion
 8 AAT Level 2 Certificate in Accounting
 35 AAT Level 3 Diploma in Accounting
 59 AAT Level 4 Diploma in Professional Accounting
 8.9K For accounting professionals
 23 coronavirus (Covid19)
 274 VAT
 92 Software
 274 Tax
 137 Bookkeeping
 7.3K General accounting discussion
 193 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
 589 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
 48 Distance learning and other ways to study AAT
 25 Apprenticeships
 65 AAT membership