In this exercise, you will compile summary data based on an inventory listing for Educational Endeavors. Then you will determine the inventory balance for a product category using three methods. Last, you will create a PivotTable and a PivotChart. 1. Open EA4-A1-Inventory from your Chapter 04 folder and save it as: EA4-A1-Inventory-[YourName]

2. Use a function to display the total number of product categories in cell B2. 3. Populate the cells as described for the Construction Paper product category: In this cell:

Use a function to display the:

Cell J5 Cell K5 Cell L5 Cell M5

Number of years for which an inventory balance is displayed Average inventory balance for the five years shown Maximum inventory balance for the five years shown Minimum inventory balance for the five years shown

Hint: Make sure the formula in cell J5 will update properly if any currently blank cells are later filled in.

4. Copy the formulas in the range J5:M5 and paste them such that the calculations will be performed for all product categories.

5. Enter formulas in the range E63:I63 to add the inventory balances for each year.

Use Inventory Costing Methods 6. Switch to the Construction Paper tab. 7. Use the CONCATENATE function to enter LIFO Inventory Balance in cell A17. 8. Enter a formula in cell B17 to calculate the ending inventory balance for construction paper under the LIFO method.

9. In cell A18, use the CONCATENATE function to enter FIFO Inventory Balance.

10. Enter a formula in cell B18 to calculate the ending inventory balance for construction paper under the FIFO method.

11. In cell A19, use the CONCATENATE function to enter WA Inventory Balance. 12. Enter a formula in cell B19 to calculate the ending inventory balance for construction paper under the weighted average method.

13. Enter a formula in the appropriate location on the Inventory Listing tab to display the fifth-year LIFO inventory balance for construction paper.

14. Apply the 3 Symbols (Uncircled) icon set and Red – White – Green color scale to the range K5:K62.

15. Create a PivotTable on the Inventory Listing tab based on the inventory balances displayed for all five years.

16. Rename the new worksheet tab containing the PivotTable. 17. Display the Year 5 Inventory Balances within the PivotTable with: • Country of Manufacture in the Rows area • Product Category in the Columns area • A filter that excludes all but the Active product department

18. Add a slicer that limits the data to product categories that earned at least a 3 of 5 online rating.

19. Create a 3-D Clustered Column PivotChart and display the Online Rating category in the legend.

20. Position the PivotChart and slicer in a logical manner.

1. Challenges in the Business Environment
   Overview
   Changing, or even stating, a company’s values can be a long and arduous process, but it often pales in comparison to the effort it takes to make sure they are honored, implemented and projected. In this assignment, you evaluate how well your chosen company from the first assignment has done in “walking the talk” and responding to a social issue.
   Preparation
   Review your chosen company’s mission and values statements as well as other sources that provide insight into the company’s values with regard to social responsibility. Pick two of their primary values and research how the company manifests those values. Simple examples might be the commitment to workplace diversity or ecological sustainability. 
   Instructions
   Create a 3–5-minute (approximately 6–8 slides) PowerPoint presentation that evaluates how well the company embodies its issue-related values. Your presentation should contain detailed speaker’s notes that flesh out and support main points, ideas, or conclusions and have supporting citations.
   1. Summarize your chosen company’s Supplier Responsibility information.
   2. In your own words, explain how each aspect of your Supplier Code of Conduct is committed to ethical business practices and social responsibility.
   3. Discuss your company’s stance on each of the following areas:
      • Empowering Workers.
      • Labor and Human Rights.
      • Health and Safety.
      • The Environment.
      • Accountability.
   4. Identify the key ways that your company’s Code of Conduct has changed since last year.
   5. Examine the manner in which your company’s Supplier Code of Conduct helps the organization operate as a socially responsible organization.
   6. In this week’s discussion, you consider assembling a team to write a supplier code of conduct. Recommend the stakeholders roles (4–5) needed on the team and how each supports the project.
   7. Integrate at least three supporting resources from the Strayer University Library or other reputable sources.
      This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions.
      The specific course learning outcome associated with this assignment is:
      • Create a presentation about the key areas, changes, and progress in a company’s supplier responsibilities and code of conduct.

Technology Communication Plan

As a health care manager, it is your responsibility to ensure that the implementation of new technology is well understood and training for the new technology use is communicated appropriately to staff and patients.

