I'm trying to pull together a google sheet of pricings, we have the "stock price" which is supposedly a 25% mark up on base price. We can edit the mark up, down to 10% at whatever whole % needed. But the issue is it doesn't mathematically work out.
I am trying to create a spreadsheet that automatically works out % when we do not have access to the current automated system.
i.e heres one example
25% 20% 18% 10%
$50,750.00 $49,000.00 $48,300.00 $45,500.00
If you then work out what the base line for these should be they all provide a different answer
0% (10%) 0% (18%) 0% (20%) 0% (25%)
$41,363.64 $40,932.20 $40,833.33 $40,600.00
Im struggling to work out from the info I have what the ACTUAL base line price is and what the corresponding mark ups actually are. Is it even possible to do this?
Am I being dumb or is this physically not possible to work out from the data I have?
End would follow this format
Stock Price Price Before Mark Up New Mark Up% New Cost
$50,750.00 $40,600.00 18% $47,908.00
Were I can change the stock and New mark up to auto calculate new cost
After posting it completely ruined the formatting it may make sense to some
I am trying to create a spreadsheet that automatically works out % when we do not have access to the current automated system.
i.e heres one example
25% 20% 18% 10%
$50,750.00 $49,000.00 $48,300.00 $45,500.00
If you then work out what the base line for these should be they all provide a different answer
0% (10%) 0% (18%) 0% (20%) 0% (25%)
$41,363.64 $40,932.20 $40,833.33 $40,600.00
Im struggling to work out from the info I have what the ACTUAL base line price is and what the corresponding mark ups actually are. Is it even possible to do this?
Am I being dumb or is this physically not possible to work out from the data I have?
End would follow this format
Stock Price Price Before Mark Up New Mark Up% New Cost
$50,750.00 $40,600.00 18% $47,908.00
Were I can change the stock and New mark up to auto calculate new cost
After posting it completely ruined the formatting it may make sense to some