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
Get step-by-step solutions from verified subject matter experts
