2. A company has established a project team to identify a location for a new manufacturing facility. Use a weighted scoring model to analyze three candidate locations (A, B, C) for setting up the new factory. The relative weights for each criterion are shown in the following table. A score of 1 represents unfavorable, 2 satisfactory, and 3 favorable. Location Category Labor costs Labor productivity202 Labor supply Union relations Material supply Transport costs Infrastructure Weight ABC 20 31 10 10 10 25 3. Compare your answer in Problem 2 to the answer you would have found if you had used an unweighted, 0-1 scoring model. Assume that a score of 1 means does not qualify and a 2 or 3 means it does qualify. (Hint: build a 0-1 scoring model, using x, count the total) https://d2vlcm61l7u1fs.cloudfront.net/media%2F179%2F1793dedf-608d-448c-a2be-d70cf3eb9134%2FphpEgh11l.png

Schmaltx, 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 $50,000. Eight workers handle production and shipping. Each receives salary and fringe benefits of $2,000 per month. Packaging and distribution costs are $1.5 per case, and ingredients cost $3 per case. The product is sold for $9 a case. Determine the following: 1) Write an expression for the cost function, revenue function and profit function in terms of the number of cases of beverage produced, Q. (Assume there is no demand restriction on sales). 2) Find the break-even point algebraically. 3.) Formulate a spreadsheet model that will give the profit. Use the Excel goal seek command (Data > What-If-Analysis > Goal Seek) to calculate the break-even point in part a. 4.a) Using the above spread sheet model find the profit or loss if Schmaltx produces and sells 10,000 cases. 4.b) Using the above spread sheet model find the profit or loss if Schmaltx produces and sells 30,000 cases. 5.) Write an expression for the profit function in terms of demand (in cases) for the beverage (S) and the number of cases of beverage produced (Q). 5.a) Formulate a spreadsheet model that will find the profit. 5.b) Find the cases of beverage to be produced when S= 20,000 cases using the above spreadsheet model. 5.c) Find the cases of beverage to be produced when S= 10,000 cases using the above spreadsheet model.