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
