MGT 608 Week 1 Sales Analysis for Natun Computer Company Case Study

Description

using spreadsheets to create a business case from raw data.

HINT: The on-line “Essential Training” links for Excel are posted below. Use your National University Single-Sign-On (SSO) for free access to these sessions at LinkedIn Learning.

The two below files are the instructions for the assignment and the data file to work on. For detailed information on this project check page 31 of the text: “Improving Decision Making: Using Databases to Analyze Sales Trends”

Week 1, Hands-on Analysis – Instructions – Word Document (27 KB)

Week 1 – Assignment Data – Excel Document (16 KB)

Recommendations for Reporting Analytical Work:

Always start with an Introduction of the business problem that you will be addressing in your report

End this Introduction with a brief summary of the topics you’ll be covering in your report

Always discuss information BEFORE showing a Table or Figure

Always reference a Table or Figure in the text, for example: “see Table 1 below”

The Table/Figure should follow as soon as possible on the page (e.g. at the next paragraph break)

Do NOT just reiterate the data in the Table or Figure

DO provide explanation, meaning, and/or summary of key points shown in the Table/Figure

For example, stating comparisons such as “A is 32% larger than B” or “this trend has consistently increased over the past 12 months”

Keep Tables/Figure as concise as possible — not too much data to clutter your main point

1/4 page is a good size, 1/2 page maximum, or use the Appendix as last resort for very large Tables/Figures

Avoid breaking Tables/Figure across 2 pages

Keep fonts legible, typically in the same style and size as your paragraph text
Always end with a Conclusion that:

Briefly summarizes your work,

Highlights again your key findings and
Ends with your overall recommendation and/or necessary actions as “next steps”
HINT: As with all writing and speaking, know your audience! For a business analysis, this will probably be your supervisor within your company/organization

2 attachments

Slide 1 of 2

attachment_1

attachment_1
attachment_2

attachment_2

Unformatted Attachment Preview

