D.5_Appendix_A_B_F.xlsx

XLSX spreadsheet 51 KB Posted

Attached to
Commercial Banking Services Federal contract opportunity
Solicitation number
75FCMC19R0006
Issued by
Department of Health and Human Services Centers for Medicare and Medicaid Services

About this file

Attachment D.5 Appendix A_B_F

View the file

Other files for this federal contract opportunity

Show all 12

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Instructions

Appendix A
Instructions
1. Complete the attached spreadsheets completely, leaving all formulas in tact.
2. Spreadsheets must remain in Excel format when they are submitted. The spreadsheet must provide CMS the ability to open and view in normal view, copy and paste data. Further, formulas/calculations shall be viewable/verifiable and editable
3. Additional information has been added to the bottom of the “Schedule of Services Volume Proposal” spreadsheet. The added lines of data can be found under 3 .ww and 4. a,b,c &,d, . These changes are reflected on the following tabs in the spreadsheet:
Schedule of Services - Base Year
Schedule of Services - Option Year 1
Schedule of Services - Option Year 2
Schedule of Services - Option Year 3
Schedule of Services - Option Year 4

HHSM-500-2019-RFP-9999 MAC Banking Contract

Summary

Exhibit 1
Summary
ImplementationBase YearOption Year 1Option Year 2Option Year 3Option Year 4Total for Base and Option Years:
2/10/2019 -7/09/20197/10/2019 -2/09/20202/10/2020 -2/09/20212/10/2021 -2/09/20222/10/2022 -2/09/20232/10/2023 -2/09/2024

HHSM-500-2019-RFP- MAC Banking Contract

Appendix A - BaseYear

Appendix A
Schedule of Services Volume Proposal***
BASE YEAR
MEASURED ACCOUNT SERVICESVOLUMEUNIT COSTTOTAL LINE ITEM COST
1PAYMENT
a)EFTs22,500,000*=
b)Checks5,000,000*=
2MAJOR COST ITEMS
a)Deposited Items62,000*=
b)ACH Addenda Records20,600,000*=
c)Check Image Capture7,210,000*=
3ALL OTHER CHARGES
a)Account Maintenance2,500*=
b)Reconciliations1,000*=
c)CMS Mandated Reconciliations and Reports (per funding account)175*=
d)CD ROM Disks350*=
e)Controlled Distribution Maintenance (Controlled Disbursement & ARP)600*=
f)Wire Transfers3,750*=
g)Mail Credit Advice/Express Courier Deposit37,500*=
h)Online Payable Services - paid check retention850,000*=
i)Online Stop Payments9,000*=
j)Online Information Reporting - subscription fee (per user, per module)600*=
k)Online Payable Services -Maintenance425*=
l)Data Transmission - ACH (per transmission)4,000*=
m)Data Transmission - Issue File588*=
n)Data Transmission/Pay File (per transmission)1,550*=
o)Deposit Ticket/Credits Posted1,550*=
p)EFT Monthly Maintenance750*=
q)EFT Return Notification Fax10,800*=
r)ACH Debit Block Maintenance350*=
s)ACH returns/NOCs13,296*=
t)ACH reversals600*=
u)ACH return via transmission (per item)175*=
v)Positive Pay Maintenance4,000,000*=
w)Positive Pay Exception (per item)2,000*=
x)Positive Pay Exception Return (per return)1,750*=
y)Same Day Positive Pay1,750,000*=
z)Onsite Electronic Deposit - Deposited Items175,000*=
aa)Onsite Electronic Deposit- Credit1,500*=
bb)Onsite Electronic Deposit - Check Scanner2*=
cc)Onsite Electronic Deposit - Email Notification of Returns200*=
dd)Web Service -Ext paid check Retention 84 months (per item)50,000*=
ee)Image Deposited Checks maintenance (monthly)475*=
ff)Image Deposited Checks - per item350,000*=
gg)Image Deposit - Credit posted200,000*=
hh)Image Deposit - Return Deposited Item (per item)250*=
ii)Image Deposited Checks Maintenance (Monthly)800*=
jj)Image Deposit - Credit posted (per credit)2,650*=
kk)Lockbox- Item Processing137,500*=
ll)Lockbox- Photocopy- (per Item)137,500*=
mm)Lockbox- Checks Deposited137,500*=
nn)Lockbox- Account Changes30*=
oo)Lockbox - Image File Transmission (per item)500,000*=
pp)Lockbox- Data Entry3,550,000*=
qq)Lockbox- Document Sorting/matching137,500*=
rr)Lockbox- Returned deposits/envelopes325,000*=
ss)Lockbox- Credit Ticket10,000*=
tt)Lockbox- Monthly Maintenance250*=
vv)Lockbox - Deposit Item Image CD (per item)250,000*=
ww)Payee Positive Pay1,250,000*=
4Fees For New Accounts Setup / Service Changes /All Testing Support
a)New ACH Setup - Includes account setup, inbound transmission, up to two full "round trip" test cycles.5*=
b)New ARP / Positive Pay Setup - Includes account setup, inbound and outbound transmissions, up to two full "round trip" test cycles.5*=
c)ACH / ARP / Positive Pay /- Additional Test Cycles / Support for Testing Base / Non-Base Changes - Per Round Trip Cycle10*=
d)New LOC Setup / Wire Drawdown System Setup and Testing / Per LOC2*=
TOTAL ANNUAL COST: BASE YEAR
***NOTE: THESE VOLUMES ARE A REPRESENTATION OF ONE FINANCIAL INSTITUTION

