Instructions indicated on photo. Need answer with this.

Instruction on the given problems below, present an analysis using DMAIC approach. Derive your proposal on the given data, Elaborate the analysis including the use of IE tools. Problem. 20pts each DMAIC The Production Manager is complaining about the Machining Department's output. In spite of Supervisor's presence and with almost 100% workers' attendance (actual attendance 95%), and with ready stocks of materials in the warehouse, skillful workers, available machines and tools, still the Department haven't had met output based on the "available capacity". A request "study" was forwarded to Industrial Engineering Department. A review was conducted and collected the following data. A number of units were affected. To have a better perspective of the problem, the number of units affected were converted to number of lost hours on respective causes. 352 hours lost-due to quality defects, 105 hours lost-due to absenteeism, 150 hours lost- not following routings, 143 hours lost on un-updated references, 683 hours lost on unavailability of materials in the work station. Assuming yourself as an Industrial Engineer, you are required to present an analysis of this problem and have your proposed solutions