please help solve

Question 2012 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 $75,000 Variable cost per part 5100 For purchasing from supplier: Purchase price per part - $190 a. If demand is forecast to be 2,000 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 productions Total cost of outsourcing: 5 The best decision is to Select 1. The marketing department forecasts that the upcoming year's demand will be 2,000 parts. A new supplier offers to make the parts for 5186 cach. Should the company accept the offer? Use the break-even Excel template. Roundlyour answer to the nearest whole number. New total cost of outsourcing: 5 The best decision is to What is the maximum price per part the manufacturer should be willing to pay to the supplier if the forecast is 2,000 parts? Round your answer to the nearest cent. $