+ Reply to Thread
Results 1 to 3 of 3

Help with product margin increase

  1. #1
    Registered User
    Join Date
    07-01-2015
    Location
    Northampton, UK
    MS-Off Ver
    2007
    Posts
    6

    Help with product margin increase

    Hi all,

    got one that has me frustrated

    So I have a product that sells for £3, the cost is £1.26 giving me a profit margin of around 58%

    I want to increase that margin by 10% to 68%.

    Using my cost price and desired margin how can I generate the new sale price?

    Appreciate any help.

    Steve

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: Help with product margin increase

    If B1 = cost price (£1.26), B2 = desired margin (68% = 0.68) then type the following into B3:

    Please Login or Register  to view this content.
    That will give you your selling price.

    WBD
    Office 365 on Windows 11, looking for rep!

  3. #3
    Registered User
    Join Date
    07-01-2015
    Location
    Northampton, UK
    MS-Off Ver
    2007
    Posts
    6

    Re: Help with product margin increase

    Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Determining Margin Formula, I know cost and margin desired.
    By Draftdude in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-15-2018, 06:08 AM
  2. Replies: 2
    Last Post: 08-23-2017, 10:50 AM
  3. Simplifying Sum Product to increase speed. Count?!
    By Keibri in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-05-2016, 03:38 AM
  4. help on price increase on product list ?
    By digga in forum Excel General
    Replies: 3
    Last Post: 07-27-2016, 01:43 AM
  5. Net Margin Formula Using SUM= To Calculate Gross Margin Cells
    By jezrp22 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-26-2015, 08:41 PM
  6. [SOLVED] I need a margin detailed margin calculation
    By mikerules in forum Excel Formulas & Functions
    Replies: 34
    Last Post: 01-31-2014, 03:00 AM
  7. Textbox margin overwritten by auto-margin
    By Jess in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2005, 07:09 PM

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