Maths question

[Nick]

 

Growler is now, and as usual, confuzzled 

[Snoopy]

In theory ?15 represents the VAT@15% so divide it by 15 and multiply by 100.

?15 divided by 15=?1

?1x100 = ?100.

Total bill should then have been ?115.

Let's try it with ?153.75 being the VAT collected at 15%

?153.75 divided by 15 = ?10.25

?10.25 x 100 = ?1025.00

Total bill should then have been ?1178.75

Quite so Snoopy...

A spreadsheet with the pre VAt amount, VAT, add totals would allow you to automatically add them all up and cross check...

As Snoopy points out any other way simply won't work and the VAT man will be down on you like several tonnes of stolen hub caps...

 I do the accounts for a number of charities locally and struggle to get Excel to work. No matter how many times I am shown for some reason I just can't remember it. So I do it with pen and paper. Looks like a spread sheet but in handwriting rather than off the PC. Takes forever.

[Barman]

In theory ?15 represents the VAT@15% so divide it by 15 and multiply by 100.

?15 divided by 15=?1

?1x100 = ?100.

Total bill should then have been ?115.

Let's try it with ?153.75 being the VAT collected at 15%

?153.75 divided by 15 = ?10.25

?10.25 x 100 = ?1025.00

Total bill should then have been ?1178.75

Quite so Snoopy...

A spreadsheet with the pre VAt amount, VAT, add totals would allow you to automatically add them all up and cross check...

As Snoopy points out any other way simply won't work and the VAT man will be down on you like several tonnes of stolen hub caps...

 I do the accounts for a number of charities locally and struggle to get Excel to work. No matter how many times I am shown for some reason I just can't remember it. So I do it with pen and paper. Looks like a spread sheet but in handwriting rather than off the PC. Takes forever.

I am an Excel guru like... 

[Snoopy]

You mean you can't do maths but you know how to make the machine do it?

[Barman]

You mean you can't do maths but you know how to make the machine do it?

Did I say that...? 

[Snoopy]

You mean you can't do maths but you know how to make the machine do it?

Did I say that...? 

Nearly 

[Pastis]

Ok, here we go again ... the fractions, or formulae as you call them are:

for 15% ... 3/23 i.e. Multiply the invoice total by 3 then divide by 23. The result will be the amount of VAT; subtract that from the invoice total and you'll have the original invoice figure.

for 17.5% ... 7/47 etc

Simples!

[Nick]

 

[Snoopy]

Ok, here we go again ... the fractions, or formulae as you call them are:

for 15% ... 3/23 i.e. Multiply the invoice total by 3 then divide by 23. The result will be the amount of VAT; subtract that from the invoice total and you'll have the original invoice figure.

for 17.5% ... 7/47 etc

Simples!

But he has the VAT totals NOT the invoice totals 


He knows how much VAT he has charged but he has not calculated the total invoices nor the pre VAT figures. He is trying to arrive at those by working purely from the VAT total.

He has added up the VAT shown on all his invoices and is looking to avoid doing the same to the totals by finding a quick calculation to extrapolate the figures purely from the VAT

As Christopher Robin would say "You are a silly old bear!"

[Pastis]

I give up 

[Barman]

You mean you can't do maths but you know how to make the machine do it?

Did I say that...? 

Nearly 

In your mind perhaps... 

[Snoopy]

You mean you can't do maths but you know how to make the machine do it?

Did I say that...? 

Nearly 

In your mind perhaps... 

I have a daughter who managed a B in GCSE Maths but still doesn't know any times tables beyond 4. Baffled me until she revealed that most of the work is done using a 'pooter and/or a calculator.

So she can't do the maths but knows a machine that can. 

As I pointed out that will do her no good when she has ?20 in her purse and needs to work out what she can buy with it. This argument is, she tell me, flawed in that she would simply put her purchases on a credit card.

Frankly I can't wait to see how she copes when she leaves home 

[Barman]

You mean you can't do maths but you know how to make the machine do it?

Did I say that...? 

Nearly 

In your mind perhaps... 

I have a daughter who managed a B in GCSE Maths but still doesn't know any times tables beyond 4. Baffled me until she revealed that most of the work is done using a 'pooter and/or a calculator.

So she can't do the maths but knows a machine that can. 

As I pointed out that will do her no good when she has ?20 in her purse and needs to work out what she can buy with it. This argument is, she tell me, flawed in that she would simply put her purchases on a credit card.

Frankly I can't wait to see how she copes when she leaves home 

Rubbish in/rubbish out tho...

You can't build a working spreadsheet unless you know which formula to put in each box... A thorough understanding of BOMDAS helps too... 

[Snoopy]

I'll stick to my trusty Evrite Accountancy Pads and a sharp pencil or two. I don't trust 'pooters that much.

[The Moan Ranger]

You mean you can't do maths but you know how to make the machine do it?

Did I say that...? 

Nearly 

In your mind perhaps... 

I have a daughter who managed a B in GCSE Maths but still doesn't know any times tables beyond 4. Baffled me until she revealed that most of the work is done using a 'pooter and/or a calculator.

So she can't do the maths but knows a machine that can. 

As I pointed out that will do her no good when she has ?20 in her purse and needs to work out what she can buy with it. This argument is, she tell me, flawed in that she would simply put her purchases on a credit card.

Frankly I can't wait to see how she copes when she leaves home 

Rubbish in/rubbish out tho...

You can't build a working spreadsheet unless you know which formula to put in each box... A thorough understanding of BOMDAS helps too... 

Do you mean BODMAS?