Established in 2002 t-shirts dotcom website has rapidly become the place to find, order and save on T-shirts. One enormous selling factor is that the company manufactures its own T-shirts. Though the quality manager for the production plant, Kasey Harnish has noticed an intolerable number of defective T-shirts being produced. You have been borrowed to assist Kasey in understanding where the problems are concentrated. He proposes using a PivotTable to perform an analysis and has provided you with a data file T3_TshirtProduction_Data.xls, your solution should contain at least one Pivot table. Your proposal for this assignment will consist of two files uploaded to the dropbox for the assignment-

(a) One will be your assignment spreadsheet containing the worksheets you have used to solve this problem (pivot tables, auto filters, custom auto filters & conditional formatting).

(b) The second file will be a one page Word document in which you communicate your solution to this problem as well as in which you reference the worksheets you created in order to justify your answers