MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Manufacturing > Master Scheduling > Key Concepts and Procedures > Exhibit C: Tentative Schedule/Current Schedule/Projected Inventory > Assumptions

Assumptions

 

Inventory

 

=

100

Current Schedule:

 

 

 

 

Order Quantity

=

500

 

Order Receipts

=

100

Total Demand

 

=

500

Target Inventory

 

=

0

 

Example 1

1.   The tentative master schedule is calculated as the incremental order quantity required to meet demand and target inventory; in this case, 400 units:

 

Beginning Inventory


Demand

Tentative Schedule

Projected Inventory

100

500

400

0

 

2.   The current schedule is calculated as the balance due on current orders.  The tentative and current schedules are compared as follows:

 

Tentative Schedule

Current Schedule

Required Action

400

400

None

 

(500 - 100)

 

 

If, however, an additional 200 units are received before the tentative and current schedules are compared, the following results:

 

Tentative Schedule

Current Schedule

Required
Action

400

200

Increase by 200

 

(500 - 300)

 

 

Although neither demand, target inventory, nor schedule production has changed, the comparison results in a suggested increase of 200 units.  If the suggested action is implemented, the resulting inventory will be 200 units greater than the target inventory.

Example 2

1.   The tentative master schedule is calculated as the incremental quantity required to meet demand and target inventory, plus receipts against orders due in the period:

 

Beginning Inventory 


Demand

Tentative Schedule

Projected Inventory
(**see below)

100

500

500

0

 

 

(400 + 100)

 

 

2.   The current schedule is calculated as the expected yield on all orders scheduled for the period, including units already received:

 

Tentative Schedule 

Current Schedule

Required Action

500

500

None

 

The result is the same regardless of the activity that occurs between the generation and the implementation of the tentative schedule.

**Projected Inventory

Note in Example 2 that the portion of the tentative schedule that has been received has been taken into account in calculating the projected inventory.  This portion is listed as the Supply Activity quantity on the Tentative Schedule Generation Report; similarly, the Demand Activity, or that portion of demand which has been shipped to a customer or issued to a manufacturing order, is listed on the report.  Thus, the projected inventory calculation is as follows:

 

PROJECTED INVENTORY

=

BEGINNING INVENTORY

plus

(TENTATIVE SCHEDULE - SUPPLY ACTIVITY)

minus

(DEMAND - DEMAND ACTIVITY)

 

which, for the above example, is as follows:

 

Projected Inventory

=

100 + (500 - 100) - (500 - 0)

 

=

0