Portfolio Project — Business Analyst Application

D365 CRM MigrationCost-Benefit Analysis

Full cost-benefit framework for migrating a mid-market Croatian manufacturer from legacy CRM to Dynamics 365 Sales + Customer Service

Business Analyst Portfolio Project | By David Mustač | March 2026

0
CRM Users
Across 3 offices
0
Year 1 Investment
Full implementation
0
Annual Value
Quantified savings
0%
3-Year ROI
16-month payback
Scroll to explore
01

Scenario Definition

The hypothetical client: "Adria Manufacturing d.o.o." — a typical D365 consulting engagement

Client Profile

IndustryMid-market manufacturing (industrial components)
LocationZagreb, Croatia + Ljubljana & Belgrade offices
Employees180 total, 45 CRM users
Revenue€12M annually
Current CRMOn-premise legacy PHP/MySQL (8 years old)
Decision DriversCEO digitalization mandate, developer leaving, compliance pressure

Current Pain Points

No mobile access — sales reps use spreadsheets on the road
Manual reporting — 8-10 hrs/week building Excel reports
Siloed data — no integration with ERP or email
No GDPR audit trail — increasing regulatory risk
Developer maintaining system is leaving in 6 months
User satisfaction: 2.1/5 on internal survey

User Breakdown — 45 Licensed Users

RoleCountLicense
Sales Representatives15Sales Professional
Sales Managers5Sales Enterprise
CS Agents10CS Enterprise
CS Manager2CS Enterprise
Marketing3Sales Professional
Executives5Sales Enterprise
IT Admin2Power Platform
Field Service3Sales Professional
Total45
02

Current State Assessment

Legacy system audit reveals critical gaps across every dimension

ArchitectureCritical

PHP/MySQL on-premise, custom-built 2018

Single point of failure, no vendor support

Data VolumeWarning

~120K contacts, 45K accounts, 15K opportunities

Significant cleanup needed before migration

IntegrationsCritical

Manual CSV exports to Pantheon ERP

4-6 hrs/week wasted on manual transfer

Mobile AccessCritical

None

Sales reps use spreadsheets on the road

ReportingCritical

Manual Excel exports, 1 person weekly

8-10 hrs/week on manual reporting

UptimeWarning

~95% (outages 2-3x/quarter)

Lost productivity, customer delays

MaintenanceCritical

€18,000/year (part-time dev + hosting)

Cost rising — developer leaving

SecurityCritical

No GDPR audit trail, no RBAC

Regulatory risk increasing

Cost of Doing Nothing — Annual

CategoryAnnual Cost
Current maintenance€18,000
Manual data transfer€7,800
Manual reporting€15,600
Lost sales (no mobile)€24,000
Server downtime€4,800
GDPR exposure€10,000–€50,000
Total Status Quo Cost€80,200–€125,200/yr
03

D365 Licensing Cost Model

Microsoft Dynamics 365 2026 pricing — first app base license, additional apps at attach rates

User Count Simulator

45 users
35 users45 users (base)65 users
Adjusted Annual Platform Cost
40,920/yr
User GroupCountLicense Type€/monthAnnual Total
Sales Reps15Sales Professional6010,800
Sales Managers5Sales Enterprise885,280
CS Agents10CS Enterprise8810,560
CS Manager2CS Enterprise882,112
Marketing3Sales Professional602,160
Executives5Sales Enterprise885,280
IT Admin2Power Platform37888
Field Service3Sales Professional602,160
Subtotal Licenses4539,240/yr

Additional Platform Costs

Power BI Pro (10 users)€1,080
Azure storage (estimated)€600
Power AutomateIncluded
Microsoft 365 (existing)Included
Total Platform Cost€40,920/yr

3-Year Projection (~5% annual increase)

Year 1Base deployment
€40,920
Year 2+5% increase
€42,970
Year 3+5% + potential adds
€45,120
3-Year License Total€129,010
04

Implementation Cost Breakdown

840 hours across 8 phases over ~20 weeks — €101,600 total consulting investment

Cost by Phase (€)

Hours Distribution (840 total)

PhaseDurationHoursCost (€)% of Total
Discovery
3 weeks12012,000
12%
Design
2 weeks8010,400
10%
Config & Custom
6 weeks28036,400
36%
Data Migration
3 weeks12014,400
14%
Integration
2 weeks8010,400
10%
Testing & UAT
2 weeks606,600
7%
Training & Go-Live
2 weeks606,600
7%
Post-Go-Live
4 weeks404,800
5%
Total~20 weeks840€101,600100%

Consulting Rates (Croatian/CEE Market)

Senior D365 Consultant
Architecture, complex config
150/hr
Mid-level D365 Consultant
Configuration, customization
120/hr
Business Analyst
Requirements, documentation
100/hr
Data Migration Specialist
ETL, data mapping
120/hr
Trainer
End-user training, materials
100/hr
Project Manager
Coordination, risk management
130/hr

Western European partners charge €175-250/hr — CEE rates offer a competitive advantage.

05

Business Value & ROI Projection

€134,400/year in quantified value — 38.3% ROI over 3 years with 16-month payback

3-Year Investment
€291,510
TCO
3-Year Value
€403,200
Quantified savings
Net Benefit
€111,690
Over 3 years
Payback Period
16 months
Break-even Month 16

Quantified Business Value (Annual)

