Question: please help with the last four red numbers in the table Shift mation Next Round Name Able Primary Segment Trad Low High Pim Size Units

please help with the last four red numbers in the

please help with the last four red numbers in the table

Shift mation Next Round Name Able Primary Segment Trad Low High Pim Size Units Sold 999 1.763 Unit Inven Age Pim Size tory_Revision DateDec.31 MTBF CoordCoordPrice 189 11/21/2010 3.1 17500 5.5 14.5 $28.00 5/25/2009 4.6 14000 3.0 17.0 $21.00 4/18/2012 1.7 23000 8.0 12.0 $38.00 78 6/30/2011 25 25000 9.4 15.5 $33.00 62 5/25/2011 26 19000 4 0 110 $33.00 Material Labor Contr. Over- Cost_CostMargtime $11.59 $7.49 2 9% 0% $7.81 $7.12 27% $15.98 $8.57 33% $15.87 $8.57 8.57 23% $13.62 $8.57 30% Capacity Next Plant Round Utiliz. 1,800 66% 1,400 129% 900 45% 600 73% 600 63% Adam 358 314 Agape Production Costs Activity Use the table below with page 4 of the Courier 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) Increasing capacity is $6 per unit with an adjustment for automation. Increasing automation is per unit of capacity Found under "Automation Next Round" 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 Cost to Double Capacity Cost to Raise Automation to 10.0 Capacity Analysis Product First Shift Segment Name Capacity Company Industry Traditional Able 1800 10800 Low End Acre 1400 8400 High End Adam 900 5400 Performance Aft 600 3600 Size Agape 6003600 First & Second Automation Shift Capacity Level Company Industry 3600 21600 4 2800 16800 1 800 10800 3 1200 7200 3 120072003 The Round 0 Capstone Courier

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!