Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
liquidone
Starting Member
10 Posts |
 Posted - 2006-09-11 : 14:37:50
|
| I need to figure out how to solve an equation for a sales team, I need the logic for how to solve it, before I decide where and how to calulate it. The problem is below, thanks.The saleman here work on commission, and it is tiered based on profit margin, and they want to be able to enter in the cost of an item, along with the desired margin, and have the program figure out the total based on those values.cost is always a known number.profit = total - costmargin = profit / totalI need to figure out total if cost and margin are the only ones known.I think the folowing formula describes it better(total - cost) / total = MarginThe only unknown in that formula is total.Now ill use a current example.For a big custom job coming up there is an amount of shades for a house that total $100,080 in our cost.We want to add that to the invoice at 15% profit margin, in order to get the next level of commission.If you just add 15% to it, that makes about a 13% profit margin, so thats no good.so using the above formula:(total - 100,080) / total = 15/100(15%)How would I systematically solve this equation, I just need the logic for it.Thanks,Mike |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-11 : 14:48:18
|
| Algebra 101...Total = 100,080 / ( 1 - 0.15)Peter LarssonHelsingborg, Sweden |
 |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-09-11 : 14:52:17
|
| http://mathforum.org/library/drmath/view/65175.htmlSrinika |
|
|
|
liquidone
Starting Member
10 Posts |
Posted - 2006-09-11 : 15:15:04
|
| I suppose I shoulf have paid better attention in math class...and I thought I'd never use it in the real world...lolThanks guys for helping me out!-Mike |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-09-11 : 17:04:46
|
| You thought you would never use algebra?"I have HAD it with these muthu-f$#%in' cursors in my muthu-f$#%in' database!" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-12 : 01:06:31
|
| Maybe he even doesn't pay his taxes either?Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
|
|
Math Logic Problem. . .