Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help on part 5.5 thank you! h Question 5.1. Suppose that Brandwein's Bagels have ready to sell 23 plain bagels, 17 everything bagels, 12

image text in transcribedimage text in transcribed please help on part 5.5 thank you!image text in transcribedh

Question 5.1. Suppose that Brandwein's Bagels have ready to sell 23 plain bagels, 17 everything bagels, 12 wheat everything bagels, 19 sesame bagels, and 7 onion bialy. Create a table that contains this information. It should have two columns: menu item and count . Assign the new table to the variable Brandweins. Brandweins = Brandweins_sales. select("count", "menu item") Brandweins Question 5.2. The file Brandweins_sales.csv contains the number of menu items sold over a brief period of time from each type of menu item in the Brandweins table. Brandweins_sales.csv has an extra column called "price per menu item (\$)". Load these data into a table called Brandweins_sales. Brandweins_sales = Table. read_table( 'Brandweins_sales.csv') Brandweins_sales Question 5.4. What was the total revenue (the total price of all menu items sold) in the Brandweins_sales table? Assign this value to total_revenue . total_revenue =((9)2)+((14)2)+((6)2)+((13)2)+((3)2.5) total_revenue 91.5 Question 5.5. Make a new table called remaining_inventory . It should have the same rows and columns as Brandweins , except that the amount of menu items sold for each menu item should be subtracted from that menu item's original count, so that the count is the amount of menu items remaining. Question 5.4. What was the total revenue (the total price of all menu items sold) in the Brandweins_sales table? Assign this value to total_revenue . total_revenue =((9)2)+((14)2)+((6)2)+((13)2)+((3)2.5) total_revenue 91.5 Question 5.5. Make a new table called remaining_inventory . It should have the same rows and columns as Brandweins , except that the amount of menu items sold for each menu item should be subtracted from that menu item's original count, so that the count is the amount of menu items remaining

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

Advances In Spatial And Temporal Databases 11th International Symposium Sstd 2009 Aalborg Denmark July 8 10 2009 Proceedings Lncs 5644

Authors: Nikos Mamoulis ,Thomas Seidl ,Kristian Torp ,Ira Assent

2009th Edition

3642029817, 978-3642029813

More Books

Students also viewed these Databases questions

Question

322 Prove by Induction 8 7n 6 is divisible by

Answered: 1 week ago