Review the attachments

Value-added, 12 minutes EXCEL FHPIME EX 12-6 Calculate lead time Oh]. 1 Flint Fabricators Inc. machines metal parts for the automotive industry. Under the traditional manufacturing approach, the parts are machined through two processes: milling and nishing. Parts are produced in batch sizes of 30 parts. A part requires 5 minutes in milling and 7 min- utes in nishing. The move time between the two operations for a complete batch is 5 minutes. Under the lean philosophy, the part is produced in a cell that includes both the milling and nishing operations. The operating time is unchanged; however, the batch size is reduced to 4 parts and the move time is eliminated. Determine the value-added, non-valueadded, and total lead times, and the valueadded ratio under the traditional and lean manufacturing methods. (Round percentages to one decimal place.) lCells with nong ray,r backgrounds are protected and cannot be edited. An asterisk [*] will appear to the right of an incorrect entry. Enter a zero in cells you would otherwise leave blank. Traditional Philosophy: ValueAdded HonValue Total Time Added Time Time Valueadded time Within hatch wait time More time Total Value-Added Time E Total Time = Value-Added Ratio Lean Hanufaeturin Philoso h Value-added time Within hatch wait time More time Total Value-Added Time E Total Time = Value-Added Ratio ES