Formula Help - 2 dynamic variables

eoinymc

Board Regular
Joined
Jan 29, 2009
Messages
203
Hi,

Just wondering if anyone can help me.

I'm currently trying to solve an equation and put it into an excel formula.

If I have the following info:
Customers10
Total Revenue$200
Revenue Per Customer$20

<tbody>
</tbody>

I want to increase my total revenue by $100 and the increase will be gotten by 50% of revenue increase and 50% of customer increase.

Can anyone help me out on how to do this please?

If you need any more info, please let me know.

Cheers,

E
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

eoinymc

Board Regular
Joined
Jan 29, 2009
Messages
203
I meant to say that I'm looking for a way to figure out what my new average revenue per customer is and what my new total customers are if I get the required increase by increasing both by 50%...
 

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
11,005
customers
1011121314151617
20200220240260280300320340
20.5205225.5246266.5287307.5328348.5
21210231252273294315336357
revenue per customer21.5215236.5258279.5301322.5344365.5
22220242264286308330352374
22.5225247.5270292.5315337.5360382.5
23230253276299322345368391
23.5235258.5282305.5329352.5376399.5
24240264288312336360384408
24.5245269.5294318.5343367.5392416.5
25250275300325350375400425
25.5255280.5306331.5357382.5408433.5
26260286312338364390416442
26.5265291.5318344.5371397.5424450.5
27270297324351378405432459
27.5275302.5330357.5385412.5440467.5
28280308336364392420448476
28.5285313.5342370.5399427.5456484.5
29290319348377406435464493
29.5295324.5354383.5413442.5472501.5
30300330360390420450480510
clearly 13 customers and $23 per customer is one solution
as is 14 customers and $21.5 per customer
you have to decide what is possible

<colgroup><col><col><col span="12"></colgroup><tbody>
</tbody>
 

eoinymc

Board Regular
Joined
Jan 29, 2009
Messages
203
Thanks for the help..

It's not quite what I was looking for. I wanted a way to do this by being able to change the 50%/50% split in a cell and a formula automatically updating what would show what this meant for increase in customers and revenue.

But I appreciate that.

E
 

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
11,005

ADVERTISEMENT

ok I did not "see" that in your original post - I will give it more thought...
 

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
11,005

ADVERTISEMENT

10customerscustincr%percustincr%
$20per customer4555
$200REVENUE
customers14
per cust31.00
REVENUE$434.00
now you can play with the % split to study the effect on total revenue
if this is ok with you, I will post formulas

<tbody>
</tbody>
 
Last edited:

eoinymc

Board Regular
Joined
Jan 29, 2009
Messages
203
I don't think I'm explaining it correctly.

The target revenue to hit is $300 (which is an increase of $100). This is a constant.

How I get that extra $100 is a mix of increasing customers and revenue per customer.

50% of the increase should come from increasing customers and 50% from increasing the revenue per customer. i.e. in this example, $50 incremental revenue from increasing rev per customer and $50 from increasing customers.

Then, what I want to be able to do is to change 50-50 to 60-40 or whatever and it shows me what the mix of increases will be.

Does that explain it?

Thanks again for your help thus far.

E
 

Noodleski

Active Member
Joined
Nov 18, 2015
Messages
467
12,5 customers is a bit weird, isn't it? I guess that's what oldbrewer tried to avoid.
 

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
11,005
if you get X more customers and Y more revenue you get an equation 20X +XY+10Y = 100

clearly there are infinite solutions.....my table shows you this and my post 7 gives you a way to look at the effects of varying the split percentages
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,313
Members
414,052
Latest member
Dual Showman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top