CM Automation analysis answer

Anonymous
timer Asked: Nov 21st, 2016

Question description

Based on file information, (answer for all your company's products)? Record your answer here in the text block.

a. Regarding inventory

b. Regarding automation

c. Regarding unit volume goals

Name Able A_Low A_High Primary Segment Low Low Units Sold Unit Inventory Revision Date Age Dec.31 MTBF 951 0 11/21/2013 5.1 21000 726 0 3/8/2018 0.8 15000 0 0 6/6/2019 0 0 Baker Low 1,500 0 3/11/2018 2 17900 Cake Cupcak Low High 1,581 129 0 0 4/7/2018 3/7/2018 2.9 20000 0.8 17000 Daze Dragon Low High 1,386 249 0 0 10/1/2018 5/14/2018 1.7 20000 0.6 19500 Eat Eight High 1,002 0 781 0 11/14/2018 5/1/2019 1.6 21000 0 0 Fast Fbb High High 1,263 423 321 0 9/25/2018 6/17/2018 1.7 23000 0.5 23000 1 2 3 2nd Shift & Pfmn Coord Size Coord Price Material Cost Labor Cost Contr. Marg. Over-time 6.4 13.6 $32.00 $13.39 $11.55 20% 92% 5.3 15 $33.00 $8.99 $13.10 32% 100% 0 0 $0.00 $0.00 $0.00 0% 0% 6 14.2 $35.00 $11.42 $11.28 34% 74% 4.8 7.4 15.2 12.6 $35.00 $45.00 $9.75 $14.27 $11.11 $14.58 36% 35% 60% 100% 6.3 8.1 13.7 11.9 $35.00 $45.50 $12.88 $16.48 $10.61 $13.09 36% 34% 75% 100% 8.7 0 11.7 0 $44.00 $0.00 $17.77 $0.00 $10.18 $0.00 34% 0% 100% 0% 8.5 8.2 11.5 11.8 $42.00 $38.00 $18.36 $17.74 $11.65 $12.37 28% 20% 100% 100% Automation Next Round Capacity Next Round Plant Utiliz. 3 500 190% 4 800 161% 2 325 0% Unit MTL + Labor $24.94 $22.09 $0.00 Unit Carry $ $ 2.99 $ 2.65 $ - Total Carry $K $ $ $ - 3 997 172% $22.70 $ 2.72 $ - 4 6 1,000 80 158% 162% $20.86 $ $28.85 $ 2.50 $ 3.46 $ - 4.5 2.5 900 400 173% 124% $23.49 $ $29.57 $ 2.82 $ 3.55 $ - 5 2 1,100 400 198% 0% $27.95 $ $0.00 $ 3.35 $ $ 2,619.47 - 5 6 900 500 198% 106% $30.01 $ $30.11 $ 3.60 $ 3.61 $ 1,155.99 - CM $ Impact of Cost ($K) to Add Annual Unit Fixed Unit Labor Carry Cost on One Unit of Depreciation Cost Cost Each Sold Unit CM % Impact Automation ($K) Increment Savings $0.00 0.0% $2,000 $133 $0.14 $1.16 $0.00 0.0% $3,200 $213 $0.29 $1.31 #DIV/0! #DIV/0! $1,300 $87 #DIV/0! $0.00 $0.00 0.0% $3,988 $266 $0.18 $1.13 $0.00 $0.00 0.0% 0.0% $4,000 $320 $267 $21 $0.17 $0.17 $1.11 $1.46 $0.00 $0.00 0.0% 0.0% $3,600 $1,600 $240 $107 $0.17 $0.43 $1.06 $1.31 $2.61 5.9% #DIV/0! $4,400 $1,600 $293 $107 $0.29 #DIV/0! $1.02 $0.00 $0.92 $0.00 2.2% 0.0% $3,600 $2,000 $240 $133 $0.19 $0.32 $1.17 $1.24 #DIV/0! BEU for BEU for annual CM % total cost cost (K Impact (K units) units) 3.6% 1731.6 115.4 4.0% 2442.7 162.8 #DIV/0! #DIV/0! #DIV/0! BE Years BE Years assuming at last market Market year's growth growth volume rate rate 0.1 0.1 10.0% 0.2 0.2 10.0% #DIV/0! #DIV/0! A1 Volume A2 1046 799 0 1151 878 0 3.2% 3535.5 235.7 0.2 0.1 10.0% 1650 1815 3.2% 3.2% 3600.4 219.5 240.0 14.6 0.2 0.1 0.1 0.1 10.0% 20.0% 1739 155 1913 186 3.0% 2.9% 3393.0 1222.3 226.2 81.5 0.2 0.3 0.1 0.3 10.0% 20.0% 1525 299 1677 359 2.3% #DIV/0! 4322.2 #DIV/0! 288.1 #DIV/0! 0.3 #DIV/0! 0.2 #DIV/0! 20.0% 1202 0 1443 0 2.8% 3.3% 3090.1 1616.8 206.0 107.8 0.2 0.3 0.1 0.2 20.0% 20.0% 1516 508 1819 609 A3 A4 A5 A6 A1 CM $ Increment A2 A3 $1,208.25 $1,329.07 $1,461.98 $1,046.17 $1,150.78 $1,265.86 $0.00 $0.00 $0.00 1266 966 0 1392 1063 0 1532 1169 0 1685 1286 0 1997 2196 2416 2657 $1,861.20 $2,047.32 $2,252.05 2104 223 2315 267 2546 321 2801 385 $1,932.14 $225.70 $2,125.35 $270.84 $2,337.89 $325.01 1845 430 2029 516 2232 620 2455 744 $1,617.60 $391.13 $1,779.36 $469.36 $1,957.30 $563.23 1731 0 2078 0 2493 0 2992 0 $1,224.04 $0.00 $1,468.85 $0.00 $1,762.62 $0.00 2182 731 2619 877 3143 1053 3771 1263 $1,765.67 $627.90 $2,118.81 $753.48 $2,542.57 $904.18 Cumulative CM $ A4 A5 A6 Increment $1,608.17 $1,768.99 $1,945.89 $9,322.35 $1,392.45 $1,531.69 $1,684.86 $8,071.81 $0.00 $0.00 $0.00 $0.00 $2,477.26 $2,724.98 $2,997.48 $14,360.29 $2,571.68 $390.01 $2,828.85 $468.01 $3,111.73 $561.61 $14,907.64 $2,241.17 $2,153.03 $675.87 $2,368.33 $811.05 $2,605.16 $973.25 $12,480.78 $3,883.88 $2,115.15 $0.00 $2,538.18 $0.00 $3,045.81 $0.00 $12,154.65 $0.00 $3,051.08 $1,085.01 $3,661.30 $1,302.02 $4,393.56 $1,562.42 $17,533.00 $6,235.01

Tutor Answer

(Top Tutor) Studypool Tutor
School: Rice University
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors