Practical Excel tips and personal uses

In this episode of Financial Modeler’s Corner, host Paul Barnhurst sits down with Amber Johnson to discuss forecasting, financial modeling, and how operational decisions impact financial outcomes. They explore the connection between logistics forecasting and financial forecasting, the importance of tracking forecast accuracy and bias, and how small operational issues can create large financial impacts. Amber also shares lessons from her experience working with data, forecasting demand, and helping businesses improve their systems and decision-making.

Amber Johnson is a fractional industrial engineer and the founder of Peachy Profitability, where she helps teams work smarter through process improvement, data storytelling, and automation. She began her career as a “beer psychic,” forecasting demand at Anheuser-Busch, and has since built logistics networks, optimized warehouse flows, and guided businesses through transformational change. Amber is also the creator of Office Hours with Amber, a weekly livestream that encourages continuous improvement with curiosity and confidence.

Expect to Learn

1. How logistics forecasting connects to financial forecasting
2. Why forecast accuracy and bias matter in decision-making
3. How operational drivers influence financial results
4. Ways finance, sales, and logistics teams can align better
5. How Excel and data analysis support forecasting and planning

Here are a few quotes from the episode:

1. “Sometimes the smallest operational issue becomes the biggest financial problem later.” – Amber Johnson
2. “Good forecasting isn’t about being perfect, it’s about learning and adjusting.” – Amber Johnson

Amber Johnson shared practical insights on forecasting, operational drivers, and financial modeling. She highlighted how understanding logistics and operational data can improve financial decisions and help businesses plan more effectively.

Follow Amber:

LinkedIn: https://www.linkedin.com/in/ambernjohnsonwmu/

Website: https://peachyprofitability.com/

Follow Financial Modeler's Corner:

LinkedIn Page - https://www.linkedin.com/company/financial-modeler-s-corner/

Newsletter - Subscribe on LinkedIn - https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984

Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’.

Visit https://bit.ly/497oAqW and use the code “Podcast” to save 15% when you register.

In today’s episode:

[02:23] – Amber’s Background

[08:21] – Founding Peachy Profitability

[10:38] – Learning Excel and Forecasting

[15:37] – Logistics vs Financial Forecasting

[18:59] – Forecast Accuracy and Bias

[23:59] – Finance vs Logistics Perspectives

[31:41] – Aligning Teams Around Goals

[36:07] – Favourite Excel Shortcuts

[37:46] – Rapid Fire: modeling Opinions

[44:39] – Where to Find Amber