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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started