wonder if anybody here would be kind enough to help me with this headscratcher.
i am working on a gross profit calculator for a restaurant.
i want to include 3 methods of viewing the affect on gp.
increase to (new price) method, and increase by (fixed amount) method are straightforward enough, by the reverse calculation needed for achieve given GP % is frying my head a bit
<tbody>
</tbody>
any help gratefully received - new to the forum, but hope to give as much as i take.
i am working on a gross profit calculator for a restaurant.
i want to include 3 methods of viewing the affect on gp.
increase to (new price) method, and increase by (fixed amount) method are straightforward enough, by the reverse calculation needed for achieve given GP % is frying my head a bit
A | B | C | D | E | F |
cost price | sale price | gross profit € | gross profit % | to achieve gross profit of X% | the new sale price needs to be P |
100€ | 200€ | 100€ | 100% | 200% | Formula Required |
4.75€ | 18.95€ | 14.20€ | 299% | 350% |
<tbody>
</tbody>
any help gratefully received - new to the forum, but hope to give as much as i take.