The Daily Management Worksheet is a tool to help you update your production board. It has tabs for planning your demand and staffing. This information is automatically added to the production board worksheet to help you manage your day.
Click the image to download a copy of our Daily Management Worksheet.
If you like our forms & tools, please help us spread the word about them!
The production board is the cornerstone of daily management. It is a very visual indicator of a team’s progress, and makes sure that everyone has the same understanding of the current condition of the team.
Note that you will likely need to make modifications to this tool to match your staff size, types of work, start times, etc. Feel free to adjust the tool as needed, but please do not redistribute it outside of your own company.
On this worksheet, the light gray blocks are filled out on a daily basis. The dark gray blocks are updated less frequently.
Using the Daily Management Worksheet
Fill out the hour-by-hour demand patterns of your products on the ‘Demand’ tab.
Enter the relative weights of the type of work your team does. Use task ‘A’ as the base task and set it to ‘1’. For example, if task ‘B’ takes one and a half times as long as task ‘A’, it would be weighted 1.5.
On the ‘Staffing’ tab, enter the current productivity (items per hour).
Enter the schedule of your staff on the ‘Staffing’ tab. Adjust for lunches, stand-up meetings, cleanup time, etc.
Enter the skill level of the person, with ‘1’ meaning the person produces at exactly the planning rate. Caution: This can be a sensitive issue. You may choose to use it only for trainees.
If a person is absent for the day, enter a ‘0’ next to the ‘<-Absent’ label.
Enter adjustments in the ‘Out’/’Extra’ boxes. The formulas subtract hours from the ‘Out’ column and add to the ‘Extra’ column, so there is no need to include minus signs.
On the ‘Production Board’ tab, you will see the results of the Demand and Staffing data you entered in the Plan column.
Set the ‘End of Day Target’ for your queue. Depending on your specific customer requirements and the way your work flows, you may not want to work down to 0 every day. The most likely reason is to prevent starving the team of work the next morning.
Enter the size of the queue at the start of the workday. It will be equivalent to the previous end-of-day backlog plus the overnight demand.
Enter any specific adjustments to demand. This would include known one-time variations in demand, such as if a customer calls to tell you to expect several additional orders.
Changes to staffing should be done on the staffing tab. Other capacity changes, such as system downtime or additional help from another team should be entered on the capacity adjustment column.
As the day progresses, enter the actual incoming work and output in the appropriate columns at the specified times.