PLEASE COMPLETE WORK IN EXCEL SPREADSHEET ONLY. SHOW ALL FORMULAS/FUNCTIONS TO SHOW ANSWERS AND EXPLAIN TO ME HOW YOU GOT THE ANSWER. DO NOT WRITE IT DOWN IN A PIECE OF PAPER.

A company is deciding if it should design a product in-house or outsource the design. If outsourced, the cost for a low bidder would be $40,000, and the cost for an expensive bidder would be $100,000. To design in-house would require overtime for an already stretched design team with total costs of $70,000. If all three designs (in-house, low bid, high bid) are equal in quality and the likelihood of finding a low bidder is 60% (meaning that 40% of the time the firm will have to hire the expensive bidder), should the company outsource design or do it in-house?