Hint(s) Check My Work Spreadsheet A firm is evaluating the alternative of manufacturing a part that is currently being outsourced from a supplier. The relevant information is provided below: For in-house manufacturing: Annual fixed cost = $95,000 Variable cost per part = $110 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 manufacture in-house 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 Hide Feedback