Question: Please use given MRP planning schedule for item J to answer the following questions: Unit Cost $8 Setup cost $45 Inventory holding cost per week

  1. Please use given MRP planning schedule for item J to answer the following questions:

    Unit Cost

    $8

    Setup cost

    $45

    Inventory holding cost per week

    2% of unit cost

    Beginning inventory

    30

    Lead time

    1 week

    Week

    0

    1

    2

    3

    4

    5

    Demand

    18

    22

    55

    46

    17

    a. Select adequate EOQ model to calculate the optimal order quantity________ (round-up the decimal to integer).

    b. Indicate the correct net requirements, planned-order receipts, and planned order releases to meet the demand in the provided table

    c. Calculate the total inventory holding cost and fixed ordering cost for these 5 weeks in the provided table (keep two decimals for the costs).

    Week:

    0

    1

    2

    3

    4

    5

    TC

    Item:

    J

    Gross requirements

    OH:

    Scheduled receipts

    LT:

    Projected available balance

    SS:

    Net requirements

    Q:

    Planned order receipts

    Planned order releases

    Inventory Holding Cost

    Fixed Ordering/Set-up Cost

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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!