HHSM-500-2019-RFP-0000 MAC Banking Contract

&A

OptionYear1

Appendix A
Schedule of Services Volume Proposal***
OPTION YEAR 1
MEASURED ACCOUNT SERVICESVOLUMEUNIT COSTTOTAL LINE ITEM COST
1PAYMENT
a)EFTs23,175,000*=
b)Checks5,150,000*=
2MAJOR COST ITEMS
a)Deposited Items63,860*=
b)ACH Addenda Records21,218,000*=
c)Check Image Capture7,426,300*=
3ALL OTHER CHARGES
a)Account Maintenance2,575*=
b)Reconciliations1,030*=
c)CMS Mandated Reconciliations and Reports (per funding account)180*=
d)CD ROM Disks361*=
e)Controlled Distribution Maintenance (Controlled Disbursement & ARP)618*=
f)Wire Transfers3,863*=
g)Mail Credit Advice/Express Courier Deposit38,625*=
h)Online Payable Services - paid check retention875,500*=
i)Online Stop Payments9,270*=
j)Online Information Reporting - subscription fee (per user, per module)618*=
k)Online Payable Services -Maintenance438*=
l)Data Transmission - ACH (per transmission)4,120*=
m)Data Transmission - Issue File605*=
n)Data Transmission/Pay File (per transmission)1,597*=
o)Deposit Ticket/Credits Posted1,597*=
p)EFT Monthly Maintenance773*=
q)EFT Return Notification Fax11,124
r)ACH Debit Block Maintenance361*=
s)ACH returns/NOCs13,695*=
t)ACH reversals618*=
u)ACH return via transmission (per item)180*=
v)Positive Pay Maintenance4,120,000*=
w)Positive Pay Exception (per item)2,060*=
x)Positive Pay Exception Return (per return)1,803*=
y)Same Day Positive Pay1,802,500*=
z)Onsite Electronic Deposit - Deposited Items180,250*=
aa)Onsite Electronic Deposit- Credit1,545*=
bb)Onsite Electronic Deposit - Check Scanner2*=
cc)Onsite Electronic Deposit - Email Notification of Returns206*=
dd)Web Service -Ext paid check Retention 84 months (per item)51,500*=
ee)Image Deposited Checks maintenance (monthly)489*=
ff)Image Deposited Checks - per item360,500*=
gg)Image Deposit - Credit posted206,000*=
hh)Image Deposit - Return Deposited Item (per item)258*=
ii)Image Deposited Checks Maintenance (Monthly)824*=
jj)Image Deposit - Credit posted (per credit)2,730*=
kk)Lockbox- Item Processing141,625*=
ll)Lockbox- Photocopy- (per Item)141,625*=
mm)Lockbox- Checks Deposited141,625*=
nn)Lockbox- Account Changes31*=
oo)Lockbox - Image File Transmission (per item)515,000*=
pp)Lockbox- Data Entry3,656,500*=
qq)Lockbox- Document Sorting/matching141,625*=
rr)Lockbox- Returned deposits/envelopes334,750*=
ss)Lockbox- Credit Ticket10,300*=
tt)Lockbox- Monthly Maintenance258*=
vv)Lockbox - Deposit Item Image CD (per item)257,500*=
ww)Payee Positive Pay1,287,500*=
4Fees For New Accounts Setup / Service Changes /All Testing Support
a)New ACH Setup - Includes account setup, inbound transmission, up to two full "round trip" test cycles.2*=
b)New ARP / Positive Pay Setup - Includes account setup, inbound and outbound transmissions, up to two full "round trip" test cycles.2*=
c)ACH / ARP / Positive Pay /- Additional Test Cycles / Support for Testing Base / Non-Base Changes - Per Round Trip Cycle10*=
d)New LOC Setup / Wire Drawdown System Setup and Testing / Per LOC1*=
TOTAL ANNUAL COST: OPTION YEAR 1
***NOTE: THESE VOLUMES ARE A REPRESENTATION OF ONE FINANCIAL INSTITUTION

