can someone help me on this homework 

 

 

 

Strategic Planning for Wy’East Coffee (50 pts)

 

 

Analyzing Some Data

          A good friend of yours, Madeline, owns a small, rather successful coffee shop near center campus.  She has gathered some data in an Excel spreadsheet over the past week and now wants to analyze this data to see if it is worth it to open a coffee shop near South campus.

          You meet with Madeline, over coffee, and she explains what she wants the program to do.  She would like you to write a program that will do the following:

 Determine the total sales by zip code.  She wants to enter a zip code (48088, 48093, 48066 or 48026) and then see what the total sales were for that zip code.

 Determine the total sales by coffee type.  She wants to be able to enter a coffee type (mocha, latte, regular, decaf or caramel) and see how much money each type produced.

 Determine the grand total.  She wants to see how much money was made for all 4 zip codes and all 5 types of coffee.

 Determine which coffee type sold the most in a particular zip code.  She wants to enter the zip code and then be told which coffee type sold the most and made the most money.

 Determine which zip code sold the most given a particular coffee type.  She wants to enter a coffee type and then see which zip code sold the most and the amount of money that was made.

     The menu below lists the menu and pricing.  All of her coffee is one size, 16 oz. 

           

     Finally she gives you a copy of the Excel spreadsheet with her current sales.

 

     She likes menus and doesn’t want to do a lot of typing in order to run the program.

Program Requirements

     Your program will need to do the following:

 Feature a menu so that all you need to do is enter a letter and the program will perform the necessary task.  Use the following letters to correspond to what the program needs to do:

           

 

 Allow you to pick numerous tasks before you are done with the program.  HINT:  you will need a loop here.

 Load all arrays with data when the program loads.  In other words, you will not get prompted to load these values separately.  Instead you will initialize your arrays with these numbers at the beginning of the program.

 Nice clean output.

 Utilization of modular programming.  At the minimum you should have 5 modules counting the main module as one of them.  

Some Help with the Logic

          Start your analysis of inputs and outputs.  Write a problem statement and create a list of your variables.  Try to figure out what variables will go in what module.  Create a 30,000 foot view and write pseudocode for each module.  Remember that pseudocode should not look like working code.  Copied and pasted working Python code into a text file will give you 0 points for the pseudocode portion of this assignment.

Time to Code

          Once you have planned your attack you can start to code.  Write each module separate from each other.  Write a module and then test it.  Don’t go on to the next module until the one you are coding works.  Finally be watchful of how lists behave in Python.  Remember that lists are by reference parameter passes and not by value.

 Remember the proper flow of a program è declare variables at the top, fill the variables, process the variables and print out the variables

 Choose good variable names.  These are not too long but descriptive.

 Take care with your output.  This does need to make sense.

 Don’t forget your comments!  Points will be deducted.

 Since this program is a little longer than your lab programs, test as you go.  If you type all of your code in and then test at the end, your debugging will last longer.

           

           

          Once you have your code typed in, using the test data above, test your program.  My output looked like the following when I entered Z and 48026 for the zip code:

 

     My output when I selected C and C for Caramel

 

 

     My output when I select G

 

 

My output when I select HZ and 48088 for the zip code

 

 

     My output when I selected HC and D for decaf

 

          Try to get your program to look as much like mine as you can.  Utilize the format function and the tab character to line your output up. 

 

Page 1 of 4Homework # 4 Guidesheet ~ Strategic Planning for Wy’East Coffee (50 pts)Analyzing Some DataA good friend of yours, Madeline, owns a small, rather successful coffee shop near center campus.She has gathered some data in an Excel spreadsheet over the past week and now wants to analyze thisdata to see if it is worth it to open a coffee shop near South campus.You meet with Madeline, over coffee, and she explains what she wants the program to do.She wouldlike you to write a program that will do the following:Determine the total sales by zip code.She wants to enter a zip code (48088, 48093, 48066 or48026) and then see what the total sales were for that zip code.Determine the total sales by coffee type.She wants to be able to enter a coffee type (mocha,latte, regular, decaf or caramel) and see how much money each type produced.Determine the grand total.She wants to see how much money was made for all 4 zip codes andall 5 types of coffee.Determine which coffee type sold the most in a particular zip code.She wants to enter the zipcode and then be told which coffee type sold the most and made the most money.Determine which zip code sold the most given a particular coffee type.She wants to enter a coffeetype and then see which zip code sold the most and the amount of money that was made.The menu below lists the menu and pricing.All of her coffee is one size, 16 oz.ItemPriceCafé Mocha$3.50Café Latte$4.00Café Regular$2.50Café’ Regular Decaf$2.50Café Caramel$4.50Finally she gives you a copy of the Excel spreadsheet with her current sales.She likes menus and doesn’t want to do a lot of typing in order to run the program.Program RequirementsYour program will need to do the following:Feature a menu so that all you need to do is enter a letter and the program will perform thenecessary task.Use the following letters to correspond to what the program needs to do:

• 1494053503-HW4CoffeSalesAnalysisGuidesheetFall16.pdf

ComputerScienceExpert

(11)

Status NEW Posted 06 May 2017 06:05 AM My Price 11.00

-----------

Attachments

file 1494053505-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer