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

5 Answers

Relevance
  • 1 decade ago
    Favorite 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.

    AND

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

    100 * (200-100)/200

    =50%

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

    • Login to reply the answers
  • 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.
    • Login to reply the answers
  • 1 decade ago

    hy

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

    • Login to reply the answers
  • How do you think about the answers? You can sign in to vote the answer.
  • 1 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!?!?

    • Login to reply the answers
Still have questions? Get your answers by asking now.