Manie M asked in Science & MathematicsMathematics · 1 decade ago

# 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.

Thanx

Relevance
• 1 decade ago

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%

• Anonymous
5 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

• 1 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

hy

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