-
Hierarchy structure for Chart of accounts
Current COA is a flat structure where you add main accounts and assign an account category to it.
My suggestion is to align it similar to product category hierachy.
creation of multiple hierarchy can be used for reporting and aggregation and budgeting too.like instead of budgeting at individual account level it can be then elevated to category level.
-
Forecasting at product category level
Today all forecasting is at the product and dimension level.
For retail industry the merchandise planning begins at the category level and then to stores and then products.
Idea here is to leverage the product category hierarchy and build forecasting there with the ability to break down using a seasonality to product level.
second part to that is using the actual sales history for allocation to stores or sites/ warehouses.