Chapter 3, Problem 1.8CP

A company sales manager requires a sales analysis of the two products on offer atthe end of the month. The company employs five salespeople. Input values for each salesperson are name, number, gender, and total units sold forthe month, for each product (one and two). The salary of each salesperson is strictly commission-based. Each salespersonearns 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 anadditional 10% commission on product two. If not, commission for sales of producttwo is reduced to 5% (i.e. instead of receiving the basic 12.5% commission for salesof 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 ismore than R6 000. Each employee receives a printed pay-slip showing all the employee details, grosspay, all the deductions and/or additions,…

Ss.227. In cell D5, construct a formula to calculate the % of Total Projected Investments for Pooled Investments by dividing the Projected Investments for Next Fiscal Year for Pooled Investments by the Total Projected Investments for Next Fiscal Year. Use absolute cell references as necessary, format the result in Percent Style, and Center the percentage. Fill the formula down through cell D9.

The following shows a training company’s workshops, the number of days of each, and their registration fees. Workshop # of Days Registration FeeHandling Stress 3 $ 1,000Time Management 2 $ 800Supervision Skills 3 $ 1,200Negotiation 6 $ 1,500Interview Skills 1 $ 300The training company conducts its workplace in the six locations shown in the following table. The table also shows the lodging fees per day at each location. Location Lodging Fees per DayAustin $ 151Chicago $ 225Dallas $ 179Orlando $ 322Phoenix $ 175Raleigh $ 165When a customer registers for a workshop, he or she must pay the registration fee plus the lodging fees for the selected location. For example, here are the charges to attend the Supervision Skills workshop in Orlando. Registration: $1,200Lodging: $322 * 3 days = $966Total: $2,166Create an application that lets the user input a workshop and location from the lists. The application should display the workshop and lodging prices, calculate and display the registration…

In cell C16, create a formula that adds 1 to the growth rate (cell C14) and multiplies the result by the estimated profit from 2021 (cell C15). Use an absolute row reference to cell C14.