I need help solving the industry section for the first, and second shift capacity.

?

Capacity Analysis Product First Shift First & Second Automation Cost to Double Cost to Raise Segment Name Capacity Shift Capacity Level Capacity Automation to 10.0 Company Industry Company Industry 46800 Low End 'Dell ] [1400 ] |o ] |2soo ] i | '5 | '36400 I '28000 ] High End 'Dixie ] [900 y i y \\1800 y i y '3 1 '16200 y \\25200 ] Performance Dot 600 1200 3 10800 16800 First Shift Capacity First and Second Automation Cost to Raise Automation to Shift Capacity Level Cost to Double Capacity 10 Found under Increasing capacity is $6 per Company "Capacity Next Capacity Next unit with an adjustment for Increasing automation is per Round" Round x 2 (shifts) unit of capacity Found under automation. "Automation Total the capacity of Total capacity of Next Round" Formula is: Formula is: Industry each product in that each product in that First Shift Capacity x [$6 + First Shift Capacity x [$4 x segment segment X 2 ($4 x automation level)] (10 - automation level)] Example Input: 500 Example Input: 700 *In the simulation, the input cells are in thousands ('000's), so an input of 1 is actually 1000 units. So, in the example below 500,000 units is inputted as 500 in the cell. This applies to dollar values as well.