Answered step by step
Verified Expert Solution
Link Copied!

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 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.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cases In Financial Reporting

Authors: Ellen Engel, D. Eric Hirst, Mary Lea McAnally

7th Edition

1934319791, 9781934319796

More Books

Students also viewed these Finance questions