Financial performance : question 2.3 d) CBT 4
lifeisstrange
Registered Posts: 27 Epic contributor 🐘
Please could you help me with question 2.3 d) CBT 4 on the AAT website?
Here is the question:
The price at which the product will be sold is £50
The company expects to sell 30000 units at a price of £50
The variable material cost is £20 per unit
The labour requirement is 20 minutes at a cost of £18 per hour
The required profit margin is 30%
d) The expected demand, variable costs and target profit margin (30%) all remain the same but the total fixed production costs are now expected to be £200000
The margin of safety in order to achieve the target profit margin (30%) is %
I have seen the following topic regarding the question but I really don’t understand:
http://forums.aat.org.uk/showthread.php?36454HELPCBT4FNPF2.3%28d%29&highlight=fnpf
Thank you
Here is the question:
The price at which the product will be sold is £50
The company expects to sell 30000 units at a price of £50
The variable material cost is £20 per unit
The labour requirement is 20 minutes at a cost of £18 per hour
The required profit margin is 30%
d) The expected demand, variable costs and target profit margin (30%) all remain the same but the total fixed production costs are now expected to be £200000
The margin of safety in order to achieve the target profit margin (30%) is %
I have seen the following topic regarding the question but I really don’t understand:
http://forums.aat.org.uk/showthread.php?36454HELPCBT4FNPF2.3%28d%29&highlight=fnpf
Thank you
0
Comments

You need to work out the break even amounts for both scenarios.
With fixed costs at £270,000 you need to make 11250 sales just to break even (270000/24)  (24 being the contribution of each unit). So you now know that in order to break even (i.e. just cover the costs, not make any kind of profit), you need to sell 11250 units.
With the fixed costs reducing to £200,000, you now only need to sell 8333.33 units (so 8334  round up not down as 8333 would not cover the costs but 8334 would) (200000/24).
The margin of safety is therefore the difference of these two figures divided by the original break even figure, so 2916/11250 x 100 = 25.92% (26%)0 
Thank you so much Nps: you are the best.:001_smile:0

Thank you too...you've saved me a massive headache! It had me beaten!0

URGENT can someone help me on this question please:
a) Sales Per unit: £40.00
Profit Margin: £18.00
Total Cost: £22.00
Fixed cost per unit: £12.00
Labour cost per unit: £6.00
Maximum material cost per unit: £4.00
Target cost per kg: £20.00
b) The trade price quoted on the supplier's price list is £25 per kg. The purchasing manager has negotiated a discount of 15%. The discount should be rejected because the £25 reduces to £21.25 which is above the target cost.
C) The minimum percentage discount needed to achive the target cost is 20% ( How do you figure this bit out Someone please help me ASAP)0 
Salih
You haven't specified what help you want, I have tried to help by annotating your quote
a) Sales Per unit: £40.00 specified in the question
Profit Margin: £18.00 specified in the question
Total Cost: £22.00 a subtraction to show the total cost needed to achieve the required profit at the specified selling price
Fixed cost per unit: £12.00 identifiable from the question
Labour cost per unit: £6.00 identifiable from the question
Maximum material cost per unit: £4.00 a subtraction to show the total material cost per unit needed to achieve the required profit at the specified selling price and all the other costs
Target cost per kg: £20.00 a divide sum to show the total material cost per kg after recognising £4 per 200 grammes x 5 (5 lots of 200 g in 1 kg)
b) The trade price quoted on the supplier's price list is £25 per kg. The purchasing manager has negotiated a discount of 15%. The discount should be rejected because the £25 reduces to £21.25 which is above the target cost.
C) The minimum percentage discount needed to achive the target cost is 20% ( How do you figure this bit out Someone please help me ASAP)
To get from the quote of £25 to the target cost of £20 per kg the price must fall by £5/kg. £5/£25 is 20%Sandy
sandy@sandyhood.com
www.sandyhood.com0 
Hi Nps
I am stuck on this question as well. I got to the point of 2916 units but I was dividing it by 30000 units (original budgeted sales figure) but this was giving me the wrong answer.
The formula for % Margin of safety is
MOS (units)/budgeted sales (units).
I kind of understand where the 11250 came from but can't figure out why do we divide by this figure instead of 30000?0 
Also I thought we need to include the required profit of 450,000. So I got 200,000 + 450,000/24 = 27084. And then 30,00027084=2916 That's how I got to this point and then wrong on the final bit.0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 12.5K For AAT students
 301 NEW! Qualifications 2022
 154 General Qualifications 2022 discussion
 11 AAT Level 2 Certificate in Accounting
 55 AAT Level 3 Diploma in Accounting
 79 AAT Level 4 Diploma in Professional Accounting
 8.8K For accounting professionals
 23 coronavirus (Covid19)
 272 VAT
 92 Software
 272 Tax
 135 Bookkeeping
 7.2K General accounting discussion
 198 AAT member discussion
 3.8K For everyone
 38 AAT news and announcements
 345 Feedback for AAT
 2.8K Chat and offtopic discussion
 581 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