This Excel-based model can complete a wholesale distributor cost analysis, retail analysis or an analysis across the entire supply chain. The model is designed to be both a strategic tool, as well as, a tactical tool.
Category managers can use it to make tactical assortment, space and pricing decisions.
The model then allows companies to aggregate the data up and report results at several levels including brand, manufacturer, supplier, customer, delivery, subcategory, and category. The model is loaded with 1999-2000 ABC data. Model owners will receive new models when the ABC factors are updated. There are two ways to customize the model. A custom input screen is provided to allow companies to update the most sensitive numbers like wage rates, cost of capital and operating costs, very easily.