Civic Intelligence
Filing

The Microdata Systems Inc. Retirement Plan

Microdata Systems Inc. • EIN 25-1452773 • Plan year 2007

Company ProfileSource Archive
Filing Insights

Participants

Down

8 → 6

-2 • -25.00%

Assets

No comparison

- → -

No earlier value available.

Investment Management Fee

-

Admin expenses - • Total expenses -

Filing Details

Context
Pension payor EIN
71-0294708

Status Flags

Fidelity bond in place

Not reported

Limited-scope audit performed

Not reported

Contributions transmitted on time

Not reported

Participant loans in default

Not reported

Leases in default

Not reported

Reportable party-in-interest issues

Not reported

Loss discovered during year

Not reported

Assets with undetermined value

Not reported

Non-cash contributions

Not reported

Assets held for investment

Not reported

5% transactions reported

Not reported

All plan assets distributed

Not reported

Benefits paid when due

Not reported

Plan blackout period

Not reported

Plan termination resolution adopted

Not reported

Counterparties

Company Timeline

This filing is highlighted inside the broader sponsor history.

Year / FilingFilingsParticipantsAssetsContributionsContrib./Participant
202413$1,180,184$30,291$10,097iApproximate average salary by contribution assumption: employee only about $252,425 at 4% or $168,283 at 6%; with 50% employer match about $168,283 at 4% or $112,189 at 6%; with 100% employer match about $126,213 at 4% or $84,142 at 6%.
The Microdata Systems Inc. Retirement Plan-3$1,180,184$30,291$10,097iApproximate average salary by contribution assumption: employee only about $252,425 at 4% or $168,283 at 6%; with 50% employer match about $168,283 at 4% or $112,189 at 6%; with 100% employer match about $126,213 at 4% or $84,142 at 6%.
202314$1,098,356$31,934$7,984iApproximate average salary by contribution assumption: employee only about $199,588 at 4% or $133,058 at 6%; with 50% employer match about $133,058 at 4% or $88,706 at 6%; with 100% employer match about $99,794 at 4% or $66,529 at 6%.
The Microdata Systems Inc. Retirement Plan-4$1,098,356$31,934$7,984iApproximate average salary by contribution assumption: employee only about $199,588 at 4% or $133,058 at 6%; with 50% employer match about $133,058 at 4% or $88,706 at 6%; with 100% employer match about $99,794 at 4% or $66,529 at 6%.
202214$927,472$38,566$9,642iApproximate average salary by contribution assumption: employee only about $241,038 at 4% or $160,692 at 6%; with 50% employer match about $160,692 at 4% or $107,128 at 6%; with 100% employer match about $120,519 at 4% or $80,346 at 6%.
The Microdata Systems Inc. Retirement Plan-4$927,472$38,566$9,642iApproximate average salary by contribution assumption: employee only about $241,038 at 4% or $160,692 at 6%; with 50% employer match about $160,692 at 4% or $107,128 at 6%; with 100% employer match about $120,519 at 4% or $80,346 at 6%.
202115$1,093,028$24,438$4,888iApproximate average salary by contribution assumption: employee only about $122,190 at 4% or $81,460 at 6%; with 50% employer match about $81,460 at 4% or $54,307 at 6%; with 100% employer match about $61,095 at 4% or $40,730 at 6%.
The Microdata Systems Inc. Retirement Plan-5$1,093,028$24,438$4,888iApproximate average salary by contribution assumption: employee only about $122,190 at 4% or $81,460 at 6%; with 50% employer match about $81,460 at 4% or $54,307 at 6%; with 100% employer match about $61,095 at 4% or $40,730 at 6%.
202015$1,220,430$36,868$7,374iApproximate average salary by contribution assumption: employee only about $184,340 at 4% or $122,893 at 6%; with 50% employer match about $122,893 at 4% or $81,929 at 6%; with 100% employer match about $92,170 at 4% or $61,447 at 6%.
The Microdata Systems Inc. Retirement Plan-5$1,220,430$36,868$7,374iApproximate average salary by contribution assumption: employee only about $184,340 at 4% or $122,893 at 6%; with 50% employer match about $122,893 at 4% or $81,929 at 6%; with 100% employer match about $92,170 at 4% or $61,447 at 6%.
201915$1,039,801$45,309$9,062iApproximate average salary by contribution assumption: employee only about $226,545 at 4% or $151,030 at 6%; with 50% employer match about $151,030 at 4% or $100,687 at 6%; with 100% employer match about $113,272 at 4% or $75,515 at 6%.
The Microdata Systems Inc. Retirement Plan-5$1,039,801$45,309$9,062iApproximate average salary by contribution assumption: employee only about $226,545 at 4% or $151,030 at 6%; with 50% employer match about $151,030 at 4% or $100,687 at 6%; with 100% employer match about $113,272 at 4% or $75,515 at 6%.
201816$971,682$48,764$8,127iApproximate average salary by contribution assumption: employee only about $203,183 at 4% or $135,456 at 6%; with 50% employer match about $135,456 at 4% or $90,304 at 6%; with 100% employer match about $101,592 at 4% or $67,728 at 6%.
The Microdata Systems Inc. Retirement Plan-6$971,682$48,764$8,127iApproximate average salary by contribution assumption: employee only about $203,183 at 4% or $135,456 at 6%; with 50% employer match about $135,456 at 4% or $90,304 at 6%; with 100% employer match about $101,592 at 4% or $67,728 at 6%.
201716$977,862$50,164$8,361iApproximate average salary by contribution assumption: employee only about $209,017 at 4% or $139,344 at 6%; with 50% employer match about $139,344 at 4% or $92,896 at 6%; with 100% employer match about $104,508 at 4% or $69,672 at 6%.
The Microdata Systems Inc. Retirement Plan-6$977,862$50,164$8,361iApproximate average salary by contribution assumption: employee only about $209,017 at 4% or $139,344 at 6%; with 50% employer match about $139,344 at 4% or $92,896 at 6%; with 100% employer match about $104,508 at 4% or $69,672 at 6%.
201616$810,298$51,213$8,536iApproximate average salary by contribution assumption: employee only about $213,388 at 4% or $142,258 at 6%; with 50% employer match about $142,258 at 4% or $94,839 at 6%; with 100% employer match about $106,694 at 4% or $71,129 at 6%.
The Microdata Systems Inc. Retirement Plan-6$810,298$51,213$8,536iApproximate average salary by contribution assumption: employee only about $213,388 at 4% or $142,258 at 6%; with 50% employer match about $142,258 at 4% or $94,839 at 6%; with 100% employer match about $106,694 at 4% or $71,129 at 6%.
201516$719,021$48,362$8,060iApproximate average salary by contribution assumption: employee only about $201,508 at 4% or $134,339 at 6%; with 50% employer match about $134,339 at 4% or $89,559 at 6%; with 100% employer match about $100,754 at 4% or $67,169 at 6%.
The Microdata Systems Inc. Retirement Plan-6$719,021$48,362$8,060iApproximate average salary by contribution assumption: employee only about $201,508 at 4% or $134,339 at 6%; with 50% employer match about $134,339 at 4% or $89,559 at 6%; with 100% employer match about $100,754 at 4% or $67,169 at 6%.
201415$676,190$42,467$8,493iApproximate average salary by contribution assumption: employee only about $212,335 at 4% or $141,557 at 6%; with 50% employer match about $141,557 at 4% or $94,371 at 6%; with 100% employer match about $106,168 at 4% or $70,778 at 6%.
The Microdata Systems Inc. Retirement Plan-5$676,190$42,467$8,493iApproximate average salary by contribution assumption: employee only about $212,335 at 4% or $141,557 at 6%; with 50% employer match about $141,557 at 4% or $94,371 at 6%; with 100% employer match about $106,168 at 4% or $70,778 at 6%.
201315$676,547$34,721$6,944iApproximate average salary by contribution assumption: employee only about $173,605 at 4% or $115,737 at 6%; with 50% employer match about $115,737 at 4% or $77,158 at 6%; with 100% employer match about $86,803 at 4% or $57,868 at 6%.
The Microdata Systems Inc. Retirement Plan-5$676,547$34,721$6,944iApproximate average salary by contribution assumption: employee only about $173,605 at 4% or $115,737 at 6%; with 50% employer match about $115,737 at 4% or $77,158 at 6%; with 100% employer match about $86,803 at 4% or $57,868 at 6%.
201215$564,096$33,010$6,602iApproximate average salary by contribution assumption: employee only about $165,050 at 4% or $110,033 at 6%; with 50% employer match about $110,033 at 4% or $73,356 at 6%; with 100% employer match about $82,525 at 4% or $55,017 at 6%.
The Microdata Systems Inc. Retirement Plan-5$564,096$33,010$6,602iApproximate average salary by contribution assumption: employee only about $165,050 at 4% or $110,033 at 6%; with 50% employer match about $110,033 at 4% or $73,356 at 6%; with 100% employer match about $82,525 at 4% or $55,017 at 6%.
201116$504,957$31,900$5,317iApproximate average salary by contribution assumption: employee only about $132,917 at 4% or $88,611 at 6%; with 50% employer match about $88,611 at 4% or $59,074 at 6%; with 100% employer match about $66,458 at 4% or $44,306 at 6%.
The Microdata Systems Inc. Retirement Plan-6$504,957$31,900$5,317iApproximate average salary by contribution assumption: employee only about $132,917 at 4% or $88,611 at 6%; with 50% employer match about $88,611 at 4% or $59,074 at 6%; with 100% employer match about $66,458 at 4% or $44,306 at 6%.
201018$489,225$31,508$3,939iApproximate average salary by contribution assumption: employee only about $98,463 at 4% or $65,642 at 6%; with 50% employer match about $65,642 at 4% or $43,761 at 6%; with 100% employer match about $49,231 at 4% or $32,821 at 6%.
The Microdata Systems Inc. Retirement Plan-8$489,225$31,508$3,939iApproximate average salary by contribution assumption: employee only about $98,463 at 4% or $65,642 at 6%; with 50% employer match about $65,642 at 4% or $43,761 at 6%; with 100% employer match about $49,231 at 4% or $32,821 at 6%.
200918$414,156$30,611$3,826iApproximate average salary by contribution assumption: employee only about $95,659 at 4% or $63,773 at 6%; with 50% employer match about $63,773 at 4% or $42,515 at 6%; with 100% employer match about $47,830 at 4% or $31,886 at 6%.
The Microdata Systems Inc. Retirement Plan-8$414,156$30,611$3,826iApproximate average salary by contribution assumption: employee only about $95,659 at 4% or $63,773 at 6%; with 50% employer match about $63,773 at 4% or $42,515 at 6%; with 100% employer match about $47,830 at 4% or $31,886 at 6%.
200815$330,877$30,693$6,139iApproximate average salary by contribution assumption: employee only about $153,465 at 4% or $102,310 at 6%; with 50% employer match about $102,310 at 4% or $68,207 at 6%; with 100% employer match about $76,733 at 4% or $51,155 at 6%.
The Microdata Systems Inc. Retirement Plan-5$330,877$30,693$6,139iApproximate average salary by contribution assumption: employee only about $153,465 at 4% or $102,310 at 6%; with 50% employer match about $102,310 at 4% or $68,207 at 6%; with 100% employer match about $76,733 at 4% or $51,155 at 6%.
200716$0$0-
The Microdata Systems Inc. Retirement PlanCurrent6---
200617$401,946$26,103$3,729iApproximate average salary by contribution assumption: employee only about $93,225 at 4% or $62,150 at 6%; with 50% employer match about $62,150 at 4% or $41,433 at 6%; with 100% employer match about $46,613 at 4% or $31,075 at 6%.
The Microdata Systems Inc. Retirement Plan-7$401,946$26,103$3,729iApproximate average salary by contribution assumption: employee only about $93,225 at 4% or $62,150 at 6%; with 50% employer match about $62,150 at 4% or $41,433 at 6%; with 100% employer match about $46,613 at 4% or $31,075 at 6%.
200517$343,670$19,098$2,728iApproximate average salary by contribution assumption: employee only about $68,207 at 4% or $45,471 at 6%; with 50% employer match about $45,471 at 4% or $30,314 at 6%; with 100% employer match about $34,104 at 4% or $22,736 at 6%.
The Microdata Systems Inc. Retirement Plan-7$343,670$19,098$2,728iApproximate average salary by contribution assumption: employee only about $68,207 at 4% or $45,471 at 6%; with 50% employer match about $45,471 at 4% or $30,314 at 6%; with 100% employer match about $34,104 at 4% or $22,736 at 6%.
200416$311,275$22,270$3,712iApproximate average salary by contribution assumption: employee only about $92,792 at 4% or $61,861 at 6%; with 50% employer match about $61,861 at 4% or $41,241 at 6%; with 100% employer match about $46,396 at 4% or $30,931 at 6%.
The Microdata Systems Inc. Retirement Plan-6$311,275$22,270$3,712iApproximate average salary by contribution assumption: employee only about $92,792 at 4% or $61,861 at 6%; with 50% employer match about $61,861 at 4% or $41,241 at 6%; with 100% employer match about $46,396 at 4% or $30,931 at 6%.
200316$270,017$40,236$6,706iApproximate average salary by contribution assumption: employee only about $167,650 at 4% or $111,767 at 6%; with 50% employer match about $111,767 at 4% or $74,511 at 6%; with 100% employer match about $83,825 at 4% or $55,883 at 6%.
The Microdata Systems Inc. Retirement Plan-6$270,017$40,236$6,706iApproximate average salary by contribution assumption: employee only about $167,650 at 4% or $111,767 at 6%; with 50% employer match about $111,767 at 4% or $74,511 at 6%; with 100% employer match about $83,825 at 4% or $55,883 at 6%.
200216$187,279$26,291$4,382iApproximate average salary by contribution assumption: employee only about $109,546 at 4% or $73,031 at 6%; with 50% employer match about $73,031 at 4% or $48,687 at 6%; with 100% employer match about $54,773 at 4% or $36,515 at 6%.
The Microdata Systems Inc. Retirement Plan-6$187,279$26,291$4,382iApproximate average salary by contribution assumption: employee only about $109,546 at 4% or $73,031 at 6%; with 50% employer match about $73,031 at 4% or $48,687 at 6%; with 100% employer match about $54,773 at 4% or $36,515 at 6%.
200116$200,537$27,650$4,608iApproximate average salary by contribution assumption: employee only about $115,208 at 4% or $76,806 at 6%; with 50% employer match about $76,806 at 4% or $51,204 at 6%; with 100% employer match about $57,604 at 4% or $38,403 at 6%.
The Microdata Systems Inc. Retirement Plan-6$200,537$27,650$4,608iApproximate average salary by contribution assumption: employee only about $115,208 at 4% or $76,806 at 6%; with 50% employer match about $76,806 at 4% or $51,204 at 6%; with 100% employer match about $57,604 at 4% or $38,403 at 6%.
200018$0$0-
The Microdata Systems Inc. Retirement Plan-8---
199918$195,765$24,094$3,012iApproximate average salary by contribution assumption: employee only about $75,294 at 4% or $50,196 at 6%; with 50% employer match about $50,196 at 4% or $33,464 at 6%; with 100% employer match about $37,647 at 4% or $25,098 at 6%.
The Microdata Systems Inc. Retirement Plan-8$195,765$24,094$3,012iApproximate average salary by contribution assumption: employee only about $75,294 at 4% or $50,196 at 6%; with 50% employer match about $50,196 at 4% or $33,464 at 6%; with 100% employer match about $37,647 at 4% or $25,098 at 6%.
Schedule Details

