Join or Sign In

Sign in to add and modify your software

Sign in with Facebook Sign in with email

By joining Download.com, you agree to our Terms of Use and acknowledge the data practices in our Privacy Agreement.

MRP_Excel.zip

By Production-Scheduling Free Editors' Rating

Editors' Review

Download.com Staff Feb 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.

Full Specifications

What's new in version 2.0

General

Release November 8, 2008
Date Added April 14, 2001
Version 2.0

Operating Systems

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

Popularity

Total Downloads 159,188
Downloads Last Week 11
Report Software

Related Software

ABC Inventory Software

Free
ABC Inventory Software

InFlow Inventory Free Edition

Free
InFlow Inventory Free Edition

Inventoria Stock Manager

Free to try
Inventoria Stock Manager

Barcode Label Generator

Free to try
Barcode Label Generator

Best VPN Services for 2020

Best for privacy

3 months free with 1-year plan

Best for customer support

$39.99 for the first 12 months

Best for zero logs

$4.87.99/months for a 1-year plan

Best money-back guarantee

$2.99/months for a 3-year plan

User Reviews

4.6/5
15 User Votes
5 Star
4 Star
3 Star
2 Star
1 Star

Developer's Description

From the developer: "A fully functional Manufacturing Resource Planning (MRP) system in Excel that has no macros or VBA code, nothing is hidden, the system may be modified by an Excel literate person, and adapted for use by a range of manufacturing companies. The system is loaded with sample data from a fictional shampoo manufacturer who makes 3 variants each in 3 pack sizes on a single bottling line.

"Working from a sales forecast and finished inventory, the system schedules the bottling line so that the desired inventory cover is maintained. It also explodes the production requirements through a bill of materials (BOM), and calculates the raw materials to be purchased, taking into account the materials that are in inventory and on order from suppliers. There is also a module which determines the best mix of products to make with the raw material inventory on hand, taking into account that some of the materials are common to several products, while others are unique."