calculate the numbers to reach a number knowing the percenage to add to the first number?

[haggardns]

Hi,

Sorry if this is trivial, but I can't internet search this properly cause it is difficult to explain my question to a search engine

I am working on a capacity planning spreadsheet.

If can do 100 units of work, but I know that if someone assigns me 100 units of work but it may be 50% more than they said it would be, how do I know what my real capacity is?

For example: I can do 70 units of work, but I know it will always take 50% longer to do.

50% = the growth of the work
70 = amount of units capacity.

I manually did this but the answer is roughly:

46.6666
23.3333
= 70

So my manager comes to me and says I have work for you to do that will take 70 days but I know it could 50% longer to do it, so I tell him never assign me more than what we estimate the work to be, give me 46.666 days of work, and if it does take 50% longer than the 46, I have the 70 days to complete it in.

Without going into the existential reasoning of this question , how do I calculate this in excel.

A1 = 50%
B1 = 70
C = 46.666 (need answer)
D = 23.333 (need answer)

Thanks!

Chris

 

[jmacleary]

Hi there. The formulas you want are: set C1 to: =B1/(1+A1), and set D1 to =B1-C1. Make sure that cell A1 is set to percentage format.

John

 

[haggardns]

Thanks! This is the answer.