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
Product Data Questions Answered: ACES and PIES Data, Is There An Auto Parts Fitment Database, Automotive Part Numbers
Aftermarket Analysis, Market ResearchThe automotive aftermarket discusses ACES and PIES product data standards a lot. Here we define the ACES and PIES product data standards, and reveal how many aftermarket part numbers exist.Note: for more information on PIES data and…
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…
Small Company Growing Pains: Learn the Growth Stages of a Company
Marketing ArticlesLearn the growth stages of a company Growth stages of a company tend to be similar across different businesses. As a business grows, it goes through distinct stages of growth. These stages have unique characteristics and challenges and require…
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 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…
