UK Increase in Cost of Goods Sold

[Stace760@Googlemail. Com]

Hi, I am new to costs and revenues (currently studying AAT LEVEL 3) but I have been asked at work to produce a spreadsheet to show what increase in sales would need to be as a % to maintain a profit margin of 50% for every 1% increase in Costs of Goods sold.

I need help!
I have no idea how to work this out

Could someone please point me in the right direction

 

[Ambitious7]

Stacey, have a look here: https://hedgescompany.com/blog/2010/10/formula-price-increase-price-decrease/

That should help!