Products Banner Image

Assortment Planning

Assortment planning is done extensively in Excel application and due to the nature of data pertaining to different channels of buying (licensees, E-commerce, stores, etc.), amount of data processing increases over period. Also, there is no auditing or control of data being edited.

Systems running based on Excel has following concerns that need to be addressed:

  • Multiple Excels to manage
  • Time taken for processing is longer due to macros
  • Missing accountability - no audit trail
  • Changes to AP template during every season causing more downstream changes
  • During Excel Template upgrade, must redo entire coding

Business Solution Provided by United Techno

United Techno created a WinForms solution with shared Database and Telerik Controls to provide a configurable, scalable, reliable and high-performance solution. Field creation, authentication and authorization (user level, group level, field level, row level), auto calculations, validations, export are all configurable. Admin user can do all changes on-the-fly and does not need dependency on development team for configuration set up.

Benefits Realized by Client

  • Multiple Excels to manage
  • Time taken for processing is longer due to macros
  • Missing accountability - no audit trail
  • Changes to AP template during every season causing more downstream changes
  • During Excel Template upgrade, must redo entire coding