Table: Tasks

Lookup Value:

Start Date:

End Date:

TaskOpportunity (Formula)StageStatusDue DateAssigned To (Full Name)
Cash Value Reporting"`Kelly, Ted`"AdminComplete01/01/2023Brittney Leonard
Cash Value Reporting"`Kelly, Ted`"AdminComplete01/01/2023"Brittney Leonard,Heather Townley"
Cash Value Reporting"`Kelly, Ted`"AdminComplete02/01/2023"Brittney Leonard,Heather Townley"
Cash Value Reporting"`Kelly, Ted`"AdminComplete02/01/2023Brittney Leonard
Ted Kelly Cash Value Reporting"`Kelly, Ted`"AdminComplete03/01/2023Brittney Leonard
Ted Kelly Cash Value Reporting"`Kelly, Ted`"AdminComplete04/01/2023Brittney Leonard
Ted Kelly Cash Value Reporting"`Kelly, Ted`"AdminComplete05/01/2023Brittney Leonard
Ted Kelly Cash Value Reporting"`Kelly, Ted`"AdminComplete06/01/2023Brittney Leonard
Ted Kelly Cash Value Reporting"`Kelly, Ted`"AdminComplete07/01/2023Brittney Leonard
Ted Kelly Cash Value Reporting"`Kelly, Ted`"AdminComplete08/01/2023Brittney Leonard
Ted Kelly Cash Value Reporting"`Kelly, Ted`"AdminComplete09/01/2023Brittney Leonard
Reply to Brad`s email question"`Kopp, Brad`"AdminComplete07/28/2021Chris Wyrtzen
Cash Value Reporting"`Kopp, Brad`"AdminComplete01/01/2023Brittney Leonard
Cash Value Reporting"`Kopp, Brad`"AdminComplete02/01/2023Brittney Leonard
Brad Kopp Cash Value Reporting"`Kopp, Brad`"AdminComplete03/01/2023Brittney Leonard
Brad Kopp Cash Value Reporting"`Kopp, Brad`"AdminComplete04/01/2023Brittney Leonard
Brad Kopp Cash Value Reporting"`Kopp, Brad`"AdminComplete05/01/2023Brittney Leonard
Brad Kopp Cash Value Reporting"`Kopp, Brad`"AdminComplete06/01/2023Brittney Leonard
Brad Kopp Cash Value Reporting"`Kopp, Brad`"AdminComplete07/01/2023Brittney Leonard
Brad Kopp Cash Value Reporting"`Kopp, Brad`"AdminComplete08/01/2023Brittney Leonard
Kopp - Prudential Annual Premium Invoice"`Kopp, Brad`"AdminComplete08/04/2023Heather Townley
Brad Kopp Cash Value Reporting"`Kopp, Brad`"AdminComplete09/01/2023Brittney Leonard
Address update with Pru"`Kopp, Brad`"AdminComplete09/06/2023Heather Townley
Review Bob`s question with Case Design team Tuesday morning"`Petry, Paul`"AdminComplete01/25/2022Chris Wyrtzen
Cash Value Reporting"`Petry, Paul`"AdminComplete01/01/2023Brittney Leonard
Withdrawal/ Disbursment"`Petry, Paul`"AdminComplete01/17/2023Heather Townley
Cash Value Reporting"`Petry, Paul`"AdminComplete02/01/2023Brittney Leonard
Paul Petry Cash Value Reporting"`Petry, Paul`"AdminComplete03/01/2023Brittney Leonard
Contribution Reminder to Lynn Buskey for premium payment from the Trust"`Petry, Paul`"AdminComplete03/24/2023Heather Townley
Paul Petry Cash Value Reporting"`Petry, Paul`"AdminComplete04/01/2023Brittney Leonard
Paul Petry Cash Value Reporting"`Petry, Paul`"AdminComplete05/01/2023Brittney Leonard
Paul Petry Cash Value Reporting"`Petry, Paul`"AdminComplete06/01/2023Brittney Leonard
Paul Petry Cash Value Reporting"`Petry, Paul`"AdminComplete07/01/2023Brittney Leonard
Paul Petry Cash Value Reporting"`Petry, Paul`"AdminComplete08/01/2023Brittney Leonard
Paul Petry Cash Value Reporting"`Petry, Paul`"AdminComplete09/01/2023Brittney Leonard
HT to send out Annual Premium Invoice once annual review is complete"`Quaranto, Paul`"AdminComplete07/30/2021Heather Townley
KR - can you put together the Lincoln and Penn Mutual reprojections we need for Paul Quaranto? Meeting with him on Thursday morning. See case update for specs."`Quaranto, Paul`"AdminComplete08/10/2021Karl Reinhold
Put together Agenda and Segment results"`Quaranto, Paul`"AdminComplete08/10/2021Chris Wyrtzen
CW to call Paul to set up the annual review"`Quaranto, Paul`"AdminComplete08/11/2021Chris Wyrtzen
"Send F/U email to Paul - DCA Account, 1 Additional Premium, ICOLI?""`Quaranto, Paul`"AdminComplete08/13/2021Chris Wyrtzen
Set up appointment with Paul to review policy"`Quaranto, Paul`"AdminComplete08/19/2022Chris Wyrtzen
Start preparing for annual meeting"`Quaranto, Paul`"AdminComplete09/05/2022Chris Wyrtzen
Send f/u email with information Paul needs on Penn policy (allocation options)"`Quaranto, Paul`"AdminComplete12/02/2022Chris Wyrtzen
"Form 712, bene change, and owner change request""`Quaranto, Paul`"AdminComplete05/03/2023Heather Townley
Flush out the Braman example further0-Sales Concept - Atticus Premium Finance for DB Benefit PoolClosed/LostComplete05/11/2022Chris Wyrtzen
Fill out LSF paperwork1-LicensingClosed/WonComplete10/17/2022Chris Wyrtzen
Make sure that Insperity has enrollment contribution elections for new employees401k EnrollmentProjectsComplete01/04/2023Chris Wyrtzen
Verify that fee is dropped to 40 bps in 2023401k EnrollmentProjectsComplete06/30/2023Chris Wyrtzen
Enroll Megan for 2023 contributions401k EnrollmentProjectsComplete06/30/2023Chris Wyrtzen
Have July send Brady information about signing up for the 401(k)401k EnrollmentProjectsToDo10/27/2023Chris Wyrtzen
Send Les some times for a call in January for educational meeting401k EnrollmentProjectsToDo12/01/2023Chris Wyrtzen
Finalize the 2021 Safe Harbor contribution2022 EBS Planning ItemsClosed/WonComplete09/23/2022Chris Wyrtzen
Iron Mountain Follow Up on refund2022 EBS Planning ItemsClosed/WonComplete04/28/2023Heather Townley
Put together Abadi exhibits - see the Ovadia work as a guideAbadi PPLIClosed/LostComplete01/03/2022Karl Reinhold
Review what Karl puts together and make sure materials go to EBS-WestAbadi PPLIClosed/LostComplete01/07/2022Chris Wyrtzen
Discuss case with CR/JA/KRAbadi PPLIClosed/LostComplete01/18/2022"Chris Rich,Chris Wyrtzen,John Analambadakis,Karl Reinhold"
Put together simplistic example of funding for Estate Taxes - see case notes from 1/17Abadi PPLIClosed/LostComplete01/31/2022"Karl Reinhold,John Analambadakis"
Review what John put together and send on to EBS-WestAbadi PPLIClosed/LostComplete02/07/2022Chris Wyrtzen
Run illustrations at Underwriting offerACCA Split DollarClosed/LostCompleteJohn Analambadakis
Ask LS to submit request for informal offers from Lincoln and ZurichACCA Split DollarClosed/LostComplete06/25/2021Bonnie Barnes
Analyze illustrations that JA sent - does it make sense to use insurance?ACCA Split DollarClosed/LostComplete07/06/2021Chris Wyrtzen
Rerun Bart James PacLife illustration as requested in Case UpdateACCA Split DollarClosed/LostComplete07/19/2021John Analambadakis
Fix Date and BOY AGe = 1/1/21 and age 46 (which is what Pac Illus shows) - distributions starting in year 21 (which is what illus shows)ACCA Split DollarClosed/LostComplete07/19/2021John Analambadakis
For PacLife - what Index options are available in the product that Barton James could get?ACCA Split DollarClosed/LostComplete07/22/2021"Karl Reinhold,John Analambadakis"
Follow up with ACCA team on decisionACCA Split DollarClosed/LostComplete09/07/2021"Don Curristan,Bonnie Barnes"
"Run another Bart James illus - target $39,649 using 7-pay - see the Case Update note on 9/21"ACCA Split DollarClosed/LostComplete09/21/2021John Analambadakis
See 9/17 case update for 2 new Exhibits neededACCA Split DollarClosed/LostComplete09/24/2021John Analambadakis
"Schedule call with Kristin for Friday, July 9"Advanced Energy DCPNew AddCompleteChris Wyrtzen
Create Modeler for enrollment meetingsAdvanced Energy DCPNew AddComplete08/11/2021"Chris Wyrtzen,John Analambadakis,Bonnie Barnes"
Put together initial modeling specs for KR/JAAdvanced Energy DCPNew AddComplete08/16/2021Chris Wyrtzen
Put together Benefit Cash Flow modelAdvanced Energy DCPNew AddComplete08/30/2021Chris Wyrtzen
KR to start COLI modeling after CW gives him the Benefit Cash Flow modelAdvanced Energy DCPNew AddComplete08/30/2021Karl Reinhold
"Revised COLI Modeling using the attached Benefit Cash Flows - one is for use with the entire census (distributions thru Yr 26), one for the younger census (distribs thru yr 32). Be sure to use a 6.5% net crediting rate"Advanced Energy DCPNew AddComplete09/07/2021Karl Reinhold
Use revised COLI illustrations to develop COLI vs MF funding modelAdvanced Energy DCPNew AddComplete09/07/2021Chris Wyrtzen
Send KR revised COLI funding / benefit distributionsAdvanced Energy DCPNew AddComplete09/10/2021Chris Wyrtzen
New COLI runs based on updated COLI cash flows from CWAdvanced Energy DCPNew AddComplete09/13/2021Karl Reinhold
Run new AEI COLI illustrations - see revised Ben CFs in Dropbox folder: Dropbox (EBS)\8. Case Work\AEI\2021-10-04 Funding Model\Advanced Energy DCPNew AddComplete10/04/2021Karl Reinhold
Run slightly revised distribution scenario - stored in latest folder: COLI Funding Specs-to KR-10-04.xlsxAdvanced Energy DCPNew AddComplete10/05/2021Karl Reinhold
Design session on ModelerAdvanced Energy DCPNew AddComplete10/15/2021"Chris Wyrtzen,John Analambadakis"
COLI Market SurveyAdvanced Energy DCPNew AddComplete10/25/2021Chris Wyrtzen
Compensation AnalysisAdvanced Energy DCPNew AddComplete10/25/2021Chris Wyrtzen
Put together Enrollment GuideAdvanced Energy DCPNew AddComplete11/11/2021Chris Rich
Finalize ModelerAdvanced Energy DCPNew AddComplete12/13/2021"Chris Wyrtzen,John Analambadakis"
Put together one page summary of the COLI purchase recommendationAdvanced Energy DCPNew AddComplete01/04/2022Chris Wyrtzen
Get approval from Lincoln on GI COLIAdvanced Energy DCPNew AddComplete01/04/2022Chris Wyrtzen
Follow-up on Consent requestsAdvanced Energy DCPNew AddComplete01/07/2022Chris Wyrtzen
Admin - reach out to Fidelity to set up call to discuss plan adminAdvanced Energy DCPNew AddComplete01/12/2022Chris Wyrtzen
Create Admin outline for Thursday call with AEIAdvanced Energy DCPNew AddComplete01/19/2022Chris Wyrtzen
Verify Consent FormsAdvanced Energy DCPNew AddComplete01/19/2022Brittney Leonard
Run COLI Illustrations for both Lincoln and ProtectiveAdvanced Energy DCPNew AddComplete01/21/2022Karl Reinhold
Send Lincoln Investment options to KristenAdvanced Energy DCPNew AddComplete01/26/2022Chris Wyrtzen
Check with AEI if we have access to Fidelity yetAdvanced Energy DCPNew AddComplete02/03/2022Bonnie Barnes
Go on Fidelity and familiarize with reporting capabilitiesAdvanced Energy DCPNew AddComplete03/07/2022"Bonnie Barnes,Chris Wyrtzen"
Finalize policy death benefit round 1 COLIAdvanced Energy DCPNew AddComplete03/07/2022Chris Wyrtzen
Put together COLI paperworkAdvanced Energy DCPNew AddComplete03/07/2022Bonnie Barnes
Ready for fundingAdvanced Energy DCPNew AddComplete03/29/2022Bonnie Barnes
Send sample Corporate Reporting PackageAdvanced Energy DCPNew AddComplete04/06/2022Chris Wyrtzen
Reallocation from MMAdvanced Energy DCPNew AddComplete05/02/2022Bonnie Barnes
Create reporting package for review on 5/3Advanced Energy DCPNew AddComplete05/02/2022Bonnie Barnes
Accounting for D&D of RSUs: Follow-up with Berg CrawfordAdvanced Energy DCPNew AddComplete11/01/2022Chris Rich