In this article we explain how to use Excel and the Fast Development Method to build an advanced and fully automated Inventory Analysis Tool with zero VBA coding
Spreadsheets in Business
How does your Excel planning measure up?
Are you getting the best results or are you suffering from Excel hell?
Here is a simple measurement and a download tool that can give you an instant rating on your planning tools built with spreadsheets.
This is a core method to apply the Fast Excel Development Method in building a planning and scheduling system in Excel.
Convert forecasts, explode demand and generate work orders — this method is something that every planner should know.
Is the purpose of production scheduling to feed MRP and execution?
If you’re satisfied with this answer, then you’re missing something. A small, two-letter word will change the way you look at scheduling.
I would like to introduce the most useful function that Excel has to offer.
This is the most widely used Excel function in the Fast Excel Method. When building planning systems, I find myself typing this in formulas more than any other function.
The function can transform Excel spreadsheets into a fully-blown business software platform. We use it to retrieve data, perform calculations and present them in a report.
Capacity planning compares minutes of production with days of resources. Here is an easy way to convert minutes to days over any working calendar.
This technique also helps to simplify many Excel date calculations for working days and times.
Excel is the most widely used software for production planning. Production planning is one of the most common applications for Excel in manufacturing. Yet, there is one common mistake that people make when production planning in Excel. Avoid doing this one thing and you will save yourself hundreds of hours of unnecessary and repetitive work with production planning data. The mistake:..
I have demand, on-hand inventory and open purchase orders. What orders can I cover with materials and which orders are going to be short? This is a simple question in material planning. We frequently get asked by clients to build spreadsheet tools that can provide an answer. You can download a simple example of such …