Hello, I am builiding a Labor breakdown by employee that will show me how many hours I can afford to pay them based on the given labor dollars that I have on hand currently.
Here are the two areas where I am drawing a blank:
What formulas do I use that will divide up my labor bank by each employee's hourly rate.
Although I show a monthly breakdown I would like a formula to determine how far out my money will take me.
Here is a sample spreadsheet that I've attached.
You're asking Excel to do things best suited for the human brain, in my opinion. But Excel can help along the way. It's simple to add check cells for each month as you add in your hours.
I guess Excel COULD tell you how many hours to give each employee, but only after you develop a full chart denoting each employee "type" and what percentage of hours goes to each type pool, etc.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Yeah - That's basically what I told my boss. Who thought I should be doing this w/in Access. Uh - NO! Access is going to house all the labor and contract data, but I'm going to have to do dumps to Excel to give him what he's wanting here.
Thanks for your assistance, at least the SUMPRODUCT formula will help me some. I've never really used that one.
here is another aproach
It assumes everyone will try to work 173 hours / month as default
as you enter the hours it will adjust, and tell you how many months you can pay everyone at 173 hours
if there is not enough left for 173 hours it will set everyon to a lower level for the rest of the time
entering actual hours will adjust all other rows!
Regards
Darren
Update 12-Nov-2010 Still job hunting!
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
Glad I could help at least a little.
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].
(Also, use the "scales" icon in our posts to leave Feedback, it is appreciated)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks