GETTING STARTEDOpen the file NP_EX16_1a_FirstLastName_1.xlsx, available for download from the SAM website.Save the file as NP_EX16_1a_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_EX16_1a_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 STEPSKatie works for the Human Resources Department at Pepito’s Supermarkets and uses Excel to calculate the company’s payroll expenses and profits. She is currently finalizing the Profit and Payroll worksheets to close out the week’s figures.Adjust the width of column A using AutoFit.Change the width of column D to 12.00.Enter the values shown in Table 1 below into the corresponding cells in the range B12:C14.In cell D6, type ML3583. Select the range D5:D14, and then use the Flash Fill button (in the Editing group on the Home tab) to automatically enter codes into the remaining cells in the range. (Hint: You must use the Flash Fill button to properly receive credit for this step.) [Mac Hint: Flash Fill is not available on Excel 2016 for the Mac, so refer to the Final Figures to enter the correct values.]Select cell A15, and then enter the word Total. Remove cell borders from the range A15:B15 using the No Border border format.In cell B15, create a formula using the SUM function to total the data in the range B5:B14.In cell B17, create a formula using the COUNT function to determine the number of people employed by Pepito’s Supermarkets by counting the values in the range B5:B14.Switch to the Profit worksheet. Change the orientation of the Profit worksheet to Landscape. In cell A2, change the cell content to Profit - March 1-7, 2018 (instead of just reading “March 1-7, 2018”).Select the range A4:E4 and the nonadjacent cell G8, and then increase the font size of the cells to 12 pt.To better display the content, manually change the height of row 3 to 18.00. (Hint: Do not use AutoFit.)In cell B7, enter a formula without using a function to determine the profit generated at the Downtown location by subtracting the store’s expenses (cell B6) from the store’s sales (cell B5) for the week of March 1-7, 2018. Copy the formula you created in cell B7 to the range C7:D7.After determining the total profits generated by each store, Katie is now interested in calculating the total sales, expenses, and profits for the company. Select the range E5:E7, and then apply AutoSum to calculate the totals for these categories across all three stores.Katie edited the worksheet after March 8, 2018, making the content in cell A11 unnecessary. Click on cell A11 and clear its contents.Apply the wrap text formatting to cell G8.Adjust the Zoom level of the Profit worksheet to 130%.After reviewing the Profit and Payroll worksheets, Katie typically generates some additional data for accounting. To create a placeholder worksheet for this data, insert a new worksheet in the workbook, rename the worksheet Accounting, and if necessary, move the new worksheet after the Profit worksheet.On the Payroll worksheet, cut the contents of the range B1:B2 and paste them into the range A1:A2.Table 1: Data for the Range B12:C14 B C 12 321.68 7/9/1990 13 427.67 6/9/1982 14 526.34 5/8/1988 Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.

Review the text material below for best practices of self-regulated ethics programs. Summarize the material of corporate self-regulation ethics programs. Explain the major challenges and issues to enforce these programs as well as the business ethics training portion, such as codes of conduct, peer review, and the readiness checklists. Use citations and references in APA style to support your post.5 Corporate Self-Regulation and Ethics Programs: Challenges and IssuesAccording to the ethicist Lynn Paine in a Harvard Business Review article, a values-based approach in ethics programs should be more effective than a strict, rules-based compliance approach, since a values approach is grounded and motivated in personal self-governance.[93] Employees are more likely to be motivated to "do the right thing" than threatened if they violate laws and rules. A values-based stakeholder management approach assumes that corporations (owners and management) ought to intrinsically value the interests of all stakeholders.[94] In practice, this is not always the case.[95] Later studies suggest that both values-based and compliance ethics programs seem to work effectively together. Without values-based compliance, however, compliance and fear-based programs are less likely to succeed.[96] Responsible self-regulation in companies can enhance entrepreneurship and reduce unnecessary costs of too much bureaucratic control (e.g., it is estimated that the 2002 Sarbanes-Oxley Act costs large public companies $16 million to implement). One study by the Open Compliance Ethics Group (OCEG) found that firms that had had an ethics program for 10 or more years did not have "reputational damage" during the last five years. Ethics programs appear to have some intended effect.[97] Complete your company's "Ethical Weather Report" to identify your point of view regarding how ethical your company is.Chapter 4 discussed in more detail ethics programs that include codes of ethical and legal conduct that are designed to help companies financially and legally. As noted there, the Federal Sentencing Guidelines for Organizations (FSGO) were established in 1984 by Congress—which passed a crime bill that instituted the U.S. Sentencing Commission. This commission, made up of federal judges, was empowered with sentencing those found in violation of the guidelines. In 1987, uniform guidelines were created for sentencing individuals in the federal courts. Some federal judges quit the bench in protest of the strictness of the guidelines and the sentences they were required to hand down. In 1991, the commission shifted the emphasis from individual wrongdoers to organizations that might be found guilty for the illegal actions of their employees. The 1991 revised guidelines threaten fines of up to $290 million to companies found guilty of violating the federal guidelines. However, those fines can be substantially reduced if an organization implements an "effective program to prevent and detect violations of law." Companies that followed the requirements of the FSGO could find relief from lawsuits that resulted from one or more criminally motivated professionals. However, without active, ethical leadership, there is less likely to be a strong culture, open communication, and support from other organizational systems to support ethics programs