HHSM-500-2014-RFP-0067 MAC Banking Contract

&A

OptionYear2

Appendix A
Schedule of Services Volume Proposal***
OPTION YEAR 2
MEASURED ACCOUNT SERVICESVOLUMEUNIT COSTTOTAL LINE ITEM COST
1PAYMENT
a)EFTs23,870,250*=
b)Checks5,304,500*=
2MAJOR COST ITEMS
a)Deposited Items65,776*=
b)ACH Addenda Records21,854,540*=
c)Check Image Capture7,649,089*=
3ALL OTHER CHARGES
a)Account Maintenance2,652*=
b)Reconciliations1,061*=
c)CMS Mandated Reconciliations and Reports (per funding account)186*=
d)CD ROM Disks371*=
e)Controlled Distribution Maintenance (Controlled Disbursement & ARP)637*=
f)Wire Transfers3,978*=
g)Mail Credit Advice/Express Courier Deposit39,784*=
h)Online Payable Services - paid check retention901,765*=
i)Online Stop Payments9,548*=
j)Online Information Reporting - subscription fee (per user, per module)637*=
k)Online Payable Services -Maintenance451*=
l)Data Transmission - ACH (per transmission)4,244*=
m)Data Transmission - Issue File623*=
n)Data Transmission/Pay File (per transmission)1,644*=
o)Deposit Ticket/Credits Posted1,644*=
p)EFT Monthly Maintenance796*=
q)EFT Return Notification Fax11,458
r)ACH Debit Block Maintenance371*=
s)ACH returns/NOCs14,106*=
t)ACH reversals637*=
u)ACH return via transmission (per item)186*=
v)Positive Pay Maintenance4,243,600*=
w)Positive Pay Exception (per item)2,122*=
x)Positive Pay Exception Return (per return)1,857*=
y)Same Day Positive Pay1,856,575*=
z)Onsite Electronic Deposit - Deposited Items185,658*=
aa)Onsite Electronic Deposit- Credit1,591*=
bb)Onsite Electronic Deposit - Check Scanner2*=
cc)Onsite Electronic Deposit - Email Notification of Returns212*=
dd)Web Service -Ext paid check Retention 84 months (per item)53,045*=
ee)Image Deposited Checks maintenance (monthly)504*=
ff)Image Deposited Checks - per item371,315*=
gg)Image Deposit - Credit posted212,180*=
hh)Image Deposit - Return Deposited Item (per item)265*=
ii)Image Deposited Checks Maintenance (Monthly)849*=
jj)Image Deposit - Credit posted (per credit)2,811*=
kk)Lockbox- Item Processing145,874*=
ll)Lockbox- Photocopy- (per Item)145,874*=
mm)Lockbox- Checks Deposited145,874*=
nn)Lockbox- Account Changes32*=
oo)Lockbox - Image File Transmission (per item)530,450*=
pp)Lockbox- Data Entry3,766,195*=
qq)Lockbox- Document Sorting/matching145,874*=
rr)Lockbox- Returned deposits/envelopes344,793*=
ss)Lockbox- Credit Ticket10,609*=
tt)Lockbox- Monthly Maintenance265*=
vv)Lockbox - Deposit Item Image CD (per item)265,225*=
ww)Payee Positive Pay1,326,125*=
4Fees For New Accounts Setup / Service Changes /All Testing Support
a)New ACH Setup - Includes account setup, inbound transmission, up to two full "round trip" test cycles.3*=
b)New ARP / Positive Pay Setup - Includes account setup, inbound and outbound transmissions, up to two full "round trip" test cycles.3*=
c)ACH / ARP / Positive Pay /- Additional Test Cycles / Support for Testing Base / Non-Base Changes - Per Round Trip Cycle10*=
d)New LOC Setup / Wire Drawdown System Setup and Testing / Per LOC1*=
TOTAL ANNUAL COST: OPTION YEAR 2
***NOTE: THESE VOLUMES ARE A REPRESENTATION OF ONE FINANCIAL INSTITUTION

