Project DepEx: Depreciation Exploration and Visualization

Authors

Charlie Brockmeier, University of Nebraska - LincolnFollow
Bethany Barnwell, University of Nebraska - LincolnFollow
Rishi Krishna, University of Nebraska - LincolnFollow
Allan Muinov, University of Nebraska - LincolnFollow
Ayan Hussain, University of Nebraska - LincolnFollow
Landen Fogle, University of Nebraska - LincolnFollow

Date of this Version

5-2025

Document Type

Thesis

Citation

Brockmeier, C, Barnwell, B., Krishna, R., Muinov, A., Hussain, A., & Fogle, L. 2025. Project DepEx: Depreciation Exploration and Visualization. Undergraduate Honors Thesis. University of Nebraska-Lincoln.

Comments

Copyright Charlie Brockmeier, Bethany Barnwell, Rishi Krishna, Allan Muinov, Ayan Hussain, and Landen Fogle 2025

Abstract

Project DepEx delivered a scalable, automated solution for Conagra Brands to analyze and visualize asset depreciation across its extensive manufacturing network. By leveraging Python for data transformation and Power BI for interactive visualization, the team streamlined a previously manual, fragmented process into a unified, dynamic dashboard. This tool consolidates over 10 million data points from more than 100,000 assets and provides clear, actionable insights by fiscal period, facility, brand, and asset type. The solution enables Conagra to reduce analysis time by over 97%, enhance financial planning, and support more informed capital investment decisions that drive long-term value creation.