Hi Everyone,
I am doing a school exercise on how to calculate the optimal volume of a product to have a fixed margin, where the price and COGS are depended on the volume.
I wanted to tackle this through a top down + bottom up approach by then having goals seek trying to match the 2 prices by changing the volume, but I didn't succeed to do a double goal seek, can anyone help? (I enclosed the example)
https://we.tl/9wBojww5Hb
Thanks!
Bookmarks