This report presents the actuals sales and gross margins for a large Canadian furniture retail company. The actual sales can be compared to the budget and can be presented on a per department basis, per store basis, per type of store basis or per geographical location basis.
Furthermore, the sales of the company can be compared to the estimated total market. This is then useful to estimate the market share as well as the penetration on a per FSA basis. In Canada, the FSA’s are the first digits of the postal codes and can prove to be very useful to map results, budgets or market on a geographical basis. Such an information is very useful when you want to implement new stores or when you would like to get a better understanding of your competition.
Also, the dashboard provides a view of the sales, per department, per store, per postal code around the store location. This is very interesting when you want to get a better feel of where your clients are coming from.
Finally, a detailed inventory can be shown, per department or per store. Such a view is critical since running out of inventory can only translate into lost sales! Not only the inventory can prove to be useful on identifying items that should go on liquidation, but it would become a very important tool to track the items that might be out of stock as well as identifying the expected dates by which new items should be received. This information will be critical in order to manage the promotions and the clients’ expectations.