Spreadsheet A university currently has a recycling program for paper waste. The fixed cost of running this program is $15,000 per year. The variable cost for picking up and disposing of each ton of recyclable paper is $30. If the work is outsourced to a recycling company, the cost would be $50 per ton. a. If the forecasted demand is 950 tons, what should the university do? Use the Break Even Excel template to find your answer. Round your answers to the nearest dollar Total cost of doing the job in-house: $ Total cost of outsourcing the job: $ So the best decision for the university is to select- for a savings of b. Find the break even point using the Excel Goal Sook tool. Round your answer to the nearest whole number tons t Answered A firm is evaluating the alternative of manufacturing a part that is currently being outsourced from a supplier. The relevant information is below For in-house manufacturing: Annual fixed cost = $100,000 Variable cost per part = $130 For purchasing from supplier: Purchase price per part = $150 a. For this information, use the Break-Even Excel template to find the best decision if the demand is 3,500. Round your answers to the nearest dollar Total cost of production: $ Total cost of outsourcing: $ The best decision is to -Select- b. Determine the break-even quantity for which the firm would be indifferent between manufacturing the part in-house or outsourcing it. Use the Excel Goal Seek tool. Round your answer to the nearest whole number parts The Davis national drugstore chain prefers to operate one outlet in a town that has four major market segments. The number of potential customers in each segment, along with the coordinates are as follows: Location Market Coordinates Number of Segment X y Customers 1 3 19 1,600 2 11 800 3 1,500 4 18 3 3,300 Find the best location using the Center of Gravity. Excel template. Round your answers to two decimal places. C. 21 3 Choose the correct graph representing the center of gravity The correct graphis -Select- A Center of Gravity y Coordinate Center of Gravity y- Coordinate 25 25 20 20 15 15 10 10 5 5 10 15 20 Coordinate 10 25 20 Coordinate A. . Center of Gravity y- Coordinate Center of Gravity y- Coordinate 25 25 20 20 15 15- 10 10+ 5 UN 5 25 10 20 10 15 20 X- Coordinate 25 15 *- Coordinate C. D Center of Gravity y- Coordinate Center of Gravity y- Coordinate 25 25 20 20 . . 15 15 10+ 10 5 5 e S 25 10 15 20 X- Coordinate 25 10 15 20 - Coordinate