+ Reply to Thread
Results 1 to 3 of 3

Calculate daily takings needed based on daily spend & profit margin

  1. #1
    Registered User
    Join Date
    01-04-2010
    Location
    Malta
    MS-Off Ver
    Excel 2004 (Mac)
    Posts
    8

    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.
    Last edited by root729; 01-04-2010 at 07:45 AM.

  2. #2
    Registered User
    Join Date
    01-04-2010
    Location
    Malta
    MS-Off Ver
    Excel 2004 (Mac)
    Posts
    8

    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.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-04-2010
    Location
    Malta
    MS-Off Ver
    Excel 2004 (Mac)
    Posts
    8

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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