Complete Case 7.3 Trans LAN Project in Larson and Gray by responding to questions 1, 2, and 3. Combine items 1 and 2 into a single Risk Assessment Form (see Figure 7.6 in Larson and Gray) and use Microsoft Excel to complete this item. Use Microsoft Excel for the Risk Response Matrix (see Figure 7.8 in Larson and Gray) for question 3. Note that additional items may be added to the Risk Assessment Form and the Risk Response Matrix.In addition to the requested items in the case, complete the following:Based on the risks that you identified on the Risk Assessment Form, create a Risk Severity Matrix (see Figure 7.7 in Larson and Gray). Note that additional information beyond the information shown in Figure 7.7 may be provided. Use Microsoft Excel to complete this item.Make any assumptions and document them as necessary to complete the aforementioned items.Based on the information in Appendix 12.1 in Larson and Gray, evaluate what type of contract(s) might be applicable to this project if you were to outsource certain aspects of your project to suppliers. Ensure that you justify your supplier contractual decisions based the inherent risks related to your selected contract type(s). Make any assumptions and document them accordingly. Ensure that at least 350 words are provided. APA formatting is not required. Place your responses into a Microsoft Word file.Ensure that the Risk Assessment Form, Risk Severity Matrix, and Risk Response Matrix are included in the same Microsoft Excel File. Submit your Microsoft Excel File and your Microsoft Word File. Ensure that your last name is in your file names.While APA style is not required for the body of this assignment, solid academic writing is expected, and in-text citations and references should be presented using APA documentation guidelines, which can be found in the APA Style Guide, located in the Student Success Center.This assignment uses a scoring guide Please review the scoring guide prior to beginning the assignment to become familiar with the expectations for successful completion.Case 7.3Trans LANProject Trans Systems is a small information systems consulting firm located in Meridian, Louisiana. Trans has just been hired to design and install a local area network (LAN) for the city of Meridian’s social welfare agency. You are the manager for the project, which includes one Trans professional and two interns from a local university. You have just finished a preliminary scope statement for the project (see below). You are now brainstorming potential risks associated with the project.1. Identify potential risks associated with this project. Try to come up with at least five different risks.2. Use a risk assessment form similar to Figure 7.6 to analyze identified risks.3. Develop a risk response matrix similar to Figure 7.8 to outline how you would deal with each of the risks.PROJECT SCOPE STATEMENTPROJECT OBJECTIVETo design and install a new local area network (LAN) within one month with a budget not to exceed $90,000 for the Meridian Social Service Agency with minimum disruption to ongoing operations.DELIVERABLES∙Twenty workstations and twenty laptop computers.∙ Server with dual-core processors.∙ Two color laser printers.∙ Windows R2 server and workstation operating system (Windows 10).∙ Migration of existing databases and programs to new system.∙ Four hours of introduction training for client’s personnel.∙ Sixteen hours of training for client network administrator.∙ Fully operational LAN system.MILESTONES1. Hardware January 22.2. Setting users’ priority and authorization January 26.3. In-house whole network test completed February 1.4. Client site test completed February 2.5. Training completed February 16.TECHNICAL REQUIREMENTS1. Workstations with 17-inch flat panel monitors, dual-core processors, 4 GB RAM, 8X DVD+RW, wireless card, Ethernet card, 500 GB hard drive.2. Laptops with 12-inch display monitor, dual-core processors, 2GB RAM, 8X DVD+RW, wireless card, Ethernet card, 500 GB hard drive and weigh less than 4½ lbs.3. Wireless network interface cards and Ethernet connections.4. System must support Windows 11 platforms.5. System must provide secure external access for field workers.LIMITS AND EXCLUSIONS1. On-site work to be done after 8:00 p.m. and before 7:00 a.m. Monday through Saturday.2. System maintenance and repair only up to one month after final inspection.3. Warranties transferred to client.4. Only responsible for installing software designated by the client two weeks before the start of the project.5. Client will be billed for additional training beyond that prescribed in the contract.CUSTOMER REVIEWDirector of the city of Meridian’s Social Service Agency.

