Read the Komtek case and then compute the cost of scrap for the Zimmer order using the attached Excel solution template. Note that the rows 1 through 160 represent sequential operation steps. Also, the case indicates at what operation steps units are scrapped.

Help needed

Thank you!

Exhibit 2 The Process \begin{tabular}{|c|l|l|c|c|} \hline OperationNo. & \multicolumn{1}{|c|}{ Description } & \multicolumn{1}{|c|}{ Comments } & SetupTime(mins) & RunTime(mins) \\ \hline 1 & Kitup & Release work order to floor & & 0.3 \\ \hline 10 & Abrasive Cutting & Cut bars to length & 18 & 1.002 \\ \hline 15 & Grind Slugs & Grind off sharp edge of bar & & 1.002 \\ \hline 20 & Wheelabrate & Clean bars before coating & & 0.402 \\ \hline 30 & Coat Slugs & Coat slugs for extrusion & & 0.6 \\ \hline 40 & Extrude & Extrude & 120 & 1.5 \\ \hline 50 & Wheelabrate & Clean before forging & & 0.402 \\ \hline 60 & Forge & Forge in tolerance per print & 150 & 1.5 \\ \hline 65 & Helper & Helphammermaninlubrication,flashremoval & 150 & 3 \\ \hline 80 & Alox 90 & Cleaning process & & 1.5 \\ \hline 90 & Staging for Inspection & Parts waiting for inspection & & 0.3 \\ \hline 100 & Visual & 100% inspection & & 1.002 \\ \hline 103 & Parting line sample & Grindsample(10%)ofpartsforlinecracks & 120 & \\ \hline 105 & Deburr & Rework marked indications & & 4.998 \\ \hline 110 & Hot Coin & HC parts into tol. per print & 120 & 1.5 \\ \hline 111 & Tensile testing & Test 2 pieces per heat for tensile & & \\ \hline 115 & Straighten & Check straightness per print, 100% & & 2.4 \\ \hline 120 & Chem Polish & Outside service & & \\ \hline 130 & Cleaning & Outside service & & \\ \hline 140 & NDT Facility & Non destructive testing 100\% & & 4.998 \\ \hline 150 & Quality Control & Acceptable Quality Level (AQL) & 120 & \\ \hline 160 & Final Prep & Package and Ship & & \\ \hline \end{tabular} Exhibit 3 Work Order Review (for week ending 8/29/97) Exhibit 4 Material Review Exhibit 5 Standard Costs and Zimmer Order Costs Material. Die and Toolind Costs Die, Forge, and Bxtrusion Tooling costs are based on 1000 pieces Tensile Testing Costs $250 for 2 pieces Exhibit 6 Komtek Cost of Scrap Estimate Team Names: Exhibit 2 The Process \begin{tabular}{|c|l|l|c|c|} \hline OperationNo. & \multicolumn{1}{|c|}{ Description } & \multicolumn{1}{|c|}{ Comments } & SetupTime(mins) & RunTime(mins) \\ \hline 1 & Kitup & Release work order to floor & & 0.3 \\ \hline 10 & Abrasive Cutting & Cut bars to length & 18 & 1.002 \\ \hline 15 & Grind Slugs & Grind off sharp edge of bar & & 1.002 \\ \hline 20 & Wheelabrate & Clean bars before coating & & 0.402 \\ \hline 30 & Coat Slugs & Coat slugs for extrusion & & 0.6 \\ \hline 40 & Extrude & Extrude & 120 & 1.5 \\ \hline 50 & Wheelabrate & Clean before forging & & 0.402 \\ \hline 60 & Forge & Forge in tolerance per print & 150 & 1.5 \\ \hline 65 & Helper & Helphammermaninlubrication,flashremoval & 150 & 3 \\ \hline 80 & Alox 90 & Cleaning process & & 1.5 \\ \hline 90 & Staging for Inspection & Parts waiting for inspection & & 0.3 \\ \hline 100 & Visual & 100% inspection & & 1.002 \\ \hline 103 & Parting line sample & Grindsample(10%)ofpartsforlinecracks & 120 & \\ \hline 105 & Deburr & Rework marked indications & & 4.998 \\ \hline 110 & Hot Coin & HC parts into tol. per print & 120 & 1.5 \\ \hline 111 & Tensile testing & Test 2 pieces per heat for tensile & & \\ \hline 115 & Straighten & Check straightness per print, 100% & & 2.4 \\ \hline 120 & Chem Polish & Outside service & & \\ \hline 130 & Cleaning & Outside service & & \\ \hline 140 & NDT Facility & Non destructive testing 100\% & & 4.998 \\ \hline 150 & Quality Control & Acceptable Quality Level (AQL) & 120 & \\ \hline 160 & Final Prep & Package and Ship & & \\ \hline \end{tabular} Exhibit 3 Work Order Review (for week ending 8/29/97) Exhibit 4 Material Review Exhibit 5 Standard Costs and Zimmer Order Costs Material. Die and Toolind Costs Die, Forge, and Bxtrusion Tooling costs are based on 1000 pieces Tensile Testing Costs $250 for 2 pieces Exhibit 6 Komtek Cost of Scrap Estimate Team Names