Steel pipes production

I. SOFTWARE OVERVIEW

BRAVO software (ERP-VN) when applied at units specializing in STEEL PIPE PRODUCTION and PROCESSING is customized according to the characteristics of enterprises in the industry. The system is built with the purpose of helping businesses solve problems of administration and operation of processes built on the software under the mechanism of “coordinating – sharing – jointly controlling”. control – accomplish together” between departments and divisions in the enterprise to improve and maximize business and production efficiency.

II. PROBLEMS OF READING STEEL PIPE PRODUCTION AND PROCESSING INDUSTRY

Units specializing in STEEL PIPE production and processing in general and STEEL PIPE rolling and production units in particular will build closed processes, improving coordination, control and distribution capabilities. resources optimally, quickly and efficiently. Accordingly, the application process will be operated as follows:1. Data organization systemDescribe main activities:a. (1): Business Management:As the starting point of the production and business process. In addition to sales operations, the sales department bases on sales data to make “production plans” corresponding to reality. , then transferred to the factory to complete. When the production process is done, the sales department needs to monitor the production situation and capture the output and available inventory (available inventory). sales) to coordinate arising orders/contracts. Main tasks in the process:Sales management: Planning revenue, making sales policies (price list, discounting,…), making quotations, making sales orders/contracts/export contracts, making export orders /hold order, sales invoice/export invoice, delivery and shipping tracking, return sales slip. Production planning and tracking: planning about “production volume”, detailed production plan/work order tracking, production progress tracking and production statistics, available inventory tracking. b. (2), (5), (6): Production Manager:Participation of all departments at the factory (factory board of directors and subordinate departments and divisions) Inheriting the “production plan” from the sales and construction department develop detailed “production plans” according to the production stages: + Steel Rolling Plant, including stages: Strip Cutting, Rust Removal, Rolling, Annealing.+ Steel Pipe Factory, including stages: Galvanized Wire, Strip Plating, Cutting, Strip Welding, Bending, Dipping, and Threading.p>Based on the production plan, the inventory of available materials will estimate raw materials for production. Check and monitor the machine downtime to estimate repair and maintenance supplies. . Make the purchase request for materials, request for the delivery/receipt of materials, transfer to the technical department for inspection and send to the purchasing department. Based on the appropriate plan and resources, proceed to make the “ production orders” transferred to workshops, production stages in the factory to carry out the production process. Track progress, detailed production statistics according to production plans. Coordinating combine, check and evaluate the quality of finished products Main tasks in the process:Production Dispatching Department:+ Receive and complete the Production Plan.+ Make a detailed production plan by stage.+ Make detailed production orders by stage.+ Estimate and make a proposal to supply materials.+ Track production statistics.+ Monitor downtimeProduction Statistics Department:+ Receive production plan/work order.+ Production statistics by stage.+ Manage consumables.+ Statistics of machine downtimeQuality Management:+ Control and evaluate the quality of purchased materials (according to groups requesting supplies)+ Measurement and quality control of finished products (mechanical, physical, chemical).+ Management of weighing stations for raw materials and finished products+ Monitor production progressElectrical Engineering Department:+ Management and budgeting of materials+ Summary of requests for supplies (repair and maintenance supplies).+ Summary of requests to purchase materials.+ Control and evaluate the quality of purchased materials (according to groups requesting supplies).+ Pipe mold control+ Make a cut order calculation sheet.+ Monitor downtime.+ Monitor production progressFactory Accounting and Warehouse Department+ Receive import notices.+ Receipt of export/stocking orders.+ Warehouse management: purchasing, warehousing, importing finished products.+ Warehouse management: export sales, export raw materials, export assembly, export transfer.+ Update accounting data arising at the factoryc. (3) (3A,B,C), (4), (7): Purchasing Manager:Playing the role of coordinating materials for production and business process. Based on actual inventory and production plan to estimate materials. Based on actual arising , the materials department inherits, controls and processes the “request for materials” groups from the updated departments. After completing the “requests for materials”, conducts inquiries and collects reports evaluate and evaluate, select the most suitable supplier After the leader approves the supplier, prepares orders and contracts (according to quotations) and monitors the purchasing process. When receiving delivery notices from suppliers, proceed to make “notices/import orders” to relevant departments such as: Technical department, Quality management department, Warehouse… to arrange personnel inspect and evaluate goods, raw materials and conduct purchasing. At the same time, prepare payment records for suppliers and transfer to accountants for payment. After the process is over. successful purchase and import process, conduct surveys and evaluate the quality of each supplier g level as a basis for selection and purchase in the next time Main tasks in the process:Supplying of materials. Controlling purchase requisitions. Assembling quotations and evaluating suppliers. Manage purchase orders/contracts. Order/inform import notification. Track purchase status. Make purchase payment records. Supply survey and evaluation d. (7), (7A), (8): Management Accounting:As the part that inherits all data arising in the system. Plays the role of controlling the arising financial activities corresponding to each production and business operation. Main tasks in the process:Cash accounting. Cash accounting. Accounting for sales and accounts receivable Accounting for purchases and accounts payable. Inventory accounting. . Property accounting and CCDC. Cost accounting (calculating costs by each stage). Tax accounting. Management accounting (general accounting data for the whole world). system: office, factory, branch) e. (7A), (9): Administrative Organization:Manage purchasing process (office supplies, equipment) independent of supplies department. Administrative management (documents, work uniforms distribution). Human resource management. Attendance. Timekeeping and statistics. Payroll calculation. Insurance tracking.

