Create appropriate x- and y-axis labels

Assignment Help Marketing Management

Reference no: EM131202944

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.

Reference no: EM131202944

Questions Cloud

The journal entry to record this transaction would include : A company factored $38,000 of its accounts receivable and was charged a 1% factoring fee. The journal entry to record this transaction would include a:

Common stockholders will receive dividend : A corporation has 10,000 shares of 6% $50 par value cumulative preferred stock and fifty thousand shares of $4 par value common stock outstanding last year no dividends were paid this year the board of directors decided to pay a dividend of $80,000 t..

Calculate the value of c to achieve this condition : It is desired to run the motor in the previous problem with a power factor of unity. To achieve this, a capacitor C is connected in parallel across the motor, which results in a circuit like that shown in Fig. 2.13. Calculate the value of C to ach..

Program to find the sum & average of the given numbers : Write a program to find the sum & average of the given numbers using the while loop.- Write a program in C to find the sum and average of the given numbers stored in an array of n values.

Create appropriate x- and y-axis labels : 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.)

Find the resistance r and inductance l of the motor : A motor is connected to a 120 V rms, 60 Hz line. The motor is rated at 2 kVA and operates with a power factor of 0.8.

What stereotypes are associated with middle age : Describe Erik Erikson's Generativity versus Stagnation stage. According to Erikson, how does personality change in middle age? What personal and cultural forces motivate generativity? Why does it increase and contribute vitally to favorable adjust..

Their respective voltages is : The ratio of resistances of a 100 W, 220 V lamp to that of a 100 W, 110 V lamp will be at their respective voltages is?

Using the units-of-production method-depreciation expense : A company purchased a weaving machine for $307,320. The machine has a useful life of 8 years and a residual value of $17,000. It is estimated that the machine could produce 764,000 bolts of woven fabric over its useful life. In the first year, 112,00..

User Account

All Pages