HHSM-500-2014-RFP-0067 MAC Banking Contract

&A

OptionYear3

Appendix A
Schedule of Services Volume Proposal***
OPTION YEAR 3
MEASURED ACCOUNT SERVICESVOLUMEUNIT COSTTOTAL LINE ITEM COST
1PAYMENT
a)EFTs24,586,358*=
b)Checks5,463,635*=
2MAJOR COST ITEMS
a)Deposited Items67,749*=
b)ACH Addenda Records22,510,176*=
c)Check Image Capture7,878,562*=
3ALL OTHER CHARGES
a)Account Maintenance2,732*=
b)Reconciliations1,093*=
c)CMS Mandated Reconciliations and Reports (per funding account)191*=
d)CD ROM Disks382*=
e)Controlled Distribution Maintenance (Controlled Disbursement & ARP)656*=
f)Wire Transfers4,098*=
g)Mail Credit Advice/Express Courier Deposit40,977*=
h)Online Payable Services - paid check retention928,818*=
i)Online Stop Payments9,835*=
j)Online Information Reporting - subscription fee (per user, per module)656*=
k)Online Payable Services -Maintenance464*=
l)Data Transmission - ACH (per transmission)4,371*=
m)Data Transmission - Issue File642*=
n)Data Transmission/Pay File (per transmission)1,694*=
o)Deposit Ticket/Credits Posted1,694*=
p)EFT Monthly Maintenance820*=
q)EFT Return Notification Fax11,801
r)ACH Debit Block Maintenance382*=
s)ACH returns/NOCs14,529*=
t)ACH reversals656*=
u)ACH return via transmission (per item)191*=
v)Positive Pay Maintenance4,370,908*=
w)Positive Pay Exception (per item)2,185*=
x)Positive Pay Exception Return (per return)1,912*=
y)Same Day Positive Pay1,912,272*=
z)Onsite Electronic Deposit - Deposited Items191,227*=
aa)Onsite Electronic Deposit- Credit1,639*=
bb)Onsite Electronic Deposit - Check Scanner2*=
cc)Onsite Electronic Deposit - Email Notification of Returns219*=
dd)Web Service -Ext paid check Retention 84 months (per item)54,636*=
ee)Image Deposited Checks maintenance (monthly)519*=
ff)Image Deposited Checks - per item382,454*=
gg)Image Deposit - Credit posted218,545*=
hh)Image Deposit - Return Deposited Item (per item)273*=
ii)Image Deposited Checks Maintenance (Monthly)874*=
jj)Image Deposit - Credit posted (per credit)2,896*=
kk)Lockbox- Item Processing150,250*=
ll)Lockbox- Photocopy- (per Item)150,250*=
mm)Lockbox- Checks Deposited150,250*=
nn)Lockbox- Account Changes33*=
oo)Lockbox - Image File Transmission (per item)546,364*=
pp)Lockbox- Data Entry3,879,181*=
qq)Lockbox- Document Sorting/matching150,250*=
rr)Lockbox- Returned deposits/envelopes355,136*=
ss)Lockbox- Credit Ticket10,927*=
tt)Lockbox- Monthly Maintenance273*=
vv)Lockbox - Deposit Item Image CD (per item)273,182*=
ww)Payee Positive Pay1,365,908*=
4Fees For New Accounts Setup / Service Changes /All Testing Support
a)New ACH Setup - Includes account setup, inbound transmission, up to two full "round trip" test cycles.3*=
b)New ARP / Positive Pay Setup - Includes account setup, inbound and outbound transmissions, up to two full "round trip" test cycles.3*=
c)ACH / ARP / Positive Pay /- Additional Test Cycles / Support for Testing Base / Non-Base Changes - Per Round Trip Cycle10*=
d)New LOC Setup / Wire Drawdown System Setup and Testing / Per LOC1*=
TOTAL ANNUAL COST: OPTION YEAR 3
***NOTE: THESE VOLUMES ARE A REPRESENTATION OF ONE FINANCIAL INSTITUTION

