Small store dashboard. Store Sales Departments Jan Feb march April May June $1,800 Grocery meat $1,700 $4,650 $1,700 $1,990 $2,000 $1,150 $2,050 $1,100 $1,200 $1,120 $920 Produce $1,500 $1,200 $1,800 $1,720 $1,600 $1,130 $880 $1,020 $790 $800 $8170 81,090 Bakery Deli Clothing $1,700 $1,710 $9.00 $1,300 $1,000 $900 $1,100 $1,010 $1,200 $1,070 $1,150 $1,180 Pharmacy $1,730 $1,800 $1,120 $1,700 $1,960 $1,220 Gm $1,200 $1,900 $1,250 $1,900 $1,600 86700

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

Develop the dashboard below and create graphs 

## Small Store Dashboard: Store Sales

### Monthly Sales Data by Department

Below is a table representing the sales data for a small store from January to June. Each department's monthly sales figures are in dollars.

| **Departments** | **Jan** | **Feb** | **March** | **April** | **May** | **June** |
|-----------------|---------|---------|-----------|-----------|---------|----------|
| Grocery         | $1,700  | $4,650  | $1,700    | $1,990    | $2,000  | $1,800   |
| Meat            | $1,150  | $2,050  | $1,100    | $1,200    | $1,120  | $920     |
| Produce         | $1,800  | $1,720  | $1,600    | $1,130    | $1,500  | $1,200   |
| Bakery          | $880    | $1,020  | $790      | $900      | $870    | $1,090   |
| Deli            | $1,700  | $1,710  | $900      | $1,300    | $1,000  | $900     |
| Clothing        | $1,100  | $1,010  | $1,200    | $1,070    | $1,150  | $1,180   |
| Pharmacy        | $1,730  | $1,800  | $1,120    | $1,700    | $1,960  | $1,600   |
| General Merchandise (GM) | $1,200 | $1,900 | $1,250 | $1,900 | $1,220 | $1,700 |

### Notes:
- The **Grocery** department experienced a significant spike in sales in February ($4,650) but returned to average levels in the following months.
- **Meat** department shows variability, with the highest sales of $2,050 in February and the lowest sales of $920 in June.
- **Produce** department sales fluctuate moderately, peaking in May at $1,500.
- The **Bakery** department sees its highest sales in June ($1,090), whereas March had the lowest sales ($790).
-
Transcribed Image Text:## Small Store Dashboard: Store Sales ### Monthly Sales Data by Department Below is a table representing the sales data for a small store from January to June. Each department's monthly sales figures are in dollars. | **Departments** | **Jan** | **Feb** | **March** | **April** | **May** | **June** | |-----------------|---------|---------|-----------|-----------|---------|----------| | Grocery | $1,700 | $4,650 | $1,700 | $1,990 | $2,000 | $1,800 | | Meat | $1,150 | $2,050 | $1,100 | $1,200 | $1,120 | $920 | | Produce | $1,800 | $1,720 | $1,600 | $1,130 | $1,500 | $1,200 | | Bakery | $880 | $1,020 | $790 | $900 | $870 | $1,090 | | Deli | $1,700 | $1,710 | $900 | $1,300 | $1,000 | $900 | | Clothing | $1,100 | $1,010 | $1,200 | $1,070 | $1,150 | $1,180 | | Pharmacy | $1,730 | $1,800 | $1,120 | $1,700 | $1,960 | $1,600 | | General Merchandise (GM) | $1,200 | $1,900 | $1,250 | $1,900 | $1,220 | $1,700 | ### Notes: - The **Grocery** department experienced a significant spike in sales in February ($4,650) but returned to average levels in the following months. - **Meat** department shows variability, with the highest sales of $2,050 in February and the lowest sales of $920 in June. - **Produce** department sales fluctuate moderately, peaking in May at $1,500. - The **Bakery** department sees its highest sales in June ($1,090), whereas March had the lowest sales ($790). -
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Project Roles
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
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