SPC: Sales, Profits and Commissions
Version 1.0.7, March 10, 2005
Significant changes since v1.0.3
- Redesigned the user interface where all layouts fit on a 1024 x 768 screen in landscape mode. This eliminates the need
to scroll from top to bottom to get to various buttons.
- Changed the panel and field coloring scheme of the detail layouts to make it clearer exactly where new or updata data is
to be entered. The main data entry strategy is that users enter new or change data in the center panel, the one with a graph
paper background, and then via the Update or Done buttons, commits the data to the panel immediately to the left. This means
that the user must click a button to change or add data.
- Fields and logic were added to the employment plan feature so that bonus thresholds could be set by the user, and so
that bonus values may be either flat dollar values or percentages of agent quarterly quota amounts. Dollar bonus
amounts will still appear on the Agent Quota report.
- An optional salary field was added to the Agent Profile record for manual inspection and information. The field shows
up as a summarized monthly value on the Commission report.
- A flag was put on the Plan layout to control whether commissions are calculated from sales profit (sale
price – sale
cost) or from total sale price. This feature can be controlled agent by agent, since each agent
can have his own tailored and dynamic employment plan.
- A Sales Item Report was created. This report is identical to the Regional Sales report, except that it sorts by item
and reports a count of each item in a valid sale. A valid sale is one where the sale type is either Purchase
or Lease. Other sales type will not be counted, such as Partner transactions for the secondary partner. Note that the Partner
transactions must be included in the report in order to evalute total sales profit for the sold item.
- The percentage of commission withheld and forwarded to be paid in the next month for agents in the company has been opened
to the user on the Shop layout, so that it can be varied from zero to 100. This allows flexibilty in how a sales shop can be
configured and operated.