Fun graph pf the increasing population size of mice

I could really use some help on this one, as I cannot remember what this kind of equation is called or how it can be done.

Here is the data I have inhand, which I am eventually trying to put into a chart in Excel.

| best case | worst case | |

reproduce litters | 5 | 10 | |

sex ratio | 2 | 3 | females |

litter size | 5 | 6 | |

gestation period | 19 | 21 | days |

female life | 2 | 3 | years |

female age to reproduce | 4 weeks |

So, step one was breaking the time down to days.

female life is 730 - 1095 days

female age to reproduce 28 days

By the "best / worst" at the top, I am trying to say the best case scenario (assuming we do not want a lot of mice), versus the worst case scenario.

The calculation is where I am having trouble. Once the female is 28 days old, it will give birth to 5 to 6 pups, 2 or 3 of which are female. The gestation period is 19 - 21 days, so nothing can be produced during this point of time. When the offspring are born, the system begins again, 2 or 3 of those females become 28 days old, then begin to reproduce in the same manner. Of course each female needs to stop reproducing at 730 - 1095 days... (Worried)

I would not expect this to be viewable in one line, being that I gave a range of numbers, it would probably have to be two, but the calc should be the same.

If someone could please help me with figuring out this calculation, which I then need to move into Excel and graph, it would be most appreciated. Also, can you tell me what this calc is called? I know I have done this before, but it has been a long time.

Thank you so much,

Ryan

Re: Fun graph pf the increasing population size of mice

Other fun facts that can be applied to this graph once it is created.... (kinda gross but that is the point)

• An average mouse weighs 15g

• Average mouse is 3.3” long

• Average mouse is approximately 1” tall

• In six months, a mouse can eat about 2 pounds of food and produce some 9,000 droppings

• Average dropping is ¼” long