Competency Lead, communicate, and direct diverse teams, stakeholders, and sponsors. Scenario Helen is a newly assigned Chief Information Officer for a fast growing online retail store that employees over 1000 employees. The company is geographically spread across several states in the North-Eastern United States. Headquartered in Boston, Massachusetts, the companies leadership consists of the Chief Executive Officer (CEO), Chief Financial Officer (CFO), Chief Operations Officer (COO), Vice President of Marketing and Vice President of Production. The CEO has asked Helen to provide a recommended organizational structure that integrates Information Technology across the company. Helen must also create the Management Information System (MIS) department from the ground up. Considering the cost to the company, Helen must articulate the importance of each MIS role/position and adequately demonstrate the operational need of MIS. The CEO has asked Helen to provide a mission statement for her newly formed team. Instructions You will provide 2 separate deliverables as follows: Create a 2-3 slide ( Power Point ) presentation that Helen will use to brief the CEO. Provide a mission statement for the newly formed MIS team that emphasizes the importance of customer service. Create an organizational chart that depicts the key business positions as well as the recommended MIS positions that Helen has been charged with creating. Use the notes section to provide detailed speaker notes Provide a 1-2 page written summary of each MIS position that describes the purpose of the position as well as how the positions benefits the strategic goals of the company. Resources (if needed) Structure That's Not Stifling Grading Rubric F F C B A 0 1 2 3 4 Did not Submit No Pass Competence Proficiency Mastery Not Submitted Created an organization chart but it is missing many of the key business positions and/or it is missing many of the key recommended MIS positions that Helen has been charged with creating. Created an organization chart that depicts some but not all of the key business positions and/or lacks the recommended MIS positions that Helen has been charged with creating. Created an organization chart that depicts the key business positions but lacks some of the recommended MIS positions that Helen has been charged with creating. Created an organization chart that depicts the key business positions as well as the recommended MIS positions that Helen has been charged with creating. Not Submitted Provided a written summary but was missing many of the MIS positions or is lacking any detail about the purpose of the position or lacks explanation about how the positions benefit the strategic goals of the company. Provided a written summary of most but not all of the MIS positions or is lacking some detail about the purpose of the position or lacks some detail on how the positions benefit the strategic goals of the company. Provided a written summary of each MIS position that describes the purpose of the position but lacks some detail on how the positions benefit the strategic goals of the company. Provided a written summary of each MIS position that describes the purpose of the position as well as how the positions benefit the strategic goals of the company.

i need to complete this assignment. Open the file NP_EX19_EOM3-1_FirstLastName_1.xlsx, available for download from the SAM website.Save the file as NP_EX19_EOM3-1_FirstLastName_2.xlsx by changing the “1” to a “2”.If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.With the file NP_EX19_EOM3-1_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.If cell B6 does not display your name, delete the file and download a new copy from the SAM website.PROJECT STEPSChanelle Larson is a professional assistant with Barrel Barnard Consulting. Chanelle is responsible for collecting consultant hours for some of Barrel Barnard's projects and processing the payments. She wants to automate some tasks and calculate summary information automatically on the worksheet that consultants use to track their hours. Switch to the Timesheet worksheet. In cell C5, insert the NOW function to record the current date.Each worksheet covers a period of 20 work days. In cell C4, create a formula using the WORKDAY function to calculate the date 19 days from the start date (cell C3).Use AutoFill to complete the labels in the table of hours. Use the values in the range A9:A10 to extend the week numbering to the range A11:A12. Use the value in cell B8 to autofill the remaining weekday abbreviations in the range C8:F8.Add formulas to complete the table of hours used. In cell B17, create a nested formula with the IF and SUM functions that check if the total number of hours worked in week 1 (cells B9:F9) is equal to 0. If it is, the cell should display nothing (indicated with two quote marks: ""). Otherwise, the cell should display the total number of hours worked in week 1. Copy the formula from cell B17 to fill the range B18:B20.In cell H2, create a formula using the WORKDAY function to calculate the date 5 days after the period end date (cell C4).Create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number in cell I5 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell I5 and the range A17:G20.Copy the formula from cell I6 to the range I7:I11 and then edit the formula in cell I7 to return the value in the 3rd column, the formula in cell I8 to return the value in the 4th column, the formula in cell I9 to return the value in the 5th column, the formula in cell I10 to return the value in the 6th column, and the formula in cell I11 to return the value in the 7th column.Add formulas to complete the balances section. In cell K8, create a formula using the SUM function that calculates the total of the range D17:D20 and subtracts it from the value in cell J8.In cell K9, create a formula using the SUM function that calculates the total of the range E17:E20 and subtracts it from the value in cell J9.In cell K10, create a formula using the SUM function that calculates the total of the range F17:F20, subtracts it from the value in cell J10, adds the total of the range G17:G20, and subtracts 160.Copy the formula in cell J11 to cell K11. In cell J16, create a formula using the AVERAGE function that calculates the average of the range B9:F12.In cell J17, create a formula using the MAX function that returns the maximum value from the range B9:F12.In cell J18, create a formula using the MIN function that returns the minimum value from the range B9:F12.Your workbook should look like the Final Figures on the following pages. The value in cell C5 has been intentionally blurred as it will never be constant. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.