Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

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

Marketing design and innovation assignment -you are

Marketing Design and Innovation Assignment - You are required to select a contemporary consumer, industrial or commercial product or service that for one reason or another inspires you to critique within the context of t ...

Question write a 2-3 page double spaced narrative response

Question: Write a 2-3 page (double spaced) narrative response. Be sure to address every point within the prompt. Submit as DOC, DOCX, PDF, or RTF file attachments. Prompts: Recommended after Lecture 8 Find one commercial ...

Assignment -prepare a marketing plan for given

Assignment - Prepare a marketing plan for given product. Product - Use Pencil Box as the product. REQUIREMENTS - Cover Sheet (USE APA TEMPLATE FOR THIS ASSIGNMENT) Marketing Objectives - Just one concise paragraph. Inclu ...

Question the final assignment is a paper that describes

Question: The final assignment is a paper that describes each of the steps necessary to conduct marketing research based on a specific marketing research problem. Choose a product or service with a marketing research iss ...

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 explain the importance of variation to health-care

Question: Explain the importance of variation to health-care organizations and answer the following questions. 1. What might be the key processes for health-care organizations? 2. What are the potential common causes of ...

Assignment -context you are required to select a

Assignment - Context: You are required to select a contemporary consumer, industrial or commercial product or service that for one reason or another inspires you to critique within the context of this module. Explain why ...

Question 1what is molto deliziosos business-level strategy

Question: 1. What is Molto Delizioso's business-level strategy? Note that Five business-level strategies are discussed in chapter 5. 2. What is a customer centric business strategy? Is Molto Delizioso's strategy customer ...

Assignment project -assignment objectives - apply research

Assignment Project - Assignment Objectives - Apply research concepts and principles by developing a research strategy and proposal for a project Assignment Description - Part 1: During the past few weeks, you have consid ...

Question case analysis the cases provide an opportunity to

Question: Case Analysis: The cases provide an opportunity to examine concepts in greater detail and develop problem solving and decision making skills. Students are expected to read and analyze each case, develop and sub ...

  • 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