LinkBack URL
About LinkBacks
So I have my cost and gross margin. I would like to set up an equation where I can enter my target GM (say 35%) and it will take my cost and target GM to give me a target price for my item. Any idea how to set this up in Excel?
So I have my cost and gross margin. I would like to set up an equation where I can enter my target GM (say 35%) and it will take my cost and target GM to give me a target price for my item. Any idea how to set this up in Excel?
The basic formula is
=cost/(1-gross margin)
Use values / cell references in place of descriptions.
Last edited by jason.b75; 07-19-2012 at 01:31 PM. Reason: brain malfunction
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks