Business Analysis

Search

July 2009
M	T	W	T	F	S	S
« May
	1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31

Feeds

How to effectively collect, process, analyze and present data

103CommentsBusiness+Analysis2007-05-01+14%3A08%3A26Juan+Carlos+M%C3%A9ndez-Garc%C3%ADa to “Business Analysis”

Neda Esfan says:

October 29, 2008 at 11:01 am

Thank you so much. That was a huge help.
Regards
Neda
Juan Carlos Méndez-García says:

October 27, 2008 at 12:28 pm

@Neda
Thanks for the message. For the problem you mention I’d personally use simply a step formulation just as you described ($15@1-10, $17@11-15, $20@16-20) if anything else because it is easier to communicate to the walkers. In Excel this would be just a simple =IF(AND(numdog>0,numdog< =10),15,IF(numdog<=15),17,...))

If you still would like to use an s-curve for the problem, you could use the technique described in this previous post: http://jcandkimmita.info/jc/2007/04/business/modeling-market-adoption-in-excel-with-a-simplified-s-curve/”

You would set the saturation to $5 (the difference between the low pay range and the high pay range), the start of fast growth around 7 or 8 (dogs walked) and the takeover parameter would not mean time, but dogs walked, and I would set it around 15 or 16. In the original curve the horizontal axis is time since introduction, and in your usage would be dogs walked. Finally, you would add $10 (the low pay range) to the formula result.

Happy modeling!
Neda Esfan says:

October 27, 2008 at 10:35 am

Hi Juan,
I desperatly need your help. I have been searching the internet for hours and finally saw your website.
I am helping my brother in his business and he needs to create an s curve in excel to predict his cost.
He basically needs a formula to create an s curve for the following problem. For example if he wants to pay $15/hr to someone for walking up to 10 dogs but he will pay $17/hr if they walk 15 dogs and finally $20/hr if they walk 20 dogs.
Any ideas how to write the formula in excel and make a s-curve chart?
My gratitude and million thanks in advance.
Neda

Sorry, the comment form is closed at this time.

Search

Recent Posts

Archives

Categories

Feeds

Business Analysis

Search

Recent Posts

Tags

Archives

Categories

Feeds

Business Analysis