WarPigl3t
Well-known Member
- Joined
- May 25, 2014
- Messages
- 1,611
Hey guys and gals. I don't have a spreadsheet yet. I was hoping you could help me figure out a formula and I would create the spreadsheet afterwards. It seems simple enough, but the solution eludes me. Here's the senerio:
There are 3 work shifts in a day. Lets take Friday for example. I would look at last week's sales report and determine that we made $2000 last Friday. Now I have job assignment for employees such as mop the floor, clean bathrooms, etc. I am going to determine how long it takes to do each task and sum up the minutes. So on Friday for shift 1, we'll just say that there is 2 hours worth of tasks and the rest of the time is spend helping customers. What I'm trying to calculate is the amount of time that is not spent ringing up customers at the cash register using sales data. So what here's what I'm thinking. I look at the job assignments list for the last week and determine what was done. Then I look at the sales data and see how much money we made that day. According to the job assignments, they completed 2 hours of tasks and we made $2000 that day. On Saturday they completed 1 hour of tasks and we made $3000 that day. It's obvious that depending on how much money we make, we have less time for other work tasks. Using the sales data and previous job assignments, I want to figure out the average amount of time in 1 hour is used on the customer and how much is used on tasks. So for example, 1 hour of work might mean 45 minutes with customers and 15 minutes on tasks. I hope this makes sense.
Background: I'm the new assistant manager and have been tasked out to create a more efficient work schedule. Currently we have days where nothing gets done because we are so busy with customers. I need to schedule enough employees to get these jobs done but I can't go over budget. So I need to know how much time is needed to complete tasks based on sales data. Using the formula you help me with, I'll be able to determine if we need 1, 2, or 3 employees to work and for how many hours does the 3rd employee need to be there. You are helping me and my company become more efficient while minimizing payroll costs.
There are 3 work shifts in a day. Lets take Friday for example. I would look at last week's sales report and determine that we made $2000 last Friday. Now I have job assignment for employees such as mop the floor, clean bathrooms, etc. I am going to determine how long it takes to do each task and sum up the minutes. So on Friday for shift 1, we'll just say that there is 2 hours worth of tasks and the rest of the time is spend helping customers. What I'm trying to calculate is the amount of time that is not spent ringing up customers at the cash register using sales data. So what here's what I'm thinking. I look at the job assignments list for the last week and determine what was done. Then I look at the sales data and see how much money we made that day. According to the job assignments, they completed 2 hours of tasks and we made $2000 that day. On Saturday they completed 1 hour of tasks and we made $3000 that day. It's obvious that depending on how much money we make, we have less time for other work tasks. Using the sales data and previous job assignments, I want to figure out the average amount of time in 1 hour is used on the customer and how much is used on tasks. So for example, 1 hour of work might mean 45 minutes with customers and 15 minutes on tasks. I hope this makes sense.
Background: I'm the new assistant manager and have been tasked out to create a more efficient work schedule. Currently we have days where nothing gets done because we are so busy with customers. I need to schedule enough employees to get these jobs done but I can't go over budget. So I need to know how much time is needed to complete tasks based on sales data. Using the formula you help me with, I'll be able to determine if we need 1, 2, or 3 employees to work and for how many hours does the 3rd employee need to be there. You are helping me and my company become more efficient while minimizing payroll costs.