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

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!