Results 1 to 14 of 14

Calculate Sales price with Net Margin 10% Goal, if Cost goes up or down

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-31-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    124

    Calculate Sales price with Net Margin 10% Goal, if Cost goes up or down

    I really need help,

    I am having trouble figuring it out how to add the formula for sales price column to calculate price get Net margin 10% if cost goes up or down want sales prices to calculate as price 10% net margin

    in Net Margin column formula I have

    Sales Price -(Cost+Comm)/ Sales = Net Margin

    up to now I add sales price manually, now I would to add formula to calculate sales price from net margin

    my brain is not working , can some please help me with this, I am sure it must be really easy,

    I have to add this to the file today, I really appreciate all the help in this matter.

    hope my question is not confusing, please let me know if its does not make sense,

    I just want Net margin to stay 10% no matter what the cost is and calculate the sales price from 10% net margin.

    thanks in advance
    Last edited by Bitto; 10-21-2013 at 02:12 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need to calculate retail price based on known cost and percentage
    By rayzorkat in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-02-2013, 06:27 PM
  2. Margin, RRP and Cost Price Calculation assistance
    By scottmjohnson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-24-2012, 05:55 AM
  3. Calculate the correct cost when more than 1 cost price
    By CplSmudge in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-25-2012, 01:12 PM
  4. How to calculate a price using goal seek?
    By karo3440 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-25-2011, 03:26 AM
  5. Forumula to calculate cost price ?
    By Digmen1 in forum Excel General
    Replies: 3
    Last Post: 04-16-2008, 08:10 AM

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