who can complete homework  assignment  by 4pm today  excel module 3Documentation 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 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
Dividends Paid
Monthly DividendJanuaryFebruaryMarchAprilMayJuneTrendTotal
Amount$ – 0
Net Amount$ – 0$ – 0$ – 0$ – 0$ – 0$ – 0$ – 0
Net Dividend % (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 Dividends
Monthly DividendJulyAugustSeptemberOctoberNovemberDecemberTrendTotal
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

System Analysis and Design Assignment 13,1 – Data Management

System Analysis and Design Assignment 13,1 – Data Management This is a required assignment, worth 20 points, and must be submitted by the due date. Review the Grading Rubric before completing this assignment. Research a scholarly paper on the impact of “Emerging Technologies on SAD” and reflect on only one

Capstone 2408906454Design and Analysis of a Simple Computer SystemObjective:

Capstone 2408906454 Design and Analysis of a Simple Computer System Objective: Students will design, simulate, and analyze the architecture of a simplified computer system, applying concepts from Stephen D. Burd’s materials such as the CPU, memory hierarchy, I/O, and instruction set architecture (ISA). Components: 1. System Design: . CPU Design: