View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Will[_12_] Will[_12_] is offline
external usenet poster
 
Posts: 2
Default 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.