System and method for developing a defined pension plan logic and framework

A computerized method for designing pension plan logic and calculations for use by a computer user to create a defined benefit pension plan comprising:

• receiving by a computer questions for use in querying said computer user to define provisions of said defined benefit pension plan and for
• receiving by said computer presentation conditions for presenting said questions to said computer user;
• receiving by the computer in a plurality of spreadsheets a plurality of actuarial formulas for performing calculations suitable to implement said provisions of said defined benefit pension plan;
• receiving by said computer data for a calculation sequence to select said spreadsheets and execute said actuarial formulas in said spreadsheets, said data comprising:
• (a) rules for selecting said spreadsheets and executing said actuarial formulas;
• and
• (b) plan conditions associating responses to said questions with said spreadsheets;
• storing in a first database said defined benefit pension plan questions, said presentation conditions, said spreadsheets comprising said actuarial formulas, and said calculation sequences for selecting said spreadsheets;
• and
• generating executable code for presenting said questions in accordance with said presentation conditions, providing the responses to said questions to said spreadsheets in accordance with said plan conditions, causing said spreadsheets to be selected and to execute said actuarial formulas in accordance with said rules for selecting said spreadsheets and executing said actuarial formulas and the responses to said questions provided by said computer user, thereby defining the provisions of the defined benefit plan consistent with designed pension plan logic.

A computerized system for designing pension plan logic and calculations for use by a computer user to create a defined benefit pension plan comprising:

• a calculation designer configured to receive in a plurality of spreadsheets a plurality of actuarial formulas for performing calculations suitable to implement provisions for said defined benefit plan;
• a rulebench component configured to receive data for:
• a) questions used in querying said computer user to define provisions of said defined benefit pension plan and presentation conditions for presenting said questions to said computer user;
• b) a calculation sequence to select said spreadsheets and execute said actuarial formulas in said spreadsheet;
• c) plan conditions associating responses to said questions with said spreadsheets
• a spreadsheet component configured to store said plurality of spreadsheets for execution according to said calculation sequence;
• a database for storing said questions, said presentation conditions, and said calculation sequence to select said spreadsheets and execute said actuarial formulas;
• and
• a code generation component for generating executable code for presenting said questions in accordance with said presentation conditions, providing the responses to said questions to said spreadsheets in accordance with said plan conditions, causing said spreadsheets to be selected and to execute said actuarial formulas in accordance with said rules for selecting said spreadsheets and executing said actuarial formulas and the responses to said questions provided by said computer user, thereby defining the provisions of the defined benefit plan consistent with designed pension plan logic.