Need Help: Determine Equipment Capacity
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.
|