{"product_id":"produktionsplanering-kapacitetskalkyl-excel-2026-2027","title":"Production Planning \u0026 Capacity Calculation 2026\/2027 – Production Order, Weekly Plan \u0026 Excel | Word\/PDF","description":"\u003cdiv class=\"mb-product-description\" lang=\"en\"\u003e\n\n\u003cp\u003e\u003cstrong\u003eProduction Planning \u0026amp; Capacity Calculation 2026\/2027\u003c\/strong\u003e is an editable template package for workshops, manufacturing companies, production managers, and small industrial businesses that need to consolidate production orders, resources, and capacity assessments. The package combines Word and PDF templates with an Excel workbook for planned order hours, weekly capacity, resource utilization, and deviations.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003e79 SEK – one-time purchase.\u003c\/strong\u003e No subscription. With a common structure for order IDs, resource IDs, and week codes, you can assess whether a planned week is overloaded and document decisions regarding rescheduling. It is a practical offline tool, not an ERP system, MES, or automated sequence optimizer.\u003c\/p\u003e\n\n\u003cnav aria-label=\"About the document template\"\u003e\u003cstrong\u003eAbout the document template:\u003c\/strong\u003e \u003ca href=\"#prod-innehall\"\u003eWhat is included\u003c\/a\u003e · \u003ca href=\"#prod-excel\"\u003eExcel\u003c\/a\u003e · \u003ca href=\"#prod-guide\"\u003eHow to use the package\u003c\/a\u003e · \u003ca href=\"#prod-regler\"\u003eRules\u003c\/a\u003e · \u003ca href=\"#prod-faq\"\u003eFAQ\u003c\/a\u003e · \u003ca href=\"#prod-format\"\u003eFormat\u003c\/a\u003e\u003c\/nav\u003e\n\u003cdiv style=\"background:#e8f5ed;border-left:4px solid #238657;padding:16px 19px;margin:18px 0\"\u003e\n\n\u003cstrong\u003eProfessionally and regulation-checked: October 9, 2026\u003c\/strong\u003e\u003cp\u003eVersion 1.0 relevant for 2026\/2027. The templates have been compared with current public guidance on employer planning and risk assessment responsibilities, including the Swedish Work Environment Authority's AFS 2023:1 and 2023:2. No official certification, formal specialist review of your specific production, or guarantee of delivery results is included.\u003c\/p\u003e\n\n\n\u003c\/div\u003e\n\n\u003ch2 id=\"prod-innehall\"\u003eWhat is included in the document package\u003c\/h2\u003e\n\n\u003ctable\u003e\n\n\u003cthead\u003e\u003ctr\u003e\n\n\u003cth\u003eDocument\u003c\/th\u003e\n\n\u003cth\u003ePractical content\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\u003eProduction Planning \u0026amp; Capacity Control – Routine\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eGovernance document with purpose, roles, weekly process, capacity calculations, pre-decision checks, deviation management, and decision log.\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\u003eProduction Order \u0026amp; Capacity Decision\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eForm for order details, standard time, resource, material, safety requirements, capacity assessment, decision, and follow-up.\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\u003eSeparate user guide\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eReview of each Excel sheet, real calculation examples, step-by-step instructions, common errors, limitations, 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\u003eProduction Planning Working Sheet (English)\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eSupplementary English working document for Swedish operations; not a full translation of the main templates.\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\u003eProduction Planning \u0026amp; Capacity in Excel\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eSix sheets with order register, resource details, weekly capacity, overload warnings, deviations, and overview.\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\u003eA total of 9 files\u003c\/strong\u003e in one combined ZIP package: four editable Word documents (DOCX), four searchable PDF documents in A4, and one Excel workbook (XLSX). Main language: Swedish, with a supplementary English working form.\u003c\/p\u003e\n\n\u003ch2\u003eWho is this template for?\u003c\/h2\u003e\n\n\u003cp\u003e\u003cstrong\u003eProduction managers\u003c\/strong\u003e who want to view planned hours per week and resource; \u003cstrong\u003eworkshops and smaller manufacturing companies\u003c\/strong\u003e planning based on standard times; \u003cstrong\u003eprocess owners and supervisors\u003c\/strong\u003e who document bottlenecks, decisions, and rescheduling; as well as \u003cstrong\u003emaintenance and quality functions\u003c\/strong\u003e that need a common order ID for follow-up.\u003c\/p\u003e\n\n\u003ch2 id=\"prod-excel\"\u003eExcel – six tabs with functional calculations\u003c\/h2\u003e\n\n\u003ctable\u003e\n\n\u003cthead\u003e\u003ctr\u003e\n\n\u003cth\u003eWorksheet\u003c\/th\u003e\n\n\u003cth\u003eFunction\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\u003eAutomatic counts of orders, active orders, remaining order hours, weekly plan rows, overloads, and open deviations.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eResources\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003e40 pre-prepared rows for resource ID, type, person responsible, gross hours per week, availability in percent, and net hours.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eProduction Orders\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003e80 pre-prepared order rows with quantity, standard time in minutes per unit, total\/remaining hours, week code, resource ID, status, and delivery date.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eWeekly Capacity\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003e100 planning rows per combination of week and resource. Net capacity, remaining order load, utilization, and capacity margin are calculated automatically.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eDeviations\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003e80 rows for obstacles, cause, consequence, responsibility, priority, action, date, status, and verification.\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\u003eDefinitions, unit management, calculation examples, usage limits, and 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\u003eFormulas use \u003cstrong\u003eremaining quantity × standard time ÷ 60\u003c\/strong\u003e for order hours and \u003cstrong\u003egross hours × availability\u003c\/strong\u003e for net capacity. The weekly resource load is summed only when the order's week code and resource ID match the capacity plan's code. Capacity rows display \u003cem\u003eOVERLOADED\u003c\/em\u003e when demand in calculated hours exceeds available net hours.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003eIllustrative example:\u003c\/strong\u003e An order of 80 items with a standard time of 15 minutes equals 20 total order hours. When 20 items have been produced, 15 hours remain. A resource with 32 gross hours and 75% availability has 24 net hours. In this example, that results in 62.5% utilization if no other orders are assigned to the same week and resource. The delivery file contains no fabricated real orders.\u003c\/p\u003e\n\n\u003cdiv style=\"background:#fff3d7;border-left:4px solid #d6a33a;padding:15px 19px;margin:18px 0\"\u003e\n\n\u003cstrong\u003eImportant limitation:\u003c\/strong\u003e Planned capacity does not guarantee delivery. The workbook does not automatically monitor material shortages, setup times, staff competence and working time regulations, dependencies between operations, real suitability of different machines, work environment risks, or product quality requirements. Approval of the production plan is done manually.\u003c\/div\u003e\n\n\u003ch2 id=\"prod-guide\"\u003eHow to use the production planning package\u003c\/h2\u003e\n\n\u003col\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eCollect facts.\u003c\/strong\u003e Identify production lines, machines, relevant standard times, and already decided delivery dates.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eCreate resource IDs.\u003c\/strong\u003e Enter realistic weekly gross capacity and estimated availability percentage.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eRegister production orders.\u003c\/strong\u003e Use a unique order ID, quantity, and standard time in \u003cem\u003eminutes per unit\u003c\/em\u003e. Enter the planned week in the format YYYY-WWW, for example, 2026-W042.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eCreate a weekly plan.\u003c\/strong\u003e Add a row for the same week code and resource ID in the Weekly Capacity sheet, as well as the decided gross time and availability.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eReview calculations.\u003c\/strong\u003e Check net capacity, remaining planned hours, utilization, and any overload warnings.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eDecide on actions.\u003c\/strong\u003e In case of capacity conflicts: assess redistribution, new delivery dates, material, competence, safety, and actually possible extra capacity. Document decisions and customer communication.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eUpdate actual outcome.\u003c\/strong\u003e Report actual completed quantities and record deviations. Take versioned copies of approved plans.\u003c\/li\u003e\n\n\u003cli\u003e\n\u003c\/li\u003e\n\u003c\/ol\u003e\n\n\u003ch2\u003eCommon mistakes\u003c\/h2\u003e\n\n\u003cul\u003e\n\n\u003cli\u003eUsing different week codes or resource IDs in the order and capacity sheets – this prevents the load from matching correctly.\u003c\/li\u003e\n\n\u003cli\u003eEntering the standard time in hours even though the input field refers to minutes.\u003c\/li\u003e\n\n\u003cli\u003eConfusing gross working time with actual available production time.\u003c\/li\u003e\n\n\u003cli\u003eForgetting setup time, maintenance, purchasing, personnel, and inspections that affect capacity.\u003c\/li\u003e\n\n\u003cli\u003eMarking an order as finished without simultaneously updating the actual quantity produced.\u003c\/li\u003e\n\n\u003cli\u003eViewing a green utilization indicator as proof that the production's work environment and product requirements are fulfilled.\u003c\/li\u003e\n\n\n\u003c\/ul\u003e\n\n\u003ch2 id=\"prod-regler\"\u003eProduction planning, work environment, and rules\u003c\/h2\u003e\n\n\u003cp\u003eThere is no general Swedish legal requirement to use a specific Excel template for production planning. However, employers are responsible for planning and organizing work safely. \u003cstrong\u003eAFS 2023:1\u003c\/strong\u003e includes obligations to regularly examine and assess work environment risks, including before making changes. \u003cstrong\u003eAFS 2023:2, Ch. 2 § 6\u003c\/strong\u003e deals with the prevention of unhealthy work pressure and ensuring that resources are adapted to the requirements of the work.\u003c\/p\u003e\n\n\u003cp\u003ePlanned utilization is merely a production administrative metric. It cannot replace risk assessment, working time monitoring, individual competence assessment, or actual safety measures. Furthermore, the employer must comply with applicable collective agreements, working time regulations, product-specific requirements, and safe routines during operation and changes.\u003c\/p\u003e\n\n\u003ch2 id=\"prod-faq\"\u003eFrequently asked questions\u003c\/h2\u003e\n\n\u003ch3\u003eCan Excel automatically calculate production capacity?\u003c\/h3\u003e\n\n\u003cp\u003eYes, net capacity and weekly utilization are calculated when you enter gross hours, availability, and matching resource and week codes for orders. The real-world accuracy of the capacity is your responsibility.\u003c\/p\u003e\n\n\u003ch3\u003eDo I get a Gantt chart or automatic production sequencing?\u003c\/h3\u003e\n\n\u003cp\u003eNo. This is not an optimization engine and does not contain automatic machine sequences or a Gantt system. The focus is on realistic weekly and resource capacity.\u003c\/p\u003e\n\n\u003ch3\u003eCan I handle multiple production lines?\u003c\/h3\u003e\n\n\u003cp\u003eYes. Each line or resource is given a unique resource ID; a separate weekly capacity row is used for each relevant combination of week and resource.\u003c\/p\u003e\n\n\u003ch3\u003eIs cost and inventory planning included?\u003c\/h3\u003e\n\n\u003cp\u003eNo, this package prioritizes capacity and case traceability. Full material requirements planning (MRP), inventory, and cost accounting are not included.\u003c\/p\u003e\n\n\u003ch3\u003eHow many orders can I register?\u003c\/h3\u003e\n\n\u003cp\u003eThe workbook has 80 prepared order rows, 40 resources, 100 weekly planning rows, and 80 deviation entries.\u003c\/p\u003e\n\n\u003ch3\u003eIs there an English version?\u003c\/h3\u003e\n\n\u003cp\u003eYes, a supplementary English-language Production Planning Working Sheet is included. The main Swedish documents and the detailed guide are not fully translated.\u003c\/p\u003e\n\n\u003ch3\u003eDoes the product work in Microsoft Excel?\u003c\/h3\u003e\n\n\u003cp\u003eYes, XLSX is intended for modern Excel or compatible software. For the best results, a spreadsheet program with support for standard formulas and data validation is recommended.\u003c\/p\u003e\n\n\u003ch2 id=\"prod-format\"\u003eFormat, price, and digital delivery\u003c\/h2\u003e\n\n\u003cp\u003eOne-time price \u003cstrong\u003e79 SEK\u003c\/strong\u003e. Delivered as a ZIP file with four Word files (DOCX), four searchable A4 PDFs, and an Excel workbook (XLSX). No physical shipping. Automatic digital customer delivery requires the ZIP file to be linked to the product variant in Shopify's Digital Products.\u003c\/p\u003e\n\n\u003ch2\u003eOfficial sources\u003c\/h2\u003e\n\n\u003cul\u003e\n\n\u003cli\u003e\u003ca href=\"https:\/\/www.av.se\/arbetsmiljoarbete-och-inspektioner\/publikationer\/foreskrifter\/afs-20231\/\"\u003eSwedish Work Environment Authority – AFS 2023:1, Systematic Work Environment Management\u003c\/a\u003e\u003c\/li\u003e\n\n\u003cli\u003e\u003ca href=\"https:\/\/www.av.se\/arbetsmiljoarbete-och-inspektioner\/publikationer\/foreskrifter\/afs-20232\/\"\u003eSwedish Work Environment Authority – AFS 2023:2, Planning, organizing and workload\u003c\/a\u003e\u003c\/li\u003e\n\n\u003cli\u003e\u003ca href=\"https:\/\/verksamt.se\/\"\u003eVerksamt.se – Practical support for business\u003c\/a\u003e\u003c\/li\u003e\n\n\n\u003c\/ul\u003e\n\n\u003ch2\u003eRelated products\u003c\/h2\u003e\n\n\u003cp\u003eComplement your planning with \u003ca href=\"\/en\/products\/maskinregister-forebyggande-underhall-excel-2026-2027\"\u003eMachine Register \u0026amp; Preventive Maintenance\u003c\/a\u003e for service and operational reliability, or \u003ca href=\"\/en\/products\/fmea-feleffektanalys-mall-excel-2026-2027\"\u003eFMEA – Failure Mode and Effects Analysis\u003c\/a\u003e for preventive risk analysis of processes.\u003c\/p\u003e\n\n\u003cp\u003e\u003csmall\u003eDisclaimer: The product provides general planning support and does not constitute a legal, technical, or organization-specific specialist assessment. The results should always be verified against real resources, agreements, and applicable safety requirements.\u003c\/small\u003e\u003c\/p\u003e\n\n\n\u003c\/div\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\u003eOverview of planning, material requirements, follow-up, and improvement.\u003c\/p\u003e\n\n\u003cp\u003e\u003ca href=\"\/en\/blogs\/foretag\/produktion-kvalitetsledning-guide-mrp-oee-fmea-8d\"\u003eGuide to production management and quality management\u003c\/a\u003e\u003c\/p\u003e\u003c\/section\u003e","brand":"Svenska Dokumentmallar","offers":[{"title":"Default Title","offer_id":55655096189270,"sku":"PRODUKTIONSPLANERING-2027","price":79.0,"currency_code":"SEK","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0827\/2373\/3846\/files\/01_Produktionsplanering_Kapacitet_Hero_2027_d9f09ce3-ed1c-46a5-a3a1-a2731c9e0d03.png?v=1791501258","url":"https:\/\/mallbutiken.se\/en\/products\/produktionsplanering-kapacitetskalkyl-excel-2026-2027","provider":"Mallbutiken","version":"1.0","type":"link"}