(20) BUILD - Create the equation to build using the following information: Hardware Costs:

(20) BUILD - Create the equation to build using the following information:  Hardware Costs: eight (8) new laptops will be needed for this project, since all the available computers your company currently owns need to be updated. Each new laptop will cost $959.00. You will also need to purchase the Extended Warranty at a price of $175.00 per machine.  Service Costs: Your current Computer Maintenance Services Company will cover the new machines at 1/4 their normal rate of $140 per machine per day. The per-day charge is non-negotiable, applied every day of the week (whether the machines are in use or not).  Labor Costs: Since your company CEO has a really bad habit of hiring unqualified and inexpensive staff, you will need to staff your new laptops with Software Engineers (SE) and Computer Programmers (CP). Each of the four (4) SE's assigned to your project make $78 per hour (8 hour day), and each of the four (4) CP's make $57 per hour (8 hour day). Since this project is so important, and since all your SE's and CP's have threatened to quit because they want a raise, management has also agreed to pay Key Assignment Bonuses to the eight (8) employees to get them on-board. Each SE will be paid a $9,800 cash bonus, and each CP will be paid a $8,400 cash bonus. SE's and CP's are both assigned to work on this project 7 days per week (8 hour day), with no additional overtime or benefit costs incurred.  Training will be provided for all new employees. Two trainers will be brought in, each charging $65 per hour. The training will be for 2 weeks; 10 - 8hr days total. The trainers will be paid in full before training begins.  Eight employees will also be given iPhones and will be required to keep in close contact at all times, including weekends. The iPhones were purchased several months ago. However, there is a monthly contract fee of $906.80 for each phone that must be paid in full for the first year.  All hardware and labor costs are considered "sunk", and no depreciation is performed, since your company CEO doesn't pay taxes anyway. (16) BUY - Create the equation to buy using the following information:  Hardware Costs: eight (8) new laptops will cost $3,600.00 each. Brick offers a 10% discount per machine. You decide not to purchase an extended warranty.  Your current Computer Maintenance Services Company will cover the new machines at a price of $55.00 per machine per month for the first year. Yearly service contracts must be paid in full, up front.  Hourly Fees: $49.60 per Senior Data Entry Clerk (SDEC), and $38.27 per Junior Data entry Clerk (JDEC). Brick runs his shop seven days per week (8 hour day), and has guaranteed you 25 SDEC's and 20 JDEC's every day until the project is complete.  Eight employees will also be given iPhones and will be required to keep in close contact at all times, including weekends. The iPhones were purchased several months ago. However, there will be a monthly contract fee of $1,062.60 (based on a 30 day month) for each phone.  Twelve employees will be sent to training. Training fees for 5 days for each employee will be $120 per day paid in full before training begins.  Travel and hotel fees will also need to be paid for the 12 employees participating in the training. Each flight costs $580 round trip. Hotel rates are $125/night for 5 nights. All employees are required to share a room (2 per room). All travel fees are paid before employees travel. answer these additional questions:  (2) At which day do the BUILD and BUY options become equal? (Round your answer up to the next nearest day). Show your equation and all calculations as to how you arrived at it.  (3) If Brick's Data Recapture could finish the data entry in 10 days, and your in-house team could finish it in the same time, which option would you recommend, and why? What costs are associated with each option at this point in time?  (3) If Brick's Data Recapture could finish the data entry in 14 days, and your in-house team could finish it in the same time, which option would you recommend, and why? What costs are associated with each option at this point in time?  You must show all calculations using the correct formulas to earn credit for this assignment (how did you obtain the numbers used in your analysis?) Label all.  Set up your analysis and equations using Excel  You must also have clear answers to the questions posed above to receive credit for this assignment. Make it clear WHAT your numbers are and HOW you arrived at them.  Use Excel to calculate your totals. When finished, save your analysis as an .xlsx file to