Scribd Logo
Upload

Welcome to Scribd!

  • 59 views

    Solution 2223PrdMgmt - HW4

    Uploaded by

    Hoang Thao Nhi
    This document contains production planning information for multiple items across several periods. It includes details like gross requirements, scheduled receipts, projected on hand inventory, net requirements, and planned order receipts and releases for each item in each period. The document is organized with an item header followed by the corresponding data for multiple periods. It appears to be a production plan or schedule for the listed items over the given time horizon.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Solution 2223PrdMgmt - HW4

    Uploaded by

    Hoang Thao Nhi
    59 views16 pages
    This document contains production planning information for multiple items across several periods. It includes details like gross requirements, scheduled receipts, projected on hand inventory, net requirements, and planned order receipts and releases for each item in each period. The document is organized with an item header followed by the corresponding data for multiple periods. It appears to be a production plan or schedule for the listed items over the given time horizon.

    Original Title

    Solution 2223PrdMgmt_HW4

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains production planning information for multiple items across several periods. It includes details like gross requirements, scheduled receipts, projected on hand inventory, net requirements, and planned order receipts and releases for each item in each period. The document is organized with an item header followed by the corresponding data for multiple periods. It appears to be a production plan or schedule for the listed items over the given time horizon.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    59 views16 pages

    Solution 2223PrdMgmt - HW4

    Uploaded by

    Hoang Thao Nhi
    This document contains production planning information for multiple items across several periods. It includes details like gross requirements, scheduled receipts, projected on hand inventory, net requirements, and planned order receipts and releases for each item in each period. The document is organized with an item header followed by the corresponding data for multiple periods. It appears to be a production plan or schedule for the listed items over the given time horizon.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 16

    Item: A LLC: 0 PERIOD

    Lot size: L4L LT: 1 1 2 3 4 5 6 7


    Gross Requirements 50 250 150
    Scheduled Receipts
    Projected on Hand 0 0 0 0
    Net Requirements 50 250 150
    Planned Order Receipts 50 250 150
    Planned Order Releases 50 250 150

    Item: B LLC: 1 PERIOD


    Lot size: L4L LT: 2 1 2 3 4 5 6 7
    Gross Requirements 100 500 300
    Scheduled Receipts 100
    Projected on Hand 0 0 0 0
    Net Requirements 0 500 300
    Planned Order Receipts 500 300
    Planned Order Releases 500 300

    Item: C LLC: 1 PERIOD


    Lot size: 800 LT: 1 1 2 3 4 5 6 7
    Gross Requirements 1050 850 150
    Scheduled Receipts 300
    Projected on Hand 120 120 170 170 120 120 770
    Net Requirements 630 680 30
    Planned Order Receipts 800 800 800
    Planned Order Releases 800 800 800

    Item: D LLC: 2 PERIOD


    Lot size: L4L LT: 1 1 2 3 4 5 6 7
    Gross Requirements 500 300
    Scheduled Receipts
    Projected on Hand 50 50 0 0 0
    Net Requirements 450 300
    Planned Order Receipts 450 300
    Planned Order Releases 450 300

    Planned order report PERIOD


    Item 1 2 3 4 5 6 7
    A 50 250 150
    B 500 300
    C 800 800 800
    D 450 300
    Item: A LLC: 0 PERIOD
    Lot size: L4L LT: 1 1 2 3 4 5 6 7 8
    Gross Requirements 200 300
    Scheduled Receipts
    Projected on Hand 0 0 0
    Net Requirements 200 300
    Planned Order Receipts 200 300
    Planned Order Releases 200 300

    Item: B LLC: 1 PERIOD


    Lot size: L4L LT: 2 1 2 3 4 5 6 7 8
    Gross Requirements 200 300
    Scheduled Receipts
    Projected on Hand 0 0 0
    Net Requirements 200 300
    Planned Order Receipts 200 300
    Planned Order Releases 200 300

    Item: C LLC: 1 PERIOD


    Lot size: L4L LT: 3 1 2 3 4 5 6 7 8
    Gross Requirements 200 300
    Scheduled Receipts
    Projected on Hand 0 0 0
    Net Requirements 200 300
    Planned Order Receipts 200 300
    Planned Order Releases 200 300

    Item: E LLC: 1 PERIOD


    Lot size: 900 LT: 2 1 2 3 4 5 6 7 8
    Gross Requirements 400 800 600 1200
    Scheduled Receipts
    Projected on Hand 500 500 100 100 200 500 500 200 200
    Net Requirements 0 700 400 700
    Planned Order Receipts 900 900 900
    Planned Order Releases 900 900 900

    Item: D LLC: 2 PERIOD


    Lot size: 500 LT: 1 1 2 3 4 5 6 7 8
    Gross Requirements 600 900
    Scheduled Receipts 500
    Projected on Hand 200 200 100 100 600 200 200 200 200
    Net Requirements 0 300
    Planned Order Receipts 500 500
    Planned Order Releases 500 500

    Planned order report PERIOD


    Item 1 2 3 4 5 6 7 8
    A 200 300
    B 200 300
    C 200 300
    D 500 500
    E 900 900 900
    Item: A LLC: 0 PERIOD
    Lot size: L4L LT: 2 1 2 3 4 5 6 7 8
    Gross Requirements 95 150 130
    Scheduled Receipts
    Projected on Hand 0 0 0 0
    Net Requirements 95 150 130
    Planned Order Receipts 95 150 130
    Planned Order Releases 95 150 130

    Item: B LLC: 0 PERIOD


    Lot size: L4L LT: 1 1 2 3 4 5 6 7 8
    Gross Requirements 80 70
    Scheduled Receipts
    Projected on Hand 0 0 0
    Net Requirements 80 70
    Planned Order Receipts 80 70
    Planned Order Releases 80 70

    Item: E LLC: 1 PERIOD


    Lot size: L4L LT: 3 1 2 3 4 5 6 7 8
    Gross Requirements 190 300 260
    Scheduled Receipts 200
    Projected on Hand 85 85 95 95 0 0 0
    Net Requirements 0 205 260
    Planned Order Receipts 205 260
    Planned Order Releases 205 260

    Item: C LLC: 1 PERIOD


    Lot size: 250 LT: 2 1 2 3 4 5 6 7 8
    Gross Requirements 205 270 260 300 70 260
    Scheduled Receipts
    Projected on Hand 625 420 150 140 90 20 10
    Net Requirements 0 0 110 160 0 240
    Planned Order Receipts 250 250 250
    Planned Order Releases 250 250 250

    Item: D LLC: 1 PERIOD


    Lot size: 800 LT: 1 1 2 3 4 5 6 7 8
    Gross Requirements 250 600 550 140 260
    Scheduled Receipts
    Projected on Hand 350 100 300 300 550 410 150 150 150
    Net Requirements 0 500 0 250 0 0
    Planned Order Receipts 800 800
    Planned Order Releases 800 800
    Item: A LLC: 0 PERIOD
    Lot size: L4L LT: 4 1 2 3 4 5 6 7 8
    Gross Requirements 103
    Projected on Hand 18 8 8 8 8 8 8 8 5
    Net Requirements 100
    Planned Order Receipts 100
    Planned Order Releases 100

    Item: Q LLC: 0 PERIOD


    Lot size: L4L LT: 2 1 2 3 4 5 6 7 8
    Gross Requirements 200
    Projected on Hand 6 6 6 6 6 6 6 6 6
    Net Requirements 200
    Planned Order Receipts 200
    Planned Order Releases 200

    Item: B LLC: 1 PERIOD


    Lot size: L4L LT: 3 1 2 3 4 5 6 7 8
    Gross Requirements 100
    Projected on Hand 10 10 10 10 0
    Net Requirements 90
    Planned Order Receipts 90
    Planned Order Releases 90

    Item: C LLC: 1 PERIOD


    Lot size: L4L LT: 2 1 2 3 4 5 6 7 8
    Gross Requirements 200 200
    Projected on Hand 20 20 20 20 0 0
    Net Requirements 180 200
    Planned Order Receipts 180 200
    Planned Order Releases 180 200
    Item: E LLC: 1 PERIOD
    Lot size: 500 LT: 1 1 2 3 4 5 6 7 8
    Gross Requirements 360 400 200
    Projected on Hand 30 30 170 270 270 70 70 70 70
    Net Requirements 330 230 0
    Planned Order Receipts 500 500
    Planned Order Releases 500 500

    Item: D LLC: 2 PERIOD


    Lot size: 200 LT: 1 1 2 3 4 5 6 7 8
    Gross Requirements 180 200
    Projected on Hand 0 20 20 20 20 20 20 20
    Net Requirements 180 180
    Planned Order Receipts 200 200
    Planned Order Releases 200 200
    Item: A LLC: 0 PERIOD
    Lot size: L4L LT: 3 1 2 3 4 5 6 7 8
    Gross Requirements 100
    Scheduled Receipts
    Projected on Hand 10 10 10 10 10 10 10 10 0
    Net Requirements 90
    Planned Order Receipts 90
    Planned Order Releases 90

    Item: B LLC: 0 PERIOD


    Lot size: L4L LT: 2 1 2 3 4 5 6 7 8
    Gross Requirements 200
    Scheduled Receipts
    Projected on Hand 5 5 5 5 5 5 0
    Net Requirements 195
    Planned Order Receipts 195
    Planned Order Releases 195

    Item: C LLC: 1 PERIOD


    Lot size: Mini 50 LT: 4 1 2 3 4 5 6 7 8
    Gross Requirements 270
    Scheduled Receipts
    Projected on Hand 140 140 140 140 140 0
    Net Requirements 130
    Planned Order Receipts 130
    Planned Order Releases 130

    Item: D LLC: 1 PERIOD


    Lot size: Mult 250 LT: 2 1 2 3 4 5 6 7 8
    Gross Requirements 585 180
    Scheduled Receipts 250
    Projected on Hand 200 200 450 450 115 185 185 185 185
    Net Requirements 135 65
    Planned Order Receipts 250 250
    Planned Order Releases 250 250

    Planned order report PERIOD


    Item 1 2 3 4 5 6 7 8
    A 90
    B 195
    C 130
    D 250 250
    Lead time = 1 period
    Holding cost = $1 per cabinet per period
    Ordering cost = $100 per order
    Beginning inventory = 25
    ḋ 29
    EOQ 77
    POQ 3

    Item: A LLC: 0 PERIOD


    Lot size: L4L LT: 1 1 2 3 4 5
    Gross Requirements 20 40 30 10 45
    Projected on Hand 25 5 0 0 0 0 Total cost $ 405
    Net Requirements 0 35 30 10 45
    Planned Order Receipts 35 30 10 45
    Planned Order Releases 35 30 10 45

    Item: A LLC: 0 PERIOD


    Lot size: EOQ 77 LT: 1 1 2 3 4 5
    Gross Requirements 20 40 30 10 45
    Projected on Hand 25 5 42 12 2 34 Total cost $ 295
    Net Requirements 0 35 0 0 43
    Planned Order Receipts 77 77
    Planned Order Releases 77 77

    Item: A LLC: 0 PERIOD


    Lot size: POQ 3 LT: 1 1 2 3 4 5
    Gross Requirements 20 40 30 10 45
    Projected on Hand 25 5 40 10 0 0 Total cost $ 255
    Net Requirements 0 35 0 0 45
    Planned Order Receipts 75 45 RECOMMEND POQ
    Planned Order Releases 75 45

    You might also like