Reporting Metric Template

Reviews

Shared by: gigi12

Tags

Reporting Metric Template, DvD Movies, video rental, video rental software, Rental Software, video games, rental business, Rental System, business system, home rentals

Stats

views:: 46
rating:: not rated
reviews:: 0
posted:: 11/16/2008
language:
pages:: 0

Public Domain

DISTRIBUTOR PERFORMANCE METRICS V1.3 AUC RULE 004: ALBERTA TARIFF BILLING CODE (V1.4) TABLE OF CONTENTS 1. DISTRIBUTOR – PERFORMANCE METRICS .................................................................................... 3 1.1 1.2 1.3 1.4 CURRENCY OF TARIFF BILL FILE CONTENT ..................................................................................... 3 FILE COMPLETENESS .................................................................................................................... 5 INVALID FILE REJECTIONS ............................................................................................................. 7 INVALID FILE DISPUTES ................................................................................................................. 9 1 • Distributor Performance Metrics (AUC Rule 004) 1. DISTRIBUTOR PERFORMANCE METRICS 1.1 Currency of Tariff Bill File Content Measure: Percentage of all sites with a site production reason code of “2020 – Regular Bill Cycle” published in original tariff bill files, where the number of business days from the current bill period end date for each site to the tariff bill file date created is less than or equal to 8 business days.1 Reporting Period: Target Metric: 95.0% Actual Results: Time Period Month1 Month2 Month3 Quarter Distributor ID Target Actual Variance* Compliant (Y=Yes/N= No) N Y Y Y 0020 0020 0020 0020 95.0% 95.0% 95.0% 95.0% 94.0% 96.0% 98.0% 96.0% -1.0% +1.0% +3.0% +1.0% * Variance will need to be included in the explanation of results section and must represent the difference between the target and actual performance (i.e. if target is a percent, represent variance as a percent; if target is a count, represent the variance as a count. Negative variance represents under performance; Positive variance represents over performance.) NOTE: Provide supporting data for the table above using the Excel Workbook Template that describes detailed data submission requirements and formatting that must be followed before submitting to the AUC. 1 Distributors are exempt from including sites belonging to a seasonal bill cycle (i.e. irrigation) and sites dependent on transmission tariff information from the ISO when reporting their performance for this metric. 3 • Distributor Performance Metrics (AUC Rule 004) Currency of Tariff Bill File Contents 99.0% 98.0% Percentage of Sites 97.0% 96.0% 95.0% 94.0% 93.0% 92.0% Month1 Month2 Tim e Period Month3 QTR Explanation of Results: Month 1 Month 2 Month 3 Quarter Year-End Review (applies to 4th Quarter report) Comments: 4 • Distributor Performance Metrics (AUC Rule 004) 1.2 File Completeness Measure: Percentage of all sites assigned to bill cycles transmitted in original tariff bill files with a site production reason code of “2020 – Regular Bill Cycle” on their scheduled tariff bill file publish date as stated in the tariff bill calendar file.2 Reporting Period: Target Metric: 98% Actual Results: Time Period Month1 Month2 Month3 Quarter Distributor ID Target Actual Variance* Compliant (Y=Yes/N= No) N Y Y Y 0020 0020 0020 0020 98.0% 98.0% 98.0% 98.0% 96.0% 100.0% 98.0% 98.0% -2.0% +2.0% 0.0% 0.0% * Variance will need to be included in the explanation of results section and must represent the difference between the target and actual performance (i.e. if target is a percent, represent variance as a percent; if target is a count, represent the variance as a count. Negative variance represents under performance; Positive variance represents over performance.) NOTE: Provide supporting data for the table above using the Excel Workbook Template that describes detailed data submission requirements and formatting that must be followed before submitting to the AUC. 2 Distributors are exempt from including sites belonging to a seasonal bill cycle (i.e. irrigation) and sites dependent on transmission tariff information from the ISO when reporting their performance for this metric. 5 • Distributor Performance Metrics (AUC Rule 004) File Com pleteness 100.0% 99.0% Percentage of Sites 98.0% 97.0% 96.0% 95.0% 94.0% Month1 Month2 Tim e Period Month3 QTR Explanation of Results: Month 1 Month 2 Month 3 Quarter Year-End Review (applies to 4th Quarter report) Comments: 6 • Distributor Performance Metrics (AUC Rule 004) 1.3 Invalid File Rejections Measure: Count of TRN (reject) transactions produced by a distributor per retailer per calendar month. Reporting Period: Target Metric: 0 TRN (reject) transactions per retailer per calendar month. Actual Results: Time Period* Month1 Month1 Month2 Month3 Month3 Month3 Quarter Quarter Quarter Distributor ID 0020 0020 0020 0020 0020 0020 0020 0020 0020 Retailer ID 999999999 999999997 999999998 999999999 999999998 999999997 999999999 999999998 999999997 Target 0 0 0 0 0 0 0 0 0 Count** 2 2 2 2 3 3 4 5 5 Variance*** Compliant (Y=Yes/N=No) -2 N -2 N -2 N -2 N -3 N -3 N -4 N -5 N -5 N * Disclose unique combinations of Time Period and Retailer ID. ** Report only the occurrences of TBRs (i.e. do not report 0 counts). *** Variance will need to be included in the explanation of results section and must represent the difference between the target and actual performance (i.e. if target is a percent, represent variance as a percent; if target is a count, represent the variance as a count. Negative variance represents under performance; Positive variance represents over performance.) NOTE: Provide supporting data for the table above using the Excel Workbook Template that describes detailed data submission requirements and formatting that must be followed before submitting to the AUC. 7 • Distributor Performance Metrics (AUC Rule 004) Invalid File Rejections 6 5 Total TBR Transactions 4 3 2 1 0 999999999 999999998 Retailer Month1 Month2 Month3 QTR 999999997 Explanation of Results: Month 1 Month 2 Month 3 Quarter Year-End Review (applies to 4th Quarter report) Comments: 8 • Distributor Performance Metrics (AUC Rule 004) 1.4 Invalid File Disputes Measure: Count of TBD transactions that have been rejected by a distributor per retailer per calendar month. Reporting Period: Target Metric: 0 rejected TBDs per retailer per calendar month. Actual Results: Time Period* Month1 Month1 Month2 Month3 Month3 Month3 Quarter Quarter Quarter Distributor ID 0020 0020 0020 0020 0020 0020 0020 0020 0020 Retailer ID 999999999 999999997 999999998 999999999 999999998 999999997 999999999 999999998 999999997 Target 0 0 0 0 0 0 0 0 0 Count** 2 2 2 2 3 3 4 5 5 Variance*** Compliant (Y=Yes/N=No) -2 N -2 N -2 N -2 N -3 N -3 N -4 N -5 N -5 N * Disclose unique combinations of Time Period and Retailer ID. ** Report only the occurrences of TBDs (i.e. do not report 0 counts). *** Variance will need to be included in the explanation of results section and must represent the difference between the target and actual performance (i.e. if target is a percent, represent variance as a percent; if target is a count, represent the variance as a count. Negative variance represents under performance; Positive variance represents over performance.) NOTE: Provide supporting data for the table above using the Excel Workbook Template that describes detailed data submission requirements and formatting that must be followed before submitting to the AUC. 9 • Distributor Performance Metrics (AUC Rule 004) Invalid File Disputes 6 5 4 3 2 1 0 999999999 999999998 Retailer Month1 Month2 Month3 QTR 999999997 Explanation of Results: Month 1 Month 2 Month 3 Quarter Year-End Review (applies to 4th Quarter report) Comments: 10 • Distributor Performance Metrics (AUC Rule 004) Total TBD Transactions