you should first read two handouts and answer all the quiz I provided, and then do the prelab writing

1.Download and open the P6-DataFile.xlsx workbook.

2.Open the Part1 spreadsheet. This spreadsheet includes some data and an image of a chart that effectively communicates something interesting about the data.

3.Using the chart image as your sample, perfectly recreate the chart yourself. You must recreate all elements of the chart.

A.Wording, placement, alignment, and relative sizing all must be exactly the same as the sample. The actual colors and fonts you use are not critical—you have flexibility with those.

B.You will need to use textboxes and creativity to place the text and some labeling properly.

C.The size of the end points of the lines are slightly larger than the default size.

D.There must not be any inadvertent marks, lines, or text on your chart.

Part 2: Create new visuals

Requirements:

1.Go to the Part2 spreadsheet in the same workbook. This spreadsheet shows data for the capacity vs. the demand for project hours over time. Think about the data and how you might best present an interesting element of it in a chart.

2.Quickly create at least four possible charts that could serve as potential designs for visualizing the data or communicating an important aspect of the data.

A.You must create your four charts in the same Part 2 spreadsheet below the data.

B.Your draft charts do not need to look professional, but the important parts of the charts should be labelled.

C.You will not be evaluated on the appearance and detail of these charts. They should be quick drafts to brainstorm ideas for your final chart.

D.You may create more than four potential charts.

E.You should keep all of your charts in your Part 2 spreadsheet.

3.After exploring different designs and elements of the data, decide on what message you want to present with your final chart. Then write your answers to the questions found in E4-E6 in the spreadsheet. (You must write the actual answers to your questions in your Excel file—column F is fine.)

A.Who is your target audience for this chart?

B.What is the main message you are trying to communicate with this chart?

C.What action do you want your audience to take because of this chart?

4.After answering the questions and considering the effectiveness of the different chart designs, select a chart design to use for your final chart.

5.Create a professional chart that looks great and effectively communicates your message to your target audience. Pay close attention to detail and apply the design principles and skills we learned in class.

A.Create your chart in the same spreadsheet.

B.You will be evaluated based on appearance, design, consistency, and professionalism.

C.You will be evaluated based on the principles covered in class.

D.Use effective titling and labelling.

E.Use welcome to use text judiciously in your chart.

F.You can summarize, aggregate, or transform the data as long as you maintain the integrity of the data.

G.Your chart should not be the same or very similar to anyone else’s chart. If your chart is the same or similar to that of any other student(s), you all will only receive partial credit for your charts.

6.When you have completed your chart, be sure it and all of your design drafts are saved in the Part 2 spreadsheet.

When you are finished with the two parts, submit your Excel workbook with both spreadsheets to Blackboard before 5pm on Friday.

You have 75 minutes to complete this exam. Although the exam will automatically save and submit once your time limit has been reached, please make sure you submit the exam when completed. You will only have one opportunity to complete the exam, so prepare accordingly and choose your location wisely. The correct answers will be made available once the exam deadline for all students has passed. Good luck!

Assignment 2: Compensation Plan Outline

Using the same company you researched in Assignment 1, evaluate the company’s compensation plan to determine how it could be improved.

Write a six to eight (6-8) page paper in which you:

1. Evaluate the existing compensation plan to determine if it is the most appropriate for your company. Explain your rationale.
2. Determine the most beneficial ratio of internally consistent and market consistent compensation systems for the company you selected.
3. Evaluate the current pay structure used by your company and assess the recognition of employee contributions.
4. Make two (2) recommendations for improving the effectiveness of the discretionary benefits provided by the company you selected.
5. Evaluate the types of employer-sponsored retirement plans and health insurance programs provided by the company you selected and compare them to that company’s major competitors.
6. Use at least three (3) quality references. Note: Wikipedia and other websites do not qualify as academic resources.

Your assignment must follow these formatting requirements:

• This course requires use of new Strayer Writing Standards (SWS). The format is different than other Strayer University courses. Please take a moment to review the SWS documentation for details.
• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; references must follow SWS or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required page length.

The specific course learning outcomes associated with this assignment are:

• Evaluate the effectiveness of traditional bases for pay (seniority and merit) against incentive-based and person-focused compensation approaches.
• Compare and contrast internally consistent and market-competitive compensation systems.
• Evaluate the role of benefits in strategic compensation.
• Use technology and information resources to research issues in compensation management.
• Write clearly and concisely about compensation management using proper writing mechanics.

Required Resources

Martocchio, J. J. (2017).Strategic compensation: A human resource management approach (9th ed.). Upper Saddle River, NJ: Prentice Hall / Pearson.

Supplemental Resources

Consul, J. (2014). Compensation. Financial Executive, 30(1), 17-19.

Held, J. (2016). Benefit trends: benefits a big part of compensation. Benefits Magazine, 57(7), 8-10.

Huang, Q., Jiang, F., Lie, E., & Que, T. (2017). The effect of labor unions on CEO compensation. Journal of Financial & Quantitative Analysis, 52(2), 553-582

Nagel, D. (2017). Salary & Job satisfaction. T H E Journal, 44(1) 6-9.

Quintana-García, C., & Elvira, M. M. (2017). The effect of the external labor market on the gender pay gap among executives. ILR Review, 70(1), 132-159. doi:10.1177/0019793916668529

Walls, M. (2017). Ways in which workers’ compensation needs to evolve. Property & Casualty 360, 120(12), 26-29.

The Society of Human Resources Management (2012). General format. Retrieved from http://www.shrm.org

WorldatWork. (n.d.). General format. Retrieved from http://www.worldatwork.org

Respond to the following scenario with your thoughts, ideas, and comments. Be substantive and clear, and use research to reinforce your ideas.

You’re meeting with Lester in his office to discuss the details of your presentation to the board next week.

“Given all of the research that you have completed over the past several weeks,” he says, “you should have most of the information you need to make a presentation to the board. The board doesn’t want you to do any more research on all of the topics; rather, we want you to summarize the research that you have already done. “

“Yes,” you say. “I think I have what I need.”

“Of course we want your final conclusion and recommendation on what the company should do regarding the location issue, as well,” he says.

“What type of presentation do you have in mind, Lester?”

“A PowerPoint presentation would be appropriate for this group,” he says. “I want you to include slide notes, too, in case we have to go back and look at something at a later date. Your PowerPoint presentation should contain between 7-10 slides, not including the title slide and reference slide(s). For each slide, you should have between 150–200 words in the Notes sections. Let’s take a few minutes now to go over how the slides should be organized. I’ve done similar presentations, so I can save you some time with a few pointers.”

When you get back to your office, you type out your notes about each element you discussed and the overall organization of the presentation. For this presentation, you are addressing the following elements:

• Legal, social, and financial factor considerations
• Economic factors: gross domestic product (GDP), inflation, interest rates, unemployment
• Elasticity of demand
• Economies of scale and efficiency
• Strengths, weaknesses, opportunities, and threats (SWOT)
• Market structure
• Risk
• Costs (marginal, fixed, variable, etc.)
• International expansion (Five factors that should be considered before making the decision to expand internationally)

Deliverable Length: 7-10 slides + 150 words per slide in the notes, APA format (in text citations)