Question: T.R. Accounting Service is developing a workforce schedule for three weeks from now and has forecasted demand and translated it into the following minimum personnel


T.R. Accounting Service is developing a workforce schedule for three weeks from now and has forecasted demand and translated it into the following minimum personnel requirements for the week: Day Mon Tue Wed Thu Fri Sat Sun Minimum personnel 8 6 6 6 9 5 3 T.R., The staff requirements are for full time accountants who do accounting work such as end-of- month financial statements, tax record organization, and federal, state and local tax payments. the owner of the accounting service, wants to schedule employees so that each employee has two consecutive days off and all demand requirements are met. Step 1 - locate the set of at least two consecutive days with the smallest requirements. We are doing this because the owner wants to give people two consecutive days off. You should see that Saturday and Sunday are the two consecutive days that meet this criteria. Day Mon Tue Wed Thu Fri Sat Sun Minimum personnel 8 6 6 6 9 5 3 Step 2 - assign the first accountant to the days not circled. That would be Monday through Friday. We have now scheduled someone for Monday through Friday so the requirements for that day can be reduced by one person. The new requirements are below: Day Mon Tue Wed Thu Fri Sat Sun Minimum personnel 7 5 5 5 8 5 3 Step 3 - repeat step 1 Day Mon Tue Wed Thu Fri Sat Sun Minimum personnel 7 5 5 5 8 5 3 Step 4 - assign the second account to the days to circled (Monday-Friday) and subtract the requirement. This gives us the following requirements. Day Mon Tue Wed Thu Fri Sat Sun Minimum personnel 6 4 4 4 7 5 3 Step 5 you now have a scenario where there are two scenarios with the two lowest demands are equal. In this case it is up to the scheduler to choose the one they want. In this case I chose accountant three to have Tuesday and Wednesday off. The new requirement is listed below. Day Mon Tue Wed Thu Fri Sat Sun Minimum personnel 5 4 4 3 6 4 2 Step 6 - we have another scenario where accountant 4 should work Monday through Friday and have Saturday and Sunday off. After we subtract the requirement, we get the requirements listed below. Day Mon Tue Wed Thu Fri Sat Sun Minimum personnel 4 3 3 2 5 4 2 Continue this process until you have met all requirements, even if you end up scheduling more accountants than necessary on some days. I have already started filling in the Final Accountant Schedule by placing an x in the days that the accountants are working. Fill in the rest of the Final Accountant Schedule and sum up the number of workers each day to get a total number of workers each day. Final Accountant Schedule Accountant Mon Tue Wed Thu Fri Sat Sun 1 X X X X X 2 X X X X 3 X X X X X 4 X X X X X 5 6 7 8 9 10 Total Compare the total number of accountants in the Final Accountant Schedule to the initial requirements. You need to fill in the total days from the above schedule Day Mon Tue Wed Thu Fri Sat Sun Minimum personnel 8 6 6 6 9 5 3 Total There are three questions that should be addressed: 1. Did you meet the minimum personnel requirements each day? 2. Did you give every off two consecutive days? 3. What is the overall efficiency of your schedule? Remember that efficiency is how well you used your resources to meet the desire outcome. Sum up the total number of days worked by all employees. Sum up all the required days. 100% efficiency would be if the required number of days equaled the total number of days by all workers. However the scheduling requirements did not allow you to do that. In this case, complete the efficiency calculation below: Efficiency = *100% = To complete this assignment, please post your Final Accountant Schedule and the Efficiency calculation to D2L. You can use the current Word document format to answer the
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
