Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Business Finance homework help

lab

Shelly Cashman Excel 365/2021 | Module 3: SAM Project 1a

Raybridge Recruiting

CREATE A SALES REPORT

GETTING STARTED

Save the file
SC_EX365_2021_3a_
FirstLastName_1.xlsx
as
SC_EX365_2021_3a_
FirstLastName_2.xlsx

Edit the file name by changing “1” to “2”.

If you do not see the
.xlsx file extension, do not type it. The file extension will be added for you automatically.

With the file
SC_EX365_2021_3a_
FirstLastName_2.xlsx
open, ensure that your first and last name is displayed in cell B6 of the Documentation worksheet.

If cell B6 does not display your name, delete the file and download a new copy.

PROJECT STEPS

Lindsey Sawyer is the director of recruiting and business development for Raybridge Recruiting in Washington, D.C. She has been analyzing sales and commissions for recruiters in an Excel workbook and has asked you to help her complete the analysis.

Go to the
Sales worksheet. Rename the
Sales worksheet as
Sales and Dividends, which is a more accurate name.

Unfreeze column A so it is not displayed when you scroll horizontally.

Middle-align the contents of the merged cell A1 to improve the appearance of the worksheet title.

In cell B3, insert a formula that uses the
NOW function to display today’s date.

Fill the range C6:G10 with the formatting from the range B6:B10 to use a consistent number format for the sales data.

Lindsey wants to show the sales trend for each position and month from January to June. Provide this information as follows:

In cell H6, insert a
Line sparkline based on the data in the range B6:G6.

Use the Fill Handle to fill the range H7:H10 without formatting based on the contents of cell H6.

Change the color of the sparklines in the range H6:H10 to
Dark Purple, Text 2 (4th column, 1st row of the Theme Colors palette) to emphasize them.

Show a High Point and a Low Point in the sparklines to make those values easy to identify.

Copy the formula in cell I6 and paste it in the range I7:I10, pasting only the formula and number formatting, to include sales totals.

Lindsey wants to determine how the sales of each month contributed to the total sales. Calculate this information for her as follows:

In cell B13, insert a formula without using a function that divides the total sales for January (cell
B10) by the total sales to date (cell
I10).

Use an absolute reference to cell I10 in the formula.

Use the Fill Handle to fill the range C13:G13 with the formula in cell B13.

Lindsey also needs to calculate the dividends earned each month. If the company earns $200,000 or more in a month, the dividend is 35% of the sales. If the company earns less than $200,000 in a month, the dividend is 27% of the sales. Calculate the dividends as follows:

In cell B17, enter a formula that uses the
IF function and tests whether the total sales for January (cell
B10) is greater than or equal to
200000.

If the condition is true, multiply the total sales for January (cell
B10) by
0.35 to calculate a dividend of 35%.

If the condition is false, multiply the total sales for January (cell
B10) by
0.27 to calculate a dividend of 27%.

Use the Fill Handle to fill the range C17:G17 with the formula in cell B17 to calculate the dividends for February through June.

Change the sparklines in the range H17:H18 as follows to use a more meaningful format:

Change the Column sparklines to
Line sparklines.

Apply the sparkline style
Dark Gray, Sparkline Style Dark #3 (3rd column, 5th row of the Sparkline Styles palette) to make the sparklines easier to see.

Lindsey would like to increase the average number of placements per month. Because executive placements are the most profitable, Lindsey wants to know how many executive placements she needs to reach the goal of 30 placements per month.

Use Goal Seek to set the average number of placements for all positions (cell
I27) to the value of
30 by changing the average number of executive placements (cell
I23).

Format the text in cell J22 to clarify what it refers to as follows:

Merge and center the range J22:J27.

Rotate the text down to
-90 degrees in the merged cell so that the text reads from top to bottom.

Change the width of column J to
6.00.

Delete row 35, which contains information Lindsey does not need anymore.

Lindsey also wants to compare the estimated sales of July and December. Insert a chart that provides this information as follows:

Create a
Clustered Column chart based on the nonadjacent ranges A22:B26 and G22:G26.

Enter
Estimated Sales: July and December as the chart title.

Resize and reposition the chart so its upper-left corner is in cell A35 and its lower-right corner is in cell E49.

Change the chart layout to
Layout 2 to display the data values above the bars instead of including a vertical axis.

(Note: The value in cell B3 of the sales and dividends worksheet may differ from that shown below.)

Your workbook should look like the Final Figures on the following pages. The value in cell B3 has been intentionally blurred as it will never be constant. Save your changes, close the workbook, and then exit Excel. Follow the directions on the website to submit your completed project.

Final Figure 1: Sales and Dividends Worksheet

5aeda309-5734-44ab-9585-7a2755544745.jpeg

image9.png

image6.png

image7.png

image8.png

>Business & Finance homework help

Share This Post

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

Related Questions

ACC 5301 DB II R I

