I need to make a formula or VB that can calculate sell price based on the following
1. My cost
2. the amount i want to make
3. Fees
4. Shipping cost
IE... My cost is 6.00 I want to make 5.00 my fees are 12% of the total sell price my shipping cost is 8.50
can anyone help me with this project
Hello painnbt,
Welcome to the Forum!
This looks a lot like a homework problem. The forum policy is not to write any code for you for homework assignments. We can provide you with advice on how to structure and solve your problem.
This is the basic formula: Total Sale Amount = (Cost + Profit) + Fees%*(Cost + Profit) + Shipping or (6 + 5) + .012*(6 + 5) + 8.50 = $19.63
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thank you for your reply. No this is not homework it is a part of a project for work that I am trying to wrap my head around. The goal is to be able to put the formula in my cost spreadsheet so I can export price based on my fees my cost and how much I want to make on a given cost bracket
Similar to Leith's solution: we have Revenue (Selling Price), Cost (which includes 12% Fees on Cost + Profit) and Shipping - so:
R=1.12*P+2.12*C+S=$26.82 (a variation on the old PRC formula P-R-C)
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thank you for the feed back I tried what you said and when i go back to check it it does not come out right when i make the formula to check the it comes out higher then the profit that i put in. I have attached a screen shot
Untitled.jpg
Yeah, I had a senior moment - sorry, change the formula to:
R=1.12*P+1.12*C+S=$21.82 or like Leith's - R=1.12*(P+C)+S
That seems to put the number in the other direction when i check it.
Untitled2.jpg
Your fee calculation is off, it should be 95 cents for the first one:2.09 -.95=1.14 and 1.14+3.87=5.01
Perhaps im not explaining the fee well enough. The fee is based off of the sell price so if the sell price is 20.00 then the fee is 2.40. So what i need is something that will calculate sell price based on what my cost, shipping, and how much profit i want to make and the fee
Row\Col E2: =SUM(A2:C2) / (1-D2)
Entia non sunt multiplicanda sine necessitate
Thank you it worked!!!!
Last edited by painnbt; 04-13-2015 at 10:13 AM.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks