The Book-keepers Forum (BKF)

Post Info TOPIC: The Friday afternoon quiz (2010/04/16)


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
The Friday afternoon quiz (2010/04/16)
Permalink Closed


Hi folks,

bit busy today but a promise is a promise so how about getting your teeth into this one which is another play on markups and margins but with a twist.

A business sells goods earning a constant 25% markup.

Sales in the period amount to £500,000

Opening Stock was £100,000

Closing Stock was £20,000.

Purchases were £450,000.

The owner suspects theft.

Calculate the amount of the stock losses.

Have fun people!

-- Edited by Shamus on Friday 16th of April 2010 11:44:25 AM

__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Expert

Status: Offline
Posts: 1963
Date:
Permalink Closed

£130,000

__________________
Rob
www.accounts-solutions.com


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Hi Rob,

Sorry, that one's actually a long way out.

__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Expert

Status: Offline
Posts: 1707
Date:
Permalink Closed

£162,500

__________________

Never buy black socks from a normal shop. They shaft you every time.

http://www.smbps.co.uk/



Expert

Status: Offline
Posts: 1963
Date:
Permalink Closed

I must be making a fundamental friday error then! I worked on the basis that it took £400,000 stock to generate £500,000 sales with a mark up of 25%. There has been £530,000 of stock used (100k+450k-20k), and the difference is 130k.

I'll have another look!!

__________________
Rob
www.accounts-solutions.com


Expert

Status: Offline
Posts: 1963
Date:
Permalink Closed

Hi Peasie, your figure is my figure plus the mark up, so we are along the same lines!

__________________
Rob
www.accounts-solutions.com


Expert

Status: Offline
Posts: 1707
Date:
Permalink Closed

I'm waiting to go for a shower but want to know the answer first.

__________________

Never buy black socks from a normal shop. They shaft you every time.

http://www.smbps.co.uk/



Expert

Status: Offline
Posts: 1963
Date:
Permalink Closed

I'm off to the bank before clients realise I don't know what I'm doing and demand their money back!!

__________________
Rob
www.accounts-solutions.com


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Hi Rob,

Sorry, I've mistyped the question. you were right Rob!

I thought that I'd typed £10,000 opening stock which made the answer £40,000... Doh

For anyone else having a problem with this the full answer is :


(1) Calculate what cost of sales should have been.
25% markup = 20% margin
So, gross profit = 500,000 * 20% = £100,000
Therefore, cost of sales must have been £400,000 (500k -  100k)

(2) Calculate what cost of sales actually was
Opening stock was £100,000 (!!! Ooops)
Closing stock was £20,000

(3) Calculate the variance
Therefore cost of sales should have been 100k + 450k 20k = £530,000
So, losses = 530,000 -  400,000 = 130,000

So sorry Rob, you were completely correct and I got the question wrong!!!


-- Edited by Shamus on Friday 16th of April 2010 12:23:54 PM

__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Senior Member

Status: Offline
Posts: 270
Date:
Permalink Closed

I made it the same as Rob, £130,000



__________________

Ruth (AFA, ACIB)

Shore Accounting
www.shoreaccounting.co.uk



Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Ruth and Rob both get gold stars and I get to sit up the corner with a dunces cap on for both mistyping it and being number blind when I reviewed what I'd written!

__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Expert

Status: Offline
Posts: 1707
Date:
Permalink Closed

Shamus wrote:

Ruth and Rob both get gold stars and I get to sit up the corner with a dunces cap on for both mistyping it and being number blind when I reviewed what I'd written!



I'll be sat in the other corner wearing my dunces cap but reading bookkeeping books to make sure I don't get it wrong again.

I think you learn more from mistakes. I've seen people on here asking for answers to assigmnents and thought it was pointless - I tend to put in what I think is correct and then when it comes back the actual correct answer it sticks in my brain more.

 



__________________

Never buy black socks from a normal shop. They shaft you every time.

http://www.smbps.co.uk/



Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Hi Peasie,

just have a go at the next one and I'm sure that you'll redeem yourself.

It's closely linked to this question but again adds another aspect to it.

And besides that I've actually typed the correct figures in for the answer that I've got on the other one!

__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Expert

Status: Offline
Posts: 1963
Date:
Permalink Closed

Back from the bank and a bit relieved! I nearly asked if the opening/closing stock figures were right! I'll sit out the next question (i'll have a go and post my answer if no-one sticks their neck out!)

__________________
Rob
www.accounts-solutions.com


Expert

Status: Offline
Posts: 1707
Date:
Permalink Closed

Shamus wrote:

Hi Peasie,

just have a go at the next one and I'm sure that you'll redeem yourself.



I'll try it later on tonight - need to out and buy milk now.
So far in 2010 I have spent £37.59 buying 94.816 litres of milk. This is worrying that I know this.

 



__________________

Never buy black socks from a normal shop. They shaft you every time.

http://www.smbps.co.uk/



Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Hi Peasie,

Without any further exams I'm pretty sure that we all agree that you've passed the final test as to whether you are ready to be an accountant!

Bet that you've also calculated the stock days ratio and economic order quantity on that haven't you! lol

__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Expert

Status: Offline
Posts: 1707
Date:
Permalink Closed

I only calculate how much I was buying (cost and litres) per day. I have been buying less now even when it is cheaper. I was buying 1.5 litres per day costing me £1.02 now I'm buying under 1 litre per day and it is costing me 38p a day.



__________________

Never buy black socks from a normal shop. They shaft you every time.

http://www.smbps.co.uk/

Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About