Formula to calculare the total sales amount of the customer name HORSHOE INCORPORATED. Note: This excel worksheet goes up to row 1699! Thanks.
Formula to calculare the total sales amount of the customer name HORSHOE INCORPORATED. Note: This excel worksheet goes up to row 1699! Thanks.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
Formula to calculare the total sales amount of the customer name HORSHOE INCORPORATED. Note: This excel worksheet goes up to row 1699! Thanks.
Transcribed Image Text:1 ales_ID
1586 S1585
1587 S1586
1588 S1587
1589 S1588
1590 S1589
1591 S1590
1592 S1591
1593 S1592
1594 S1593
1595 S1594
1596 S1595
1597 S1596
1598 S1597
1599 S1598
1600 S1599
1601 S1600
1602 S1601
1603 S1602
1604 S1603
1605 S1604
1606 S1605
1607 S1606
1608 S1607
1609 S1608
1610 S1609
1611 S1610
1612 S1611
1613 S1612
1614 S1613
Ready
Sales_Date
2021-11-19
2021-11-19
2021-11-20
2021-11-20
2021-11-20
2021-11-21
2021-11-22
2021-11-22
2021-11-22
2021-11-22
2021-11-22
2021-11-22
2021-11-22
2021-11-23
2021-11-23
2021-11-23
2021-11-23
2021-11-24
2021-11-24
2021-11-24
2021-11-24 Wheels on Coast
2021-11-24 Wheels on Coast
2021-11-25 Riders Ltd.
2021-11-25 Bikes for Likes
2021-11-26 OffRoad Vehicles
2021-11-26 Crestfallen
2021-11-26 Bikes for Likes
2021-11-26 Riders Ltd.
2021-11-27 Motorcross Events
Inventory Data
Customer_Name
Bikes for Likes
Motorcross Events
OffRoad Vehicles
Riders Ltd.
Seed
Motorcross Events
OffRoad Vehicles
Motorcross Events
Riders Ltd.
Horshoe Incorporated
Riders Ltd.
**************
Motorcross Events
OffRoad Vehicles
Bikes for Likes
Horshoe Incorporated
Horshoe Incorporated
Horshoe Incorporated
X Games
Riders Ltd.
Horshoe Incorporated
Motorcross Events
Sales Data
Accessibility: Investigate
Item_ID
A1340
$
A1122
$
A1312
$
A1174
$
A1898
$
A1654 $
A1383 $
A1823 $
A1897 $
A1211 $
A1184 $
A1467 $
A1384 $
A1094 $
A1309 $
A1762 $
A1724 $
A1932 $
A1296 $
A1798 $
A1373 $
A1726 $
A1778 $
A1293 $
A1460 $
A1864 $
A1662 $
A1324 $
A1117 $
+
Aging Group
Sales_Amount
89,275
86,562
17,494
57,077
59,551
76,223
36,604
91,013
86,478
94,395
57,832
30,386
79,013
21,861
34,620
64,966
92,879
38,631
46,163
28,151
88,530
22,183
6,325
27,776
77,110
98,042
95,276
85,002
Payment_Date
2021-12-18
2021-11-27
2021-12-20
2021-12-09
2021-12-08
2021-12-17
2021-12-29
2021-12-25
2021-12-17
2021-11-28
2021-12-15
2021-12-17
2021-12-22
2021-12-11
2021-12-09
2021-12-07
2021-12-05
2021-12-09
2021-12-08
2021-12-11
2021-12-02
2021-12-08
Appear in A/R
at 2020-12-31
Appear in A/R
at 2021-12-31
17,494
59,551
94,395
57,832
6,325
85,002
17,099
Number of Days
from Sales Date
to 2021-12-31
41
41
88
39
39
36
35
34
Aging Category
Overdue 1-30 days
Overdue 1-30 days
Overdue 1-30 days
Overdue 1-30 days
Overdue 1-30 days
Overdue 1-30 days
Overdue 1-30 days
B
Sales_Year
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
2021
Item
Engine
Brakes
Brakes
Brakes
Tire
Radio
Brakes
Engine
Tire
Brakes
Radio
Tire
Brakes
Tire
Seats
Radio
Brakes
Brakes
Brakes
Brakes
Radio
Tire
Tire
Seats
Engine
Engine
Brakes
Engine
Seats
135%
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education