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:

Equilibrium Quantity

The quantity of goods or services that are supplied and demanded at the equilibrium price, where the amount producers are willing to sell equals the amount consumers are willing to buy.

Price of Ingredients

The cost of raw materials used in the production of goods, which can impact the final price of the product and profitability of producers.

Cattle Feed

A type of food specifically formulated and provided for the dietary needs of cattle, including grains, hay, and other nutrients.

Supply Curve for Milk

A graphical representation showing the relationship between the quantity of milk that producers are willing to sell and the price of milk.