I am stuck with part of a very big problem. I need to figure out the work hours/visits as well as the adjusted work hours/visits along with the work hours/adjusted visits and adjusted work hours/adjusted visits. I have attached the excel sheet below which shows part of the problem.
Please see the attached file for solution.
Adjusted Visits: Adjusted Visits are calculated based on the ratios of visits provided and what is the effectiveness of each visit. So for example, for location 1, 30% of …
The solution provides details regarding calculating productivity based on adjusted hours and adjusted visits.