Download.com
  • Navigation
  • open search
Close

PLATFORMS

POPULAR LINKS

CATEGORIES

HELP & SETTINGS

Editors' Review

by   / February 20, 2012

MRP_Excel.zip from Production-Scheduling.com is a free Manufacturing Resource Planning tool in an Excel workbook. It uses no macros or VBA code and it's not locked: anyone who knows Excel can customize it to suit his or her needs.

Excel-based MRP systems have several advantages, such as the ability to use schedules and other data already entered in Excel; greater familiarity and less complexity than a full-scale MRP system; and, best of all, lower cost. MRP offers some significant features, including a Purchase Action Report that identifies schedule-critical purchase orders, a single-level Bill of Material Structure, and a built-in Inventory Rationing tool that analyzes existing inventories and product lines and rations materials to make the inventory cover as much production as possible.

MRP_Excel.zip comes with sample data for a new line of shampoo. Clicking the extracted download opened the workbook inside Excel with the Introduction sheet displayed. Aside from a Table of Contents, the first page of note is the Table of Links, which depicts those worksheets that are linked to other worksheets as well as chained PivotTables. This table saves a lot of time, especially for inexperienced users, since there are about 20 links.

The next sheet, The Business, displays data for the fictional small company that manufactures shampoo, including Process, Bill of Materials, and Capacities. Reviewing MRP_Excel.zip's sample materials could serve as a thumbnail education in manufacturing production planning.

The rest of the workbook's sheets also feature data for the fictitious product line, grouped by categories. For example, the Data Files section features the Item Master, Supplier Master, Bill of Materials (BOM), and Purchase Orders sheets. The Finite Schedule section includes a sheet entitled Make-to-Inventory Logic Explained. MRP Calculations let us schedule production runs, allocate inventory, and make other calculations. The final section is the Inventory Rationing tool.

While MRP_Excel.zip is a serious, enterprise-ready tool that can serve capably in companies of all sizes, it's easy enough to use to be appropriate for individuals, family businesses, and other small manufacturing businesses. The Inventory Rationing tool seems especially useful for managing for lean supply chains as well as lean times.

What do you need to know about free software?

User Reviews
  • All Versions

    4.6

    out of 15 votes

    • 5 star 13
    • 4 star 0
    • 3 star 1
    • 2 star 0
    • 1 star 1
 
show reviews

Full Specifications

General

Publisher Production-Scheduling
Publisher web site http://Production-Scheduling.com
Release Date April 14, 2001
Date Added April 14, 2001
Version 2.0

Category

Category Business Software
Subcategory Inventory Software

Operating Systems

Operating Systems Windows 95/98/NT/2000
Additional Requirements Windows 95/98/NT/2000, Excel 97 or 2000

Download Information

File Size 99.01KB
File Name MRP_Excel_v2.zip

Popularity

Total Downloads 158,234
Downloads Last Week 56

Pricing

License Model Free
Limitations Not available
Price Free
Report a problem
Latest Stories
Best Amazon Prime Day deals so far

Best Amazon Prime Day deals so far

by Clifford Colby

From headphones and earbud to mobile phones and smart home devices, here are the best Prime Day tech...

Read more
How to check out Microsoft's Chrome-like Edge browser for Windows 10

How to check out Microsoft's Chrome-like Edge browser for Windows 10

by Clifford Colby

If you want to test an early version of Microsoft's reworked Edge browser, here's your chance.

Read more
How to reinstall updates that Windows 10 automatically uninstalled

How to reinstall updates that Windows 10 automatically uninstalled

by Clifford Colby

Microsoft this week will try to resolve a startup failure issue by uninstalling recently installed u...

Read more