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.
Team and projects Allan's times Team members Allan Brian Cameron Diana Eva Annual compensation (S) 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 E Date Company Project 3-May-20 ABC Corp Hospital digitiration 4-May-20 ABC Corp Hospital digitization 5-May-20 ABC Corp Hospital digitiration 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 disitization 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 Hears worked Status 10 WIP 9 WIP 10 WIP 10 WIP 9 WIP 9 WIP 9 WIP TO WIP 10 WIP 9 WIP 3 WIP SWIP 3 WIP 6 WIP SWIP SWIP 2 WIP & WIP 2 WIP 9 WIP 11 WIP 2/ WIP 9 WIP 9 WIP 3 Completed 9 WIP WIP 1 | WIP 10 WIP 14 Completed 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 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-201.cave 28-May-20 L.cave 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 & WIP 1 WIP 11 WIP 10 WIP 9 WIP 9 WIP 2 WIP 8 WIP 6 WIP 2 WIP 10 WIP SWIP s Completed 9 WIP 9 WIP 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 digitiration 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 dagitization 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 WIP 10 WIP 101 WIP 11 WIP 9 WIP 10 WIP 9 WIP 11 WIP 9 WIP 12 WIP 9 WIP WIP 12 WIP 11 WIP 14 WIP 12 Submitted 10 WIP 12 WIP 13 WIP SWIP 11 WIP 9 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 S-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 & WIP 9 WIP 9 WIP 9 WIP 10 WIP & WIP & WIP 7| WIP 9 WIP 6 WIP 9 WIP 8 WIP 9 WIP 7 WIP 9WIP 6 WIP 9 WIP 9 WIP SWIP 9 WIP 8/ WIP 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 SWIP 9 WIP 9 WIP 9 WIP 9 WIP 9 WIP 11 WIP 13 WIP 13 WIP 12 WIP 12 WIP 12 WIP 12 WIP WIP 12) WIP 12 WIP 13 Final Team and projects Allan's times Team members Allan Brian Cameron Diana Eva Annual compensation (S) 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 E Date Company Project 3-May-20 ABC Corp Hospital digitiration 4-May-20 ABC Corp Hospital digitization 5-May-20 ABC Corp Hospital digitiration 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 disitization 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 Hears worked Status 10 WIP 9 WIP 10 WIP 10 WIP 9 WIP 9 WIP 9 WIP TO WIP 10 WIP 9 WIP 3 WIP SWIP 3 WIP 6 WIP SWIP SWIP 2 WIP & WIP 2 WIP 9 WIP 11 WIP 2/ WIP 9 WIP 9 WIP 3 Completed 9 WIP WIP 1 | WIP 10 WIP 14 Completed 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 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-201.cave 28-May-20 L.cave 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 & WIP 1 WIP 11 WIP 10 WIP 9 WIP 9 WIP 2 WIP 8 WIP 6 WIP 2 WIP 10 WIP SWIP s Completed 9 WIP 9 WIP 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 digitiration 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 dagitization 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 WIP 10 WIP 101 WIP 11 WIP 9 WIP 10 WIP 9 WIP 11 WIP 9 WIP 12 WIP 9 WIP WIP 12 WIP 11 WIP 14 WIP 12 Submitted 10 WIP 12 WIP 13 WIP SWIP 11 WIP 9 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 S-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 & WIP 9 WIP 9 WIP 9 WIP 10 WIP & WIP & WIP 7| WIP 9 WIP 6 WIP 9 WIP 8 WIP 9 WIP 7 WIP 9WIP 6 WIP 9 WIP 9 WIP SWIP 9 WIP 8/ WIP 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 SWIP 9 WIP 9 WIP 9 WIP 9 WIP 9 WIP 11 WIP 13 WIP 13 WIP 12 WIP 12 WIP 12 WIP 12 WIP WIP 12) WIP 12 WIP 13 Final