Chat with us, powered by LiveChat ORG 726 University of Phoenix Sales Volume Analysis Discussion Paper - Credence Writers
+1(978)310-4246 [email protected]

Description

ORG/726: The Impact Of Technology On Organizations

Wk 5 – Summative Assessment: Organization Decision-Making [due Mon]

Wk 5 – Summative Assessment: Organization Decision-Making [due Mon]

Assignment Content

  1. Making decisions within an organization requires a thorough analysis of the available data. In this assignment, you will analyze and interpret provided data to make informed decisions regarding product marketing.

    Review the

    Sales Volume Data by Month

    . Run a variety of sorts and filters to better understand the data provided.

    Create a visualization of the data using 1 of the graphing tools in Microsoft? Excel?. Include the graph as an image in your analysis.

    Write a 1,050- to 1,400-word analysis of the data in which you:

    • Include:
    • Graphical depiction of the data
    • Summary of the descriptive data
    • Inferences from the descriptive data
    • Recommended strategic response to the information
    • Summarize the descriptive data. Consider:
    • Best-performing products
    • Worst-performing products
    • Seasonal variance
    • General patterns
    • Statistical outliers
    • Explain inferences that can be made from the data. Consider:
    • Contextual aspects of the data
    • Correlations of seasons and product offerings
    • Predictability of sales volume changes
    • Recommend a business response to the data. Consider specific marketing strategies based on your interpretation of the data.

Review the
Sales Volume
Data by
Month Table
in cells A3
through N8.
Table 1: Sales
Volume Data
by Month
Product
Jan.
Feb.
March
April
May
June
July
Aug.
Soda 1
Soda 2
Beer 1
Beer 2
Water
122
87
34
45
24
110
70
13
15
28
130
98
25
26
34
190
110
45
52
43
221
195
110
98
98
310
243
187
167
160
358
269
410
342
198
490
310
390
340
210
Sept.
Oct.
Nov.
Dec.
Total
340
214
367
344
178
217
112
234
267
65
189
98
221
178
32
240
71
205
160
28
2917
1877
2241
2034
1098

Purchase answer to see full
attachment

error: Content is protected !!