Production Costs Activity

In the table below, the first two sections have two columns Company and Industry for each segment. These are for the raw plant capacity and the maximum capacity of each product and segment. Automation Level is the product line automation and the last two sections are to calculate the costs of plant improvements, in this case doubling capacity and maximizing automation. How to complete the table using the Production Analysis page of the FastTrack

	First Shift Capacity	First and Second Shift Capacity	Automation Level	Cost to Double Capacity	Cost to Raise Automation to 10
Company	Found under "Capacity Next Round"	Capacity Next Round x 2 (shifts)	Found under "Automation Next Round"	Increasing capacity is $6 per unit with an adjustment for automation.	Increasing automation is per unit of capacity
Industry	Total the capacity of each product in that segment	Total capacity of each product in that segment X 2		Formula is: First Shift Capacity x [$6 + ($4 x automation level)] Example Input: 500	Formula is: First Shift Capacity x [$4 x (10 - automation level)] Example Input: 700

* In the simulation, the input cells are in thousands (000s), 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 Name	First Shift Capacity		First & Second Shift Capacity		Automation Level	Cost to Double Capacity	Cost to Raise Automation to 10.0
	Company	Industry	Company	Industry

I'm trying to figure out what the first shift capacity is for the company and the industry. The first and second shift capacity for the both the company and the industry. and the cost of double capacity . And the cost to raise automation to 10.0?

Name Primary Segment Units Sold Unit Inven tory Revision Date Age Dec.31 MTBF Pfmn Coord Size Coord Price Material Cost Labor Cost Contr. Marg. 2nd Shift & Overtime Auto mation Next Round Capacity Next Round Plant Utiliz.

Name Primary Segment Units Sold Unit Inven tory Revision Date Age Dec.31 MTBF Pfmn Coord Size Coord Price Material Cost Labor Cost Contr. Marg. 2nd Shift & Overtime Auto mation Next Round Capacity Next Round Plant Utiliz.