Features and benefits of using WynPlan include the following:

• Ability to define the first fiscal year start date as well as independently defining the start date of the Plan.  For reporting purposes we could report on a calendar basis while starting the plan on ANY month during the first year.
• Logical step-by step procedure to enter driver data.
  ALL Driver requirements are contained within the Driver sheet.
  Up to SIX selling profiles available for the Executive version of WynPlan, THREE for the Manager version and ONE for the FREE Entry level model.
  Numerous options to control Sales Rep headcount plan including:
  • Hire start date based on a given lag from plan start date or start date of any other employee.
  • Ability to specify duration of service of any Sales Rep (up to 60 months).
  • Start and end date for every Sales Rep is calculated and shown on the headcount driver window.
  • Ability to “scale” the sales performance of any Sales Rep by use of a “Selling Index”, which results in percentage change to reference Profile performance.
  • Ability to specify a “Recruiting Fee” for any sales Rep as well as specifying the method of payment, either immediate cash payment or payment through the Accounts Payable system.
• Three methods available to “shape” gross margin for the SRD-Rev model and ability to define selling price and cost for each fiscal year for each profile in the SRD-Prod model.

• Separate Headcount plan for each department.  The Headcount plan includes full time employees as well as temporary or contract employees and includes the following options to control each department headcount:
  • Employee start date triggered by:
    • A defined lag from the start of the Plan.
    • A defined number of months before or after another employee starts or leaves.
    • When the number of Sales Reps reaches a defined trigger level.
    • When the revenue running rate reaches a defined trigger level.
  • Ability to specify duration of service for any employee.
  • Start and end date for every employee is calculated and shown on the headcount driver window.
  • Ability to specify a “Recruiting Fee” for any employee as well as specifying the method of payment, either immediate cash payment or payment through the Accounts Payable system.
• All department expenses are grouped as being either:
  • Common to ALL departments or
  • Unique to specific departments.
• Each expense allows for up to THREE methods of planning.
• Each expense allows for adjustments in “granularity” by allowing for expense planning to be defined in terms of periods of THREE, SIX or TWELVE months.  However each expense allows for a THREE month transition period at the start of each expense.
• Commission expense included in Sales & Marketing Department, allowing the payment of commission to be based on:
  • Revenue recognition with appropriate delay.
  • Customer cash receipt with appropriate delay.
• Separate control over the start time of each expense.
• Payment method (Cash or Accounts Payable) selected for each expense.
• Color coded cells indicate when Driver data is complete (or NOT complete).
• Ability to use the Advertising/Marketing Programs expense as a separate revenue channel by defining a “Revenue/Expense” multiplier, coupled with given number of months delay from Expense to Revenue.
• Inclusion of “Discretionary Expenses” which allows for customization of expense names to accommodate the needs and financial characteristics of the company.
• Ability to include Interest Revenue based on interest generated on cash above a defined threshold amount.
• Inclusion of Income Tax expense and the ability to specify FOUR payment months per year.
• Ability to split customer sales collections into:
  • COD sales
  • Sales on account
• Accounts receivable planning method based on Days Sales Outstanding (DSO).  Ability to “shape” DSO over the duration of the Plan based on the “planning increment” concept.
• Inventory planning method based on “Days of On Hand inventory” (DOH).  This method sometimes gives a less volatile plan than that based on using “Inventory Turns” and is probably easier to understand.  Again, we have the ability to “shape” DOH based on the “planning increment” concept.
• Inclusion of Prepaid Expense asset which is expensed as a G & A expense over the life of the prepayment.  Renewal dates are governed by the original date and prepayment duration.
• Two classes of Fixed Assets with differing lives for depreciation.  The first class is intended for computer equipment and has a maximum depreciation life of FIVE years.  The second class, Other Fixed Assets, has a maximum depreciation life of SEVEN years.  Depreciation expense is recorded as a G & A expense and is based on the fixed line method of calculation.
• WynPlan uses the “Days Payable” method to plan Accounts Payable.  Again, WynPlan offers the ability to “shape” “Days Payable” over the duration of the Plan.
• Accrued Liabilities include accrued interest payable on bank loan as well as commission payable.  Other Current Liabilities include income tax liability.
• Financing options include THREE rounds of equity financing as well as a bank loan.

Analytical and reporting aids featured in WynPlan include:

• the WynPlan Ribbon, shown below:

• The ribbon is displayed on the Driver Sheet and is seen by first activating the macro from the Message Bar and clicking on the “Show WynPlan Ribbon” button.  The ribbon is used as a visual aid in adjusting drivers to attain the desired results.  Note that in the above example, the minimum cash balance included in the Plan is $1,179,000 negative which occurs at the end of October 2012.  By performing a series of WIF scenarios, one can observe changes in financial performance as evidenced by the information shown in the WynPlan Ribbon.

• A detailed Assumptions Report that lists ALL the drivers included in the plan.  This report should be run after the FIRST round of entering Driver data as a means of reviewing “what exactly is in this plan”.

• A detailed Financial Statements Report showing:

• • Five year financial overview including key performance metrics
  • Five Year Income Statement (Years 1 and 2 by quarters and annual totals, Years 3, 4 and 5 by annual totals)
  • Balance Sheet
  • Statement of Cash Flow
  • Details of performance of all Sales Representatives
  • Headcount detail, employees and temporary/contract employees for each department
  • Detailed department expense reports.

• Inclusion of a FIVE year discounted cash flow analysis based on a range of discount rates and the ability to modify cash flow as a means of determining sensitivity of calculated Net Present Value (NPV).

• Navigation Menu that allows for ease of navigation through the Driver sheet.  The “Go to Menu” button is located on Row 1 of the Driver sheet.  Use of the Menu first requires activation of the macro from the Message Bar.

• Detailed analysis of Sales Representative Contribution where the definition of “Contribution” is controlled by selecting from a list of Sales Rep sensitive Drivers.  The resulting analysis includes metrics, by each Sales Rep on:

• Months required to break-even

• Month of break-even contribution

• Contribution over TWO user defined time periods, each starting at the month of hire.

The FINAL feature and benefit of the WynPlan series of models that is worthy of note is Wynism No 7.