Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

lab

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

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

2

Diaz Marketing

COMPLETE A BUDGET SUMMARY WORKSHEET

GETTING STARTED

Save the file
SC_EX365_2021_1b_
FirstLastName_1.xlsx
as
SC_EX365_2021_1b_
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_1b_
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

Ashley Bowman manages the New England office for Diaz Marketing, a consulting firm that develops strategies for businesses to become more profitable. She has created a worksheet summarizing the revenue and expenses for the first six months of the year, and asks for your help in determining what the New England office needs to do in the rest of the year to meet its profit goals.

Go to the
Budget worksheet. Cut the worksheet subtitle from cell B1 and paste it in cell A2 to display the subtitle in its expected location.

In cell H2, add the text
consultants so that the complete text appears as “Number of consultants” and more clearly identifies the value in cell J2.

Enter
Feb in cell C3,
Mar in cell D3,
Apr in cell E3,
May in cell F3, and
Jun in cell G3.

In cell J4, enter a formula that subtracts the value in cell
I4 from the value in cell
H4 to determine how much revenue the New England office needs to earn from July to December to reach its goal for the year.

Ashley wants to calculate the gross margin from January to June and for the year to date. Provide this information as follows:

In cell B6, enter a formula that divides the value in cell
B5 (the gross profit for January) by the value in cell
B4 (the revenue in January).

Use the Fill Handle to fill the range C6:H6 with the formula in cell B6 to find the gross margin for February to June and for the year to date.

Ashley needs to sum the sales for each New England state for the year to date. Provide this information as follows:

In cell H9, enter a formula that uses the
SUM function to total the range
B9:G9 to calculate the year-to-date sales for Connecticut.

Use the Fill Handle to fill the range H10:H12 with the formula in cell H9 to find the year-to-date sales for the other states.

In cell B17, enter
27,363 as the general expenses for January.

Ashley wants to determine how much revenue each state needs to generate from July to December to reach its target for the year. Enter this information as follows:

In cell J9, enter a formula that subtracts the value in cell
I9 from the value in cell
H9 to find the amount of Connecticut sales Ashley needs to meet the goal.

Copy the formula in cell J9, and then paste it in the range J10:J14, pasting the formulas only, to find the differences for the other states, the total, and the revenue per consultant.

Ashley is interested in how much revenue the nine consultants each generate on average per month and for the year to date. Find this information as follows:

Edit cell B14 to include a formula that divides the value in cell
B13 (the total sales for Connecticut in January) by the value in cell
J2 (the number of consultants). Don’t change the reference to cell J2 that is already there.

Fill the range C14:H14 with the formula in cell B14 to determine the average revenue per consultant from February to June and for the year to date.

Ashley also needs to calculate the operating margin, which is the ratio of operating profit or loss to revenue and indicates how much the office makes after paying for expenses. Calculate the operating margin as follows:

In cell B19, enter a formula that divides the value in cell
B18 (the operating profit or loss in January) by the value in cell
B4 (the revenue in January).

Use the Fill Handle to fill the range C19:H19 with the formula in cell B19 to find the operating margin for February to June and for the year to date.

Ashley wants to visualize the total year to date sales separated into states. Insert a chart to provide this visualization as follows:

Create a
2-D Pie Chart based on the nonadjacent ranges
A8:A12 and
H8:H12.

Enter
Total Year to Date Sales by State as the chart title.

Reposition and resize the chart so its upper-left corner is in cell K3 and its bottom-right corner is in cell M17

Apply
Style 11 to the chart.

Hide the gridlines for the
Budget worksheet to make it easier to read.

Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the website to submit your completed project.

Final Figure 1: Budget Worksheet

a062c1e0-146e-4cdb-b62e-6c2270387395.jpeg

image9.png

image6.png

image7.png

image8.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

D 8 of 485

Follow the attached instructions to complete this work.   Strategies for Addressing Global Threats You will start by writing a short paper as described in the discussion question. You will be using information from this week’s readings and from your own research to address the information needs expressed in the

D 7 of 485

Follow the attached instructions to complete this work. Leadership Update: Cyber Crime   You will start by writing a short paper as described in the discussion question. You will be using information from this week’s readings and from your own research to address the information needs expressed in the question.

