Question: Create a program that displays 12 months of sales data, calculates the total yearly sales and average monthly sales, and allows the user to edit

Create a program that displays 12 months of sales data, calculates the total yearly sales and average monthly sales, and allows the user to edit the sales for any month.

Monthly Sales program

COMMAND MENU

monthly - View monthly sales yearly - View yearly summary edit - Edit sales for a month exit - Exit program

Command: monthly Jan - 616

Feb - 466

Mar - 796

Apr - 238

May - 310

Jun - 726

Jul 987

Aug - 604

Sep - 951

Oct - 958

Nov - 238

Dec - 610

Command: yearly

Yearly total: 7500

Monthly average: 625

Command: edit

Three-letter Month: Noc

Invalid three-letter month.

Command: edit

Three-letter Month: Nov Sales Amount: 354

Sales amount for Nov was modified.

Command: exit Bye!

Console

Specifications

  • Store the month sales in a list of lists at the beginning of the main method.

monthlySales = [['Jan', '616'], ['Feb', '466'], ['Mar', '796'], ['Apr', '238'],

['May', '310'], ['Jun', '726'], ['Jul', '987'], ['Aug', '604'],

['Sep', '951'], ['Oct', '958'], ['Nov', '238'], ['Dec', '610']]

  • Create functions for the monthly, yearly, and edit commands. The functions will take the sales list as an input parameter. Call each function from an if statement in the main method.
  • The yearly function will dynamically calculate the average based on the total of all sales values in the list and the length of the list. Round the results of the monthly average to a maximum of 2 decimal digits. Formatting is not required.
  • The edit function will ask the user for the three-letter month and sales value and make a simple list of these two values. This simple new list will replace the current single month list in the sales list.
  • For the edit function, display an error message if the user doesnt enter a valid three-letter abbreviation for the month. Use the following list as the standard abbreviations.

months = ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec']

python

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!