Member Fixed Fee Ticket Analysis
What is the Member FF Ticket Analysis Report and How is it Used?
The Member Ticket Analysis report takes the FF Tickets report a step further. In this report, a ticket is selected and then analyzed. The body of the report contains the shadow billable for the time period and the revenue. Each section shows totals by month for the ticket.
Filters
The report can be filtered on the specific ticket. Tickets are listed in the pull-down menu (1). Inactive members can also be excluded from the report (2).
Note: Each of the reports can be downloaded in either PDF format or as an Excel/CSV spreadsheet using the icons at the right on the Filters heading . The "+" allows you to store the reports for later download. You can also save the report to use in Recurring Deliveries.
Make sure to click the Filter button to have the filter changes take effect.
Body of Report
Each member who put time into the FF Ticket is listed as a line item, both for their shadow billable per month and then the revenue attributed to them. This happens for each non-closing month (closing month is set in your PSA). In the closing month, the actual revenue is considered and attributed to any member who worked on the FF Ticket. If more revenue has been attributed in the non-closing months, the revenue can be negative.
The Shadow Billable section lists the members who worked on the ticket and a breakdown by month of the shadow billable. A more detailed set of information on a specific line can be seen by clicking on the pie under a given month.
The Revenue section shows the members who worked on the ticket and the monthly revenue.
Ticket Totals
The last section of the report is an analysis of the full ticket revenue distribution. The line shows all revenue which has been attributed to the FF Ticket, all of the Shadow Billable time of the members working on the ticket over the length of the ticket.
The goal of MSPCFO is to align the revenue of the FF ticket to the work that is done by the members during the length the ticket is worked. Each month, revenue credit is assigned to the member and to the ticket at a % of what would have been billed at their standard rate (% set in the Options table). The last month of the ticket is the 'Ended at' month that is in the PSA table. The month of the Last Date Worked needs to be <= the month of the Ended At. If work or invoices go beyond the month of the Ended At (set in your PSA), the resulting ticket information may be incomplete.
Some different scenario ticket totals are given as examples:
Example 1:
No revenue was recognized as labor revenue for this FF Ticket. Members put in time that would amount to $2,290.20 in actual rate work had they billed at their rates. Therefore there is no efficiency for this FF Ticket. If this ticket was worked over a period of months, any revenue credit in months previous to the close month will be subtracted from both the member revenue and the FF ticket revenue.
Example 2:
$660 of labor revenue was recognized for this FF Ticket. Members put in time that would have been billed at $600.06 in actual rate work. In April, the End Month, additional credit was given to each member working on the ticket in proportion to their shadow billable to bring the revenue up to $660.
0 Comments
Add your comment