The administrative aide's work is described in Chapter 11 by David A. Ammons and Dale J. Roenigk. 2022. Tools for Decision Making: A Practical Guide for Local Government has the vehicle maintenance parts room at the city of Weber on the brink of significant changes. How do you think work hours should be reassigned by tasks and staff members in the future? Do a proposed work-distribution chart. What targets might be set? How would you compare the current versus the target? Write on both the current work assignments and the performance of the proposal. Are there positions or tasks you might want to identify for future efforts at streamlining the work?

To use this template, simply remove the data in the yellow boxes below and load your new data. Do not enter data in the white cells; these cells are calculated by Excel from the entries in the yellow cells. The template is set up to handle ten positions and twenty tasks but more could be easily added. The chart below shows how much each task represents of the total. Tasks can be deleted by simply deleting rows. Tasks can be added most easily if rows are inserted in the middle of the list. Similarly the positions can be reduced by deleting columns. More positions can be added most easily if columns are inserted in the midd e of the list. r - Total Staff Percent of Tota . Position | Position | Position | Position | Position | Position | Position | Position - Process/Task Description Position 1 Position 10 Hours Hours 2 % 4 5 & 7 B 9 1.3% 5 Task 03 1.3% ] ] Task 04 2.5% 5 5 Task 06 3.8% | s | | 5 [ | - 1 s [ | Task 07 5.0% 5 5 5 5 Task 09 5 5 3 e 5 - ... : Task 11 5 20 15 5 5 Task 12 5 5 TESk 13 5 . 5 Task 14 5 5 5 5 Task 15 5 5 5 5 Tk 1 - . 5 Task 17 5 5 5 Task 18 5 5 5 Task 20 ! s [ 1t r [ [ 1 s | Total staff hours per week Percent of Total Hours 0%% 496 696 89% 10% 12% 14% Task 01 1.3% Task 02 11.3% Task 03 1.3% Task 04 2.5% Task 05 5.0%% Task 06 3.8% Task 07 5.0% Task 08 5.0%% Task 09 3.86 Task 10 3.896 Task 11 12.5% Task 12 2.59% Task 13 5.0% Task 14 5.0% Task 15 5.0% Task 16 5.0% Task 17 3.8% Task 18 3.8% Task 19 12.5% Task 20 2.5%