Ms. Chavez has asked you to make a spreadsheet for three of the top Realtors for the past month. In the spreadsheet, she would like to be able to see the total sales by city and by realtor as well as the income to the Realtor and to Move NOW! at 4% each commission on each selling price. Sales are as follows:
Murray - Sold 8 houses in the cities shown at the prices below:
- Denver - 105,000
- Brighton - 352,000
- Louisville - 647,000
- Aurora - 529,000
- Lakewood - 272,000
- Lafayette - 785,000
- Lone Tree - 674,000
- Broomfield - 426,000
Guled - Sold 4 houses at the following prices:
- Lousiville - 738,000
- Broomfield - 123,800
- Aurora - 342,000
- Thornton - 569,000
Jones - Sold 5 houses at the following prices:
- Aurora - 1,782,072
- Denver - 922,000
- Broomfield - 728,200
- Lakewood - 255,000
- Thornton - 499,000
Instructions
Make a Spreadsheet:
The layout for your spreadsheet needs to have the ability to calculate:
- Total sales for each Realtor
- Total sales per city in the Metro area
- Average Sale per city
- Average Sale per Realtor
- Total Commission per Realtor
- Total Commission for Move NOW!
- Average Commission per Realtor
To complete the calculations based on commissions, enter the commission percentage (4%) one time on your spreadsheet, and use an Absolute Reference to calculate each individual commission amount. Do not make new formula for each cell for those calculations.
Format:
Use the formatting techniques learned in this Module, and include the following at a minimum:
- Borders and Shading
- Merged Cells
- Use proper cell format for each cell based on the information in the cell
- Include the company Logo (from Module 2) on the Spreadsheet
Chart: Create two Charts and place them in a New Worksheet
- One Chart for total sales by Realtor
- One Chart for total sales by City
- Use the Chart Format of your choice