Read the attached case study ” Samsung” and answer questions 1 and 2 under the Corporate strategy section only. 

Risk management project part 3

This project is divided into several parts, each with a deliverable. The first four parts are drafts. These documents should resemble business reports in that they are organized by headings, include source citations (if any), be readable, and be free from typos and grammatical errors. However, they are not final, polished reports. Please see the attached requirements.

Project Part 3: Risk Mitigation Plan

Senior management at Health Network allocated funds to support a risk mitigation plan. They have requested that the risk manager and team create a plan in response to the deliverables produced within earlier phases of the project. The risk mitigation plan should address the identified threats described in the scenario for this project, as well as any new threats that may have been discovered during the risk assessment. You have been assigned to develop a draft of this new plan.

Submission Requirements

• Format: Microsoft Word (or compatible)
• Font: Arial, size 12, double-space
• Citation style: Your school’s preferred style guide

Estimated length: 4–6 pages 

Need it in 2 hours.

Please see attached:

Case Analysis Topic, Requirements and Template

 Pick one of the following terms for your research: Whistle-blowing, motivation, decentralization, group norms, or needs.  

–  The paper should have a ‘Definition, Summary and Discussion’ headings ( Summary should have 150-200 words and discussion should have 300-350 words. )

– Attach minimum 2 references

– Absolutely no plagiarism, attach a plagiarism report with a 0% similarity index

Exp19_Excel_Ch07_HOEAssessment_Employees

Project Description:

You work for a clothing distributor that has locations in Iowa, Minnesota, and Wisconsin. You will use date and logical functions to complete the main employee data set, use database functions to calculate key summary statistics and create a map, and use financial functions to complete a loan amortization table.

Start   Excel. Download and open the file named Exp19_Excel_Ch07_HOEAssessment_Employees.xlsx. Grader has automatically added   your last name to the beginning of the filename.

The 1-Data worksheet contains   employee data. You will insert several functions to complete this worksheet.   Column C contains the actual hire dates for the employees. You want to   extract only the year in column G.
 

  In cell G9, insert the appropriate date function to extract the year from the   date in cell C9. Copy the function from cell G9 to the range G10:G33.

Next, you want to determine how   many years each employee has worked for the company.
 

  In cell H9, insert the YEARFRAC function to calculate the years between the   hire date and the last day of the year contained in cell G2. Use a mixed   reference to cell G2. Copy the function from cell H9 to the range H10:H33.

You want to determine what day   of the week each employee was hired.
 

  In cell I9, insert the WEEKDAY function to display the day of the week the   first employee was hired. Use 2 as the return_type. Copy the function from   cell I9 to the range I10:I33.

The value returned in cell I9 is   a whole number. You want to display the weekday equivalent.
 

  In cell J9, insert a VLOOKUP function to look up the value stored in cell I9,   compare it to the array in the range H2:I6, and return the day of the week.   Use mixed references to the table array. Copy the function from cell J9 to   the range J10:J33.

Column D contains the city each   employee works in. You want to display the state.
 

  In cell F9, insert the SWITCH function to switch the city stored in cell D9   with the respective state contained in the range C2:C4. Switch Des Moines for Iowa, St. Paul for Minnesota, and Milwaukee for Wisconsin. Use mixed   references to cells C2, C3, and C4. Copy the function from cell F9 to the   range F10:F33.

Your next task is to calculate   the bonus for the first employee. If the employee was hired before 1/1/2010,   the employee’s salary is multiplied by 3%. If the employee was hired before   1/1/2015, the employee’s salary is multiplied by 2%. If the employee was   hired before 1/1/2020, the employee’s salary is multiplied by 1%.
 

  In cell K9, insert the IFS function to create the three logical tests to   calculate the appropriate bonus. Use mixed references to cells within the   range K2:L4. Copy the function from cell K9 to the range K10:K33.

Top management decided to ensure   all representatives’ salaries are at least $62,000 (cell G2).
 

  In cell L9, nest an AND function within an IF function. If the job title is Representative   and the salary   is less than the minimum representative salary, calculate the difference   between the minimum representative salary and the actual salary. If not,   return zero. Use a mixed reference to cell G3. Copy the function from cell L9   to the range L10:L33.

The 2-Summary worksheet contains   data to insert conditional math and statistical functions to provide summary   data. First, you want to count the number of employees in each state.
 

  Click the 2-Summary worksheet. In cell J3, insert the COUNTIF function to   count the number of employees in Iowa, using the state abbreviation column   and the state abbreviation in cell I3. Use mixed references for the range and   cell to keep the row numbers the same. Copy the function from cell J3 to the   range J4:J5.

Next, you want to calculate the   total payroll for each state.
 

  In cell K3, insert the SUMIF function to total the salaries for employees who   work in Iowa, using the state abbreviation column and the state abbreviation   in cell I3. Use mixed references for the ranges and cell to keep the row   numbers the same. Copy the function from cell K3 to the range K4:K5.

