A grocery sells following product, namely: Instant noodle, Cooking oil, Rice, Sugar, Egg and Milk. The following data shows the item being sold within a year (12 months). Cooking Oil Rice [kg] [liter] Month Instant Sugar [kg] Egg [item] Milk [liter] Noodle [item] January February 45 55 56 45 100 34 43 57 60 40 122 30 March 40 58 53 35 134 32 April 56 70 24 28 156 45 May 30 80 35 40 166 40 June 38 78 39 43 165 49 July August September 40 70 45 48 164 50 35 76 44 49 167 52 36 77 43 50 164 55 October 20 85 59 50 167 55 November 21 90 65 52 168 53 December 15 106 87 59 190 53 The unit price of those items is following: Instant noodle 2,500 IDR/item, Cooking oil 10,000 IDR/liter, Rice 7,500 IDR/kg, Sugar 10,000 IDR/liter, Egg 2,000 IDR/item and Milk 15,000 IDR/liter. Develop a Python program to perform the following tasks: a. Calculate the total income for the whole year b. Define which product produces the highest income and when it happens c. Plot the income/month from each product in one graph and show the point of highest income with an arrow and annotation of "Highest Income"

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

Use Python

A grocery sells following product, namely: Instant noodle, Cooking oil, Rice, Sugar, Egg and Milk.
The following data shows the item being sold within a year (12 months).
Cooking Oil
(liter]
Month
Instant
Rice [kg]
Sugar (kg] Egg [item] Milk [liter]
Noodle
[item]
January
February
45
55
56
45
100
34
43
57
60
40
122
30
March
40
58
53
35
134
32
April
Мay
56
70
24
28
156
45
30
80
35
40
166
40
June
38
78
39
43
165
49
July
August
September
40
70
45
48
164
50
35
76
44
49
167
52
36
77
43
50
164
55
October
20
85
59
50
167
55
November
21
90
65
52
168
53
December
15
106
87
59
190
53
The unit price of those items is following: Instant noodle 2,500 IDR/item, Cooking oil 10,000
IDR/liter, Rice 7,500 IDR/kg, Sugar 10,000 IDR/liter, Egg 2,000 IDR/item and Milk 15,000
IDR/liter. Develop a Python program to perform the following tasks:
a. Calculate the total income for the whole year
b. Define which product produces the highest income and when it happens
c. Plot the income/month from each product in one graph and show the point of highest income
with an arrow and annotation of "Highest Income"
Transcribed Image Text:A grocery sells following product, namely: Instant noodle, Cooking oil, Rice, Sugar, Egg and Milk. The following data shows the item being sold within a year (12 months). Cooking Oil (liter] Month Instant Rice [kg] Sugar (kg] Egg [item] Milk [liter] Noodle [item] January February 45 55 56 45 100 34 43 57 60 40 122 30 March 40 58 53 35 134 32 April Мay 56 70 24 28 156 45 30 80 35 40 166 40 June 38 78 39 43 165 49 July August September 40 70 45 48 164 50 35 76 44 49 167 52 36 77 43 50 164 55 October 20 85 59 50 167 55 November 21 90 65 52 168 53 December 15 106 87 59 190 53 The unit price of those items is following: Instant noodle 2,500 IDR/item, Cooking oil 10,000 IDR/liter, Rice 7,500 IDR/kg, Sugar 10,000 IDR/liter, Egg 2,000 IDR/item and Milk 15,000 IDR/liter. Develop a Python program to perform the following tasks: a. Calculate the total income for the whole year b. Define which product produces the highest income and when it happens c. Plot the income/month from each product in one graph and show the point of highest income with an arrow and annotation of "Highest Income"
Expert Solution
steps

Step by step

Solved in 2 steps with 7 images

Blurred answer
Knowledge Booster
Introduction to computer system
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