Schedule A

Row 1
Filing Id
84037270079568
Form Id
90833983
Page Id
2
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7030378270079060002
Ins Broker 01 Name
CBIZ BENEFITS & INSURANCE SERVICES
Ins Broker 01 Street Addr
11440 TOMAHAWK CREEK PARKWAY
Ins Broker 01 City
LEAWOOD
Ins Broker 01 State
KS
Ins Broker 01 ZIP Code
66211
Ins Broker Comm Pd 01 Amount
$3,987
Ins Broker Fees Pd 01 Amount
$472
Ins Broker Fees Pd 01 Text
FEES
Ins Broker 01 Code
5
Row 2
Ins Carrier Name: ING LIFE AND ANNUITY COMPANY
Filing Id
84037270079568
Form Id
90833983
Schedule A EIN
25-1452773
Schedule A Plan Num
001
Schedule A Plan Year Begin Date
2007-01-01
Schedule A Tax Period
20071231
Ins Carrier Name
ING LIFE AND ANNUITY COMPANY
Ins Carrier EIN
71-0294708
Ins Carrier Naic Code
86509
Ins Contract Num
PHT657
Ins Prsn Covered End of year Count
0
Ins Policy From Date
2007-01-01
Ins Policy To Date
2007-12-31
Ins Broker Comm Total Amount
$3,987
Ins Broker Fees Total Amount
$472
Pension End of year Gen Account Amount
$0
Pension End of year Sep Account Amount
$0
Pension Prem Paid Total Amount
$0
Pension Unpaid Premium Amount
$0
Pension Contract Cost Amount
$0
Pnsn Type Unalloc Cntrct I
4
Pension Oth Unalloc Type Text
OTHER-GROUP PENSION FUNDING
Pension End Prev Bal Amount
$0
Pension Contribution Dep Amount
$0
Pension Divnd Cr Dep Amount
$0
Pension Interest Cr Dur Yr Amount
$0
Pension Transfer From Amount
$0
Pension Other Amount
$0
Pension Total Additions Amount
$0
Pension Total Bal Addn Amount
$0
Pension Bnfts Dsbrsd Amount
$0
Pension Admin Chrg Amount
$0
Pension Transfer To Amount
$0
Pension Oth Ded Amount
$0
Pension Total Ded Amount
$0
Pension End of year Bal Amount
$0
Wlfr Premium Rcvd Amount
$0
Wlfr Unpaid Due Amount
$0
Wlfr Reserve Amount
$0
Wlfr Total Earned Prem Amount
$0
Wlfr Claims Paid Amount
$0
Wlfr Incr Reserve Amount
$0
Wlfr Incurred Claim Amount
$0
Wlfr Claims Chrgd Amount
$0
Wlfr Ret Commissions Amount
$0
Wlfr Ret Admin Amount
$0
Wlfr Ret Oth Cost Amount
$0
Wlfr Ret Oth Expense Amount
$0
Wlfr Ret Taxes Amount
$0
Wlfr Ret Charges Amount
$0
Wlfr Ret Oth Chrgs Amount
$0
Wlfr Ret Total Amount
$0
Wlfr Refund Amount
$0
Wlfr Held Bnfts Amount
$0
Wlfr Claims Reserve Amount
$0
Wlfr Oth Reserve Amount
$0
Wlfr Divnds Due Amount
$0
Wlfr Total Charges Paid Amount
$0
Wlfr Acquis Cost Amount
$0

