The project lead in an MNC decides to assign every member of his team to a new project and monitors their performance on a customized scale of scores. The data on their performance over a period of six months are shown below.

 Performance Scores
Team members
Jan
Feb
Mar
Apr
May
 Jun1
4
5
2
3
-1
 32
2
2
3
1
4
 43
-1
4
4
4
5
 14
5
1
4
2
5
 35
2
2
1
5
4
 46
4
1
2
1
-1
 47
1
5
-1
2
5
 18
1
2
5
5
4
 29
4
5
3
4
2
 210
4
5
2
2
-1
 511
5
-1
5
1
2
 212
3
2
-1
-1
1
 213
-1
1
4
-1
4
 514
2
3
3
2
-1
 415
5
-1
5
5
1
 116
5
2
1
5
2
 -117
5
-1
4
-1
2
 118
3
4
-1
5
2
 419
2
3
5
1
3
 120
4
4
3
1
-1
 521
3
1
1
4
-1
 422
3
1
5
5
4
 223
2
2
-1
3
2
 -124
1
2
4
4
4
 325
3
5
-1
2
5
 4
a. Create a heat map in Excel that shades the cells with negative performance scores. Use Excel's Conditional Formatting function to create this heat map.b. For each month, identify the team members who scored negative. Which month has the highest negative performance scores?
?

What will be an ideal response?


?

a.

?

b. January: Team members 3 and 13.

February: Team members 11, 15, and 17.
March: Team members 7, 12, 18, 23, and 25.
April: Team members 12, 13, and 17.
May: Team members 1, 6, 10, 14, 20, and 21.
June: Team members 16 and 23.
We observe that most team members scored negative in the month of May.


Business

You might also like to view...

The following are all elements of Title 26, U.S. Code Section 7201 EXCEPT:

a. not reporting bribe income may be grounds for being charged with tax evasion. b. filing income tax that excludes income from fraud may be considered an improper tax filing. c. bribes paid may be deducted as business expenses. d. failure to report income from fraud may be grounds for being charged with tax evasion.

Business

Which of the following is a difference between Area III and Area IV of the Johari Window??

A) ?Area III represents things we know about ourselves but that others do not know about us, whereas Area IV includes things we do not know about ourselves and others do not know about us. B) ?Area III includes things we do not know about ourselves and others do not know about us, whereas Area IV represents things we know about ourselves but that others do not know about us. C) ?Area III represents what we know about ourselves and what others know about us, whereas Area IV designates those things others know about us but that we do not know about ourselves. D) ?Area III designates those things others know about us but that we do not know about ourselves, whereas Area IV represents what we know about ourselves and what others know about us.

Business

Which leadership style of the Hersey and Blanchard model entails allowing followers to work independently with little or no overseeing?

A. Telling B. Selling C. Participating D. Delegating E. Situational

Business

Small business start-ups are likely to find that getting commercial loans are:

A. difficult because lenders are reluctant to give loans to firms that do not have a track record. B. one of the most flexible ways of obtaining financing because local bankers are usually eager to establish relationships with new companies. C. the most difficult because start-ups require higher financing than what banks can offer. D. the best way to obtain all the financing they need as lenders usually get an ownership stake in the companies.

Business