Question: Please use given MRP planning schedule for item J to answer the following questions: Unit Cost $20 Setup cost $60 Inventory holding cost per week
Please use given MRP planning schedule for item J to answer the following questions:
| Unit Cost | $20 |
| Setup cost | $60 |
| Inventory holding cost per week | 1.5% of unit cost |
| Beginning inventory | 60 |
| Lead time | 1 week |
| Week | 0 | 1 | 2 | 3 | 4 | 5 |
| Demand | 45 | 38 | 60 | 80 | 25 |
- Select adequate EOQ model to calculate the optimal order quantity___ (round up to the nearest whole number).
- Indicate the correct net requirements, planned-order receipts, and planned order releases to meet the demand in the provided table.
- Calculate the total inventory holding cost and fixed ordering cost for these 5 weeks in the provided table
| Week: | 0 | 1 | 2 | 3 | 4 | 5 | TC | |||
| Item: | 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
