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

faith

Bible BUSI 606 FAITH AND LEARNING ASSIGNMENT INSTRUCTIONS For this assignment, you will write an essay with a minimum of 500 words where you will integrate the Bible into one of the topics related to global financial markets covered in this course. You will briefly describe how the Bible is

int9

Financial Management of Multinational Firm BUSI 606 Discussion Assignment Instructions The Discussions allow you the opportunity to apply what you have learned from the Module: Week’s readings. There are 2 parts to each Discussion: thread and replies. Both parts must be posted and written in a substantive manner, without

ACC 5301 V DB R2

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

Deliverable 04 – Relationship Management Document

Scenario Recall a time when you were involved with a conflict in the workplace or witnessed a conflict at work. This situation should be one that involves a relationship of some kind (i.e. manager-employee, employee-employee, etc.) where a conflict occurred. Think about how this experience could have been improved

Deliverable 03 – Self-Management Plan

Scenario As such, you need to consider how to manage yourself before you can really manage others. You need to think about what your personal and professional stress levels are–what might be the breaking points between succeeding and failing? How can I manage that stress? What emotions come to

D6

Introduction You will analyze the Modeling the Causes and Mitigation Measures for Cost Overruns in Building Construction: The Case of Higher Education Projects case study by Alhammadi, Y., Al-Mohammad, M., & Rahman, R. A. (2024) and cover the pertinent facts of the case in the context of the respective project management

Business Finance – Operations Management MBA 510 Week Two Assignment 4. Create slides showing your company’s operation’s tech stack. 9-10 SLIDES

Assignment 4: Slide Deck: Analyze Technology Systems Top of Form Length: 9-10 slides. Instructions Choose a company you know or create one for this assignment. Create slides showing your company’s operation’s tech stack. · On the title slide, write the name of the company, the industry, and its business model. ·

MBA510 Week TWO Discussion Post 1. Please answer the discussion post in 250 min

Instructions · Choose a company that had a disruptive business model (e.g., Netflix, Uber, Amazon…), either existing today or in the past. · Describe its model and how it disrupted its industry. Length: 250-400 words Contributions must display original thinking and good knowledge of the subject matter, including links and references

MBA510 Week TWO Discussion Post 2. Please answer the discussion post in 250 min

Instructions · How might a company’s technology systems change by utilizing AI? Length: 250-400 words Contributions must display original thinking and good knowledge of the subject matter, including links and references to sources to support your arguments. Additionally, make sure you cite sources you reference in-text and under a “References” section

Business Finance – Management Management Assignment For Supply Chain Modeling And Analysis Needs To Be Completed By Wednesday, 3 December, At 3 pm.

This assignment involves Demand Forecasting. The attachment includes all of the information for it including the questions that need to be answered. Please let me know if you need to use a book to better understand how to complete the questions.

6-2 Activity: Expert Evaluator Activity IDS 104

SEE ATTACHMENT Module Six Expert Evaluator Activity Guidelines and Rubric.html IDS 104 Module Six Expert Evaluator Activity Guidelines and Rubric Overview In today’s fast-paced digital world, we are constantly bombarded with information from a variety of sources such as news sites, blogs, social media platforms, podcasts, and more. Not all

Module 6 Expert Evaluator Activity IDS 104

Module Short Answer: Creative Work Analysis

See attachments Module Six Short Answer Assignment Guidelines and Rubric.html HUM 102 Module Six Short Answer Assignment Guidelines and Rubric Overview Understanding diverse perspectives is beneficial in further understanding the humanities. Diverse perspectives are viewpoints that are influenced by a person’s or group’s background and identity as well as sociocultural

Evaluating a Public Healthcare Leader’s Style

Pick a public leader that responded to the Covid-19 crisis and discuss what leadership style or characteristics they demonstrated. Was their behavior consistent with your expectations for a leader in that position? Why or why not? Be sure to respond to at least TWO of your classmates’ posts.

HRM 6303 V DB 2

2 Training and Development HRM 6303 Unit V DB Reply 2 A Response post to be a minimum of 250 words in length and at least one supporting reference. Top of Form A culture creates context for behavior by providing reinforcements and punishments for each discrete behavior. Recognizing this helps

HRM 6303 V DB 1

2 Training and Development HRM 6303 Unit V DB Reply 1 A Response post to be a minimum of 250 words in length and at least one supporting reference. Top of Form In learning, the best way for me is to study the material voraciously. The more difficult the better

ACC 5301 VIII

2 Management Applications of Accounting ACC 5301 Unit VIII Journal This journal measures your mastery of ULOs 2.8, 2.9, and 4.2. ABC Corporation has 3 plants across the United States in 3 different regions consisting of East, Central, and West. Last year, each plant purchased new equipment for their plants,

Business, Govt & Society

Please prepare slide for representatives, include the superintendent for the school district, their headshot, and qualifications on Santa Clara county San Francisco