Civic Intelligence
Filing

DCCI Employee Profit Sharing Plan and Trust

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

Filing Insights

Participants

Down

6 → 1

-5 • -83.33%

Assets

No comparison

- → -

No earlier value available.

Investment Management Fee

-

Admin expenses - • Total expenses -

Filing Details

Context

No event flags were generated for this filing.

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
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 TrustCurrent1---
200612$430,504$0-
DCCI Employee Profit Sharing Plan and Trust-2$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
91037002203059
Form Id
93831225
Page Id
2
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7010378270150050002
Ins Broker 01 Name
MERRILL LYNCH
Ins Broker Comm Pd 01 Amount
$2,039
Ins Broker Fees Pd 01 Amount
$0
Ins Broker 01 Code
3
Row 2
Filing Id
91037002203059
Form Id
93831225
Page Id
2
Page Seq
0
Page Row Num
2
Row Num
1
Image Form Id
7010378270150050002
Ins Broker 01 Name
WATKINS, ROSS & CO.
Ins Broker 01 Street Addr
161 OTTAWA AVENUE N.W., SUITE 505
Ins Broker 01 City
GRAND RAPIDS
Ins Broker 01 State
MI
Ins Broker 01 ZIP Code
49503
Ins Broker Comm Pd 01 Amount
$0
Ins Broker Fees Pd 01 Amount
$780
Ins Broker Fees Pd 01 Text
TPA FORUM COMPENSATION
Ins Broker 01 Code
5
Row 3
Ins Carrier Name: JOHN HANCOCK LIFE INSURANCE COMPANY (U.S.A)
Filing Id
91037002203059
Form Id
93831225
Schedule A EIN
38-3209256
Schedule A Plan Num
001
Schedule A Plan Year Begin Date
2007-01-01
Schedule A Tax Period
20071231
Ins Carrier Name
JOHN HANCOCK LIFE INSURANCE 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
2007-01-01
Ins Policy To Date
2007-12-31
Ins Broker Comm Total Amount
$2,039
Ins Broker Fees Total Amount
$780
Pension End of year Gen Account Amount
$0
Pension End of year Sep Account Amount
$394,225
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
91037002203059
Page Id
3
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7010378270150050003
Row 2
Filing Id
91037002203059
Page Id
1
Page Seq
0
Page Row Num
1
Row Num
0
Image Form Id
7010378270150050003
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,505
Row 3
Filing Id
91037002203059
Page Id
1
Page Seq
0
Page Row Num
2
Row Num
1
Image Form Id
7010378270150050003
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
$0
Row 4
Filing Id
91037002203059
Page Id
2
Page Seq
1
Page Row Num
1
Row Num
10
Image Form Id
7010378270150050003
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
$0
Row 5
Filing Id
91037002203059
Page Id
2
Page Seq
1
Page Row Num
2
Row Num
11
Image Form Id
7010378270150050003
DFE P1 Entity 01 Name
JH LIFESTYLE 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
$25,291
Row 6
Filing Id
91037002203059
Page Id
2
Page Seq
1
Page Row Num
3
Row Num
12
Image Form Id
7010378270150050003
DFE P1 Entity 01 Name
JH JOHN HANCOCK STABLE 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
$1,630
Row 7
Filing Id
91037002203059
Page Id
2
Page Seq
1
Page Row Num
4
Row Num
13
Image Form Id
7010378270150050003
DFE P1 Entity 01 Name
JH T. ROWE PRICE SPECTRUM INC
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
$9,206
Row 8
Filing Id
91037002203059
Page Id
2
Page Seq
1
Page Row Num
5
Row Num
14
Image Form Id
7010378270150050003
DFE P1 Entity 01 Name
JH DAVIS NEW YORK VENTURE
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
$105,670
Row 9
Filing Id
91037002203059
Page Id
2
Page Seq
1
Page Row Num
6
Row Num
15
Image Form Id
7010378270150050003
DFE P1 Entity 01 Name
JH BLACKROCK LARGE 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
$137,858
Row 10
Filing Id
91037002203059
Page Id
2
Page Seq
2
Page Row Num
1
Row Num
16
Image Form Id
7010378270150050003
DFE P1 Entity 01 Name
JH AMERICAN FUNDS 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
$73,488
Row 11
Filing Id
91037002203059
Page Id
1
Page Seq
0
Page Row Num
3
Row Num
2
Image Form Id
7010378270150050003
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
$0
Row 12
Filing Id
91037002203059
Page Id
1
Page Seq
0
Page Row Num
4
Row Num
3
Image Form Id
7010378270150050003
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
$0
Row 13
Filing Id
91037002203059
Page Id
2
Page Seq
0
Page Row Num
1
Row Num
4
Image Form Id
7010378270150050003
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
$0
Row 14
Filing Id
91037002203059
Page Id
2
Page Seq
0
Page Row Num
2
Row Num
5
Image Form Id
7010378270150050003
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
$0
Row 15
Filing Id
91037002203059
Page Id
2
Page Seq
0
Page Row Num
3
Row Num
6
Image Form Id
7010378270150050003
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
$6,969
Row 16
Filing Id
91037002203059
Page Id
2
Page Seq
0
Page Row Num
4
Row Num
7
Image Form Id
7010378270150050003
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
$0
Row 17
Filing Id
91037002203059
Page Id
2
Page Seq
0
Page Row Num
5
Row Num
8
Image Form Id
7010378270150050003
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
$31,608
Row 18
Filing Id
91037002203059
Page Id
2
Page Seq
0
Page Row Num
6
Row Num
9
Image Form Id
7010378270150050003
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
$0
Row 19
Filing Id
91037002203059
Schedule D EIN
38-3209256
Schedule D Plan number
001
Schedule D Plan Year Begin Date
2007-01-01
Schedule D Tax Period
20071231