Sorting a cell amount into specific labelled amount columns

Hi guys,

I'm a relative newbie to excel, i.e. can do formulas, but not much to do with VBA/macros etc so there may be a method to do it that way but I may need walking through.

A brief overview of what i want this excel sheet to do. I'm doing a project on merchandise suppliers (we have 6), and they have supplied us with prices for various bulk purchases (i.e a pallet of 100, 500, 2000 etc as examples). We can only buy from the bulk prices and not individually so if i require 2350 items, ill need 1 x 2000 and 4 x 100 which will give me 2400 as I cannot have less than what i require.

I want to sort various amounts found in cell A6-A11, into columns labelled from B5-G5 that carry various values.
For example if I have an amount of 2000, and I have columns in order from left to right of 100, 500, 1000 and 1500.
I want it to attempt to sort itself from the highest value to the lowest value. So in that case it will leave a mark or the number "1" to represent the amount of multiples in the column as 1 x 1500, and 1 x 500.

Once I have that designed I need it to deal with slightly more difficult numbers. For example if the number in cell A6 was 2250, and I have columns in order from left to right of 100, 500, 1000 and 1500 as before.

It would sort from the highest amount to lowest in 1 x 1500, 1 x 500, and 2 x 100, but the remainder of 50 would not be allocated.
In this case I need the remainder to be rounded up so that it is counted as another 1 x 100, giving me a total of 2300, from my original 2250 value entered.

Please see my example I have put together. It is not capable however to run the remainders into the COUNT section I have set up.
Any help is appreciated.