Answer Happy

Problem Topic #4: Scheduling Tool Scenario: you work as an assistant in a company supporting a manager who schedules shift work for employees who work part-time or casual. You notice that your manager spends a lot of time cross- referencing the availability of staff and trying to make sure all of the work shifts are covered while still offering all of the employees enough hours to make them happy. Your manager is doing this using very basic Excel functions and not using the software to its full potential. You notice that they can make some efficiencies to the process. You offer to help them by making a scheduling tool in Microsoft Excel. Page - 4
Task: build an Excel workbook template that can automatically populate shifts using employee availability data. Make sure you use advanced Excel functions to analyze and organize the data. You will have to make assumptions by making up the daily required shifts, the employee names, their availability, and their desired amount of working hours per week. Make up the availability of employees week by week for a month. The weekly availability for employees must vary since part-time and casual employees usually have complex availability. Create some kind of tool in Excel that will automatically input the name of the employee into a shift based on their availability and how many hours they want to work per week. Remember that every employee usually has their own expectations of how much they want to work per week, and often there aren't enough available shifts for employees to always get what they want. If there aren't enough available shifts per week for each employee to work the hours they want, try to set up some kind of rotation function in the table. Submission: submit two Excel workbooks: one template for the instructor to test and one with populated data to prove that it works.