Brain Up, Brain On, Brew Up Some Money ! The Brewery Base Case \"Witches Brew" Professor Peter wants to start a new brewing business in NYC (He prefers Fiji, Tahiti or some ether South Pacific spot but his he is shackled by the global pandemic to heme and also loves working with his college students]. Mayer understands that his fixed cost will include: capital equipment. a brewer's permit and a single royalty payment for the famous recipe. He believes that the total fixed costs would be roughly 1 million US Dollars. He is not certain who he will pay the royalty payment to. Howeyer, he also understands that his variable cost includes: Packaging (cans. bottles, labels and bottle caps but not the bottling equipment). employee wages, water. utilities, and the main ingredients like barley. hops, yeast and coffee [It's really a modified German beer 6% ABM). #1} Peter has run many mathematical models that list the cost of the ingredients and hours required to produce this product. After many hours and many Coffee Beers he is convinced that he can not only sell the product for $200 per barrel (a common unit of measure within the industry) but that his cost per unit would be just around $?5 to produce. How many units does Professor Peter need to brew\"? (SHOW YOUR WORK in MICROSOFT EXCEL CREATE A TAB CALLED BASE CASE) This is your first calculation. #2} Now that you have successfully consulted Prof. Mayer about the amount of beer that he will need to produce before making money. he has also told you that he wants to ensure that he (himself) wants to take an annual salary [before taxes of course] of 2?5,DDD dollars per year. This is NOT negotiable after all aren't we supposed to make some money? (Again, in Microsoft Excel show your work. Create a second tab called with 250 K