having issues with both industry sections

Capacity Analysis Capacity Analysis Being able to analyze plant and equipment (capacity and automation) is essential to understanding how you and your competitors are supplying the market demand. There is often unmet demand in segments because companies do not or cannot produce enough units. If you successfully analyze industry capacity, your team could benefit from these shortfalls. Each product has its own production line where you can set capacity and automation. Capacity represents the company's ability to produce units of its product. Think of capacity as your manufacturing plant. For each unit of capacity, there are two shifts of workers that can use your manufacturing plant to produce your products, which represents a first and second shift. So if your product has a capacity of 1000, this means you can produce up to 2000 units of your product. Automation represents the robot-to-worker ratio in your manufacturing plant. A higher ratio of robots will provide your company with a lower labor cost. However, this will increase the amount of time it takes your products to be updated. You will need: - The Production Analysis report (page 4) of the Capstone Courier for Round 0 On the Production Analysis page, look at the table of products (the Andrews company is displayed below). The highlighted boxes (plus a little math!) are where you will find the information you need to complete the analysis. 1112112010 145 moo mm 17.0 $21.00 0132012 . 12.0 moo W\" 15.5 mm M" 11.0 333.\") Production Costs Activity Use the table below with page 4 of the Courier to complete the activity. Production Costs Activity Use the table below with page 4 of the Courier to complete the activity. First Shift Capacity First and Second Automation Cost to Raise Automation to Cost to Double Capacity Shift Capacity Level 10 Found under Increasing capacity is $6 per Capacity Next Increasing automation is per Company "Capacity Next Round x 2 (shifts) unit with an adjustment for unit of capacity Round" Found under automation. "Automation Formula is: Total the capacity of Total capacity of Next Round" Formula is: First Shift Capacity x [$6 + First Shift Capacity x [$4 x Industry each product in that each product in that ($4 x automation level)] (10 - automation level)] segment segment X 2 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. Incomplete 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 Traditional Able 1800 10800 3600 21600 Incorrect value entered 43200 Low End Acre 1400 8400 2800 16800 5.0 36400 28000 High End Adam 900 1800 3.0 16200 25200 Performance Aft 600 1200 3.0 10800 16800 Size Agape 600 1200 3.0 10800 16800 The Round 0 Capstone Courier