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

Relevance

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%

• Login to reply the answers
• 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

• Login to reply the answers
• 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%

• Login to reply the answers
• Login to reply the answers
• Login to reply the answers