Calculate a purchase figure for the year?
Cat37
Registered Posts: 6
Preparing statements for sole traders & paternerships. Please could someone advise how to come to the following answer from given information.
Sales for year £95,200 all at 60% mark up. Opening inventory £22,560 and closing inventory £18,420. Calculate the purchased figure for the year? The answer is £55,360 but how was that calculated?
Thank you in advance.
Sales for year £95,200 all at 60% mark up. Opening inventory £22,560 and closing inventory £18,420. Calculate the purchased figure for the year? The answer is £55,360 but how was that calculated?
Thank you in advance.
0
Comments
-
Sales: 95,200 x 100/160 = 59,500 cost of goods sold (60% mark up means the sales figure is 160% of the purchase cost).
However, closing stock is less than opening stock, meaning you have purchased less stock than you have sold. 22,560 - 18,420 = 4,140.
59,500 - 4,140 = 55,3601 -
Thank you. Please could you guide me with this one too?
Sales for year £42,000 opening inventory £4700 and purchase were £30,000. Gross profit margin 33 1/3%. Calculate the closing inventory?0 -
Cat, you should be able to work this one through yourself from the example I've given, it's just a different blank to fill in.
The only other thing you have to be aware of is that this one uses a margin rather than a mark-up.
A mark-up is calculated from the cost of the goods: a £1 item sold at a mark-up of 50% is sold at 1 + 1x50% = £1.50.
A margin is calculated from the sale price of the goods: so an item sold at £1.50 with a 50% profit margin means the margin = £1.50 x 50% = £0.75, and therefore the cost is £1.50 - £0.75 = £0.75.
The first item has a 33% margin (50p profit from £1.50 sale). The second item has a 100% mark-up (75p cost plus 75p mark-up to get to £1.50 sale).
Does that make sense?
You can now work out the cost of the goods sold by taking the sales and subtracting the 33% margin. Everything else you should be able to slot into place to get to the answer. If you need further help just ask.1 -
Thanks very much for your time & assistance0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 328 NEW! Qualifications 2022
- 161 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 57 AAT Level 3 Diploma in Accounting
- 95 AAT Level 4 Diploma in Professional Accounting
- 8.9K For accounting professionals
- 23 coronavirus (Covid-19)
- 273 VAT
- 92 Software
- 275 Tax
- 138 Bookkeeping
- 7.2K General accounting discussion
- 203 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 584 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