WKP - List of production cards, Production planning (as in the MS Project program), auto valuation of exchangers and petrochemical and energy devices, tanks

WKP - List of production technology cards, List of covering cards that should be correctly found / identified at the production department. It helps in finding order items, after the warehouseman saves where they are.
The S ... system purchased from the factory could not exactly record this position of the elements.
The WKP program is an attempt to cope after completing the implementation of a large program called S ..... in the company.
Import of order data from the popular S ..... program used on the market to the WKP spreadsheet was carried out. The data processed with the spreadsheet was sent to warehouse keepers for recording.
In the next stage, the program will be replaced with an application on the website written in PHP and MySQL. The program will be operated by employees using touch panels and tablets in positions.

Production planning (as in the MS Project program) - a program for calculating the execution time of a multi-stage order, with a certain number of locksmiths and welders, painters, warehousemen, hours of chip machining on a boring machine and other activities for BOCAR GmbH
By using the spreadsheet, you can react appropriately at any stage of the production to complete the order within.

Auto valuation program for petrochemical and energy exchangers and devices, tanks.
The program contains labor intensity norms:
- drilling
- gas cutting
- planing
- rough boring
- guillotine
- gas cutting
- post-processing
- turning of various types of flanges
- ellipsoidal bottoms
- folding partitions into packages
and other necessary for calculations

The program, based on the above standards, calculates the preparation of heat exchanger details: tube sheets, spacers, coat flanges, head chamber flanges, ellipsoidal bottoms, folding partitions into packages and others.
The program also includes the construction of tube walls and partitions conventionally by drilling with twist drills and reamers and mixed and strictly numerical methods.
The program then counts how long the complete installation of the heat exchanger / energy device takes.

Overview

WKP - List of Guide Cards, Plant Planning Worksheet (like MS Projekt), Quotation sheets for whole exchangers.

Client

ZBA S.A. - PKN Orlen S.A. company group
BOCAR GmbH Sp. z o.o. Department in Poland

Services

Excel
PHP + MySQL

Skills

Excel, PHP + MySQL

Related Projects