Report: Production Analysis

1. On the 360Toolbox menu, click Classic Reports to open Reports - All where you can make your selection.
2. Click Production Analysis Report . This opens the Report - Production Analysis selection form.

1. Evaluate performance for companies, employees, and customers.
2. Gather statistics on the number of customers, invoices (work load), and volume by:
   • Line of Business
   • Company
   • Transaction
3. Establish goals using the comparison format.
4. Best Practices Analysis. For example:
   • Calculating the percent of total volume on various producers, companies and customers, as suggested by Best Practices.
   • Tracking the number of clients, and the number of policies, along with the number of invoice transactions, gives key Best Practices data.
5. Retention Reporting

When the Production Report is sorted by (Information Reporting By), executive or representative (any sort combination that includes executive or representative) and there is more than one exec or rep on the policy, the premium, non-premium and commissions are allocated as follows:

Allocation Percentage = Specific exec or rep commission divided by total commission for all execs or reps. The resulting percentage is then applied to the premium/non-premium, agency commission and broker commission, if any.

Example

The sort is by executive. Premium = $2,400.00, Non-Premium = $15.00, Agency Commission = $600.00, Broker Commission = $120.00, Executive #1 Commission = $30.00, Executive #2 Commission = 60.00. The executive's allocation percentages are:

• Executive #1's allocation percentage would be 1/3 (30.00/[30.00 +60.00] = 1/3).
• Executive #2's allocation percentage would be 2/3 (60.00/[30.00 + 60.00] = 2/3)

When you run the report, the Include Basis report selection is used to specify whether you want to include items based on the Invoice Effective Date, or the later of the Invoice Date or Invoice Effective Date. For Binder Billings, the Include Basis selection is used as follows:

If Include Basis = Later of Invoice Date/Invoice Effective Date

Binder Billings posted with the Binder Post Method Post Expense on Effective Date are included based on the later of the Invoice Date or Invoice Effective date.

Binder Billings posted with the Binder Post Method Post Expense After Replace on Later of Effective or Replace Date are reported after being replaced based on the later of the Replace Date or Invoice Effective Date.

If Include Basis = Invoice Effective Date

Binder Billings posted with either Binder Post Method are reported based on Invoice Effective Date.

The Production Analysis report is evaluated based on the later of invoice/invoice effective date for the date range selected.

