MATH!! MY BRAIN GOT STUCK. Gross Profit Recalculation. Please Help?

Question

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.

Thanx

Answer 1

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.

AND

Gross margin percentage = 100 * (sales price - cost) / sales price
100 * (200-100)/200
=50%

Answer 2

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

Answer 3

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%

Answer 4

hy
visit a college library u could get help from students that are geneous of math for free.

Answer 5

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!?!?