Prepare Final Accnts for Sole Traders/Partnerships HELP
AngelDust
Registered Posts: 30
Hi, I'm stuck on the following question, can someone please shed some light?
Miranda includes a profit margin of 40% in the price of each item sold. She has suffered a fire at the year end which destroyed stock.
It asks what the value of closing stock before the fire is?
The amount to be claimed from the insurance company?
Following info available:
Sales to customers for the year amounted to £360,000
Purchases of goods for resale totalled £218,000
Opening inventory was £12,000
Remaining stock that survived the fire is valued at £3000
Can someone clarify how to calculate above two questions? I've worked out COGS is £227,000.
Thanks in advance
Miranda includes a profit margin of 40% in the price of each item sold. She has suffered a fire at the year end which destroyed stock.
It asks what the value of closing stock before the fire is?
The amount to be claimed from the insurance company?
Following info available:
Sales to customers for the year amounted to £360,000
Purchases of goods for resale totalled £218,000
Opening inventory was £12,000
Remaining stock that survived the fire is valued at £3000
Can someone clarify how to calculate above two questions? I've worked out COGS is £227,000.
Thanks in advance
0
Comments
-
Hi
1) 'Margin' is based on sales. Hence, GP for the year would be £144000 (40% of Sales). The COGS would, therefore, be £216000 (Sales minus GP).
2) Closing stock before fire should, therefore, be £14000 (Op Inv + Purchases - COGS).
3) Since the remaining stock was £3000, stock destroyed in fire should be: £11000
Trust, this helps.
Thanks0 -
1) Calculate the GP
sales £360000*40% = £144000
2) Cost of good sold is £216000 (ie £360000-£144000)
3) Closing stock before fire:
opening inventory £12000+ purchases £218000-£3000(remaining stock) =£227000
So, closing stock before the fire is £227000-£216000=£14000
4) Amount to be claimed from insurance company will be : Closing inventory before fire LESS remaing inventory after fire- £14000-£3000=£11000
NOTE:
£227000 is the COGS AFTER the fire because you only had £3000 stock left which is not the actual closing inventory AND
£216000 is the ACTUAL COGS because you've got your sales figure and margin - refer to calculation 1 & 2 above.
Hope this help.0 -
My blog post on Margins and Mark-ups may help with this:
http://aatstudentadvice.blogspot.co.uk/2015_03_01_archive.html
Using a Margin Model:
Sales 100%
Cost of sales 60%
Profit 40%
Profit on the stated sales should have been £360,000 x 40% margin = £144,000 which means Cost of Goods Sold would be £216,000.
However, if we calculate the cost of goods sold based on Opening inventory + Purchases - Closing inventory we see that:
£12,000 + £218,000 - £3,000 = £227,000
Obviously we have a difference here - the difference being £11,000 (the value of the inventory destroyed by the fire).
You can check this by recalculating the Cost of goods sold:
Opening + Purchases - (Closing ivnentory + Destroyed inventory)
£12,000 + £218,000 - (£3,000 + £11,000) = £216,000 (the figure our Margin Model says we should have for our cost of goods sold).
It's always good to work your answer back to check that you've not made an error.0 -
Thank you for your replies!0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 319 NEW! Qualifications 2022
- 157 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 92 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 274 Tax
- 136 Bookkeeping
- 7.2K General accounting discussion
- 201 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