D 8 of 413

 Follow the attach instructions to complete this work. Budgeting for Cybersecurity   You will start by writing a short paper as described in the discussion question. You will be using information from this week’s readings and from your own research to address the information needs expressed in the question. Create an

Computer Science written assignment 3

Written Essay Assignment 3-1: · Identify common risks, threats, and vulnerabilities found in the LAN-to-WAN Domain that require proper security controls for mitigation · Identify network and security policies needed to properly secure the LAN-to-WAN portion of the network infrastructure · Write a 2-3 page APA-formatted essay that identifies network

project 3 of 485

Follow the attach instructions to complete the work. Make sure it aligns with the Rubric Project #3: Presentation for Board of Directors Your Task: Padgett-Beale’s Chief Information Security Officer (CISO) has tasked you to continue supporting the Merger & Acquisition team’s efforts to bring Island Banking Services’ security program into

project 2 of 485

Fellow the attach instructions to complete this work. Make sure it aligns with the Rubric Project #2: Cybersecurity Implementation Plan Your Task: The Acquisition of Island Banking Services has moved from the strategy development phase to the integration phase. In this phase, the M&A team will develop transition and implementation

PROJECT 1 of 485

Fellow the attach instructions to complete this work. Make sure it aligns with the rubric Project #1: Cybersecurity Strategy & Plan of Action Your Task: You have been assigned to support the Padgett-Beale Merger & Acquisition (M&A) team working under the direct supervision of Padgett-Beale’s Chief Information Security Officer (CISO).

proj3-Final

Project 3: Cloud Portfolio Report  Step 1: Review BallotOnline’s Cloud Services Offerings  You’ve now had a lot of experience working on many aspects of the cloud at BallotOnline, and you will take a look at what you’ve done in the past. In this step, you will write up how you

AWS Simple Monthly Calculator

Discussion: AWS Simple Monthly Calculator Contains unread posts Now that you have discussed BallotOnline’s cloud services offerings, you will discuss the AWS Simple Monthly Calculator. You should cover the following areas: · What are some of the general use cases that are covered? · What are the requirements to use

D 5 0F 485

Follow the attach instructions to complete this work. Assessing Maturity for Cybersecurity Program Before you begin read:  Our class focuses on integrating many different aspects of cybersecurity, information security, and information assurance.  Recent developments in the field of cybersecurity have resulted in a number of “maturity models” which can be

Discussion 4 of 413

Follow the attach instructions to complete the work Data Breach Reporting Policy Review the Red Clay Renovations company profile and the weekly readings. Provide specific information about “the company” in your response. Due to changes in state and federal laws, Red Clay leadership decided the CISO will be the sole

discussion 4 of 485

Follow the attach instructions to complete this work. Cultural Differences as Barriers to Success The Merger & Acquisition team hired a team of external consultants to assist with identification of cultural issues which could result in barriers to the successful acquisition of Island Banking Services by Padgett-Beale. The consultants conducted

project 3 of 413

Follow the attached instructions to complete this work Download the attached detailed assignment description for this project. You should also review the rubric shown below for additional information about the requirements for the project and how your work will be graded. Please make sure that you use both the assignment description file

Project 2 of 413

Follow the attach instructions to complete this work. Make sure it aligns with the rubric Project #2: Manager’s Deskbook Company Background & Operating Environment Red Clay Renovations is an internationally recognized, awarding winning firm that specializes in the renovation and rehabilitation of residential buildings and dwellings. The company specializes in

Project 1 of 413

Follow the attach instructions to complete this work. Make sure it aligns with rubric Project #1: Employee Handbook Company Background & Operating Environment Red Clay Renovations is an internationally recognized, awarding winning firm that specializes in the renovation and rehabilitation of residential buildings and dwellings. The company specializes in updating

Discussion and Replies

Please see attachment for instructions     Discussion   In 250 words total, answer the questions below with 4 evidence base scholarly articles. APA format. 1. Discuss some of the common issues with implementation of security policy. 2. What are some possible mitigations to ensure policy can be enforced. Replies

revision x 10

I need someone to follow all of the instructions that is provided for revision that can be done no later than tomorrow, do not request bid if this price is not enough or if you cannot fulfill the requirements this is a time sensitive manner I cannot wait 3-4 days