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:

Accounting Profit

The total revenue of a business minus the explicit costs associated with that business, as calculated for financial accounting and reporting purposes.

Explicit Costs

Direct, out-of-pocket payments made by businesses for resources and services.

ATC

Average Total Cost, which is the total cost of production divided by the number of goods produced, representing the per unit cost of production.

AVC

Average Variable Cost is the total variable costs divided by the quantity of output produced; it represents the variable cost per unit of output.