{"product_id":"materialbehovsplanering-mrp-inkopsplan-excel-2026-2027","title":"Material Requirements Planning \u0026 Purchasing Planning MRP Light 2026\/2027 – Excel, Word \u0026 PDF","description":"\u003csection class=\"mb-product-description\" lang=\"en\"\u003e\n\u003cp\u003e\u003cstrong\u003eMaterial Requirements Planning \u0026amp; Purchasing Planning – MRP Light 2026\/2027\u003c\/strong\u003e is an editable toolkit for smaller manufacturers, workshops, production managers, and purchasing agents who need to plan components before production begins. It combines a professional Excel sheet with document templates for material planning routines, purchasing decisions, a detailed user guide, and an English working template.\u003c\/p\u003e\n\n\u003cp\u003eUsing a \u003cstrong\u003esingle-level Bill of Materials (BOM)\u003c\/strong\u003e and planned finished product orders, the gross requirements for purchased components are calculated. Excel then accounts for stock balances, safety stock, confirmed incoming deliveries, and ordering terms to suggest what needs to be purchased. This means less manual calculation and clearer documentation for responsible purchasing decisions.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003ePrice 79 SEK as a one-time purchase\u003c\/strong\u003e – no subscription. This product is a limited and transparent \u003cem\u003eMRP Light\u003c\/em\u003e tool, not an ERP system, advanced multi-level MRP, or automatic inventory bookkeeping system.\u003c\/p\u003e\n\n\u003cnav aria-label=\"About the document template\"\u003e\u003cstrong\u003eAbout the document template:\u003c\/strong\u003e \u003ca href=\"#mrp-paket\"\u003eIncluded\u003c\/a\u003e · \u003ca href=\"#mrp-excel\"\u003eExcel Tool\u003c\/a\u003e · \u003ca href=\"#mrp-berakning\"\u003eCalculation Example\u003c\/a\u003e · \u003ca href=\"#mrp-steg\"\u003eHow it works\u003c\/a\u003e · \u003ca href=\"#mrp-risker\"\u003eLimitations\u003c\/a\u003e · \u003ca href=\"#mrp-faq\"\u003eFAQ\u003c\/a\u003e · \u003ca href=\"#mrp-kallor\"\u003eSources\u003c\/a\u003e\u003c\/nav\u003e\n\u003cdiv style=\"background:#E8F5EE;border-left:4px solid #348456;padding:15px 18px;margin:18px 0\"\u003e\n\n\u003cstrong\u003eLegally and\/or technically reviewed: October 7, 2026\u003c\/strong\u003e\u003cp\u003eVersion 1.0, intended for 2026\/2027. Formulas and control values have been tested, and the method description has been source-checked against public information regarding material requirements planning. The marking refers to an internal editorial\/technical review, not external certification, site audit, or an individual legal opinion.\u003c\/p\u003e\n\n\n\u003c\/div\u003e\n\n\u003ch2 id=\"mrp-paket\"\u003eWhat is included in the MRP package\u003c\/h2\u003e\n\n\u003ctable\u003e\n\n\u003cthead\u003e\u003ctr\u003e\n\n\u003cth\u003eDocument\u003c\/th\u003e\n\n\u003cth\u003eContent\u003c\/th\u003e\n\n\u003cth\u003eFormat\u003c\/th\u003e\n\n\n\u003c\/tr\u003e\u003c\/thead\u003e\n\n\u003ctbody\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eMaterial Planning Routine\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eResponsibilities, data sources, work methodology, BOM control, decisions, deviation handling, and archiving.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eMaterial \u0026amp; Purchasing Decisions\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003ePrintable control and decision protocol for purchasing quantities, supplier data, deviations, and approval.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eDetailed Swedish User Guide\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eReview of all seven tabs, preparations, step-by-step instructions, calculation examples, common errors, and division of responsibilities.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eMaterial Planning – Working Sheet (English)\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eSupplementary English working sheet for personnel in Swedish companies. Not a complete translation of every Swedish document.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eMaterial Requirements \u0026amp; MRP Light\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eExcel workbook with integrated registers, BOMs, material requirements, purchase suggestions, control tab, and dashboard.\u003c\/td\u003e\n\n\u003ctd\u003eExcel (XLSX)\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\n\u003c\/tbody\u003e\n\n\n\u003c\/table\u003e\n\n\u003cp\u003e\u003cstrong\u003e9 delivery files in one ZIP:\u003c\/strong\u003e 4 DOCX, 4 searchable A4-PDFs, and 1 XLSX. Swedish is the primary language; an English working sheet is included.\u003c\/p\u003e\n\n\u003ch2\u003eWhich businesses is the tool suitable for?\u003c\/h2\u003e\n\n\u003cp\u003e\u003cstrong\u003eSmall industrial companies\u003c\/strong\u003e with recurring finished products and clear component BOMs, \u003cstrong\u003eworkshops and assemblers\u003c\/strong\u003e that need to order material for specific jobs, \u003cstrong\u003eproduction planners\u003c\/strong\u003e who want to derive material needs from product orders, and \u003cstrong\u003epurchasing agents\u003c\/strong\u003e who want to consolidate component data, purchase terms, and individual decisions.\u003c\/p\u003e\n\n\u003cp\u003eMRP Light is best suited for a straightforward product structure where a finished product consumes purchased components at \u003cstrong\u003ea single BOM level\u003c\/strong\u003e. For intermediate products with their own underlying BOMs and multiple levels, you should use a more advanced MRP method.\u003c\/p\u003e\n\n\u003ch2 id=\"mrp-excel\"\u003eExcel – seven worksheets with calculation functions\u003c\/h2\u003e\n\n\u003ctable\u003e\n\n\u003cthead\u003e\u003ctr\u003e\n\n\u003cth\u003eWorksheet\u003c\/th\u003e\n\n\u003cth\u003eWhat can you do?\u003c\/th\u003e\n\n\n\u003c\/tr\u003e\u003c\/thead\u003e\n\n\u003ctbody\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eOverview\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eDashboard with registered components, BOM lines, orders, components requiring purchase, calculated purchase value, and data warnings.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eItems\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003e80 component lines for component ID, unit, balance, safety stock, confirmed incoming quantity, lead time, minimum order size, order multiple, unit price, and date. Gross, net, purchase suggestions, and value are calculated.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eBOM\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003e120 lines for finished product, component, quantity per finished unit, and scrap percentage. Summarizes input order volumes per product and calculates gross requirements per line.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eOrder Requirements\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003e100 order lines with ID, finished product ID, volume, due date, customer\/project, and verification of whether the product's BOM exists.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003ePurchasing Plan\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003e80 lines to retrieve suggested quantities and calculated value via component ID, along with actual ordered quantity, order number, confirmed delivery, and receipt.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eControl\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eCompilation of orders without a BOM, components missing from the item register, items with requirements, missing due dates, and potential item ID duplicates.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eInstructions\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eTab-by-tab guide, defined limitations, and methodology sources.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\n\u003c\/tbody\u003e\n\n\n\u003c\/table\u003e\n\n\u003cp\u003eThe workbook has clear headings, frozen top rows, input fields, data validation for certain status fields, and an automatic overview. It is designed for manual use offline in Microsoft Excel or compatible software.\u003c\/p\u003e\n\n\u003ch2 id=\"mrp-berakning\"\u003eHow the MRP calculation works – a concrete example\u003c\/h2\u003e\n\n\u003cp\u003eAssume you are going to manufacture \u003cstrong\u003e40 finished products\u003c\/strong\u003e. Each product requires \u003cstrong\u003e3 components\u003c\/strong\u003e and you have accounted for \u003cstrong\u003e5% scrap\u003c\/strong\u003e. The gross requirement for the component will be 40 × 3 × 1.05 = \u003cstrong\u003e126 units\u003c\/strong\u003e after rounding up.\u003c\/p\u003e\n\n\u003cp\u003eAt the same time, you have 40 units in stock, require 10 units in safety stock, and have 20 units in actual confirmed incoming deliveries. The net requirement therefore becomes \u003cstrong\u003e126 + 10 − 40 − 20 = 76 units\u003c\/strong\u003e. If the minimum order quantity is 50 units and the order multiple is 10 units, Excel suggests a purchase of \u003cstrong\u003e80 units\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003cp\u003eWith a unit price of 15 SEK, this corresponds to a \u003cstrong\u003ecalculated purchase value of 1,200 SEK excluding any VAT\u003c\/strong\u003e. The calculation determines this value but does not purchase material and does not automatically determine correct VAT or delivery time.\u003c\/p\u003e\n\n\u003cdiv style=\"background:#FFF3D6;border-left:4px solid #D6A23A;padding:15px 18px;margin:18px 0\"\u003e\n\n\u003cstrong\u003eImportant limitation:\u003c\/strong\u003e This is an \u003cem\u003eaggregate material requirements calculation\u003c\/em\u003e, not a fully time-phased MRP. Orders from the input data are aggregated over the entire planning horizon. No components are automatically reserved for individual orders, no multi-level BOM is exploded, and balances are not updated when a purchase order is placed or when material is used.\u003c\/div\u003e\n\n\u003ch2 id=\"mrp-steg\"\u003eHow to use material requirements planning\u003c\/h2\u003e\n\n\u003col\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eSelect planning horizon and order selection.\u003c\/strong\u003e Collect only the production and customer orders that are actually to be calculated. Remove canceled orders from the selection before calculating.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eRegister purchased components.\u003c\/strong\u003e Give each component a unique ID, enter unit, actual stock, safety stock, and confirmed incoming deliveries.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eCreate single-level BOMs.\u003c\/strong\u003e List which components are needed per finished product, how many, and if a verified scrap allowance is needed.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eEnter planned finished product orders.\u003c\/strong\u003e Use a product ID that matches the BOM and enter the requested quantity.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eCheck automatic gross calculation and net requirements.\u003c\/strong\u003e Verify that no component or BOM is missing and that units are comparable.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eAssess lead time and dates.\u003c\/strong\u003e State when the component is needed at the latest. The calculated order date subtracts calendar days and needs to be reviewed against holidays, transport times, and the supplier's actual order handling.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eMake actual purchasing decisions.\u003c\/strong\u003e Check MOQ, order multiple, agreements, price, and supplier confirmation. Document decisions in the separate protocol.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eKeep balances current.\u003c\/strong\u003e Register purchase orders, deliveries, and actual stock events in correct systems or your own controlled routines. Then update the calculation.\u003c\/li\u003e\n\n\n\n\u003c\/ol\u003e\n\n\u003ch2 id=\"mrp-risker\"\u003eImportant error sources and when you need more than Excel\u003c\/h2\u003e\n\n\u003cul\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eBOM version:\u003c\/strong\u003e Incorrect component consumption results in incorrect material requirements even if the formula is mathematically correct.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eStock and reservations:\u003c\/strong\u003e Available balance may be lower than physical balance if material is reserved for other orders.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eComponents in multiple products:\u003c\/strong\u003e Excel sums component requirements across matching BOM lines, provided codes are unique and consistent.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eLead time:\u003c\/strong\u003e Calculated order dates use calendar days, not a separate supplier calendar or working day model.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eUnits:\u003c\/strong\u003e Never mix meters, kilograms, or pieces without a documented unit conversion.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eConfirmed incoming:\u003c\/strong\u003e Confused or double-counted incoming deliveries can create misleading purchase suggestions.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eComplex business:\u003c\/strong\u003e Multi-level BOM, multiple warehouses, traceability requirements, batch control, dynamic weekly plans, and automatic transactions require special systems or customized controls.\u003c\/li\u003e\n\n\n\u003c\/ul\u003e\n\n\u003ch2\u003eWhat applies according to Swedish regulations?\u003c\/h2\u003e\n\n\u003cp\u003eThere is \u003cstrong\u003eno general Swedish legal requirement that all companies must use a specific MRP template\u003c\/strong\u003e. Material requirements planning is an administrative method. However, actual purchasing, documentation, inventory management, accounting, and products may be covered by separate contractual, accounting, work environment, or product safety requirements. A purchasing plan is not a binding supplier contract, a goods receipt check, an accounting voucher, or proof of product safety.\u003c\/p\u003e\n\n\u003ch2 id=\"mrp-faq\"\u003eFrequently asked questions and answers\u003c\/h2\u003e\n\n\u003ch3\u003eWhat is the difference between production planning and material requirements planning?\u003c\/h3\u003e\n\n\u003cp\u003eProduction planning assesses when and with what resources something should be manufactured. Material requirements planning calculates which components are needed for the planned production and what purchasing requirements remain after stock and planned deliveries.\u003c\/p\u003e\n\n\u003ch3\u003eCan the template calculate net requirements and purchase suggestions?\u003c\/h3\u003e\n\n\u003cp\u003eYes. With complete registered component, BOM, and order data, Excel calculates total gross\/net requirements and suggestions using MOQ and order multiple. Calculation results should be reviewed before ordering.\u003c\/p\u003e\n\n\u003ch3\u003eAre multi-level BOMs or MRP per calendar week supported?\u003c\/h3\u003e\n\n\u003cp\u003eNo. The product is explicitly limited to single-level BOMs and aggregated requirements for a specified selection. It is an MRP Light model without automatic time-phased planning.\u003c\/p\u003e\n\n\u003ch3\u003eIs the stock balance updated automatically when an order is manufactured or a purchase is received?\u003c\/h3\u003e\n\n\u003cp\u003eNo. Inventory is manually entered and must be kept accurate by the company. Actual purchase orders in the purchasing plan are separate registration items.\u003c\/p\u003e\n\n\u003ch3\u003eIs a user guide and English version included?\u003c\/h3\u003e\n\n\u003cp\u003eYes. A detailed guide in Swedish and a separate supplementary working sheet in English are included. The main Swedish documents are not fully translated.\u003c\/p\u003e\n\n\u003ch3\u003eCan I use the Excel tool as a purchase contract or invoice?\u003c\/h3\u003e\n\n\u003cp\u003eNo. It is a calculation and decision support tool. For commercial agreements, invoicing, and accounting, correct documents and routines are needed.\u003c\/p\u003e\n\n\u003ch3\u003eCan I use the template for many items and customers?\u003c\/h3\u003e\n\n\u003cp\u003eThe workbook has prepared rows for 80 purchased components, 120 BOM lines, 100 finished product orders, and 80 purchasing plan lines. For larger volumes, a more advanced business system is recommended.\u003c\/p\u003e\n\n\u003ch2\u003eFormat, price, and digital delivery\u003c\/h2\u003e\n\n\u003cp\u003e\u003cstrong\u003e79 SEK\u003c\/strong\u003e, one-time purchase. Delivered as a ZIP with four Word files (DOCX), four searchable A4-PDFs, and one Excel workbook (XLSX). The files can be used offline in compatible software. The product is digital and requires no physical shipping. Automatic download after purchase assumes the ZIP file is linked to the correct Shopify variant in Digital Products.\u003c\/p\u003e\n\n\u003ch2 id=\"mrp-kallor\"\u003eMethodological sources and further reading\u003c\/h2\u003e\n\n\u003cul\u003e\n\n\u003cli\u003e\u003ca href=\"https:\/\/www.mallar.biz\/mall\/material-inkopsplanering\"\u003eMallar.biz – Material and Purchasing Planning (MRP)\u003c\/a\u003e\u003c\/li\u003e\n\n\u003cli\u003e\u003ca href=\"https:\/\/usersolutions.com\/excel-templates\/mrp\"\u003eUser Solutions – Material Requirements Planning, Excel\u003c\/a\u003e\u003c\/li\u003e\n\n\u003cli\u003e\u003ca href=\"https:\/\/stocksmith.io\/mrp-excel\"\u003eStocksmith – MRP, BOMs, and inventory requirements\u003c\/a\u003e\u003c\/li\u003e\n\n\n\u003c\/ul\u003e\n\n\u003ch2\u003eRelated products on Mallbutiken.se\u003c\/h2\u003e\n\n\u003cp\u003eSupplement with \u003ca href=\"\/en\/products\/produktionsplanering-kapacitetskalkyl-excel-2026-2027\"\u003eProduction Planning \u0026amp; Capacity Calculation\u003c\/a\u003e when you also need resources and machine hours, or \u003ca href=\"\/en\/products\/leverantorsbedomning-leverantorsuppfoljning-excel-2026-2027\"\u003eSupplier Assessment \u0026amp; Supplier Follow-up\u003c\/a\u003e for quality and supplier assessment. The \u003ca href=\"\/en\/products\/maskinregister-forebyggande-underhall-excel-2026-2027\"\u003eMachine Register \u0026amp; Preventive Maintenance\u003c\/a\u003e is also relevant within the same production cluster.\u003c\/p\u003e\n\n\u003cp\u003e\u003csmall\u003eDisclaimer: The documents are general planning aids and cannot guarantee actual balances, error-free BOMs, correct prices, or agreed delivery times. They do not replace technical, legal, or accounting specialist assessment when required.\u003c\/small\u003e\u003c\/p\u003e\n\n\u003c\/section\u003e\n\u003csection class=\"mallbutiken-related-guide\" aria-label=\"Related guide\"\u003e\u003ch2\u003eDeepen your knowledge with our guides\u003c\/h2\u003e\n\n\u003cp\u003eSee how you use BOMs, inventory, and lead times to plan purchases.\u003c\/p\u003e\n\n\u003cp\u003e\u003ca href=\"\/en\/blogs\/foretag\/materialbehovsplanering-mrp-stycklista-inkop\"\u003eMaterial Requirements Planning with MRP – step by step\u003c\/a\u003e\u003c\/p\u003e\n\n\u003cp\u003e\u003ca href=\"\/en\/blogs\/foretag\/produktion-kvalitetsledning-guide-mrp-oee-fmea-8d\"\u003eOverview: production management and quality management\u003c\/a\u003e\u003c\/p\u003e\u003c\/section\u003e","brand":"Svenska Dokumentmallar","offers":[{"title":"Default Title","offer_id":55655157236054,"sku":"MRP-LIGHT-2027","price":79.0,"currency_code":"SEK","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0827\/2373\/3846\/files\/01_materialbehov_mrp_light_hero_2027_7131c305-6c93-4e60-83be-04092d2da263.png?v=1791503764","url":"https:\/\/mallbutiken.se\/en\/products\/materialbehovsplanering-mrp-inkopsplan-excel-2026-2027","provider":"Mallbutiken","version":"1.0","type":"link"}