l. Schmaltz, Ltd. produces a variety of specialty beverages. One of its products is made in a separate facility for which monthly rent, administrative costs, and equipment leasing is $80,000. The facility has a monthly capacity of 50,000 cases of the specialty beverage. Eight workers handle production and shipping. Each receives salary and fringe benefits of $2,500 per month. Packaging and distribution costs are $0.30 per case, and ingredients cost $1.10 per case. The product is sold for $5.39 a case. Determine the following: (a) Construct Cost (C), Revenue (R), and Prot (P) functions for Sehmaltz in terms of x, the number of cases produced. (b) How many cases must Schmaltz make and sell to break even? (e) What is Schmaltz's breakeven point (BEP) in dollars? (d) What would be the prot when 40,000 cases are made and sold? (e) Make a drawing by hand showing a graph of Sehmaltz's cost, revenue, and prot functions, and identify the break even point. (f) Set up an Excel model for this problem, and use Goal Seek to nd the BEP. (please follow below instruction) For problem 1 (f), please submit a copy of an Excel spreadsheet, formatted like the one below. To get this layout with the gridlines and the row and column labels, do the following. In Excel, select File then select Page Setup ... Click on the tab labeled Sheet. Click on the check boxes for Gridlines and Row and column headings. To check that it looks right before you print, click on Print Preview. If it looks ok then click Print. Attach this as the last page of your assignment.A B A B A #1. Schmaltz Name & ID# 2 Fixed costs 3 Unit cost 4 Selling price 5 6 Units sold 7 8 Total cost 9 Total revenue 10 Profit 11