Answered step by step
Verified Expert Solution
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
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 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 remainingStep 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