It is a 24 question assignment that must be done on on an excel spreadsheet. You must be proficient to advanced on microsoft excel. 1Start Excel. Open the downloaded Excel file named GO_eV1_Grader_CAP.xlsx.02On the Net Sales worksheet, in the range F4:F8, calculate the annual total sales for each state.23In the range B9:F9, calculate totals.24Using absolute cell references as necessary, in cell G4, construct a formula to calculate the percent that the Colorado Total is of Total Sales, and then fill the formula down through the range G5:G8.25Apply the Total cell style to the range B9:F9.26In cell H4, insert a Line sparkline using the data range B4:E4. Format the sparkline by applying the Sparkline Style Accent 2 (no dark or light). Copy the sparklines down to cell H8.27Insert a 3-D Pie chart using the nonadjacent ranges A4:A8 and G4:G8. Change the chart style to Style 7. Reposition the chart so that the top left corner of the chart is centered in cell A10. Change the width of the chart to 6.5 inches.28Change the chart title to Annual Net Sales by State and add data labels to the chart that display only the Category Name and Percentage positioned in the Center. Change the data labels Font color to Black, Text 1 and apply Bold Italic. Remove the Legend from the chart.2.59Change the angle of the first slice of the pie to 200, and then explode the red New Mexico slice of the pie by 10%. Change the solid fill color of the orange Colorado slice to Tan, Accent 6.2.510On the Seattle Inventory worksheet, in cell G14, enter an IF function to determine the items to be ordered. If the Quantity in Stock is less than 50, then the cell should displayOrder. If not, then the cell should display OK. Copy the function down through cell G19.211Format the range A13:G19 as a table with headers and then apply Table Style Medium 5.212Add Gradient Fill Orange Data Bars to the range A14:A19. Add conditional formatting to the range G14:G19 so that the cells with text that contain the word Order are formatted as Yellow Fill with Dark Yellow Text. Sort the table by Item # from Smallest to Largest. 2.513Filter the table on the Sport column to display only the Skiing types. Display a Total Row in the table, and then sum the Quantity in Stock for Skiing items. Type the result in cell B11. Remove the total row from the table and then clear the Sport filter.214In cell B5, enter a function that will display the average retail price. In cell B6, enter a function that will display the median retail price. In cell B7, enter a function that will calculate the lowest retail price. In cell B8, enter a function that will calculate the highest retail price. Format the range B5:B8 with Accounting Number Format.415Display the Inventory Summary sheet. In cell B4, enter a formula that references cell B4 in the Seattle Inventory sheet so that the Seattle Total Items in Stock displays in cell B4. In cell B5, enter a formula that references cell B5 in the Seattle Inventory sheet so that the Seattle Average Price displays in cell B5. In cells B6, B7, and B8, enter similar formulas to reference the Median Price, Lowest Price, and Highest price in the Seattle Inventory sheet.2.516In cell C4, enter a formula that references cell B4 in the Denver Inventory sheet so that the Denver Total Items in Stock displays in cell C4. In cells C5, C6, C7, and C8, enter similar formulas to reference the Average Price, Median Price, Lowest Price, and Highest price in the Denver Inventory sheet.2.517On the Annual Expenses sheet, construct formulas to calculate Totals by Quarter in the range B10:E10 and the Annual Totals in the range F5:F10. Apply the Total cell style to the Totals by Quarter (B10:F10), and then center the column headings (B4:G4) and apply the Heading 4 cell style.218Using absolute cell references as necessary, in cell G5, construct a formula to calculate the % of Total by dividing the Sales Expense Annual Total by the Annual Totals by Quarter. Fill the formula down through the range G6:G9.219Using the data in the nonadjacent ranges B4:E4 and B10:E10, insert a Line with Markers chart. Position the upper left corner of the chart slightly inside the upper left corner of cell A12. Change the height of the chart to 1.75 inches and the width of the chart to 7.25 inches.1.520Apply chart Style 7. Change the chart title to 2016 Direct Expenses. Edit the Vertical (Value) Axis so that the Minimum is 8000000 and the Major unit 1000000.3.521Use Format Painter to copy the formatting from cell A2 to A20. In cell B23, enter a formula that references the value in cell F10.222Using absolute cell references as necessary, in cell C23, construct a formula to calculate the projected expenses for 2018 after the Forecasted increase in cell B21 is applied. Fill the formula through cell F23.2.523Display the Sales Reps sheet. By using Flash Fill and deleting columns as necessary, place the last names in column A, the first names in column B, and then merge and center the title Sales Reps across the two columns.224Ensure that the worksheets are correctly named and placed in the following order in the workbook: Net Sales; Seattle Inventory; Denver Inventory; Inventory Summary; Annual Expenses; Sales Reps. Save the workbook. Close the workbook and then close Excel. Submit the workbook as directed.0

Please read the facts set forth in Discussion Question 21 (p.175) of your text as related to the Menendez-Halliburton case set forth in chapter three of your text (pp. 164-165).How would you characterize Halliburton's accounting for revenue from an ethical and a professional perspective?After KPMG learned that Menendez had secretly tape recorded conversations and had provided a complaint to Halliburton's audit committee highlighting questionable practices, the KPMG audit partner instructed the audit team members to avoid communications with Menendez. How would you characterize those ethically and professionally?How would you characterize Menendez secrete tape recording of conversations from a legal and ethical perspective?Each response must be a substantial paragraph.