2110 Attachment 6 Effort.xlsx

This is a Vendor Staffing Level of Effort worksheet for Kenosha County, Wisconsin's Microsoft AX to Microsoft Dynamics 365 upgrade project. The document outlines the proposed resource allocation and billing structure for the implementation engagement. The project is structured across five phases, with Phase 1 representing the active implementation phase comprising 220 total hours. Phase 1 staffing includes one Project Manager role allocated 10 hours for Project Management, 10 hours for Knowledge Transfer, 20 hours for Design, 30 hours for Configuration, 50 hours for Testing, and 100 hours for GoLive/Support activities. Phases 2 through 5 currently show zero hours allocated, indicating either incomplete planning or a single-phase implementation approach. The worksheet includes provisions for additional resource types and roles to be added as needed, with columns designated for resource type, resource role/name, hourly rate/unit cost, and implementation task assignments categorized by function (Design, Build, Test, Train, Cutover).

The pricing section of the document contains fields for detailed professional service payment information, including service type categorization (Project Management, Implementation, Data Conversion, Reporting, Technical, etc.), resource classification (on-site or off-site), and total cost calculations. The current worksheet shows only the Project Manager resource fully detailed for Phase 1, with multiple empty rows available for additional resource entries. The effort allocation percentages for Phase 1 demonstrate a balanced approach: 4.5% Project Management, 4.5% Knowledge Transfer, 9.1% Design, 13.6% Configuration, 22.7% Testing, and 45.5% GoLive/Support, reflecting the typical distribution of effort in enterprise resource planning implementations. The document contains formula errors for Phases 2-5, suggesting the template requires completion of staffing plans for subsequent project phases.