Question: Using the Master Production Schedule grid below, calculate the Projected Available Balance for each Quarter and determine what quarter(s) require a Master Production Schedule

Using the Master Production Schedule grid below, calculate the Projected Available Balance for each Quarter  

Using the Master Production Schedule grid below, calculate the Projected Available Balance for each Quarter and determine what quarter(s) require a Master Production Schedule receipt. + Beginning Inventory = 30 units Production Quantity/Lost Size = 80 units Forecast Projected Available Balance Master Production Schedule Forecast Actual Customer Orders Projected Available Balance Available to Promise Master Production Schedule 6. Available to Promise Calculations a. Utilizing the grid below, calculate the Projected Available Balance for each period and the Available to Promise using the Discrete Method. Beginning inventory = 45 units Production Quantity/Lot Size = 50 units Quarter 1 20 Forecast Actual Customer Orders Projected Available Balance Available to Promise Master Production Schedule 1 20 13 2 20 8 1 20 13 Quarter 2 70 2 20 8 3 20 20 4 30 3 20 20 Quarter 3 70 b. Utilizing the grid below, calculate the Projected Available Balance for each period and the Available to Promise using the Cumulative Method. Beginning inventory = 45 units Production Quantity/Lot Size = 50 units 4 30 5 30 6 30 5 30 Quarter 4 20 6 30 7 30 8 30 7 30 8 30

Step by Step Solution

3.34 Rating (148 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

For the first scenario Discrete Method Quarter 1 Beginning Inventory 30 units Production Quantity 80 units Forecast 20 units Projected Available Balance Beginning Inventory Production Quantity Forecas... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!