Instructions

Scenario (information repeated for deliverable 01, 03, and 04)

A major client of your company is interested in the salary distributions of jobs in the state of Minnesota that range from $30,000 to $200,000 per year. As a Business Analyst, your boss asks you to research and analyze the salary distributions. You are given a spreadsheet that contains the following information:

• A listing of the jobs by title
• The salary (in dollars) for each job

The client needs the preliminary findings by the end of the day, and your boss asks you to first compute some basic statistics.

Background information on the Data

The data set in the spreadsheet consists of 364 records that you will be analyzing from the Bureau of Labor Statistics. The data set contains a listing of several jobs titles with yearly salaries ranging from approximately $30,000 to $200,000 for the state of Minnesota.

What to Submit

Your boss wants you to submit the spreadsheet with the completed calculations. Your research and analysis should be present within the answers provided on the worksheet.

nstructions Scenario (Information repeated for deliverable 01, 03, and 04) A major client of your company is interested in the salary  distributions of jobs in the state of Minnesota that range from $30,000  to $200,000 per year. As a Business Analyst, your boss asks you to  research and analyze the salary distributions. You are given a spreadsheet that contains the following information: A listing of the jobs by title The salary (in dollars) for each job The client needs the preliminary findings by the end of the day, and your boss asks you to first compute some basic statistics.
Background information on the Data The data set in the spreadsheet consists of 364 records that you  will be analyzing from the Bureau of Labor Statistics. The data set  contains a listing of several jobs titles with yearly salaries ranging  from approximately $30,000 to $200,000 for the state of Minnesota.
What to Submit Your boss wants you to submit the spreadsheet with the completed  calculations. Your research and analysis should be present within the  answers provided on the worksheet.

As per the week four discussion and assignment, imagine that you have been appointed to serve as the health department liaison to a community group mobilizing to make change. You have been working with the community for a few months and your supervisor is very happy with your efforts so far.

You have made some progress gaining access to and the trust of the community, but some people in the community are still wary of the health department’s involvement. In the past, the health department has come into the community and implemented health promotion programs without taking the community’s needs or wants into account. Many of the programs were perceived of by the community as being offensive and hurtful. For example, many older members of the community remember programs run by the health department that coerced low-income women of color to be sterilized as a way to decrease unplanned pregnancy.  Thus, they remain suspicious about why you and the health department want to work with them.

Unaware of some of the complexities of the health department and community’s relationship, your supervisor has decided to reward your work by granting the community program $5,000. However, the money comes with a stipulation that you may not use it to pay people (i.e. for salaries; you are the staff person who will need to implement the chosen intervention, and your salary is already budgeted) and it must be used to address alcohol and drug abuse, which your supervisor perceives to be an issue in the community with which you are working. In addition, the money must be used within the next two months, prior to the end of the fiscal year. The money is “use it or lose it”. If not used within the next two months, the money will be gone and your supervisor may think you and the community do not want or need funding to do your work.

Your supervisor has requested you submit by Thursday a one-page overview of the intervention you plan to implement and an associated budget that lays out how you will spend the money. This leaves you no time to talk with community leaders about what they think about the offer for program funding or what should be done with the money. You have a meeting with community leaders scheduled for Thursday night and will need to present them with the proposal you develop this week.

The textbook outlines several intervention strategies, including health communication, health education, health policy/enforcement, and environmental change. Based on the analysis you did of the community in week four, choose one or more of these strategies that you think would be most successful given the community’s work to date. In your post:

• Outline the primary program components that you will spend the money on.
• Create a budget that explains how the funding will be used.
• Devise a strategy for how you will present the plan to the community. Consider how you will respond to their potential concerns.

Select a psychoactive drug that is of pharmacological interest to you, but not one you will review as part of your Critical Review or one that was included in your previous Rapid Review. For this paper, you may choose drugs of abuse; however, the paper must focus on the pharmacology of the drug and not on the social or addictive aspects.  If you focus on addiction and social impact, your paper will not receive credit.

In addition to the text, research a minimum of three peer-reviewed articles published within the last five years on your selected drug. Prepare a three-page summary of the drug

In your Rapid Review, analyze and explain the pharmacological aspects of the drug as they relate to the following: neurotransmitters affected, receptors, route of administration, half-life, doses, side effects, drug interactions, contraindications, and other important facets of the drug. Explain these aspects of the drug in terms of the psychiatric disorders indicated for the drug and the issue(s) associated with that use. If there is no accepted therapeutic use for the drug, evaluate and describe the actions of the drug with regard to the abuse process.

The paper:

• Must be three to five double-spaced pages in length, excluding title page and references page, and it must be formatted according to APA style

Read Chapter 8 Case Study- Valpak in The Project Manager’s Guide to Mastering Agile and answer the below questions in a submitted essay.

Write a 300 – 350  words summary on the following questions that you would anticipate if the same kind of implementation was addressed at your company

