MRP_Excel.zip - Free download and software reviews - CNET Download.com

MRP_Excel.zip

CNET 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

  • Apache OpenOffice
    Take an open-source approach to office productivity.
    Download

    Installed

    Smart Install
  • Free PDF to Word
    Convert PDF files to Microsoft Word format.
    Download

    Installed

    Smart Install
  • Microsoft Office Co...
    Open, edit, and save files using the new file formats in 2007 v...
    Download

    Installed

    Smart Install
  • Adobe Reader XI
    View, navigate, and print PDF files.

    This download is served from an external site

    close

    NOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.

    Continue to download

    Sponsored Products

    Visit Site
  • Free JPG to PDF
    Convert JPG, BMP, TIFF, PNG images to PDF files.
    Download

    Installed

    Smart Install
  • ARulesXL
    Add business rules to Excel spreadsheets that combine computati...
    Download

    Installed

    Smart Install
  • All-Business-Letter...
    Get a comprehensive library of 4500 sample business letters and...
    Download

    Installed

    Smart Install
  • XDrill
    Find out where a result in your spreadsheet cell or graph comes...
    Download

    Installed

    Smart Install
  • All-Business-Docume...
    Prepare any business documents from 6000 professionally written...
    Download

    Installed

    Smart Install
  • SimpleShortcuts Exc...
    Format spreadsheets using hotkey keyboard shortcuts.
    Download

    Installed

    Smart Install
  • Microsoft Office Wo...
    Create and share content with the help of a comprehensive set o...

    This download is served from an external site

    close

    NOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.

    Continue to download

    Sponsored Products

    Visit Site
  • Obba
    Build spreadsheet GUIs to Java code with ease.
    Download

    Installed

    Smart Install
  • Tools for Excel Tab...
    Analyze and manage databases and huge tables in your spreadshee...
    Download

    Installed

    Smart Install
  • PDF to Excel
    Transform PDF documents to Excel documents.
    Download

    Installed

    Smart Install
  • PDF ReDirect
    Create, encrypt, and merge PDF files.
    Download

    Installed

    Smart Install
  • StockQuery
    Download and analyze stock data in Microsoft Excel.
    Download

    Installed

    Smart Install
  • WorkTime
    Keep track of how you use your PC.
    Download

    Installed

    Smart Install
  • HotXLS Excel VCL
    Use native Excel read write library and VCL components for Delp...
    Download

    Installed

    Smart Install
  • PDFCreator
    Render PDF files within applications that support the print fun...
    Download

    Installed

    Smart Install
  • Macabacus Lite for ...
    Use productivity tool for Excel 2003 for investment bankers and...
    Download

    Installed

    Smart Install
  • Waterfall Diagram T...
    Generate professional looking waterfall diagrams within minutes...
    Download

    Installed

    Smart Install
  • Microsoft Office Vi...
    Develop your own custom solutions visualizing various data.

    This download is served from an external site

    close

    NOTICE: This link will open a connection to a third-party site. CNET cannot ensure the security of software that is hosted on external sites.

    Continue to download

    Sponsored Products

    Download

    Installed

    Smart Install
  • Bulk File Generator...
    Output data from a selected range of cells to a single file.
    Download

    Installed

    Smart Install
  • iDecide
    Calculate and analyze risk factors.
    Download

    Installed

    Smart Install
All User Reviews
  • All versions:

    4.6 stars

    out of 15 votes

    • 5 star: 13
    • 4 star: 0
    • 3 star: 1
    • 2 star: 0
    • 1 star: 1
  • Current version:

    4.6 stars

    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

Results 1-10 of 10

Results 1-10 of 10

Add Your Review

Log in or create an account to post a review.
You are logged in as . Please submit your review for MRP_Excel.zip 2.0
Add Your Review

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

Submit your reply

Submit

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

cancel

E-mail this review

Submit cancel

Report offensive content

If you believe this comment is offensive or violates the CNET's Site Terms of Use, you can report it below (this will not automatically remove the comment). Once reported, our staff will be notified and the comment will be reviewed.

Select type of offense:

Offensive: Sexually explicit or offensive language
Spam: Advertisements or commercial links
Disruptive posting: Flaming or offending other users
Illegal activities: Promote cracked software, or other illegal content
Submit cancel

See more CNET content tagged:

Previous Versions:

Error

close

ERROR MESSAGE

If you think this is an error, please contact CNET TechTracker Support for further assistance.

Ok

Running Request

close

loading

Smart Install Software

close

CNET TechTracker will now automatically install software without requiring further action by you. (Note: This feature automatically accepts associated EULAs and third party applications on your behalf.)

You have selected the following software to Smart Install:

CNET TechTracker will attempt to install this software without interrupting you again. If an application requires manual installation, CNET TechTracker will download the installer and prompt you to take further action.

Proceed with Smart Install?

Confirm Standard Install Cancel

Submit a problem report for MRP_Excel.zip

close

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

Problem:

The CNET Installer isn't working as expected

The download link does not work

The software has a newer version

The software contains malware

Other

Description:

Please select a feedback type.

Please enter a description.

Submit Problem Report

Problem Report submitted

close

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

OK

Installed

Smart Install

About CNET Installer

The CNET Download.com Installer is a tiny ad-supported stub installer or "download manager" that helps securely deliver your downloads from Download.com's servers. We also include offers for carefully screened software that complies with Download.com Software Policies as part of our Installer process. Learn more

MRP_Excel.zip