Need help adding a percentage cost to a selling price

  • MHB
  • Thread starter mrmikepan
  • Start date
In summary, you would subtract the flat fee of $4.70, the shipping fee of $5.20, the material costs of $100, and the profit of $35 from the selling price. Then you would add 0.119*($164.47-$135) to the selling price to get the final selling price.
  • #1
mrmikepan
3
0
Sorry if this question sounds stupid...

I know there's something obvious that I'm missing (maybe not) but its taking me forever to figure out on my own.

What were trying to do is cover all costs associated for the sale within the selling price.

We have-
  • Flat Fees: $4.70
  • Shipping: $5.20
  • Material costs: $100
  • And we want to include a 35% Profit of Material Costs ($35) within the selling price.
  • And last but not least, the part I can't figure out is how to add a 11.9% fee to the selling price (applied after the sale of everything combined).

I need to have it be exact! So if the fees were deducted I would be left with 135 dollars. ($100 + the 35% profit)

If I add 11.9 percent of the selling cost, the 11.9 percent value will have changed because I'm adding the dollar amount to the total...right? So how can I account for it? By raising the 35 percent profits to something more?

I just need to be sent in the right direction so that I could do this alone next time. Not necessarily looking for the answer, I'm looking for the procedure/the way to go about this type of calculation which I'm sure happens all the time in business.

Thanks for all your help! (Smile)
 
Last edited:
Mathematics news on Phys.org
  • #2
Re: Need up adding a percentage cost to a selling price!

Just a little algebra.

•Flat Fees: $4.70
•Shipping: $5.20
•Material costs: $100
•And we want to include a 35% Profit of Material Costs ($35) within the selling price.
•And last but not least, the part I can't figure out is how to add a 11.9% fee (applied after the sale) of everything combined to the selling cost.

(Selling Cost) = 4.70 + 5.20 + 100.00*1.35 + 0.119*(Selling Cost)

Some algebra

(Selling Cost) - 0.119*(Selling Cost) = 4.70 + 5.20 + 100.00*1.35

More algebra

(Selling Cost)(1 - 0.119) = 4.70 + 5.20 + 100.00*1.35

Still More

(Selling Cost) = (4.70 + 5.20 + 100.00*1.35)/(1 - 0.119)

Now for arithmetic

(Selling Cost) = (9.90 + 135.00)/(0.881) = 144.90/0.881 = 164.48

Check it out!

164.48*0.119 = 19.57
164.48 - 19.57 = 144.91 and this is not quite 144.90 only because of rounding.
 
  • #3
Re: Need up adding a percentage cost to a selling price!

tkhunny said:
Just a little algebra.

•Flat Fees: $4.70
•Shipping: $5.20
•Material costs: $100
•And we want to include a 35% Profit of Material Costs ($35) within the selling price.
•And last but not least, the part I can't figure out is how to add a 11.9% fee (applied after the sale) of everything combined to the selling cost.

(Selling Cost) = 4.70 + 5.20 + 100.00*1.35 + 0.119*(Selling Cost)

Some algebra

(Selling Cost) - 0.119*(Selling Cost) = 4.70 + 5.20 + 100.00*1.35

More algebra

(Selling Cost)(1 - 0.119) = 4.70 + 5.20 + 100.00*1.35

Still More

(Selling Cost) = (4.70 + 5.20 + 100.00*1.35)/(1 - 0.119)

Now for arithmetic

(Selling Cost) = (9.90 + 135.00)/(0.881) = 144.90/0.881 = 164.48

Check it out!

164.48*0.119 = 19.57
164.48 - 19.57 = 144.91 and this is not quite 144.90 only because of rounding.

OMG TY! I don't know why this was taking me so long, for some reason when I was trying to do it in my head trying to setup the calculation I needed in excel. I felt like I was going in circles. Its nice to get things explained clearly, ty!
 
  • #4
Re: Need up adding a percentage cost to a selling price!

