# Calculate daily takings needed based on daily spend & profit margin

1. ## Calculate daily takings needed based on daily spend & profit margin

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.

2. ## Re: Formula needed to calculate daily takings needed based on daily spend & profit ma

Thought I would send in an example.

This sheet has the basic idea with the figures needed at the top and the some margins and split figures below. The figure in C19 is the one I would have to manually keep changing to make D23 equal to F14, can this be calculated without the need for VB?

Thanks.

3. ## Re: Formula needed to calculate daily takings needed based on daily spend & profit ma

bump - no response . . .

or is it that I am not the only one stumped by this, maybe it just cant be done without running some vb to cycle through the values until x = y etc.

Thanks for looking,
Cheers.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1