1. How would this approach be implemented at your company?

2. What methodologies would be changing at your company to go to the SAFe type of methodology?

3. Give an example of an “Architectural epic” that would be used at your company.

4. How would portfolio Kanban be implemented at your company?

5. What do you think the biggest challenges you would face at your company if you were the consultant hired to implement the same types of processes that were addressed at Valpak?

15. If it were to be successful at your company, what would the key success factors be?

Individual Assignment – Presentation – 15% – Tuesday Class

Students will be required to complete an individual presentation and an individual paper at the end of the term. Students will be required to provide a paper written APA style format.

You are a hospitality human resources executive in a new hospitality global entrant. Your main responsibility is to oversee the strategic planning as well as the hiring, training and development of all employees. You will need to create the company’s goals and objectives. This includes the development of the mission statement for the organization and the purpose of the hospitality brand.

Every employee speaks English at various levels, however, there will be communication issues as many employees are from different parts of the world. You need to plan for the long-term growth of the brand and this means that employees will be working in different locations around the world for this new hospitality company entrant.

For this presentation, you will look at current hospitality leaders’ best practices in human resources. You are presenting your plan to the executive committee team at the annual strategic planning meeting. This means that there needs to be buy-in from the executive team and the leaders of the organization have to have confidence in your leadership. I would encourage you to look at Fairmont Hotels and Resorts and Four Seasons Hotels and Resorts in the accommodation sector. In addition, you may want to look at Tim Horton’s and Cactus Club in the food and beverage sector as they attempt to grow their global presence in the industry.

You need to address the following items in your presentation:

· Visa and Permit Issues

· Relocation Allowances and housing

· Language and Cultural training – Be specific

· Spousal employment concerns

· Health/medical/insurance issues

· Compensation and incentives

· Education for the children

You will need to provide a plan and this means that you will need to review the Strategy and Human Resources Planning. You will need to address the following:

1. Mission, Vision and Values

a. Identify purpose and scope and long term direction

2. External Analysis

a. Assess opportunities and threats

b. Conduct an environmental scanning (legal, political and environmental)

c. Analyze the industry and competitors (Fairmont, Marriott, Four Seasons, Tim Horton’s, Starbucks)

3. Internal Analysis

a. Analyze your firms strengths and weakness keeping in mind that you are a new entrant

b. Analyze and present your firm’s core competencies

c. Analyze your firms resources: people, process and systems

4. Strategy Formulation

a. Develop a corporate strategy for your new company

b. Develop a business strategy

5. Strategy Implementation

a. Design structure, systems and so on

b. Allocate resources

6. Evaluation

a. Evaluate benchmarking efforts with the leaders (Again, you can use Fairmont, Four Seasons and Marriott)

Be creative, enthusiastic and use the knowledge in the course to prepare your plan.

You are responsible for providing a minimum of five (5) slides of content and no more than (7). You need to provide with a minimum of five (5) content points in the notes section of your slides. This will keep you organized and on time.

Please provide a reference page with a list of references obtained.

This course is called Advanced Human Resources and you will need to sell your idea and your plan.

Human Resources Plan Grading Grid

1. Mission, Vision and Values (10 points)

2. External Analysis (20 points)

3. Internal Analysis (20 points)

4. Strategy Formulation (20 points)

5. Strategy Implementation (20 points)

6. Evaluation (10 points)

Total points (100)

Purpose:  This assignment is the second of three assignments.  Students will use the tools and concepts learned in the course and in previous business courses to develop an understanding of how organizations develop and manage strategies to establish, safeguard and sustain its position in a competitive market.

Students also have the opportunity to review an organization’s objectives and goals and the key functional areas within the organization.  Performing an internal environment analysis helps assess a firm’s internal resources and capabilities and plays a critical role in formulating strategy by identifying a firm’s strengths to overcome weaknesses.  Students will then 1) assess long-term objectives, 2) identify and evaluate alternative strategies and 3) recommend strategies for a company to pursue.

Instructions:

In completing the assignment, students will use the chapters in the eBook as a guide and perform research on the company from Assignment 1, answer the questions below in narrative form following the steps provided below: 

Step 1:  Create a double-spaced, 12-point font Word or Rich Text Format (RTF) document.  The final product should be 12 pages in length, which includes all tables and matrices but excludes the title page and reference page.  Do no use an Appendix.

Step 2:  Review assignment grading rubric.

Step 3:  Follow the following format using these topics as headings:

· Title page with title, your name, the course, the instructor’s name;

· Company Background/Information

· Internal Environmental Analysis

· Strategic Analysis & Strategy Selection

· Reference page

Step 4:  In writing the analysis, writing in the third person.  What this means is that there are no words such as “I, me, my, we, or us” (first person writing), nor is there use of “you or your” (second person writing).

