| |
|
|
DAO Web Page of Fame |
|
Celebrating
Summer Successes Since 2006 |
|
 |
|
INDUCTEE:
Gautam Sukumar YEAR:
2007
CATEGORY:
Pivot Tables |
Gautam Sukumar used Pivot
tables and regression extensively to accurately highlight the
benefit of
configuration profitability rather than individual commodity
profitability. Historically, Dell
 performed
profitability analysis on individual components such as Hard Drive,
Memory, Processor, etc and used the results of this analysis to set
pricing for its computers. Gautam approached the problem
differently. By analyzing profitability of a combination of
individual commodities that make up a configuration, Gautam was able
to identify several insights to help Dell improve its pricing model.
One of the key highlights of the analysis was the identification of
irregular discounting worth more than $35MM. |
|