http://en.wikipedia.org/wiki/DSV_Alvin#Sinking wrote:Researchers found a cheese sandwich which exhibited no visible signs of decomposition, and was in fact eaten.
Meteoric wrote:We can definitely set up an equation that relates sales, spending, and profit. Your 40.65% appears to actually be the percentage of revenue you spent, rather than the percentage which is profit, although these figures are complementary (so with 40.65% spent, you should have 59.35% profit).
That equation should look like this: target% = 100*spending/sales
But you want to know the level of sales you need, so we solve the equation for that, ending up with: target_sales = 100*spending/target%
That would tell you the total sales you need, so if you want to know how far off you were, just subtract how much you actually made: (100*spending/target%)-actual_sales
If you use the target percentage as a decimal (.3) rather than a percent (30) you can get rid of that 100 in the equation, leaving you with: (spending/target)-actual_sales.
So for the example numbers you posted, you need (2386.56/.3)-5870.32 = 2084.88, or almost $2100. This doesn't match the $2500 you came up with... maybe I've misunderstood what you're asking? Regardless, hopefully this helps point you in the right direction.
KernowDragon wrote:Here's an example using mock figures.
Actual %: 40.65
Target %: 30
Using trial and error, we're about 2,500 out (that'd make it 30.04%, which is near enough for the boss but not for me! :p). I can't seem to work out a formula that will get me a number close to 2,500. I've tried most things a man with my brainpower could reasonably be expected to try... Any help would be much appreciated.
Users browsing this forum: nadando and 13 guests