70.2K

Verified Solution

Link Copied!

The 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 D$2$L$.$ 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\mathrm{.}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 $1080$a and FG $1081$a you would place a $0$ in cells F$46$ 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.

Answer & Explanation Solved by verified expert

See Answer