Work support device, work support method and work support program
Patent Information
- Application Number
- JP2023133186
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2023-08-18
- Publication Date
- 2025-03-03
AI Technical Summary
【0010】 本発明は、受注した商品の材料の発注又は加工依頼等を行うための手配データの作成業務を支援して、担当者の負担を軽減できる。
Smart Images

Figure 2025028388000001_ABST
Abstract
Description
[Technical field]
[0001] The present invention relates to a business support device, a business support method, and a business support program. [Background technology]
[0002] The computer system for mediating made-to-order production of goods disclosed in Patent Document 1 (JP Patent Publication 2019-215834 A) includes a processor capable of communicating with a second computer system for electronically trading goods. The processor receives order data for the goods from the second computer system, the order data including information for identifying the quantity of the goods.
[0003] The processor unit also determines whether the total quantity or the change in the quantity of the products exceeds a predetermined threshold based on information for identifying the quantity of the products included in the order data. If the processor unit determines that the total quantity or the change in the quantity of the products exceeds the predetermined threshold, the processor unit executes an order process for the products to be produced. This makes it possible to mediate the production of products on an order basis. [Prior art documents] [Patent documents]
[0004] [Patent Document 1] JP 2019-215834 A Summary of the Invention [Problem to be solved by the invention]
[0005] However, in the past, it was necessary to manually create procurement data for ordering materials or requesting processing of the ordered products, which placed a burden on the person in charge.
[0006] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a business support device, a business support method, and a business support program that support the creation of arrangement data for ordering materials or requesting processing of ordered products, thereby reducing the burden on staff. [Means for solving the problem]
[0007] In order to solve the above-mentioned problems and achieve the objective, the business support device of the present invention has a calculation unit that refers to a memory unit in which materials and required quantities for each product characteristic required to manufacture a product are stored, based on the characteristics and production quantity of a specified product, and calculates the required quantity of materials required to manufacture a specified number of products with the specified characteristics, a data generation unit that generates arrangement data including the calculated required quantity of materials and an arrangement category indicating the content of a request to arrange for materials, and an output control unit that controls the output of the generated arrangement data to an external device.
[0008] In addition, in order to solve the above-mentioned problems and achieve the objective, the business support method of the present invention includes a calculation step in which a calculation unit refers to a memory unit in which materials and required quantities for each product characteristic required to manufacture the product are stored, based on the characteristics and production quantity of a specified product, and calculates the required quantity of materials required to manufacture a specified number of products with the specified characteristics; a data generation step in which a data generation unit generates arrangement data including the calculated required quantity of material and an arrangement category indicating the content of a request to arrange for materials; and an output control step in which an output control unit controls the output of the generated arrangement data to an external device.
[0009] In addition, in order to solve the above-mentioned problems and achieve the objective, the business support program of the present invention causes a computer to function as a calculation unit that refers to a memory unit in which materials and required quantities for each product characteristic required to manufacture a product are stored, based on the characteristics and production quantity of a specified product, and calculates the required quantity of materials required to manufacture a specified number of products with the specified characteristics, a data generation unit that generates arrangement data including the calculated required quantity of materials and an arrangement category indicating the content of a request to arrange for materials, and an output control unit that controls the output of the generated arrangement data to an external device. Effect of the Invention
[0010] The present invention supports the creation of arrangement data for ordering materials or requesting processing of an ordered product, thereby reducing the burden on the person in charge. [Brief description of the drawings]
[0011] [Figure 1] Figure 1 is a diagram to explain the business structure of the textile industry. [Diagram 2] FIG. 2 is a block diagram illustrating a hardware configuration of the task support device according to the embodiment. [Diagram 3] FIG. 3 is a diagram illustrating an example of the product master. [Figure 4] FIG. 4 is a diagram illustrating an example of the product configuration master. [Diagram 5] FIG. 5 is a diagram showing an example of the inventory table. [Figure 6] FIG. 6 is a diagram showing an example of the order input screen. [Figure 7] FIG. 7 is a diagram showing an example of the order details input screen. [Figure 8] FIG. 8 is a diagram showing an example of the order details input screen. [Figure 9] FIG. 9 is a diagram showing an example of the order details matrix input screen. [Figure 10] FIG. 10 is a diagram showing an example of the reservation details input screen. [Figure 11] FIG. 11 is a diagram showing an example of the order input screen. [Figure 12] FIG. 12 is a diagram illustrating an example of the order header table. [Figure 13] FIG. 13 is a diagram illustrating an example of the order details table. [Figure 14] FIG. 14 is a diagram illustrating an example of the order details table. [Figure 15] FIG. 15 is a diagram illustrating an example of an order detail breakdown table. [Figure 16] FIG. 16 is a diagram illustrating an example of the processing request table. [Figure 17] FIG. 17 is a diagram illustrating an example of the order table. [Figure 18] FIG. 18 is a diagram illustrating an example of the movement instruction table. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0012] A business support device according to an embodiment of the present invention will be described in detail below with reference to the drawings. This embodiment is an example in which the present invention is applied to a business support device that supports ordering operations such as fabric for clothing, materials such as buttons, and processing requests in the textile industry. Note that the present invention is not limited to such an embodiment, and may be applied to ordering operations such as parts and materials for automobile manufacturers, home appliance manufacturers, food manufacturers, etc. The following should be understood as one application example of the present invention.
[0013] (overview) A requirement unique to the textile industry is that orders for outsourced product processing are managed by product number, for example, shirts. This is because it is difficult to manage product orders by color or size. For this reason, it is necessary to order the required fabric, buttons, etc. according to product characteristics, such as color (white, blue, gray, etc.) and size (S, M, L, etc.).
[0014] Specifically, Fig. 1 is a diagram for explaining the business form of the textile industry. The terminal device of the transition trading company in Fig. 1 corresponds to the business support device 1 of the embodiment. This business support device 1 is connected to a customer terminal device (customer terminal device) 51, a supplier terminal device (supplier terminal device) 52, and a contract processing destination terminal device (consignment processing destination terminal device) 53 so as to be able to communicate with each other via a predetermined network such as the Internet.
[0015] 1, when an order for the manufacture of a shirt is placed from customer terminal device 51, business support device 1 of the textile trading company generates arrangement data for fabric and accessories such as buttons, and transmits it to supplier terminal device 52. Business support device 1 also generates arrangement data requesting the manufacture of a shirt using fabric and parts delivered by the supplier to a contracted processing company, and transmits it to contracted processing company terminal device 53.
[0016] As will be described later, the business support device 1 of the embodiment automatically generates such arrangement data, thereby reducing the burden of the task of generating arrangement data (support for the tasks shown in boxes among the tasks of the business support device 1 in Figure 1).
[0017] The supplier delivers the fabric, buttons, and other parts to the outsourced processing company based on the order contents from the business support device 1, and reports the delivery contents to the transition trading company via the business support device 1.
[0018] When materials such as fabrics are received from the supplier, the outsourced manufacturer cuts and processes them and delivers (ships) them to the customer. This means that the shirts ordered by the customer are delivered to the customer (received).
[0019] The outsourced processing company transmits a fabric cutting report, a processing report, and a shirt shipping report to the business support device 1 via the outsourced processing company terminal device 53. The business support device 1 performs accounting by performing processing to input a processing contract based on the fabric cutting report and the processing report, and processing to input sales based on the shirt shipping report.
[0020] Here, when it comes to shirts, different colors require different fabrics, but when the same color is used but the size is different, the same fabric is used. Also, even when the colors and sizes are different, the same buttons are used.
[0021] This meant that staff had to manually order the necessary materials, such as fabric and buttons, or request processing by color and size, which placed a burden on the staff.
[0022] The business support device of the embodiment automatically generates ordering data for ordering materials such as fabric and buttons, etc., and for requesting processing, etc., based on product characteristics such as the color and size of the clothing and the number of items to be manufactured, thereby reducing the burden on staff in charge of ordering and improving business efficiency.
[0023] (Hardware configuration) Fig. 2 is a block diagram showing a hardware configuration of a task support device 1 according to an embodiment. As shown in Fig. 2, the task support device 1 includes a storage unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5. An input device 6 and an output device 7 are connected to the input / output interface unit 5. The output device 7 corresponds to a display unit such as a monitor device (including a home television), a printing device, or a speaker device. The input device 6 may be a keyboard device, a mouse device, a microphone device, or a monitor device that cooperates with a mouse device to realize a pointing device function.
[0024] The communication interface unit 4 is connected to a network 55, for example, a wide area network such as the Internet or a private network such as a LAN (Local Area Network). The business support device 1 of the embodiment is connected to a customer terminal device 51, a supplier terminal device 52, and a consignment processing destination terminal device 53 via the communication interface unit 4 and the network 55 so as to be able to communicate with each other.
[0025] A storage device such as a ROM (Read Only Memory), a RAM (Random Access Memory), an HDD (Hard Disk Drive), or an SSD (Solid State Drive) can be used as the storage unit 2. The storage unit 2 stores a business support program that automatically creates arrangement data for requesting suppliers to arrange for fabrics and parts, and arrangement data for requesting contract processing companies to process fabrics, etc., thereby reducing the burden on personnel.
[0026] The storage unit 2 also stores a product master 11, a product configuration master 12, an inventory table 13, an order header table 14, and an order details table 15. The storage unit 2 also stores an order details table 16, an order details breakdown table 17, a processing request table 18, an order table 19, and a movement instruction table 20.
[0027] As shown in Fig. 3, the product master 11 is composed of a product number code, a product code, a product name, one or more characteristic values, and a main supplier code indicating a main supplier. A different product number code is assigned for each material or product. For example, the product "T-shirt" is assigned the product number code "S001", and the material "white fabric" is assigned the product number code "T002". The material "black fabric" is assigned the product number code "T003", and the material "buttons" is assigned the product number code "T004".
[0028] Furthermore, products are classified by characteristic values, and products with different characteristic values are assigned different product codes. In other words, characteristic values are information that indicates the features of a product. As in this example, if the product is a "T-shirt," the characteristic values are "color" and "size." In the example of FIG. 3, the first characteristic value indicates "color," and "T-shirts" are classified into "white" and "black." Also, in the example of FIG. 3, the second characteristic value indicates "size," and "T-shirts" are classified into "Small (Small)," "Medium (Medium)," and "Large (Large)" sizes.
[0029] In addition, the part number code for "T-shirts" is the same as "S001" regardless of the characteristic value, but the product codes are assigned according to the above-mentioned characteristic values. That is, "white" and "S-size" "T-shirts" are assigned the product code "S00101", "white" and "M-size" "T-shirts" are assigned the product code "S00102", and "white" and "L-size" "T-shirts" are assigned the product code "S00103".
[0030] Similarly, the "T-shirt" in "black" and "size small" is given the product code "S00104", the "T-shirt" in "black" and "size medium" is given the product code "S00105", and the "T-shirt" in "black" and "size large" is given the product code "S00106".
[0031] The main supplier code is the supplier code of the main supplier of the material. The example in Figure 3 shows that "white fabric" and "black fabric" are purchased from a supplier with a supplier code of "K002", and "buttons" are purchased from a supplier with a supplier code of "K003".
[0032] The product configuration master 12 includes a parent product code, a first characteristic value, a second characteristic value, the number of parent members, a child product code, the number of child members, and a child configuration quantity, as shown in Fig. 4. The parent product code corresponds to the product code of the product (T-shirt in this example) shown in Fig. 3, and is assigned a code of "S00101" to "S00106" according to each of the characteristic values described above.
[0033] The parent number of components is the number of components that make up one product, and in the case of a "T-shirt", it is "1 piece". The child product code is the number of materials required to manufacture that product, and the child component quantity is the amount of materials required to manufacture that product. For example, the example in Figure 4 shows that in the case of a "white" "Small size" "T-shirt", "2.0 m" of white fabric, equivalent to "0.04 rolls (1 roll is 50 m)", is required to manufacture. The example in Figure 4 also shows that in the case of a "black" "Large size" "T-shirt", "3.0 m" of black fabric, equivalent to "0.06 rolls (1 roll is 50 m)", is required to manufacture.
[0034] The inventory table 13 includes warehouse codes, product codes, inventory numbers, and inventory quantities, as shown in Figure 5. The warehouse codes are the codes of warehouses owned by the textile trading company. The example in Figure 5 shows that the textile trading company owns a warehouse with a warehouse code of "SK01."
[0035] Product codes are the codes for the materials used in the product. In this example, since the product is a "T-shirt," the product code for the "white fabric" used in the manufacture of the T-shirt is set to "T002," the product code for the black fabric is set to "T003," and the product code for the button is set to "T004."
[0036] The number of stock items indicates the number of materials stored in the warehouse as inventory, and the inventory quantity indicates the quantity or amount of materials stored in the warehouse as inventory. The example in Figure 5 shows that the inventory of "white fabric" with product code "T002" is "0 rolls" and "0.0 m", indicating that the product is "out of stock". The example in Figure 5 also shows that the inventory of "black fabric" with product code "T003" is "10 rolls" and "500.0 m". The example in Figure 5 also shows that the inventory of "buttons" with product code "T004" is "1000 pieces".
[0037] The order header table 14 stores order data including the order number, business code, order date, and customer, which is input in response to an order from a customer. The order detail table 15 stores order detail data including the order number, line number, product code, product name, quantity (order quantity), sales price, and sales amount, which are details of the order data.
[0038] The order details table 16 stores order details data including the order number, line number, order category, product code, product name, number of items, quantity, processing destination, receiving destination, department, and order input date, which are details of materials that need to be ordered (arranged) according to the ordered quantity of the received product. The order details breakdown table 17 stores order details breakdown data including the order number, product code, first characteristic value, second characteristic value, and quantity, which indicate the quantity corresponding to the characteristic value of the product.
[0039] The processing request table 18 stores processing request data including a processing request number, processing destination code, category, line number, product code, product name, quantity, and amount for requesting a contract processing destination to process materials.
[0040] The order table 19 stores order data for ordering materials from a supplier, including an order number, a supplier, a receiving destination, a line number, a product code, a product name, a quantity, and an amount.
[0041] The transfer instruction table 20 stores transfer instruction data including a transfer instruction number, warehouse code, receiving destination (in this example, the contracted processing destination), row number, product code, product name, quantity, and amount, which are used to instruct the movement of materials from the above-mentioned warehouse owned by the textile trading company to the contracted processing destination.
[0042] The processing request data, the order data, and the movement instruction data are examples of "arrangement data." The business support device 1 of the embodiment automatically generates the arrangement data to support the processing request work, the order work, the movement instruction work, and the like of the person in charge, thereby reducing the burden. Details will be described later.
[0043] (Functional configuration of business support device) Next, the control unit 3 executes the task assistance program stored in the storage unit 2, thereby functioning as a display control unit 21, a calculation unit 22, and a data generation unit 23, as shown in FIG.
[0044] The display control unit 21 displays, via the output device 7, an order input screen for inputting orders, an order detail input screen for inputting order details, and an order detail input screen for inputting order details. In addition, the display control unit 21 displays, via the output device 7, an order detail matrix input screen for inputting matrix order details, and an order detail input screen for inputting order details.
[0045] The calculation unit 22 refers to a storage unit (product configuration master 12) that stores the materials and required quantities for each product characteristic (characteristics such as the above-mentioned color or size) required for product production, based on the characteristics and production quantity of the specified product. Then, the calculation unit 22 calculates the required quantity of materials required to produce the specified number of products with the specified characteristics.
[0046] The data generating unit 23 generates ordering data (mainly, processing request data) including the calculated required amount of material and an ordering class indicating the request content for requesting the ordering of the material.
[0047] The display control unit 21 is an example of an output control unit, and controls the output of the generated arrangement data to an external device (output device 7). In this example, the output device 7, which is an external device, is a display unit, and the output control unit will be described as displaying the arrangement data on this output device 7, but a printing device or a speaker device may also be used as the output device 7. When the output device 7 is a printing device, the output control unit prints out the arrangement data via the printing device. Also, when the output device 7 is a speaker device, the output control unit controls the output of the audio of the arrangement data via the speaker device.
[0048] In addition, the data generation unit 23 generates matrix input screen display data for displaying a matrix input screen (order details matrix input screen in FIG. 9) having a matrix-shaped input field in which an input field for a first characteristic of the product (color in FIG. 9) and an input field for a second characteristic different from the first characteristic (size in FIG. 9) are crossed in the row and column directions.
[0049] The output control unit (display control unit 21) outputs matrix input screen display data to an external device (output device 7) to display the matrix input screen on the external device (output device 7). The calculation unit 22 calculates the required amount of material based on the production quantity input by the operator in the input field on the matrix input screen corresponding to the characteristics of the product to be manufactured.
[0050] The ordering categories included in the ordering data are processing requests, which are requests to the processing destination (contracted processing destination) to manufacture a product, parts orders, which indicate an order for materials to a supplier, or supply requests, which are requests to move materials from a designated storage location (textile trading company's warehouse) to the processing destination (contracted processing destination).
[0051] The data generation unit 23 generates, as the arrangement data, processing request data (see FIG. 16) corresponding to a processing request, order data (see FIG. 17) corresponding to a parts order, or movement instruction data (see FIG. 18) serving as a supply request.
[0052] The data generating unit 23 compares the required amount of material calculated by the calculation unit 22 with inventory data indicating the stock of material stored in the storage unit 2. If the stock is less than the required amount, the data generating unit 23 generates order data for ordering the material, and if the stock is equal to or greater than the required amount, it generates movement instruction data that serves as a supply request.
[0053] (Automatic generation of ordering data) Next, the operation of automatically generating arrangement data in the business support device 1 of this embodiment will be described. First, as shown in Fig. 1, it is assumed that an order from a customer is received by the business support device 1 of a textile trading company. As a result, the person in charge specifies the display of the order input screen via the input device 6. When this specification operation is performed, the display control unit 21 displays the order input screen exemplified in Fig. 6 via the output device 7.
[0054] The person in charge enters the business code, order date, department, customer, supplier, shipping date, and expected sales date into this order input screen, and operates the new line button 60. The order number is automatically assigned by the control unit 3 and automatically entered by the display control unit 21. The example in FIG. 6 shows an order from a customer, "Company A," with the supplier being an "apparel manufacturer," and the shipping date and expected sales date being "June 1, 2023."
[0055] After inputting the order in this manner, the person in charge operates the new line button 60 to input order details. When the new line button 60 is operated, the display control unit 21 displays the order details input screen shown in FIG. 7 via the output device 7. The person in charge inputs the line number, product code, quantity, sales price, and sales amount into this order details input screen. The example in FIG. 7 shows that an order has been placed for 250 "T-shirts" with product code "S001". In addition, the sales price of the "T-shirts" is 1,200 yen, so the sales amount is 300,000 yen.
[0056] After inputting the order details in this manner, the person in charge operates the order details button 62 to input the order details. When the order details button 62 is operated, the display control unit 21 displays, via the output device 7, an order details input screen on which the order number, business establishment code, and department code based on the order input screen shown in Fig. 6, and the product code and sales quantity (=number of units) based on the order details input screen shown in Fig. 7 have been automatically input, as exemplified in Fig. 8. The order number on this order details input screen is automatically assigned by the control unit 3 and automatically input by the display control unit 21. The order input date is manually input by the person in charge.
[0057] Although the person in charge may manually input the order details such as line number, order category, processing destination / supplier, receiving destination, product code, quantity, and amount on this order details input screen, in the case of the business support device 1 of the embodiment, the order details can be easily input automatically by using the input screen in a matrix format described below. That is, when inputting the order details, the person in charge operates the matrix input button 63 shown in Fig. 8. When the matrix input button 63 is operated, the display control unit 21 displays the order details matrix input screen shown in Fig. 9 via the output device 7.
[0058] As shown in this Figure 9, the display control unit 21 automatically inputs and displays the product code (S001) and quantity (= sales quantity: 250 items) entered via the order details input screen shown in Figure 7 into the order details matrix input screen.
[0059] The display control unit 21 also displays on the order details matrix input screen a matrix input field in which the row direction is an input field for sizes such as "S", "M", "L", "LL" etc. (an example of a first characteristic) and the column direction is an input field for colors such as "white", "black", "gray" etc. (an example of a second characteristic), and these input fields in the row direction and column direction are intersected.
[0060] The person in charge enters the quantity corresponding to the breakdown of the sales quantity of 250 items in this matrix input field. The example in Figure 9 shows that the breakdown of the sales quantity of 250 items is "50 items" of white S size, "100 items" of black M size, and "100 items" of black L size, for a total of "250 items."
[0061] 9 is an example of order entry in the textile industry, but in the case of the machinery industry, for example, a matrix input field may be displayed with the type of parts in the row direction and the size of the parts in the column direction, and the desired number of parts may be entered in this matrix input field. Also, the person in charge may select a desired characteristic in the row direction (first characteristic value) from several characteristics and select a desired characteristic in the column direction (second characteristic value), causing the display control unit 21 to display a matrix input field for each selected characteristic.
[0062] Next, after such matrix input is performed and the Confirm button 64 on the order details matrix input screen shown in Fig. 9 is operated, the display control unit 21 automatically generates and displays order details information on the order details input screen in Fig. 10 based on the input contents on the order details matrix input screen, the product configuration master 12 in Fig. 4, and the inventory data in the inventory table in Fig. 5. Note that this order details information can be manually corrected by the person in charge.
[0063] More specifically, the display control unit 21 first refers to the product configuration master 12 in Fig. 4 based on the first characteristic value and the second characteristic value corresponding to the quantity of products input as details on the order details matrix input screen shown in Fig. 9. Then, the display control unit 21 detects child product codes corresponding to the first characteristic value and the second characteristic value, and detects the number of child constituent members and the child constituent quantity required to create one item of the product corresponding to the first characteristic value and the second characteristic value.
[0064] In the example of FIG. 9, since there are 50 white T-shirts of size S, the display control unit 21 detects the child product code of "T002", the number of child members of "0.04 Roll (1 Roll = 50 m)", and the child composition quantity of "2.0 m" by referring to the product configuration master 12. In the example of FIG. 9, since there are 100 black T-shirts of size M, the display control unit 21 detects the child product code of "T003", the number of child members of "0.05 Roll", and the child composition quantity of "2.5 m" by referring to the product configuration master 12. In the example of FIG. 9, since there are 100 black T-shirts of size L, the display control unit 21 detects the child product code of "T003", the number of child members of "0.06 Roll", and the child composition quantity of "3.0 m" by referring to the product configuration master 12.
[0065] The calculation unit 22 calculates the total number of fabrics and the number of buttons required to manufacture the detected number of T-shirts of each color and size. That is, the amount of white fabric required to manufacture one white, small size T-shirt is "0.04 rolls (1 roll = 50 m)" or "2.0 m". Therefore, the calculation unit calculates "50 pieces x 0.04 rolls = 2.0 rolls" and "50 pieces x 2.0 m = 100 m" as the total amount of white fabric required to manufacture 50 white, small size T-shirts. This calculates the total amount of white fabric required to manufacture 50 white, small size T-shirts.
[0066] Similarly, the amount of black fabric required to manufacture one black, medium-sized T-shirt is "0.05 rolls (1 roll = 50 m)" or "2.5 m." Therefore, the calculation unit calculates the total amount of black fabric required to manufacture 100 black, medium-sized T-shirts as "100 pieces x 0.05 rolls = 5.0 rolls" and "100 pieces x 2.5 m = 250 m." This calculates the total amount of black fabric required to manufacture 100 black, medium-sized T-shirts.
[0067] Similarly, the amount of black fabric required to manufacture one black, size L T-shirt is "0.06 rolls (1 roll = 50 m)" or "3.0 m." Therefore, the calculation unit calculates the total amount of black fabric required to manufacture 100 black, size L T-shirts as "100 pieces x 0.06 rolls = 6.0 rolls" and "100 pieces x 3.0 m = 300 m." This calculates the total amount of black fabric required to manufacture 100 black, size L T-shirts.
[0068] The calculation unit 22 also calculates the total number of buttons, which are common parts, required to manufacture T-shirts of each color and size. For example, assume that seven buttons are required to manufacture one T-shirt. In this example of manufacturing 250 T-shirts, the calculation unit 22 calculates the total number of buttons required by calculating "7 buttons x 250 T-shirts = 1750 buttons."
[0069] Next, once the total number of fabrics and buttons have been calculated in this manner, the data generation unit 23 generates order detail information for white fabric, black fabric, and buttons, with the order classification set to "processing request." The display control unit 21 displays each generated order detail information on the order detail input screen shown in Figure 10. Of the order detail information shown in Figure 10, the details with row numbers 1 to 3 and order classification set to "processing request" are the order detail information for white fabric, black fabric, and buttons.
[0070] Next, the data generating unit 23 compares the calculated total number of white fabric, black fabric, and buttons with the stock quantities of white fabric (product code: T002), black fabric (product code: T003), and buttons (product code: T004) stored in the stock table 13 shown in FIG. 5. In this example, "2.0 Rolls (100 m)" of white fabric are required to manufacture 50 white T-shirts in size S. Referring to the stock table 13 shown in FIG. 5, the stock of white fabric with product code "T002" is "0.0 Roll (0 m) = out of stock."
[0071] In this case, since there is a shortage of white fabric, the data generation unit 23 generates order details information for the order category of "parts order." The display control unit 21 displays the generated order details information on the order details input screen shown in Fig. 10. The line number "4" in Fig. 10 and the details for the order category of "parts order" are order details information for ordering "2 rolls (100 m)" of white fabric required to manufacture 50 white, small size T-shirts.
[0072] In this example, 5.0 rolls (250 m) of black fabric is required to produce 100 medium-sized black T-shirts. 6.0 rolls (300 m) of black fabric is required to produce 100 large-sized black T-shirts. Therefore, a total of 11.0 rolls (550 m) of black fabric is required.
[0073] Referring to the inventory table 13 shown in FIG. 5, there is an inventory of "11.0 Rolls (550 m)" of black fabric with product code "T003", which is enough to produce 100 each of the medium and large size black T-shirts to be produced this time. Therefore, the data generation unit 23 generates arrangement details information with an arrangement class of "supply request". The display control unit 21 displays the generated arrangement details information on the arrangement details input screen shown in FIG. 10. The line number "5" in FIG. 10 and the details with an arrangement class of "supply request" are arrangement details information for requesting the supply of "11 Rolls (550 m)" of black fabric from the company's warehouse to the contract manufacturer, which is required to produce 100 black medium size T-shirts and 100 black large size T-shirts.
[0074] In this example, the required number of buttons, which are common parts, required to manufacture 250 T-shirts of each color and size is "1750 pieces." Referring to inventory table 13 shown in FIG. 5, buttons with product code "T004" are in stock at "1000 pieces," with a shortage of "750 pieces." In this case, data generation unit 23 generates detailed arrangement information for the arrangement class of "parts order" for 750 buttons and the arrangement class of "supply request" for 1000 buttons. Display control unit 21 displays the generated detailed arrangement information on the detailed arrangement input screen shown in FIG. 10. The details in FIG. 10 with the line number "6" and the arrangement class of "parts order" are detailed arrangement information for ordering the 750 buttons to make up the shortage in stock from a parts company. Also, the line number "7" in FIG. 10 and the details with the order classification "supply request" are order detail information for requesting the supply of 1,000 buttons from the company's warehouse to a contract manufacturing company.
[0075] In this way, the data generation unit 23 compares the received order quantity with the number of stock members and the stock quantity in the inventory table 13, and if there is a shortage of inventory, it generates order details information for "parts order", and if there is sufficient inventory, it automatically generates order details information for "supply request", which the display control unit 21 displays on the order details input screen shown in Figure 10.
[0076] When this input of order details is completed, the person in charge operates the register button 65 on the order details input screen as shown in Fig. 10. When the register button 65 is operated, the display control unit 21 returns the displayed screen to the order input screen as shown in Fig. 11, and displays details such as the product code, quantity, sales price, and sales amount indicating the order contents in the details display field of this order input screen, based on the input contents on the order details input screen shown in Fig. 7. If the new line button 60 is operated in this state, the order details input screen shown in Fig. 7 is displayed, and it becomes possible to input the quantity, sales price, sales amount, etc. again, as described above.
[0077] Next, when the order input is completed, the person in charge operates the register button 61 shown in Fig. 11. When the register button 61 is operated, the data generation unit 23 generates order header data including the order number, office code, department code, order date, customer code, etc. as shown in Fig. 12 based on the input contents on the order input screen shown in Fig. 11, and stores this in the order header table 14. Every time the data generation unit 23 generates order header data, it updates the order header table 14 by adding details of the newly generated order header data. The display control unit 21 displays the order header data stored in the order header table 14 via the output device 7 at a timing specified by the person in charge, etc.
[0078] Furthermore, when the register button 61 is operated, the data generation unit 23 generates order detail data including the order number, line number, product code, product name, quantity, sales price, sales amount, etc. as shown in Fig. 13 based on the order details on the order input screen shown in Fig. 11, and stores this in the order detail table 15. Every time the data generation unit 23 generates order detail data, it updates the order detail table 15 by adding details of the newly generated order detail data. The display control unit 21 displays the order detail data stored in the order detail table 15 via the output device 7 at a timing designated by the person in charge, etc.
[0079] Furthermore, when the register button 61 is operated, the data generation unit 23 generates order detail data including the order number, line number, order category, product code, product name, number of items, quantity, processing destination, warehouse destination, department code, order input date, etc., as shown in Fig. 14 based on the order detail information on the order detail input screen shown in Fig. 10, and stores this in the order detail table 16. Every time the data generation unit 23 generates order detail data, it updates the order detail table 16 by adding details of the newly generated order detail data. The display control unit 21 displays the order data stored in the order detail table 16 via the output device 7 at a timing specified by the person in charge, etc.
[0080] Furthermore, when the register button 61 is operated, the data generation unit 23 generates order detail breakdown data including the order number, product code, first characteristic value, second characteristic value, quantity, etc., as shown in Fig. 15 based on the input contents of the order detail matrix input screen shown in Fig. 9, and stores this in the order detail breakdown table 17. Every time the data generation unit 23 generates order detail breakdown data, it updates the order detail breakdown table 17 by adding details of the newly generated order detail breakdown data. The display control unit 21 displays the order data stored in the order detail breakdown table 17 via the output device 7 at a timing specified by the person in charge, etc.
[0081] Furthermore, when the register button 61 is operated, the data generation unit 23 generates processing request data (an example of arrangement data) including the processing request number, processing destination, category, line number, product code, product name, quantity, amount, etc. as shown in Fig. 16 based on the arrangement details information on the arrangement details input screen shown in Fig. 10, and stores this in the processing request table 18. Every time the data generation unit 23 generates processing request data, it updates the processing request table 18 by adding details of the newly generated processing request data.
[0082] The example in Figure 16 shows that an order was received for the production of 250 T-shirts (category = 1: receiving), and 2 rolls (100 m) of white fabric, 11 rolls (550.0 m) of black fabric, and 1,750 buttons were delivered (category = 2: delivering), and a processing request was made to the processing supplier.
[0083] The display control unit 21 displays the processing request data stored in the processing request table 18 via the output device 7 at a timing designated by a person in charge or the like.
[0084] Furthermore, when the register button 61 is operated, the data generation unit 23 generates order data (an example of order data) including the order number, supplier, receiving destination, line number, product code, product name, quantity, amount, etc. as shown in Fig. 17 based on the order detail information on the order detail input screen shown in Fig. 10, and stores this in the order table 19. Every time the data generation unit 23 generates order data, it updates the order table 19 by adding details of the newly generated order data.
[0085] The example in Figure 17 shows that an order was placed for 2 rolls (100 m) of white fabric to make up for the shortage in the production of 50 small size white T-shirts, and also for 750 buttons, which are the shortage of the 1750 buttons needed to produce 250 T-shirts. The white fabric and buttons are received by a contract manufacturer (receiving code: K001).
[0086] The display control unit 21 displays the order data stored in the order table 19 via the output device 7 at a timing designated by a person in charge or the like.
[0087] Furthermore, when the register button 61 is operated, the data generation unit 23 generates transfer instruction data (an example of arrangement data) including a transfer instruction number, warehouse code, storage destination, line number, product code, product name, quantity, amount, etc., as shown in Fig. 18 based on the arrangement detail information on the arrangement detail input screen shown in Fig. 10, and stores this in the transfer instruction table 20. Every time the data generation unit 23 generates transfer instruction data, it updates the transfer instruction table 20 by adding details of the newly generated transfer instruction data.
[0088] The example in Figure 18 shows that 11 rolls (550.0 m) of black fabric required to manufacture 100 each of medium and large size black T-shirts are moved from the company's warehouse (SK001) to a contract processing company (warehouse receiving location: K001) and a processing request is made. The example in Figure 18 also shows that 1,000 buttons, which are in stock at the company's warehouse, are moved from the company's warehouse (SK001) to a contract processing company (warehouse receiving location: K001) and a processing request is made.
[0089] The display control unit 21 displays the movement instruction data stored in the movement instruction table 20 via the output device 7 at a timing designated by a person in charge or the like.
[0090] Since the task support device 1 according to the embodiment can automatically generate various data in this way, the task burden on the person in charge can be significantly reduced.
[0091] (Effects of the embodiment) As is clear from the above explanation, the business support device 1 of the embodiment can automatically generate arrangement data for ordering the required materials such as fabric or buttons and requesting processing, etc., based on product characteristics such as the color and size of the clothing and the number to be manufactured.
[0092] This reduces the burden on the person in charge of ordering and improves the efficiency of the ordering process. It also helps to prevent duplicate orders and improves manufacturing yields, optimizing the production volume.
[0093] [Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, and can therefore contribute to Goals 8 and 9 of the SDGs.
[0094] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of Goals 12, 13, and 15 of the SDGs.
[0095] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.
[0096] [Other embodiments] The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.
[0097] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.
[0098] In addition, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.
[0099] Moreover, with regard to the task support device 1, each of the components shown in the figures is a functional concept, and does not necessarily have to be physically configured as shown in the figures.
[0100] For example, the processing functions of the business support device 1, particularly the control unit 3 and each processing function performed by the control unit 3, may be realized in whole or in part by a CPU (Central Processing Unit) and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium including programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the business support device 1 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD. This computer program is executed by being loaded into a RAM, and constitutes the control unit 3 in cooperation with the CPU.
[0101] In addition, the business support program of this business support device 1 may be stored in another server device connected to the business support device 1 via any network, and it is also possible to download all or part of it as needed.
[0102] The business support program for executing the process described in the present embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical Disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.
[0103] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that achieves its function by working with a separate program, such as an OS. Note that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading a recording medium in the business support device 1 shown in the embodiment, as well as the installation procedure after reading.
[0104] The memory unit 2 is a storage means such as a memory device such as RAM or ROM, a fixed disk device such as a hard disk, a flexible disk, or an optical disk, and stores various programs, tables, databases, and web page files used for various processes and providing websites.
[0105] The business support device 1 may be configured as an information processing device such as a known personal computer device or a workstation, or may be configured as an information processing device to which any peripheral device is connected. The information processing device may be realized by implementing software (including programs or data, etc.) that realizes the processing described in this embodiment.
[0106] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]
[0107] The present invention can support business in industries involving ordering parts or requesting processing, such as the apparel industry, and the manufacturing industries of automobiles and home appliances. [Explanation of symbols]
[0108] 1 Business support equipment 2 Storage section 3. Control Unit 4. Communication Interface Section 5 Input / Output Interface Section 6 Input Devices 7 Output Devices 11 Product Master 12 Product composition master 13 Inventory Table 14 Order Header Table 15 Order Details Table 16 Order Details Table 17 Order Detail Breakdown Table 18 Processing Request Table 19 Order Table 20 Movement Instruction Table 21 Display control unit 22 Calculation section 23 Data Generation Division 51 Customer terminal device 52 Supplier terminal equipment 53. Terminal equipment for outsourced processing
Claims
1. a calculation unit that refers to a storage unit in which materials and required quantities for each characteristic of a product that are required for the production of the product are stored, based on the characteristics of the product and the number of products to be produced that are designated, and calculates the required quantity of materials required to produce the product having the designated characteristics by the designated number of products to be produced; a data generating unit that generates ordering data including the calculated required amount of the material and an ordering category indicating a request for ordering the material; an output control unit that controls output of the generated arrangement data to an external device; A business support device having the above configuration.
2. the data generation unit generates matrix input screen display data for displaying a matrix input screen including a matrix-shaped input field in which an input field for a first characteristic of the product and an input field for a second characteristic different from the first characteristic are crossed in row and column directions; the output control unit outputs the matrix input screen display data to the external device to display the matrix input screen on the external device; the calculation unit calculates the required amount of the material based on the production quantity input by an operator into the input field of the matrix input screen corresponding to the characteristic of the product to be manufactured; 2. The business support device according to claim 1,
3. The arrangement category is a processing request, which is a request to a processing destination to manufacture the product, a parts order, which is an order to a supplier to place an order for the material, or a supply request, which is a request to move the material from a predetermined storage location to the processing destination; the data generation unit generates, as the arrangement data, processing request data corresponding to the processing request, order data corresponding to the part order, or movement instruction data serving as the supply request; 3. The business support device according to claim 1 or 2,
4. the data generation unit compares the required amount of the material calculated by the calculation unit with inventory data indicating the stock of the material stored in the storage unit, and generates the order data for ordering the material when the stock is less than the required amount, and generates the movement instruction data serving as the supply request when the stock is equal to or greater than the required amount; 4. The business support device according to claim 3,
5. a calculation step in which a calculation unit refers to a storage unit in which materials and required amounts for each characteristic of a product are stored, based on the characteristics and production quantity of the specified product, and calculates the required amount of materials required to produce the specified number of products having the specified characteristics; a data generating step of generating arrangement data including the calculated required amount of the material and an arrangement class indicating a request for the arrangement of the material by a data generating unit; an output control step in which an output control unit controls output of the generated arrangement data to an external device; A business support method having the above-mentioned features.
6. Computer, a calculation unit that refers to a storage unit in which materials and required quantities for each characteristic of a product that are required for the production of the product are stored, based on the characteristics of the product and the number of products to be produced that are designated, and calculates the required quantity of materials required to produce the product having the designated characteristics by the designated number of products to be produced; a data generating unit that generates ordering data including the calculated required amount of the material and an ordering class indicating a request for ordering the material; Functioning as an output control unit that controls output of the generated order data to an external device; A business support program that features:
Citation Information
Patent Citations
Computer system for mediating order production of commodity, program executed in computer system, and system for producing commodity to order
JP2019215834A