| |
|
|
|
|
|
|
|
|
|
| COMPARATIVE ANALYSIS THROUGH AUGUST |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| NAME |
TOTAL |
CHARGE |
PERCENT |
HOURS |
WRITEUP |
BILLING |
BILLING |
PROFIT |
PROFIT PER |
| YEAR |
HOURS |
HOURS |
CHARGABLE |
BILLED |
WRITEDOWN |
|
PER HOUR |
|
HOUR BILLED |
| |
|
|
|
|
|
|
|
|
|
| EMPLOYEE 1 |
|
|
|
|
|
|
|
|
|
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
$0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| |
|
|
|
0.00 |
|
|
|
|
|
| EMPLOYEE 2 |
|
|
|
|
|
|
|
|
|
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| EMPLOYEE 3 |
|
|
|
|
|
|
|
|
|
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| EMPLOYEE 4 |
|
|
|
|
|
|
|
|
|
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| |
|
|
|
|
|
|
|
|
|
| EMPLOYEE 5 |
|
|
|
|
|
|
|
|
|
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| |
|
|
|
|
|
|
|
|
|
| EMPLOYEE 6 |
|
|
|
|
|
|
|
|
|
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| |
|
|
|
|
|
|
|
|
|
| NON-FULL-TIME EQUIVALENTS |
|
|
|
|
|
|
|
|
| 20XX |
|
|
|
|
|
|
|
|
|
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| |
|
|
|
|
|
|
|
|
|
| TOTAL |
|
|
|
|
|
|
|
|
|
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| 20XX |
0 |
0 |
#DIV/0! |
0.00 |
$0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| |
|
|
|
|
|
|
|
|
|
| 3-YEAR |
0.00 |
0.00 |
#DIV/0! |
0.00 |
0.00 |
$0.00 |
#DIV/0! |
$0.00 |
#DIV/0! |
| AVERAGE |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| LESS FIRM ADMIN |
0 |
0.00 |
#DIV/0! |
0.00 |
0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| . |
|
|
|
|
|
|
|
|
|
| NET WITHOUT FIRM ADMINISTRATOR |
0.00 |
0.00 |
#DIV/0! |
0.00 |
0.00 |
0.00 |
#DIV/0! |
0.00 |
#DIV/0! |
| as an average |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| NOTE ****THE PROFIT NUMBER COMES FROM A SEPARATE ANALYSIS CALCULATING DIRECTLY ATTRIBUTABLE COSTS SUCH AS COMP, DUES, CPE, PENSION, P/R TAXES, ETC |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|