Civic Intelligence

Randy R. Ciepluch, Dds

Plan context: Randy R. Ciepluch, Dds 401(K) Plan

EIN 39-1437880 • Milwaukee, WI • 37 filings • 5 plans

3500 West Lisbon AvenueMilwaukee, WI 53208
Current Snapshot

Latest Year

2022

2022 Participants

6

2022 Assets

$7,035,729

2022 Contributions

$98,405

Historical Graphs

Total Assets Over Time

Aggregate end-of-year assets by filing year, excluding zero-asset years

$7,035,729$3,517,865$0200020122021YearValue
$7,035,729Latest year 2021

Participants Over Time

Largest reported end-of-year plan headcount by filing year, used to avoid double-counting participants across overlapping plans

630200020112021YearValue
6Latest year 2021

Company Timeline

Year summaries and individual filings are combined here so you can stay in one place while moving across years and plan filings.

Year / FilingFilingsParticipantsAssetsContributionsContrib./Participant
202210$0$0-
Randy R. Ciepluch, Dds 401(K) Plan-0$0--
202126$7,035,729$98,405$16,401iApproximate average salary by contribution assumption: employee only about $410,021 at 4% or $273,347 at 6%; with 50% employer match about $273,347 at 4% or $182,231 at 6%; with 100% employer match about $205,010 at 4% or $136,674 at 6%.
Randy R. Ciepluch, Dds 401(K) Plan-6$3,613,365$72,838$12,140iApproximate average salary by contribution assumption: employee only about $303,492 at 4% or $202,328 at 6%; with 50% employer match about $202,328 at 4% or $134,885 at 6%; with 100% employer match about $151,746 at 4% or $101,164 at 6%.
RANDY R. CIEPLUCH, DDS CASH BALANCE PLAN-1$3,422,364$25,567$25,567iApproximate average salary by contribution assumption: employee only about $639,175 at 4% or $426,117 at 6%; with 50% employer match about $426,117 at 4% or $284,078 at 6%; with 100% employer match about $319,588 at 4% or $213,058 at 6%.
202026$6,023,108$185,171$30,862iApproximate average salary by contribution assumption: employee only about $771,546 at 4% or $514,364 at 6%; with 50% employer match about $514,364 at 4% or $342,909 at 6%; with 100% employer match about $385,773 at 4% or $257,182 at 6%.
Randy R. Ciepluch, Dds 401(K) Plan-6$3,038,516$71,338$11,890iApproximate average salary by contribution assumption: employee only about $297,242 at 4% or $198,161 at 6%; with 50% employer match about $198,161 at 4% or $132,107 at 6%; with 100% employer match about $148,621 at 4% or $99,081 at 6%.
RANDY R. CIEPLUCH, DDS CASH BALANCE PLAN-6$2,984,592$113,833$18,972iApproximate average salary by contribution assumption: employee only about $474,304 at 4% or $316,203 at 6%; with 50% employer match about $316,203 at 4% or $210,802 at 6%; with 100% employer match about $237,152 at 4% or $158,101 at 6%.
201926$5,144,696$140,994$23,499iApproximate average salary by contribution assumption: employee only about $587,475 at 4% or $391,650 at 6%; with 50% employer match about $391,650 at 4% or $261,100 at 6%; with 100% employer match about $293,738 at 4% or $195,825 at 6%.
Randy R. Ciepluch, Dds 401(K) Plan-6$2,653,275$37,994$6,332iApproximate average salary by contribution assumption: employee only about $158,308 at 4% or $105,539 at 6%; with 50% employer match about $105,539 at 4% or $70,359 at 6%; with 100% employer match about $79,154 at 4% or $52,769 at 6%.
RANDY R. CIEPLUCH, DDS CASH BALANCE PLAN-6$2,491,421$103,000$17,167iApproximate average salary by contribution assumption: employee only about $429,167 at 4% or $286,111 at 6%; with 50% employer match about $286,111 at 4% or $190,741 at 6%; with 100% employer match about $214,583 at 4% or $143,056 at 6%.
201826$3,473,842$244,146$40,691iApproximate average salary by contribution assumption: employee only about $1,017,275 at 4% or $678,183 at 6%; with 50% employer match about $678,183 at 4% or $452,122 at 6%; with 100% employer match about $508,638 at 4% or $339,092 at 6%.
Randy R. Ciepluch, Dds 401(K) Plan-6$2,126,321$52,896$8,816iApproximate average salary by contribution assumption: employee only about $220,400 at 4% or $146,933 at 6%; with 50% employer match about $146,933 at 4% or $97,956 at 6%; with 100% employer match about $110,200 at 4% or $73,467 at 6%.
RANDY R. CIEPLUCH, DDS CASH BALANCE PLAN-5$1,347,521$191,250$38,250iApproximate average salary by contribution assumption: employee only about $956,250 at 4% or $637,500 at 6%; with 50% employer match about $637,500 at 4% or $425,000 at 6%; with 100% employer match about $478,125 at 4% or $318,750 at 6%.
201726$4,354,780$145,235$24,206iApproximate average salary by contribution assumption: employee only about $605,146 at 4% or $403,431 at 6%; with 50% employer match about $403,431 at 4% or $268,954 at 6%; with 100% employer match about $302,573 at 4% or $201,715 at 6%.
Randy R. Ciepluch, Dds 401(K) Plan-6$2,242,748$50,235$8,373iApproximate average salary by contribution assumption: employee only about $209,313 at 4% or $139,542 at 6%; with 50% employer match about $139,542 at 4% or $93,028 at 6%; with 100% employer match about $104,656 at 4% or $69,771 at 6%.
RANDY R. CIEPLUCH, DDS CASH BALANCE PLAN-6$2,112,032$95,000$15,833iApproximate average salary by contribution assumption: employee only about $395,833 at 4% or $263,889 at 6%; with 50% employer match about $263,889 at 4% or $175,926 at 6%; with 100% employer match about $197,917 at 4% or $131,944 at 6%.
201626$3,632,495$124,188$20,698iApproximate average salary by contribution assumption: employee only about $517,450 at 4% or $344,967 at 6%; with 50% employer match about $344,967 at 4% or $229,978 at 6%; with 100% employer match about $258,725 at 4% or $172,483 at 6%.
Randy R. Ciepluch, Dds 401(K) Plan-6$1,877,246$29,188$4,865iApproximate average salary by contribution assumption: employee only about $121,617 at 4% or $81,078 at 6%; with 50% employer match about $81,078 at 4% or $54,052 at 6%; with 100% employer match about $60,808 at 4% or $40,539 at 6%.
RANDY R. CIEPLUCH, DDS CASH BALANCE PLAN-6$1,755,249$95,000$15,833iApproximate average salary by contribution assumption: employee only about $395,833 at 4% or $263,889 at 6%; with 50% employer match about $263,889 at 4% or $175,926 at 6%; with 100% employer match about $197,917 at 4% or $131,944 at 6%.
201526$3,292,837$167,923$27,987iApproximate average salary by contribution assumption: employee only about $699,679 at 4% or $466,453 at 6%; with 50% employer match about $466,453 at 4% or $310,969 at 6%; with 100% employer match about $349,840 at 4% or $233,226 at 6%.
Randy R. Ciepluch, Dds 401(K) Plan-6$1,698,494$45,423$7,571iApproximate average salary by contribution assumption: employee only about $189,263 at 4% or $126,175 at 6%; with 50% employer match about $126,175 at 4% or $84,117 at 6%; with 100% employer match about $94,631 at 4% or $63,088 at 6%.
RANDY R. CIEPLUCH, DDS CASH BALANCE PLAN-6$1,594,343$122,500$20,417iApproximate average salary by contribution assumption: employee only about $510,417 at 4% or $340,278 at 6%; with 50% employer match about $340,278 at 4% or $226,852 at 6%; with 100% employer match about $255,208 at 4% or $170,139 at 6%.
201426$3,172,151$185,066$30,844iApproximate average salary by contribution assumption: employee only about $771,108 at 4% or $514,072 at 6%; with 50% employer match about $514,072 at 4% or $342,715 at 6%; with 100% employer match about $385,554 at 4% or $257,036 at 6%.
Randy R. Ciepluch, Dds 401(K) Plan-6$1,650,957$35,066$5,844iApproximate average salary by contribution assumption: employee only about $146,108 at 4% or $97,406 at 6%; with 50% employer match about $97,406 at 4% or $64,937 at 6%; with 100% employer match about $73,054 at 4% or $48,703 at 6%.
RANDY R. CIEPLUCH, DDS CASH BALANCE PLAN-6$1,521,194$150,000$25,000iApproximate average salary by contribution assumption: employee only about $625,000 at 4% or $416,667 at 6%; with 50% employer match about $416,667 at 4% or $277,778 at 6%; with 100% employer match about $312,500 at 4% or $208,333 at 6%.
201325$2,897,899$269,952$53,990iApproximate average salary by contribution assumption: employee only about $1,349,760 at 4% or $899,840 at 6%; with 50% employer match about $899,840 at 4% or $599,893 at 6%; with 100% employer match about $674,880 at 4% or $449,920 at 6%.
Randy R. Ciepluch, Dds 401(K) Plan-5$1,539,015$67,339$13,468iApproximate average salary by contribution assumption: employee only about $336,695 at 4% or $224,463 at 6%; with 50% employer match about $224,463 at 4% or $149,642 at 6%; with 100% employer match about $168,348 at 4% or $112,232 at 6%.
RANDY R. CIEPLUCH, DDS CASH BALANCE PLAN-5$1,358,884$202,613$40,523iApproximate average salary by contribution assumption: employee only about $1,013,065 at 4% or $675,377 at 6%; with 50% employer match about $675,377 at 4% or $450,251 at 6%; with 100% employer match about $506,533 at 4% or $337,688 at 6%.
201225$2,143,426$138,850$27,770iApproximate average salary by contribution assumption: employee only about $694,250 at 4% or $462,833 at 6%; with 50% employer match about $462,833 at 4% or $308,556 at 6%; with 100% employer match about $347,125 at 4% or $231,417 at 6%.
Randy R. Ciepluch, Dds 401(K) Plan-5$1,217,150$0-
RANDY R. CIEPLUCH, DDS CASH BALANCE PLAN-5$926,276$138,850$27,770iApproximate average salary by contribution assumption: employee only about $694,250 at 4% or $462,833 at 6%; with 50% employer match about $462,833 at 4% or $308,556 at 6%; with 100% employer match about $347,125 at 4% or $231,417 at 6%.
201125$1,913,881$283,039$56,608iApproximate average salary by contribution assumption: employee only about $1,415,195 at 4% or $943,463 at 6%; with 50% employer match about $943,463 at 4% or $628,976 at 6%; with 100% employer match about $707,598 at 4% or $471,732 at 6%.
Randy R. Ciepluch, Dds 401(K) Plan-5$1,122,648$45,147$9,029iApproximate average salary by contribution assumption: employee only about $225,735 at 4% or $150,490 at 6%; with 50% employer match about $150,490 at 4% or $100,327 at 6%; with 100% employer match about $112,868 at 4% or $75,245 at 6%.
RANDY R. CIEPLUCH, DDS CASH BALANCE PLAN-5$791,233$237,892$47,578iApproximate average salary by contribution assumption: employee only about $1,189,460 at 4% or $792,973 at 6%; with 50% employer match about $792,973 at 4% or $528,649 at 6%; with 100% employer match about $594,730 at 4% or $396,487 at 6%.
201025$1,734,166$268,215$53,643iApproximate average salary by contribution assumption: employee only about $1,341,075 at 4% or $894,050 at 6%; with 50% employer match about $894,050 at 4% or $596,033 at 6%; with 100% employer match about $670,538 at 4% or $447,025 at 6%.
Randy R. Ciepluch, Dds 401(K) Plan-5$1,105,312$45,178$9,036iApproximate average salary by contribution assumption: employee only about $225,890 at 4% or $150,593 at 6%; with 50% employer match about $150,593 at 4% or $100,396 at 6%; with 100% employer match about $112,945 at 4% or $75,297 at 6%.
RANDY R. CIEPLUCH, DDS CASH BALANCE PLAN-5$628,854$223,037$44,607iApproximate average salary by contribution assumption: employee only about $1,115,185 at 4% or $743,457 at 6%; with 50% employer match about $743,457 at 4% or $495,638 at 6%; with 100% employer match about $557,593 at 4% or $371,728 at 6%.
200926$1,398,954$276,497$46,083iApproximate average salary by contribution assumption: employee only about $1,152,071 at 4% or $768,047 at 6%; with 50% employer match about $768,047 at 4% or $512,031 at 6%; with 100% employer match about $576,035 at 4% or $384,024 at 6%.
Randy R. Ciepluch, Dds 401(K) Plan-6$987,903$44,717$7,453iApproximate average salary by contribution assumption: employee only about $186,321 at 4% or $124,214 at 6%; with 50% employer match about $124,214 at 4% or $82,809 at 6%; with 100% employer match about $93,160 at 4% or $62,107 at 6%.
RANDY R. CIEPLUCH, DDS CASH BALANCE PLAN-5$411,051$231,780$46,356iApproximate average salary by contribution assumption: employee only about $1,158,900 at 4% or $772,600 at 6%; with 50% employer match about $772,600 at 4% or $515,067 at 6%; with 100% employer match about $579,450 at 4% or $386,300 at 6%.
200825$162,869$162,869$32,574iApproximate average salary by contribution assumption: employee only about $814,345 at 4% or $542,897 at 6%; with 50% employer match about $542,897 at 4% or $361,931 at 6%; with 100% employer match about $407,173 at 4% or $271,448 at 6%.
RANDY R. CIEPLUCH, DDS CASH BALANCE PLAN-5$162,869$162,869$32,574iApproximate average salary by contribution assumption: employee only about $814,345 at 4% or $542,897 at 6%; with 50% employer match about $542,897 at 4% or $361,931 at 6%; with 100% employer match about $407,173 at 4% or $271,448 at 6%.
Randy R. Ciepluch, Dds 401(K) Plan-4---
200714$0$0-
Randy R. Ciepluch, Dds 401(K) Plan-4---
200615$1,163,176$54,840$10,968iApproximate average salary by contribution assumption: employee only about $274,200 at 4% or $182,800 at 6%; with 50% employer match about $182,800 at 4% or $121,867 at 6%; with 100% employer match about $137,100 at 4% or $91,400 at 6%.
Randy R. Ciepluch, Dds 401(K) Plan-5$1,163,176$54,840$10,968iApproximate average salary by contribution assumption: employee only about $274,200 at 4% or $182,800 at 6%; with 50% employer match about $182,800 at 4% or $121,867 at 6%; with 100% employer match about $137,100 at 4% or $91,400 at 6%.
200515$967,788$54,790$10,958iApproximate average salary by contribution assumption: employee only about $273,950 at 4% or $182,633 at 6%; with 50% employer match about $182,633 at 4% or $121,756 at 6%; with 100% employer match about $136,975 at 4% or $91,317 at 6%.
Randy R. Ciepluch, Dds 401(K) Plan-5$967,788$54,790$10,958iApproximate average salary by contribution assumption: employee only about $273,950 at 4% or $182,633 at 6%; with 50% employer match about $182,633 at 4% or $121,756 at 6%; with 100% employer match about $136,975 at 4% or $91,317 at 6%.
200415$1,393,607$51,314$10,263iApproximate average salary by contribution assumption: employee only about $256,570 at 4% or $171,047 at 6%; with 50% employer match about $171,047 at 4% or $114,031 at 6%; with 100% employer match about $128,285 at 4% or $85,523 at 6%.
Randy R. Ciepluch, Dds 401(K) Plan-5$1,393,607$51,314$10,263iApproximate average salary by contribution assumption: employee only about $256,570 at 4% or $171,047 at 6%; with 50% employer match about $171,047 at 4% or $114,031 at 6%; with 100% employer match about $128,285 at 4% or $85,523 at 6%.
200315$1,266,159$52,789$10,558iApproximate average salary by contribution assumption: employee only about $263,945 at 4% or $175,963 at 6%; with 50% employer match about $175,963 at 4% or $117,309 at 6%; with 100% employer match about $131,973 at 4% or $87,982 at 6%.
Randy R. Ciepluch, Dds 401(K) Plan-5$1,266,159$52,789$10,558iApproximate average salary by contribution assumption: employee only about $263,945 at 4% or $175,963 at 6%; with 50% employer match about $175,963 at 4% or $117,309 at 6%; with 100% employer match about $131,973 at 4% or $87,982 at 6%.
200215$1,038,128$50,182$10,036iApproximate average salary by contribution assumption: employee only about $250,910 at 4% or $167,273 at 6%; with 50% employer match about $167,273 at 4% or $111,516 at 6%; with 100% employer match about $125,455 at 4% or $83,637 at 6%.
Randy R. Ciepluch, Dds 401(K) Plan-5$1,038,128$50,182$10,036iApproximate average salary by contribution assumption: employee only about $250,910 at 4% or $167,273 at 6%; with 50% employer match about $167,273 at 4% or $111,516 at 6%; with 100% employer match about $125,455 at 4% or $83,637 at 6%.
200115$0$0-
Randy R. Ciepluch, Dds 401(K) Plan-5---
200015$1,101,959$45,107$9,021iApproximate average salary by contribution assumption: employee only about $225,535 at 4% or $150,357 at 6%; with 50% employer match about $150,357 at 4% or $100,238 at 6%; with 100% employer match about $112,768 at 4% or $75,178 at 6%.
Randy R. Ciepluch, Dds 401(K) Plan-5$1,101,959$45,107$9,021iApproximate average salary by contribution assumption: employee only about $225,535 at 4% or $150,357 at 6%; with 50% employer match about $150,357 at 4% or $100,238 at 6%; with 100% employer match about $112,768 at 4% or $75,178 at 6%.
Randy R. Ciepluch, Dds | EIN 39-1437880 | 2022 Form 5500 Company Profile