Basic.WorkCentersAndSkus is the most important worksheet in the Basic group. It relates SKUs produced on various Work Centers/Production Lines to Production Rates, Production Efficiencies, and Minimum Production Lot sizes. Information on this worksheet is used to generate the rest of the tables in the Basic group as well as the Main.RollingPlan template. For example, SKU IDs and SKU Descriptions are used to create Basic.Demand, Basic.OpenStocks, and Basic.Param tables while the list of Work Centers/Production Lines serves as a basis for building the Basic.WorkCentersConstraints table.
Generally speaking, Basic.WorkCentersAndSkus table is a simplified description of what is produced in your workshop/factory/company, and how it is produced. For instance, if you have several Work Centers/Production Lines installed in your plant, you certainly know what SKUs can be manufactured on each of them. You are also aware how many pieces (or kilos) per hour (or minute) of each SKU can be made on each of your Work Centers/Production Lines, and what the Minimum Production Lots Sizes are. You can also tell the values of Production Efficiencies for every SKU on each Work Center/Production Line. The Basic.WorkCentersAndSkus worksheet organizes all this information in a straightforward structure.
1. Work Center. Alphanumeric Unicode values. In this column you enter the names of your Work Centers/Production Lines.
2. SKU ID. Alphanumeric Unicode values. In this column you fill in SKU IDs of the products manufactured on each Work Center/Production Line. Normally, most of the ERP systems use SKU IDs as keys in their Material Master tables. This kind of data fields are also called “material codes”, “part numbers”, etc.
3. SKU Description. Alphanumeric Unicode values. In this column you enter product names corresponding to various SKU IDs.
4. Rate. Numeric positive values. The maximal number of pieces, kilos, etc. a given Work Center/Production line can produce per unit of time (hours, minutes, etc.). It is not mandatory to enter integer numbers here. Values like 123.456 (units per hour) are perfectly acceptable.
5. Efficiency. Numeric values between 0 and 1. This coefficient shows what fraction of the possible production of a given SKU manufactured on a particular Work Center/Production Line per unit of time can be utilized. Although, it is not 100% theoretically correct, this coefficient provides the means to account for things like change-overs and set up times. It does not make much sense to enter zeroes in this column, unless you want to show that production of a given SKU on a particular Work Center/Production Line is blocked.
6. Index. Numeric values. This field should be left blank.
7. Minimum Lot. Numeric positive values. Automated Planning can calculate Planned Quantities in multiples of predefined Minimum Lot Sizes. If you would like to take advantage of this option, fill in this column. Otherwise, it could be left blank.
Common mistakes that may cause troubles later on.
1. Missing Work Center/Production Line. This column contains values which are used as keys to retrieve information from the table as well as to build Main.RollingPlan, and Basic.WorkCenetersConstraints templates. Blanks in this column may lead to undesirable results during generation of the planning grid in the Main.RollingPlan worksheet.
2. Missing SKU ID. This column also contains key values which are used to pull out information from this table. SKU IDs also provide the foundation for building Basic.Demand, Basic.OpenStocks, and Basic.Param tables as well as the Main.RollingPlan template.
3. Missing SKU description. In order to avoid confusions, it is good to give descriptions to all SKU IDs.
4. Same SKU ID with different SKU Descriptions. SKUs remain the same even if they are produced on different Production Lines. It makes sense to keep same descriptions for the same SKU IDs.
5. Different SKU IDs with same SKU Description. If a certain SKU is given a SKU ID, it is supposed to be in some way different from the rest of the SKUs. If it is different from the rest of the SKUs, it is supposed to have a different name.
6. Negative, missing, or non-numerical Rate. Production Rates are used to calculate Required Times to produce various SKUs on your Work Centers/Production Lines. Calculations will lead to reasonable results, only if positive numbers are entered in this column.
7. Negative, missing, or non-numerical Efficiency. This parameter is also used to calculate Required Times to produce. Negative, missing, or non-numerical values may lead to erroneous calculations.
8. Negative, missing, or non-numerical Minimum Lot. In case, you intend to use Automated Planning to calculate Planned Quantities as multiples of Minimum Lot Sizes, enter positive values greater than zero for the corresponding combinations of Work Centers/Production Lines, and SKU IDs in this column.
9. Any possible combination of above.
1. Build Template. This function clears completely the worksheet area and places column headers on the second row in accordance with the formats defined in the Dictionary.
2. Clear. This function clears all the data from the table, but leaves column headers untouched. Microsoft Excel® Undo function will have no effect after Clear.
Like in the rest of the worksheets of the Basic group, Basic.WorkCentersAndSkus’ column headers can be customized by changing the contents, and the formats of the corresponding cells in the Dictionary, or by using standard Microsoft Excel® formatting techniques.
You can use regular Microsoft Excel® cell formatting to give the area around column headers the look you like.
Important things to remember.
- Basic.WorkCentersAndSkus is the most important worksheet in the Basic group. It must be properly filled out in order to ensure proper operation of the rolingPlan tool as a whole.
- No blanks or gaps must be left in the table, especially in Work Center, SKU ID, and SKU Description columns.
- Column headers can be customized by changing the contents, and the formats of the corresponding cells in the Dictionary.
- Microsoft Excel® Undo function will have no effect after Clear.