Week One Hands on MIS Application Software Exercise Solution 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 ask the right questions about the data and then present your case Import the data into Excel or Access (or compatible spreadsheet database) Use the data to perform the below 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 A Strongest Selling Period for each Product by Total Revenue B Strongest Selling Period for each Region by Total Revenue C Strongest Selling Period for each Store by Total Revenue Provide a business case in 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 to label your tables SUBMIT your final report with one WORD document and one EXCEL ACCESS file Store Region Sales Database ID Store No Sales Region Item No Item Description Unit Price Units Sold Week Ending 1 1 South 2005 17 Monitor $229 00 28 10 27 10 2 1 South 2005 17 Monitor $229 00 30 11 24 10 3 1 South 2005 17 Monitor $229 00 9 12 29 10 4 1 South 3006 101 Keyboard $19 95 30 10 27 10 5 1 South 3006 101 Keyboard $19 95 35 11 24 10 6 1 South 3006 101 Keyboard $19 95 39 12 29 10 7 1 South 6050 PC Mouse $8 95 28 10 27 10 8 1 South 6050 PC Mouse $8 95 3 11 24 10 9 1 South 6050 PC Mouse $8 95 38 12 29 10 10 1 South 8500 Desktop CPU $849 95 25 10 27 10 11 1 South 8500 Desktop CPU $849 95 27 11 24 10 12 1 South 8500 Desktop CPU $849 95 33 12 29 10 13 2 South 2005 17 Monitor $229 00 8 10 27 10 14 2 South 2005 17 Monitor $229 00 8 11 24 10 15 2 South 2005 17 Monitor $229 00 10 12 29 10 16 2 South 3006 101 Keyboard $19 95 8 10 27 10 17 2 South 3006 101 Keyboard $19 95 8 11 24 10 18 2 South 3006 101 Keyboard $19 95 8 12 29 10 19 2 South 6050 PC Mouse $8 95 9 10 27 10 20 2 South 6050 PC Mouse $8 95 9 11 24 10 21 2 South 6050 PC Mouse $8 95 8 12 29 10 22 2 South 8500 Desktop CPU $849 95 18 10 27 10 23 2 South 8500 Desktop CPU $849 95 18 11 24 10 24 2 South 8500 Desktop CPU $849 95 20 12 29 10 25 3 South 2005 17 Monitor $229 00 38 10 27 10 26 3 South 2005 17 Monitor $229 00 30 11 24 10 27 3 South 2005 17 Monitor $229 00 3 12 29 10 28 3 South 3006 101 Keyboard $19 95 30 10 27 10 29 3 South 3006 101 Keyboard $19 95 32 11 24 10 30 3 South 3006 101 Keyboard $19 95 33 12 29 10 31 3 South 6050 PC Mouse $8 95 25 10 27 10 32 3 South 6050 PC Mouse $8 95 5 11 24 10 33 3 South 6050 PC Mouse $8 95 26 12 29 10 34 3 South 8500 Desktop CPU $849 95 28 10 27 10 35 3 South 8500 Desktop CPU $849 95 27 11 24 10 36 3 South 8500 Desktop CPU $849 95 29 12 29 10 37 4 North 2005 17 Monitor $229 00 18 10 27 10 38 4 North 2005 17 Monitor $229 00 20 11 24 10 39 4 North 2005 17 Monitor $229 00 4 12 29 10 40 4 North 3006 101 Keyboard $19 95 12 10 27 10 41 4 North 3006 101 Keyboard $19 95 24 11 24 10 42 4 North 3006 101 Keyboard $19 95 36 12 29 10 43 4 North 6050 PC Mouse $8 95 29 10 27 10 44 4 North 6050 PC Mouse $8 95 11 11 24 10 45 4 North 6050 PC Mouse $8 95 38 12 29 10 46 4 North 8500 Desktop CPU $849 95 21 10 27 10 47 4 North 8500 Desktop CPU $849 95 24 11 24 10 48 4 North 8500 Desktop CPU $849 95 30 12 29 10 49 5 North 2005 17 Monitor $229 00 27 10 27 10 50 5 North 2005 17 Monitor $229 00 25 11 24 10 51 5 North 2005 17 Monitor $229 00 23 12 29 10 52 5 North 3006 101 Keyboard $19 95 80 10 27 10 53 5 North 3006 101 Keyboard $19 95 82 11 24 10 54 5 North 3006 101 Keyboard $19 95 75 12 29 10 55 5 North 6050 PC Mouse $8 95 65 10 27 10 56 5 North 6050 PC Mouse $8 95 24 11 24 10 57 5 North 6050 PC Mouse $8 95 55 12 29 10 58 5 North 8500 Desktop CPU $849 95 55 10 27 10 59 5 North 8500 Desktop CPU $849 95 57 11 24 10 60 5 North 8500 Desktop CPU $849 95 47 12 29 10 61 6 East 2005 17 Monitor $229 00 24 10 27 10 62 6 East 2005 17 Monitor $229 00 85 11 24 10 63 6 East 2005 17 Monitor $229 00 56 12 29 10 64 6 East 3006 101 Keyboard $19 95 52 10 27 10 65 6 East 3006 101 Keyboard $19 95 58 11 24 10 66 6 East 3006 101 Keyboard $19 95 69 12 29 10 67 6 East 6050 PC Mouse $8 95 35 10 27 10 68 6 East 6050 PC Mouse $8 95 39 11 24 10 69 6 East 6050 PC Mouse $8 95 44 12 29 10 70 6 East 8500 Desktop CPU $849 95 78 10 27 10 71 6 East 8500 Desktop CPU $849 95 88 11 24 10 72 6 East 8500 Desktop CPU $849 95 99 12 29 10 73 7 East 2005 17 Monitor $229 00 34 10 27 10 74 7 East 2005 17 Monitor $229 00 36 11 24 10 75 7 East 2005 17 Monitor $229 00 35 12 29 10 76 7 East 3006 101 Keyboard $19 95 49 10 27 10 77 7 East 3006 101 Keyboard $19 95 47 11 24 10 78 7 East 3006 101 Keyboard $19 95 48 12 29 10 79 7 East 6050 PC Mouse $8 95 45 10 27 10 80 7 East 6050 PC Mouse $8 95 42 11 24 10 81 7 East 6050 PC Mouse $8 95 45 12 29 10 82 7 East 8500 Desktop CPU $849 95 55 10 27 10 83 7 East 8500 Desktop CPU $849 95 57 11 24 10 84 7 East 8500 Desktop CPU $849 95 55 12 29 10 85 8 East 2005 17 Monitor $229 00 18 10 27 10 86 8 East 2005 17 Monitor $229 00 17 11 24 10 87 8 East 2005 17 Monitor $229 00 23 12 29 10 88 8 East 3006 101 Keyboard $19 95 22 10 27 10 89 8 East 3006 101 Keyboard $19 95 18 11 24 10 90 8 East 3006 101 Keyboard $19 95 22 12 29 10 91 8 East 6050 PC Mouse $8 95 14 10 27 10 92 8 East 6050 PC Mouse $8 95 16 11 24 10 93 8 East 6050 PC Mouse $8 95 17 12 29 10 94 8 East 8500 Desktop CPU $849 95 32 10 27 10 95 8 East 8500 Desktop CPU $849 95 28 11 24 10 96 8 East 8500 Desktop CPU $849 95 30 12 29 10

