Homework # 4 ~ Strategic Planning for Wy’East Coffee solve it on pyhon
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
1 answer
1 answer