Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Financial Management Expert

Resources:

Microsoft® Office Help and Training

Other tutorials available online

Video: "Excel 2016 Essential Training"

Read the following business scenario:

Your company has asked you to create a spreadsheet to analyze the following data. The data will be reviewed for top salespeople bonuses and commissions payments based on individual sales. Averages will be used to analyze month-over-month sales throughout the years.

Use the Sales Analysis Microsoft® Excel® spreadsheet and apply formatting to accomplish the following:

Calculate total sales using the SUM function.

Calculate total sales for each quarter. (March, June, and September each represent a quarter.). A quarter is three months.

Calculate average sales for each quarter to help determine 4th-quarter potential sales.

Highlight the top salesperson in each quarter.

Generate a Microsoft® Excel® chart or graph that displays the total sales by region to identify the highest and lowest selling regions. This chart should display the TOTAL sales (i.e., the sales for the complete year), per region.

These "Total Sales" must include the fourth quarter as well, which you forecast as indicated above.

Financial Management, Finance

  • Category:- Financial Management
  • Reference No.:- M93045515

Have any Question?


Related Questions in Financial Management

Assignmentimagine you are the owner of a small business in

Assignment Imagine you are the owner of a small business in your hometown. Briefly describe your company in 3 to 5 sentences. Discuss the following in 525 to 700 words: Define the roles you play as a small business owner ...

Company overviewintroductory paragraph summarize the

Company Overview Introductory paragraph. Summarize the section in 1 - 2 paragraphs including the history, current market, and the overall image of the organization. History Current Market Include a brief 2 - 3 paragraph ...

Discussionbull profits and risks of off-balance-sheet

Discussion • Profits and Risks of Off-Balance-Sheet Activities • The difference between spot and forward exchange rates. What role do currency swaps play? • The Federal Open Market Committee • Multiple Deposit Creation a ...

In a minimum of two pages not counting the title and

In a minimum of two pages (not counting the title and reference pages), address how you would respond to the following points: Do you believe Carl is aware that he is a follower as well as the first shift supervisor? If ...

Capital structure and tax shields go to yahoo finances

"Capital Structure and Tax Shields" Go to Yahoo! Finance's Website, and select a publicly traded company which interests you. Determine the company's symbol (i.e., Apple = APPL) and navigate to the "SEC Filings" link on ...

This week you are to research the issue of healthcare

This Week, you are to research the issue of healthcare charging and develop a charging policy for a healthcare institution that reflects current market trends. You should consider various methods of establishing this pol ...

Problem identification and project outlinethe company that

Problem Identification and Project Outline The company that I we will be speaking on is Uber. Uber is a ride sharing app that is in most major city in the United States. Uber started in San Francisco and has branched out ...

Corporate finance amp financial management assignment -task

CORPORATE FINANCE & FINANCIAL MANAGEMENT ASSIGNMENT - TASK - Question 1 - Y Ltd Shares have a beta of 1.6 and an expected return of 21.0%. Shares in Z Ltd have a beta of 1.03 and an expected return of 13.5%. If the risk- ...

Corporate financial management questions -part a -q1 200

Corporate Financial Management Questions - Part A - Q1. $200 invested today and earning 8 per cent per annum compounded semi-annually will grow to what amount at the end of three years? (A) $158.80 (B) $251.94 (C) $380.7 ...

Part aweek 1in order to properly implement a strategic plan

Part A Week 1: In order to properly implement a strategic plan, organizations use structure, various control systems (budgets, variance analysis, policies and procedures, company rules), and culture. Let us revisit Gener ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As