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

 

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%
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Table
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education