Optimization Case Study Assignment Study the case Hawley Lighting Co Download Hawley Lighting Coand download the data file Hawley Data-1.xlsx Download Hawley Data-1.xlsx. Follow the instructions Download instructionsto analyze the case and prepare a report. Dr. Kerry Newness developed the Tutorial Download Tutorialon how to install and use Solver in Excel and added tips on how to approach the Hawley Lighting Co case. Prepare a business memo to report and discuss your findings on this case and answer the case questions. Follow APA style to prepare the report and include NSU Cover Sheet at the beginning of the report. Team Leaders, submit the group project report for grading (15 points) before due date. Individual team members (including team leaders) should fill out TAPE Peer Review Form-1.docx Download TAPE Peer Review Form-1.docxand submit to its drop box (not graded). Read the grading policy for details on grading the group case project. Click here to download the grading rubric. Download rubric. 4