I wanted to share a spreadsheet I’ve put together that helps with learning curve calculations and pulling out multiple production lot data showing the learning effects.  It provides useful lot information such as lot average unit cost and lot total costs with the effects of learning curves, escalation, and everything else factored in.  It also has a tab for doing some basic learning curve calculations in multiple lot scenarios by hand and viewing a set of useful metrics.

We want all of this kind of information to be available in TruePlanning for the next release.  We’ll have new multiple production lot features for the next major release of TruePlanning, including more flexibility to account for different schedules by production lot, integrated reporting features by lot, different starting points on the learning curve, and more.

You can download the spreadsheet here.  Feel free to post any questions or any requirements or related features you’d like to see in TruePlanning to the comments section.