Prepare your answers for all of the following problems in one Excel and submit the Excel file in Canvas. Use one file th

[answerhappygod]

Prepare your answers for all of the following problems in oneExcel and submit the Excel file in Canvas. Use onefile that contains solutions on different sheets; do not try tosubmit separate Excel files. Clearly indicate youranswers. The solutions in your Excel file should be very organizedwith every number labeled. Follow theexamples in the textbook for the proper format.
Problem 2. [20 points]Myman Pharmaceuticals uses centrifuges in its labs to removeproduct solids from its finishing processes. The labsfive engineers are responsible for running the machines and each ofthe ten machines is closely monitored withdigital control displays. The centrifuges cost $500,000 each andthe engineers are paid an average annual salary of$125,000, including benefits. On October 14, without warning themachines begin to self-destruct. Six of thecentrifuges are shut down before they are damaged, but the otherfour are destroyed. An investigation determinedthat the Stuxnet worm had infected the software running themachines and caused them to spin out of control whilehiding these effects from appearing on the display monitors. Thelab engineers will lose 50 percent of theirproductivity over the next six months as it will take that long toreplace the destroyed centrifuges. In estimating theloss from the cyberattack, the CFO assigned an annual revenue(sales) to each centrifuge of $2.5M. In recent years,Myman had earned a 15-percent return on its sales (net income ÷sales). Vendors have indicated that thereplacement cost of new machines will be approximately $600,000.The engineers will not lose their jobs and willcontinue to be paid their full salaries. Estimate the loss from theattack and whether any other factors need to beconsidered.