{"id":36563,"date":"2018-06-26T22:25:02","date_gmt":"2018-06-26T15:25:02","guid":{"rendered":"https:\/\/bahtera.jp\/?p=36563"},"modified":"2023-01-03T07:57:06","modified_gmt":"2023-01-03T00:57:06","slug":"business-system-sub","status":"publish","type":"post","link":"https:\/\/bahtera.jp\/en\/business-system-sub\/","title":{"rendered":"Development of interface for production scheduler"},"content":{"rendered":"

Proposal of production scheduler operation method<\/h2>\n

In general, it is rare to done master maintenance or actual result input on the production scheduler, and normally maintenance of the master data to be used by the scheduler is done on the production control system side or the external DB, and the latest master data is imported at the time generating orders by production scheduler.<\/p>\n

When you issue a production order with the production control system, the generated order is imported as a production order. Howeverif you only input the actual results in the production control system, we will collect actual results on the external interface system and import this as production result.<\/p>\n

By processing the data accumulated on the production control system or the external DB side, it is possible to create a report on the load calculation and the forecast management, in order to convince Indonesian key person about the price and the validity of the introduction period , it is meaningful to extend the width of the function to the side to give a feeling of volume of service.<\/p>\n

Input interface<\/h2>\n

Although it is possible to generate a Integrated Master by integrating the Bill of Material, machine capability, standard load and unit quantity in production control system, but it is rare cases that these pieces of information are complete.<\/p>\n

When setting the machine capacity and the standard load of each item in production control system, the item and line at the time of pile creation calculation by MRP are a one-to-one relationship, and there is no meaning to set a load for an alternative line of a certain item<\/p>\n

\n
    \n
  1. Capacity of line in a day
    \n\u21d2Machine Capacity\uff0875,600 Sec\uff0fDay\uff09or\uff089,450 Pcs\uff0fDay\uff09or\uff0816 Hour\uff0fDay\uff09<\/li>\n
  2. Load per item by line
    \n\u21d2Production quantity by standard load\uff088 Sec\uff0f1 Pcs\uff09or\uff081 Sec\uff0f0.125 Pcs\uff09or\uff082000 Pcs\uff0f1 Hour\uff09<\/li>\n<\/ol>\n<\/div>\n

    In other words, in both the production scheduler and the production control system, need to set the cycle time for each item, which is the ratio of machine capacity and standard load for each combination of item and line.<\/p>\n

    However, in the production control system, since the combination of item and line applied in MRP is limited to only one, maintenance of machine capacity tends to be negligible and there are only a few cases where the data of the production control system can be directly interfaced without any adjustment.<\/p>\n

    Therefore, only the item information is interfaced from the production control system, and the machine information is managed by the external DB.<\/p>\n

    \"treeviewBOM\"<\/p>\n

    In the input interface, by merging the item information (input instruction) and resource information (use instruction) with the parent (item), child (item or resource), order type as the primary key, create integrated master of production scheduler.<\/p>\n

    The functions of the input interface are as follows.<\/p>\n

    \n
      \n
    1. Function to generate Integrated Master from BOM of production control system and machine information of external DB.<\/li>\n
    2. Additional master maintenance function such as machine information.<\/li>\n
    3. Function to reference, add, modify, and delete items and resources from the tree view.<\/li>\n
    4. Function to check looping<\/li>\n<\/ol>\n<\/div>\n

      It is aimed at improving work efficiency by visualizing the tree maintenance view on a web basis based on division of the master maintenance work that takes time, making it visible, and putting it in mutual monitoring status.<\/p>\n

      Result collection interface<\/h2>\n

      What is real time for?<\/h3>\n

      When there is a demand to “see progress situation in real time at production scheduler”, it is necessary to clarify real-time definition before that.<\/p>\n

      As an example of collecting actual results in real time, acquiring actual data counted by a sequencer and saved in a DB through an interface, scanning a barcode of an item tag with a barcode scanner and on and on.<\/p>\n

      On the other hand, it is an example of batch processing to input the daily work report into the system by 10 o’clock the next morning. but I am not sure whether it is batch or realtime to upload the results gathered by a batch scanner every hour for CSV .<\/p>\n

      In short, the difference between real-time and non-real-time is only the difference in the time interval from the timing when the processing is physically finished on the line to the timing when the actual result is reflected in the system.<\/p>\n

      If so, we should decide the best method after clarifying what we want to do by seeing “real-time progress”.<\/p>\n

      How to reflect process progress control in inventory control<\/h3>\n

      I think that the most simple way is to carry out process progress management on a production order basis at the production scheduler, and to reflect the results to inventory by importing the results into the production control system.<\/p>\n

        \n
      1. Actual results are entered into the production management system and actual results are input to the production order (with progress management)
        \nGenerate production order with production scheduler \u21d2 Import CSV from order detail list of production control system \u21d2 Collect actual results in real time \u21d2 Import manufacturing results into production scheduler<\/li>\n
      2. The actual results are entered into the production control system, but the actual results are entered per item (with progress management)
        \nGenerate production order at production scheduler \u21d2 CSV import from production detail management order \u21d2 Collect actual results in real time \u21d2 Allocate actual of day, line and item units in order of production order \u21d2 Import manufacturing results into production scheduler<\/li>\n
      3. The actual results are entered into the production control system, but the actual results are entered in item units (without progress management)
        \nGenerate production order at production scheduler \u21d2 CSV import from production detail management order \u21d2 Collect actual results in real time \u21d2 Allocate actual of day, line and item units in order of production order \u21d2 Import manufacturing results into production scheduler.<\/li>\n
      4. The actual results are input to the production scheduler and uploaded to the production control system (with progress management)
        \nProduction order generated by production scheduler \u21d2 Collect actual results in real time \u21d2 CSV import from Manufacturing result without plan of production control system.<\/li>\n<\/ol>\n

        Functions of result collection interface<\/h3>\n

        Functions to be included in result collection interface are as follows.<\/p>\n

        \n
          \n
        1. Input actual result to production order (with progress management).<\/li>\n
        2. Allocate the results of the day, the line, and the item unit in the order of the production order (with progress management).<\/li>\n
        3. Import results of day, line and item unit as inventory order (no progress management).<\/li>\n
        4. Function to convert actual results into CSV and I \/ F to the production control system.<\/li>\n
        5. Function to enter actual results with cable type bar code scanner<\/li>\n
        6. A function to import a CSV file acquired from a batch type barcode scanner.<\/li>\n<\/ol>\n<\/div>\n

          It is difficult to ask to input actual result on the production order at the manufacturing site where there is no culture to report actual result in the production order, so the result of the item unit is allocated to the production order by the system and the order. It will prevent you from getting bad impressions from taking the time to collect results from the beginning of operation.<\/p>\n

          Output interface<\/h2>\n

          We will manage the batch using the actual item slip in order to record the production results on production order by the production scheduler and reflect the process progress management at the production scheduler in the inventory management of the production control system, It is necessary to have an output interface that can easily execute functions such as issuance.<\/p>\n

          Reissue of actual item label at lot division<\/h3>\n

          In order to scan a barcode with a barcode scanner, it is necessary to output production order on which a barcode is printed, but the problem are processing when the lot (or palette) is divided.<\/p>\n

          In the case of lot integration, since the two production orders on the system move together in one place on the field, the system does not do anything and it can flow with 2 pieces of actual item label and input results separately. However, in the case of lot division, it is necessary to issue newly since the physical item label is required two pieces.<\/p>\n

          We will implement the method of issuing an item label of this divided lot as a derivative function of the reissue function of the existing lot. In other words, if you set the radio button “Normal \/ Divide” on the issue slip issued screen retrieved by lot number, and if division is selected, execute derivation process of reissue.<\/p>\n

          \n
            \n
          1. Quantity is blank, lot number (branch numbering) \u30fb item \u30fb scheduled start date \u30fb line name is usually<\/li>\n
          2. Quantity is blank, lot number \u30fb item \u30fb scheduled start date \u30fb line name is normal<\/li>\n
          3. Lot number and quantity are blank, item \u30fb scheduled start date \u30fb line name is normal<\/li>\n
          4. Issuing a complete empty slip and entering by handwriting<\/li>\n<\/ol>\n<\/div>\n

            Actual quantity of divided lot is updated by time series on actual production quantity by production order or by actual quantity (addition). Because integration and division of lots are caused by situations in the field, it is impossible to divide and feed back the production order of the system every time it occurs, so we have the goal of process progress management and inventory management at the beginning of planning.<\/p>\n

            Replacement of actual item label when the lot of the previous process and the next process are different<\/h3>\n

            Since the lot size is different between the molding or pressing process which is the previous process and ASSY or welding which is the next process, it is necessary to replace the actual item label and the function of the subsystem which can be issued at any time by item and lot is necessary. However, if you do not make it distinguish whether it is already issued or the first issue, the actual lot of the same lot will be inundated at the site.<\/p>\n

            Output Report Type<\/h3>\n

            If you have the following as a management report to be packaged in the output interface, I think that it is enough in the sense that “Expanding the volume of service by expanding the width of the feature” at the time of pre-sales.<\/p>\n

            \n
              \n
            1. Manufacturing Order or Actual Item Label\uff08Operation\uff09<\/li>\n
            2. Daily Production Plan by Line\uff08Operation\uff09<\/li>\n
            3. Monthly Production Plan by Item and Line\uff08Information\uff09<\/li>\n
            4. Daily Production Comparison List\uff08Inpormation\uff09<\/li>\n
            5. Occupancy Rate Comparison List by Line\uff08Information\uff09<\/li>\n<\/ol>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

              Here considering the subsystem of the production scheduler, there are three types of the interface developed for improving the usability, input interface that integrates the existing master and the additional master, result collection interface by the bar code scanner or handy terminal, and output interface for output such as production orders and availability forecast comparison tables.<\/p>\n

              When proposing a production scheduler, it is more important how a customer can draw an operation story than a functional explanation, so the three interfaces are very effective in proposing an operation story at a manufacturing site in Indonesia.<\/p>\n","protected":false},"author":2,"featured_media":81120,"parent":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[619],"tags":[],"class_list":["post-36563","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-production-scheduler"],"_links":{"self":[{"href":"https:\/\/bahtera.jp\/en\/wp-json\/wp\/v2\/posts\/36563","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bahtera.jp\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bahtera.jp\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bahtera.jp\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bahtera.jp\/en\/wp-json\/wp\/v2\/comments?post=36563"}],"version-history":[{"count":0,"href":"https:\/\/bahtera.jp\/en\/wp-json\/wp\/v2\/posts\/36563\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bahtera.jp\/en\/wp-json\/wp\/v2\/media\/81120"}],"wp:attachment":[{"href":"https:\/\/bahtera.jp\/en\/wp-json\/wp\/v2\/media?parent=36563"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bahtera.jp\/en\/wp-json\/wp\/v2\/categories?post=36563"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bahtera.jp\/en\/wp-json\/wp\/v2\/tags?post=36563"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}