who can complete homework  assignment  by 4pm today  excel module 3 Documentation Shelly Cashman Excel 2019 | Module

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%

image1.png

image2.png

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions