Bundor-DAD 220 Module 5-3 Major Activity Assignment
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
220
Subject
Business
Date
Apr 25, 2024
Type
docx
Pages
5
Uploaded by DoctorHawk9805
DAD 220 Module 5-3 Major Activity Assignment: Analyzing Queries
C Daniel T Bundor
Southern New Hampshire University
DAD 220: Introduction to Structure Database
Dr. Robert Rupocinski
July 30, 2023
DAD 220 Module 5-3 Major Activity Assignment: Analyzing Queries
1.
Write SQL commands that capture specific, usable data that can be used in your analysis.
The below SQL commands will extract specific and usable data from the sales and returns data tables, providing valuable insights for the analysis of sales and returns by region.
a.
SELECT state, COUNT(*) AS customer_count
FROM sales_data
GROUP BY state
ORDER BY customer_count DESC;
b.
SELECT product_name, SUM(quantity) AS total_sold
FROM sales_data
GROUP BY product_name
ORDER BY total_sold DESC
LIMIT 50;
c.
SELECT product_name, SUM(quantity) AS total_sold
FROM sales_data
WHERE state IN ('Virginia', 'North Carolina', 'South Carolina', 'Georgia')
GROUP BY product_name
ORDER BY total_sold DESC;
d.
SELECT product_name, COUNT(*) AS return_count
FROM returns_data
GROUP BY product_name
ORDER BY return_count DESC;
e.
SELECT product_name, COUNT(*) AS return_count
FROM returns_data
WHERE state IN ('Washington', 'Oregon', 'Idaho', 'Montana')
GROUP BY product_name
ORDER BY return_count DESC
LIMIT 20;
2. Analyze the results of queries to identify specific information that can be presented in your summary.
A. Sales by region:
i. Analyze sales data by state to determine where the company has the largest customer base.
From the analysis of sales data by state, we found that the company has the largest customer base
in California, Texas, and New York. These states contribute significantly to the overall sales volume and indicate strong market presence.
ii. Analyze the data to determine the top three products sold in the United States.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Managment information system :
paper (minimum length) describing the following effects of management information systems on organizational functions:
Executive-level decision making;
The support levels of an organization: e.g., finance, human resources, marketing, sales; and
The production, distribution, and sales of product.
arrow_forward
A service provided delivering packages to a locker for customers to pick up at their convenience is an example of:
Question content area bottom
Part 1
A.
hybrid office.
B.
passive contact.
C.
active contact.
D.
front office.
arrow_forward
1) Create a business scenario/description.
2) Based on the business description created, construct an Order Processing flow chart that
is appropriate for the business.
arrow_forward
Matrix 15.1
Use this data in this matrix to answer the following questions.
Class <500 lb
50
55
60
65
70
77.5
85
92.5
100
34.3 28.32 24.25
36.94
30.5
26.12
39.59
32.69
27.99
41.94 34.64 29.66
44.64 36.86 31.56
48.1
51.9
55.89
60.27 49.77
O $1,074.50
O $21.49
Matrix of Weight Breaks and Freight Class ($/CWT)
500 lb 1,000 lb 2,000 lb 5,000 lb
Refer to Matrix 15.1. What is the cost to ship a 5,000 pound item in freight class 65?
O$107,450
10,000 lb 20,000 lb
23.04 17.58 15.74
10.47
24.82
18.93
17.41
11.58
26.6
20.29
19.08
12.69
21.49
28.18
20.27
13.48
22.88
29.99
21.94
14.59
23.85
15.86
24.65
32.32
39.72 34.01
26.6
34.87
36.7
26.24
17.45
18.87
37.56
28.38
28.64
30.89
30.77 20.46
42.61 40.5
O $5,000
42.86
46.15 39.52
arrow_forward
Pls help ASAP for both
arrow_forward
Assistance with the following please showing all working.
arrow_forward
Required information
Problem 9-2
[The following information applies to the questions displayed below.]
An air-conditioning repair department manager has compiled data on the primary reason for 41 service calls for the previous week, as shown in the table.
JobNumber
Problem/Customer Type
JobNumber
Problem/Customer Type
JobNumber
Problem/Customer Type
301
O/C
315
W/R
329
N/C
302
N/C
316
F/R
330
O/R
303
F/R
317
F/R
331
N/R
304
O/R
318
N/R
332
W/C
305
F/R
319
F/R
333
W/C
306
N/R
320
N/R
334
N/R
307
N/C
321
O/C
335
F/C
308
O/R
322
W/C
336
W/C
309
N/R
323
F/R
337
F/C
310
N/C
324
O/C
338
N/R
311
O/C
325
W/C
339
N/R
312
O/R
326
N/C
340
N/C
313
N/R
327
O/R
341
N/R
314
O/R
328
N/R
Key:
Problem type:
Customer type:
N
= Noisy
C
= Commercial customer
F
= Equipment failure
R
= Residential customer
W
= Runs warm
O
= Odor
Problem 9-2 Part a
a.
Using the data, prepare a check sheet for the problem…
arrow_forward
Working process of Transaction Processing System (TPS). ---Report
arrow_forward
Mangement question
Management is a series of continuous, inter-related functions with no pre-determined sequence’. Explain.
arrow_forward
This process is used in business or manufacturing to predict their future requirements
Select one:
a.
Plant Layout
b.
Capacity Study
c.
Forecast
d.
Scheduling
arrow_forward
Quesition no.2.5 related to manufacturing system. Automation and production system forth edition book chapter no.2 exercise quesition 2.5
arrow_forward
Exercise 8-37, 8-38, 8-39 & 8-40 (Static) (LO 8-2, 3, 5)
Skip to question
[The following information applies to the questions displayed below.]Pacific Ink had beginning work-in-process inventory of $744,960 on October 1. Of this amount, $304,920 was the cost of direct materials and $440,040 was the cost of conversion. The 48,000 units in the beginning inventory were 30 percent complete with respect to both direct materials and conversion costs.
During October, 102,000 units were transferred out and 30,000 remained in ending inventory. The units in ending inventory were 80 percent complete with respect to direct materials and 40 percent complete with respect to conversion costs. Costs incurred during the period amounted to $2,343,600 for direct materials and $3,027,840 for conversion.
Exercise 8-37 (Static) Compute Costs per Equivalent Unit: Weighted-Average Method (LO 8-3)
Required:
a. Compute the equivalent units for the materials and conversion cost calculations.
b.…
arrow_forward
please walk me step by step to solve the following in excel. thank you!!!
arrow_forward
Preview
File
Edit
View
Go
Tools
Window
Help
84%
t my.charlotte.edu
MBAD 6141 U90 SpringX
G According to Trevino ar X
B Weaver Chocolate Co. X
C Get Homework Help WiX
a Stevenson, W. J. - Operations management. (14th ed.). McGraw-Hill-Mcgraw-Hill (2021).pdf (page 576 of 929)
Search
6100
pur uay. 1 TIC Capacity 1or prodUCIng tic PTOGUCT IS U TWIIS Pur uay. Dulup COsis PIOU, anu stoTagt anu
202210-MBAD
handling costs are $5 per ton a year. The firm operates 200 days a year. (Note: 1 ton = 2,000 pounds.)
odf
a. How many bags per run are optimal?
Spring 2022
b. What would the average inventory be for this lot size?
c. Determine the approximate length of a production run, in days.
Extra
Асcount
Home
Zoom
d. About how many runs per year would there be?
Dashboard
21
Announcements
e. How much could the company save annually if the setup cost could be reduced to $25 per run?
Modules
vaccine and
other info
11. A company is about to begin production of a new product. The manager of the department…
arrow_forward
what is the specific software used for Tim Hortons CRM
arrow_forward
Solve all
arrow_forward
I need assistance with Homework question Chapter 21 Problem 2. I keep getting the calculations mixed up. Thank you.
arrow_forward
Complaints have come to the department manager regarding timeliness of requests for patient information and a decision must be made.
Three months ago, Community Hospital opened a 24-hour urgent-care center 10 miles away in a rapidly growing community. Kent Jones, the health information services manager, took part in the planning that included the use of a combined record and one patient identification number. The decision was made to allow electronic sharing of patient records between the facilities; however, at present it is necessary to fax some portions of the record upon request. In the past month, Kent has received four complaints from the urgent care center that records were not faxed in a timely manner.
There are 26 employees in health information services. Three full-time employees care for record activity during the day, with one employee devoted to record activity during the evening shift, when a team leader and four other employees are usually in the department. During the…
arrow_forward
Complaints have come to the department manager regarding timeliness of requests for patient information and a decision must be made.
Three months ago, Community Hospital opened a 24-hour urgent-care center 10 miles away in a rapidly growing community. Kent Jones, the health information services manager, took part in the planning that included the use of a combined record and one patient identification number. The decision was made to allow electronic sharing of patient records between the facilities; however, at present it is necessary to fax some portions of the record upon request. In the past month, Kent has received four complaints from the urgent care center that records were not faxed in a timely manner.
There are 26 employees in health information services. Three full-time employees care for record activity during the day, with one employee devoted to record activity during the evening shift, when a team leader and four other employees are usually in the department. During the…
arrow_forward
!
Required information
[The following information applies to the questions displayed below.]
The following are the car repair shop data:
Ticket No.
1
Work
Brakes
Ticket No.
11
Work
Lube & oil
Ticket No.
21
Work
Transmission
2
Brakes
12
Battery
22
Lube & oil
3
Tires
13
Tires
23
Tires
4
Brakes
14
Lube & oil
24
Lube & oil
5
Lube & oil
15
Brakes
25
Brakes
6
Lube & oil
16
Tires
26
Brakes
7
Battery
17
Lube & oil
27
Brakes
8
Lube & oil
18
Lube & oil
28
Lube & oil
9
Brakes
19
Brakes
29
Tires
10
Lube & oil
20
Tires
30
Battery
Click here for the Excel Data File
a. Prepare a check sheet for the above car repair shop data:
Work Type
Frequency
Brakes
Tires
Lube & oil
Battery
Transmission
Total
0
arrow_forward
Lights Incorporated calculates cost for an equivalent unit of production using the weighted-average method. Data for July: Work-in-process inventory, July 1 (35,000 units): Direct materials (97% completed) Conversion (46% completed) Balance in work in process inventory, July 1 Units started during July Units completed and transferred Work-in-process inventory, July 31: Direct materials (97% completed) Conversion (46% completed) Cost incurred during July: Direct materials Conversion costs $ 122,950 77,400 $ 200,350 86,000 95,900 25,100 $ 185,500 266,000 The cost of goods completed and transferred out under the weighted-average method is calculated to be: (Round your Intermediate calculations to 2 decimal places and final answer to the nearest whole dollar amount.) Multiple Choice $627,740. $553,343. $578,840. $102,946. $569,680.
arrow_forward
Please respond I need the answer in 10 minutes. The scenario and Use Case diagram below describes a Medical Practice Management system in a doctor’s office. The receptionists, nurses, and doctors use the system.
Six use case modeling errors were made on the diagram. Identify the errors that have been made and motivate why it is an error.
arrow_forward
I need to do an essay about compare and contrast of The Yellow Wallpaper and The Story of an Hour?
arrow_forward
please answer in 30 mins.
arrow_forward
How would you manually write a mathematical model this?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Related Questions
- Managment information system : paper (minimum length) describing the following effects of management information systems on organizational functions: Executive-level decision making; The support levels of an organization: e.g., finance, human resources, marketing, sales; and The production, distribution, and sales of product.arrow_forwardA service provided delivering packages to a locker for customers to pick up at their convenience is an example of: Question content area bottom Part 1 A. hybrid office. B. passive contact. C. active contact. D. front office.arrow_forward1) Create a business scenario/description. 2) Based on the business description created, construct an Order Processing flow chart that is appropriate for the business.arrow_forward
- Matrix 15.1 Use this data in this matrix to answer the following questions. Class <500 lb 50 55 60 65 70 77.5 85 92.5 100 34.3 28.32 24.25 36.94 30.5 26.12 39.59 32.69 27.99 41.94 34.64 29.66 44.64 36.86 31.56 48.1 51.9 55.89 60.27 49.77 O $1,074.50 O $21.49 Matrix of Weight Breaks and Freight Class ($/CWT) 500 lb 1,000 lb 2,000 lb 5,000 lb Refer to Matrix 15.1. What is the cost to ship a 5,000 pound item in freight class 65? O$107,450 10,000 lb 20,000 lb 23.04 17.58 15.74 10.47 24.82 18.93 17.41 11.58 26.6 20.29 19.08 12.69 21.49 28.18 20.27 13.48 22.88 29.99 21.94 14.59 23.85 15.86 24.65 32.32 39.72 34.01 26.6 34.87 36.7 26.24 17.45 18.87 37.56 28.38 28.64 30.89 30.77 20.46 42.61 40.5 O $5,000 42.86 46.15 39.52arrow_forwardPls help ASAP for botharrow_forwardAssistance with the following please showing all working.arrow_forward
- Required information Problem 9-2 [The following information applies to the questions displayed below.] An air-conditioning repair department manager has compiled data on the primary reason for 41 service calls for the previous week, as shown in the table. JobNumber Problem/Customer Type JobNumber Problem/Customer Type JobNumber Problem/Customer Type 301 O/C 315 W/R 329 N/C 302 N/C 316 F/R 330 O/R 303 F/R 317 F/R 331 N/R 304 O/R 318 N/R 332 W/C 305 F/R 319 F/R 333 W/C 306 N/R 320 N/R 334 N/R 307 N/C 321 O/C 335 F/C 308 O/R 322 W/C 336 W/C 309 N/R 323 F/R 337 F/C 310 N/C 324 O/C 338 N/R 311 O/C 325 W/C 339 N/R 312 O/R 326 N/C 340 N/C 313 N/R 327 O/R 341 N/R 314 O/R 328 N/R Key: Problem type: Customer type: N = Noisy C = Commercial customer F = Equipment failure R = Residential customer W = Runs warm O = Odor Problem 9-2 Part a a. Using the data, prepare a check sheet for the problem…arrow_forwardWorking process of Transaction Processing System (TPS). ---Reportarrow_forwardMangement question Management is a series of continuous, inter-related functions with no pre-determined sequence’. Explain.arrow_forward
- This process is used in business or manufacturing to predict their future requirements Select one: a. Plant Layout b. Capacity Study c. Forecast d. Schedulingarrow_forwardQuesition no.2.5 related to manufacturing system. Automation and production system forth edition book chapter no.2 exercise quesition 2.5arrow_forwardExercise 8-37, 8-38, 8-39 & 8-40 (Static) (LO 8-2, 3, 5) Skip to question [The following information applies to the questions displayed below.]Pacific Ink had beginning work-in-process inventory of $744,960 on October 1. Of this amount, $304,920 was the cost of direct materials and $440,040 was the cost of conversion. The 48,000 units in the beginning inventory were 30 percent complete with respect to both direct materials and conversion costs. During October, 102,000 units were transferred out and 30,000 remained in ending inventory. The units in ending inventory were 80 percent complete with respect to direct materials and 40 percent complete with respect to conversion costs. Costs incurred during the period amounted to $2,343,600 for direct materials and $3,027,840 for conversion. Exercise 8-37 (Static) Compute Costs per Equivalent Unit: Weighted-Average Method (LO 8-3) Required: a. Compute the equivalent units for the materials and conversion cost calculations. b.…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,