Ask Marketing Management Expert

Use the following information to build a sales spreadsheet.

You have been assigned the following accounts and provided with the following sales data. This is the total annual sales in dollars for each account in your territory for 2012-2014.

Account

2012

2013

2014

Illinois

116,030

178,970

189,400

Indiana

15,190

1,250

5,004

Iowa

67,890

164,170

83,310

Maryland

65,980

45,280

98,220

Michigan

68,070

55,880

124,550

Michigan State

82,390

100,050

157,790

Minnesota

27,830

79,231

84,900

Nebraska

258,450

219,390

274,880

Northwestern

52,890

46,570

55,570

Ohio State

158,590

209,890

162,440

Penn State

101,200

148,500

138,530

Purdue

111,880

85,089

76,800

Rutgers

110,000

145,000

128.000

Wisconsin

75,000

90,900

111,005

Total

1,311,190

1,687,960

1,670,179

Add the following columns to your spreadsheet (use round numbers -- no decimals):

Two columns with one showing the percentage change for 2012-2013, and one showing the dollar change for 2012-2013.

Two columns with one showing the percentage change for the following year, 2013-2014, and one showing the dollar change for 2013-2014.

You have been assigned a 12% sales goal for 2015. Add one column showing the sales goal, plus two columns showing the forecasted percentage and dollar change for 2014-2015.

Using the spreadsheet,

Use the "Insert Chart" function in Excel to build a bar chart showing three years' worth of sales growth.

Create appropriate X- and Y-axis labels, a chart title, and data labels so that your chart data are appropriately identified (years, dollars, account territory, etc.).

Open a PowerPoint slide, choose a template and formatting, and import your chart into PowerPoint. The idea is to create a sales slide that would be appropriate to present to senior management at your company. For instance, you can add a logo, headers, and other formatting to add to the professional appearance of your assignment.

Save your finalized slide as a PDF.

Marketing Management, Management Studies

  • Category:- Marketing Management
  • Reference No.:- M91958972

Have any Question?


Related Questions in Marketing Management

Question 1 application of conceptstime value of money2

Question: 1. Application of concepts/time value of money? 2. Which is more detrimental to a firm, pricing your product or service too high, or pricing your product or service too low? 3. Discuss the role of demographics ...

Question imagine that you are in the market for a new

Question: Imagine that you are in the market for a new career. How can the marketing research process apply to your career search? Think of a specific topic you need to learn more about that relates to your career as a o ...

Question strategic marketing planintroductionthis

Question: STRATEGIC MARKETING PLAN INTRODUCTION This assignment entails development of a comprehensive strategic marketing plan for a new product or service that is ready to "go to market". A Project Template is provided ...

Qestion ready set strive gen z is comingby janet adamy

Question: Ready, Set, Strive : Gen Z Is Coming By Janet Adamy | Sep 07, 2018 TOPICS: Consumer Behavior, External Marketing Environment, Targeting SUMMARY: About 17 million members of Generation Z are now adults and start ...

Question in your marketing plan you should1establish a

Question: In your Marketing Plan, you should: 1. Establish a Mission Statement and a Vision Statement for your new organization. 2. Briefly describe basic services it has been providing during the first six months of ope ...

Question 1review the terminal course objectives accessed by

Question: 1. Review the Terminal Course Objectives, accessed by clicking on the "Course Information" tab at the top of your screen, scrolling down to the "Course Objectives" and then selecting View class objectives. How ...

Question read the worddoc first and answer those following

Question: Read the word.doc first and answer those following question 1. Provide a list of at least five pieces of information that airlines have about their customers, and for each, explain how that information might he ...

In this unit you are asked to produce a public relations

In this unit you are asked to produce a Public Relations Campaign Proposal document and an essay that explains the theory behind your planned approach to the Proposal task. You may base your assessment on the suggested s ...

Question 1200 words on your favorite retailer and their

Question: 1200 words on your favorite retailer and their major competitor as discussed in class. This should focus on the different elements that make up the retail strategy of the companies and other factors that appeal ...

Question bulltype of paper assignmentbullsubject

Question: • Type of paper Assignment • Subject Other • Number of pages 1 • Format of citation Other • Number of cited resource s0 • Type of service Writing from scratch First, choose a piece of art from any genre (music, ...

  • 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