Finite capacity Loading - Investigation Processing-
Optional Columns - Input Spreadsheet
to get a more accurate view you can provide more data in optional columns.
If you are providing a specific optional column, then all the columns before it must exist, but they can be blank if you wish.
| . | . | <<< required columns | G | H | I | >>> more optional columns | . | . | . | |
| 1 | . | . | . | SKU | Quantity | Quantity Unit of Measure | . | . | . | . |
| 2 | . | . | . | . | 100.00 | KG | . | . | . | . |
| 3 | . | . | . | 18GUH-36K | 1 | EA | . | . | . | . |
| G. Optional. Stock Keeping Unit, or Part Number, or Item,,, | H. Optional. Quantity that will be made. | I. Optional. Unit of measure for recording purposes. (For counts at this production step. If unit of measure is different at different steps for the same batch, lot, job,,, then a conversion between units should be supplied. refer Output Quantity Unit of Measure ) |
| . | . | <<< required columns | J | K | L | >>> more optional columns | . | . | . | |
| 1 | . | . | . | Resource Units | Min. Not Overlap Hrs. | Min. Not Overlap Quan. | . | . | . | . |
| 2 | . | . | . | 1>5,7 | 0.5 | 25 | . | . | . | . |
| 3 | . | . | . | . | . | . | . | . | . | . |
| J. Optional. If the resource has several processing units, you can designate which are usable for this run. 1>4 (or 1-4) means any of 1 2 3 or 4 can be used. The processor will work out how many processing units are needed, and try to balance the load among them. It can find out for you if any processing units are to be capacity bottlenecks. | K. Optional. Time before a move to the next operation. | L. Optional. Quantity to be made before a move to next operation. If time and quantity before move are both blank, there will be no overlapping. If time and quantity are both supplied, then the greater will be used. If the value is zero (not blank) then full overlapping applies. |