Step 5:  In writing this assignment, students are asked to support the reasoning using in-text citations and a reference list.  If information is taken from a source document, it has to be cited and referenced.  A reference within a reference list cannot exist without an associated in-text citation and vice versa.  View the sample APA paper under Week 4 content and How to Cite and Reference, also under Week 4 content.  There are also resources located under Course Content>>Student Toolbox.

Step 6:  In writing this assignment, students are expected to paraphrase and not use direct quotes unless citing the mission statement of a company.

Step 7: Read all course material for weeks 1 through 6 and perform independent research to provide a comprehensive internal environmental analysis, strategy analysis and selection.

Step 8:  Jot down key facts about the company.  Consider making an outline to capture key points in the paper.

Step 9:  In your paper, respond to the following:

· Background analysis including vision and mission statements and objectives

· Internal Environmental Analysis

· Corporate Level Strategy

· Business Unit Level Strategy

· Functional Level Strategy

· Explain how these strategies align with the company’s vision and mission statements;

· Assess the company’s interactions with its stakeholders, the organizational structure, the organizational culture, and communication/decision making among managers within human resources, marketing production, operations, finance and accounting, R&D, and computer information systems, which can be accomplished by viewing the company’s website, interviews, and surveys.

· Financial analysis for the last reported fiscal year:

· Use the company’s income statement and balance sheet to calculate key (emphasis added), but no less than 10 key financial ratios to the business.  Show the calculations.

· Using Excel or a Word table, record key financial ratios in the first column;

· Research the industry average financial ratios for the same ratios above and record in a second column.  If you cannot find an industry average, then select another ratio;

· In the third column, indicate whether the financial ratio is a strength, a weakness or a neutral factor. Explain the results and compare and contrast the company financials to the industry.

· Technique Analysis: develop and explain an IFE, BCG matrix, Grand Strategy Matrix, and QSPM,

· Strategy Analysis:

· Identify company strengths and weaknesses. Discuss success factors and what the company must do to perform successfully in the industry?  Discuss what strategies would allow the company to capitalize on its major strengths.  Discuss strategies that would allow the company to improve upon its major weaknesses

· Generate a minimum of three possible alternative strategies for the company;

· Identify and discuss cultural factors that should be considered in analyzing and choosing among the alternative strategies;

· Prioritize and explain the selection of alternative strategies

· Recommend the best one or two strategies among the alternative strategies and explain why these strategies are the best;

Step 10:  Create an introductory paragraph.  The Introduction should clearly and concisely convey the main points of the assignment’s requirements.

Step 11:  Write a summary paragraph.  A summary paragraph restates the main idea(s) of the essay.  Make sure to leave a reader with a sense that the essay is complete.  The summary paragraph is the last paragraph of a paper. 

Step 12:  Using the grading rubric as a comparison, read through the paper to ensure all required elements are presented.

Step 13: Proofread the paper for spelling and grammatical issues, and third person writing.

· Use the spell and grammar check in Word as a first measure;

· Have someone who has excellent English skills to proof the paper;

· Consider submitting the paper to the Effective Writing Center (EWC).  The EWC will provide 4-6 areas that may need improvement.

Step 14:  Submit the paper in the Assignment Folder.

Course Objective:  Gain an understanding of the role ethical issues play in setting boundaries within which businesses operate.

Question posed: Can you identify and comment on personal experiences where some activity fell outside the “mission” of what you were doing. It might be that you and your colleagues took some action and realized after the fact that the action fell outside the mission. On the other hand, you might have been planning to do something and someone in leadership said no because it fell outside the mission.
b. If Enron had a lengthy code of ethics, which it did, exactly what happened to ruin their reputation?

c. Share your thoughts on the below link on the “World’s Most Ethical Companies in 2017”. Are you surprised by the list?

1.Evaluate

e power−5

using two approaches

e power−x=1–x+xpower2/2−xpower3/3!+……

and

epower−x=1/e power x=1/(1+x+(xpower2/2)+(xpower3/3!))+……

and compare with the true value of

6.737947×10power−3.

Use 20 terms to evaluate each series and compute true and approximate relative errors as terms are added.

2.The derivative of f(x)=1/(1-3x power2) is given by

6x/(1=3x power 2)whole power2

Do you expect to have difficulties evaluating this function at x =0.577? Try it using 3- and 4-digit arithmetic with chopping.

3.(a)Evaluate the polynomial

y=xpower 3-5xpower2+6x+0.55

at x =1.37. Use 3-digit arithmetic with chopping. Evaluate thepercent relative error.

(b)Repeat(a) but express y as

y=((x-5)x+6)x=0.55

Evaluate the error and compare with part(a).

 

4.Use 5-digit arithmetic with chopping to determine the roots of the following equation with Eqs. (3.12) and (3.13)

xpower2-5000.002x+10

Compute percent relative errors for your results.

5.The “divide and average” method, an old-time method for approximating the square root of any positive number

a, can be formulated as

x=(x+(a/x))/2

Write a well-structured function to implement this algorithm basedon the algorithm outlined in Fig. 3.3