Using Spreadsheets to Create a Business Case from Raw Data. One word doc and One excel doc is required. See attachment for Instructions

profiledream86
M1StoreRegionSalesDatabase--ExcelTemplate.xlsx
Home>Business & Finance homework help>Management homework help>Using Spreadsheets to Create a Business Case from Raw Data. One word doc and One excel doc is required. See attachment for Instructions

Data

Store & Region Sales Database
ID Store No Sales Region Item No Item Description Unit Price Units Sold Week Ending Weekly Revenue
1 1 South 2005 17" Monitor $229.00 38 10/27/20
2 1 South 2005 17" Monitor $229.00 40 11/24/20 Instructions: See detailed instructions in the assignment.
3 1 South 2005 17" Monitor $229.00 19 12/29/20
4 1 South 3006 101 Keyboard $19.95 40 10/27/20
5 1 South 3006 101 Keyboard $19.95 45 11/24/20
6 1 South 3006 101 Keyboard $19.95 49 12/29/20
7 1 South 6050 PC Mouse $8.95 38 10/27/20
8 1 South 6050 PC Mouse $8.95 13 11/24/20
9 1 South 6050 PC Mouse $8.95 48 12/29/20
10 1 South 8500 Desktop CPU $849.95 35 10/27/20
11 1 South 8500 Desktop CPU $849.95 37 11/24/20
12 1 South 8500 Desktop CPU $849.95 43 12/29/20
13 2 South 2005 17" Monitor $229.00 18 10/27/20
14 2 South 2005 17" Monitor $229.00 18 11/24/20
15 2 South 2005 17" Monitor $229.00 20 12/29/20
16 2 South 3006 101 Keyboard $19.95 18 10/27/20
17 2 South 3006 101 Keyboard $19.95 18 11/24/20
18 2 South 3006 101 Keyboard $19.95 18 12/29/20
19 2 South 6050 PC Mouse $8.95 19 10/27/20
20 2 South 6050 PC Mouse $8.95 19 11/24/20
21 2 South 6050 PC Mouse $8.95 18 12/29/20
22 2 South 8500 Desktop CPU $849.95 28 10/27/20
23 2 South 8500 Desktop CPU $849.95 28 11/24/20
24 2 South 8500 Desktop CPU $849.95 30 12/29/20
25 3 South 2005 17" Monitor $229.00 48 10/27/20
26 3 South 2005 17" Monitor $229.00 40 11/24/20
27 3 South 2005 17" Monitor $229.00 13 12/29/20
28 3 South 3006 101 Keyboard $19.95 40 10/27/20
29 3 South 3006 101 Keyboard $19.95 42 11/24/20
30 3 South 3006 101 Keyboard $19.95 43 12/29/20
31 3 South 6050 PC Mouse $8.95 35 10/27/20
32 3 South 6050 PC Mouse $8.95 15 11/24/20
33 3 South 6050 PC Mouse $8.95 36 12/29/20
34 3 South 8500 Desktop CPU $849.95 38 10/27/20
35 3 South 8500 Desktop CPU $849.95 37 11/24/20
36 3 South 8500 Desktop CPU $849.95 39 12/29/20
37 4 North 2005 17" Monitor $229.00 28 10/27/20
38 4 North 2005 17" Monitor $229.00 30 11/24/20
39 4 North 2005 17" Monitor $229.00 14 12/29/20
40 4 North 3006 101 Keyboard $19.95 22 10/27/20
41 4 North 3006 101 Keyboard $19.95 34 11/24/20
42 4 North 3006 101 Keyboard $19.95 46 12/29/20
43 4 North 6050 PC Mouse $8.95 39 10/27/20
44 4 North 6050 PC Mouse $8.95 21 11/24/20
45 4 North 6050 PC Mouse $8.95 48 12/29/20
46 4 North 8500 Desktop CPU $849.95 31 10/27/20
47 4 North 8500 Desktop CPU $849.95 34 11/24/20
48 4 North 8500 Desktop CPU $849.95 40 12/29/20
49 5 North 2005 17" Monitor $229.00 37 10/27/20
50 5 North 2005 17" Monitor $229.00 35 11/24/20
51 5 North 2005 17" Monitor $229.00 33 12/29/20
52 5 North 3006 101 Keyboard $19.95 90 10/27/20
53 5 North 3006 101 Keyboard $19.95 92 11/24/20
54 5 North 3006 101 Keyboard $19.95 85 12/29/20
55 5 North 6050 PC Mouse $8.95 75 10/27/20
56 5 North 6050 PC Mouse $8.95 34 11/24/20
57 5 North 6050 PC Mouse $8.95 65 12/29/20
58 5 North 8500 Desktop CPU $849.95 65 10/27/20
59 5 North 8500 Desktop CPU $849.95 67 11/24/20
60 5 North 8500 Desktop CPU $849.95 57 12/29/20
61 6 East 2005 17" Monitor $229.00 34 10/27/20
62 6 East 2005 17" Monitor $229.00 95 11/24/20
63 6 East 2005 17" Monitor $229.00 66 12/29/20
64 6 East 3006 101 Keyboard $19.95 62 10/27/20
65 6 East 3006 101 Keyboard $19.95 68 11/24/20
66 6 East 3006 101 Keyboard $19.95 79 12/29/20
67 6 East 6050 PC Mouse $8.95 45 10/27/20
68 6 East 6050 PC Mouse $8.95 49 11/24/20
69 6 East 6050 PC Mouse $8.95 54 12/29/20
70 6 East 8500 Desktop CPU $849.95 88 10/27/20
71 6 East 8500 Desktop CPU $849.95 98 11/24/20
72 6 East 8500 Desktop CPU $849.95 109 12/29/20
73 7 East 2005 17" Monitor $229.00 44 10/27/20
74 7 East 2005 17" Monitor $229.00 46 11/24/20
75 7 East 2005 17" Monitor $229.00 45 12/29/20
76 7 East 3006 101 Keyboard $19.95 59 10/27/20
77 7 East 3006 101 Keyboard $19.95 57 11/24/20
78 7 East 3006 101 Keyboard $19.95 58 12/29/20
79 7 East 6050 PC Mouse $8.95 55 10/27/20
80 7 East 6050 PC Mouse $8.95 52 11/24/20
81 7 East 6050 PC Mouse $8.95 55 12/29/20
82 7 East 8500 Desktop CPU $849.95 65 10/27/20
83 7 East 8500 Desktop CPU $849.95 67 11/24/20
84 7 East 8500 Desktop CPU $849.95 65 12/29/20
85 8 East 2005 17" Monitor $229.00 28 10/27/20
86 8 East 2005 17" Monitor $229.00 27 11/24/20
87 8 East 2005 17" Monitor $229.00 33 12/29/20
88 8 East 3006 101 Keyboard $19.95 32 10/27/20
89 8 East 3006 101 Keyboard $19.95 28 11/24/20
90 8 East 3006 101 Keyboard $19.95 32 12/29/20
91 8 East 6050 PC Mouse $8.95 24 10/27/20
92 8 East 6050 PC Mouse $8.95 26 11/24/20
93 8 East 6050 PC Mouse $8.95 27 12/29/20
94 8 East 8500 Desktop CPU $849.95 42 10/27/20
95 8 East 8500 Desktop CPU $849.95 38 11/24/20
96 8 East 8500 Desktop CPU $849.95 40 12/29/20