Mungo Dunnett Associates: Management and Marketing Consultancy

Stock Control

What Mungo Dunnett Associates delivered?

Development of Access database, linked to existing in-house Sage accounts system. This drove the analysis to provide key product data, as below.

Promotional/sales analysis

Identification of profit margin per SKU, based on determining marginal costs including promotional costs

Assessment of the efficiency of sales and marketing activities in driving profitable sales (Return On Investment analysis)

Product analysis

Ranking of SKUs by profit margin

Identification of substantial skew in profit towards small % of SKUs

Means of determining which SKUs should be terminated

Division of SKUs into ‘tiers’, allowing separate stock levels and re-order levels in accordance with profitability and stock turn volatility