1. Use the layout provided in the starter file. You may change the formatting (font size, location in cell, spelling, etc.) as necessary. Add rows and/or columns as necessary.
2. Type in the amount of sales for each week (make up numbersthese are your inputs). Use a variety of numbers.
3. Add a column after Week 4 to calculate total monthly sales for each employee. Use the appropriate function.
4. Add a column with commission rate (percent) for each employee. Use a different commission percent for each employee. (This is another input column but does not have to be assumptions).
5. Create additional columns as instructed in steps below. Any assumptions required should be placed on a new worksheet and that worksheet should be the second sheet in your workbook.
6. Add a column to automatically calculate the monthly commission earned for each employee (sales * commission rate = monthly commission in dollars).
7. Add a column for bonus calculation for each employee. If monthly sales are $25,000 or less, bonus is 6% of their monthly sales, otherwise bonus is 12% of their monthly sales. (The cutoff and percentages may change in the future).
8. Add a column for agency fees for each employee of $200 per month. (This number may change in the future).
9. Add a column for Monthly Earnings for each employee (commission earned + bonus agency fee).
10. Add three rows at the bottom for the total, average and maximum (based on the information for the four employees) of each of the columns. Use the proper functions.
11. Format cells appropriately.
12. Format the worksheets so they are professional, attractive, readable, and user friendly as possible. Follow the formatting rules and design rules we discussed in class.
13. Make sure the completed sales worksheet prints to one page in landscape orientation.

E F 3 A B 1 2 3 4 Salesperson Summary 5 Month of: 6 Name Week 1 7 Carter, Michelle 8 Johnson, Micah 9 Peters, Jonah 10 Thornsby, Lauren 11 12 Week 2 Week 3 Week 4 N