Project Timesheet
The table to the right privides a list of completed activities and associated development times.
| Date | Activity | Hours |
|---|---|---|
| 2019/08/02 - 2019-08-08 | Demand Forecasting and MRP research | 16 |
| 2019/08/23 - 2019-08-26 | Implement testbed for demonstration of forecasting principles | 24 |
| 40 | ||
| 2019/08/27 - 2019-09-01 | Project start. Create Demand forecast bundle and implement SAP File Manager for importation of SAP files. All file import and base data display. With select delete om SAP Files. | 35 |
| 2019/09/02 - 2019-09-08 | Import data display pages for SALES, GIT SOH, PO, OP and Master data. Provide data filtering and sort capability. Build relational Material Master table. Link to plants table. Build base unit manager to determine unit conversion. Build supplier and customer table. Constuct Material console page. Added injection services for Sales Manager and Forecast Manager and other supporting managers (GIT, SOH, PO, OP). Develop command processor for data process into Material Master, customer, suppliers, plants and sales. Develop material console page forecast, ssl based on moving average. Determine stock out and stock alert. Accomodate purchase orders and goods in transit into forecasting. Build Brenntag webapp. Install on server. | 49 |
| 2019/09/09 - 2019-09-15 | Added console alert page. Review and improve forecast service. Added master material config for forecast methodology for console and material master list. Added blocked and zero stock tables to alert console. Added with select material config to material list. Added registered user widget and sales person to registered user linkage. | 20 |
| 2019/09/12 - 2019-09-12 | Preparation and Demo to Brenntag | 8 |
| 2019/09/16 - 2019/09/18 | Complete relational database and update from imported SAP files. Develope background import command. Seperate forecasting and analysis from SAP files. | 20 |
| 2019-09-19 - 2019-09/21 | Added Confirmed order manager, update to graphing, added color graph, material lead times and background processing of SAP tables to relational database. Convert all supporting service managers to support weekly analysis. Evaluate weekly processing | 19 |
| 2019-09-22 - 2019-09-24 | Added forecast alert manager for conversion of forecasts to weekly periods for analysis of stockout against ssl and purchases. Added order generation and capture. Order graphing. Order display and filter console | 20 |
| 2019-09-25 - 2019-09-25 | Repository commit. Server update, processing and evaluation and fixes. | 10 |
| 2019-09-26 - 2019-09-26 | Updated Registered User view and added orders list. Added click on order to prompt order acceptance. Added auto disable function to command processing of materials with no sales. | 6 |
| 2019-09-27 - 2019-09-30 | Review at Brenntag Boksburg. Added material status and auto disable. Added allow order flag and display. Added import support for status flag. Process and check latest SAP export. Added SSL Multiplier, default and material config. Added Supplier filter for both admin and reg user. Added comment system admin and reg user. Test import of SAP file update. Website update / SAP file update | 20 |
| 207 | ||
| 2019-10-01 - 2019-10-04 | Fixes to forecast function after month roll-over. Added filter to master data import to only load ZA entries. Added view material typeahead in reg userview to allow view of any material. Allow view of any material in admin. Website update / SAP file update. Changed open order functions to treat all so's as confirmed. | 14 |
| 2019-10-07 - 2019-10-11 | Added graph expand on material console pages. Added pdf and email report capability. Fixed sales person link to show customer without profile. Added multitomulti on customer and sales person. Updated linkage func and added prod manager select on reg user view. Added system order functionality, add, view and consolidate. Added supplier order and consolidated order entities. Fix to sales summary to include sales returns. Order status update and removal. Added fallback on material base unit and conversion based on material name. Added supplier add if not detected. Added confirmed order series to detailed graph. Added supplier order manager. Investigate missing historical sales. Add full sales import command. Re-process full sales. Fixed filter on admin Order. Added historical data import command. Added date set and quantity totals to consolidated order. Fix to soh determination of pc to kg or ltr determination. Added fix to show all proposed orders to show from current week onwards. Added un-consolidate order. | 36 |
| 2019-10-12 - 2019-10-15 | Added order acceptance and consolidation to registered user. Added merge open orders to sales forecast. Added open order merge to sales current month. Added comments page (view all) with edit and delete to admin and reg user. Added new supplier to reg user material console. Added re- forecast to reg user. Added supplier orders to add order popup. Test, eval and website update. Data import. | 16 |
| 66 | ||
| TOTAL | 313 |