APS排程管理系統(tǒng)
APS的功能包括考慮供需平衡的規(guī)劃，提供決策支持功能。它能夠幫助企業(yè)快速制定符合各種生產(chǎn)約束條件（人機(jī)料法環(huán)）、滿足計(jì)劃目標(biāo)與策略的、優(yōu)化的詳細(xì)生產(chǎn)作業(yè)計(jì)劃，實(shí)現(xiàn)縮短制造提前期，削減庫存，提高交貨期的遵守，有效地實(shí)現(xiàn)客戶的利益增長。
APS排程系統(tǒng)是一種基于有限產(chǎn)能的、自動化的智能的高級計(jì)劃排程與調(diào)度系統(tǒng)。它能夠幫助企業(yè)快速制定符合各種生產(chǎn)約束條件，滿足計(jì)劃目標(biāo)與策略的、優(yōu)化的詳細(xì)生產(chǎn)作業(yè)計(jì)劃，實(shí)現(xiàn)縮短制造提前期，削減庫存，提高交貨期的遵守，有效的實(shí)現(xiàn)客戶的利益增長。
APS排程系統(tǒng)分為以下核心模塊：基礎(chǔ)數(shù)據(jù)即通用建模，核心算法，計(jì)劃調(diào)度等模塊。根據(jù)面臨的困境和業(yè)務(wù)現(xiàn)狀，APS排程系統(tǒng)提供多種應(yīng)用場景的應(yīng)對方案，滿足各種應(yīng)用需求，覆蓋生產(chǎn)計(jì)劃七大難點(diǎn)，跟蹤生產(chǎn)計(jì)劃從制定到執(zhí)行的每一個重要環(huán)節(jié)，提供科學(xué)高效的計(jì)劃排程方法，滿足企業(yè)計(jì)劃調(diào)度和排程需求。
The main purpose of this document is to define best ETA, sailing schedule and shipment summary
Transports team has already built an access tool to do best ETA and reporting function.
Original excel files in access:
Name | Purpose |
T_BookingRequest | Data copies from booking request.xlsx, which records the demands from suppliers. |
T_CPTransportZone | Master Data (Maintained by users) |
T_DetentionandDemurrage | Master Data (Maintained by users) |
T_OncarriageLeadTime | Master Data (Maintained by users) |
T_Order | Data copies from order.xlsx |
T_OTDSCTimeWindow | Master Data (Maintained by users) |
T_SailingSchedule | Master Data (Maintained by users) |
T_Shipment | Data copies from shipment.xlsx |
T_TransitOrderLeadTime | Master Data (Maintained by users) |
Process:
1. Users extract files from different system and external suppliers.
2. All the data is imported into access database by link connection.
3. Macro buildup behind in access tool makes users run the report.
Weakness:
· Users can read and write the raw data directly, which will lead to mistakes happens.
· No more than 2 users can use this tool in the same period and easily be locked.
· Running speed is not good due to which data imported from different excel files.
