home *** CD-ROM | disk | FTP | other *** search
/ Gold Fish 1 / GoldFishApril1994_CD2.img / d4xx / d431 / advtemplates / law.lzh / Law / FIRMPROD.ADV (.txt) < prev    next >
Gold Disk Spreadsheet  |  1991-01-12  |  8KB  |  129 lines
  1.       FIRM PRODUCTIVITY ANALYSIS
  2. ------------
  3. ------------
  4. ------------
  5. ------------
  6. ------------
  7. ------------
  8. ------------
  9. ------------
  10. ------------
  11. ------------
  12. ------------
  13. ------------
  14. ------------
  15. ------------
  16. ------------
  17. ------------
  18. ------------
  19. ------------
  20. ------------
  21. ------------
  22. ---------
  23.  BILLABLE
  24.  BILLED
  25.     VALUE OF
  26.  EFF.
  27.  % TO
  28.    CASH
  29.   % TO
  30.        HOURS
  31.   HOURS
  32. BILLED HRS
  33.  RATE
  34.     PR. PER.
  35.  RECEIPTS
  36.     BLD. HRS
  37.  EXPENSES
  38. MARGIN
  39. ------------
  40. ------------
  41. ------------
  42. ------------
  43. ------------
  44. ------------
  45. ------------
  46. ------------
  47. ------------
  48. ------------
  49. ------------
  50. ------------
  51. ------------
  52. ------------
  53. ------------
  54. ------------
  55. ------------
  56. ------------
  57. ------------
  58. ------------
  59. ---------
  60. 19____
  61. 19___
  62. 19___
  63. 19___
  64. ---------
  65. ---------
  66. ---------
  67. ---------
  68. ---------
  69. ---------
  70. ---------
  71. ---------
  72. ----------
  73. ---------
  74. ---------
  75. ---------
  76. ---------
  77. ---------
  78. ---------
  79. ---------
  80. ---------
  81. ---------
  82. ---------
  83. ---------
  84. ---------
  85. 6WORK-IN-PROCESS FOR PERIOD ENDED ____________ 19_____
  86. $0.00
  87. WRITE-OFFS THIS PERIOD
  88. $0.00
  89. WRITE-OFFS TO DATE
  90. $0.00
  91. ACCOUNTS RECEIVABLE BALANCE
  92. $0.00
  93. % INCREASE/
  94. ACCTS RECEIVABLE ANALYSIS
  95.  DECREASE
  96. ---------
  97. ---------
  98. ---------
  99. ---------
  100. ---------
  101. ---------
  102. ---------
  103. YEAR:
  104. YEAR:
  105. YEAR:
  106. YEAR:
  107. 0PROFITABILITY ANALYSIS (NET PROFIT PER PARTNER)
  108. % INC/DEC
  109. YEAR:
  110. $0.00
  111. YEAR:
  112. $0.00
  113. YEAR:
  114. $0.00
  115. YEAR:
  116. $0.00
  117. '* FORMULA: NIPP = (1 + L)(U)(BR)(R)(M)
  118. E  - LEVERAGE (L): THE RATIO OF NON PARTNER PROFESSIONALS TO PARTNERS
  119. U  - UTILIZATION (U): THE WEIGHTED AVERAGE CHARGEABLE HOURS PER PROFESSIONAL PER YEAR
  120. C  - BILLING RATE (BR): THE WEIGHTED AVERAGE STANDARD RATE PER HOUR
  121. r  - REALIZATION (R): THE PERCENTAGE OF TIME WORKED ON CLIENT PROJECTS (VALUED AT STANDARD RATES) THAT IS ACTUALLY
  122.  BILLED AND COLLECTED
  123. 6  - MARGIN (M): THE RATIO OF NET INCOME TO GROSS FEES
  124. LEVERAGE =
  125. UTILIZATION =
  126. BILLING RATE =
  127. REALIZATION =
  128.     MARGIN =
  129.