Columbia Physical Therapy Profit Sharing

Executive Summary

Columbia Physical Therapy (CPT) is a regional physical therapy company that operates in various towns in Washington, Oregon, and Idaho. The Company has grown at a steady rate over the last 25 years (approximately how long the company has been in existence). Each clinic has a clinic manager, who is a physical therapist. While the therapists are very good at managing clinics, the current accounting system is archaic.

At the end of each quarter, the company accountant calculates profit-sharing to determine what the company should distribute to each therapist. Thus, it is important that the profit-sharing numbers are calculated accurately. Because the accounting system is fairly limited, the profit-sharing is not calculated through the accounting system. Instead, the accountant uses an Excel spreadsheet to keep track of all the items used to compute the profit-sharing. In the past, the billing office manager has emailed the accountant 25 Word documents with all the relevant data (the formatting on the exported Excel documents is very difficult to use). The accountant has then copied those documents to an Excel file, and then used that data to determine profit-sharing numbers. This is a time-consuming process, sometimes taking hours or all day. The goal of my project was to create a template spreadsheet that would import the files and calculate profit-sharing for each clinic in a matter of minutes.

Links:

• http://files.gove.net/shares/files/15w/kramerkh/TestFile_Template_RecoveredData.xlsm
• http://files.gove.net/shares/files/15w/kramerkh/MBA_614_Final_Project.pdf