Reporting Examples › 6.9 Quantify Costs Recovered for CICS Usage

6.9 Quantify Costs Recovered for CICS Usage

PROBLEM:

    An approximation of the cost that is being recovered by
    the chargeback algorithm for use of the CICS services
    for the last six months is needed.


DATABASE FILES TO BE ACCESSED:

    &PCICM..CICCSY01-06
        Last six month's CIC System Activity File.


SUGGESTED SAS FACILITIES TO BE USED FOR REPORTING:

    PROC CHART to provide histogram of CICS charges by month.


SAS CODE EXAMPLE:

************************************************************;
* CICS FINANCIAL ANALYSIS                                  *;
************************************************************;
OPTIONS  S=62; /*For Title 2*/
DATA;
SET &MCICM..CICCSY01 &MCICM..CICCSY02 &MCICM..CICCSY03
    &MCICM..CICCSY04 &MCICM..CICCSY05 &MCICM..CICCSY06;
FORMAT YRMM $5. CICCOST DOLLAR7.2;
CICCOST=(CSYCPUTM * 0.06) + (CSYEXCPS/1000 * 3.60) +
        (CSYTRANS * 0.05);
ADJYEAR=YEAR-100;
YRMM=PUT(ADJYEAR,2.) || '-' || LEFT(PUT(MONTH,2.));
PROC CHART; VBAR YRMM / TYPE=SUM SUMVAR=CICCOST;
TITLE "MONTHLY CHARGES (DOLLARS) APPLIED TO CICS USAGE";
TITLE2 "CHARGING ALGORITHM OF $0.06 PER CPU SECOND, $3.60 PER
1000 EXCPS, AND $0.05 PER TRANSACTION";


GENERATED OUTPUT REPORT:

    Figure 6-6 illustrates the output reports produced by the
    SAS code illustrated above.

 
                                          MONTHLY CHARGES (DOLLARS) APPLIED TO CICS USAGE       16:18 THURSDAY, APRIL 20, yyyy
                     CHARGING ALGORITHM OF $0.06 PER CPU SECOND, $3.60 PER 1000/EXCPS, AND $0.05 PER TRANSACTION
 
 
                        CICCOST SUM
 
                                 |                                           *****
                                 |                                           *****
                          270000 +                                           *****       *****       *****
                                 |                                           *****       *****       *****
                                 |                   *****                   *****       *****       *****
                                 |                   *****                   *****       *****       *****
                          240000 +                   *****       *****       *****       *****       *****
                                 |                   *****       *****       *****       *****       *****
                                 |                   *****       *****       *****       *****       *****
                                 |                   *****       *****       *****       *****       *****
                          210000 +                   *****       *****       *****       *****       *****
                                 |                   *****       *****       *****       *****       *****
                                 |                   *****       *****       *****       *****       *****
                                 |                   *****       *****       *****       *****       *****
                          180000 +                   *****       *****       *****       *****       *****
                                 |                   *****       *****       *****       *****       *****
                                 |                   *****       *****       *****       *****       *****
                                 |                   *****       *****       *****       *****       *****
                          150000 +       *****       *****       *****       *****       *****       *****
                                 |       *****       *****       *****       *****       *****       *****
                                 |       *****       *****       *****       *****       *****       *****
                                 |       *****       *****       *****       *****       *****       *****
                          120000 +       *****       *****       *****       *****       *****       *****
                                 |       *****       *****       *****       *****       *****       *****
                                 |       *****       *****       *****       *****       *****       *****
                                 |       *****       *****       *****       *****       *****       *****
                           90000 +       *****       *****       *****       *****       *****       *****
                                 |       *****       *****       *****       *****       *****       *****
                                 |       *****       *****       *****       *****       *****       *****
                                 |       *****       *****       *****       *****       *****       *****
                           60000 +       *****       *****       *****       *****       *****       *****
                                 |       *****       *****       *****       *****       *****       *****
                                 |       *****       *****       *****       *****       *****       *****
                                 |       *****       *****       *****       *****       *****       *****
                           30000 +       *****       *****       *****       *****       *****       *****
                                 |       *****       *****       *****       *****       *****       *****
                                 |       *****       *****       *****       *****       *****       *****
                                 |       *****       *****       *****       *****       *****       *****
                                 -------------------------------------------------------------------------
                                         08-10       08-11       08-12       09-1        09-2        09-3
 
                                                                    YRMM
 
 

Figure 6-6.  CICS Monthly Financial Analysis Trend