Civic Intelligence
Filing

DCCI Employee Profit Sharing Plan and Trust

Distributed Computing Consultants Inc. • EIN 38-3209256 • Plan year 2006

Filing Insights

Participants

Down

9 → 2

-7 • -77.78%

Assets

Down

$501,606 → $430,504

-$71,102 • -14.17%

Investment Management Fee

-

Admin expenses - • Total expenses $113,889

Filing Details

Context
Net investment result
$-71,102
Pension payor EIN
01-0233346

Status Flags

Fidelity bond in place

Yes

Limited-scope audit performed

Not reported

Contributions transmitted on time

Not reported

Participant loans in default

No

Leases in default

No

Reportable party-in-interest issues

Not reported

Loss discovered during year

No

Assets with undetermined value

No

Non-cash contributions

No

Assets held for investment

Not reported

5% transactions reported

Not reported

All plan assets distributed

No

Benefits paid when due

Not reported

Plan blackout period

Not reported

Plan termination resolution adopted

No

Counterparties

Company Timeline

This filing is highlighted inside the broader sponsor history.

Year / FilingFilingsParticipantsAssetsContributionsContrib./Participant
200910$0$0-
DCCI Employee Profit Sharing Plan and Trust-0$0--
200810$0$0-
DCCI Employee Profit Sharing Plan and Trust-0---
200711$0$0-
DCCI Employee Profit Sharing Plan and Trust-1---
200612$430,504$0-
DCCI Employee Profit Sharing Plan and TrustCurrent2$430,504--
200512$501,606$13,375$6,688iApproximate average salary by contribution assumption: employee only about $167,188 at 4% or $111,458 at 6%; with 50% employer match about $111,458 at 4% or $74,306 at 6%; with 100% employer match about $83,594 at 4% or $55,729 at 6%.
DCCI Employee Profit Sharing Plan and Trust-2$501,606$13,375$6,688iApproximate average salary by contribution assumption: employee only about $167,188 at 4% or $111,458 at 6%; with 50% employer match about $111,458 at 4% or $74,306 at 6%; with 100% employer match about $83,594 at 4% or $55,729 at 6%.
200414$519,186$10,755$2,689iApproximate average salary by contribution assumption: employee only about $67,219 at 4% or $44,813 at 6%; with 50% employer match about $44,813 at 4% or $29,875 at 6%; with 100% employer match about $33,609 at 4% or $22,406 at 6%.
DCCI Employee Profit Sharing Plan and Trust-4$519,186$10,755$2,689iApproximate average salary by contribution assumption: employee only about $67,219 at 4% or $44,813 at 6%; with 50% employer match about $44,813 at 4% or $29,875 at 6%; with 100% employer match about $33,609 at 4% or $22,406 at 6%.
200314$474,716$51,885$12,971iApproximate average salary by contribution assumption: employee only about $324,281 at 4% or $216,188 at 6%; with 50% employer match about $216,188 at 4% or $144,125 at 6%; with 100% employer match about $162,141 at 4% or $108,094 at 6%.
DCCI Employee Profit Sharing Plan and Trust-4$474,716$51,885$12,971iApproximate average salary by contribution assumption: employee only about $324,281 at 4% or $216,188 at 6%; with 50% employer match about $216,188 at 4% or $144,125 at 6%; with 100% employer match about $162,141 at 4% or $108,094 at 6%.
200218$443,029$100,259$12,532iApproximate average salary by contribution assumption: employee only about $313,309 at 4% or $208,873 at 6%; with 50% employer match about $208,873 at 4% or $139,249 at 6%; with 100% employer match about $156,655 at 4% or $104,436 at 6%.
DCCI Employee Profit Sharing Plan and Trust-8$443,029$100,259$12,532iApproximate average salary by contribution assumption: employee only about $313,309 at 4% or $208,873 at 6%; with 50% employer match about $208,873 at 4% or $139,249 at 6%; with 100% employer match about $156,655 at 4% or $104,436 at 6%.
2001116$0$0-
DCCI Employee Profit Sharing Plan and Trust-16---
2000117$0$0-
DCCI Employee Profit Sharing Plan and Trust-17---
1999113$438,945$159,492$12,269iApproximate average salary by contribution assumption: employee only about $306,715 at 4% or $204,477 at 6%; with 50% employer match about $204,477 at 4% or $136,318 at 6%; with 100% employer match about $153,358 at 4% or $102,238 at 6%.
DCCI Employee Profit Sharing Plan and Trust-13$438,945$159,492$12,269iApproximate average salary by contribution assumption: employee only about $306,715 at 4% or $204,477 at 6%; with 50% employer match about $204,477 at 4% or $136,318 at 6%; with 100% employer match about $153,358 at 4% or $102,238 at 6%.
Schedule Details

