Production costs activity use the table below with page 4 of the fasttrack to complete the activity. 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 (‘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 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 eat 800 1304 1600 0 3 14400