Hi all,
I have always had to calculate this figure manually by trail and error and am sure there must be a simple way to solve it automatically in a formula so here I am . .
The basic idea is to do with calculating total takings needed as a target - I have a budget which gives me a daily profit needed to replace stock and pay all the overheads etc. I know my margins, taxes etc on the different aspects of the business but for now I have to enter a total daily takings figure to see if the profit is enough and if it is higher or lower I have to keep changing the total takings figure until the result matches the profit needed. I am sure there must be a simple bit of maths and or formula I am missing so if anyone can suggest a solution it would be greatly appreciated.
Many thanks.
Bookmarks