User Account

All Pages

Calculate total sales using the sum function

Assignment Help Operation Management
Reference no: EM131943466

Purpose of Assignment

In this assignment, you apply Microsoft® Excel® formatting to a business example. You will use this skill to enter and analyze data using charts.

Assignment Steps

Resources:

Microsoft® Office Help and Training

Other tutorials available online

Week 3 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.

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.

Reference no: EM131943466

Questions Cloud

Explore the realm of leadership and assess his own strength : The development plan and subsequent application thereof, is potentially the single most important opportunity and lasting legacy of this course.
Marginal rate of technical substitution : What are the relationships among marginal products, the marginal rate of technical substitution, and the slopes of isoquants?
Formulate your opinion based on your findings : Formulate your opinion based on your findings and then frame your opinion in a thesis statement that you will use in your essay assignment.
Discuss the various options for sampling : Discuss the various options for sampling and cohort formation within epidemiologic cohort studies. As a practicing epidemiologist, how would you go about.
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.
Describe the events leading up to the triggering event : Describe the events leading up to the triggering event and what's happened since then. Explain how various stakeholder groups have reacted to the issue.
Prepare a memo for management on unionization : Prepare a 100 to 125-word Labor Relations Memo for Management on unionization as it would apply to the company. It should be written in the third person voice.
Introduce the Victorian Curriculum : ECP327 Assessment Title: Curriculum and Application: Critique and Reflection. Introduce the Victorian Curriculum and describe your understanding
Algorithm for computing the depth : Give an O(n)-time algorithm for computing the depth of each node of a tree T, where n is the number of nodes of T.

Reviews

Write a Review

Operation Management Questions & Answers

  Develop the required knowledge and capabilities

The primary goal of training programs is to ensure participants develop the required knowledge and capabilities to maximize on-the-job performance.

  How you will calculate the economic order quantity

Suppose you are working as a Inventory Manager in a manufacturing company. Your company requires 1000 units of raw material per month. The ordering cost is Rs 100 per order. The carrying cost is 15% of average inventory per order. How you will calcul..

  Explain the labour processes and the relations of production

explain the labour processes and the relations of production regarding that specific product in term of the material

  What is purpose of using a pareto chart for a given problem

How can a university control the quality of its output (that is, its graduates)? -  Philip Crosby said that quality is free. Why?

  Queuing system in your place of business

List three examples of problems you could solve with a queuing system in your place of business or where you shop. What kinds of problems in your daily lives have you seen that a queuing system might solve?

  Types of teams in an organization is established

Which of the following types of teams in an organization is established with a specific mission to develop something new or complete a specific task?

  Which shipping alternative would you recommend

Three hundred and sixty boxes are to be shipped, and each box has a price of $146. Which shipping alternative would you recommend?

  Mean price of s gallon of unleaded regular gasoline i

According to a study, the mean price of s gallon of unleaded regular gasoline in the United States is $2.45. A s sample of 25 Chicago area gas stations shows the mean price of $2.55. The standard deviation of the population is known to be $0.50. Deve..

  Strategies to fit dynamic and unpredictable economies

international companies strive to dynamically change their operations strategies to fit the dynamic and unpredictable economies.

  Values and going down to few specific job titles

Develop a competency-based model for an organization you're familiar with, starting from the mission and values and going down to a few specific job titles.

  As part of the settlement for class action lawsuit

As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash to make the following payments

  Construct a strategic marketing plan objective

Construct a strategic marketing plan objective: To develop an understanding of the steps involved in creating a strategic Marketing plan.

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