Below you’ll find articles where we show the Excel formulas to calculate Gross Margin Return on Investment (GMROI), Pareto 80/20 management tips, the Turn/Earn Index, and how to calculate the effects of price increases/decreases.Posts
Auto Data Questions Answered: Automotive Part Numbers, Is There An Auto Parts Fitment Database, ACES and PIES Data
Aftermarket Analysis, Market Research
The automotive aftermarket has focused a lot on ACES and PIES product data standards in the past few years, so have you ever wondered how many total part numbers are in the automotive aftermarket? (Scroll down for ACES and PIES defined.)
Note:…
How to Calculate Gross Profit Margin Return on Investment (GMROI) to Manage Inventory
Marketing ArticlesLearn calculate GMROI (Gross Margin Return on Investment) in Excel. The Turn Earn Index and GMROI are two simple ways to help manage your inventory and run your business. Need to know the GMROI formula? Read on!
GMROI formula definition:
GMROI…
How A Price Increase/Decrease Affects Gross Profit vs. Unit Sales
Marketing Articles(Note: if you just need to calculate gross margin or mark up, please scroll down to the bottom.)
Calculate the impact of price increase on profit
If you want to increase gross margin with a price increase, you should know how gross profit…
Rule of Three Marketing: Market Share and Market Dynamics
Market Research, Marketing ArticlesWhy do some companies thrive and dominate their market segment, only to later become an afterthought? Market dynamics and the Rule of Three explains how some companies succeed and some fail.
Most industries and market segments, including…
Learn How To Do 80/20 Analysis in Excel to Analyze your Business
Marketing ArticlesLearn how to do an 80/20 analysis in Excel, and use the 80/20 principle to manage your business, reduce costs and increase your profits.
You've probably heard about Pareto's Law or the 80/20 principle, although most people only understand…