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 GroupIncurred MonthJan 2022Feb 2022Mar 2022Apr 2022May 2022Jun 2022Jul 2022Aug 2022Sep 2022Oct 2022Nov 2022Dec 2022Jan 2023Feb 2023Mar 2023Apr 2023May 2023Jun 2023Jul 2023Aug 2023Sep 2023Oct 2023Nov 2023Dec 2023Jan 2024Feb 2024Mar 2024Apr 2024May 2024Jun 2024Jul 2024Aug 2024Sep 2024Oct 2024Nov 2024Dec 2024Total
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 .