a program that allows you to view and edit the sales amounts for each month of the current year. Example   COMMAND MENU add   - Add sales for specified month view   - View sales for specified month edit   - Edit sales for specified month totals - View sales summary for year exit   - Exit program

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

Monthly Sales

Create a program that allows you to view and edit the sales amounts for each month of the current year.

Example

 
COMMAND MENU
add   - Add sales for specified month
view   - View sales for specified month
edit   - Edit sales for specified month
totals - View sales summary for year
exit   - Exit program
 
Command: add
Three-letter Month: jan
Sales Amount: 10317
Sales amount for Jan is 10,317.00.
 
 
Command: add
Three-letter Month: feb
Sales Amount: 15293
Sales amount for Jan is 15,293.00.
 
 
Command: view
Three-letter Month: jan
Sales Amount: 14317
Sales amount for Jan is 14,317.00.
 
 
Command: edit
Three-letter Month: jan
Sales amount for Jan is 14,317.00.
 
 
Command: totals
Yearly total:         29,610.00
Monthly average:       14,805.00
 
Command: view
Three-letter Month: july
Invalid three-letter month.
 
Command: exit
Bye!

Specifications

  • The program should use a list to store the sales data for each month with the three-letter abbreviation for the month (Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, and Dec) as the key for each item.
  • When the program starts, it should read the sales data inserted from the user.
  • If the user edits the sales data, the program should edit the data  (review slide 45 for calculate total function example).
  • Has to be in c++
  • Has to use ALL commands : add,edit,exit,totals, and view
  • If the user selects total, the program should calculate the total sales and average monthly sales.
  • Use functions to view sales, edit sales, calculate total, and calculate average.
Expert Solution
Step 1

def readFile():

    sale={}

    file=open("monthly_sales.txt")

    for line in file:

        l=line.split("\t")

        sale[l[0]]=int(l[1])

    file.close()

    return sale

 

def writeFile(d):

    file=open("monthly_sales.txt", 'w')

    for k, v in d.items():

        file.write(k)

        file.write("\t")

        file.write(str(v))

        file.write("\n")

    file.close

 

 

d=readFile()

 

 

print("Monthly Sales program\n")

print("COMMAND MENU")

print("view\t- View sales for specified month")

print("edit\t- Edit sales for specified month")

print("totals\t- View sales summary for year")

print("exit\t- Exit pogram")

 

 

while True:

 

    command=input("\nCommand: ")

 

    command=command.lower()

    if command=='view':

        mon=input("Three-letter Month: ")

        monupper=mon.upper()

 

        if len(mon)!=3:

            print("Inavlid three-letter month.")

        else:

 

            for k, v in d.items():

 

                if monupper==k:

                    print(f"Sales amount for {mon} is {v:0.2f}.")

                    break

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

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