Developed System for Income / Expense Projections
I worked with him closely and taught him how to use Excel. It took him out of his comfort zone at first, but soon he was quite happy to no longer be using paper sheets and his hand calculator.
Based on his paper spreadsheets I developed a system of 13 interdependent spreadsheets with the various cost centers, inventory, expenses, etc. The spreadsheets were scripted so that a change in one would update the appropriate summary items elsewhere.
This system allowed the executives at the record label to easily propose 'what if?' scenarios and to plan more carefully. Over time we were able to improve the quality of the Income/Expense Projections system by comparing our projections with actual income and expense data and tweaking the system's variables accordingly.