Kiến thức quản trị
Home Products news What is a production plan? The 7-step planning process for a factory.
Nguyễn Thu Huế
(19.11.2026)

What is a production plan? The 7-step planning process for a factory.

Orders are piling up, materials are arriving late, and machines are shutting down unexpectedly: almost every week, the planners have to revise the production schedule at least once. When the plan lacks a solid foundation, the consequences are delayed deliveries, inventory imbalances (both surplus and shortage), and workers who are sometimes overworked and sometimes idle.

This article is for planners, production managers, and factory managers. You will learn what a production plan is, the 7-step production planning process (with calculation examples), how to create a production plan based on orders, how to do it using Excel, and the signs that indicate it's time to use a dedicated system.

1. What is a production plan?

1.1. Concept

A production plan is a document that defines what products a business will produce, in what quantities, when, using which machinery and personnel, and what raw materials are needed to meet deadlines. Production planning is the process of translating market demand (orders, forecasts) into a specific work schedule for the factory, within the limits of available resources.

A production plan serves as a bridge between business (when to deliver), purchasing and warehousing (what materials to prepare), and the factory (what to do first, what to do next), allowing all three parties to view a single set of data.

1.2. What questions should a production plan answer?

Whether created on paper, in Excel, or using software, a viable business plan must answer five questions:

  • What to produce? Products, versions, and specifications according to orders or forecasts.
  • How much will be produced? The amount produced after deducting inventory and the quantity already under production orders.
  • When? Start date, completion date for each stage, and delivery date.
  • By what resources? Workshops, production lines, machinery, shifts, and labor.
  • What materials are needed, and when should they be purchased? Material requirements are based on specifications and supplier delivery times.

A good plan helps ensure on-time deliveries, reduces unnecessary inventory, utilizes machinery and labor efficiently, and helps you calculate which orders will be delayed by a disruptive order.

2. Levels of production planning

"Production plan" is not a single file, but a series of plans progressing from general to detailed, with each level having its own responsible person.

Level Time vision Main output
Comprehensive plan Quarter, year Production levels by product group, manpower requirements, and budget.
Master Production Plan (MPS) Week, month Quantity and completion time for each product code
Material and Capacity Planning (MRP, CRP) Week, month Purchase schedule, semi-finished product production order, machine load level.
Detailed production schedule (or scheduling) Shift, day The order of work on each machine, each shift

The MPS (Material Planning Specialist) is the most active planning level and also the business level directly involved in fulfilling delivery deadlines. From the MPS, the factory calculates material requirements (MRP) and checks whether machinery has sufficient operating hours (CRP); if materials are not delivered on time or machinery is overloaded, the MPS must make adjustments.

Read more: MRP II: A mandatory requirement on ERP systems for manufacturing businesses

3. Input data to prepare before production planning.

A plan is only accurate when the input data is accurate. A planner needs to have:

  • Orders and Forecasts: Signed orders, sales forecasts, delivery dates, and priority levels.
  • Inventory: Finished goods, semi-finished goods, raw materials, including goods in transit or awaiting inspection.
  • Bill of Materials (BOM): The materials that make up a product, along with an allowable loss rate.
  • Technological process and standard timeline: Stages, equipment used, preparation time, and running time.
  • Production and supply capacity: Number of machines, number of shifts, number of workers, maintenance schedule, supplier delivery times.

The Bill of Materials (BOM) and standard time are two of the most common sources of error: an outdated standard can skew the entire material calculation, so periodic review and comparison with actual factory data are necessary.

4. The 7-step production planning process

The process below is applicable to most factories. The examples use hypothetical data; please replace it with data from your business.

4.1. Step 1: Gather and confirm needs

Gather all requirements for the planning period (signed orders, forecasts, inventory replenishment plans), confirm delivery dates and priorities with the business team, and separate confirmed requirements from projected requirements because the risks and material handling methods for these two categories differ.

4.2. Step 2: Determine the required production volume.

Subtract the portion already in stock, the portion under production, and the safety stock:

Production quantity needed = Demand + Safety stock − Existing inventory − Quantity currently under production order

Example: Product A has a demand of 1,200 units per month, inventory is 150, work-in-progress orders to be completed within the period are 50, and the desired safety margin is 100. The required production volume = 1,200 + 100 − 150 − 50 = 1,100 units.

4.3. Step 3: Check production capacity