III. SOLUTION OF BRAVO SOFTWARE:

1. Software database organization:The common characteristic of manufacturing enterprises is that the geographical area and scope of production and business are dispersed in many different locations and areas (offices, factories, sales warehouses, branches…). Therefore, in addition to the needs of customers, when building solutions, BRAVO consults on solutions to organize and stream data for convenience in business operations, closely in management of development issues. Generate and synthesize all activities in the customer’s business and production organization system.a. Organizational model for updating and exploiting system data:As mentioned, because the locations where the software is used are spread across geographical regions, BRAVO needs to build a data system that combines a synchronous and distributed data solution to ensure the accuracy of the data. timeliness of data (for legacy issues, tracking and management of data arising) and continuity of data (to ensure continuous sales and production when there is a connection failure) , reducing the delay in transactions that need to be counted continuously such as sales, goods import…).Data Model:Description:At headquarters:+ Install 01 BRAVO software including “running program” and “database” on the server (Server).+ In departments, computers that are allowed to access the software (Client) will be declared (machine name, user ID) and installed “running programs” for users to update information. information, data into the software.+ Users will be managed and decentralized in detail according to each user’s role in the relevant departments. Each department will have its own layout design (interface) suitable for the management of each department.At the factory and branches:+ Installing BRAVO software only includes “running program” (not including “database”) on client computers of departments, users participating in using the software to update and receive online data about the software on the server at the head office.+ Users are decentralized and authorized to ensure independence and responsibility when updating data into the system.(Recommendation: to ensure stability and data safety when operating the software, BRAVO recommends equipping a backup server, a backup server serving two main tasks: replacing the main server operates the system and backs up the software’s data.On the main server and backup server integrate equivalent physical hard drives and configure according to hard drive Raid solutions: Raid 0, Raid 1, Raid 10) .b. Grouping user data classes at each use location:In addition to inheriting data arising in the system, each department has its own, independent and sometimes confidential operations with other departments. Therefore, for users’ convenience in operating and manipulating the software, BRAVO divides the user interface into layers (Layout). Specifically:

At Headquarters:+ Layout of the Board of Directors of the company.+ Sales Department Layout.+ Layout of the Purchasing Department – Import and Export.+ Layout of Accounting Department.+ Organization Room Layout

At branch:+ Layout Branch Board of Directors.+ Sales Department Layout.+ Shopping Room Layout.+ Warehouse Layout.+ Layout of Accounting Department.+ Organization Room Layout

+ Layout Factory Board of Directors.+ Layout of Production Dispatching Department.+ Layout of Production Statistics Department+ Layout of Electromechanical Engineering Department.+ Warehouse Department Layout.+ Quality Control Department Layout.+ Factory Accounting Department Layout

c. Organize and disassemble software databaseFor enterprises to easily monitor, manage and aggregate data arising at each software operation location, BRAVO advises on data organization plans suitable to each size of the business. Accordingly, the software’s database (database) will be divided into data trays (called base unit trays) corresponding to each point used to receive, store and process broadcast data. born at each point. And there is 01 aggregate data tray that plays the role of aggregating/unifying generated data for the whole system.d. Handling specific operations of production and businessSales Features:Sales and exports are carried out at the office (headquarters, branches) and the export and delivery are carried out at the factory. Therefore, the software needs to solve the high requirements of accuracy in order processing / sales contracts, continuity in the delivery process. At the office, sales staff can control and track production flow (through production statistics processes), available inventory (products that can be sold). However, in addition to the automatic functions of the system, in the operation process, enterprises must determine the data completion time points between the locations of use. Accordingly, production work is often happens continuously and it is necessary to set a time to close the production data of each day so that the business divisions can inherit and capture the actual output of that day => as a basis for building orders, making export orders. (For example, it is stipulated that before 8:00 a.m. every day, the production departments at the factory must update and complete the production data of the previous day in order for the business to perform the sales stages). From the moment When a business completes orders/contracts and makes “delivery orders”, the data will have to be displayed immediately at the Warehouse, weighing house and factory accountant to set up delivery procedures for customers. Therefore, in addition to the supporting technology of software and hardware, enterprises also need to equip information technology infrastructure systems (servers, internet lines, power systems) to ensure the continuity of the network. business process. Some images on BRAVO software:

