Performing Level 0 Master Production Scheduling—Key Exercises
IMPORTANT |
It is extremely important
that you set up and work within your own site to maintain your
data integrity. If you work within any other site, you will
compromise your own exercise data as well as the data of other
students. Predictable exercise results require that your data
be isolated in your own site. |
Basic Data Setup
Overview of Master Production Scheduling Data
Purpose: The purpose of this exercise is to create the required data that is
used in the master production scheduling exercises. This sets up data for your
site that only needs to be done once for master production scheduling.
If you have already set up the master production scheduling data on your
site, use that data instead.
- Set up your site for master production scheduling planning data for racing
engines.
General exercise for Master Production Scheduling
Planning Data
MS Sets 2 through 6
Purpose: The purpose of this exercise is to verify that MS sets
2 through 6 are available for use with Sales and Operations forecast planning of these exercises.
Windows:
MS Basic Data
- Open the MS Basic Data window and click
the
Master Schedule Set tab.
- Populate the window.
- Verify that the following MS sets exist:
MS Set
|
MS Set Description |
0 |
Base plan |
1 |
Planning table for MRP and CRP |
2 |
Sales and operations plan |
3 |
Aggregated demand |
4 |
Proposed total forecast |
5 |
Eastern region forecast |
6 |
Western region forecast |
General exercise for MS Sets
Main Exercises
Note: In order for your MPS results to match the predicted results,
these exercises and the level 1 exercises, if used, must be performed on the same
day.
Purpose: The purpose of this exercise is to enter Level 0 part
records.
Windows:
MS Level 0 Part
- Open the MS Level 0 Part window.
- Create a new MS level 0 part.
- Select the 24-000 Engine Family planning part from the List of Values at
your site.
- Verify that the family type is set to Make to
Stock (default).
- In the Demand field, enter 1.
- In the Planning field, enter 2.
- Verify that the roll flag is set to Rolled up
(default).
- Save your changes.
Purpose: The purpose of this exercise is to create family set data on
your site for use with sales and operations monetary forecast planning.
Windows:
MS Basic Data
/Family Set Data
- Open the MS Basic Data window and click
the
Family Set Data tab.
- Add the following family set data:
Site |
Part No |
MS Set |
Avg Sales Price |
Avg Cost |
Beginning On-Hand |
Your Site |
24-000 |
0 |
8000 |
6500 |
0 |
- Save the changes.
General exercise for Family Set Data
Purpose: The purpose of this exercise is to familiarize you with
entering and maintaining multiple forecasts.
Windows:
MS Level 0 Part
/Register Forecast
- Open the MS Level 0 Part window and click the
Register
Forecast tab.
- Query for part 24-000 at your site.
- Create a new record.
- In the MS Set field, select 5 Eastern Region Forecast from
the List of Values.
- Save the changes.
- Create a new forecast in the table, using the following values, and
entering the actual date used:
Forecast Date |
Actual Date Used |
Forecast |
Today + 2 workdays |
|
25 pieces |
Today + 4 workdays |
|
25 pieces |
Today + 6 workdays |
|
25 pieces |
Today + 8 workdays |
|
25 pieces |
Today + 10 workdays |
|
50 pieces |
- Save the changes.
- Refresh MS set 5 and verify that the total forecast is 150.
- Create a new record.
- In the MS Set field, select 6 Western Region Forecast
from the List of Values.
- Save the changes.
- Create a new forecast in the table, using the following values and actual date used:
Forecast Date |
Actual Date Used |
Forecast Quantity |
Today + 2 workdays |
|
25 pieces |
Today + 4 workdays |
|
25 pieces |
Today + 6 workdays |
|
25 pieces |
Today + 8 workdays |
|
25 pieces |
Today + 10 workdays |
|
50 pieces |
-
Save the changes.
-
Refresh MS set 6 and verify that the total forecast is 150.
Purpose: The purpose of this exercise it to combine two MS sets into one MS set.
Windows:
MS Level 0 Forecast Sets
- Open the MS Level 0 Forecast Sets window.
- Populate the window.
- Select the rows containing MS sets 5 Eastern Region Forecast and
6 Western Region Forecast. Right-click and then click Add Forecast.
- Enter your site, part 24-000, MS set 4, and accept
today's date.
- Click OK.
- Refresh part 24-000 and verify that MS set 4 displays the total forecast for MS sets
5 and 6.
- Select the MS set 5 Eastern
Region Forecast record. Change the first forecast quantity (period 1) to
20.
- Save the changes.
- Refresh MS set 5 and verify that the total forecast is 145.
- In the MS Level 0 Forecast Sets window, select the row containing MS set
4. Right-click and then click Reset Forecast.
- Enter your site and part 24-000, accept today's date, and then click OK.
- Refresh part 24-000 and verify that MS set 4 is reset to 0.
- Select the rows containing MS sets 5 Eastern Region Forecast and
6 Western Region Forecast. Right-click and then click Add Forecast.
-
Enter your site, part 24-000, MS set 4, and accept today's
date.
- Click OK.
- Refresh part 24-000.
- Verify that MS set 4 displays the total forecasts from
MS sets 5 and 6, period 1 has been changed to 45, and the total forecast is
295.
Purpose: The purpose of this exercise is to copy an MS set to another MS set.
Windows:
MS Level 0 Forecast Sets
- Open the MS Level 0 Forecast Sets window.
- Populate the window.
- Select the row containing MS set 4. Right-click and then click Copy Forecast.
- Enter your site, part 24-000, and MS set 0.
- Click OK.
- Select the row containing MS set 4. Right-click and then click Copy Forecast.
- Enter your site, part 24-000, and MS set 1.
- Click OK.
- At the warning prompt, click Yes.
- Refresh part 24-000.
- Verify that MS set 0 and MS set 1 forecast values are the same as those for MS set 4.
Purpose: The purpose of this exercise is to disaggregate a level 0
forecast family plans (MS set 1) into level 1 parts (MS set 1) and then to review the results.
Windows:
Disaggregate Level 0 to Level 1
Background Jobs
MS Level 1 Part
MS Level 1 Part
/Action Proposals
- Open the Disaggregate Family Plan window.
- Enter your site and part 24-000.
- In the Source Family Plan MS Set field, enter 1.
- In the Target Family Plan MS Set field, enter 1.
- Click OK.
- Populate the
Background Jobs window.
- Verify that the state for the Level 0 Family Plan Disaggregation background job
is Ready.
- Open the
MS Level
0 Part window.
- Query for part 24-000.
- Click the
Action Proposals tab.
- Verify that the following message appears in the Action Proposals column:
"MS plan is
within the planned time frame".