2 Management Applications of Accounting ACC 5301 DB II Reply I Your response to a classmate should be at least 250 words in length. The Importance of Financial and Managerial Accounting in Strategic Decision-Making Every successful business relies on accurate financial information to survive and thrive in a competitive marketplace.

HRM 6303 DBI R

2 Training and Development HRM 6303 Unit I DB Reply A response post to at least one other student is due by end of day Tuesday. Posts to others should be a minimum of 250 words in length. Part I My name is Larry Taylor, and I live in Delaware.

MISw2

Welcome to week two. Now that you’ve explored what makes a problem worth solving, it’s time to zoom in on who you’re solving it for and why it matters. This week’s assignment helps you define your target user, the problem they face, and the questions you’ll need to answer to

HUM 102 Module Three Short Answer

Please see attachments Module Three Short Answer Assignment Guidelines and Rubric.html HUM 102 Module Three Short Answer Assignment Guidelines and Rubric Overview Many times, as we engage with a creative work, our own biases and assumptions creep into how we interpret the work. In many cases, this has to do

IDS 104 Module Three

Please see attachments Unit Resources [Insert Unit Title]4.html Introduction These resources will help you learn how to support meaningful participation in diverse digital communities and explain how a growth mindset and feedback supports personal and professional growth. Note: You are not required to complete any quizzes or practice questions associated

Simulation 2

Instructions, case study and reading attached Please read this case study first: Case study_Turnover and Retention.pdf Your task (single post): Write one organized post that answers all four questions below using specific evidence from the case tables/exhibits. Use headings and concise analysis—not bullet lists of facts. Questions to answer: Q1.

reading note 9

Instructions and readings attached For section #1(Key Quote) and #3 (Prediction or Action Step) please use week 9 reading (Turnover and Retention.pdf) For section #2 Comparative Insight (7 points) I also attached week 8 reading (Internal Recruitment-1.pdf)

ACC 5301 DB II

2 Management Applications of Accounting ACC 5301 DB II Post 1: Initial post addressing the discussion board topic is due by the end of day on Saturday. • Your initial post should be at least 300 words in length. • Your initial post should include at least one APA-formatted scholarly, professional, or

HRM 6303 DB I

2 Training and Development HRM 6303 Unit I DB How has the COVID-19 pandemic impacted training and development within organizations in the past few years? How have you have seen it change at your current place of employment? Initial post to be a minimum of 500 words in length and

Business Finance – Operations Management WEEK 2 ASSIGNMENT OP

Assignment 1: Topic Paper/Peer Reviewed Journal Article review instructions: 1. Download a copy of the Sample Article Review. sampleartreview1 (1).pdf 2. Using the exact Sample Article Review format, write a review on 3 articles relating to your final research topic. Use the Library database or http://scholar.google.com to find the 3 peer reviewed journal

Presentation to Staff on Hangar Renovation Project Progress

Your supervisor has asked you to give a 15-min formal presentation during weekly staff meetings about (this week’s material). What will you share? How will you teach it? Put together a short slide deck outlining the topics you’d cover and how you would present them. Feel free to use

Legal Environment of Business

This is Jamaican/ British/TCI law. Kindly use cases and materials that refer to our law jurisdictions. Additionally, when reference material is used, it is often from the Caribbean and the US region. Ensure cases are real and not fictional. The professor gave instructions that when answering questions, we should ensure

D2

Procurement Management Plan Instructions This week, you are required to produce your project Procurement Strategy deliverable. Your Procurement Strategy will define how procurements will be planned, executed, and managed throughout the life of the project. The Procurement Strategy is prepared during the planning process phase of your project. The proposed

Audit- Internal controls

Materials posted. Need it by November 4th, 8:00 p.m. EST. N.B. Try to reference more US/Caribbean as that is more in my region.. but i belive the powerpoints notes and the book may suffice.

Assistance with Player Management Simulation

Player Management Simulation Assistance Player Management Player Management Sequence 1. Read Concept Overview 2. Take the Quiz 3. Review Case Briefing Document 4. Complete Learning Phase in Simulator 5. Complete Challenge Phase in Simulator Player Management Concept Overview – Table of Contents • The Key To Fielding A Winning Team

orientation

MGT 561 – Test 3 Essay Answers should be cited and referenced. You can do the references for all three at the end of all the essays or you can reference each one. The Answer should be 2-3 pages and double spaced. Be thorough in your answer. This work is

All Carpet Cleaner

How Often Should You Get Your Carpets Cleaned? Many people wait until their carpets look visibly dirty before cleaning them, but by that time, a lot of hidden dirt and allergens have already accumulated. The frequency of all carpet cleaning depends on a few key factors, including how much foot traffic

FEG Plus With Free Derma Roller Price in Lahore

Why Choose FEG Plus with Free Derma Roller? When you purchase FEG Plus, you not only get the powerful lash and brow serum but also a complimentary Derma Roller. The Derma Roller helps to enhance the absorption of the serum, allowing it to penetrate more deeply into the skin for