he goal of this portion of the assignment is to conduct an SKU rationalization to address the capacity issue from the Statement of Facts document in Content/Material for Final Project/Problems in D2L. There are three tabs in this workbook that will be used. Finished goods Before, FG after productivity improve, and FG after SKU. You will need to conduct an analysis of the Finished goods Before and determine which if any of the SKUs are candidates to be eliminated. I would sort the data provided by cases from highest to lowest before starting on the rationalization. All the yellow boxes on Finished goods Before must be populated. Highlight the SKUs you are considering for elimination in red. On the FG after productivity improve tab you will adjust the numbers in columns D and H to reflect the increased productivity from the results of your ABC analysis (reduces downtime 2.5%) and carton machine downtime reduction (2%) project. All yellow boxes must be populated. Again I would sort by Cases. Totals for Cases and Productivity in Finished Goods After should all be higher than the original numbers. On the FG after SKU tab:To remove the skus from the final calculations place a 0 in the appropriate rows of Column F. For example if you choose to eliminate FG 1080a and FG 1081a you would place a 0 in cells F46 and F 47. Hint: These are the first two I would eliminate. By removing SKUS from the calculation you will have additional cases available to add to some of the remaining skus to get back tp 2000 shifts. Your findings and conclusions will be summarized in the executive summary. All yellow boxes must be populated.