The Wholesale Forums

[redfanatic]

Great Program! Nice One!

[Jezz]

Thanks for all your interest and advice

I've just added an update version, I'm still calling it a demo till someone can confirm that the results are correct.
I've changed the code to this:

                // Calculate Duty on goods
                DutyPayable = InitialPrice/100 * DutyRate;
                // Add this to the inital price
                InitialPrice += DutyPayable;
                // Add Shipping and Insurance
                InitialPrice += Shipping + Insurance;
                // Calculate VAT on the lot
                VatPayable =  InitialPrice/100 * VatRate;
                // Calculate the total
                TotalPrice = InitialPrice + VatPayable;

Does this look right?

Originally Posted by D M

P.S
This is what spreadsheets are for!

lol.. this is a pretty good point
I've never been a real fan of spreadsheets myself though.
Anyhow it gave me something to do

[D M]

DutyPayable = ( C.I.F ) / 100 * DutyRate

For VAT there's also something called "VAT value adjustment", but I wouldn't worry about that.

[D M]

Here's a spreadsheet I use to get a rough cost before asking for a quote from supplier:



If someone has to pay VAT + Duty in the UK it means it comes from outside the EU. Chances are they are not paying in pounds sterling (£), which makes things even more complicated.

You won't know the exact exchange rate for purchasing the goods until you make the transfer and then customs use a different (monthly) exchange rate !

[Jezz]

Thankyou D M

Of course, higher tax = a better tax system!

I've just changed the code and uploaded a new version again.

                // C = InitialPrice, I = Insurance, F = Shipping
                DutyPayable = (InitialPrice + Insurance + Shipping)/100 * DutyRate;
                // Apply Duty
                InitialPrice += DutyPayable;
                // Calculate VAT 
                VatPayable =  InitialPrice/100 * VatRate;
                // Apply VAT
                TotalPrice = InitialPrice + VatPayable;

Thanks heaps for sharing, I really appreciate it
I'll take a look at this tomorrow it's late here.

Cheers,
Jeremy

[cdtronix]

I like it mate, it looks good, how far away is a full version ?

[Jezz]

Hi cdtronix,

I've kept it as a demo because I'm not a 100% sure that's it's producing the correct results.
If it is then it's not a demo anymore
I think the code above is fairly easy to understand, so hopefully someone can confirm that it's working properly.

If it is... and no one can crash it, I'll call it a full version and remove the warning.
I am thinking of more features to add, but not tonight.
My wife has banned me from using my PC

Cheers,

Jeremy

[cdtronix]

Originally Posted by Jezz

but not tonight.
My wife has banned me from using my PC

LOL know that feeling !

[DSC]

Ok, so this isn't going to work to well perhaps I should have just explained it in words.


// Calculate Duty on goods
DutyPayable = InitialPrice += Shipping + Insurance/100 * DutyRate;
// Add this to the InitialPrice += Shipping + Insurance
InitialPrice += Shipping + Insurance +=DutyPayable;
// Calculate VAT on the lot
VatPayable = InitialPrice += Shipping + Insurance + DutyPayable/100 * VatRate;
// Calculate the total

First of all disregard VAT and just work out your duty on C I F total, then add Duty C I F together and work out your VAT add them all up and you have your total cost.

[Jezz]

Thanks DSC ,

I should have quoted the latest code again it's

// C = InitialPrice, I = Insurance, F = Shipping
DutyPayable = (InitialPrice + Insurance + Shipping)/100 * DutyRate;
// Apply Duty
InitialPrice += DutyPayable;
// Calculate VAT 
VatPayable =  InitialPrice/100 * VatRate;
// Apply VAT
TotalPrice = InitialPrice + VatPayable;

This is what's in the application at the moment, So I think this must be correct

Edit: Actually studying what you have written more closely, maybe it isn't
It's a job for the morning anyhow...