tkhunny said:
Just a little algebra.

•Flat Fees: $4.70
•Shipping: $5.20
•Material costs: $100
•And we want to include a 35% Profit of Material Costs ($35) within the selling price.
•And last but not least, the part I can't figure out is how to add a 11.9% fee (applied after the sale) of everything combined to the selling cost.

(Selling Cost) = 4.70 + 5.20 + 100.00*1.35 + 0.119*(Selling Cost)

Some algebra

(Selling Cost) - 0.119*(Selling Cost) = 4.70 + 5.20 + 100.00*1.35

More algebra

(Selling Cost)(1 - 0.119) = 4.70 + 5.20 + 100.00*1.35

Still More

(Selling Cost) = (4.70 + 5.20 + 100.00*1.35)/(1 - 0.119)

Now for arithmetic

(Selling Cost) = (9.90 + 135.00)/(0.881) = 144.90/0.881 = 164.48

Check it out!

164.48*0.119 = 19.57
164.48 - 19.57 = 144.91 and this is not quite 144.90 only because of rounding.

One little thing I wanted to ask:
The formula is -

... x = 4.70 + 5.20 + 100*1.35 + 0.119x right?
-0.119x ...... - 0.119x

0.881x = 4.70 + 5.20 + 100*1.35
0.881 .... 0.881

x = (4.70 + 5.20 + (100*1.35))/0.881
x = (9.90 + 135)/0.881
x = 144.90/0.881
x = 164.47 (164.47*0.119) = 19.57

164.47 - 4.70 = 159.77
159.77 - 5.29 = 154.57
154.57 - 19.57 = 135!

Yay! I guess I answered my own question (Giggle)
 
  • #5


No need to apologize, this is a valid question and it's important to make sure all costs are properly accounted for in the selling price. Here's a step-by-step process you can follow to calculate the selling price with the added percentage cost:

1. Start by adding up all the costs associated with the sale: $4.70 for flat fees, $5.20 for shipping, and $100 for material costs. This gives us a total cost of $109.90.

2. Next, we need to calculate the 35% profit on material costs. To do this, we multiply the material costs by 35% (or 0.35). In this case, it would be $100 x 0.35 = $35.

3. Now, we need to add this profit to the total cost. $109.90 + $35 = $144.90.

4. This is the total cost including the 35% profit. To find the selling price, we need to add the 11.9% fee on top of this cost. To do this, we multiply the total cost by 11.9% (or 0.119). In this case, it would be $144.90 x 0.119 = $17.28.

5. Finally, we add this fee to the total cost to get the selling price. $144.90 + $17.28 = $162.18.

So the selling price for this product would be $162.18 to cover all costs and include the desired profit margin.

In terms of the procedure, it's important to break down the costs and calculate each one separately before adding them together. This ensures that all costs are accounted for and the final selling price is accurate. I hope this helps and good luck with your future calculations!
 

FAQ: Need help adding a percentage cost to a selling price

What is the formula for adding a percentage cost to a selling price?

The formula for adding a percentage cost to a selling price is: selling price + (percentage cost * selling price).

How do I calculate the percentage cost of a selling price?

To calculate the percentage cost of a selling price, you will need to know the cost and the selling price. Then, use the following formula: (selling price - cost) / selling price * 100.

What is the difference between markup and margin?

Markup and margin are both methods of adding a percentage cost to a selling price. The difference is that markup is the percentage of the cost that is added to the selling price, while margin is the percentage of the selling price that is profit.

Can I use a different percentage for different products?

Yes, you can use a different percentage for different products. The percentage cost can vary depending on factors such as production cost, demand, and competition.

How do I add a percentage cost to a discounted selling price?

To add a percentage cost to a discounted selling price, you will first need to calculate the discounted selling price. Then, use the same formula as adding a percentage cost to a regular selling price, using the discounted selling price as the base price.

Back
Top