Excel Portfolio
Meineke:
We created an excel document that allows employees to input their billable hours and ticket numbers. All hours are totaled and compared to the hours worked, and a productivity percentage is calculated. The Excel program then defines the hourly wage considering the technician class, total hours worked with incentives and overtime wages. All they have to do is input the total hours worked for each day and the rest is done for them!
Piedmont Micro, Inc.:
The Dentrix sales division of the company demands a lot of calculation of Software, Hardware, Installation, Additions, etc... This Excel program allows us to select each of the parts and options for a specific job. Then at the click of a button the selected contents are combined on a new document with headings, descriptions, quantities and totals. Formated and ready to be given to the client as a sales reciept. What used to take over an hour now takes minutes.
|