Share
Explore BrainMass

Resource Planning

(See attached file for full problem description)

1. Consider the MPS, BOM, and inventory data shown below (15 pts).

Master Production Schedule: the following table shows the MPS start quantities.

Item: A Lot Size: LFL
Lead Time: 1 Week
Safety Stock: 5
Time Period (Weeks)
1 2 3 4 5 6 7 8 9 10
Gross Requirements 10 20 0 40 30 0 20 0 40 0
Scheduled Receipts
On-Hand Inventory 15
Planned Receipts
Planned Order Releases 20 40 30 20 40

Bill of Material:
-Item A uses 2 each of component D, 1 each of component C and 2 each of subassembly B.
-Subassembly B uses 2 each of component E.

Selected Inventory Data:

Item Lot Size Technique Lead Time (weeks) Scheduled Receipts Safety Stock On-Hand
B L4L 1 40 in period 1
C POQ=3 2 10 40
D FOQ=250 1 50 100
E L4L 2 160 in period 2 20 20
Based on the information from the previous page, complete the following inventory records:

Item: B Lot Size:
Lead Time:
Safety Stock:
Time Period (Weeks)
1 2 3 4 5 6 7 8 9 10
Gross Requirements
Scheduled Receipts
On-Hand Inventory
Planned Receipts
Planned Order Releases

Item: C Lot Size:
Lead Time:
Safety Stock:
Time Period (Weeks)
1 2 3 4 5 6 7 8 9 10
Gross Requirements
Scheduled Receipts
On-Hand Inventory
Planned Receipts
Planned Order Releases

Item: D Lot Size:
Lead Time:
Safety Stock:
Time Period (Weeks)
1 2 3 4 5 6 7 8 9 10
Gross Requirements
Scheduled Receipts
On-Hand Inventory
Planned Receipts
Planned Order Releases

Item: E Lot Size:
Lead Time:
Safety Stock:
Time Period (Weeks)
1 2 3 4 5 6 7 8 9 10
Gross Requirements
Scheduled Receipts
On-Hand Inventory
Planned Receipts
Planned Order Releases

Attachments

Solution Preview

Please see the attached file.

1. Consider the MPS, BOM, and inventory data shown below (15 pts).

Master Production Schedule: the following table shows the MPS start quantities.

Item: A Lot Size: LFL
Lead Time: 1 Week
Safety Stock: 5
Time Period (Weeks)
1 2 3 4 5 6 7 8 9 10
Gross Requirements 10 20 0 40 30 0 20 0 40 0
Scheduled Receipts
On-Hand Inventory 15
Planned Receipts
Planned Order Releases 20 40 30 20 40

Bill of Material:
-Item A uses 2 each of component D, 1 each of component C and 2 each of subassembly B.
-Subassembly B uses 2 each of component E.

Selected Inventory Data:

Item Lot Size Technique Lead Time (weeks) Scheduled Receipts Safety Stock On-Hand
B L4L 1 40 in ...

Solution Summary

Word document contains Master Production Schedule (MPS). Resource planning functions are analyzed.

$2.19