Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2008
    Location
    Medway, Kent, United Kingdom
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cost and Margin (2003 SP2)

    Morning Loungers

    My spread sheet calculates Prime Cost and On Cost when entering Profit % and Total (blue cells row 8). Or it calculates Profit and Total when you enter Prime Cost and On Cost % (blue cells row 10)

    What I don't seem to be able to get my head round is calculating the prime cost by entering the On Cost % and the Total.

    Any offers?

    Regards

    Graeme
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cost and Margin (2003 SP2)

    You should enter 33.33% in B12, not 33.33. The formulas then become

    A12 = E12 / (1 + B12)

    D12 = B12 / (1 + B12)

    C12 = D12 * E12

  3. #3
    New Lounger
    Join Date
    Sep 2008
    Location
    Medway, Kent, United Kingdom
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cost and Margin (2003 SP2)

    Hans

    Thank you

    Regards

    Graeme

Posting Permissions

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