Projected Sales based on Days Booked
We need the number of days per month to reflect the number of days we have sold in the period (ie if 6 days are sold over a 6 month period, it should show as 1 day per month)

-
Tony McNeill commented
great idea
-
Jo Young commented
A number of our contractors work part time - so projected sales needs to reflect how many days they actually work a month, rather than assuming that they are full time, otherwise the projects are completely useless.
One way of doing this would be to divide the number of days in the contract by the number of weeks in the in the contract time period and allocating accordingly.