Reference no: EM132387552

CPT 174 Nesting Skills Worksheet Assignment -

Instructions: Using a single Excel worksheet, set up appropriate solutions for the problems specified below. You should use appropriate labels to identify the data and results, and choose formatting appropriate to the type of data involved (all financial quantities and all percentages should be expressed to two decimal places). Each problem will require the use of appropriate formula(s) and/or function(s), which you will need to identify and incorporate into your solution. For the first problem a sample layout is included as an example of how to design the solutions to the problems. Make sure each problem is clearly identified with the problem number. Submit your workbook to the appropriate D2L folder in a compressed (i.e. "zipped") folder with the name Nesting Skill Worksheet. Submissions that are not correctly named, or not in a compressed folder, will not be graded.

Commission -

If a realtor's monthly sales are less than $150,000, their commission is 5%.

If a realtor's monthly sales are between $150,000 and $750,000, their commission is 10%.

If a realtor's monthly sales are more than $750,000 but less than $1,200,000, their commission is 15%.

If a realtor's monthly sales are $1,200,000 or more, their commission is 18.5%.

Monthly Sales Information -

Using the commission information, re-write the commission requirements using valid Excel mathematical symbols. The first one is done for you.

If a realtor's monthly sales are less than $150,000, their commission is 5%.

If monthly-sales < 150000, commission = monthly-sales * 5%

If a realtor's monthly sales are between $150,000 and $750,000, their commission is 10%.

If a realtor's monthly sales are more than $750,000 but less than $1,200,000, their commission is 15%.

If a realtor's monthly sales are $1,200,000 or more, their commission is 18.5%.

Using the information above, determine the commission amount earned by each realtor. (Hint: commission equals the sales amount * commission rate)

Audrey:

Faris:

Charlie:

Joan:

Vacation Days -

Vacation days are based on status. Using the information in the lower table below, create a nested-IF that will use the information in the upper table to determine the amount of vacation time earned by each employee.