The Revenue/Credit Trend Analysis Report presents a monthly history for the year, up to the previous month, of the charges and credits for a given cost center compared to its budget. This report allows management to analyze the amount of credits applied to a given cost center in relation to its expenditures. This may be a key indicator of cost center operational problems. Figure 6-12 shows a sample Revenue/Credit Trend Analysis Report. The report heading contains the installation name, the name of the cost center (Middle-Atlantic Department), the report name (Revenue/Credit Trend Analysis), and the accounting period (June, 2002). The body of the report lists the charges, credits, and net charges for the cost center for the last 12 months. For reference, the report also shows the monthly budget and variance from budget (budget amount minus net charges). REPORT OPTIONS The available option for this report is: o Cost Center Selection You can run this report for all billable customers (cost centers), all non-billable customers, or both. The STATUS variable in the Financial Recap File (derived from Billing Status in the Cost Center Attributes File) indicates whether a cost center is billable. Specifying a SYSPARM parameter of STATUS=BILL, STATUS=NOBILL, or STATUS=BOTH determines which cost centers appear on the report. The default is BOTH. RUNNING THE REPORT Run the Revenue/Credit Trend Analysis Report from the Financial Reports option of the IS Financial Management Menu (MWF;4;2;4;3;2). The JCL for this report is in sharedprefix.MICS.CNTL(FINRPT).
Y O U R C O M P A N Y N A M E REVENUE/CREDIT TREND ANALYSIS ACCOUNTING PERIOD: JUNE, 2002 REPORT DATE - 07/26/02 DEPARTMENT: MIDDLE-ATLANTIC Page No. - 1 MONTH JAN FEB MAR APR MAY JUN ----------- --------- --------- --------- --------- --------- --------- CHARGES 128,276 118,312 142,196 138,789 156,867 152,554 CREDITS 8,234 6,543 1,975 1,472 9,927 5,768 --------- --------- --------- --------- --------- --------- NET CHARGES 120,042 111,769 140,221 137,317 146,940 146,786 --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- BUDGET 140,000 112,000 140,000 140,000 140,000 140,000 --------- --------- --------- --------- --------- --------- VARIANCE 19,958 231 (221) 2,683 (6,940) (6,786) MONTH JUL AUG SEP OCT NOV DEC ----------- --------- --------- --------- --------- --------- --------- CHARGES 155,831 171,608 178,825 . . . CREDITS 274 3,246 11,699 . . . --------- --------- --------- --------- --------- --------- NET CHARGES 155,557 168,362 167,126 . . . --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- BUDGET 170,000 170,000 170,000 170,000 170,000 170,000 --------- --------- --------- --------- --------- --------- VARIANCE 14,443 1,638 2,874 . . .
Figure 6-12. Revenue/Credit Trend Analysis Report
|
Copyright © 2014 CA.
All rights reserved.
|
|