55
S
ales are the lifeline of all businesses, and employers frequently off er
compensati on programs to their employees that include sales incenti ves to
moti vate them to sell more products and services. An increase in sales results
in increased profi ts for the business and increased compensati on for the
employees.
The sales incenti ve programs of most businesses consist of cash commissions.
Some businesses may also off er bonus plans, merchandise, prizes, profi t
sharing, or other rewards.
The following acti vity illustrates how a spreadsheet can be used to compute
the commissions earned by employees of the Shear Magic Beauty Salon and
Day Spa for additi onal sales of beauty products to clients and how to add the
commission for those sales to their base salaries.
1. None. This
acti vity provides
additi onal
reinforcement in
using many of the
skills introduced
in previous
acti viti es.
1. Create a NEW spreadsheet.
Unless otherwise stated, the font should be 10 point Arial.
2. Format row 9 to wrap the text within each cell.
3. Type the data as shown.
4. Format the width of column A to 11.0 and left align.
5. Format the width of columns B and C to 14.0 and left align.
6. Format the width of columns D G to 13.0 and right align.
7. Format cells D11 G45 as numbers displaying 2 decimal places with a comma
separator.
8. Bold cell A2 and change the font size to 16 point.
9. Bold rows 7 9.
10. Compute the formulas for the fi rst employee as follows:
a. COMMISSION=6%*SALES > In cell F11, type
=6%*E11
b. TOTAL SALARY=BASE SALARY+6% COMMISSION > In cell G11, type
=D11+F11
11. Use the AutoFill feature to copy the formulas down for the 6% COMMISSION
and TOTAL SALARY columns for the remaining employees.
12. Enter formulas to calculate the Totals, Average, Maximum, and Minimum for
columns D G.
13. Bold rows 42 45.
14. Display formulas in your spreadsheet by using <CTRL> + ` to check for accuracy.
25
Sales Report
ACTIVITY
For Evaluation Purposes Only