ISYS2056 - IPO Chart Two PDF

Preview

Summary

Week 3 Workshop Materials...

Description

IPO Chart Two ISYS2056 Business Information Systems Bill and Huang want to ensure that Brokers are paid their base commissions correctly. Commissions are paid as a percentage of the sales commission/revenue received by Morita of each loan. The rate differs depending on the type of loan (Commercial Home. Motor Vehicle or Personal Loan) settled shown as in Table 1. The relevant percentage is then applied to the sales commission/revenue received by Morita Loans. The owners have also decided to reward staff who have sold single loans that have a settlement value of $1M and above, by paying the broker a $150 bonus for each such loan. The special bonus will show $150 for any loan sales of $1M or more. For each accounting period Morita needs to be aware of the total amounts paid as standard and bonus commissions to Brokers

Table 1 Loan Type

Loan Type Commission Commission to Salesperson

Commercial Home Loan Motor Vehicle Personal

0.04 0.05 0.08 0.09

Using the information above, you are required to fill in the following tables based on the appropriate design of inputs, processing and outputs. INPUT

PROCESSING

OUTPUT

Loan Type The sales revenue received for that loan Loan Type Commission Table List of loans per broker Settlement Amount for each loan

Based on the loan type, Lookup the Loan Type Commission Table to determine the correct rate. Multiply the rate by the sales revenue received for that loan, If Settlement Amount for each loan >= $1M then Bonus Commission to Broker is $150 Repeat for each loan per Broker Add/Sum the Base Commission to Broker for each loan and the Bonus Commission to Broker

Base Commission to Broker for each loan

Base Commission to Broker Bonus Commission to Broker

Bonus Commission to Broker

Total Commission to Broker for each loan...