Complete the following sections based on the technology trend selected and discussed in Weeks One and Two.

Write a summary of the technology to be implemented and its impact on the facility.

• As      you prepare your summary, consider your audience (staff and patients).

Explain the implementation process of the technology you selected in the health care setting.

• Consider      discussing the equipment that needs to be acquired (e.g., list equipment      necessary for the clinic, staff, and patients).
• Consider      a possible timeline for implementation.
• Consider      basic standard operating procedures for your employees and stakeholders. 

Analyze the security and privacy protocols when implementing the technology you selected in a facility.

• As      you analyze security and privacy protocols when implementing technology,      consider all stakeholders who will be impacted.

Explain the roles and responsibilities of resources in the implementation process for the technology you selected.

• Consider      discussing the resources for staff and patients (e.g., useful resources      (websites, articles) with information pertaining to the new technology).
• Consider      discussing the staff and patient training (e.g., consider communication to      your stakeholders (staff and patients) and list the impact to their daily      activities).

Cite 2 references, one of which may be the course textbook, to support your position.

Format your proposal according to APA guidelines.

QUESTION 1

1. Criminology theorizing is criticized for being male-centered and unable to account for female experiences (including participation in crime and delinquency). Briefly summarize the main points of this critique and assess the empirical evidence around these claims. Also describe and evaluate one theory in particular that purports to account for gender similarities in crime and another theory that purports to account for gender differences in crime. Discuss the implications of your evaluation for future theory and research.

2. Describe the historical development of social learning theory, including its origins in differential association theory. What elements of differential association theory are retained in social learning theory and in what ways has social learning theory extended or elaborated upon the original differential association theory? Cite relevant research that supports and/or refutes the theoretical elaborations provided by the social learning model and draw a conclusion whether social learning theory has made a substantive contribution to the explanation of crime beyond that provided by differential association theory.

3. Control theory has undergone several changes, especially since Hirschi’s (1969) proposal and test of “social bonding” theory. Describe in detail the evolution of control theory since 1969 and highlight the similarities and differences among the various iterations of this theoretical tradition. Finally, evaluate the degree to which this evolution in control theory has produced meaningful improvement, from both a logical and empirical standpoint, in our understanding of crime and delinquency.

4. Deterrence theory and labeling theory offer two contradictory positions on the effects of legal punishment. Please describe these two positions and, for each one, provide a comprehensive review of the empirical evidence and assess which theory most accurately captures the effects of legal punishments.

5. Discuss thoroughly the criteria used to evaluate the quality of criminological theories for explaining crime and detail why each of these criteria produce stronger theories. Which current criminological theory do you believe does the best job and which does the worst job of meeting those criteria? Thoroughly defend your answers to those who would disagree with you.

6. Compare and contrast the Anomie theories of Durkheim, Merton, and Messner & Rosenfeld.

7.Describe the current state of labeling theory. In doing so, be sure to emphasize (1) the definition of labeling, (2) the factors that should increase one’s exposure to labeling, (3) the reasons why labeling should affect later crime, and (4) the factors that may amplify or diminish its effects on crime. Where relevant, discuss empirical evidence on the accuracy of labeling theory’s predictions.

8. Gottfredson and Hirschi’s (1990) self-control theory (and Hirschi’s 2004 revised version of self-control theory) and Akers (1973) social learning theory are classic criminological theories. Describe the similarities and differences between these two theories (including Hirschi’s 2004 revised self-control theory) with regard to how they would explain crime and delinquency. In addition, make an argument whether or not these theories could be integrated, and if so, how.

9. Contemporary social disorganization theory identifies several structural correlates of crime rates across communities, but acknowledges that additional factors mediate the relationship between these structural factors and crime. Discuss in detail both the exogenous structural conditions of disorganization necessary for crime as well as the factors that mediate the effects of disorganization on crime rates. Review the research that tests the relationships proposed by contemporary social disorganization theory and take a position on whether or not variation in crime rates across communities can be explained by variation in the community’s level of disorganization. Be sure to defend your answer thoroughly

10. Use theory to explain the mass looting and violence following Hurricane Katrina. Identify the elements (i.e., concepts and propositions) connected to the theory, as well as what the theory would predict in terms of empirical findings. Finally, discuss the limitations of the theory to explain the postKatrina crime.