MATH!! MY BRAIN GOT STUCK. Gross Profit Recalculation. Please Help?
Hi. I have a problem. MAth is rusty. I have 5 products. I need to recalculate the gross profit for each according to 1 standard equasion.
Cost - $100, $70, $50, $30, $10. Sell - $200, $140, $100, $60, $20
50% Gross Profit Margin.
Now, the cheap products are too expensive for a 50% Gross Margin. What I need is the following.
The $260 gross profit needs to be divided into the 5 products on a scale whereas the most expensive product($100) absors more profit and the smallest product of $10 less. It must look something like this.
Cost - $100, $70, $50, $30, $10. Sell - $220, $150, $85, $51, $14
I use excel. I will appreciate if someone can mail me an example.
- PoutineLv 71 decade agoFavorite Answer
Yes Loop has been kicked off.
Tom you should learn how to read.
The questioner asked for an example done on excel to me e-mailed to them. Unfortunately they do not allow e-mails and did not give an e-mail address.
Gross margin percentage = 100 * (sales price - cost) / sales price
100 * (200-100)/200
- KarenLv 44 years ago
These aren't brain teasers; these are straight math problems. Lol. 1. Solve x + y = 70 x = 10 + 2y so (10+2y) + y = 70 10 + 3y = 70 3y = 60, so y = 20. Since x + y = 70, it follows that x = 50. 2. Solve x + y = 180 x = 10 + 3y so (10 + 3y) + y = 180 10 + 4y = 180 4y = 170, so y = 170/4 = 85/2 = 42.5. Since x + y = 180, it follows that x = 180 - 85/2 = 275/2 = 137.5
- ♥Tom♥Lv 61 decade ago
if you buy an item and sell it for twice what you bought it for.. your final sale still has 100% profit.. no matter how much or how little you paid for it...
the $260 is the total of your costs for the 5 items.. and you sell them for a total of $520 (or 100% profit).. now, you want to change the prices so that you only have 50% profit so you sell them each not for 2 times their original cost but for just 1.5 times..
so, the $100 item sells for $150, etc...
after paying out $260 for your items you sell them and instead of getting $260 profit you get only $130 profit.. or 50%Source(s): By the way, Poutine, is just as bad as the advertisement.. you did not even TRY to answer the question.
- 1 decade ago
visit a college library u could get help from students that are geneous of math for free.
- How do you think about the answers? You can sign in to vote the answer.
- Mr. Girl LikerLv 51 decade ago
I'm not answering this question, but POUTINE, DID LOOP Q'S ACCOUNT GET DELETED FROM ANSWERS? B/C I DON'T SEE ANY OF HIS Q'S OR A'S!?!?