The Budgetary Analysis Report summarizes the charges invoiced to the cost centers within the accounting period, compared to their specified budgets for the same period. This report lets you see which cost centers are over or under budget and the amount of the discrepancy. You can also run a Year-to-Date Budgetary Analysis Report that lists year-to-date amounts. Figure 6-7 shows a sample of the Budgetary Analysis Report. The report heading contains the data center name, the report name (for example, Budgetary Analysis), and the accounting period (for example, June 2005). The body of the report lists the cost center's name (as specified in the Cost Center Attributes File), (for example, Acme Products Division), the Over Budget status (if applicable), the budget amount for the accounting period, the actual charges for the accounting period, and the variance (budget amount minus charges). Negative values of the variance are shown in parentheses. Because zero balanced amounts are not compared to budgets, the "Net Charges" column amounts do not reflect any zero balance adjustments. The budget amounts and charges are totaled and the variance and status for the total are calculated. REPORT OPTIONS The available options for this report are: o Fuzz Value An OVER BUDGET message prints when the charges vary from the budgeted amount. By specifying a Fuzz Value, some tolerance is allowed before the OVER BUDGET message is produced. The default Fuzz Value is $1000, so that differences of less than $1000 between the charges and the budgeted amount are ignored. 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 Budgetary 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 the sharedprefix.MICS.CNTL(FINRPT) member. Run the Year-to-Date Budgetary Analysis Report from the Year to Date Financial Reports option IS Financial Management menu (MWF;4;2;4;3;3). The JCL for this report is in the sharedprefix.MICS.CNTL(FINRPTY) member.
Y O U R C O M P A N Y N A M E BUDGETARY ANALYSIS ACCOUNTING PERIOD: JUNE ,2005 REPORT DATE: 07/26/05 PAGE NO. - 1 COST CENTER NAME STATUS BUDGET NET CHARGES VARIANCE ----------------------------------------------- ------------ ----------------- ----------------- ----------------- ACME PRODUCTS DIVISION OVER BUDGET $0.00 $6,038.02 ($6,038.02) AUSTIN PLANT 1 OVER BUDGET $0.00 $1,107.97 ($1,107.97) DUNSMILL OVER BUDGET $0.00 $5,779.14 ($5,779.14) FIELD SERVICES OVER BUDGET $0.00 $1,400,734.36 ($1,400,734.36) MARKETING OVER BUDGET $0.00 $2,041,334.22 ($2,041,334.22) SALES $3,649,421.61 $196,419.77 $3,453,001.84 ----------------------------------------------- ------------ ----------------- ----------------- ----------------- TOTAL OVER BUDGET $3,649,421.61 $3,651,413.48 ($1,991.86) ============ ================= ================= =================
Figure 6-7. Budgetary Analysis Report
|
Copyright © 2014 CA.
All rights reserved.
|
|