LEE Electronics

6 Pages 1585 Words

Executive Summary
Objectives & Results

· The Purpose of this project was to establish a foundation by which Leading Edge Electronics can evaluate the overall profitability for each account number and model number.
· Results show that approximately 3% of the total accounts represent over 75% of the total profit margin. It was also found that less then 6% of the total models accounted for over 95% of the total profit margin.

Supporting Reasoning & Methodology

· The original data was cleaned (Exhibit 1) to provide more accurate data for analysis.
· The data was organized into the seven different business classes of products and further analyzed based on volume, revenues and profits (Exhibit 2). Upon further inspection, it was concluded that CEG, with 49% of total revenues and 34% of profits, would be the most appropriate business class to develop the framework for future analysis.

· The CEG data was isolated and segmented, based on profit margins, into ABC classes for both account numbers and model numbers. The “A” class consisted of customers and models that accounted for 75% of total profits in their respective classes. The “B” class consisted of the next 20% of total profits while the “C” class made up the remaining 5%. The breakdown is as follows:

Customer Breakdown
ABC Class Number of Accounts % of Total Accounts Total Margin % of Total Margin
A 87 3.07% 73,028,058.37 75.07%
B 184 6.49% 19,453,205.12 20.00%
C 2564 90.44% 4,802,088.65 4.94%
Totals 2835 100.00% 97,283,352.14 100.00%

Model Breakdown
ABC Class Number of Models % of Total Accounts Total Margin % of Total Margin
A 24 2.56% 73,415,950.13 75.47%
B 30 3.21% 19,592,776.25 20.14%
C 882 94.23% 4,274,625.76 4.39%
Totals 936 100.00% 97,283,352.14 100.00%

· Once the breakdown was established, a matrix was derived based on the ABC analysis for both the customers and model numbers ...