Hi,
I am trying to find a solution and am hoping you clever guys can help me out.(first post so go easy
Problem:
I would like to adjust the sales prices for a range of products so we have sensible and structured prices. At the moment we have some bigger items that are cheaper than smaller items and a few other anomolies.
Ideally I would like to have the sales price increase in line with the size and also a reasonably consistent margin accross the products.
However I have to ensure that:
1. The total price paid by the customer will stay same so they will be in the same position.
2. The profit made is still the same.
I have uploaded an extract of this and am hoping some intelligient individual can demonstrate the best way of tackling this as Im struggling.
The expected result would be a revised sales price whilst complying with the above conditions.
The upload is merely a small extract.
Im reasonable on excel but no where near as good as you gurus
Bookmarks