Choosing the right city: where should a reusable EV battery factory be built in Gujarat?

Khushi, a Data Analytics student at Bright Computer Education, built four interactive Power BI dashboards to compare ten Gujarat cities on factory cost, operating cost, market reach and long-term profit, and to recommend one location.
Power BI · Data Analytics Case Study
Khushi Chaudhry
Microsoft Power BI project
The Business Problem
A start-up wants to set up a reusable EV battery factory Case Study in Gujarat. Ten cities are on the shortlist: Ahmedabad, Sanand, Vadodara, Vapi, Jamnagar, Surat, Bharuch, Rajkot, Bhavnagar and Gandhidham. Some are cheap to build in but far from customers. Others sit close to the market but cost more. So which city gives the best balance of cost, sales and profit?
Project Snapshot
Student Khushi Chaudhry
Course Data Analytics
Batch 2026
Tool Microsoft Power BI
Project Gujarat Reusable EV Battery
What Khushi Built
1. Overview. Headline KPIs, factory cost split by utilities, machinery, logistics, land, labour and compliance, plus sales forecast and profit for the 1st, 3rd, 5th, 7th and 10th year.
2. Capex. First-year investment and operating cost (OPEX) by city, with raw material, maintenance and packaging costs.

3. Market Access. The sales forecast of each city set against its nearby market-potential radius. The total forecast across ten cities is ₹830 Cr.
4. Conclusion. The recommended city, the three reasons behind it, and a short “Why not others?” explanation.
Key Findings
Sanand has the highest sales forecast. At ₹110 Cr, it leads Ahmedabad (₹100 Cr) and Surat (₹95 Cr). Gandhidham is lowest at ₹60 Cr.
Sanand is closest to its market. Its market-potential radius is just 150 km, the shortest of all ten cities. Gandhidham has the longest at 450 km.
The cheapest city is not the best city. Gandhidham sits at the low end for first-year cost and OPEX, but its low market potential holds it back. Sanand has higher OPEX, yet its sales and profit outweigh that.
Ahmedabad and Vadodara cost more to set up. Ahmedabad has the highest first-year cost, at roughly 175 on the chart, against roughly 132 for Gandhidham.
The final call is Sanand. The dashboard recommends it for three reasons: the highest sales forecast, the highest profit after 10 years, and the nearest market potential.