Feed sales history by month from point of sale system. Sum up sales data by store, department and month. Every month load data from source system to planning system. For small business feed data using excel only. For enterprise level data data connectivity tool help for live connection.
Inventory Turn key is yearly turn rate for inventory. If same assortment sold 3 times in year then turn key is 3. Turn key is decided based on country growth rate and Consumer puraching index and historical sales data.
Based on sales forecast and inventory turn key last month end of month inventory is calculated.
Based on sales forecast and inventory turn key current month end of month inventory is calculated.
Estimated Open to buy value is calculated based on Sales, annual or seasonal turn key, End of month inventory, begin of month inventory.
"On order" data is feed on each month to update suggested OTB and actual OTB adjustment.
Monthly cut over activity is action from end user to update last month actual data like, Last month actual sale, last month actual End of month inventory. Including current month beginning inventory. Once these values are setup. OTB summary for current month is suggested. Department with over inventory and below inventory with exact numbers are shown for further action in current month. Fluctuation on season level on inventory values are singling for buyer to further take action on mark down and season level demand estimation. Suggested OTB values are further taken in account for preparing purchase order.
Given assortment OTB software is based on Office Excel. User can easily prepare and load data from source data on each cut over cycle (monthly) by excel only. Underlying technology is not limited to excel only. It uses MS SQL server and OLAP technology for data store and processing. Which is well designed to store and process data up to 5 TB volume. Which is good enough for approximately 1000 store x 100 thousand products and 10 years data. For enterprise level application data ETL is design for automated way. Engineers can keep system monitoring and connect with various kind of source systems. Cloud subscription is one of the option of end user to quick start application using AWS and Azure cloud.