2 . 7 D 19 30 11 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 $90,000 Variable cost per part - $160 For purchasing from supplier: Purchase price per part - $180 a. If demand is forecast to be 5,500 parts, should the firm make the part in-house or purchase it from a supplier? Use the Break Even Excel template. Round your answers to the nearest whole number. Total cost of production: $ O Total cost of outsourcing: $ The best decision is to-Select- b. The marketing department forecasts that the upcoming year's demand will be 5,500 parts. A new supplier offers to make the parts for $176 each. Should the company accept the offer? Use the Break-Even Excel template. Round your answer to the nearest whole number. New total cost of outsourcing: $ The best decision is to Select What is the maximum price per part the manufacturer should be willing to pay to the supplier if the forecast is 5,500 parts? Round your answer to the nearest cent 12 113 44 DO 45 46. 47 . 18 49 5 SO