MRP_Excel.zip

MRP_Excel.zip

Download Editors' Rating:
5
Spectacular
Average User Rating:
4.6
out of 15 votes

Quick Specs

  • Version:
    2.0
  • Total Downloads:
    117,640
  • Date Added:
    April 14, 2001
  • File Size:
    99.01KB
  • Downloads Last Week:
    238
  • Operating Systems:
    Windows 95/98/NT/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.

 
read more +

Publisher's Description

+
 
read more +
User Reviews
+

Results 1–10 of 10

3 stars

""Good working Facility""

October 01, 2013  |  By jasonhad411

 |  Version: MRP_Excel.zip 2.0

Pros

Free from virus threats and simple to set up own data on essential belief of production planning and MRP.

Cons

Not yet found

Reply to this review

Was this review helpful? (0) (0)

5 stars

"excellent Excel tool"

February 15, 2002

 |  Version: MRP_Excel.zip 2.0

Summary

This is what I would build if I had time to work on it. Can be adapted to many planning situations. No one should knock this program for the price!

Reply to this review

Was this review helpful? (1) (0)

5 stars

"Great for practical as well as educational use."

February 04, 2002

 |  Version: MRP_Excel.zip 2.0

Summary

This is a great tool to use for a practical application as well as for use as an educational tool. You can set up all your own data and understand very quickly the basic tenets of production planning and MRP. Good Job!

Reply to this review

Was this review helpful? (1) (0)

5 stars

"Easy to use"

October 24, 2001

 |  Version: MRP_Excel.zip 2.0

Reply to this review

Was this review helpful? (0) (1)

5 stars

"sdss"

October 02, 2001

 |  Version: MRP_Excel.zip 2.0

Summary

dsdsds

Reply to this review

Was this review helpful? (0) (1)

5 stars

"mrp"

September 15, 2001

 |  Version: MRP_Excel.zip 2.0

Summary

eh

Reply to this review

Was this review helpful? (0) (1)

5 stars

"medicine management"

August 18, 2001

 |  Version: MRP_Excel.zip 2.0

Reply to this review

Was this review helpful? (0) (2)

5 stars

"Very goood product."

May 30, 2001

 |  Version: MRP_Excel.zip 2.0

Reply to this review

Was this review helpful? (0) (1)

1 stars

"BAD!"

May 26, 2001

 |  Version: MRP_Excel.zip 2.0

Summary

This was bad. The Features suck, and I would not reccommend this download to anyone!!!!!!! Don't wasts your time.

Reply to this review

Was this review helpful? (1) (0)

5 stars

"very innovative use of Excel"

April 24, 2001

 |  Version: MRP_Excel.zip 2.0

Summary

I can't believe this is for free. There is no macro code, so I can see exactly how it works and modify and adapt it to my business. The "how to use inventory of raw materials" feature is brilliant, even the big expensive ERP packages don't have that.

Reply to this review

Was this review helpful? (1) (0)

Results 1–10 of 10

Add Your Review

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.

 
see all 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 2000, Windows NT, Windows 98, Windows 95, Windows
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 117,640
Downloads Last Week 238
Pricing
License Model Free
Limitations Not available
Price Free

Previous Versions:

 
read more +

More Products to Consider

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