Docket No. RM2017-8

Library Reference PRC-LR-RM2017-8/1

Tables 2 and 3 IOCS-Estimated and TACS-Adjusted IOCS-Estimated, respectively, FY 2016 Quarterly City Carrier Letter Route and Special Purpose Route Delivery (Street Time) Costs and SAS Programming Code

Table 2: IOCS-Estimated FY 2016 Quarterly City Carrier Letter Route and Special Purpose Route Delivery (Street Time) Costs

Type of City Carrier Route Street Time Cost1 / FY 2016 Quarters
1
(Oct.-Dec. 2015) / 2
(Jan.-Mar. 2016) / 3
(Apr.-Jun. 2016) / 4
(Jul.- Sept. 2016)
City Carrier Street Time Costs ($ in Thousands)
Total Letter Routes / 3,034,450 / 2,952,046 / 2,958,906 / 2,951,728
Total Special Purpose Routes(SPR) / 141,570 / 111,521 / 121,337 / 114,050
Exclusive Parcel Post SPR / 58,795 / 33,207 / 37,615 / 35,028
Combination/Other SPR / 44,966 / 47,430 / 47,893 / 40,473
1 IOCS activity code 6710 in variable F262 using the IOCS cost weight variable F9250.
Source: Commission generated IOCS-estimates using Docket No. RM2017-9, Library Reference USPS-RM2017-9/1, folder “DataSet,” SAS file “prcpub16_tacsadj.sas7bdat.

Table 3: TACS-Adjusted IOCS-Estimated FY 2016 Quarterly City Carrier Letter Route and Special Purpose Route Delivery (Street Time) Costs

Type of City Carrier Route Street Time Cost1 / FY 2016 Quarters
1
(Oct.-Dec. 2015) / 2
(Jan.-Mar. 2016) / 3
(Apr.-Jun. 2016) / 4
(Jul.- Sept. 2016)
City Carrier Street Time Costs ($ in Thousands)
Total Letter Routes / 2,956,714 / 2,914,012 / 2,937,711 / 2,921,396
Total Special Purpose Routes(SPR) / 233,360 / 155,423 / 145,973 / 149,229
Exclusive Parcel Post SPR / 97,606 / 46,465 / 46,620 / 46,751
Combination/Other SPR / 73,391 / 65,395 / 55,727 / 51,585
1IOCS activity code 6710 in variable F262 using the TACS-Adjusted IOCS cost weight variable TALCOST.
Source: Commission generated IOCS-estimates using Docket No. RM2017-9, Library Reference USPS-RM2017-9/1, folder “DataSet,” SAS file “prcpub16_tacsadj.sas7bdat.”

Docket No. RM2017-8

Library Reference PRC-LR-RM2017-8/1

SAS Programming Code to Produce Estimates in Tables 2 and 3

*Note: Most IOCS Variable names and Values Can be found in Docket No. ACR2016, Library Reference USPS-FY16-37, Excel file "IOCSDataDictionaryFY16.xls,"

the IOCS activity coded in variable f262 values are listed in Docket No. ACR2016, Library Reference USPS-FY16-37, file "MASTER.CODES.FY16.";

libname prop5 'c:'; run;

proc format ;

value $route

'71'='Business Foot-LTR'

'73'='Business Motorized-LTR'

'75'='Residential Foot=LTR'

'77'='Residential Curb-LTR'

'78'='Residential P & L-LTR'

'80'='Mixed-Foot-LTR'

'82'='Mixed-Curb-LTR'

'83'='Mixed-P & L-LTR'

'86'='Parcel Post-SPR'

'87'='Collection -Foot Motorized-SPR'

'89'='Relay Route-SPR'

'98'='Combination/Other-SPR'

'99'='Training Route';run;

data IOCSCarrier;

set prop5.prcpub16_tacsadj;*The Proposal Five, Docket No. RM2017-9 SAS Data were filed in Library Reference USPS-RM2017-9/1, folder "DataSet," August 9, 2017.;

where f9252 in ('5', '6');

if q02b ge '20151001' and q02b le '20151231' then qtr=1;

if q02b ge '20160101' and q02b le '20160331' then qtr=2;

if q02b ge '20160401' and q02b le '20160630' then qtr=3;

if q02b ge '20160701' and q02b le '20160930' then qtr=4;

if f260 ge '71' and f260 lt '86' then routegrp='LTR';

if f260='99' then routegrp='TR';

if f260 ge '86' and f260 le '98' then routegrp='SPR';

routename=put(f260, $route.);

nf9252=input(f9252,1.);

nf9250=input(f9250, 18.); *changes the character variable to numeric;

dollar=nf9250/100; *IOCS cost weighting variable f9250 is in pennies, this converts to dollars;

dollarwt=dollar/1000; *This makes the SAS output $ easier to read--values output from the weighted proc freq procedure can be multiplied by 1000 for actual value in dollars;

talcdollar=talcost/100;

tdollarwt=talcdollar/1000;run;

proc freq ; where f262='6710' ;

tables routename*qtr routegrp*qtr/list norow nocol; weight dollarwt;

title 'Table 2: Estimates Calculated Using IOCS Cost Variable';

title2 'City Carrier Street Time Costs';

title3 '$ in Thousands';run;

proc freq ; where f262='6710' ;

tables routename*qtr routegrp*qtr/list norow nocol; weight tdollarwt;

title 'Table 3: Estimates Calculated Using TACS-Adjusted IOCS Cost Variable';

title2 'City Carrier Street Time Costs';

title3 '$ in Thousands';run;

1