Menu
This is one of 4546 IT projects that we have successfully completed with our customers.How can we support you?
Sales planning for fashion items
Project duration: 11 months
Brief description
An existing Excel application is enhanced to include a new limit calculation/replacement control. Here, planned and actual stocks are compared in terms of quantity and value to determine the free or exceeded limit at the sales area, product group, subgroup and type levels (depending on what levels were included in planning).
Supplement
The application is developed entirely in Office VBA (Microsoft Excel 2003) with access to MS Access and SQL Server 2005 (via ODBC).
Subject description
In the limit calculation, the data scheduled in purchasing planning is estimated again at a later time in order to identify any repurchasing. The new estimate is made easier by also importing the actual data identified up to that point. The "limit calculation" is only released once purchasing planning is complete. It is released by the company management or the division management.
Overview
- Branchen trade
- Fachaufgaben inventory alterations, inventory management, inventory planning, purchasing, Reporting
- DV-Aufgaben customised software new development
- Systemumgebungen Client/Server
- Vorgehensmodell PTA project manual
- Datenbanken MS SQL Server
- Betriebssysteme Windows NT
Project periodProjektzeitraum01.07.2008 - 31.05.2009
Have we sparked your interest?
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
© Copyright 2024 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
