Definition

Shoe factories find themselves in some moment to produce more sku (models) with smaller quantities of each one, because of fashion colors, seasoning, customers testing products, personlization, and the have to keep their cost at same level than before.

This app defines how many production lines the factory should use to descrease the variation of requiered time and operators of the models they manufacture in each production line and assign the correct models to each production line.

Using a database that show the time required of each kind of machine, or operator you can make an hclust analisis and define how many lines to define for decreasing the range of time required to produce them.

The analisis require the following information - Database with sku in the first column and all the operators required to produce in the next columns (like the example)

  SKU BENDING STITCHING PRE.STITCHING
1 A-1      56       443          1097
2 A-2      44       150          1027
3 A-3      96       285           767

• Use the dendogram showed in the analysis to define how many lines.
• Review the analysis and download the final assignment.

The analysis includes 5 tab.

1. Information loaded Confirms to user the information loaded, allows to define headers or not.
2. Statistics Shows menas deviations and ranges for each operators
3. Production lines Shows a dendogram and ask the user to define how many production lines to define using the plot
4. Asigned products Show the final table of skus asssigned to each production line
5. Final analisis
   • Shows final deviations and ranges
   • Calculate the general improvement of the analysis

This app is actually being used by shoe factories to define their production lines and to assing models to different factories, so they keep only the models that fits their production standards and search for factories to do the others.

It also helping the development deparments to optimize the amount of work a shoe have of each different operators and machines so the can build them in a different way, put more details in some operators and remove from others.

An online app for this analysis can be found in: Shiny App

A sample database can be found in the repo of the assignment here