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

i need someone to do this homework for me  Technische Informatik 1 Wintersemester 2024/2025 Übungsblatt 9 Bitte Beachten! Diese Hausübung ist

i need someone to do this homework for me  Technische Informatik 1 Wintersemester 2024/2025 Übungsblatt 9 Bitte Beachten! Diese Hausübung ist eine Zulassungsvorraussetzung für die Klausur. Bitte laden sie ihre Lösung entsprechend der Aufgabenbeschreibung in Moodle über den dazu vorgesehenen Punkt bis zum 08.01.25 23:59Uhr auf Moodle hoch. Übung 9

Follow the attach instructions to complete this work. Analyzing a Business Function – Project Management   Must post first. Subscribe Nofsinger

Follow the attach instructions to complete this work. Analyzing a Business Function – Project Management   Must post first. Subscribe Nofsinger Consulting Services uses Project Management techniques to manage client engagements. One of the primary responsibilities of the engagement project managers is ensuring that the advisory services and associated written