Documentation Shelly Cashman Excel 2019 | Module 3: SAM Project 1a Raybridge Recruiting CREATE A SALES REPORT Author:David Bossio Note: Do not edit this sheet. If your name does not appear in cell...

1 answer below »
excell spreadsheet i dont know how to do shit on it


Documentation Shelly Cashman Excel 2019 | Module 3: SAM Project 1a Raybridge Recruiting CREATE A SALES REPORT Author:David Bossio 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 TypeJanuaryFebruaryMarchAprilMayJuneTrendTotal Executives$ 98,348.5089532.981522.6775279.2691610.2497352.68$ 533,646.25 Managers$ 74,474.3565742.1256330.6952540.5868080.6778107.76 Professionals$ 31,330.2129667.7428884.4827274.0927281.9630099.43 Interim$ 18,307.5215002.2615721.80654186912382.120009.2221272.37 Total$ 222,460.58199945.02182459.646541869167476.03206982.09226832.24 Percentage per Month Share Commissions Paid Monthly CommissionJanuaryFebruaryMarchAprilMayJuneTrendTotal Amount$ - 0 Net Amount$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0 Net Commission % (After Deductions)62% Estimated Sales Position TypeJulyAugustSeptemberOctoberNovemberDecemberTotalAvg. PlacementsEstimates 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,50043 Professionals$ 31,000$ 29,000$ 30,000$ 31,000$ 33,000$ 30,000$ 184,00020 Interim$ 22,000$ 15,000$ 16,000$ 18,000$ 19,500$ 19,000$ 109,50022 Total$ 229,500$ 198,000$ 206,000$ 213,000$ 220,500$ 211,500$ 1,278,50028 Estimated Commissions Monthly CommissionJulyAugustSeptemberOctoberNovemberDecemberTrendTotal 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 Commission % (After Deductions)62% Net commissions = 35% + 27%
Answered Same DayMar 29, 2021

Answer To: Documentation Shelly Cashman Excel 2019 | Module 3: SAM Project 1a Raybridge Recruiting CREATE A...

Kshitij answered on Mar 30 2021
122 Votes
Documentation
        Shelly Cashman Excel 2019 | Module 3: SAM Project 1a
        Raybridge Recruiting
        CRE
ATE A SALES REPORT
    Author:    David Bossio
    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 and Commissions
    Raybridge Recruiting
    Sales Report
    Last updated:    3/30/20
    Monthly Sales
    Position Type    January    February    March    April    May    June    Trend    Total
    Executives    $ 98,348.50    $ 89,532.90    $ 81,522.67    $ 75,279.26    $ 91,610.24    $ 97,352.68        $ 533,646.25
    Managers    $ 74,474.35    $ 65,742.12    $ 56,330.69    $ 52,540.58    $ 68,080.67    $ 78,107.76        $ 395,276.17
    Professionals    $ 31,330.21    $ 29,667.74    $ 28,884.48    $ 27,274.09    $ 27,281.96    $ ...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here