Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

=+what kinds of policies and practices should be developed?

Answered: 1 week ago