
Algebra PreAlgebra and Basic Algebra Math Forum 
 LinkBack  Thread Tools  Display Modes 
March 25th, 2014, 11:15 AM  #1 
Newbie Joined: Mar 2014 Posts: 1 Thanks: 0  Sales price calculation
Hey, For you guys this is probably peanuts: I have this formula in an IT application I am designing. It is used to calculate sales prices for materials: (( TMC + ( O * S ) ) * M ) * T ) = S TMC = Total manufacturing costs = e.g. 720 is given O = overhead percentage of sales price is given = e.g 25% S = Sales price we are calculating here M = Market uplift on total costs = E.g is given factor 3,00 but can be changed, with this we multiply our total costs to add margin T= Transport upcharge is given: E.g. 1,06 Now to calculate S we can deduct this: S = T * M * TMC / (1  ( T * M * O)) Great the solutions I find with this formula are correct BUTTTT When T * M * O > 1 the solution will be negative, we will not sell something for  so much euro. What am I doing wrong? Thank you so much in advance, Michaël 
March 25th, 2014, 05:46 PM  #2  
Math Team Joined: Oct 2011 From: Ottawa Ontario, Canada Posts: 14,597 Thanks: 1038  Re: Sales price calculation Quote:
Can you provide an ACTUAL example? Could you use a decimal POINT instead of that funny "," you guys use :P Like 2.25, not 2,25. By the way, do you show 1,25 / 100 as ,125? YUK!  
March 25th, 2014, 07:25 PM  #3 
Global Moderator Joined: Oct 2008 From: London, Ontario, Canada  The Forest City Posts: 7,949 Thanks: 1141 Math Focus: Elementary mathematics and beyond  Re: Sales price calculation
,0125 :P 
March 25th, 2014, 08:02 PM  #4 
Math Team Joined: Oct 2011 From: Ottawa Ontario, Canada Posts: 14,597 Thanks: 1038  Re: Sales price calculation
Thanks Greg...10 minutes in the corner for me... 
March 25th, 2014, 08:17 PM  #5 
Global Moderator Joined: Oct 2008 From: London, Ontario, Canada  The Forest City Posts: 7,949 Thanks: 1141 Math Focus: Elementary mathematics and beyond  Re: Sales price calculation
That's o.k. I've been keeping it warm for you. 
March 26th, 2014, 11:20 AM  #6  
Math Team Joined: Oct 2011 From: Ottawa Ontario, Canada Posts: 14,597 Thanks: 1038  Re: Sales price calculation Quote:
Including the solutions you think are correct... OK; using your illustration (changing TMC to C and O to V): C = Total manufacturing costs: example 720 V = overhead percentage of sales price: example 25% M = Market uplift on total costs: example 3% T = Transport upcharge: example 1.06% S = Sales price. Equation should be (assuming M and T are percentages): S = C + C*(M + T) + S*V Solving: S  S*V = C*(1 + M + T) S(1  V) = C*(1 + M + T) S = C*(1 + M + T) / (1  V) So program should look like: C = 720 : V = .25 : M = .03 : T = .0106 ' givens S = C*(1 + M + T) / (1  V) PRINT.....whatever.... This will be the result: Code: Manufacturing : 720.00 Uplift : 21.60 Transport : 7.63 Overhead : 249.75 ====================== Sale price : 998.98  

Tags 
calculation, price, sales 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Sales conversion linked to sales enquiries and orders  Rocky  Elementary Math  1  July 3rd, 2013 08:55 AM 
Need help with price calculation  sidewlkr  Elementary Math  2  April 12th, 2013 03:08 PM 
Sales forecasting  Spook  Advanced Statistics  1  September 13th, 2012 04:55 AM 
marginal price and pricedemand  tsl182forever8  Calculus  2  March 15th, 2012 03:07 PM 
Sales price calculation  spitzke  Calculus  0  December 31st, 1969 04:00 PM 