Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 ContentMaterial for Final ProjectProblems in DL 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 and carton machine downtime reduction 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 in the appropriate rows of Column F For example if you choose to eliminate FG a and FG a you would place a in cells F and F 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 shifts. Your findings and conclusions will be summarized in the executive summary. All yellow boxes must be populated.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started