City of OKC Dental Lag Report 2 2022 2023 2024.xlsx
XLSX spreadsheet 50 KB Posted
- Attached to
- Dental Program
- Solicitation number
- RFP-OCMFA-042
- Issued by
- Oklahoma
About this file
The document is a Dental Lag Report spreadsheet for the City of Oklahoma City, covering dental service payments from January 2022 through December 2024. The comprehensive financial report tracks monthly dental service payments across multiple years, with a total cumulative expenditure of $9,965,422.10 during the documented period. The report appears to be part of a broader dental program managed by the Oklahoma City Municipal Facilities Authority (OCMFA), the Oklahoma City Post-Employment Benefits Trust (OPEBT), and the City of Oklahoma City.
The lag report provides granular monthly payment data, showing fluctuating dental service expenses that range from negative adjustments to significant monthly payments, with some months experiencing payments exceeding $200,000. The data suggests a consistent dental service utilization pattern, with monthly expenditures typically between $150,000 and $250,000. The detailed spreadsheet includes incurred and paid months, allowing for precise tracking of dental service financial performance across the specified timeframe. The comprehensive nature of the report indicates a robust financial management approach for tracking dental program expenses and understanding payment trends over multiple years.
View the file
Other files
Show all 12
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1 Lag Report By Service Category
Run Date: 1/14/2025
| Metrics: | (Paid) | |||||||||||||||||||||||||||||||||||||
| Rows: | (Service Category Group, Incurred Month) | |||||||||||||||||||||||||||||||||||||
| Columns: | (Paid Month) | |||||||||||||||||||||||||||||||||||||
| Paid Month: | (Jan 2022 - Dec 2024) | |||||||||||||||||||||||||||||||||||||
| Service Category Group: | (Dental) | |||||||||||||||||||||||||||||||||||||
| Database: | (CITY OF OKLAHOMA CITY: ALL) | |||||||||||||||||||||||||||||||||||||
| Paid Year: | (2022 - 2024) | |||||||||||||||||||||||||||||||||||||
| Service Category Group | Incurred Month | Jan 2022 | Feb 2022 | Mar 2022 | Apr 2022 | May 2022 | Jun 2022 | Jul 2022 | Aug 2022 | Sep 2022 | Oct 2022 | Nov 2022 | Dec 2022 | Jan 2023 | Feb 2023 | Mar 2023 | Apr 2023 | May 2023 | Jun 2023 | Jul 2023 | Aug 2023 | Sep 2023 | Oct 2023 | Nov 2023 | Dec 2023 | Jan 2024 | Feb 2024 | Mar 2024 | Apr 2024 | May 2024 | Jun 2024 | Jul 2024 | Aug 2024 | Sep 2024 | Oct 2024 | Nov 2024 | Dec 2024 | Total |
| Dental | ||||||||||||||||||||||||||||||||||||||
| Mar 2017 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Apr 2017 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| May 2017 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Jun 2017 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Jul 2017 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Aug 2017 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Sep 2017 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Oct 2017 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Nov 2017 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Dec 2017 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Jan 2018 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Feb 2018 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Mar 2018 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Apr 2018 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| May 2018 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Jun 2018 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Jul 2018 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Aug 2018 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Sep 2018 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Oct 2018 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Nov 2018 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Dec 2018 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Jan 2019 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Feb 2019 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Mar 2019 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Apr 2019 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||
| May 2019 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||
| Jun 2019 | $0.00 | $0.00 | -$184.80 | -$184.80 | ||||||||||||||||||||||||||||||||||
| Jul 2019 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||
| Aug 2019 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||
| Sep 2019 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Oct 2019 | $302.90 | $0.00 | $0.00 | $302.90 | ||||||||||||||||||||||||||||||||||
| Nov 2019 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||
| Dec 2019 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| Jan 2020 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | -$86.66 | -$86.66 | |||||||||||||||||||||||||||||||
| Feb 2020 | $0.00 | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||||
| Mar 2020 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||||
| May 2020 | $112.50 | $112.50 | ||||||||||||||||||||||||||||||||||||
| Jun 2020 | $0.00 | $112.50 | $651.20 | $763.70 | ||||||||||||||||||||||||||||||||||
| Jul 2020 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||
| Aug 2020 | $0.00 | -$198.97 | $0.00 | $0.00 | -$198.97 | |||||||||||||||||||||||||||||||||
| Sep 2020 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||
| Oct 2020 | $0.00 | -$29.52 | $0.00 | $0.00 | -$29.52 | |||||||||||||||||||||||||||||||||
| Nov 2020 | $0.00 | -$248.40 | $0.00 | -$113.68 | $0.00 | $0.00 | -$362.08 | |||||||||||||||||||||||||||||||
| Dec 2020 | $0.00 | $0.00 | $0.00 | $308.63 | $0.00 | $308.63 | ||||||||||||||||||||||||||||||||
| Jan 2021 | $0.00 | $241.78 | $112.50 | $0.00 | $354.28 | |||||||||||||||||||||||||||||||||
| Feb 2021 | $165.32 | $70.41 | $0.00 | $112.50 | $77.80 | $0.00 | $0.00 | $112.83 | $538.86 | |||||||||||||||||||||||||||||
| Mar 2021 | $71.03 | $1,186.35 | $0.00 | $35.00 | $0.00 | $0.00 | $6.29 | $0.00 | $0.00 | $0.00 | $0.00 | $1,298.67 | ||||||||||||||||||||||||||
| Apr 2021 | $0.00 | -$349.71 | $1,153.53 | $192.25 | $54.99 | $0.00 | $0.00 | $1,051.06 | ||||||||||||||||||||||||||||||
| May 2021 | $727.06 | -$249.02 | $459.21 | $775.41 | $0.00 | $78.41 | $0.00 | $1,791.07 | ||||||||||||||||||||||||||||||
| Jun 2021 | $496.53 | $270.45 | $253.78 | $233.76 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $1,254.52 | ||||||||||||||||||||||||||
| Jul 2021 | $750.00 | $1,147.22 | $734.43 | $65.50 | $23.31 | $135.69 | $0.00 | $0.00 | $0.00 | $98.97 | $0.00 | $0.00 | $0.00 | $2,955.12 | ||||||||||||||||||||||||
| Aug 2021 | $1,104.66 | $343.69 | $1,008.68 | $1,017.70 | $367.00 | $280.61 | $262.45 | $69.94 | $0.00 | $0.00 | $0.00 | $184.80 | $0.94 | -$184.80 | $0.00 | $0.00 | $4,455.67 | |||||||||||||||||||||
| Sep 2021 | $2,353.70 | $1,034.71 | $821.72 | $2,274.40 | $1,100.00 | $70.04 | $123.48 | $678.49 | $69.94 | $52.07 | $70.15 | $8,648.70 | ||||||||||||||||||||||||||
| Oct 2021 | $2,778.14 | $2,822.51 | $2,403.79 | $747.15 | $855.00 | -$10.06 | $157.00 | $268.61 | $818.91 | $75.72 | $18.85 | $847.52 | $0.00 | $11,783.14 | ||||||||||||||||||||||||
| Nov 2021 | $5,636.63 | $776.67 | $2,211.10 | $3,085.82 | $1,174.50 | $806.36 | $513.81 | $25.66 | $276.51 | $0.00 | $1,107.25 | $158.10 | $1,004.43 | $0.74 | $0.00 | $0.00 | $16,777.58 | |||||||||||||||||||||
| Dec 2021 | $57,156.06 | -$15,870.87 | $3,683.68 | $25,232.09 | $935.99 | $731.71 | $1,244.25 | $376.62 | $173.47 | $0.00 | $416.73 | $3,053.00 | $0.00 | $1,041.40 | $22.88 | $0.00 | $78,197.01 | |||||||||||||||||||||
| Jan 2022 | $172,277.25 | $74,476.25 | $14,555.09 | $20,468.02 | $2,913.10 | $2,317.40 | $75.41 | $530.20 | $862.04 | $141.30 | -$120.15 | $1,567.78 | $0.00 | $0.00 | $0.00 | $0.99 | $146.07 | $290,210.75 | ||||||||||||||||||||
| Feb 2022 | $140,730.34 | $55,090.53 | $5,262.95 | $3,871.06 | $2,122.50 | $92.77 | $1,269.46 | $613.79 | $73.00 | $778.65 | $0.00 | $233.31 | $384.08 | $339.78 | $14.52 | $0.00 | $0.00 | $210,876.74 | ||||||||||||||||||||
| Mar 2022 | $199,731.18 | $102,429.23 | $7,445.82 | $7,437.65 | $2,703.63 | $2,353.15 | $69.58 | $351.98 | $760.79 | $997.35 | -$1,253.74 | $935.52 | $0.00 | $0.00 | $330.84 | $844.56 | -$595.80 | $4.56 | -$131.15 | $0.00 | $29.37 | $0.00 | $0.00 | $324,444.52 | ||||||||||||||
| Apr 2022 | $182,038.91 | $75,080.12 | $7,167.76 | $1,626.46 | $2,399.06 | $1,890.24 | $260.49 | $201.99 | $392.33 | $0.00 | $105.19 | $503.15 | $925.94 | $0.00 | $283.57 | $28.32 | $0.00 | $78.20 | $0.00 | $272,981.73 | ||||||||||||||||||
| May 2022 | $192,102.36 | $63,502.87 | $9,411.42 | $5,572.89 | $2,354.01 | $1,139.20 | $1,003.67 | $1,487.84 | $755.76 | $235.67 | $3.18 | $245.46 | $1.02 | -$266.25 | $0.00 | $0.00 | $0.00 | $277,549.10 | ||||||||||||||||||||
| Jun 2022 | $174,315.74 | $67,158.38 | $13,454.38 | $3,005.35 | $322.79 | $1,520.71 | $228.44 | $1,213.63 | $181.05 | $99.54 | $731.93 | $714.56 | -$266.25 | $0.00 | $0.00 | $0.00 | $262,680.25 | |||||||||||||||||||||
| Jul 2022 | $137,765.65 | $71,060.42 | $3,795.84 | $3,521.21 | $3,033.06 | $808.00 | $0.00 | $1,151.18 | $1,154.38 | $52.58 | $461.74 | $106.64 | $750.00 | -$266.25 | $0.00 | $82.01 | $0.00 | $0.00 | $223,476.46 | |||||||||||||||||||
| Aug 2022 | $172,358.17 | $59,443.22 | $7,036.80 | $5,026.81 | $6,205.36 | $1,616.55 | $708.83 | $291.68 | $981.22 | $197.75 | $692.26 | $788.37 | $12.19 | -$201.25 | $0.00 | $161.64 | $0.00 | -$35.94 | $0.00 | $105.19 | $0.00 | $255,388.85 | ||||||||||||||||
| Sep 2022 | $158,306.49 | $74,004.05 | $5,207.68 | $2,624.69 | $820.67 | -$329.06 | $1,434.53 | $1,063.33 | -$31.76 | $0.00 | $0.00 | $381.86 | $0.00 | $0.00 | $114.75 | $0.00 | $0.00 | $0.00 | $0.00 | $243,597.23 | ||||||||||||||||||
| Oct 2022 | $157,754.71 | $77,876.03 | $8,418.12 | $2,848.73 | $2,348.60 | $1,017.16 | $226.04 | $1,199.80 | $0.00 | $618.64 | $12.77 | $201.96 | $157.00 | $565.04 | $0.00 | $159.65 | $0.00 | $253,404.25 | ||||||||||||||||||||
| Nov 2022 | $171,944.58 | $54,739.81 | $10,335.83 | $3,942.11 | $1,209.23 | $808.41 | $261.87 | $0.00 | $0.00 | $131.54 | $1,405.48 | $238.44 | $132.50 | $403.47 | $0.00 | $0.00 | $245,553.27 | |||||||||||||||||||||
| Dec 2022 | $163,133.76 | $64,896.94 | $7,813.12 | $3,439.88 | $2,899.51 | $1,425.09 | $546.45 | $168.06 | $39.58 | $709.21 | $426.81 | $529.89 | $0.00 | $31.00 | $0.00 | $0.00 | -$65.57 | $0.00 | $245,993.73 | |||||||||||||||||||
| Jan 2023 | $206,227.35 | $77,011.86 | $16,044.55 | $10,695.42 | $4,864.75 | $1,482.95 | $633.93 | $260.98 | $427.46 | $104.20 | $795.77 | $1,435.77 | -$682.57 | $0.00 | $188.26 | $0.00 | $941.60 | $320,432.28 | ||||||||||||||||||||
| Feb 2023 | $173,815.69 | $91,500.57 | $7,711.92 | $3,199.78 | $2,205.97 | $2,850.59 | $769.30 | $424.74 | $299.01 | $750.00 | $56.46 | $1,347.29 | $0.00 | $66.56 | $0.00 | $182.00 | $285,179.88 | |||||||||||||||||||||
| Mar 2023 | $206,342.48 | $92,570.32 | $14,675.47 | $5,966.86 | $3,933.23 | $321.77 | $1,371.95 | $2,741.14 | $309.01 | -$142.00 | -$60.27 | $1,386.12 | $1,074.16 | $0.00 | $0.00 | -$39.62 | $330,450.62 | |||||||||||||||||||||
| Apr 2023 | $158,151.53 | $86,001.30 | $7,664.55 | $3,519.83 | $730.26 | $1,220.20 | $1,680.32 | $666.25 | $890.33 | $142.00 | $60.98 | $390.26 | $221.04 | $747.50 | $0.00 | $262,086.35 | ||||||||||||||||||||||
| May 2023 | $185,619.16 | $85,731.40 | $7,666.61 | $4,064.49 | $952.68 | $1,098.37 | $917.07 | $1,369.53 | $1,069.71 | $1,427.54 | $783.98 | $616.20 | $0.00 | -$795.90 | $0.00 | $290,520.84 | ||||||||||||||||||||||
| Jun 2023 | $198,213.96 | $67,590.23 | $5,584.86 | $458.31 | $513.98 | $482.66 | $2,239.90 | $246.48 | $1,991.42 | $988.25 | $687.58 | $200.34 | $279,197.97 | |||||||||||||||||||||||||
| Jul 2023 | $165,274.53 | $66,860.41 | $7,920.80 | $2,506.74 | $1,360.00 | $1,223.06 | $1,499.80 | $1,677.99 | $283.54 | $748.71 | $72.64 | $224.17 | $111.97 | $0.00 | $249,764.36 | |||||||||||||||||||||||
| Aug 2023 | $216,099.19 | $75,169.64 | $6,583.25 | $2,806.09 | $429.69 | $2,571.80 | $621.32 | $3.73 | $844.03 | -$120.41 | $177.26 | -$315.54 | $74.30 | $1,131.04 | $0.00 | $306,075.39 | ||||||||||||||||||||||
| Sep 2023 | $155,698.96 | $67,667.58 | $6,757.09 | $1,737.80 | $1,004.19 | $639.26 | $1,232.66 | $1,080.04 | -$120.41 | $181.57 | $890.33 | $185.57 | $169.12 | $0.00 | $481.50 | $237,605.26 | ||||||||||||||||||||||
| Oct 2023 | $173,826.68 | $68,058.15 | $6,472.16 | $4,874.94 | $4,556.91 | $501.38 | $210.38 | $2,092.25 | $56.25 | $85.50 | -$215.88 | $0.00 | $0.00 | $260,518.72 | ||||||||||||||||||||||||
| Nov 2023 | $168,146.60 | $65,447.03 | $7,997.02 | $2,931.89 | $2,486.61 | $702.01 | -$377.01 | $1,542.02 | $373.10 | $183.80 | $478.41 | $102.13 | $132.05 | -$316.00 | $249,829.66 | |||||||||||||||||||||||
| Dec 2023 | $167,255.15 | $57,472.96 | $5,371.86 | $3,335.63 | $2,450.92 | $1,466.44 | $109.79 | $1,115.50 | $74.30 | $267.02 | $136.45 | $319.90 | -$912.15 | $238,463.77 | ||||||||||||||||||||||||
| Jan 2024 | $210,947.51 | $118,562.28 | $9,780.37 | $5,816.27 | $2,540.52 | $408.87 | $1,174.20 | $210.12 | $223.39 | $638.27 | $88.07 | -$1,271.01 | $349,118.86 | |||||||||||||||||||||||||
| Feb 2024 | $182,078.67 | $111,343.37 | $17,964.94 | $9,789.83 | $7,004.20 | $2,191.93 | $2,661.36 | $2,075.76 | $0.14 | $81.56 | -$1,254.20 | $333,937.56 | ||||||||||||||||||||||||||
| Mar 2024 | $187,179.49 | $76,671.49 | $15,500.33 | $6,695.76 | $2,334.59 | $1,407.46 | $2,077.03 | $735.69 | $202.22 | -$180.74 | $292,623.32 | |||||||||||||||||||||||||||
| Apr 2024 | $215,032.00 | $83,426.60 | $8,617.52 | $3,184.81 | $947.99 | $2,753.20 | $453.73 | $828.31 | -$146.28 | $315,097.88 | ||||||||||||||||||||||||||||
| May 2024 | $228,718.46 | $57,370.19 | $9,623.33 | $7,155.93 | $5,924.24 | $2,663.64 | $1,308.16 | $60.57 | $312,824.52 | |||||||||||||||||||||||||||||
| Jun 2024 | $194,560.64 | $53,323.68 | $3,612.58 | $5,500.56 | $6,586.06 | $2,298.06 | $660.52 | $266,542.10 | ||||||||||||||||||||||||||||||
| Jul 2024 | $198,411.26 | $80,435.21 | $5,954.85 | $5,512.41 | $2,896.24 | $2,839.77 | $296,049.74 | |||||||||||||||||||||||||||||||
| Aug 2024 | $211,548.54 | $54,149.33 | $6,133.61 | $3,532.68 | $2,350.40 | $277,714.56 | ||||||||||||||||||||||||||||||||
| Sep 2024 | $176,080.10 | $59,368.66 | $5,974.98 | $3,303.66 | $244,727.40 | |||||||||||||||||||||||||||||||||
| Oct 2024 | $212,804.38 | $73,197.62 | $7,427.02 | $293,429.02 | ||||||||||||||||||||||||||||||||||
| Nov 2024 | $180,547.04 | $52,790.63 | $233,337.67 | |||||||||||||||||||||||||||||||||||
| Dec 2024 | $204,006.11 | $204,006.11 | ||||||||||||||||||||||||||||||||||||
| Total: Dental | $243,516.38 | $206,111.08 | $282,149.53 | $344,159.51 | $286,574.45 | $258,913.27 | $221,212.51 | $270,798.36 | $231,679.39 | $244,538.82 | $268,052.15 | $244,534.10 | $287,537.44 | $268,096.71 | $324,044.76 | $278,144.44 | $298,128.13 | $306,374.81 | $252,554.86 | $296,145.24 | $244,954.07 | $257,686.52 | $252,215.55 | $249,088.18 | $289,025.27 | $321,214.64 | $319,638.25 | $323,045.61 | $343,349.23 | $277,073.99 | $272,497.16 | $308,397.86 | $256,646.37 | $295,135.17 | $271,406.89 | $270,781.40 | $9,965,422.10 | |
| Total: Selected Filter(s) | $243,516.38 | $206,111.08 | $282,149.53 | $344,159.51 | $286,574.45 | $258,913.27 | $221,212.51 | $270,798.36 | $231,679.39 | $244,538.82 | $268,052.15 | $244,534.10 | $287,537.44 | $268,096.71 | $324,044.76 | $278,144.44 | $298,128.13 | $306,374.81 | $252,554.86 | $296,145.24 | $244,954.07 | $257,686.52 | $252,215.55 | $249,088.18 | $289,025.27 | $321,214.64 | $319,638.25 | $323,045.61 | $343,349.23 | $277,073.99 | $272,497.16 | $308,397.86 | $256,646.37 | $295,135.17 | $271,406.89 | $270,781.40 | $9,965,422.10 |
&G &G
Page &P of &N image1.jpeg
File details come from the government source that posted it. Updated .