Question

1 Approved Answer

Posted on Jul 12, 2024

CARE is a growing consulting company in the healthcare sector with 50 employees in different locations. Each manager at CARE is responsible for tracking the

CARE is a growing consulting company in the healthcare sector with 50 employees in different locations. Each manager at CARE is responsible for tracking the profitability of the projects he/she is responsible for. Manager A oversees five team members currently working on three different projects. CARE follows a 5-day work week, with 9 hours work per day.

From the provided Excel file, analyze the data in terms of project profitability. Kindly provide your analysis and insights in an Excel sheet. Please make sure to include and explain any assumption you are making.

Assessment:

We will be assessing the comprehensiveness and accuracy of information included. We will also be looking closely at how you structure the information in a logical, insightful and easy to understand style.

Assessment:

Team and projects Allan's time Team members Allan Brian Cameron Diana Eva Annual compensation (8) 87.000 83.000 68,000 120,000 52.000 Client ABC Corp ACME XYZ Inc. Project Hospital digitization Restructuring Clinic acquisition Sales (S) 8000 3000 10500 Team and projects Allan's time sheet Date Company Project 3-May-20 ABC Corp Hospital digitization 4-May-20 ABC Corp Hospital digitization 5-May-20 ABC Corp Hospital digitization 6-May-20 ABC Corp Hospital digitization 7-May-20 ABC Corp Hospital digitization 10-May-20 ABC Corp Hospital digitization 11-May-20 ABC Corp Hospital digitization 12-May-20 ABC Corp Hospital digitization 13-May-20 ABC Corp Hospital digitization 14-May-20 ABC Corp Hospital digitization 16-May-20 ABC Corp Hospital digitization 16-May-20 ACME Restructuring 17-May-20 ABC Corp Hospital digitization 17-May-20 ACME Restructuring 18-May-20 ABC Corp Hospital digitization 19-May-20 ACME Restructuring 20-May-20 ABC Corp Hospital digitization 20-May-20 ACME Restructuring 21-May-20 ABC Corp Hospital digitization 21-May-20 ACME Restructuring 22-May-20 ACME Restructuring 23-May-20 ABC Corp Hospital digitization 23-May-20 ACME Restructuring 24-May-20 ACME Restructuring 25-May-20 ABC Corp Hospital digitization 25-May-20 ABC Corp Restructuring 26-May-20 ACME Restructuring 27-May-20 ACME Restructuring 28-May-20 ACME Restructuring 31-May-20 ACME Restructuring Hours worked Status 10 WIP 9 WIP 10 WIP 11 WIP 9 WIP 9 WIP 9 WIP 11 WIP 10 WIP 9 WIP 3 WIP & WIP 3 WIP 6 WIP SWIP S WIP 2 WIP & WIP 2 WIP 9 WIP 11 WIP 2 WIP 9 WIP 9 WIP 3 Completed 9 WIP 11 WIP TWIP 10 WIP 14|Completed Team and projects Allan's time sheet Date Company Project Hours worked Status 3-May-20 ABC Corp Hospital digitization 9 WIP 4-May-20 ABC Corp Hospital digitization 9 WIP 5-May-20 XYZ Inc. Clinic acquisition 9 WIP 6-May-20 ABC Corp Hospital digitization 10 WIP 7-May-20 ABC Corg Hospital digitization 11 WIP 10-May-20 ABC Corp Hospital digitization 10 WIP 11-May-20 ABC Corp Hospital digitization 12 WIP 12-May-20 ABC Corp Hospital digitization 10 WIP 13-May-20 ABC Com Hospital digitization 9 WIP 14-May-20 XYZ Inc. Clinic acquisition 9 WIP 17-May-20 ABC Corp Hospital digitization & WIP 17-May-20 XYZ Inc. Clinic acquisition 1 WIP 18-May-20 XYZ Inc. Clinic acquisition 11 WIP 19-May-20 XYZ Inc. Clinic acquisition 10 WIP 20-May-20 XYZ Inc. Clinic acquisition 9 WIP 21-May-20 XYZ Inc. Clinic acquisition 9 WIP 22-May-20 XYZ Inc. Clinic acquisition 2 WIP 22-May-20 ABC Corp Hospital digitization 8 WIP 23-May-20 ABC Corp Hospital digitization 6WIP 23-May-20 XYZ Inc. Clinic acquisition 2 WIP 24-May-20 ABC Corp Hospital digitization 10 WIP 25-May-20 XYZ Inc. Clinic acquisition SWIP 25-May-20 ABC Corp Hospital digitization Completed 26-May-20 Leave 27-May-20 Leave 28-May-20 Leave 29-May-20 XYZ Inc. Clinic acquisition 9 WIP 30-May-20 XYZ Inc. Clinic acquisition 9 WIP 31-May-20 XYZ Inc. Clinic acquisition 10 WIP Team and projects Allan's time sheet Date Company Project 3-May-20 ABC Corp Hospital digitization 4-May-20 ABC Corp Hospital digitization 5-May-20 ABC Corp Hospital digitization 6-May-20 ABC Corp Hospital digitization 7-May-20 ABC Corp Hospital digitization 10-May-20 ABC Corp Hospital digitization 11-May-20 ABC Corp Hospital digitization 12-May-20 ABC Corp Hospital digitization 13-May-20 ABC Corp Hospital digitization 14-May-20 ABC Corp Hospital digitization 17-May-20 ABC Corp Hospital digitization 18-May-20 ABC Corp Hospital digitization 19-May-20 ABC Corp Hospital digitization 20-May-20 ABC Corp Hospital digitization 21-May-20 ABC Corp Hospital digitization 24-May-20 ABC Corp Hospital digitization 25-May-20 ABC Corp Hospital digitization 26-May-20 ACME Restructuring 27-May-20 ACME Restructuring 28-May-20 ACME Restructuring 29-May-20 ACME Restructuring 30-May-20 ACME Restructuring 31-May-20 ACME Restructuring Hours worked Status 9 WIP 11 WIP 10 WIP 10 WIP 11 WIP 9 WIP 10 WIP 9 WIP 11 WIP 9 WIP 12 WIP 9 WIP 1 WIP 12 WIP 11 WIP 14 WIP 12 Submitted 10 WIP 12 WIP 13 WIP & WIP NI WIP Submitted Team and projects Allan's time sheet Date Company Project 3-May-20 XYZ Inc. Clinic acquisition 4-May-20 XYZ Inc. Clinic acquisition 5-May-20 XYZ Inc. Clinic acquisition 6-May-20 XYZ Inc. Clinic acquisition 7-May-20 XYZ Inc. Clinic acquisition 10-May-20 XYZ Inc. Clinic acquisition 11-May-20 XYZ Inc. Clinic acquisition 12-May-20 XYZ Inc. Clinic acquisition 13-May-20 XYZ Inc. Clinic acquisition 14-May-20 XYZ Inc. Clinic acquisition 17-May-20 XYZ Inc. Clinic acquisition 18-May-20 XYZ Inc. Clinic acquisition 19-May-20 XYZ Inc. Clinic acquisition 20-May-20 XYZ Inc. Clinic acquisition 21-May-20 XYZ Inc. Clinic acquisition 24-May-20 XYZ Inc. Clinic acquisition 25-May-20 XYZ Inc. Clinic acquisition 26-May-20 XYZ Inc. Clinic acquisition 27-May-20 XYZ Inc. Clinic acquisition 28-May-20 XYZ Inc. Clinic acquisition 31-May-20 XYZ Inc. Clinic acquisition Hours worked Status 8 WIP 9 WIP 9 WIP 9 WIP 10 WIP 8/ WIP 8 WIP 7 WIP 9 WIP 6 WIP 9 WIP SWIP 9 WIP 7 WIP 9 WIP 6 WIP 9 WIP 9 WIP SWIP 9 WIP SWIP Team and projects Allan's time sheet Date Company Project 3-May-20 XYZ Inc Clinic acquisition 4-May-20 XYZ Inc. Clinic acquisition 5-May-20 XYZ Inc. Clinic acquisition 6-May-20 XYZ Inc. Clinic acquisition 7-May-20 XYZ Inc. Clinic acquisition 10-May-20 XYZ Inc. Clinic acquisition 11-May-20 XYZ Inc. Clinic acquisition 12-May-20 XYZ Inc. Clinic acquisition 13-May-20 XYZ Inc. Clinic acquisition 14-May-20 XYZ Inc. Clinic acquisition 17-May-20 ACME Restructuring 18-May-20 ACME Restructuring 19-May-20 ACME Restructuring 20-May-20 ACME Restructuring 21-May-20 ACME Restructuring 24-May-20 ACME Restructuring 25-May-20 ACME Restructuring 26-May-20 ACME Restructuring 27-May-20 ACME Restructuring 28-May-20 ACME Restructuring 31-May-20 ACME Restructuring Hours worked Status 9 WIP 9 WIP 9 WIP 9 WIP 9 WIP 9 WIP 9 WIP 9 WIP 9 WIP 9 WIP 11 WIP 13/ WIP 13 WIP 12 WIP 12 WIP 12 WIP 12 WIP 13 WIP 12/ WIP 12 WIP 13 Final Team and projects Allan's time sheet Brian's tir Team members Allan Brian Cameron Diana Eva Annual compensation (5) 87.000 83.000 68,000 120,000 52.000 Client ABC Corp ACME XYZ Inc. Project Hospital digitization Restructuring Clinic acquisition Sales (S) 8000 3000 10500 Team and projects Allan's time sheet Brian Date Company Project 3-May-20 ABC Corp Hospital digitization 4-May-20 ABC Corp Hospital digitization 5-May-20 ABC Corp Hospital digitization 6-May-20 ABC Corp Hospital digitization 7-May-20 ABC Corp Hospital digitization 10-May-20 ABC Corp Hospital digitization 11-May-20 ABC Corp Hospital digitization 12-May-20 ABC Corp Hospital digitization 13-May-20 ABC Corp Hospital digitization 14-May-20 ABC Corp Hospital digitization 16-May-20 ABC Corp Hospital digitization 16-May-20 ACME Restructuring 17-May-20 ABC Corp Hospital digitization 17-May-20 ACME Restructuring 18-May-20 ABC Corp Hospital digitization 19-May-20 ACME Restructuring 20-May-20 ABC Corp Hospital digitization 20-May-20 ACME Restructuring 21-May-20 ABC Corp Hospital digitization 21-May-20 ACME Restructuring 22-May-20 ACME Restructuring 23-May-20 ABC Corp Hospital digitization 23-May-20 ACME Restructuring 24-May-20 ACME Restructuring 25-May-20 ABC Corp Hospital digitization 25-May-20 ABC Corp Restructuring 26-May-20 ACME Restructuring 27-May-20 ACME Restructuring 28-May-20 ACME Restructuring 31-May-20 ACME Restructuring Hours worked Status 10 WIP 9 WIP 10 WIP 11 WIP 9 WIP 9 WIP 9 WIP WIP 10 WIP 9 WIP 3 WIP 8 WIP 3 WIP 6 WIP SWIP SWIP 2 WIP 8 WIP 2 WIP 9 WIP 11 WIP 2 WIP 9 WIP 9 WIP 3 Completed 9 WIP 11 WIP 11 WIP 10 WIP 14 Completed Team and projects Allan's time sheet Brian's time sheet Date Company Project 3-May-20 ABC Corp Hospital digitization 4-May-20 ABC Corp Hospital digitization 5-May-20 XYZ Inc. Clinic acquisition 6-May-20 ABC Corp Hospital digitization 7-May-20 ABC Corp Hospital digitization 10-May-20 ABC Corp Hospital digitization 11-May-20 ABC Corp Hospital digitization 12-May-20 ABC Corp Hospital digitization 13-May-20 ABC Corp Hospital digitization 14-May-20 XYZ Inc. Clinic acquisition 17-May-20 ABC Corp Hospital digitization 17-May-20 XYZ Inc. Clinic acquisition 18-May-20 XYZ Inc. Clinic acquisition 19-May-20 XYZ Inc. Clinic acquisition 20-May-20 XYZ Inc. Clinic acquisition 21-May-20 XYZ Inc. Clinic acquisition 22-May-20 XYZ Inc. Clinic acquisition 22-May-20 ABC Corp Hospital digitization 23-May-20 ABC Corp Hospital digitization 23-May-20 XYZ Inc. Clinic acquisition 24-May-20 ABC Corp Hospital digitization 25-May-20 XYZ Inc. Clinic acquisition 25-May-20 ABC Corp Hospital digitization 26-May-20 Leave 27-May-20 Leave 28-May-20 Leave 29-May-20 XYZ Inc. Clinic acquisition 30-May-20 XYZ Inc. Clinic acquisition 31-May-20 XYZ Inc. Clinic acquisition Hours worked Status 9 WIP 9 WIP 9 WIP 10 WIP 11 WIP 10 WIP 12 WIP 10 WIP 9 WIP 9 WIP 8 WIP 1 WIP 11 WIP 10 WIP 9 WIP 9 WIP 2 WIP 8 WIP 6 WIP 2 WIP 10 WIP 5 WIP 5 Completed 9 WIP 9 WIP 10 WIP Team and projects Allan's time sheet Brian's time sheet Cameron's time sheet Diana's time Company Project 3-May-20 ABC Corp Hospital Saturation 4-May-20 ABC Corp Hospital digitation 5-May-20 ABC Cop Hospital argitation 6-May-20 ABC Corp Hospital digitization 7-May-20 ABC Corp Hospitalitation 10-May-20 ABC Corp Hospital digitiration 11-May-20 ABC Com Hospitalition 12 May 20 ABC Capital dutination 13-May-20 ABC Corp. Hospital digitization 14. May 20 ABC Corp Hospital distration 17-May-20 ARC Corp Hospital digitation 18-May-20 ATIC Comp Hospitalitation 19-May-20 AHCC Hospitalitation 20 May 20 ADICCleapital duration 21-May-20 ABC Corp Hospital digitation 24 May 20 ADC Com hospital dagitiration 25-May-20 ABC Corp Hospital digitization 26 May 20 ACME Restructuring 27-May-20 ACME Restructuring 28 May 20 ACME Returing 29-May-20 ACME Restructuring 30-May 20 ACME Restructuring 31-May-20 ACME Restructuring Hoors worked States 9WIP 11 WIP 10 WIP TO WIP 10 WIP 9 WIP 10 WIP 9 WIP 11 WIP 9 WIP 1: WIP 9 WIP 11 WIP 12 WIP It WIP 14 WIP 12 Suba 10 WIP 12 WIP 13 WIP WIP 11 WIP Submited Team and projects Allan's time sheet Brian's time sheet Cameron's time sheet Diana's time sheet Date Company Project 3-May-20 XYZ In Clinic equisition 4-May-20 XYZ Inc Clinic acquisition 5-May-20 XYZ Inc Clinic acquisition 5-May-20 XYZ Inc Clinic equisition 7-May-20 XYZ Inc Clinic acquisition 10-May-20 XYZ Inc. Clinicasquisition 11 May 20 XYZ toc Clinic acquisition 12. May-20 XYZ In Clinic quisition 13-May-20 XYZ in Clinic inquisition 14-May 20 XYZ I Clinic aquisition 17 May 20 XYZinc Clinic acquisition 18-May-20 XYZ Clinic exquisition 19-May-20 XYZ Inc Clinic acquisition 20-May-20 XYZ Inc. Clinicacyuisition 21 May 20 XYZ Clinic isition 24-May-20 KYZ loc. Clinic acquisition 25-May 20 XYZinc Clinic que 26-May-20 XYZ loc Clinic acquisition 27 May 20 XYZ Inc Clinic quisition 28-May-20 XYZ Inc Clinicquisition 31. May 20 XYZ Inc Clinic que Heated States WIP WIP 9 WIP WIP 10 WIP SWIP NWIP WIP WIP GWIP WIP WIP WIP WIP WIP WIP WIP 9 WIP WIP WIP WIP Team and projects Allan's time sheet Brian's time sheet Cameron's time sheet Diana's time sheet Eva's time sheet are MAHI wp SWIP WE Ir CA Say XYZ 4-Way 30 XY May 20 XYZ tanken 6 May 20 YZ 1 Cate May 20 KYZ Tani 10 May 20 SYNC 11 May 20 XYZ 12 May 20 SY 13 May 20 XYZ 11.10 KY/ IT 10 AMIR 10 ACME 13 May 0 ACME 20:20 AM RE 20 May 20 ALMI Det 26.0 ACME 25-May 10 ACME 26 May 30 ACME Rent 21. O ACME TR 25 May 20 ACME 10 ACME WIP SWAP 11 UP 17 UP UP UP UP UP 18 1