Explore BrainMass

Calculating Productivity Based on Adjusted Hours/Visits

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.


Solution Preview

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 ...

Solution Summary

The solution provides details regarding calculating productivity based on adjusted hours and adjusted visits.