For Requirement 1b, use Goal Seek (under What-If analysis in Excel) to calculate the three maximum prices that give net present values and internal rates of returns that equal those of the corresponding outsource alternatives. The CEO will use the ''Purchase cost per panel'' information from the Requirement 1b table to negotiate with the solar panels manufacturer. When the negotiations are finished, the senior management accountant will use that information to update your financial model and business case