Cost Driver Analysis - Need formula to allocate manpower cost

I am working on calculating the cost drivers.

We have 19 “Departments”, 11 “Head of the Departments” and around 1000+ “Employees”.

Due to Job rotation, Supervisory, Internal Expertise etc staff are often pulled / allocated to other department out of their parent department.

Form the staff attendance software we could get the monthly data of each staff worked in which department.

I have attached a sample database and my requirements.

I would appreciate if someone could help me getting the formula in the highlighted range of the attached worksheet.

Regards

Swastik

Hi Swastik,

Welcome to the Forum

Can you please amend your post title to be more descriptive of your problem in accordance with the Forum's Rule #1?

This allows users to identify if they are likely to be able help you at a glance & also makes the forum more searchable by users looking for solutions.

Rob