company employs five salespeople.  Input values for each salesperson are name, number, gender, and total units sold for the month, for each product (one and two).  The salary of each salesperson is strictly commission-based. Each salesperson earns a basic commission calculated as 12.5% of his/her total sales.  If a salesperson sells more than R1 000 of product two, he or she receives an additional 10% commission on product two. If not, commission for sales of product two is reduced to 5% (i.e. instead of receiving the basic 12.5% commission for sales of product two, a penalty is paid).  If a saleswoman sells more than R500 of product one, she receives a bonus of R100.  An added bonus of R750 is gi

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter6: Managing Multiple Worksheets And Workbooks
Section: Chapter Questions
Problem 4.4CP
icon
Related questions
Question

A company sales manager requires a sales analysis of the two products on offer at
the end of the month.
 The company employs five salespeople.
 Input values for each salesperson are name, number, gender, and total units sold for
the month, for each product (one and two).
 The salary of each salesperson is strictly commission-based. Each salesperson
earns a basic commission calculated as 12.5% of his/her total sales.
 If a salesperson sells more than R1 000 of product two, he or she receives an
additional 10% commission on product two. If not, commission for sales of product
two is reduced to 5% (i.e. instead of receiving the basic 12.5% commission for sales
of product two, a penalty is paid).
 If a saleswoman sells more than R500 of product one, she receives a bonus of R100.
 An added bonus of R750 is given to each salesperson whose total commission is
more than R6 000.
 Each employee receives a printed pay-slip showing all the employee details, gross
pay, all the deductions and/or additions, and the net pay.
 The unit prices for the two products are as follows:
O Product 1: R250
O Product 2: R175
At the end of processing, the manager wants to know:
 The total number of items sold.
 The total number of women and the total number of men that received a bonus.
 The number of women employed by the company.
 Total salary paid out (i.e. total net pay)

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Probability Problems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Operations Research : Applications and Algorithms
Operations Research : Applications and Algorithms
Computer Science
ISBN:
9780534380588
Author:
Wayne L. Winston
Publisher:
Brooks Cole
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L