Formula Help - 2 dynamic variables

[eoinymc]

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:

Customers	10
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

 

[eoinymc]

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]

								customers
					10	11	12	13	14	15	16	17
				20	200	220	240	260	280	300	320	340
				20.5	205	225.5	246	266.5	287	307.5	328	348.5
				21	210	231	252	273	294	315	336	357
	revenue per customer		21.5	215	236.5	258	279.5	301	322.5	344	365.5
				22	220	242	264	286	308	330	352	374
				22.5	225	247.5	270	292.5	315	337.5	360	382.5
				23	230	253	276	299	322	345	368	391
				23.5	235	258.5	282	305.5	329	352.5	376	399.5
				24	240	264	288	312	336	360	384	408
				24.5	245	269.5	294	318.5	343	367.5	392	416.5
				25	250	275	300	325	350	375	400	425
				25.5	255	280.5	306	331.5	357	382.5	408	433.5
				26	260	286	312	338	364	390	416	442
				26.5	265	291.5	318	344.5	371	397.5	424	450.5
				27	270	297	324	351	378	405	432	459
				27.5	275	302.5	330	357.5	385	412.5	440	467.5
				28	280	308	336	364	392	420	448	476
				28.5	285	313.5	342	370.5	399	427.5	456	484.5
				29	290	319	348	377	406	435	464	493
				29.5	295	324.5	354	383.5	413	442.5	472	501.5
				30	300	330	360	390	420	450	480	510
					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]

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]

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

 

[eoinymc]

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

Thanks so much...it's hurting my head!

 

[oldbrewer]

10	customers						custincr%	percustincr%
$20	per customer						45	55
$200	REVENUE
							customers	14
							per cust	31.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>

 

[eoinymc]

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]

12,5 customers is a bit weird, isn't it? I guess that's what oldbrewer tried to avoid.

 

[oldbrewer]

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