Hello - I'm brand new here ... reaching out for help because I'm stumped!
I have been asked to run a daily report at work that calculates productivity (sales $'s per man hour) - for our distribution center.
We ship product for three separate sales business units and each unit has a budgeted $ per man hour that I am working with.
For example:
Business A = $745 / hr (.23)
Business B = $2200 / hr (.68)
Business C = $280 / hr (.08)
The combined $'s per man hour = $1697 (if I've calculated the weighted averages correctly).
Each day I will run actual $'s shipped with actual hours worked and report the daily $'s per man hour for each business unit (each day the combined $'s per man hour will be a weighted average based on actual $'s shipped by each division)
The rub comes in with the monthly running total for the combined $'s per man hour.
Can you please explain how it should be calculated? My co-worker and I have different opinions ...
I am unsure if that total would be a simple calculation of total hours worked month to date divided into total $'s shipped month to date ... or if something different needs to be done since the daily data is based on a weighted average.
I hope this makes sense and truly appreciate any help someone might give!!
TIA!!
I have been asked to run a daily report at work that calculates productivity (sales $'s per man hour) - for our distribution center.
We ship product for three separate sales business units and each unit has a budgeted $ per man hour that I am working with.
For example:
Business A = $745 / hr (.23)
Business B = $2200 / hr (.68)
Business C = $280 / hr (.08)
The combined $'s per man hour = $1697 (if I've calculated the weighted averages correctly).
Each day I will run actual $'s shipped with actual hours worked and report the daily $'s per man hour for each business unit (each day the combined $'s per man hour will be a weighted average based on actual $'s shipped by each division)
The rub comes in with the monthly running total for the combined $'s per man hour.
Can you please explain how it should be calculated? My co-worker and I have different opinions ...
I am unsure if that total would be a simple calculation of total hours worked month to date divided into total $'s shipped month to date ... or if something different needs to be done since the daily data is based on a weighted average.
I hope this makes sense and truly appreciate any help someone might give!!
TIA!!