MRP_Excel.zip

MRP_Excel.zip


Editors' Rating:
5
Spectacular
Average User Rating:
4.6
out of 15 votes
See all user reviews

Quick Specs

Version:
2.0
File Size:
99.01KB
Date Added:
April 14, 2001
Price:
Free
Operating Systems:
Windows 95/98/NT/2000
Total Downloads:
115,157
Downloads Last Week:
166
Product ranking:
Additional Requirements:
Windows 95/98/NT/2000, Excel 97 or 2000

Editors' review

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.

Publisher's Description

More Products to Consider

All 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
  • Current Version:

    4.6

    out of 15 votes

    • 5 star: 13
    • 4 star: 0
    • 3 star: 1
    • 2 star: 0
    • 1 star: 1
  • My rating:

    0 stars

    Write review

Add Your Review

Quickly sign in with: or Login or create an account to post a review.
You are logged in as . Please submit your review for MRP_Excel.zip
Add Your Review

The posting of advertisements, profanity, or personal attacks is prohibited.
Click here to review our site terms of use.

Update your review

Since you've already submitted a review for this product, this submission will be added as an update to your original review.
Submit

The posting of advertisements, profanity, or personal attacks is prohibited.
Click here to review our site terms of use.

Previous Versions:

Close[x]

Submit a problem report for MRP_Excel.zip

Please describe the problem you have with this software. This information will be sent to our editors for review.

Problem:

The Download.com Installer isn't working as expected

The download link does not work

The software has a newer version

The product contains malicious software

Other

Description:

Please select a feedback type.

Please enter a description.

Submit Problem Report

Close[x]

Problem Report submitted

Thank you for submitting a problem report! The Download team is committed to providing you with accurate software information.

OK