Next, you want to calculate the   average salary for executives and the average salary for representatives.
 

  In cell J8, insert the AVERAGEIF function to calculate the average salary for   executives. Use mixed references to the range and for the cell containing   Executives. Copy the function to cell J9.

You want to identify the number   of representatives hired before 1/1/2015.
 

  In cell J12, insert the COUNTIFS function to count the number of   representatives who were hired before 1/1/2015. Use ranges for the criteria   ranges and the reference to cell H9 that contains Representatives. Enter the   date condition directly in the criteria box.

In cell J13, insert the SUMIFS   function to calculate the total salaries for representatives hired before   1/1/2015. Use ranges for the criteria ranges and the reference to cell H9   that contains Representatives. Enter the date condition directly in the   criteria box. Use mixed references to the ranges and cell reference so that   you can copy the function in the next step.

Copy the function from cell J13   to the range J14:J16. Edit the function in cell J14 to calculate averages.

Edit the function in cell J15 to   calculate the lowest salary.

Edit the function in cell J16 to   calculate the highest salary.

Insert a map to display total   salaries by states.
 

  Select the ranges I2:I5 and K2:K5 and insert a filled map. Change the chart   title to Payroll by State. Cut the chart and paste it in cell M1.

The 3-Finance worksheet contains   inputs for a loan.
 

  In cell F2, insert the PV function to calculate the loan. Use cell references   in the Input Area and Basic Output Area.

You are ready to insert formulas   and functions in the loan amortization table.
 

  In cell C7, enter a reference to the Payment that is stored in cell D2. Use   mixed reference so that the row number does not change. Copy the formula from   cell C7 to the range C8:C42.

The next column is designed to   display the interest portion of each payment.
 

  In cell D7, insert the IPMT function to calculate the interest for the first   payment. Use mixed references for cells in the Basic Output Area and make   sure the result is a positive value. Copy the function from cell D7 to the   range D8:D42.

Next, you are ready to calculate   the portion of the monthly payment that goes toward the principal.
 

  In cell E7, insert the PPMT function to calculate the principal portion of   the first payment. Use mixed references for cells in the Basic Output Area   and make sure the result is a positive value. Copy the function from cell E7   to the range E8:E42. 

Now you are ready to calculate   the balance of the loan after each payment.
 

  In cell F7, enter a formula to calculate the ending balance after subtracting   the Principal Repayment from the Beginning Balance. Copy the formula from   cell F7 to the range F8:F42.
 

  In cell B8, enter a formula that refers to the ending balance for the   previous month in cell F7. Copy the relative formula to the range B9:B42.

Now you want to calculate the   cumulative interest after each payment.
 

  In cell H7, insert the CUMIPMT function. Use mixed references for cells in   the Basic Output Area and the Start_period argument. Make sure the result is   a positive value. Copy the function from cell H7 to the range H8:H42. 

Finally, you want to calculate   the cumulative principal after each payment.
 

  In cell I7, insert the CUMPRINC function. Use mixed references for cells in   the Basic Output Area and the Start_period argument. Make sure the result is   a positive value. Copy the function from cell I7 to the range I8:I42.

Insert a footer on all three   sheets with your name on the left side, the sheet name code in the middle,   and the file name code on the right side.

Save and close Exp19_Excel_Ch07_HOEAssessment_Employoees.xlsx.   Exit Excel. Submit the file as directed.

refer to the attached document in the uploads.

 In this assignment, you will be analyzing how to use a loop control variable, create nested loops, avoid common loop mistakes, use constants with arrays, search an array for an exact match, and use parallel arrays. 

Develop a Java application that plays a “guess the number” game as described below.
a) Your application first gets a random number in the range 1-1000 inclusive (you might want to use Math.random() or the Random class).
b) The application then displays the following prompt (probably via a JLabel):
I have a number between 1 and 1000. Can you guess my number?
Please enter your first guess.
Post a textbox for the user to enter a number and post a message telling the user to hit ‘Enter’ after entering a guess in a textbox (probably using a JTextField).
c) Input the user’s guess in the code for a previously-registered event-handler method (consider using the event-handling approach discussed in the text, or the actionPerformed() method of class based on the ActionListener interface, which will require some additional research outside the text).
d) For the first guess, color the entire background red, meaning that they are getting warmer (you might want to use the setBackground() method for a container). If this is the second or later guess, and they are further from the correct number than the last guess, then color the entire background blue. If they get the correct number then color the background some other color than red or blue.
e) If the user guessed the number correctly, respond with their number, post a congratulatory message, get a new random number, and display a JButton to start a new game. Otherwise, to help the user close in on the correct number, post a message, with their guessed number, whether they are “TOO HIGH” or “TOO LOW” from the correct number, and whether they are “WARMER” or “COLDER” (this should match the background color). Also report the guess number of the next guess (e.g. “Enter guess number nnn”). You might want to use a concatenated string in JLabel for these incorrect guess messages.
f) The process is repeated each game until the user guesses the correct number. Be sure that you erase obsolete status messages. 