Report Selections	What is this?
Information Reporting By	Based on the purpose of the report, you must decide how you want the report organized (sorted). Example by Company/Executive (by company, and then by executive), or by Executive/Div/Branch/Dept/Group (by executive, and then by division, by branch, by department, by group). Any business unit combinations available are based on the business units your agency has turned on. AMS360 requires a Division and Department. However, it is your choice whether you turn on Branch and/or Group. For more information on business units, see Agency Setup > Accounting Options > Business Unit Setup link. If your agency uses the Business Unit Split feature, premiums and commissions are broken out by business unit for any Information Reporting By selection that references business units.
Report Date Range	Options What is this? From List Use this option to select a pre-defined date range from the list. The default option is Current month minus 1. Select Dates Use this option to type in a specific date range not covered by the choices in the From List option.
Include Basis	Options What is this? Later of Invoice Date/Invoice Effective Date Use this option to include the date the invoice was posted, or the effective date of the invoice, whichever date is the latest, in the Report Date Range option. Invoice Effective Date Use this option to only include the Invoice Effective Date in the Report Date Range option. See the Binder Billings section of this topic for more information about how Binder Billings are reported for each type of Include Basis.
Business Unit	Click to open the Business Unit Selections window where you can choose the Business Unit combinations you want to include in the report. AMS360 uses the business unit found on billing transactions to filter the information appearing on the report. If your agency uses Business Unit Split, and you limit the Business Units on the report, the full policy amount may not appear on your report.
Report Type	There are three Report Types available: LOB Detail The LOB Detail report always uses Line Of Business as the lowest level sort. Summary The summary report summarizes the production data by the choice made in the Information Reporting By field. Example If you chose to report by Executive, the report gives summary totals for each executive (no detail). check box/Field What is this? With Ranking Select the With Ranking check box to rank the production data. Ranking Selection How do you want to rank the Reporting By entity(s). Example You could rank the executives (reporting by) by premium volume (ranking selection), highest to lowest. Ranking Value If you want to limit your report by a particular number of Reporting By entities, then you would select a Ranking Value. Example Using the example above, only include the top 10 (ranking value) executives by premium volume. Comparison Select the Comparison option if you want to compare one production reporting period with another. The information is summarized by the Information Reporting By (sort) entities. Options What is this? From List Mark the From List option, and choose a date range from a pre-determined list for comparison. For example: the default date range is "Current month".   When a date range is selected from the list, the appropriate date range appears below the selection. Select Dates Mark the Select Dates options, and select a date range in the From and To date fields for comparison, or use the Date Picker to select the dates.
Policy Selections	check box/Fields What is this? Bill Method You can run the report for All direct bill and agency bill business, or limit the report to Agency bill or Direct bill business only. Customer If you want to limit your production report to one customer, type in a partial customer name and click Search. This takes you to the Customer Search form where you can make your selection. All The All check box is checked by default and when checked includes all customers. Only Policies Checked as New Business If you check this box, only policies with the "Business New to Agency" box checked in Basic Policy Information are evaluated for reporting. Customers Added on or After To limit your report to include only those customers added since a particular date, select the All check box and type in, or select a date using the date picker. The customer added date field is the date you enter a new customer, or the date you change the status of a prospect or suspect to a customer.
Transaction Reporting	Options What is this? Reporting Available for All Transactions Click this option if you want to report One, All, or Multiple standard policy transactions from the Transactions drop-down list. Reporting Based on Original Transaction Click this option if you want policy transactions to report based on the original transaction of New or Renewal business. In other words: Report as New Business, all policy transactions where the transaction effective date is within the NBS term, or where the transaction effective date is within 12 months of the NBS effective date. Report as Renew policy business, all policy transactions associated with an original policy term except those transactions that have a NBS transaction code or those that have an RWL transaction code and are equal to or less than 12 months from the original NBS effective date. You can select to include: All business New Business Renewal Business
Personnel	Fields What is this? Exec Select to include business for One, Multiple, or All executives. Rep Select to include business for One, Multiple, or All representatives. Broker Select to include business for One, Multiple, or All brokers.
Business Unit	Click the link to open the Business Unit Selections form and make your selections.
Full Production Volume for All Personnel	Check this box to report full premium/non-premium/agency commission and gross profit for All Executives and Representatives, which includes primary and additional personnel who receive commission.
Company	Fields What is this? Type Select to include business for only Insurance, Brokerage, or All insurance and brokerage companies on the report. Parent Select to include business for One, Multiple, or All parent companies. The parent company list only includes the companies that belong to the selected Type of company. Writing Select to include business for One, Multiple, or All writing companies. The writing company list only includes the companies that belong to the selected parent company. To run a report for writing companies across parent companies, multi-select the Parent companies. Then, multi-select the Writing companies from the list.
Lines of Business	Fields What is this? Type Select to include All type of business or select only: Benefits Commercial Lines Financial Services Health Life Non-Property & Casualty Personal Lines LOB Select to include business for One, Multiple, or All lines of business. The LOB list includes only the lines of business that belong to the selected Type of business.
Description	Accept the default description, or enter a new one that describes the report you are requesting.
Print Cover Page	Allows you to include a cover page listing the selected options included in the report. This option defaults as checked.
Prompt	To set a report reminder that certain selections need to be changed before the report is run, do the following: Mark the Prompt check box. Enter the reminder message in the Selections to Verify text box, for example "Verify Report Date Range." Save and close the report. The next time you attempt to print, print preview or create a CSV file for this report, you will get a reminder message that particular selections need to be checked before the report can be run. Open the report selections and modify as necessary. Then, run the report.
Selections to Verify

The Production Analysis Report counts: Number of Customers, Policies, and Invoices, can vary for the different "Information Reporting By" (sort) selections.

Example

• Customer A - Pol1, Safeco, Commercial Property. Pol2, Allstate, Commercial Property and Bus Auto
• Customer B - Pol3, Allstate, Bus Auto. Pol4, Allstate, Commercial Prop
• Customer C – Pol5, Safeco, Commercial Prop, Bus Auto. Pol6, Safeco and Bus Auto

All policies have a single exec, Kauffman, and are for the Seattle Division

Summary report, Information Reporting By = Division

Summary report, Information Reporting By = Company

Summary report, Information Reporting By = Line of Business

Summary report, Information Reporting By = Exec

The Production Analysis Report premium, non premium, and commission totals should match when the only change for the report is the Information Reporting By (sort) selection.

In the example above, a sort by division counts each unique customer for the division. A sort by company counts each unique customer for the company. Since Cust A  has a policy with Safeco and a policy with Allstate, but all customers have policies in Safeco division, a summary report by division and a summary report by company have different customer counts.

In the example above, a sort by Line of Business counts each unique customer, policy, and invoice for the Line of Business. A sort by Exec counts each unique customer, policy, invoice for the Exec. Cust A and Cust C have policies with both Commercial Property and Business Auto. Therefore, a summary report by Line of Business and a summary report by Exec have different customer, policy, and invoice counts.