Store & Region Sales Database
ID
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
Store No
1
1
1
1
1
1
1
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
2
2
3
3
3
3
3
3
3
3
3
3
3
3
4
4
4
4
4
4
4
4
Sales Region
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
South
North
North
North
North
North
North
North
North
Item No
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
Item Description
17″ Monitor
17″ Monitor
17″ Monitor
101 Keyboard
101 Keyboard
101 Keyboard
PC Mouse
PC Mouse
PC Mouse
Desktop CPU
Desktop CPU
Desktop CPU
17″ Monitor
17″ Monitor
17″ Monitor
101 Keyboard
101 Keyboard
101 Keyboard
PC Mouse
PC Mouse
PC Mouse
Desktop CPU
Desktop CPU
Desktop CPU
17″ Monitor
17″ Monitor
17″ Monitor
101 Keyboard
101 Keyboard
101 Keyboard
PC Mouse
PC Mouse
PC Mouse
Desktop CPU
Desktop CPU
Desktop CPU
17″ Monitor
17″ Monitor
17″ Monitor
101 Keyboard
101 Keyboard
101 Keyboard
PC Mouse
PC Mouse
Unit Price
Units Sold
$229.00
38
$229.00
40
$229.00
19
$19.95
40
$19.95
45
$19.95
49
$8.95
38
$8.95
13
$8.95
48
$849.95
35
$849.95
37
$849.95
43
$229.00
18
$229.00
18
$229.00
20
$19.95
18
$19.95
18
$19.95
18
$8.95
19
$8.95
19
$8.95
18
$849.95
28
$849.95
28
$849.95
30
$229.00
48
$229.00
40
$229.00
13
$19.95
40
$19.95
42
$19.95
43
$8.95
35
$8.95
15
$8.95
36
$849.95
38
$849.95
37
$849.95
39
$229.00
28
$229.00
30
$229.00
14
$19.95
22
$19.95
34
$19.95
46
$8.95
39
$8.95
21
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
4
4
4
4
5
5
5
5
5
5
5
5
5
5
5
5
6
6
6
6
6
6
6
6
6
6
6
6
7
7
7
7
7
7
7
7
7
7
7
7
8
8
8
8
8
8
8
North
North
North
North
North
North
North
North
North
North
North
North
North
North
North
North
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
East
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
6050
6050
8500
8500
8500
2005
2005
2005
3006
3006
3006
6050
PC Mouse
Desktop CPU
Desktop CPU
Desktop CPU
17″ Monitor
17″ Monitor
17″ Monitor
101 Keyboard
101 Keyboard
101 Keyboard
PC Mouse
PC Mouse
PC Mouse
Desktop CPU
Desktop CPU
Desktop CPU
17″ Monitor
17″ Monitor
17″ Monitor
101 Keyboard
101 Keyboard
101 Keyboard
PC Mouse
PC Mouse
PC Mouse
Desktop CPU
Desktop CPU
Desktop CPU
17″ Monitor
17″ Monitor
17″ Monitor
101 Keyboard
101 Keyboard
101 Keyboard
PC Mouse
PC Mouse
PC Mouse
Desktop CPU
Desktop CPU
Desktop CPU
17″ Monitor
17″ Monitor
17″ Monitor
101 Keyboard
101 Keyboard
101 Keyboard
PC Mouse
$8.95
$849.95
$849.95
$849.95
$229.00
$229.00
$229.00
$19.95
$19.95
$19.95
$8.95
$8.95
$8.95
$849.95
$849.95
$849.95
$229.00
$229.00
$229.00
$19.95
$19.95
$19.95
$8.95
$8.95
$8.95
$849.95
$849.95
$849.95
$229.00
$229.00
$229.00
$19.95
$19.95
$19.95
$8.95
$8.95
$8.95
$849.95
$849.95
$849.95
$229.00
$229.00
$229.00
$19.95
$19.95
$19.95
$8.95
48
31
34
40
37
35
33
90
92
85
75
34
65
65
67
57
34
95
66
62
68
79
45
49
54
88
98
109
44
46
45
59
57
58
55
52
55
65
67
65
28
27
33
32
28
32
24
92
93
94
95
96
8
8
8
8
8
East
East
East
East
East
6050
6050
8500
8500
8500
PC Mouse
PC Mouse
Desktop CPU
Desktop CPU
Desktop CPU
$8.95
$8.95
$849.95
$849.95
$849.95
26
27
42
38
40
Week Ending
Weekly Revenue
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
Instructions: See detailed instructions in the assignment.
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
10/27/2020
11/24/2020
12/29/2020
MGT 608 nformation
and Supply Chain Systems
Week One: Hands-on Analysis
Store & Region Sales Database
This exercise helps students understand how a raw file of sales transactions can be
analyzed to produce valuable information for managers. Your challenge is to see what
the data is telling you and then present your case for improvement!
You are the Senior Vice President of Sales for the Natun Computer Company. This is
your regular report to the CEO, summarizing the recent performance of the company.
Although all stores are approximately the same in terms of retail space and workforce,
there have been falling sales in some stores. Leadership is interested in using data-driven
decision making to make management changes at the region and store level. In addition,
Product Development is looking for direction to focus investments. Marketing is also
interested in how the ¥st sellers#an be leveraged in advertising and promotions to
increase overall sales.
For each analysis below, provide your insights on historical performance and your
recommendations for future actions.
Use the data provided to perform the below analyses using PivotTables (required for all
four analyses):
Analyze ALL THREE of the below items:
1. Best Performing Regions by Total Revenue
2. Best Performing Stores by Total Revenue
3. Best Selling Products by Total Revenue
Select ONLY ONE of the below items to analyze:
A. Total Revenue for each Product by Selling Period
B. Total Revenue for each Region by Selling Period
C. Total Revenue for each Store by Selling Period
Provide your insights and recommendations in a formal business case )n the form of
ONE descriptive paragraph and ONE data table — for each analysis. Each paragraph
must refer to the information presented in the table using the labeled Table #. Use APA
format for your entire report, including your tables. Don forget a clear introduction to
your project and conclude with a summary of your recommendations to the CEO.
SUBMIT 9our final report with one WORD document and one EXCEL file.

Purchase answer to see full
attachment

Explanation & Answer:

5 pages

User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.



^{Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."}