johnyboy010
New Member
- Joined
- May 7, 2020
- Messages
- 1
- Office Version
- 365
- 2010
- Platform
- Windows
Hi All,
First time poster here and looking for help on what I believe may lie with data tables / goal seek.
My spreadsheet currently has many formulas but can be simplified to: Margin = (Price - Costs) / Price
I am looking to answer a question:
‘What would my price have to be if costs changed by a, b & c% and my margin was fixed at Y?
The Costs variable could be:
- with each cost variable on the x axis
- each a,b,c on the y axis
- contents of the table being prices
- above the table the input margin Y
Goal seek works but it is not dynamic and also does not allow me to see all the X variables together.
Would you have any advice?
First time poster here and looking for help on what I believe may lie with data tables / goal seek.
My spreadsheet currently has many formulas but can be simplified to: Margin = (Price - Costs) / Price
I am looking to answer a question:
‘What would my price have to be if costs changed by a, b & c% and my margin was fixed at Y?
The Costs variable could be:
- Labour costs
- Materials costs
- Exchange rates
- Wholesaler margin
- with each cost variable on the x axis
- each a,b,c on the y axis
- contents of the table being prices
- above the table the input margin Y
Goal seek works but it is not dynamic and also does not allow me to see all the X variables together.
Would you have any advice?