Explore BrainMass

Explore BrainMass

    Resource Planning

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    (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

    © BrainMass Inc. brainmass.com June 3, 2020, 6:57 pm ad1c9bdddf
    https://brainmass.com/business/human-resources-management/resource-planning-81158

    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

    ADVERTISEMENT