Value DriverAnnual €
Eliminated manual reporting15,600
Eliminated manual data transfer7,800
Reduced legacy maintenance18,000
Sales productivity (mobile CRM)36,000
Faster sales cycle24,000
Reduced customer churn18,000
Compliance risk reduction15,000
Total Annual Value€134,400

Break-Even Analysis (36 months)

Break-even at Month 16 — net positive thereafter

D365 vs. Legacy — Annual Cost

Year 1 is heavy; Years 2-3 D365 costs drop below legacy

ROI Sensitivity Analysis

Conservative (50%)
-6.8%
67,200/yr
Payback: 26 months
Base Case
+38.3%
134,400/yr
Payback: 16 months
Optimistic (125%)
+73%
168,000/yr
Payback: 13 months

Even at 50% of estimated value, payback is 26 months — still within typical approval horizon.

06

Risk Assessment & Mitigation

8 identified risks with probability-impact scoring and detailed mitigation plans

#RiskProbabilityImpactLevel
R1Pantheon integration fails/delaysMEDIUMHIGH
R2Data quality worse than estimatedHIGHMEDIUM
R3User adoption below 60% at Month 3MEDIUMHIGH
R4Scope creep during customizationHIGHMEDIUM
R5Key stakeholder unavailable for UATMEDIUMMEDIUM
R6Microsoft licensing price increaseLOWLOW
R7Go-live during peak business periodMEDIUMHIGH
R8Croatian localization issuesMEDIUMMEDIUM
R1

Pantheon ERP Integration

Pre-project: 4-hour technical feasibility assessment with Pantheon partner
Fallback: If real-time sync fails → scheduled daily batch sync as Phase 1
Budget impact: +€5,000 if fallback needed
R3

User Adoption

Week 1: CEO company-wide email mandating D365 as only CRM
Week 12: Champions trained and placed in each department
Week 17: Legacy system set to read-only
Week 20: Legacy fully decommissioned — no going back
R7

Go-Live Timing

Recommended: Early Q2 (April) — past Q1 close, before summer
Avoid: December (year-end) and September (back-to-business rush)
Buffer: 2-week hypercare through April 15
07

Migration Timeline

20-week implementation with parallel tracks and key milestone gates

W1
W2
W3
W4
W5
W6
W7
W8
W9
W10
W11
W12
W13
W14
W15
W16
W17
W18
W19
W20
W21
W22
Discovery & Requirements
Solution Design
Configuration & Customization
Data Migration
Integration Development
Testing & UAT
Training & Go-Live
Hypercare Support
Milestones

Key Milestones

W3
Requirements sign-off
W5
Design approved
W11
Config complete
W14
Data migration validated
W16
UAT sign-off
W18
GO-LIVE
W22
Managed services transition

Critical Path

DiscoveryDesignConfigurationUATGo-Live

Data migration prep runs alongside configuration (W6-W14)

Integration development overlaps with configuration (W6-W11)

Training preparation starts W12, delivery W17

08

Decision Matrix

Weighted multi-criteria comparison — D365 scores 8.65/10, leading across all dimensions

Recommended
8.65
D365 Migration
7
Salesforce
6.35
HubSpot CRM
2.85
Stay on Legacy

Multi-Criteria Comparison

CriteriaWtD365LegacySFHS
Functionality25%9/104/109/107/10
TCO (inverted)20%7/107.5/106/109/10
MS Integration15%10/102/105/106/10
Scalability10%9/102/109/107/10
Local Support10%10/101/104/103/10
User Adoption10%7/103/106/108/10
Compliance10%9/103/108/107/10

Why D365 Wins for This Client

Microsoft ecosystem lock-in is an advantage — client already uses M365, Outlook, Teams
Local consulting partner in Zagreb — Croatian-speaking, same timezone, on-site support
Pantheon ERP integration requires Croatian consulting knowledge a local partner already has
Power Platform included — Power Automate, Power BI, Power Apps come with D365 licenses

When D365 Might Not Win

!If budget is the only factor → HubSpot free tier is significantly cheaper
!If client has strong internal Salesforce expertise → path of least resistance
!If client plans rapid growth beyond 200 users → Salesforce ecosystem is larger
09

Executive Summary

One-page business case for client presentation

Adria Manufacturing d.o.o.

D365 Migration Business Case — Prepared by Business Analyst

The Problem

Your current CRM is 8 years old, custom-built, has no mobile access, no integration with Pantheon, and the developer maintaining it is leaving. You're spending €80-125K/year keeping a system alive that your sales team rates 2.1/5. Every week, your people waste 15+ hours on manual reporting and data transfer.

The Solution

Migrate to Microsoft Dynamics 365 Sales + Customer Service. Full implementation in 20 weeks. 45 users with role-based licensing. Native integration with your existing Microsoft 365 tools + custom integration with Pantheon ERP.

The Investment

Year 1 (license + implementation)€179,420
Ongoing annual (license + support)€55-57K/yr
3-Year Total€291,510

The Return

Annual quantified value€134,400/yr
Payback period16 months
3-Year ROI38.3%

The Alternative: Doing Nothing

Costs €270,600 over 3 years with zero value creation and increasing risk. The system is deteriorating, the developer is leaving, and GDPR exposure grows every month.

Recommendation

Proceed with D365 migration. Start Discovery in April 2026. Go live by August 2026. Engage a certified Microsoft Partner as implementation consultant.