who can complete homework assignment by 4pm today excel module 3
Documentation
| Shelly Cashman Excel 2019 | Module 3: SAM Project 1a | |
| Raybridge Recruiting | |
| CREATE A SALES REPORT | |
| Author: | Theresa Cobb |
| Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
Sales
| Raybridge Recruiting | |||||||||
| Sales Report | |||||||||
| Last updated: | |||||||||
| Monthly Sales | |||||||||
| Position Type | January | February | March | April | May | June | Trend | Total | |
| Executives | $ 98,348.50 | 89532.9 | 81522.67 | 75279.26 | 91610.24 | 97352.68 | $ 533,646.25 | ||
| Managers | $ 74,474.35 | 65742.12 | 56330.69 | 52540.58 | 68080.67 | 78107.76 | |||
| Professionals | $ 31,330.21 | 29667.74 | 28884.48 | 27274.09 | 27281.96 | 30099.43 | |||
| Interim | $ 18,307.52 | 15002.26 | 15721.806541869 | 12382.1 | 20009.22 | 21272.37 | |||
| Total | $ 222,460.58 | 199945.02 | 182459.646541869 | 167476.03 | 206982.09 | 226832.24 | |||
| Percentage per Month | |||||||||
| Share | |||||||||
| Dividends Paid | |||||||||
| Monthly Dividend | January | February | March | April | May | June | Trend | Total | |
| Amount | $ – 0 | ||||||||
| Net Amount | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | $ – 0 | ||
| Net Dividend % (After Deductions) | 62% | ||||||||
| Estimated Sales | |||||||||
| Position Type | July | August | September | October | November | December | Total | Avg. Placements | Estimates only |
| Executives | $ 98,000 | $ 89,000 | $ 90,000 | $ 92,000 | $ 94,000 | $ 91,500 | $ 554,500 | ||
| Managers | $ 78,500 | $ 65,000 | $ 70,000 | $ 72,000 | $ 74,000 | $ 71,000 | $ 430,500 | 43 | |
| Professionals | $ 31,000 | $ 29,000 | $ 30,000 | $ 31,000 | $ 33,000 | $ 30,000 | $ 184,000 | 20 | |
| Interim | $ 22,000 | $ 15,000 | $ 16,000 | $ 18,000 | $ 19,500 | $ 19,000 | $ 109,500 | 22 | |
| Total | $ 229,500 | $ 198,000 | $ 206,000 | $ 213,000 | $ 220,500 | $ 211,500 | $ 1,278,500 | 28 | |
| Estimated Dividends | |||||||||
| Monthly Dividend | July | August | September | October | November | December | Trend | Total | |
| Amount | $ 8,032.50 | $ 5,346.00 | $ 7,210.00 | $ 7,455.00 | $ 7,717.50 | $ 7,402.50 | $ 43,163.50 | ||
| Net Amount | $ 4,980.15 | $ 3,314.52 | $ 4,470.20 | $ 4,622.10 | $ 4,784.85 | $ 4,589.55 | $ 26,761.37 | ||
| Net Dividend % (After Deductions) | 62% | ||||||||
| Net dividends = 35% + 27% | |||||||||
