SaajidHoosen
New Member
- Joined
- Jan 28, 2019
- Messages
- 2
Hi,
I need some help please, I work with a basket of products that fall under different groupings (a,b,c) I want to execute a price increase on my turnover and of x percent but I want to make group "A" increase by a certain percentage only and then be able to calculate the increase on the rest of the parts to equal the target revenue. I want to be able to do this based on the volume of sales on the part so that parts which don't sell don't increase.
Eg.
Total increase 5%
Current Turnover:500
Goal Turnover: 525
Group A 6% increase
<tbody>
</tbody>
Please help me it's driving me crazy trying to solve this.
I need some help please, I work with a basket of products that fall under different groupings (a,b,c) I want to execute a price increase on my turnover and of x percent but I want to make group "A" increase by a certain percentage only and then be able to calculate the increase on the rest of the parts to equal the target revenue. I want to be able to do this based on the volume of sales on the part so that parts which don't sell don't increase.
Eg.
Total increase 5%
Current Turnover:500
Goal Turnover: 525
Group A 6% increase
Product | Grouping | Retail Price | Volume | |
XX | a | 10 | 20 | |
XX | b | 9 | 11 | |
XX | b | 8 | 2 | |
XX | a | 7 | 3 | |
XX | c | 6 | 4 | |
XX | c | 5 | 10 | |
XX | a | 4 | 0 |
<tbody>
</tbody>
Please help me it's driving me crazy trying to solve this.