Question: Statement of Facts document in Content / Material for Final Project / Problems in D 2 L . There are three tabs in this workbook
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 and 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
