MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Manufacturing > Master Scheduling > Key Concepts and Procedures > Exhibit A: Calculating the Master Schedule

Exhibit A: Calculating the Master Schedule

 

This example illustrates how the system calculates the master schedule quantities by attempting to satisfy demand and match target inventory levels for each period while smoothing the weekly master schedule quantities.  The example pertains to standard master scheduled parts only.

EXAMPLE:

Assumptions:

Part Q has safety stock of 1000 and a target inventory of two weeks.

Period 1 has 4 weeks.  The beginning inventory level of Part Q in Period 1 is 400.

The initial demand looks like this:

 


Period


Week

Total Demand

Beginning Inventory

Target Inventory

 

 

 

400

 

1

1

500

 

 

 

2

1000

 

 

 

3

1500

 

 

 

4

1000

 

 

2

5

2000

 

 

 

6

1000

 

 

 

7

 

 

 

 

1.   Two accumulations are made.  First, the demand for period 1 is summed:

500 + 1000 + 1500 + 1000 = 4000

This calculation is performed for each week in the period, and then for further weeks to cover any target inventory weeks requirement.  In the example, the target inventory is for two weeks, so the demand for the first two weeks in the next period is calculated:

Target Inventory = 2000 + 1000 = 3000

The safety stock quantity must be added to this figure:

Target Inventory = 3000 + 1000 = 4000

Thus:

 


Period


Week

Total Demand

Beginning Inventory

Target Inventory

 

 

 

400

 

1

1

500

 

 

 

2

1000

 

 

 

3

1500

 

 

 

4

1000

 

4000

2

5

2000

 

 

 

6

1000

 

 

 

7

 

 

 

 

2.   Second, the requirement for the period must be calculated:

 

REQUIREMENT

=

PERIOD DEMAND

plus

TARGET INVENTORY

minus

BEGINNING INVENTORY

 

=

4000 + 4000 - 400

 

 

 

 

 

=

7600

 

 

 

 

 

3.   This requirement is then evenly allocated over the weeks in the period, giving the master schedule quantity for each week:

 

MASTER SCHEDULE QUANTITY PER WEEK

=

REQUIREMENT

divided by

NO. OF WEEKS

 

=

7600 / 4

 

 

 

=

1900

 

 

 

 


Period


Week

Total Demand


MS Quantity

Projected Inventory

Target Inventory

 

 

 

 

400

 

1

1

500

1900

 

 

 

2

1000

1900

 

 

 

3

1500

1900

 

 

 

4

1000

1900

 

4000

2

5

2000

 

 

 

 

6

1000

 

 

 

 

7

 

 

 

 

 

4.   The Projected Inventory for week 1 is then calculated.  This is basically the beginning inventory plus any supply activity minus any demand activity for the week.

 

PROJECTED INVENTORY

=

BEGINNING INVENTORY

plus

SUPPLY

minus

DEMAND

for week 1

=

400 + 1900 - 500

 

 

 

 

 

=

1800 (beginning inventory for week 2)

 

 

 

 

 

 


Period


Week

Total Demand


MS Quantity

Projected Inventory

Target Inventory

 

 

 

 

400

 

1

1

 500

1900

1800

 

 

2

1000

1900

 

 

 

3

1500

1900

 

 

 

4

1000

1900

 

4000

2

5

2000

 

 

 

 

6

1000

 

 

 

 

7

 

 

 

 

 

Since, in this example, the projected inventory for week 1 is positive, no further processing is needed and 1900 will be used as that week's master schedule quantity.  However, if the projected inventory quantity is negative, the master schedule quantity is increased.

5.   The remaining weeks are calculated similarly, resulting in the following:

 


Period


Week

Total Demand


MS Quantity

Projected Inventory

Target Inventory

 

 

 

 

400

 

1

1

500

1900

1800

 

 

2

1000

1900

2700

 

 

3

1500

1900

3100

 

 

4

1000

1900

4000

4000

2

5

2000

 

 

 

 

6

1000

 

 

 

 

7

 

 

 

 

 

The processing has therefore produced an even master schedule over the period, with enough stock remaining in the final week of the period to cover the target requirement.