Purchase FeaturesPurchase operations are under the authority and responsibility of the Purchasing Department (or Materials Department). However, the operating process is related to all parts and departments in the enterprise. Therefore, the application of software to Purchasing Management also needs to separate the tasks and application scope at each department and department. Processing purchase requests/requests: at each point of using the software software (office, factory, branch), all departments will make “request/request for purchasing materials” via hard copy (according to the form prescribed by the enterprise) => the purpose is to reduce the load of redundant data and minimize the number of users interacting on the software. After being confirmed and approved by the department head (or person in charge), it will be transferred to a main department (eg M&E department, Organization department) to synthesize all kinds of requests/requests for purchasing materials and updating them into the software. This department will base on the elements of materials (immediate availability, availability, reserve…) to approve purchase proposals => Approved and accepted offers will be displayed on the data screen at the Materials (purchase) department at the Head Office/representative office. At the Purchasing Department, the purchasing officer is in charge of purchasing. inspect and approve proposals/requests to purchase materials and conduct inquiries/collection of quotations/comparisons to submit to the Board of Directors for approval. After the Leader approves, the Purchasing Department proceeds to make orders/contracts (according to the selected supplier, quotation) to purchase. Before the goods arrive at the delivery point, Purchasing department prepares “import notices” to relevant departments to prepare people and geographical space for the warehousing process. When the Supplier delivers the goods to the warehouse, the staff of the Technical Department in conjunction with the Quality Control Department conducts an inspection of the goods. If the standard is met, then sign the “Receipt of goods delivery” signed by the delivery unit, factory security, Technical/Quality Management department and warehouse keeper, then proceed to warehouse. If they do not meet the standards, do not allow warehousing and return goods to the Supplier. On the system, in addition to the departments directly related to the purchase/import, the proposed departments will track the progress. level, status of goods in order to make “supply/receipt of materials” for the warehouse department to export materials. Some pictures on BRAVO software:< /p>

Production features:Finished steel products (steel plate, corrugated iron) are input materials of steel pipe factories. Therefore, the tracking of original materials plays an important role in controlling input materials and tracing the origin and quality of finished products and output semi-finished products. At each import operation. inventory, statistics sheet… the software builds input information flows, supports users to update groups of units, characteristics of raw materials/semi-finished products/finished products in the production process such as: Code original coil/coil code (semi-finished product)/steel grade/strip/production batch… Through the production statistics function at each stage, the software can handle the following operations: + Statistics on the number of products completed by each stage, each working shift, each production machine (line).<3+ Consumption statistics: Main materials, auxiliary materials, tools, oil, grease, chemicals, electricity.+ Statistics are available for each group of finished products (groups of salable items, supporting the sales department to be proactive and control inventory).Some images on BRAVO software:

Product Quality Management: Steel market with high competition among domestic companies and especially competition from Chinese steel products (Country with the world’s number one smelting and rolling output), from the perspective of management, monitoring and monitoring the quality of output products plays a key role in determining the competitive advantage of each enterprise. Accordingly, from production to distribution to the market In the market, enterprises need to control and monitor the status of their products. Specifically: + During production: with input materials (cold rolled products, coils) it is necessary to track details to each type of material (original roll code, semi-finished roll code) to can control the quality of each raw material put into production. However, at rolling mills, the output products have been analyzed for the indicators of Mechanical – Physical – Chemical properties and synthesized on the steel grades attached to the surface of each product. + After production is completed, the software allows updating product indicators/characteristics and printing “quality certificates” for each production batch. When there is a quality problem received from the market, businesses can rely on “quality certificates” to trace the production process of that product: from which roll? Which production batch? Produce from any date to any date on the system. Some images on BRAVO software:

IV. EFFECTIVE BRAVO SOFTWARE APPLICATION