2107 Attachment 7 Effort.xlsx

This is a vendor staffing level of effort document for Kenosha County, Wisconsin's cashiering solution implementation project. The document outlines a phased approach to project delivery with detailed resource allocation across multiple workstreams. Phase 1, representing the initial implementation phase, allocates 220 total hours distributed among project management (10 hours), knowledge transfer (10 hours), design (20 hours), configuration (30 hours), testing (50 hours), and go-live/support (100 hours). The staffing plan identifies a Project Manager as the primary resource role for Phase 1, with the document structure providing capacity for additional resource types and roles to be defined. Phases 2 through 5 currently show zero hours allocated, indicating they are either not yet planned or remain to be populated with resource requirements. The proposed cashiering solution is expected to integrate with Microsoft Dynamics 365 SaaS ERP and include components for cashier stations, an online payment portal, receipt printers, and payment gateway services.

The document contains a framework for detailed service costing and level of effort tracking, with sections designated for professional service descriptions, implementation tasks, resource classifications (on-site or off-site), hourly rates, and total cost calculations. However, the pricing detail section remains incomplete, with placeholder entries for service type, resource role, delivery method, implementation task classification, and associated costs. The ERROR:#DIV/0! entries appearing in Phases 2-5 of the effort summary indicate incomplete calculations or missing data that require resolution prior to proposal finalization. This template structure suggests the proposal is still in development and requires completion of resource hours, rate information, and cost details for all project phases.