Production Schedule

Module Guide: Production Schedule

Module Location

Production > Production Planning > Production Schedule

Module Objective

The Production Schedule module serves as the center for creating and managing the Master Production Schedule (MPS). Its purpose is to input the production plan—which product will be made, on which machine, how many, and when—into the system. This schedule becomes the basis for all subsequent production planning and execution activities.

1. Main View (Production Schedule List)

The main page of this module displays a list of all production schedule documents that have been uploaded or created.

View Explanation

• View: This page is a history of all existing production schedules. You can see the Doc. Number, the scheduled Machine, the Start Period, and the Document Status (whether it has been approved or not).

• Action Buttons:

  • [New] or [Manual Input]: The primary button to create a new production schedule. In many cases, this will lead to a page for uploading the schedule.

2. Steps to Create a Production Schedule (via Upload)

The most efficient way to create a schedule is by uploading an Excel file.

Step 1: Open the Upload Page

From the Main View, click the [New] button or similar to open the Upload Production Schedule page.

Step 2: Download and Fill in the Template

1. On the upload page, click the Download Excel Format link to download the standard template.

2. Open the Excel file and fill it in with your production plan, which usually includes columns like Product Code, Quantity, Machine, and Production Date.

Step 3: Upload the Schedule

1. Return to the upload page, click the [Choose File] button and select the Excel file you have filled in.

2. Click the [Import] button to upload the plan into the system.

Workflow & Integrated Business Process

• A Production Schedule that has been uploaded and approved becomes the master plan for the production department.

• This schedule will become the basis for:

  • Running MRP (Material Requirements Planning) to calculate raw material needs.

  • Creating Production Orders to be executed on the production floor.

Tips & Important Notes

• The upload-from-Excel feature greatly speeds up the schedule creation process, especially for weekly or monthly planning that involves many products.

• Ensure the data in the Excel file is accurate to avoid errors in material and production planning.

• This is the main and most fundamental work module for the PPIC (Production Planning and Inventory Control) team.