You may change the formatting (font size, location in cell, spelling, etc.) as necessary. Add rows and/or
Fantastic news! We've Found the answer you've been seeking!
Question:
- You may change the formatting (font size, location in cell, spelling, etc.) as necessary. Add rows and/or columns as necessary.
- Type in the number of sales for each week (makeup numbers…these are your inputs). Use a variety of numbers.
- Add a column after Week 4 to calculate total monthly sales for each employee. Use the appropriate function.
- Add a column with the 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).
- Create additional columns as instructed in the steps below. Any assumptions required should be placed on a new worksheet and that worksheet should be the second sheet in your workbook.
- Add a column to automatically calculate the monthly commission earned for each employee (sales * commission rate = monthly commission in dollars).
- 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).
- Add a column for agency fees for each employee of $200 per month. (This number may change in the future).
- Add a column for Monthly Earnings for each employee (commission earned + bonus – agency fee).
- 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.
- Format cells appropriately.
- Format the worksheets so they are as professional, attractive, readable, and user-friendly as possible. Follow the formatting rules and design rules we discussed in class.
- Make sure the completed sales worksheet prints to one page in landscape orientation.
Related Book For
Probability and Statistics
ISBN: 978-0321500465
4th edition
Authors: Morris H. DeGroot, Mark J. Schervish
Posted Date: