Final answer:
To calculate the available stock using consumption-based planning as the MRP type, subtract the net requirements and safety stock from the sum of inventory on hand and scheduled receipts. In this case, the available stock is 80.
Step-by-step explanation:
To calculate the available stock using consumption-based planning as the MRP type, we need to consider the Inventory On Hand, Scheduled Receipts, Net Requirements, and Safety Stock.
Available Stock = Inventory On Hand + Scheduled Receipts - Net Requirements - Safety Stock
Given:
Inventory On Hand = 100
Scheduled Receipts = 20
Net Requirements = 10
Safety Stock = 30
Substituting the values into the formula:
Available Stock = 100 + 20 - 10 - 30
Available Stock = 80
The available stock is 80.