Power Apps Consulting Staff Scheduling Tracker
Budget: €30 – €250 EUR
I'm in need of a proficient Microsoft power apps developer to create a simple yet functional staff scheduling tracker. The scheduling is related to a consulting business. This involves:
- Implement data entry feature to manually enter: employee list (name, role, hourly cost, start date for the specific cost [i.e. the cost of the single employee could change over time]), job list (job name, client, billable value, target margin, start date, job owner [i.e. owner is form employee list], list of employee assigned to the job), list of legal Holiday, company holiday, employee specific holiday
- Implementing for each job a view to manually fill, for each employee assigned to that job (i.e. each employee could be assigned to 1 or more jobs), hours to be charged to the specific job. The details should be entered and tracked on a two weeks basis (i.e. first 15 days of the month, second half of month stating form 16th to the end). The scheduling should be automatically filled with list of holidays
- the job view should track wip (work in progress) cost based on charged hours multiplied with employees cost, wip production that corresponds to cost plus the margin
- Implementing an overview dashboard to show for a selected month and by first half & second half (i.e. by default the current one) for each employee overall chargeability, overall available time, chargeability (calculated as total hours poste on a chargeable job dived by working hours available in the period – excluding holiday)
[OPTIONAL]
User access management:
-Admin role: full access
- job owner: full access to a set of job views (could perform data entry)
- job viewer: access to a set of job view in read mode
- advanced viewer: access to overview dashboard
- I prefer a design that is simple and minimalistic, focusing more on functionality and easy user experience
- Required skills: Proficiency in Microsoft power apps
- I will provide a set of template data
- Implement data entry feature to manually enter: employee list (name, role, hourly cost, start date for the specific cost [i.e. the cost of the single employee could change over time]), job list (job name, client, billable value, target margin, start date, job owner [i.e. owner is form employee list], list of employee assigned to the job), list of legal Holiday, company holiday, employee specific holiday
- Implementing for each job a view to manually fill, for each employee assigned to that job (i.e. each employee could be assigned to 1 or more jobs), hours to be charged to the specific job. The details should be entered and tracked on a two weeks basis (i.e. first 15 days of the month, second half of month stating form 16th to the end). The scheduling should be automatically filled with list of holidays
- the job view should track wip (work in progress) cost based on charged hours multiplied with employees cost, wip production that corresponds to cost plus the margin
- Implementing an overview dashboard to show for a selected month and by first half & second half (i.e. by default the current one) for each employee overall chargeability, overall available time, chargeability (calculated as total hours poste on a chargeable job dived by working hours available in the period – excluding holiday)
[OPTIONAL]
User access management:
-Admin role: full access
- job owner: full access to a set of job views (could perform data entry)
- job viewer: access to a set of job view in read mode
- advanced viewer: access to overview dashboard
- I prefer a design that is simple and minimalistic, focusing more on functionality and easy user experience
- Required skills: Proficiency in Microsoft power apps
- I will provide a set of template data