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.
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.
Whether created on paper, in Excel, or using software, a viable business plan must answer five questions:
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.
"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
A plan is only accurate when the input data is accurate. A planner needs to have:
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.
The process below is applicable to most factories. The examples use hypothetical data; please replace it with data from your business.
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.
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.
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):
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.
The calculation proceeds from finished goods down to semi-finished goods and then to raw materials (breaking the BOM):
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.
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.
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.
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.
| 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.
The process still follows the 7-step framework in section 4, but each order is treated as a small project:
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.
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.
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 |
If businesses experience several of the following signs simultaneously, they should consider a specialized system:
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:
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.
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.
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.
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.