Compare the required machine hours with the available machine hours, starting with the bottleneck stage (the stage with the highest load, which determines the output of the entire production line):

  • Available machine hours = Number of machines × Hours per shift × Number of shifts × Number of working days × Planned performance
  • Machine hours required = Output × Standard time per product
  • Load level = Hours required by the machine ÷ Hours available by the machine

Example: The processing stage has 4 machines, 2 shifts per day, each shift 8 hours, 26 working days, planned efficiency 80%, standard time 1.1 machine hours per product. Available machine hours = 4 × 8 × 2 × 26 × 80% = 1,331.2 hours. Required machine hours = 1,100 × 1.1 = 1,210 hours. Load level ≈ 90.9%: feasible but only a small buffer remains.

If an additional order of 200 products is placed, the required working hours would increase to 1,430 hours, exceeding available hours by 98.8 hours. This would necessitate options such as overtime, outsourcing, splitting deliveries into smaller batches, or renegotiating delivery dates. Exceeding 100% of capacity is not feasible, while near 100% means there's no room for error.

4.4. Step 4: Calculate material requirements

The calculation proceeds from finished goods down to semi-finished goods and then to raw materials (breaking the BOM):

  • Material requirements = Production volume × Standard rate × (1 + Loss rate)
  • Quantity to purchase = Material requirements + Safety stock − Current stock − Quantity ordered but not yet received
  • Latest order date = Required date − Supplier's delivery time

Example: Each product A uses 2.5 kg of steel plate, with an allowable loss of 4%. Steel requirement = 1,100 × 2.5 × 1.04 = 2,860 kg. The warehouse has 900 kg, 500 kg have been ordered but not yet arrived, and there is a safety margin of 300 kg. Therefore, the amount to be purchased = 2,860 + 300 − 900 − 500 = 1,760 kg. If the supplier delivers within 7 days, the purchase order must be issued at least 7 days before the start of production.

4.5. Step 5: Develop the master production plan and detailed schedule.

Divide production output by week, by day, and assign it to each machine and shift. Prioritize delivery dates, group orders with similar configurations to reduce changeover time, prioritize bottleneck processes, and allow time for maintenance instead of running machines at 100%. Forward scheduling starts from the date materials are ready and calculates the completion date; backward scheduling starts from the delivery date and calculates backward from the latest start date, typically used for order-based production.

4.6. Step 6: Finalize, approve, and issue the production order.

Before going to the factory, the plan needs to be reviewed with sales, purchasing, warehousing, production, quality, and maintenance, ideally through a regular weekly briefing. Once approved, issue a production order along with a list of required materials. A time fence should be established: the plan can only be changed within the next few days with the approval of an authorized person.

4.7. Step 7: Monitoring, measuring, and adjusting

At the end of each shift or day, record output, actual machine hours, material losses, and reasons for delays. More importantly, use actual data to update inputs: if actual efficiency is only 72% while the planned 80% is assumed, that figure must be adjusted next time.

5. Develop production plans based on orders.

5.1. How does production based on orders differ from production based on inventory plans?

Criteria According to the Material and Trades Tracking (MTS) plan. By Order (MTO)
Basis for planning Forecast demand and target inventory Actual order for each customer
Finished goods inventory Yes, delivery right from the warehouse. Very low or none
Main risks Surplus or deficit due to incorrect forecasting Delivery delayed due to insufficient capacity or materials.
Common industries Consumer goods, common materials Mechanical engineering, furniture, packaging, custom printing.

Many businesses operate using a combination of processes: they manufacture common components in advance and only complete them when an order is placed. You can refer to how mechanical , packaging , or furniture businesses organize their operations according to the specific characteristics of their respective industries.

5.2. Production planning process based on orders

The process still follows the 7-step framework in section 4, but each order is treated as a small project:

  • Review the order and determine a feasible delivery date (see section 5.3) before committing to the customer.
  • Finalizing the BOM and specific procedures for orders: For customized products, do not reuse old BOMs without prior verification.
  • Order specialized supplies in advance: Supplies with long delivery times are often the main reason for order delays.
  • Schedule back-to-back orders and issue orders with assigned order codes to track progress and costs for each order.

5.3. Promising delivery dates: the most challenging problem in made-to-order production.

The earliest feasible delivery date is the later date between the two conditions (materials have arrived, machine is available), plus production, inspection, and shipping time.

For example: specialized materials require 14 working days to arrive, 6 days for production, and 2 days for packaging and inspection. If capacity is available immediately, the earliest delivery date is 14 + 6 + 2 = 22 working days from order confirmation. If the machine is fully booked until the 18th day, the delivery date will be delayed to 18 + 6 + 2 = 26 working days. When the process is highly variable, it's advisable to inform the customer of a buffer date range instead of a fixed date.

