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