Hi all,
I already have a scroll bar that increases profit value of all my products sold uniformly on a quoting spreadsheet. However I require some products to have a higher profit applied as they are more expensive to produce. What happens at the moment is my SS works out the base cost, uses a vlookup to see what the profit should be based on selling 1 to 30 items (more profit for 1 and then profit reduces & plateaus for subsequent units sold). I then take an average of the profit and apply that to each item on the quote so that customers don't just choose the cheapest items. This average profit is in U102.
Scroll bar (from 75% to 250%) then changes U106 from say, 1.00 to 1.45 so i can multiply the profit amounts in the vlookup accordingly. New avg profit amounts will reflect in U102.
If I have a quote with both cheap units and expensive units and I want to just select the expensive units to increase the profit on, how might I go about it?
I already have a scroll bar that increases profit value of all my products sold uniformly on a quoting spreadsheet. However I require some products to have a higher profit applied as they are more expensive to produce. What happens at the moment is my SS works out the base cost, uses a vlookup to see what the profit should be based on selling 1 to 30 items (more profit for 1 and then profit reduces & plateaus for subsequent units sold). I then take an average of the profit and apply that to each item on the quote so that customers don't just choose the cheapest items. This average profit is in U102.
Scroll bar (from 75% to 250%) then changes U106 from say, 1.00 to 1.45 so i can multiply the profit amounts in the vlookup accordingly. New avg profit amounts will reflect in U102.
If I have a quote with both cheap units and expensive units and I want to just select the expensive units to increase the profit on, how might I go about it?
Last edited:
