Explore BrainMass

Calculating Productivity Based on Adjusted Hours/Visits

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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.

© BrainMass Inc. brainmass.com October 25, 2018, 9:42 am ad1c9bdddf


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.