2. Then merge the cells where the title production progress is located and center them, and set the text to be bold and the font size to be15;
3. Then, continue to merge and align the rows where the scheduling workload is located;
4. You can merge a series of cells and enter the production serial number;
5. Finally, add all borders to the table to make it more tidy;
6. The background colors of manufacturing progress and estimated cost can also be filled with pink and orange respectively.
Make a detailed production plan:
1. Create a new production plan and enter the contents.
2. Center the cell where the title "Production Plan" is located, and set the text in bold with the number 16.
3. Merge the rows with planned job numbers and align them to the left.
4. Merge the cells to be merged and enter the production serial number.
5. Add all borders to the table.
6. Fill the background colors of manufacturing schedule and estimated cost with pink and orange respectively. Attachment: main steps of production planning 1, receiving sales orders and decomposing product BOM2 according to customer requirements. 2. Assess whether the production capacity of the production workshop can meet the customer's delivery requirements. 3. Divide the production cycle into several parts. Including A- administrative planning department planning time, B- material procurement time, C- product manufacturing time, D- installation delivery time. Among them, there are several issues that must be considered. A- whether the warehouse material inventory meets the needs of the order. If not, you need to make a production plan. B- Whether the production unit or outsourcing unit can meet the requirements of timely and quality delivery. C- whether the production process is smooth, and whether it is necessary to increase equipment or personnel or working hours to meet the production needs. 4. Break down the required delivery date into several parts, including the date when each part should be in place. We must control the production progress during the delivery period and calculate the daily or weekly output. This is the practice for a single order. There must be more than one order per month. So the practice is to repeat the above process, but be sure to adjust the production plan in combination with all orders. For example, spare parts of general products can be pre-produced according to monthly sales volume and warehouse inventory, and monthly plans and production and delivery plans can be made according to production load, and then broken down into weekly plans or even daily plans. The daily plan is equivalent to the progress ledger, and the output can be controlled to the daily target plan for monitoring. The production plan must be quantified, and it is more scientific to combine the production load and bill of materials to make the plan.
Make a detailed production plan:
1. Create a new production plan and enter the contents.
2. Center the cell where the title "Production Plan" is located, and set the text in bold with the number 16.
3. Merge the rows with planned job numbers and align them to the left.
4. Merge the cells to be merged and enter the production serial number.
5. Add all borders to the table.
6. Fill the background colors of manufacturing schedule and estimated cost with pink and orange respectively. Attachment: main steps of production planning 1, receiving sales orders and decomposing product BOM2 according to customer requirements. 2. Assess whether the production capacity of the production workshop can meet the customer's delivery requirements. 3. Divide the production cycle into several parts. Including A- administrative planning department planning time, B- material procurement time, C- product manufacturing time, D- installation delivery time. Among them, there are several issues that must be considered. A- whether the warehouse material inventory meets the needs of the order. If not, you need to make a production plan. B- Whether the production unit or outsourcing unit can meet the requirements of timely and quality delivery. C- whether the production process is smooth, and whether it is necessary to increase equipment or personnel or working hours to meet the production needs. 4. Break down the required delivery date into several parts, including the date when each part should be in place. We must control the production progress during the delivery period and calculate the daily or weekly output. This is the practice for a single order. There must be more than one order per month. So the practice is to repeat the above process, but be sure to adjust the production plan in combination with all orders. For example, spare parts of general products can be pre-produced according to monthly sales volume and warehouse inventory, and monthly plans and production and delivery plans can be made according to production load, and then broken down into weekly plans or even daily plans. The daily plan is equivalent to the progress ledger, and the output can be controlled to the daily target plan for monitoring. The production plan must be quantified, and it is more scientific to combine the production load and bill of materials to make the plan.