Type or paste question here

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

1. Select adequate EOQ model to calculate the optimal order quantity___ (round up to the nearest whole number).
2. Indicate the correct net requirements, planned-order receipts, and planned order releases to meet the demand in the provided table.
3. 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