5.4. Handling interrupted orders and parameter changes

  • Assess the impact before accepting: determine which urgent orders should be postponed, which supplies need to be purchased quickly, and agree on who has the authority to approve rush orders.
  • Maintain a certain level of reserve capacity at bottleneck stages, and with parameter changes, re-examine the BOM, process, and purchased materials before acceptance.

6. Create a production plan using Excel.

6.1. When is Excel still sufficient?

Excel is flexible, familiar, and virtually free, making it sufficient for businesses with few product codes, one or two production lines, a simple Bill of Materials (BOM) with not too many levels, and only one or two people involved in planning.

6.2. Basic structure of an Excel production plan file

It's best to separate them into individual sheets, linked using product codes and order codes:

Sheet Main content Suggested formulas and tools
Order Order code, customer, product, quantity, delivery date, priority Data validation, filter by delivery date
Inventory Inventory of finished goods, semi-finished goods, and materials. XLOOKUP or VLOOKUP depending on the product code.
BOM and specifications Material composition, specifications, and losses. SUMPRODUCT calculates material requirements.
Capacity Number of machines, number of shifts, performance, maintenance schedule Machine availability varies by machine and by week.
Production plan Production order, machine, start date, end date SUMIFS adds machine hours, conditional formatting, overload warning.
Material requirements Demand, stock, orders in progress, quantity needed, order date Formula for quantity to purchase and latest order date
Monitoring the reality Actual output, completion rate, reasons for delay Weekly PivotTable

6.3. Limitations of Excel and indications for switching to a different system

If businesses experience several of the following signs simultaneously, they should consider a specialized system:

  • Multiple people editing a file often results in multiple versions or data overwriting.
  • The BOM has multiple levels, and each time the order changes, the materials need to be recalculated manually.
  • Inventory and incoming shipments are often handled manually, so they are always slower than the actual figures.
  • Only a few people understand how the file works, making handover difficult in their absence.
  • There are no automatic alerts for material shortages, order delays, or machine overload.
  • Planning, purchasing, inventory, and accounting are all working with different sets of data.

6.4. Digitizing the production planning process using ERP software

If you encounter many of the signs in section 6.3, the problem is often no longer with the planner's skills but with the tools. Enterprise Resource Planning (ERP) systems allow planning, materials, inventory, purchasing, and costs to run on the same data. For manufacturing businesses, 1C Vietnam offers two approaches depending on scale:

  • 1C:Company Management is a comprehensive mini ERP solution for manufacturing businesses, suitable for small and medium-sized enterprises (SMEs) currently managing their operations using Excel. The solution supports building cost estimates, calculating material requirements from orders and actual inventory, issuing production orders, tracking output by stage, and calculating costs. To receive consultation and a demo of 1C:Company Management, businesses can leave their information here .
  • 1C:ERP is a comprehensive resource management solution for medium and large enterprises, including corporations, suitable for those with multiple factories and workshops requiring multi-level production planning and synchronization with finance and logistics. Businesses interested in 1C:ERP can leave their information here to receive a demo.

7. Frequently Asked Questions about Production Planning

7.1. Who is responsible for production planning in the business?

Typically, the production planning department is responsible for approval, with the production manager or plant manager taking on this role; in smaller workshops, the production head may also handle this. Regardless of who creates the plan, it requires involvement from sales, purchasing, and warehousing.

7.2. How does a production plan differ from a production schedule?

Production planning answers "what to do, how much, and when" at an overall level, on a weekly or monthly basis. Production scheduling goes deeper: it involves arranging the order of orders on each machine and each shift throughout the day.

7.3. Do small businesses need to complete all 7 steps?

Yes, but at a less demanding level: you still need to confirm requirements, subtract inventory, check capacity, and calculate materials. The difference lies only in the tools and level of detail; a well-structured Excel file is usually sufficient in the initial stages.

8. Conclusion

Production planning is about translating market demand into a feasible work schedule: sufficient output, sufficient materials, sufficient capacity, and on-time delivery. The 7-step process helps you go from confirming demand to issuing orders and tracking the actual process; with production-to-order, calculate a feasible delivery date before committing to customers.

Excel remains a reasonable starting point if the file is structured and the input data is regularly reviewed. When the signs in section 6.3 appear, that's when you should consider a dedicated system. Whichever tool you choose, start by standardizing the BOM, lead times, and planning rules.

Deploy a digital transformation solution for your business today