The Answer is in the image, click to view ...

Question: Week One: Hands-on MIS Application Software Exercise Solution Store & Region Sales Database This exercise helps students understand how a raw file of sales transactions

Week One: Hands-on MIS Application Software Exercise Solution

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 ask the right questions about the data and then present your case!

Import the data into Excel or Access (or compatible spreadsheet/database). Use the data to perform the below 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:

A.Strongest Selling Period for each Product by Total Revenue

B.Strongest Selling Period for each Region by Total Revenue

C.Strongest Selling Period for each Store by Total Revenue

Provide a business case in 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 to label your tables.

SUBMIT your final report with one WORD document and one EXCEL/ACCESS file.

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Week One: Hands-on MIS Application Software Exercise Solution Store & Region Sales Database This exercise helps students understand how a raw file of sales transactions can be analyzed to produce...

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

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

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

I need a 10 page paper for my MIS class. Please do not copy and paste as my school is getting stricter on plagiarism. I have attached the assignment and the sample \fData Analytic Thinking 1 Data...

Set Student Name: 1. Answer true or false for each part, and if false, explain your answer. a. The point estimate for the population mean, , of an x distribution is x-bar, computed from a random...

Instuctor's Annotated Edition TENTH EDITION Understandable Statistics Concepts and Methods Charles Henry Brase Regis University Corrinne Pellillo Brase Arapahoe Community College Australia Brazil...

MSc Applied Research Project Please answer question (C) Introduction: Section A Fri 31st Jan 2020 Teams should prepare a 10 minute presentation: Venue: Safari Annexe O'Donovan's Road Time:...

Montonya Company has the following selected data for the current year: Sales (10,000 units) $90,000 Direct materials 30,000 Direct labor costs 10,000 Variable manufacturing overhead 3,500 Fixed...

Compute the following items for the statement of cash flows: a. Beginning and ending Accounts Receivable are $21,000 and $17,000, respectively. Credit sales for the period total $66,000. How much are...

Your program should use the Free Pascal compiler described in CSC 540. When you hand in your assignment to the digital dropbox, it should be a .PAS file, not zipped. Be careful to use qword instead...

Which one of the following polar values is equivalent to 3 0 j 4 0 ? 5 0 ? 5 3 . 1 7 0 ? 5 3 . 1 7 0 3 6 . 9 5 0 3 6 . 9

Discuss several ways ( at least four ways ) to improve the requirement process and thus, a project team can avoid a situation where too many changes to the project requirements occur at the later...

3. Do you agree that pride building can be localized throughout the organization?

a. Cover the screen with a towel or newspaper and try to identify the style of one or two persons, using voice only.

2. To get some practice in identifying communication styles, watch two or three television shows and attempt to identify the style of individuals portrayed on the screen. To fully develop your skills...