In parts I and II of *Business of Editing: What to Charge*, we discussed the effective hourly rate (EHR), how to calculate a true EHR, why it is important to have a definition of what constitutes a manuscript page, and why I think it is smarter to charge by the page or project rather than by the hour. But knowing your required EHR is not enough; you need to track it as well.

I use two programs to track my EHR: Timeless Time & Expense (TT&E) and Microsoft Excel. In the case of TT&E, I am using an older version because it does all that I need. TT&E is not freeware and it is a bit pricey if all you want is to track time, but I like that it makes it easy to track multiple projects. In any event, what you need is a good timing program that will track how much time you spend on a project and give you a total time.

Excel is a program that most of you are familiar with. However, as with TT&E, it is not necessary to use Excel; any quality spreadsheet program will do.

Tracking time is key. I round total time up to the nearest quarter hour. For example, if the total time I spent on a project is 25 hours and 1 minute (25:01), I enter that as 25.25 hours. I know that somewhere along the line I missed timing a few minutes of work, so this is a way to compensate.

Another thing I do is track the time based on billing cycles. If a project is to be billed only upon completion, then I track the time until the project is complete and being billed and use the single total time. If the project is being billed in batches, then I track the time for each batch and enter the time in Excel batch by batch.

As you can see from the following image, I use a simple form to track important data.

In the sample, I have given a spread of per-page price ranges. The key, of course, is to maximize price and minimize hours. (I know that some of you will point out the high pages-edited-per-hour rate that this illustration uses. The pages and hours shown are taken from a real project. Remember, however, that this is an illustration and your figures will differ.)

What is important is that even at the lowest per-page price of $2 per page, the EHR exceeded the required EHR of $25 (based on editing 16 pages an hour; at a rate of 13 pages per hour, the EHR would still be exceeded but at 12 pages an hour, it would not be met. However, at $2.50 per page, where the illustration has a 19 pages-edited-per-hour rate, even at a rate of 12 pages per hour the EHR would be exceeded). This illustrates that it is possible to have a low rate and still meet and exceed the required EHR if you are efficient and productive. Do not, however, take this as an argument for a low per-page rate, nor an indication that you will always exceed the required EHR, nor an indication that one can always edit at such a high pages-per-hour rate — this is just an illustration of how to calculate and track the EHR.

If the per-page rate had been $2 for the whole project, the EHR would have been $38.45 based on the numbers. However, to achieve that EHR, the editor would have had to average, as indicated in the image, 19.23 pages an hour. Depending on the project and the parameters of the project, that may be doable.

But we stray off course.

The key to determining what to charge is determining your required EHR. But to determine that EHR, you have to have accumulated data. In the beginning, you guess, but as data accumulates, you can be more precise in your calculation. The important data are the EHR for each batch of submitted manuscript, as well as for the entire project, and your average number of pages edited per hour (shown in the image at the bottom far right).

Unfortunately, the image doesn’t show the column labels. Column A is the Date; B is Batch #; C is Number of Pages; D is Per-page Rate; E is Number of Hours; F is EHR; G is Charge; H is Total; and K is the Average Pages/Hour. You need the column information for the following Excel formulas to make sense.

Although the information is important, columns A and B are not needed to calculate any of the other data in the table.

The formula to calculate the EHR of column F is:

=IF(E11=0,””,(C11*D11)/E11)

where, for example, E11 represents the data in column E row 11. The “” is an instruction to leave the cell in column F blank if the data in E11 equals 0.

To calculate the Charge of column G, use the formula:

=SUM(C11*D11)

The Total column (H) needs two formulas. The first is only for the very first row of data, which in this example is row 11:

=SUM(G11)

The formula is that simple because in this instance, the Charge and the Total are identical. To calculate subsequent Totals by row, the formula is:

=SUM(G12+H11)

which means to add the new Charge found in this row (G12) to the Total in the row immediately above (H11) so that the Total in this row is a running total. Remember that the numbers (e.g., 12 in G12) represent the row number; the letter represents the column.

All of the data is row-centric; that is, the calculations are for the row only. The exception is the Total column, which is a running total.

The Profit/Loss Data row is where we get our overall information. The formulas for the various entries are as follows:

Total Pages: =SUM(C11:C22)

Total Hours: =SUM(E11:E22)

Ave Effect Hrly Rate: =IF(E24=0,””,G24/E24)

Total Billed: =SUM(G11:G22)

Project Gross Profit: =SUM(G24-D24)

Finally, the formula for the Ave Pg/H is:

=IF(E24=0,””,C24/E24)

Because I hire other editors to work on projects, I need the IC Fee and the Gross Profit percent (%) information. For those who never hire someone else, these items can be omitted. For those that do hire, you manually enter the amount of total fee paid to the other editor under the IC fee and use this formula to calculate what percentage of the total fee you retained:

=IF(G24=0,””,H24/G24)

Although not shown in the illustration, you can also track your EHR over the course of time by adding up the total hours from each project and the total billed for each project and dividing the grand total billed by the grand total hours.

With this data at hand, you can determine whether you are charging enough for your services. Adjustments can be made as needed. This information will tell you the state of health of your business. If you see that you are not making your required EHR, you need to analyze why not. Are there things that you can do to improve your efficiency and productivity? Or is the only solution to raise your prices and find new clients?

Part IV adds some clarification and Part V concludes the series, tackling the question: Why bother?

Links to the other articles in this series:

You must be logged in to post a comment.