| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Payroll labor costs
How can I calculate/project payroll costs based on the employee weekly
schedule. I'm not sure what formula to use. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Payroll labor costs
It depends on how you set up the schedule, should it be a simple SUM? -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=558530 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Payroll labor costs
I don't believe a simple SUM would work. For each employee I input their
schedule by day. I want to type in i.e. 10:00 AM to 4:00 PM and have excel calculate the hours worked times their rate of pay (also calculate OT if applicable). The end result should one dollar figure that indicates the overall labor cost for all employees for each week. "Bearacade" wrote: It depends on how you set up the schedule, should it be a simple SUM? -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=558530 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Payroll labor costs
So let's say you have Column A: Time In Column B: Time Out Column C: B - A - Lunch hour Column D: Hourly Rate Column E: Calculate Rate (C*D)+((C-8)*(D/2)) Sum of Column E is your Weekly Payroll Projection Your formula would be a bit different if you calculate 40 hour week overtimes and other stuff. but this is the basis of it. This is why I say it depend on how you send up the schedule (And I should have said how you set up the spreadsheet) -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=558530 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need a payroll sheet that can auto update figures each week | Excel Worksheet Functions | |||
| How do you calculate payroll with tips? | Excel Discussion (Misc queries) | |||
| How do I keep each week's data from the payroll calcualtor? | Excel Worksheet Functions | |||
| payroll calculator for ontario canada, cant convert ontario rates. | Excel Discussion (Misc queries) | |||
| payroll calculator for ontario canada, cant convert ontario rates. | Excel Discussion (Misc queries) | |||
Linear Mode
