Tim Lovelock

Down to 2 Excel worksheet tabs, from well over a dozen. Goal is to get to a single sheet, but the volume of data, screen real estate, and the fact that it is reviewed in a conference room rather than printed all factor it. I’ll get there, but I like the progress so far.

I have a tab with a dynamic chart to review planned orders by assy (over 50 assemblies). Another tab to review upcoming total production volumes by type/workcenter. Need to add demand management and WIP data, then scale it all down to a single sheet.

Related posts

• There’s a reason fundamental skills are called “Fundamental” (1)
• Taking Responsibility for Materials Management on a Mature Program or Product (2)
• Simple MRP Model Using OFFSET Function in Excel (0)
• I can see a ton of uses in my day job for this: #Excel conditional drop-down lists (0)
• Excel functions I use daily (0)