The Project Lead in an MNC Decides to Assign Every

question 50

Essay

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:

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 member who scored negative? Which month has the highest negative performance scores?

---

Definitions:

Labor Demand

The quantity of labor that employers are willing and able to hire at a given wage rate, in a given time period.

Deadweight Loss

The falloff in economic efficiency that strikes when equilibrium for a good or service isn’t met or is beyond reach.

Tax Revenue

The revenue governments receive as a consequence of taxes.

Deadweight Loss

Failure to reach free market equilibrium for a good or service leads to a loss in economic efficiency.