{"id":3926,"date":"2019-10-22T11:06:20","date_gmt":"2019-10-22T11:06:20","guid":{"rendered":"https:\/\/www.mrpeasy.com\/blog\/?p=3926"},"modified":"2022-12-21T09:21:23","modified_gmt":"2022-12-21T09:21:23","slug":"how-to-go-from-excel-to-manufacturing-software-mrp-system","status":"publish","type":"post","link":"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/","title":{"rendered":"How to Go From Excel to Manufacturing Software \/ MRP System"},"content":{"rendered":"\n<p><strong>How to Go From Excel to Manufacturing Software \/ MRP System in Stock Management and Production Scheduling<\/strong>.<\/p>\n\n\n\n<!--more-->\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"590\" src=\"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System-1024x590.png\" alt=\"MRP-System\" class=\"wp-image-3927\" srcset=\"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System-1024x590.png 1024w, https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System-300x173.png 300w, https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System-768x442.png 768w, https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System.png 1346w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p><em>You can also listen to this article:<\/em><\/p>\n\n\n\n<iframe loading=\"lazy\" title=\"How to Go From Excel to Manufacturing Software \/ MRP System\" height=\"122\" width=\"100%\" style=\"border: none;\" scrolling=\"no\" data-name=\"pb-iframe-player\" src=\"https:\/\/www.podbean.com\/media\/player\/m65uq-ce8a5a?from=pb6admin&amp;download=1&amp;version=1&amp;auto=0&amp;share=1&amp;download=1&amp;rtl=0&amp;fonts=Helvetica&amp;skin=1&amp;pfauth=&amp;btn-skin=103\"><\/iframe>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_80 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #343333;color:#343333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #343333;color:#343333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#Find_a_Scalable_Solution\" >Find a Scalable Solution<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#Set_Up_the_Items_Database\" >Set Up the Items Database<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#Add_the_Recipes_or_Bill_of_Materials_to_the_System\" >Add the Recipes or Bill of Materials to the System<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#Set_Up_the_Machinery_Data_and_Set_the_Process_Layout\" >Set Up the Machinery Data and Set the Process Layout<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#Set_the_Economic_and_Financial_Conditions_of_Your_Production_and_Inventory_System\" >Set the Economic and Financial Conditions of Your Production and Inventory System<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#Add_the_Staff\" >Add the Staff<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#Start_Planning_Production\" >Start Planning Production<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Find_a_Scalable_Solution\"><\/span>Find a Scalable Solution<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Excel is a very efficient and flexible tool when managing material stocks and <a href=\"https:\/\/www.mrpeasy.com\/production-planning\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"production plans (opens in a new tab)\">production plans<\/a>. This tool allows you to describe the evolution of manufacturing processes. You will be able to quantify and pursue the continuous improvement of your business.<\/p>\n\n\n<div class=\"banner-v2\">\n    <p class=\"banner-v2__desc\">Manage your manufacturing business efficiently with MRPeasy<\/p>\n    <a class=\"banner-v2__link\" href=\"https:\/\/www.mrpeasy.com\/sign-up\/\" target=\"_blank\" data-ga-event=\"blog_signup_banner_blue\">Try for free<\/a>\n<\/div>\t\t<style>.banner-v2 {\n    float: right;\n    display: flex;\n    flex-direction: column;\n    justify-content: center;\n    align-items: center;\n    padding: 40px 32px;\n    gap: 16px;\n    width: 356px;\n    height: 205px;\n    background: linear-gradient(199.68deg, #6084E5 13.17%, #5FA7DD 82.1%);\n    border-radius: 4px;\n    margin-left: 12px;\n    margin-bottom: 12px;\n    margin-top: 15px;\n}\n\n@media (max-width: 767.98px) {\n    .banner-v2 {\n         width: 100%;\n         height: 173px;\n         margin-bottom: 0;\n         margin-left: 0;\n    }\n}\n\n.single__content p.banner-v2__desc {\n    margin: 0 !important;\n}\n\np.banner-v2__desc {\n    width: 292px;\n    font-style: normal;\n    font-weight: 700;\n    font-size: 22px;\n    line-height: 29px !important;\n    text-align: center;\n    color: #FFFFFF;\n    margin: 0 !important;\n    order: 0 !important;\n}\n\n.single__content a.banner-v2__link {\n    color: #FFFFFF !important;\n}\n\n.single__content a.banner-v2__link:hover {\n    color: #003557 !important;\n}\n\na.banner-v2__link {\n    display: flex;\n    justify-content: center;\n    align-items: center;\n    width: 181px;\n    height: 51px;\n    padding: 18px 0;\n    border-radius: 4px;\n    background: #003557;\n    font-weight: 700;\n    font-size: 16px;\n    color: #FFFFFF !important;\n    text-decoration: none !important;\n    order: 1 !important;\n}\n\n.banner-v2__link:hover {\n    background: white;\n    color: #003557 !important;\n}<\/style>\n\t\t\n\n\n<p>Yet, you have noticed that this tool loses its greatest potential every time the organization expands. There are more users and functions required in the organization. It is necessary to have real-time information. <strong>So, it is necessary to migrate from Excel to <a href=\"https:\/\/www.mrpeasy.com\/mrp-system\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"MRP System (opens in a new tab)\">MRP System<\/a>.<\/strong><\/p>\n\n\n\n<p>First, keep in mind that the introduction of <a href=\"https:\/\/www.mrpeasy.com\/manufacturing-software\/\">manufacturing software<\/a> involves the integration of people. Thus, the following essential points must be considered:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Communicate and integrate your work team about the migration process.<\/li><li>Define all involved areas of your organization. <\/li><li>Distribute tutorials for managers and the work team.<\/li><li>Train the personnel involved in the usage of the new system.<\/li><li>Introduce pilot tests to ensure the proper system operation.<\/li><li>Ensure that the new software is fully used and that Excel becomes a complementary tool.<\/li><\/ol>\n\n\n\n<p>Once the organizational aspects have been overcome,\nthe process of software change must be taken into account. The most relevant aspects of\nthis migration process are presented below:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Set_Up_the_Items_Database\"><\/span>Set Up the Items Database<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1006\" height=\"527\" src=\"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System-Stock.png\" alt=\"MRP-System-Stock\" class=\"wp-image-3929\" srcset=\"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System-Stock.png 1006w, https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System-Stock-300x157.png 300w, https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System-Stock-768x402.png 768w\" sizes=\"auto, (max-width: 1006px) 100vw, 1006px\" \/><\/figure><\/div>\n\n\n\n<p>Items comprise of 4 categories:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>The raw materials, parts, and components.<\/li><li>The semi-finished products and sub-assemblies.<\/li><li>The finished goods.<\/li><li>It is also possible to manage indirect materials, such as spare parts, cleaning materials, Health &amp; Safety items, etc.<\/li><\/ul>\n\n\n\n<p>Before the items can\nbe loaded into the system, they\nmust be properly organized. <\/p>\n\n\n\n<p>Each must have a\nunique code, a proper description. Use an intelligent coding\nsystem that allows stock managers to recognize the type of material just by\nreading the material code. A combination of\nalphanumeric digits is generally the best alternative. <\/p>\n\n\n\n<p>Organize the items by product groups for easier grouping, looking up, and analysis. <\/p>\n\n\n\n<p>You must also\nconsider the unit of measurements, unit conversions from vendors, e.g. number\nof units by the type of packaging and packing. <\/p>\n\n\n\n<p>Also, define the\nsafety stock levels to prevent shortages. <\/p>\n\n\n\n<p>Define a name for\neach area in your warehouse. This will help with finding each item as quickly as possible.<\/p>\n\n\n\n<p>It will be necessary to identify also the prices and costs of the materials. Detail the purchasing options for each item: the vendors, expected prices, lead times, minimum order quantities, vendor unit conversions, etc. <\/p>\n\n\n\n<p>Later, when ready\nto go live with the system, ask your accountant to supply the current inventory\nposition and unit cost (paid price) for each item on hand for correct data. And less\nimportant is to freeze your inventory levels during the go-live process. It will ensure that all\nquantities keep the correct figures.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Add_the_Recipes_or_Bill_of_Materials_to_the_System\"><\/span>Add the Recipes or Bill of Materials to the System<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1006\" height=\"710\" src=\"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System-Stock-BOM.png\" alt=\"MRP-System-Stock-BOM\" class=\"wp-image-3931\" srcset=\"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System-Stock-BOM.png 1006w, https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System-Stock-BOM-300x212.png 300w, https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System-Stock-BOM-768x542.png 768w\" sizes=\"auto, (max-width: 1006px) 100vw, 1006px\" \/><\/figure><\/div>\n\n\n\n<p>What is necessary to do once the items are in the MRP System? <\/p>\n\n\n\n<p>It is necessary to\ncreate relationships that show the connection of materials to the products. <\/p>\n\n\n\n<p>Put together the <a href=\"https:\/\/www.mrpeasy.com\/blog\/bill-of-materials\/\" target=\"_blank\" rel=\"noreferrer noopener\">Bills of Material (BOM)<\/a> for each of your products, semi-finished product, and sub-assembly.<\/p>\n\n\n\n<p>Each unit of the finished product is made up of the\nsum of pieces that are added until the final product is ready. <\/p>\n\n\n\n<p>Possibly, the BOM should also include scrap and waste quantities for materials, for better planning and accurate consumption.<\/p>\n\n\n\n<p>Once this data is connected with the production lead times of sub-assemblies and supply lead times of materials, the MRP System can run. This means:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>The explosion of materials can be made for purchasing purposes.<\/li><li>It is possible to calculate when and how many materials are required.<\/li><li>Forward or reverse planning of the times required by the factory for planning purposes. <\/li><\/ul>\n\n\n\n<p>You will be able\nto manage your purchasing orders with just one click. Suppliers, prices,\ndelivery times, everything will be there. Manage your inbound logistics using\naccurate statistics and know your purchasing needs.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Set_Up_the_Machinery_Data_and_Set_the_Process_Layout\"><\/span>Set Up the Machinery Data and Set the Process Layout<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1005\" height=\"662\" src=\"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System-Routing.png\" alt=\"MRP-System-Routing\" class=\"wp-image-3933\" srcset=\"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System-Routing.png 1005w, https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System-Routing-300x198.png 300w, https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System-Routing-768x506.png 768w\" sizes=\"auto, (max-width: 1005px) 100vw, 1005px\" \/><\/figure><\/div>\n\n\n\n<p>The machinery and equipment are fixed assets of the organization. These assets transform the raw material into finished products. There are two types of production systems:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Assembly line production.<\/li><li>Batch production.<\/li><\/ol>\n\n\n\n<p>First,\norganize and group your machinery and equipment into workstation groups. A workstation group&nbsp;is a group of machines that\ncan all do the same tasks.<\/p>\n\n\n\n<p>Then, for each product, define the production routing:\nenter and describe all the production stages following the production sequence\nthrough various workstation groups to get a unit of product starting from the\nraw material. <\/p>\n\n\n\n<p>The available\nworking hours for each workstation (machine) combined with the information from\nthe routing &#8211; required operations and their durations by workstation group \u2013\nmake up the production capacity.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Set_the_Economic_and_Financial_Conditions_of_Your_Production_and_Inventory_System\"><\/span>Set the Economic and Financial Conditions of Your Production and Inventory System<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1003\" height=\"747\" src=\"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System-Estimate.png\" alt=\"MRP-System-Estimate\" class=\"wp-image-3935\" srcset=\"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System-Estimate.png 1003w, https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System-Estimate-300x223.png 300w, https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System-Estimate-768x572.png 768w\" sizes=\"auto, (max-width: 1003px) 100vw, 1003px\" \/><\/figure><\/div>\n\n\n\n<p>It will be necessary to provide direct costs to\ndetermine the cost of each product. This implies incorporating:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>The direct cost of materials.<\/li><li>The direct cost of staff per hour of work.<\/li><li>The manufacturing overhead rate (e.g. variable cost of machinery, electricity, consumables\u2026). <\/li><\/ul>\n\n\n\n<p>The <a href=\"https:\/\/www.mrpeasy.com\/production-management\/\" target=\"_blank\" rel=\"noreferrer noopener\">production management<\/a> and inventory system automatically links operational activities with the commercial and financial processes. <\/p>\n\n\n\n<p>Define the mark-ups finished product will have, the billing system, and the payment terms. <\/p>\n\n\n\n<p>This will allow\nyou to send quotes and invoices in less time. <\/p>\n\n\n\n<p>Besides, the\ncommercial area may track inventories and the entire sales process. Manage the\nwhole supply chain from quotation to delivery. You can\nalso manage reverse logistics, invoicing and payments as part of an integrated\nprocess.<\/p>\n\n\n\n<p>You will have the possibility to clearly visualize the performance of your business. You can better track your cash flows, balances and real-time gains\/losses, as well as understand the profitability of the business.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Add_the_Staff\"><\/span>Add the Staff<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1004\" height=\"494\" src=\"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-system-kiosk.png\" alt=\"MRP-system-kiosk\" class=\"wp-image-3937\" srcset=\"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-system-kiosk.png 1004w, https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-system-kiosk-300x148.png 300w, https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-system-kiosk-768x378.png 768w\" sizes=\"auto, (max-width: 1004px) 100vw, 1004px\" \/><\/figure><\/div>\n\n\n\n<p>Include your staff, organized into departments, and assign them to the right operations, or workstations.<\/p>\n\n\n\n<p>The <a href=\"https:\/\/www.mrpeasy.com\/enterprise-resource-planning\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"ERP (opens in a new tab)\">ERP<\/a> or MRP System presents a friendly user-interface both for planning and reporting purposes from a PC or a mobile device. <\/p>\n\n\n\n<p>This way you can\nalso get real-time reports of the production processes.<\/p>\n\n\n<div class=\"banner-v1\">\n    <div class=\"banner__text\">\n        <div class=\"banner-v1__title\">Ditch the spreadsheets and start properly managing your manufacturing company<\/div>\n        <div class=\"banner-v1__desc\">MRPeasy users report an average increase of 54% in overall performance and 42% in on-time deliveries.<\/div>\n        <div><a class=\"banner-v1__link\" href=\"https:\/\/www.mrpeasy.com\/sign-up\/\" target=\"_blank\" data-ga-event=\"blog_signup_banner_white\">Try for free<\/a><\/div>\n    <\/div>\n    <div class=\"banner__img\">\n        <img decoding=\"async\" src=\"https:\/\/www.mrpeasy.com\/blog\/wp-content\/themes\/mrpeasy\/assets\/images\/banner.svg\" alt=\"banner\">\n    <\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Start_Planning_Production\"><\/span><strong>S<\/strong>tart Planning Production<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1005\" height=\"947\" src=\"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/Production-schedule-Calendar.png\" alt=\"Production-schedule-Calendar\" class=\"wp-image-3939\" srcset=\"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/Production-schedule-Calendar.png 1005w, https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/Production-schedule-Calendar-300x283.png 300w, https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/Production-schedule-Calendar-768x724.png 768w\" sizes=\"auto, (max-width: 1005px) 100vw, 1005px\" \/><\/figure><\/div>\n\n\n\n<p>It\u2019s time to manage your resources (workstations, materials, and workers) using a realistic production schedule. <\/p>\n\n\n\n<p><em>A more detailed article about MRP can be found here &#8211; <\/em><a rel=\"noreferrer noopener\" aria-label=\"Material Requirements Planning (opens in a new tab)\" href=\"https:\/\/www.mrpeasy.com\/material-requirements-planning\/\" target=\"_blank\"><em>Material Requirements Planning<\/em><\/a><em>.<\/em><\/p>\n\n\n\n<p>Let the system\nfigure out when operations can and should be performed.<\/p>\n\n\n\n<p>Use dynamic planning tools by dragging and dropping work orders on the calendars or <a href=\"https:\/\/www.projectmanager.com\/gantt-chart\" target=\"_blank\" rel=\"noreferrer noopener nofollow\" aria-label=\"Gantt charts (opens in a new tab)\">Gantt charts<\/a>. You will see how easy the planning process becomes in comparison to the traditional Excel spreadsheets.<\/p>\n\n\n\n<p>You will enhance your customer&#8217;s satisfaction, avoiding undesirable stock-outs, and shipment delays.  Streamline your stock management and <a href=\"https:\/\/www.mrpeasy.com\/production-scheduling\/\" target=\"_blank\" rel=\"noreferrer noopener\">production scheduling<\/a> with all areas of your organization. See your business as an integrated unit and say goodbye to the Excel spreadsheets!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to Go From Excel to Manufacturing Software \/ MRP System in Stock Management and Production Scheduling.<\/p>\n","protected":false},"author":4,"featured_media":3927,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[92,91,94],"tags":[],"class_list":["post-3926","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-accounting","category-implementation","category-tips"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Go From Excel to Manufacturing Software \/ MRP System<\/title>\n<meta name=\"description\" content=\"How to Go From Excel to Manufacturing Software \/ MRP System in Stock Management and Production Scheduling. Say goodbye to the Excel spreadsheets!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Go From Excel to Manufacturing Software \/ MRP System\" \/>\n<meta property=\"og:description\" content=\"How to Go From Excel to Manufacturing Software \/ MRP System in Stock Management and Production Scheduling. Say goodbye to the Excel spreadsheets!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog for Manufacturers and Distributors\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-22T11:06:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-21T09:21:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1346\" \/>\n\t<meta property=\"og:image:height\" content=\"775\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Karl Heinrich Lauri\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Karl Heinrich Lauri\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/\"},\"author\":{\"name\":\"Karl Heinrich Lauri\",\"@id\":\"https:\/\/www.mrpeasy.com\/blog\/#\/schema\/person\/9f3fc21487b8bd06ee559963df65c254\"},\"headline\":\"How to Go From Excel to Manufacturing Software \/ MRP System\",\"datePublished\":\"2019-10-22T11:06:20+00:00\",\"dateModified\":\"2022-12-21T09:21:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/\"},\"wordCount\":1139,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System.png\",\"articleSection\":[\"Accounting\",\"Implementation\",\"Manufacturing Tips\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/\",\"url\":\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/\",\"name\":\"How to Go From Excel to Manufacturing Software \/ MRP System\",\"isPartOf\":{\"@id\":\"https:\/\/www.mrpeasy.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System.png\",\"datePublished\":\"2019-10-22T11:06:20+00:00\",\"dateModified\":\"2022-12-21T09:21:23+00:00\",\"author\":{\"@id\":\"https:\/\/www.mrpeasy.com\/blog\/#\/schema\/person\/9f3fc21487b8bd06ee559963df65c254\"},\"description\":\"How to Go From Excel to Manufacturing Software \/ MRP System in Stock Management and Production Scheduling. Say goodbye to the Excel spreadsheets!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#primaryimage\",\"url\":\"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System.png\",\"contentUrl\":\"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System.png\",\"width\":1346,\"height\":775,\"caption\":\"MRP-System\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.mrpeasy.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Go From Excel to Manufacturing Software \/ MRP System\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.mrpeasy.com\/blog\/#website\",\"url\":\"https:\/\/www.mrpeasy.com\/blog\/\",\"name\":\"Blog for Manufacturers and Distributors\",\"description\":\"MRPeasy\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.mrpeasy.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.mrpeasy.com\/blog\/#\/schema\/person\/9f3fc21487b8bd06ee559963df65c254\",\"name\":\"Karl Heinrich Lauri\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.mrpeasy.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9bfbd724fcc3682ea1ca8376247ce950e92810c2fc786ac129ef4a8e3ba6bcac?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9bfbd724fcc3682ea1ca8376247ce950e92810c2fc786ac129ef4a8e3ba6bcac?s=96&d=blank&r=g\",\"caption\":\"Karl Heinrich Lauri\"},\"description\":\"For more than 6 years, Karl has been working at MRPeasy with the main goal of getting useful information out to small manufacturers and distributors. He enjoys working with other industry specialists to add real-life insights into his articles, with a special focus on using the feedback from manufacturers implementing MRP software. Karl has also collaborated with respected publications in the manufacturing field, including IndustryWeek and FoodLogistics.\",\"url\":\"https:\/\/www.mrpeasy.com\/blog\/author\/karl-h\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Go From Excel to Manufacturing Software \/ MRP System","description":"How to Go From Excel to Manufacturing Software \/ MRP System in Stock Management and Production Scheduling. Say goodbye to the Excel spreadsheets!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/","og_locale":"en_US","og_type":"article","og_title":"How to Go From Excel to Manufacturing Software \/ MRP System","og_description":"How to Go From Excel to Manufacturing Software \/ MRP System in Stock Management and Production Scheduling. Say goodbye to the Excel spreadsheets!","og_url":"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/","og_site_name":"Blog for Manufacturers and Distributors","article_published_time":"2019-10-22T11:06:20+00:00","article_modified_time":"2022-12-21T09:21:23+00:00","og_image":[{"width":1346,"height":775,"url":"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System.png","type":"image\/png"}],"author":"Karl Heinrich Lauri","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Karl Heinrich Lauri","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#article","isPartOf":{"@id":"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/"},"author":{"name":"Karl Heinrich Lauri","@id":"https:\/\/www.mrpeasy.com\/blog\/#\/schema\/person\/9f3fc21487b8bd06ee559963df65c254"},"headline":"How to Go From Excel to Manufacturing Software \/ MRP System","datePublished":"2019-10-22T11:06:20+00:00","dateModified":"2022-12-21T09:21:23+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/"},"wordCount":1139,"commentCount":0,"image":{"@id":"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System.png","articleSection":["Accounting","Implementation","Manufacturing Tips"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/","url":"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/","name":"How to Go From Excel to Manufacturing Software \/ MRP System","isPartOf":{"@id":"https:\/\/www.mrpeasy.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#primaryimage"},"image":{"@id":"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System.png","datePublished":"2019-10-22T11:06:20+00:00","dateModified":"2022-12-21T09:21:23+00:00","author":{"@id":"https:\/\/www.mrpeasy.com\/blog\/#\/schema\/person\/9f3fc21487b8bd06ee559963df65c254"},"description":"How to Go From Excel to Manufacturing Software \/ MRP System in Stock Management and Production Scheduling. Say goodbye to the Excel spreadsheets!","breadcrumb":{"@id":"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#primaryimage","url":"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System.png","contentUrl":"https:\/\/www.mrpeasy.com\/blog\/wp-content\/uploads\/2019\/10\/MRP-System.png","width":1346,"height":775,"caption":"MRP-System"},{"@type":"BreadcrumbList","@id":"https:\/\/www.mrpeasy.com\/blog\/how-to-go-from-excel-to-manufacturing-software-mrp-system\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.mrpeasy.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Go From Excel to Manufacturing Software \/ MRP System"}]},{"@type":"WebSite","@id":"https:\/\/www.mrpeasy.com\/blog\/#website","url":"https:\/\/www.mrpeasy.com\/blog\/","name":"Blog for Manufacturers and Distributors","description":"MRPeasy","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mrpeasy.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.mrpeasy.com\/blog\/#\/schema\/person\/9f3fc21487b8bd06ee559963df65c254","name":"Karl Heinrich Lauri","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mrpeasy.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9bfbd724fcc3682ea1ca8376247ce950e92810c2fc786ac129ef4a8e3ba6bcac?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9bfbd724fcc3682ea1ca8376247ce950e92810c2fc786ac129ef4a8e3ba6bcac?s=96&d=blank&r=g","caption":"Karl Heinrich Lauri"},"description":"For more than 6 years, Karl has been working at MRPeasy with the main goal of getting useful information out to small manufacturers and distributors. He enjoys working with other industry specialists to add real-life insights into his articles, with a special focus on using the feedback from manufacturers implementing MRP software. Karl has also collaborated with respected publications in the manufacturing field, including IndustryWeek and FoodLogistics.","url":"https:\/\/www.mrpeasy.com\/blog\/author\/karl-h\/"}]}},"_links":{"self":[{"href":"https:\/\/www.mrpeasy.com\/blog\/wp-json\/wp\/v2\/posts\/3926","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrpeasy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mrpeasy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrpeasy.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrpeasy.com\/blog\/wp-json\/wp\/v2\/comments?post=3926"}],"version-history":[{"count":23,"href":"https:\/\/www.mrpeasy.com\/blog\/wp-json\/wp\/v2\/posts\/3926\/revisions"}],"predecessor-version":[{"id":12851,"href":"https:\/\/www.mrpeasy.com\/blog\/wp-json\/wp\/v2\/posts\/3926\/revisions\/12851"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mrpeasy.com\/blog\/wp-json\/wp\/v2\/media\/3927"}],"wp:attachment":[{"href":"https:\/\/www.mrpeasy.com\/blog\/wp-json\/wp\/v2\/media?parent=3926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mrpeasy.com\/blog\/wp-json\/wp\/v2\/categories?post=3926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mrpeasy.com\/blog\/wp-json\/wp\/v2\/tags?post=3926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}