Schedule D

Row 1
Filing Id
84037270079568
Page Id
1
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7030378270079060003
DFE P1 Entity 01 Name
ING LIFE INSURANCE AND ANNUITY CO.
DFE P1 Spons 01 Name
ING LIFE INSURANCE AND ANNUITY CO.
DFE P1 Plan 01 EIN Plan number
710294708001
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$412,020
Row 2
Filing Id
84037270079568
Page Id
3
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7030378270079060003

Schedule R

Schedule R Pension Information

Retirement plan characteristics

Testing, payor, opinion-letter, and transfer information reported with the filing.

Pension & Payor

Payor EIN71-0294708

Transfers

Distributed property value$0
Schedule R source fields
Payor 71-0294708
Filing Id
84037270079568
Schedule R EIN
25-1452773
Schedule R Plan number
001
Schedule R Plan Year Begin Date
2007-01-01
Schedule R Tax Period
20071231
Pension Value Dstrb Pd Property Amount
$0
Pension payor EIN
71-0294708
Pension Bnft Distribution Sngl Sum Count
0
Pension Employer Contribution Rqr Amount
$0
Pension Employer Contribution Paid Amount
$0
Pension Funding Deficiency Amount
$0
Pension Chg Fndng Method Indicator
3
Pension Satisfy Cover Basis Code
1