Attachment 6 - STD_LTD_Prem_History.xlsx
XLSX spreadsheet 19 KB Posted
- Attached to
- Disabilitly STD/LTD Program Federal contract opportunity
- Solicitation number
- 2031JW20Q00067
About this file
This document contains an attachment with historical payment data for an employee STD and LTD program as well as details of a related federal contract opportunity. The attachment provides 26 pay periods of short term disability payment amounts from 2015 through 2019 totaling $907,923.51. It also includes monthly long term disability payment amounts and totals from July 2015 through September 2019 totaling $3,138,453.83.
The related federal contract opportunity is a solicitation from the Department of the Treasury Office of the Comptroller of the Currency seeking an experienced contractor to underwrite and administer its STD and LTD insurance programs. The contractor is required to administer the programs using an integrated disability management approach to ease employee transitions between STD and LTD. This integrated approach should enhance the employee experience through aiding return to work efforts, vocational rehabilitation, streamlining the claim filing process, and providing early notice of Social Security eligibility. Federal employees are ineligible for state disability benefits, and both STD and LTD plans are fully insured.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| 2031JW20Q00067 Disability RFQ.pdf | ||
| OCC DISABILITY QUESTIONS AND ANSWERS RESPONSES.pdf | ||
| Attachment9_Claims Data_2015.07.01 through 2020.05.31.xlsx | XLSX spreadsheet | |
| Attachment 8 - Census.xlsx | XLSX spreadsheet | |
| Attachment 4 - LTD_Certificate.pdf | ||
| Attachment 5 - STD_Certificate.pdf | ||
| 2031JW20Q00067 RFQ.pdf | ||
| Attachment 3 - Claim_Detail.xlsx | XLSX spreadsheet | |
| Attachment 2 - TechnicalQuestionnaire.docx | DOCX document | |
| Attachment 1 - Non-Disclosure Agreement.doc | DOC document | |
| Attachment 7 - VPAT.docx | DOCX document |
Show all 11
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
STD
| PAY PERIOD | CHECK DATE | CHECK AMOUNT |
| 25 | 1/6/15 | $13,533.43 |
| 26 | 1/21/15 | $13,564.51 |
| 1 | 2/3/15 | $13,943.88 |
| 2 | 2/18/15 | $14,030.79 |
| 3 | 3/3/15 | $14,026.00 |
| 4 | 3/17/15 | $14,052.96 |
| 5 | 3/31/15 | $14,069.61 |
| 6 | 4/14/15 | $14,092.01 |
| 7 | 4/28/15 | $14,070.66 |
| 8 | 5/12/15 | $14,063.18 |
| 9 | 5/27/15 | $14,122.81 |
| 10 | 6/9/15 | $14,116.97 |
| 11 | 6/23/15 | $14,096.73 |
| 12 | 7/7/15 | $12,970.49 |
| 13 | 7/21/15 | $5,880.46 |
| 14 | 8/4/15 | $6,910.91 |
| 15 | 8/18/15 | $5,813.46 |
| 16 | 9/1/15 | $5,875.26 |
| 17 | 9/15/15 | $5,900.09 |
| 18 | 9/29/15 | $5,882.99 |
| 19 | 10/14/15 | $5,912.50 |
| 20 | 10/27/15 | $5,914.61 |
| 21 | 11/10/15 | $5,916.92 |
| 22 | 11/24/15 | $5,972.64 |
| 23 | 12/8/15 | $5,945.73 |
| 24 | 12/23/15 | $5,908.94 |
| 25 | 1/5/16 | $5,887.85 |
| 26 | 1/20/16 | $5,904.48 |
| 1 | 2/4/16 | $5,881.44 |
| 2 | 2/17/16 | $6,336.61 |
| 3 | 3/1/16 | $6,181.89 |
| 4 | 3/15/16 | $6,214.13 |
| 5 | 3/29/16 | $6,193.88 |
| 6 | 4/12/16 | $6,181.82 |
| 7 | 4/26/16 | $6,209.82 |
| 8 | 5/10/16 | $6,201.97 |
| 9 | 5/24/16 | $6,216.35 |
| 10 | 6/7/16 | $6,190.59 |
| 11 | 6/21/16 | $6,249.65 |
| 12 | 7/6/16 | $6,220.67 |
| 13 | 7/19/16 | $6,455.65 |
| 14 | 8/2/16 | $6,414.22 |
| 15 | 8/16/16 | $6,439.51 |
| 16 | 8/30/16 | $6,440.60 |
| 17 | 9/13/16 | $6,468.90 |
| 18 | 9/27/16 | $6,461.13 |
| 19 | 10/12/16 | $6,508.43 |
| 20 | 10/25/16 | $6,510.90 |
| 21 | 11/8/16 | $6,497.04 |
| 22 | 11/22/16 | $6,584.08 |
| 23 | 12/6/16 | $6,507.07 |
| 24 | 12/20/16 | $6,545.56 |
| 25 | 1/4/17 | $6,518.44 |
| 26 | 1/18/17 | $6,547.88 |
| 1 | 1/31/17 | $6,753.11 |
| 2 | 2/14/17 | $6,761.09 |
| 3 | 2/28/17 | $6,747.14 |
| 4 | 3/14/17 | $6,767.43 |
| 5 | 3/28/17 | $6,748.10 |
| 6 | 4/11/17 | $6,745.37 |
| 7 | 4/25/17 | $6,713.88 |
| 8 | 5/9/17 | $6,711.09 |
| 9 | 5/23/17 | $6,701.87 |
| 10 | 6/6/17 | $6,688.18 |
| 11 | 6/20/17 | $6,705.15 |
| 12 | 7/5/17 | $6,670.43 |
| 13 | 7/18/17 | $6,681.06 |
| 14 | 8/1/17 | $6,673.11 |
| 15 | 8/15/17 | $6,673.87 |
| 16 | 8/29/17 | $6,665.25 |
| 17 | 9/12/17 | $6,639.71 |
| 18 | 9/26/17 | $6,635.61 |
| 19 | 10/11/17 | $6,615.25 |
| 20 | 10/24/17 | $6,589.90 |
| 21 | 11/7/17 | $6,430.73 |
| 22 | 11/21/17 | $6,604.04 |
| 23 | 12/5/17 | $6,598.01 |
| 24 | 12/19/17 | $6,663.63 |
| 25 | 1/3/18 | $6,628.11 |
| 26 | 1/17/18 | $6,642.89 |
| 1 | 1/30/18 | $6,867.91 |
| 2 | 2/13/18 | $6,872.66 |
| 3 | 2/27/18 | $6,892.25 |
| 4 | 3/13/18 | $6,895.90 |
| 5 | 3/27/18 | $6,858.27 |
| 6 | 4/10/18 | $6,825.65 |
| 7 | 4/24/18 | $6,847.53 |
| 8 | 5/8/18 | $6,824.86 |
| 9 | 5/22/18 | $6,818.89 |
| 10 | 6/5/18 | $6,800.89 |
| 11 | 6/19/18 | $6,788.41 |
| 12 | 7/3/18 | $6,771.38 |
| 13 | 7/17/18 | $6,924.03 |
| 14 | 7/31/17 | $6,783.73 |
| 15 | 8/14/18 | $6,802.15 |
| 16 | 8/28/18 | $6,779.32 |
| 17 | 9/11/18 | $6,824.70 |
| 18 | 9/25/18 | $6,809.00 |
| 19 | 10/10/18 | $6,709.17 |
| 20 | 10/23/18 | $6,765.57 |
| 21 | 11/6/18 | $6,674.70 |
| 22 | 11/20/18 | $6,670.51 |
| 23 | 12/4/18 | $6,645.28 |
| 24 | 12/18/18 | $6,685.17 |
| 25 | 1/2/19 | $6,627.49 |
| 26 | 1/15/19 | $6,605.47 |
| 1 | 1/31/19 | $6,930.86 |
| 2 | 2/12/19 | $6,843.97 |
| 3 | 2/26/19 | $6,767.91 |
| 4 | 3/12/19 | $6,771.82 |
| 5 | 3/26/19 | $6,741.16 |
| 6 | 4/9/19 | $6,727.78 |
| 7 | 4/23/19 | $6,750.41 |
| 8 | 5/7/19 | $6,721.01 |
| 9 | 5/21/19 | $6,719.21 |
| 10 | 6/4/19 | $6,686.96 |
| 11 | 6/18/19 | $6,725.38 |
| 12 | 7/2/19 | $6,665.92 |
| 13 | 7/16/19 | $6,746.51 |
| 14 | 7/30/19 | $6,715.45 |
| 15 | 8/13/19 | $6,712.53 |
| 16 | 8/27/19 | $6,665.59 |
| 17 | 9/10/19 | $6,647.04 |
| $907,923.51 |
LTD
| OCC | OFR | Total | ||
| Jul-15 | $50,587.93 | Jul-15 | $3,032.34 | $53,620.27 |
| Aug-15 | $51,230.95 | Aug-15 | $3,018.60 | $54,249.54 |
| Sep-15 | $51,212.99 | Sep-15 | $2,868.12 | $54,081.10 |
| Oct-15 | $51,297.39 | Oct-15 | $2,868.12 | $54,165.51 |
| Nov-15 | $51,227.63 | Nov-15 | $2,886.56 | $54,114.18 |
| Dec-15 | $51,374.09 | Dec-15 | $2,899.57 | $54,273.66 |
| $324,504.26 |
| Jan-16 | $76,769.56 | Jan-16 | $4,398.78 | $81,168.34 |
| Feb-16 | $52,564.89 | Feb-16 | $3,039.33 | $55,604.22 |
| Mar-16 | $52,374.39 | Mar-16 | $3,079.44 | $55,453.83 |
| Apr-16 | $52,386.22 | Apr-16 | $3,101.86 | $55,488.08 |
| May-16 | $78,583.17 | May-16 | $4,728.36 | $83,311.53 |
| Jun-16 | $52,681.84 | Jun-16 | $3,191.64 | $55,873.48 |
| Jul-16 | $53,829.61 | Jul-16 | $3,240.88 | $57,070.49 |
| Aug-16 | $53,746.08 | Aug-16 | $3,228.90 | $56,974.98 |
| Sep-16 | $54,142.15 | Sep-16 | $3,259.08 | $57,401.23 |
| Oct-16 | $54,336.03 | Oct-16 | $3,320.12 | $57,656.15 |
| Nov-16 | $54,503.51 | Nov-16 | $3,366.50 | $57,870.02 |
| Dec-16 | $54,436.87 | Dec-16 | $3,368.71 | $57,805.58 |
| $731,677.93 |
| Jan-17 | $81,815.63 | Jan-17 | $5,099.27 | $86,914.90 |
| Feb-17 | $55,577.64 | Feb-17 | $3,470.18 | $59,047.82 |
| Mar-17 | $55,457.43 | Mar-17 | $3,469.82 | $58,927.25 |
| Apr-17 | $55,269.29 | Apr-17 | $3,444.96 | $58,714.25 |
| May-17 | $82,719.18 | May-17 | $5,202.51 | $87,921.69 |
| Jun-17 | $55,185.89 | Jun-17 | $3,428.96 | $58,614.85 |
| Jul-17 | $55,195.36 | Jul-17 | $3,391.85 | $58,587.21 |
| Aug-17 | $54,967.60 | Aug-17 | $3,387.81 | $58,355.41 |
| Sep-17 | $54,854.72 | Sep-17 | $3,377.15 | $58,231.88 |
| Oct-17 | $54,709.45 | Oct-17 | $3,332.23 | $58,041.68 |
| Nov-17 | $54,710.41 | Nov-17 | $3,285.61 | $57,996.02 |
| Dec-17 | $54,738.27 | Dec-17 | $3,282.14 | $58,020.41 |
| $759,373.37 | ||||
| FICA Taxes | $1,663.83 | $1,663.83 | ||
| FICA Taxes | $1,221.23 | $1,221.23 | ||
| FICA Taxes | $1,239.61 | $1,239.61 | ||
| FICA Taxes | $819.76 | $819.76 | ||
| $4,944.43 |
| Jan-18 | $82,183.95 | Jan-18 | $4,857.36 | $87,041.30 |
| Feb-18 | $55,548.76 | Feb-18 | $3,241.33 | $58,790.09 |
| Mar-18 | $55,416.58 | Mar-18 | $3,209.92 | $58,626.50 |
| Apr-18 | $55,118.62 | Apr-18 | $3,118.40 | $58,237.02 |
| May-18 | $82,379.78 | May-18 | $4,526.60 | $86,906.38 |
| Jun-18 | $54,848.10 | Jun-18 | $2,858.80 | $57,706.91 |
| Jul-18 | $54,925.14 | Jul-18 | $2,717.04 | $57,642.18 |
| Aug-18 | $54,781.38 | Aug-18 | $2,633.00 | $57,414.38 |
| Sep-18 | $54,815.08 | Sep-18 | $2,549.78 | $57,364.86 |
| Oct-18 | $54,739.18 | Oct-18 | $2,397.42 | $57,136.60 |
| Nov-18 | $54,569.76 | Nov-18 | $1,939.95 | $56,509.71 |
| Dec-18 | $54,538.87 | Dec-18 | $1,924.91 | $56,463.78 |
| $749,839.70 | ||||
| FICA Taxes | $885.41 | $885.41 | ||
| FICA Taxes | $1,213.77 | $1,213.77 | ||
| FICA Taxes | $2,927.91 | $2,927.91 | ||
| FICA Taxes | $2,249.46 | $2,249.46 | ||
| $7,276.55 |
| Jan-19 | $81,714.07 | Jan-19 | $2,786.51 | $84,500.58 |
| Feb-19 | $54,660.13 | Feb-19 | $1,864.34 | $56,524.46 |
| Mar-19 | $54,451.84 | Mar-19 | $1,864.34 | $56,316.18 |
| Apr-19 | $54,030.50 | Apr-19 | $1,844.03 | $55,874.53 |
| May-19 | $80,760.19 | May-19 | $2,715.80 | $83,476.00 |
| Jun-19 | $53,729.38 | Jun-19 | $1,791.79 | $55,521.17 |
| Jul-19 | $53,610.14 | Jul-19 | $1,817.06 | $55,427.21 |
| Aug-19 | $53,339.80 | Aug-19 | $1,793.21 | $55,133.01 |
| Sep-19 | $53,257.23 | Sep-19 | $1,717.87 | $54,975.10 |
| Oct-19 | Oct-19 | $0.00 | ||
| Nov-19 | Nov-19 | $0.00 | ||
| Dec-19 | Dec-19 | $0.00 | ||
| $557,748.25 | ||||
| FICA Taxes | $1,384.02 | $1,384.02 | ||
| FICA Taxes | $1,705.32 | $1,705.32 |
$3,089.34
Grand Total $3,138,453.83
File details come from the government source that posted it. Updated .