Can you give an example of the actual values, and the results you would like
to see?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Will" wrote in message
ups.com...
I am trying to create a formula that can determine equipment capacity.

A1 = Seconds/Per Shift Avail.
A2 = Number of Shifts Scheduled
A3 = Number of Days Scheduled
B1 = Part A Annual Volume
B2 = Part B Annual Volume
B3 = Part C Annual Volume
C1 = Part A Cycle Time
C2 = Part B Cycle Time
C3 = Part C Cycle Time

I am just beginning to learn formulas in Excel and I am able to
determine the capacity for one Part. The problem is combining
multiple cycle times to determine capacity. Thanks in advance for the
help.