Exp19_DSP_Access – Business 1.0

Project Description:

You are the assistant director for the Information Technology (IT)  department at Healthy Living Motorcycles, Inc. In addition to overseeing  hardware and software selection, system maintenance, and employee IT  training, you create and maintain databases for the whole organization.  The organization uses one central database rather than maintaining  several individual ones to reduce data redundancy and errors. You will  take the opportunity to create an efficient database to keep track of  and manage information regarding the company’s employees, products, and  shareholders.

You   have an existing database that contains the products sold by  the company.   However, you need to create   a table that will classify  each product under a specific category. After the   table is created,  you import the category data into the new table.
 

  Import the data in the 02a_ProductCategory.xlsx   Excel  file into a new table. Use the column headings from the Excel file,    select the CategoryID field as the primary key, and then save the  table as Product Category.
   Hint: On the External Data tab, in Import & Link group, click New Data   Source.
 

  See next page for Instruction 3

With the Product Category table   open in Design view. Ensure the  field properties of the Product Category   table have been modified as  follows:

Field Name

Data Type

Field Size

Comments

CategoryID

Short Text

2

Description = This field is assigned a 2-letter code

Caption = Category ID

This is a required field

Set Indexed = Yes (No Duplicates)

Primary key

CategoryName

Short Text

25

Caption = Category Name

This is a required field

Set Indexed = Yes (No Duplicates)

Description

Long Text

SupplierID

Short Text

4

Caption = Supplier ID

Description = All Supplier ID must begin with an “S”

Set Indexed = No

  Hint: To open the table in Design view, right-click, and then click  Design   View. Use the Field Properties pane to modify the properties.

View the data in the Product   Category table in Datasheet view and adjust column widths so all data is   visible.
 

  Save and close the table.

You create relationships among   the four tables (Employees, Product  Category, Suppliers, and Products) so   that you can make the database  more efficient.
 

  Create the following relationships and enforce referential integrity:
 

• Product Category and Suppliers   tables using the SupplierID field
  • Suppliers and Employees tables   using the EmployeeContactID and EmployeeID fields
  • Product Category and Products   tables using the CategoryID field
 

  Save and close the Relationships window.
   Hint: On the Database Tools tab, in the Relationships group, click   Relationships.

You need to quickly find the   products that were supplied by a  foreign country. You will open the Suppliers   table and filter the  records.
 

  Open the Suppliers table in Datasheet view.
 

  Filter the records for the suppliers who were outside of the United States.   You should have 11 records.
 

  Close the table.
   Hint: Click the arrow to the right of the S_Country field, and then deselect   the USA checkbox.

The director of marketing has   requested a list of the suppliers  that have a capacity of more than 25,000   square feet for manufacturing  and warehouse space.
 

  Create a query using the Suppliers table to display the SupplierID,    SupplierName, and Capacity fields for those plants with more than  25,000   square feet. Sort the results by SupplierName in ascending  order.
 

  Run the query. Name the query Supplier Size. Save and close the query.
   Hint: On the Create tab, in the Queries group, click Query Design. In the   Capacity column, enter >25000 as the criteria.

The director of marketing wants   a list of the employees who are the  main contact with the suppliers. He also   wants the addresses of these  contact employees so that he can personally send   them a letter  thanking them for working diligently with these suppliers.
 

  Create a query using the Suppliers and Employees tables.
 

  Display the SupplierName, EmployeeLastName, EmployeeFirstName,    E_StreetAddress, E_City, E_State, and E_PostalCode fields. Sort the  results   by EmployeeLastName, in ascending order.
 

  Run the query. Save the query as Contact Employee Address. Close the query.

The human resources manager   would like a list of all employees and  the approximate length of time they   have worked for the company.
 

  Create a query using the Employees table and include the EmployeeLastName,   EmployeeFirstName, and Date_of_Hire fields.
 

  Create an expression in the first blank column of the query that  calculates   the number of years employees have worked for the company,  using the   Date_of_Hire field and the current date. Do not adjust for  days off. Name the   expression Tenure. Format the Tenure field as Fixed with 2 decimal places. Name   the query Employee Tenure.
   Hint: Enter Tenure: (Date()-[Date_of_Hire])/365 as the last field in the query.

