Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Operation Management Expert

Management Studies


Home >> Operation Management

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.

Operation Management, Management Studies

  • Category:- Operation Management
  • Reference No.:- M92782122

Have any Question?


Related Questions in Operation Management

Marcie is hired by susanrsquos wetsuits inc to create a

Marcie is hired by Susan’s Wetsuits Inc., to create a web-based marketing strategy for Susan’s new line of wetsuits. Marcie signs a contract that includes a clause prohibiting her from competing with Susan’s during and a ...

Case life and death of an aircraft development projectlaw

Case ; Life and Death of an Aircraft Development Project Law and Callon31 described the history of a large British aerospace project in terms of two entities: the global system and the project itself. The global system c ...

An end itemrsquos demand forecasts for the next 10 weeks

An end item’s demand forecasts for the next 10 weeks are 30, 20, 35, 50, 25, 25, 0, 40, 0, and 50 units. The current on-hand inventory is 80 units. The order policy is to produce in lots of 100. The booked customer order ...

1 by which of the following this company pull off mass

1. By which of the following this company pull off mass customization? And why? Justify your answer 1) Trend of technology (Technology evolution) 2) Their product or service differentiation 3) Supply chain management 2. ...

Agile project management and scrum1 what do you need to

Agile Project Management and Scrum 1. What do you need to make estimates as a team using “Estimation Poker”? 2. How do you resolve differences in estimation with “Estimation Poker”? 3. When should you use affinity estima ...

1 explain the difference between viral marketing blogging

1. Explain the difference between viral marketing, blogging and podcasting. Find an example of each on the web and share the link.   For each of your examples, discuss what you like about them. 2. Considering IBM's Watso ...

Is the geographic location of a private sector companys

Is the geographic location of a private sector company's operations a mandatory subject of bargaining under the NLRB? Should it be? If a company determines to establish a production operating facility in another geograph ...

Buildit is a construction company specialized in public

Buildit is a construction company specialized in public works (roads, bridges, pipelines, tunnels, railroads, etc.). Within Buildit, it often occurs that engineers working at a construction site (called “site engineers”) ...

1 identify the primary issues that relate to technology

1. Identify the primary issues that relate to technology investments in the public sector. Do you believe ROI analysis must be carried out for all IT projects? 2. Post an instructional strategy that you have used as an i ...

Case scenario at the workplace you are the research team

Case scenario. At the workplace, you are the research team leader. The Boss wants your team to conduct a study with three or more groups to solve a problem. Since there are many workplace problems, you must select the pr ...

  • 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

Follow Us

© Copyright 2013-14 mywordsolution.com All rights reserved