User Account

All Pages

Calculate total sales using the sum function

Assignment Help Financial Management
Reference no: EM131976837

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.

• Insert a hyperlink to the company's web page. (You can use any business web page for this example.)

• Change your spreadsheet to a page or print layout view to be sure it fits well on a printed 8.5" x 11" sheet of paper.

Attachment:- Data File.rar

Reference no: EM131976837

Questions Cloud

Depiction of a reaction between a carboxylic acid : Below is a generalised depiction of a reaction between a carboxylic acid (in this case butanoic acid) and an alcohol (ethanol). What type of reaction is this
Calculate the expected return for different stock : Consider the following probability distribution for stocks A and B for questions 1 and 2. Calculate the Expected return for Stock A and for Stock B.
What is ceos compensation package at silver cloud computing : What is the CEO's compensation package at Silver Cloud Computing is a $1,000,000 salary with a cash bonus of 5% of operating income before the bonus.
Net ionic equation for the reaction : What pH range would you expect the equivalence point to lie for the titration of a weak base (such as ammonia) with a strong acid (such as HCl)?
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.
Explain why two 2pz or two 2px orbitals : Could you please explain why two 2pz or two 2px orbitals form a sigma bond whereas two 2py orbitals form a pi bond?
Properties of a hydrogen bonding substance : Do the values bear out the assertion that hydrogen bonds are about one tenth as strong as covalent bonds? How does such a 'weak' force
Prepare a risk assessment of the food and beverage industry : Prepare a risk assessment of the food and beverage industry that can help management gain a better understanding of the external environment in foreign markets.
Unprecedented solvent capabilities : Dihydrogen monoxide, or its more common name, water, is an interesting and unique substance that has virtually unprecedented solvent capabilities.

Reviews

Write a Review

Financial Management Questions & Answers

  Discuss the difference in value of these two stations

Discuss the difference in value (if any) of these two stations

  Treasury inflation protected securities

The U.S. Treasury has introduced bonds where the return is inflation adjusted to the consumer price index (TIPS: Treasury Inflation Protected Securities), what should we expect the price of these bonds to be relative to other U.S. Treasury bonds?

  The interest payment amounts in dollars for each repo

What are the interest payment amounts in dollars for each repo?

  Plodding along without much attention from the stock market

Your firm has been plodding along without much attention from the stock market.

  What would cause an increase in net working capital

Suppose you are a finance student interviewing for a job and the interviewers ask you what would cause an increase in net working capital. Which of the following would be the best response?

  About the future value of annuity

Future Value of Annuity. Michelle is attending college and has a? part-time job.

  The put option were american

If the put option were American, would it ever be optimal to exercise it early at any of the nodes of the tree?

  The new money is invested to earn fair return

Associated Breweries is planning to market unleaded beer. Assuming that the new money is invested to earn a fair return,

  The fixed asset is fully depreciated over the life

A 4-year project has an initial fixed asset investment of $21,840, an initial NWC investment of $2,080, and an annual OCF of -$33,280. The fixed asset is fully depreciated over the life of the project and has no salvage value. Required: If the requir..

  What was bobs return on owning this car

In 1972, Bob purchased a new Datsun 2402 for $3,000. Datsun later changed its name to Nissan, and the 1972 240Z became a classic.

  Forecasting cash flows-interest bearing debt

Your company is forecasting cash flows of $20 million next year, $40 million in the second year and $60 million in year 3. After that growth is expected to level off at 7% per year. Your company has $150 million in marketable securities and $400 mill..

  Price paid to the bondholder if the issuer calls the bond

A 7.4 percent corporate coupon bond is callable in five years for a call premium of one year of coupon payments. Assuming a par value of $1,000, what is the price paid to the bondholder if the issuer calls the bond?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd