A Computer software company wants to develop a new application. They could develop in$-$house $($which means they hire the software developers$)$ for $$50\mathrm{.}00/$hour and with a fixed cost of $$75,000$ for equipment. Or they could outsource the effort at $75\mathrm{.}00/$hour with no fixed costs. At this point they have not determined how many hours it will take to develop. However, they want to have an idea of the best route to take $($in$-$house or outsource$)$ after they plan the effort. Create the model to answer the following questions:

a$.$ If it takes $1,000$ hours what is the total cost to develop in$-$house and the total cost tooutsource the effort? What is the total cost savings, if any? Prepare a user$-$friendly spreadsheet model using formulas to support your answers.

b$.$ Create a one variable data table that will show the total costs savings from outsourcing vs$.$ in$-$house development from $0-15,000$ hours.

c$.$ Use Goal Seek to determine how many hours is the break$-$even point.