Overview of Project Master Scheduling Data—Exercises
Basic Data Setup
Purpose: The purpose of this exercise is to copy the
necessary basic data to your site.
Prerequisites: The following data
should be available in the RACE database. The data is connected to company 10
and site 1.
| Data Type |
Value |
Description |
| Department |
10 |
Gather/Disburse |
| 30 |
Assembly |
| 80 |
Quality Assurance |
| 100 |
Picking |
| Work Centers |
300 |
General Assembly |
| 810 |
Test |
| Labor Class |
1 |
General 1 |
| 3 |
Skilled 1 |
| 6 |
QA Specialist |
| Import Inventory Part Information |
270 |
Commodity Group 2 |
| Product Structures |
20-100 |
Engine 1600 |
| 20-120 |
Cylinder Head 1600 |
| Routings |
20-100 |
Engine 1600 |
| 20-120 |
Cylinder Head 1600 |
Windows:
Inventory Basic Data
/Planners
Procurement Basic Data
/Buyers
Manufacturing Standard Basic Data
/Work Center Department
Manufacturing Labor Class
Work Center
Inventory Locations
- Open the
Planners tab and add your
user ID as a planner.
- Open the
Buyers
tab and add your user ID as a buyer.
-
Open the
Work Center Department tab and
copy the departments above to your site.
- Open the
Manufacturing Labor Class
window and copy the labor classes above to your site.
- Open the
Work Center window and copy
the work centers above to your site.
- Open the
Inventory Locations
window and copy some inventory locations from site 1 to your site.
General exercise for planner
General
exercise for buyer
General exercise for work center and labor class
General exercise for inventory location
Purpose: The purpose of this exercise is to
set up inventory parts, product structures and routings in your site.
Windows:
Copy Parts to Site
Product Structure
Routing
- Open the
Copy Parts to Site window and
copy all inventory parts with commodity code 270 from site 1 to your site.
-
Update the inventory part planning information for all
8 imported parts.
- Open the
Product
Structure window and query for the product structures (20-100 and
20-120).
- Copy the structures to your site.
-
Open the Routing window and query for
the routings (20-100 and 20-120).
- Copy the
routings to your site.
General exercise for
copying parts to site
General exercise for product structure
General
exercise for routing
Purpose: The purpose of this
exercise is to set up the planning data and cost for the inventory parts on your
site for using the functionality using the Racing engine data for project master
scheduling.
Windows:
Inventory Part
/General
Inventory Part
/Acquisition
Inventory Part
/Costs
Purchase Part
Supplier for Purchase Part
| Site |
Part Number |
Part Description |
Commodity Group 2 |
Purchasing Lead Time |
Estimated Material Cost |
| Your Site |
20-100 |
Engine 1600 |
270 |
|
|
| Your Site |
20-110 |
Engine Block 1600 |
270 |
20 |
200 |
| Your Site |
20-120 |
Cylinder Head 1600 |
270 |
|
|
| Your Site |
20-121 |
Cylinder Head Cover 1600 |
270 |
20 |
60 |
| Your Site |
20-122 |
Camshaft 1600 |
270 |
1 |
60 |
| Your Site |
20-123 |
Valve 1600 |
270 |
1 |
190 |
| Your Site |
20-130 |
Electric System 1600 |
270 |
1 |
410 |
| Your Site |
20-140 |
Cooling System 1600 |
270 |
1 |
480 |
- Open the
Inventory Part window and
query for all parts on your site. A total of 8 parts are displayed.
-
Click the
Acquisition tab and set the
lead times for the purchased parts to the values shown above.
-
On the
Cost tab, set the cost to the
values shown above.
- Click the
General
tab and enter your user ID as planner for the parts.
-
Right-click and then click Purchase Part to
open the
Purchase Part window and then enter your user ID as
buyer for the purchased parts.
- In the
Purchase Part window, right-click and then click Supplier for
Part to open the
Supplier for Purchase Part window.
-
Connect your purchased parts to supplier 5001. The
purchase price can be set to the same as the costs entered in step 3.
-
Repeat steps 5-7 for each of the parts. Alternatively,
you can open the
Purchase Part and
Supplier for Purchase
Part windows, query for all the above parts and then enter the buyer
and supplier information for each.
Purpose: The purpose of this
exercise is to update the product structures so that some components are set to
be standard planned and the product structure is set to Buildable state.
Windows:
Product Structure
- Open the
Product Structure window and
query for your site and site 1.
- Verify that
the parts 20-100 and 20-120 are available in your site. If not, copy these
product structures from site 1 to your site.
-
Update the Standard Planned Item check box in
the
Product Structure/Product Structure tab as
given in the table below.
-
Right-click in the
Product Structure tab
and then click Build to move the structure alternate to
Buildable state. Do this for each part.
| Assembly Part No. |
Description |
Components |
Qty. Per Assembly |
Standard Planned |
| 20-100 |
Engine 1600 |
20-110 Engine Block 1600 |
1 |
No |
| 20-100 |
Engine 1600 |
20-120 Cylinder Head 1600 |
2 |
No |
| 20-100 |
Engine 1600 |
20-130 Electric System 1600 |
1 |
No |
| 20-100 |
Engine 1600 |
20-140 Cooling System 1600 |
1 |
Yes |
| 20-120 |
Cylinder Head 1600 |
20-121 Cylinder Head Cover 1600 |
1 |
No |
| 20-120 |
Cylinder Head 1600 |
20-122 Camshaft 1600 |
2 |
No |
| 20-120 |
Cylinder Head 1600 |
20-123 Valve 1600 |
16 |
Yes |
General exercise for
copying revisions
Purpose: The purpose of this
exercise is to make sure that the routings are copied and set to Buildable
state.
Windows:
Routing
- Open the Routing window and query for
your site and site 1.
- Verify that the parts
20-100 and 20-120 are available. If not, copy these routings from site 1 to
your site.
- Right-click in the Routings tab
and then click Build to move the routing alternate to Buildable state.
General exercise for
copying revisions
Purpose: The purpose of this
exercise is to ensure that a good value can be proposed for the time fences of
the parts when they are added as project MS parts.
Windows:
Lead Time Calculation
Background Jobs
Cumulative Lead Time Calculation
- Open the Lead Time Calculation dialog box.
- Verify that the value in the
Site field is your site.
- Leave the
Part No field blank so that all parts on your site will be calculated.
-
Click OK.
- Open
the Background Jobs window and verify that the Calculate
Manufacturing Lead Time job is ready.
- Open
the Cumulative Lead Time Calculation dialog box.
-
Verify that the value in the Site field is your
site.
- Leave the Part No field blank
so that all parts on your site will be calculated.
-
Click OK.
General exercise for
calculating manufacturing and cumulative lead time
Purpose: The purpose of this exercise is to
calculate costs for your parts in your site.
Windows:
Part Cost
- Open the Part Cost window and query
for your parts on your site.
- Select cost set
2.
- Right-click anywhere in the header, point
to Cost Calculations and then click All Levels Part Cost Calculation.
- Click OK in the
All Levels Part Cost Calculationdialog box that appears and then
click Yes for the warning message that appears.
-
Right-click anywhere in the header of the
Part
Cost window again and then click Copy Costs to Cost Set One.
-
Click OK in the
Copy Costs To Cost Set
One dialog box that appears and then click Yes for the
warning message.
General exercise for
cost calculation
Purpose: The purpose of this
exercise is to create a project with activities and a connected project PNG
including these activities. Project master scheduling will later be performed
against parts connected to this project (project PNG).
Windows:
Project
Sub Projects
Activities
Projects
- Create a new project.
-
Make sure that the value in the Material Allocation
list is set to Within Project for the project.
-
Open the Sub Projects window
and create two sub projects for your project, described as
Sub Project 1 and Sub Project 2.
-
Open the Activities window and
define an
activity under each sub project, A11 and A21, described as Acquisition and
Assembly respectively.
- In the Project /Site
tab, add your site to the
project as a default site.
- Right-click
anywhere in the header of the
Projects window and then
click Netting. Check that the View Project PNG option is enabled. This
means that a project PNG has been created automatically when you created the
project. If it is not enabled you can create the project PNG manually
by right-clicking, pointing to Netting and then clicking Create Project PNG.
-
Right-click in the header again, point to Status
and then click Approve.
- Open the
Activitieswindow
and query for the activities A11 and A12 that belong to your project.
-
Select the activities, right-click, point to Status
and then click Release.
General exercise for
creating projects
Purpose: The purpose of this
exercise is to define the parts that should be project master scheduled. Later
you will enter forecasts for these parts and use them in the project master
scheduling calculation.
Windows:
Project MS Basic Data
/Project MS Default Settings
Project MS Part
- Open the Project MS Basic Data
window and select or enter the following default settings in the
Project MS
Default Settings tab.
| List/Field |
Value |
| Active |
Part Active |
| Roll |
Rolled up |
| Gen Fixed MS |
Create Fixed MS Rcp |
| Create S/P Req |
Create S/P Req |
| Unconsumed Forecast Disposition |
Roll out |
| Forecast Consumption Window |
10 |
| Create Project MS Supply |
Yes (selected) |
- Open the Project MS Part
window. Create a new records and enter following parts as project MS
parts, using the default project MS settings. Save each record when
completed.
| Part Number |
Description |
Site |
PNG |
Demand Time Fence |
Planning Time Fence |
Default Project MS Supply Activity |
| 20-110 |
Engine Block 1600 |
Your Site |
Your Project PNG |
1 |
20 |
The project ID is retrieved from the PNG. Enter
your sub project and activity A11 (Acquisition). |
| 20-120 |
Cylinder Head 1600 |
Your Site |
Your Project PNG |
1 |
21 |
The project ID is retrieved from the PNG. Enter
your sub project and activity A11 (Acquisition). |