HHSM-500-2014-RFP-0067 MAC Banking Contract

&A

Option Year4

Appendix A
Schedule of Services Volume Proposal***
OPTION YEAR 4
MEASURED ACCOUNT SERVICESVOLUMEUNIT COSTTOTAL LINE ITEM COST
1PAYMENT
a)EFTs25,323,948*=
b)Checks5,627,544*=
2MAJOR COST ITEMS
a)Deposited Items69,782*=
b)ACH Addenda Records23,185,481*=
c)Check Image Capture8,114,919*=
3ALL OTHER CHARGES
a)Account Maintenance2,814*=
b)Reconciliations1,126*=
c)CMS Mandated Reconciliations and Reports (per funding account)197*=
d)CD ROM Disks394*=
e)Controlled Distribution Maintenance (Controlled Disbursement & ARP)675*=
f)Wire Transfers4,221*=
g)Mail Credit Advice/Express Courier Deposit42,207*=
h)Online Payable Services - paid check retention956,682*=
i)Online Stop Payments10,130*=
j)Online Information Reporting - subscription fee (per user, per module)675*=
k)Online Payable Services -Maintenance478*=
l)Data Transmission - ACH (per transmission)4,502*=
m)Data Transmission - Issue File661*=
n)Data Transmission/Pay File (per transmission)1,745*=
o)Deposit Ticket/Credits Posted1,745*=
p)EFT Monthly Maintenance844*=
q)EFT Return Notification Fax12,155
r)ACH Debit Block Maintenance394*=
s)ACH returns/NOCs14,965*=
t)ACH reversals675*=
u)ACH return via transmission (per item)197*=
v)Positive Pay Maintenance4,502,035*=
w)Positive Pay Exception (per item)2,251*=
x)Positive Pay Exception Return (per return)1,970*=
y)Same Day Positive Pay1,969,640*=
z)Onsite Electronic Deposit - Deposited Items196,964*=
aa)Onsite Electronic Deposit- Credit1,688*=
bb)Onsite Electronic Deposit - Check Scanner2*=
cc)Onsite Electronic Deposit - Email Notification of Returns225*=
dd)Web Service -Ext paid check Retention 84 months (per item)56,275*=
ee)Image Deposited Checks maintenance (monthly)535*=
ff)Image Deposited Checks - per item393,928*=
gg)Image Deposit - Credit posted225,102*=
hh)Image Deposit - Return Deposited Item (per item)281*=
ii)Image Deposited Checks Maintenance (Monthly)900*=
jj)Image Deposit - Credit posted (per credit)2,983*=
kk)Lockbox- Item Processing154,757*=
ll)Lockbox- Photocopy- (per Item)154,757*=
mm)Lockbox- Checks Deposited154,757*=
nn)Lockbox- Account Changes34*=
oo)Lockbox - Image File Transmission (per item)562,754*=
pp)Lockbox- Data Entry3,995,556*=
qq)Lockbox- Document Sorting/matching154,757*=
rr)Lockbox- Returned deposits/envelopes365,790*=
ss)Lockbox- Credit Ticket11,255*=
tt)Lockbox- Monthly Maintenance281*=
vv)Lockbox - Deposit Item Image CD (per item)281,377*=
ww)Payee Positive Pay1,406,885*=
4Fees For New Accounts Setup / Service Changes /All Testing Support
a)New ACH Setup - Includes account setup, inbound transmission, up to two full "round trip" test cycles.3*=
b)New ARP / Positive Pay Setup - Includes account setup, inbound and outbound transmissions, up to two full "round trip" test cycles.3*=
c)ACH / ARP / Positive Pay /- Additional Test Cycles / Support for Testing Base / Non-Base Changes - Per Round Trip Cycle10*=
d)New LOC Setup / Wire Drawdown System Setup and Testing / Per LOC1*=
TOTAL ANNUAL COST: OPTION YEAR 4
***NOTE: THESE VOLUMES ARE A REPRESENTATION OF ONE FINANCIAL INSTITUTION

