[AccessD] planning

Hi all
I've been asked to investigate whether Access or Excel is a  suitable tool to 
develop a production capacity calculator.  As I know sweet  nothing about 
production capacity calculations I wondered whether anyone on  this list has 
experience in using Access for production capacity  calculations.
 
What I mean about  production capacity calculations is: You have so  many 
machines with so many people and so much time and material, how many units  of 
production can I make.
 
TIA
 
john c