Results 1 to 4 of 4
  1. #1
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Mark Up Folrmula (Excel '07)

    That seems correct to me...

    Steve

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

    Re: Mark Up Folrmula (Excel '07)

    An alternative but not cleaner or better method is to calculate the profits first, and to calculate the price by adding that to the 'previous' price. See attached version.
    (Should it be MSRP or MSPR?)

    I assume that you need to know each of the intermediate results. If you're only interested in the 'final' price, the formulas could be combined into one unreadable monster formula, making the intermediate results unnecessary.
    Attached Files Attached Files

  3. #3
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Mark Up Formula (Excel '07)

    Is there a cleaner or better formula for showing mark up than the one in this spread sheet?
    The names have been changed to protect the innocent.
    Attached Files Attached Files
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  4. #4
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Re: Mark Up Folrmula (Excel '07)

    Thanks Guys.
    No I don't need to know the MSRP immediately as that will be for the dealer to figure out what mark up they want and need. This is just a figure out on a new product that I am taking on.
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

Posting Permissions

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