Schedule A

Row 1
Filing Id
84037323486567
Form Id
83922931
Page Id
2
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
6030377323486060002
Ins Broker 01 Name
THE GLASS FREEDMAN COMPANY
Ins Broker 01 Street Addr
30400 TELEGRAPH ROAD, SUITE 435
Ins Broker 01 City
BINGHAM FARMS
Ins Broker 01 State
MI
Ins Broker 01 ZIP Code
48025
Ins Broker Comm Pd 01 Amount
$1,758
Ins Broker Fees Pd 01 Amount
$0
Ins Broker 01 Code
3
Row 2
Filing Id
84037323486567
Form Id
83922931
Page Id
2
Page Seq
0
Page Row Num
2
Row Num
1
Image Form Id
6030377323486060002
Ins Broker 01 Name
MERRILL LYNCH LIFE AGENCY
Ins Broker Comm Pd 01 Amount
$160
Ins Broker Fees Pd 01 Amount
$0
Ins Broker 01 Code
3
Row 3
Filing Id
84037323486567
Form Id
83922931
Page Id
2
Page Seq
0
Page Row Num
3
Row Num
2
Image Form Id
6030377323486060002
Ins Broker 01 Name
THE GLASS FREEDMAN COMPANY
Ins Broker 01 Street Addr
30400 TELEGRAPH ROAD, SUITE 435
Ins Broker 01 City
BIMGHAM FARMS
Ins Broker 01 State
MI
Ins Broker 01 ZIP Code
48025
Ins Broker Comm Pd 01 Amount
$0
Ins Broker Fees Pd 01 Amount
$145
Ins Broker 01 Code
3
Row 4
Ins Carrier Name: JOHN HANCOCK LIFE INSURANE COMPANY (U.S.A.)
Filing Id
84037323486567
Form Id
83922931
Schedule A EIN
38-3209256
Schedule A Plan Num
001
Schedule A Plan Year Begin Date
2006-01-01
Schedule A Tax Period
20061231
Ins Carrier Name
JOHN HANCOCK LIFE INSURANE COMPANY (U.S.A.)
Ins Carrier EIN
01-0233346
Ins Carrier Naic Code
65838
Ins Contract Num
63841
Ins Prsn Covered End of year Count
6
Ins Policy From Date
2006-01-01
Ins Policy To Date
2006-12-31
Ins Broker Comm Total Amount
$1,918
Ins Broker Fees Total Amount
$145
Pension End of year Gen Account Amount
$0
Pension End of year Sep Account Amount
$420,744
Pension Prem Paid Total Amount
$0
Pension Unpaid Premium Amount
$0
Pension Contract Cost Amount
$0
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
84037323486567
Page Id
1
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
6030377323486060003
DFE P1 Entity 01 Name
JH PIMCO TOTAL RETURN
DFE P1 Spons 01 Name
JOHN HANCOCK LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
010233346000
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$2,336
Row 2
Filing Id
84037323486567
Page Id
3
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
6030377323486060003
Row 3
Filing Id
84037323486567
Page Id
1
Page Seq
0
Page Row Num
2
Row Num
1
Image Form Id
6030377323486060003
DFE P1 Entity 01 Name
JH SALOMON BROS HIGH YIELD
DFE P1 Spons 01 Name
JOHN HANCOCK LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
010233346000
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$8,738
Row 4
Filing Id
84037323486567
Page Id
2
Page Seq
1
Page Row Num
1
Row Num
10
Image Form Id
6030377323486060003
DFE P1 Entity 01 Name
MONEY MARKET FUND
DFE P1 Spons 01 Name
JOHN HANCOCK LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
010233346000
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$1,583
Row 5
Filing Id
84037323486567
Page Id
2
Page Seq
1
Page Row Num
2
Row Num
11
Image Form Id
6030377323486060003
DFE P1 Entity 01 Name
JH SCUDDER INTL SELECT EQUITY
DFE P1 Spons 01 Name
JOHN HANCOCK LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
010233346000
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$0
Row 6
Filing Id
84037323486567
Page Id
1
Page Seq
0
Page Row Num
3
Row Num
2
Image Form Id
6030377323486060003
DFE P1 Entity 01 Name
JH AMERICAN FUNDS AM BALANCED
DFE P1 Spons 01 Name
JOHN HANCOCK LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
010233346000
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$26,667
Row 7
Filing Id
84037323486567
Page Id
1
Page Seq
0
Page Row Num
4
Row Num
3
Image Form Id
6030377323486060003
DFE P1 Entity 01 Name
JH WEITZ PARTNERS VALUE
DFE P1 Spons 01 Name
JOHN HANCOCK LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
010233346000
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$149,682
Row 8
Filing Id
84037323486567
Page Id
2
Page Seq
0
Page Row Num
1
Row Num
4
Image Form Id
6030377323486060003
DFE P1 Entity 01 Name
JH DOMINI SOCIAL EQUITY
DFE P1 Spons 01 Name
JOHN HANCOCK LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
010233346000
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$75,674
Row 9
Filing Id
84037323486567
Page Id
2
Page Seq
0
Page Row Num
2
Row Num
5
Image Form Id
6030377323486060003
DFE P1 Entity 01 Name
JH T. ROWE PRICE BLUE CHIP
DFE P1 Spons 01 Name
JOHN HANCOCK LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
010233346000
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$33,034
Row 10
Filing Id
84037323486567
Page Id
2
Page Seq
0
Page Row Num
3
Row Num
6
Image Form Id
6030377323486060003
DFE P1 Entity 01 Name
JH AMERICAN FUNDS EUROPACIFIC
DFE P1 Spons 01 Name
JOHN HANCOCK LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
010233346000
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$5,948
Row 11
Filing Id
84037323486567
Page Id
2
Page Seq
0
Page Row Num
4
Row Num
7
Image Form Id
6030377323486060003
DFE P1 Entity 01 Name
JH LEGG MASON GROWTH
DFE P1 Spons 01 Name
JOHN HANCOCK LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
010233346000
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$33,974
Row 12
Filing Id
84037323486567
Page Id
2
Page Seq
0
Page Row Num
5
Row Num
8
Image Form Id
6030377323486060003
DFE P1 Entity 01 Name
JH AIM SMALL CAP GROWTH
DFE P1 Spons 01 Name
JOHN HANCOCK LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
010233346000
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$29,225
Row 13
Filing Id
84037323486567
Page Id
2
Page Seq
0
Page Row Num
6
Row Num
9
Image Form Id
6030377323486060003
DFE P1 Entity 01 Name
JH T. ROWE PRICE SCI & TECH
DFE P1 Spons 01 Name
JOHN HANCOCK LIFE INSURANCE COMPANY
DFE P1 Plan 01 EIN Plan number
010233346000
DFE P1 Entity 01 Code
P
DFE P1 Plan Interest End of year 01 Amount
$53,883
Row 14
Filing Id
84037323486567
Schedule D EIN
38-3209256
Schedule D Plan number
001
Schedule D Plan Year Begin Date
2006-01-01
Schedule D Tax Period
20061231