Create a report from the   Employee Tenure query. Group by  Date_of_Hire by month. Sort ascending by   Date_of_Hire. Change the  title to Employee Tenure Report. Make sure all fields display   appropriately.
 

  Widen the columns to display all text. Save the report with the default name,   Employee Tenure, and close it.
   Hint: With the query selected, on the Create tab, in the Reports  group, click   Report. On the Design tab, in the Grouping & Totals  group, click Group   & Sort.

Your organization is always   looking for more suppliers to  manufacture products. You create a new form to   make it easier to enter  new supplier information.
 

  Create a new form based on the Suppliers table using the Form tool. Change   the title label control to Enter Supplier Information.  Reduce the text box widths to   one-half of their original size. Change  the form’s control padding to Narrow.   Save the form as Enter Supplier Information.
   Hint: With the table selected, on the Create tab, in the Forms group,  click   Form. To change the control padding, on the Arrange tab, in the  Position   group, click Control Padding.

Switch to Form view. Enter a new   supplier record, #15, using the following information:
 

  Supplier ID: S115
   Supplier Name: Oakland Supply
   Delete the content in Employee Contact ID.
   Supplier Contact Last Name: Williams
   Supplier Contact Title: Intern
   Street Address: 12 Oak Street
   S_City: Washington
   S_State: MI
   Postal Code: 48094
   S_Country: USA
 

  Leave Capacity at 0. Leave the S_Phone, S_Fax, Home Page, and ProductID   fields blank.
 

  Sort the form by Supplier Name in ascending order.
 

  Save and close the form.
   Hint: To sort the data, click in the SupplierName field and, on the  Home tab, in the Sort & Filter group,   click Ascending.

The director of marketing would   like a report that lists the  suppliers who manufacture the various   motorcycles. You create a query  and the report for him using the Report   Wizard.
 

  Create a query and name it Motorcycles by Suppliers.  Add the SupplierName,   SupplierContactLastName, and Capacity fields  from the Suppliers table. Add   the ProductName and ProductSize fields  from the Products table. Add the   Product Category table. Sort in  descending order by Capacity, but do not   display the field in the  query.
 

  Run, save, and close the query.
   Hint: To hide the field from the query results, in Design view, in  the   Capacity column, click to remove the check mark from the Show box.

Create a report based on the   Motorcycles by Suppliers query. View  the data by Suppliers, and group the data   by SupplierName. Sort the  data by ProductName, ascending order. Select   Landscape Orientation for  the report. Use Block layout.
 

  Change the report title to Motorcycles Grouped by Suppliers.  Preview the report. Change the   column widths so all the data is  visible. Ensure the Report Header title   control is wide enough so the  entire title is visible. Switch to Print   Preview and make sure that  the report is displayed on one page. Exit Print   Preview and close the  report.
   Hint: On the Create tab, in the Reports group, click Report Wizard.

The director of accounting wants   to know the cost of  time-and-a-half overtime, over and above the regular   payroll, for all  hourly employees in the organization. You will create a   query to find  all the employees who worked overtime and create a report based   on the  query results.
 

  Create a query using the Employees table to calculate the hourly  rate at time   and a half for those employees who work more than 40  hours per week. Include the following fields:   EmployeeFirstName,  EmployeeLastName, Hours, Rate, and E_State. Calculate the   weekly  overtime costs in a column called Weekly Overtime.  Please note: Only the hours   worked over 40 hours per week count toward  overtime pay. Format the field as   Currency with 2 decimal places.
 

  Name and save the query as Weekly Overtime.
   Hint: In the Hours column, enter >40 as the criteria. Enter Weekly Overtime:   ([Hours]-40)*([Rate]*1.5) as the last field in the query.

Create a report for the Weekly   Overtime query. Switch to Layout  view and use the SUM function to calculate   the total cost of overtime  pay to all employees. Apply the Organic theme to   the report. Change  the report title to Employee Weekly Overtime, format the title in bold.   Ensure the Control Margins is set to None.
 

  Preview the report and adjust column widths so that the content appears on   one page.
 

  Save the report as Employee Overtime and close the report.
   Hint: To calculate the total cost, on the Design tab, in the Grouping  &   Totals group, click Totals. To change the theme, in the Themes  group, click   Themes. If the theme is not available on your machine,  click Browse for   Themes, and then select the downloaded theme file Organic.thmx.

Analyzing an Advertisement for the Appeals

In this discussion, you will be analyzing an advertisement using the appeals.

Find an advertisement online, either a video or print, to analyze. Pick an ad that you are interested in reviewing and be sure that it is academically appropriate.

Initial Response:

• Write a short analysis of three (3) paragraphs on how the advertisement uses rhetorical appeals.
• How are ethos, pathos, and logos used in the advertisement?
• Please make sure to review the readings this week that focus on the three rhetorical appeals.
  Each paragraph in your discussion board should focus on a different appeal.
• Finally, post a link to the advertisement at the end of your discussion board so that the class can take a look at it.