Results 1 to 6 of 6

I need a basic formula that my brain is failing to give.

Threaded View

  1. #1
    Registered User
    Join Date
    10-29-2014
    Location
    Portland, OR
    MS-Off Ver
    MS Office 2013
    Posts
    54

    I need a basic formula that my brain is failing to give.

    Hello again forum,

    I'm trying to boost some sales on my products by repricing but my think box is failing me on this equation.
    SO... spread.. I have a spread of my products, cost, price, and all the fun stuff.. I need my calculated GP (Gross Profit) to be down to 10%. Meaning, I have thousands of items here with all sorts of GP's from 10% to 100% I want no matter what the current GP is, I need the price to be brought down to make my GP only 10%. So the variable is where I'm getting caught up, I need to solve for X and I don't know how. So in words (if I can explain this correctly) Cost minus Price divided by cost will get my current GP. The equation I need will calculate my current GP or just pull it from the calculation I already have and solve for X(current GP) and bring that GP down with end result being: My 100$ item has a 100% GP.. by making that item 10$ I lower my GP to 10% which is goal.
    I know I'm repetitive but it's hard for me to explain things. Any help on this would be greatly appreciated, THANK YOU!


    -Tommy Bailey
    Attached Files Attached Files
    Last edited by Bailey_Thomas; 03-06-2015 at 01:55 PM.
    Show appreciation by clicking "Add Reputation"

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Merging multiple data cells into one cell
    By Rollsta in forum Excel General
    Replies: 1
    Last Post: 10-24-2013, 11:13 PM
  2. [SOLVED] Formula that is KILLING MY TINY BRAIN
    By ennudmotty in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-21-2012, 11:35 AM
  3. Brain Clog! Help with formula, please
    By JoeSpareBedroom in forum Excel General
    Replies: 7
    Last Post: 07-19-2006, 08:20 AM
  4. [SOLVED] Formula Problem - Get your brain around this..
    By Dominators Puzzle in forum Excel General
    Replies: 0
    Last Post: 02-10-2006, 03:25 PM
  5. [SOLVED] Brain lock: using array formula within VBA?
    By Ed in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-12-2006, 01:50 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