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.

APA format 2-3 pagesScenario: Deborah enters your office, and you notice that she looks apprehensive. “Hi, Deborah. What’s up?” you ask, hoping that nothing is wrong.“Well, your team is doing an excellent job researching, and you’ve been keeping me up-to-date on your findings. My concern is that we are approaching this from a narrow-minded approach.”“How so?” You ask. You are puzzled. “Our team has been looking at every aspect of the company and considering both internal and external pros and cons.”“We need your findings put into some kind of management system so we can really see where we are headed regarding our global expansion. I think we need to cover our bases here. Please report back to me next week with your thinking put into a framework.”Complete the following:A balanced scorecard suggests that we view the organization from four perspectives (the learning & growth perspective, the business process perspective, the customer perspective, and the financial perspective). Briefly discuss these four perspectives analyzing what each means to your organization? Based on this analysis:What other strategies would be a good fit for your company profile?Provide a brief overview of these strategies. Why is it important to have more than one strategy in mind when pursuing global expansion? The materials found in the M.U.S.E. may help you with this assignment such as the audio file Choosing a Strategy. This file provides real-world experience that may help you with this assignment. In addition to your textbook material, here are a few resources that may help you learn more about the basics of the balanced scorecard:http://balancedscorecard.org/Resources/About-the-Balanced-Scorecardhttp://ap-institute.com/kpi-white-papers/what-is-a-modern-balanced-scorecard.aspx

Assignment ContentResource: SWOT Analysis table Complete an environmental scan for the health care organization you chose in Week 2. Use the SWOT Analysis table. Your scan should:Assess the organization’s internal strengths and weaknesses.Analyze the industry for opportunities and threats.Perform a SWOT analysis. A SWOT analysis helps determine performance gaps. It includes the following components:StrengthsWeaknessesOpportunitiesThreatsDescribe the organization’s present and prospective customers.Evaluate the impact of the following factors:Consumer and socialCompetitiveTechnologicalEconomicLegal and regulatory Submit the SWOT analysis as a Microsoft® Excel® attachment. Write a 1,400- to 1,750-word report in which you:Evaluate the significance and implications of an external environmental analysis in the development of a strategic plan. For your evaluation:Explain the purpose of environmental analysis.Describe possible implications of environmental analysis in the creation of your strategic plan.Analyze evolving external issues that can have an impact on the strategic plan.Evaluate benefits of competitive analysis as part of the strategic planning process.Based on your SWOT analysis, provide an assessment of your chosen organization in which you:Evaluate the organization’s ability to accomplish its mission, goals, and objectives as set in previous strategic plans.Evaluate the organization’s ability to respond to internal and external changes and challenges.Incorporate your SWOT analysis findings into clearly stated goals and objectives for a 3- to 5-year period, focusing on your strategic plan areas.You will have 2 to 3 goals for each year, with 2 to 3 measurable objectives for each goal.Goals may span several years.Outline your goals and objectives clearly and provide a narrative explanation for each of them. Cite at least 3 peer-reviewed, scholarly, or similar resources to support your information. Format your paper according to APA guidelines.Submit your assignment. For additional help, check out the ULTRA: Access your assignments page.Copyright 2018 by University of Phoenix. All rights reserved.