Subscribe
perspectives on innovative supply chain management strategies
Contact Us: tuscma@gmail.com

Archive for the Excel Category

Material Requirments Planning (MRP) tutorial

Material Requirments Planning (MRP) tutorial

Material Requirment Planning on the basis of: 01. Customer demand 02. Material capability 03. Make-To-Order 04. Make –To-Stock 05. Dynamic buffer or coverage profile 06. Lead time (different mode) 07. More then one supplier for a part 08. Supplier share of business 09. Stock 10. Minimum Order Quantity 11. Optimum Order Quantity 12. Many other simulation functions   Here you

Read more

18.2 Tips on Rounding numbers using Excel Formulas

18.2 Tips on Rounding numbers using Excel Formulas

We can use a variety of formulas to round numbers in Excel depending on the situation. We have ROUND, ROUNDUP, ROUNDDOWN, MROUND, INT, TRUNC, CEILING, FLOOR, FIXED, EVEN, ODD and few more. To know how to use all these formulas and how to round numbers based on any criteria, just read on.   Rounding Formulas in Excel   Before learning

Read more