Help With Capacity Planner Tool Excel ??

Hi,

I am looking for some help with an Excel Model that I want to create -

The basic concept is to calculate the -> order volumes - Month & Daily Take an Average and define what resource is required based on the times for the product manufacture.

It would then calculate the potential output possible based on the staff level, and the times entered.

Does anyone know if this is possible?

Any help would be greatly appreciated,
Thanks.
JL682