HHSM-500-2014-RFP-0067 MAC Banking Contract

&A

Appendix B

Appendix B
Volume Report of Schedule Itemized Bank Services
MONTH YEAR
MEASURED ACCOUNT SERVICESVOLUME
1PAYMENT
a)EFTs
b)Checks
2MAJOR COST ITEMS
a)Deposited Items
b)ACH Addenda Records
c)Check Image Capture
3ALL OTHER CHARGES
a)Account Maintenance
b)Reconciliations
c)CMS Mandated Reconciliations and Reports (per funding account)
d)CD ROM Disks
e)Controlled Distribution Maintenance (Controlled Disbursement & ARP)
f)Wire Transfers
g)Mail Credit Advice/Express Courier Deposit
h)Online Payable Services - paid check retention
i)Online Stop Payments
j)Online Information Reporting - subscription fee (per user, per module)
k)Online Payable Services -Maintenance
l)Data Transmission - ACH (per transmission)
m)Data Transmission - Issue File
n)Data Transmission/Pay File (per transmission)
o)Deposit Ticket/Credits Posted
p)EFT Monthly Maintenance
q)EFT Return Notification Fax
r)ACH Debit Block Maintenance
s)ACH returns/NOCs
t)ACH reversals
u)ACH return via transmission (per item)
v)Positive Pay Maintenance
w)Positive Pay Exception (per item)
x)Positive Pay Exception Return (per return)
y)Same Day Positive Pay
z)Onsite Electronic Deposit - Deposited Items
aa)Onsite Electronic Deposit- Credit
bb)Onsite Electronic Deposit - Check Scanner
cc)Onsite Electronic Deposit - Email Notification of Returns
dd)Web Service -Ext paid check Retention 84 months (per item)
ee)Image Deposited Checks maintenance (monthly)
ff)Image Deposited Checks - per item
gg)Image Deposit - Credit posted
hh)Image Deposit - Return Deposited Item (per item)
ii)Image Deposited Checks Maintenance (Monthly)
jj)Image Deposit - Credit posted (per credit)
kk)Lockbox- Item Processing
ll)Lockbox- Photocopy- (per Item)
mm)Lockbox- Checks Deposited
nn)Lockbox- Account Changes
oo)Lockbox - Image File Transmission (per item)
pp)Lockbox- Data Entry
qq)Lockbox- Document Sorting/matching
rr)Lockbox- Returned deposits/envelopes
ss)Lockbox- Credit Ticket
tt)Lockbox- Monthly Maintenance
vv)Lockbox - Deposit Item Image CD (per item)

AppendixF

Appendix F
Ramp-up / Transition Proposal

Total line item Cost

1Administration / Coordination
a)Conference calls with MACs (weekly)
b)Conference calls with Demonstration Project Managers (contractor)
c)Conference calls with incumbent bank and CMS
d)Create transition/Ramp up Plan with Weekly updating of transition plan
2New Account Setup
a)Establish four accounts for each MAC
b)Establish four image transmission accounts
3Letters of Credit (LOC)
a)Set-up for LOC process for each MAC
4Establish Communications Networks
a)Installation of lines for MACs
b)Installation of Network for Demonstration Projects file transfer
5Positive Pay
a)Installation of terminals (three for each MAC)
b)User Training for terminals
6Transmission and Testing of Files
a)Roundtrip testing for transmission MAC files (four files per MAC)
b)Roundtrip testing for transmission Demonstration project files

Total Ramp-up / Transition Cost

HHSM-500-2014-RFP-0067 MAC Banking Contract

&A

File details come from the government source that posted it.