The Optimized Library: Tech Fleet Refresh Cycles

Create a multiyear purchasing plan for hardware replacements

Posted on August 31, 2026 in Videos

“The Optimized Library: Solving the Puzzles of Modern Library Management” is a video series from LibTech Insights, hosted by Sam Suber, Electronic Resources Coordinator at Moraine Valley Community College Library. In this series, Sam explores how mathematical optimization empowers libraries to make smarter, value-driven decisions when facing today’s complex operational hurdles. Check out Sam’s previous work.

Whether due to going out of date, breaking down, or shifting patron demand, hardware is expensive and ages quickly, but replacing this equipment can strain already overburdened budgets. In this video, Sam shows us how to use Microsoft Excel Solver to create an optimized, multiyear purchasing plan to replace a variety of library hardware while staying within strict annual budget caps.

Be sure to stay tuned to the end of the video for Sam’s announcement of a big project coming soon to Choice!

For more background on Microsoft Excel Solver, refer to Sam’s post, “Maximizing Impact: Using Excel Solver for Optimal Library Budgeting.”

🚀 Subscribe to Choice’s YouTube channel

Related Posts