Digital Workforce Planning for Car Dealerships: Shifts and Capacity

Digital workforce planning in a dealership means one calendar for all departments, where attendance, holiday, sickness and work models come together, with automatic alerts before a shortage occurs. Excel lists and post-it notes cannot do this, because they neither calculate capacity nor detect conflicts. Autohaus Plan, which PK Solutions built for Autohaus Rapp in 4 weeks, shows what such a tool looks like.

The problem: Excel, post-it notes and no current version

In many dealerships, workforce planning lives in an Excel sheet that circulates by e-mail. Holiday requests arrive on paper or by word of mouth, sick notes sit on a slip at reception, and who works on Saturday is settled with the workshop manager in the corridor. Employees lose hours every week searching, shuffling paper and chasing answers: appointments in Excel, callbacks on post-its, and knowledge lives in people's heads instead of systems.

The consequences are always the same:

• Nobody knows which version of the plan is current.
• Conflicts between holiday, the 4-day week and Saturday duty only surface when the staff are missing.
• Remaining leave, quotas and approvals are tracked by hand.
• Management has no figures on utilisation and absences, and makes staffing decisions by gut feeling.

With 4-day weeks, flex models, Saturday work and legal requirements, planning has become too complex for a spreadsheet. This is exactly where a digital planning tool comes in.

What a dealership workforce planning tool needs to do

A planning tool for sales, service and parts needs more than a calendar. These functions have proven necessary in practice:

Make capacity visible

• Monthly view across departments and roles with attendance, holiday, sickness and remote work
• Minimum staffing per department and day stored as a rule
• Utilisation per employee and department, so that overload (above 100%) and underload (below 50%) are visible at a glance

Automatic alerts

• Early warning of critical staffing situations before the day starts
• Conflict checking when 4-day-week rotation, Saturday duty and holiday collide
• Absence statistics that reveal patterns invisible in a spreadsheet

Roles and approvals

• Absences with quotas and an approval workflow: submitted, under review, approved or rejected
• Roles for admin, employees and department-specific views
• Confidential areas for employee reviews, annual appraisals and goals

Export and compliance

• Export and print for the notice board and payroll
• Legally sound, fair planning with documented decisions
• Data-driven reports for HR decisions

The case: Autohaus Plan for Autohaus Rapp

Autohaus Rapp in Schemmerhofen is an authorised Renault and Dacia dealer with more than 50 employees. For workforce planning across sales, service and parts, PK Solutions built Autohaus Plan, covering 4-day weeks, flex models, Saturday work and legal requirements.

The key facts:

• 4 weeks of development to deployment
• 360° personnel calendar across all departments with absences and work models
• Automatic alert systems for critical staffing situations
• 4-day week and flex models with smart rotation
• Data-driven reports for HR decisions
• Employee development with conversation notes and goals
• Branding integration in the Renault design system

The speed was made possible by AI-supported low-code development on Base44, combined with automotive expertise that knows how a Saturday in a dealership really runs.

Taking it further: the Rapp Intern employee portal

Workforce planning is one part of a bigger picture. For Autohaus Rapp, PK Solutions built Rapp Intern, an employee portal that bundles communication, processes, knowledge and personnel administration in one system and replaces numerous single tools, Excel lists and paper forms. It is structured in three work areas:

1. Personal area: Dashboard with appointments and open forms, events with RSVP, notice board, library, chat, surveys, staff directory and digital requests with workflow, holiday, sick note, expenses with receipt upload, onboarding checklist.
2. Work area: Appointment management for sales and service appointments with status and priority, central callback management with assignment and push notifications so no customer is forgotten, to-do lists with due dates and priority, predefined workflows for sales and service, a knowledge base with AI chat, plus resource and training management.
3. Admin area: Capacity planning with utilisation per employee and department, personnel management for sick notes, holiday requests with calendar and remaining leave, expense approval, quality assurance and content management.

The benefit is measurable: PK Solutions states 2–3 hours saved per employee per week for the portal, at 50 employees, 100 to 150 hours per week, with no forgotten callbacks and no double bookings. The break-even was typically 2–4 months. Roles for admin and user, department-specific views, GDPR compliance, audit logs, responsive design and dark mode are part of the standard setup. Read more about the customer in the Autohaus Rapp case study.

What to look for when introducing a tool

• All departments in one calendar: Sales, service and parts interlock. Separate plans create the same gaps as Excel.
• Rules instead of memory: Minimum staffing, rotation and quotas belong in the system, not in the workshop manager's head.
• Warning before the problem: A tool that only shows understaffing after the fact is a report, not a planning tool.
• Approvals with status: Every request needs a visible path from submitted to approved, including notification of the supervisor.
• Roles and confidentiality: Conversation notes and goals are sensitive. Access must be role-based and logged.
• Mobile-ready: Service staff do not sit at a desk. The plan must work on a smartphone.
• Ready to connect: Workforce planning should later fit into an employee portal with appointments, callbacks and to-dos.
• Fast to deploy: Four weeks is a realistic frame when requirements are clear and the platform fits.

Conclusion

Workforce planning in a dealership is too important for a spreadsheet nobody can keep track of. A digital planning tool makes capacity visible, warns of bottlenecks and takes the paper trail out of managing holiday and sickness. The Autohaus Rapp case shows that such a tool can be in use within 4 weeks, and that the step to a full employee portal pays off in months, not years. If you would like to know what this could look like for your dealership, book a free first call.