Schedule I

Schedule I Financial Statement

Small plan result

Balance sheet and activity values reported by the filer for this small-plan annual return.

End-of-year assets$430,504-$71,102 change

Balance Sheet

Beginning and end of plan year.

Total assets$501,606$430,504Decrease -$71,102 (-14.17%)
Total liabilities$0$0No change $0
Net assets$501,606$430,504Decrease -$71,102 (-14.17%)

Contributions

Employer contributions$0
Participant contributions$0
Other contributions$0

Income & Expenses

Total income$42,787
Total expenses$113,889
Net income$-71,102
Source fields
Schedule I source fields
Filing Id
84037323486567
Schedule I EIN
38-3209256
Schedule I Plan Num
001
Schedule I Plan Year Begin Date
2006-01-01
Schedule I Tax Period
20061231
Small plan total assets at beginning of year
$501,606
Small plan total liabilities at beginning of year
$0
Small plan net assets at beginning of year
$501,606
Small plan total assets at end of year
$430,504
Small plan total liabilities at end of year
$0
Small plan net assets at end of year
$430,504
Small plan employer contributions
$0
Small plan participant contributions
$0
Small Oth Contribution Rcvd Amount
$0
Small Non Cash Contribution Bs Amount
$0
Small Other Income Amount
$42,787
Small plan total income
$42,787
Small plan total benefit distributions
$106,455
Small Corrective Distribution Amount
$0
Small Dm Dstrb Ptcp Ln A
0
Small Oth Expenses Amount
$7,434
Small plan total expenses
$113,889
Small plan net income or loss
$-71,102
Small Total Plan Transfers Amount
$0
Small Joint Venture End of year Indicator
No
Small Joint Venture End of year Amount
$0
Small Employer Prop End of year Indicator
No
Small Employer Prop End of year Amount
$0
Small Investment Real Est End of year I
2
Small Investment Real Est End of year A
0
Small Employer Sec End of year Indicator
No
Small Employer Sec End of year Amount
$0
Small Mortg Participants End of year Indicator
No
Small Mortg Participants End of year Amount
$0
Small Oth Lns Participants End of year Indicator
No
Small Oth Lns Participants End of year Amount
$0
Small Personal Prop End of year Indicator
No
Small Personal Prop End of year Amount
$0
Small Fail Xmt Ctb I
2
Small Fail Xmt Ctb A
0
Small plan participant loans in default
No
Small Loans In Default Amount
$0
Small plan leases in default
No
Small Leases In Default Amount
$0
Small Pt In Interest Not Reported I
2
Small Pt In Interest Not Reported A
0
Small plan fidelity bond in place
Yes
Small plan fidelity bond amount
$50,000
Small plan loss discovered during year
No
Small Loss Discovered Dur Year Amount
$0
Small plan assets with undetermined value
No
Small Asset Undeterm Valuation Amount
$0
Small plan non-cash contributions reported
No
Small Non Cash Contribution Amount
$0
Small 20 Percent Sngl Investment Indicator
No
Small 20 Percent Sngl Investment Amount
$0
Small plan all plan assets distributed
No
Waiver Annual Iqpa Report
1
Small plan resolution to terminate plan adopted
No
Small Res Terminate Plan Adpt Amount
$0

Schedule R

Schedule R Pension Information

Retirement plan characteristics

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

Pension & Payor

Payor EIN01-0233346

Transfers

Distributed property value$0
Schedule R source fields
Payor 01-0233346
Filing Id
84037323486567
Schedule R EIN
38-3209256
Schedule R Plan number
001
Schedule R Plan Year Begin Date
2006-01-01
Schedule R Tax Period
20061231
Pension Value Dstrb Pd Property Amount
$0
Pension payor EIN
01-0233346
Pension Bnft Distribution Sngl Sum Count
0
Pension Employer Contribution Rqr Amount
$0
Pension Employer Contribution Paid Amount
$0
Pension Funding Deficiency Amount
$0