I NEED ASAP. CLEAR EXPLANATION. ONLY EXCEL SOLUTION NEEDED.

The MRP gross requirements for Item A are shown here for the next 10 weeks. Lead time for A is three weeks and setup cost is $9. There is a carrying cost of $0.010 per unit per week. Beginning inventory is 75 units.

	WEEK
	1	2	3	4	5	6	7	8	9	10
Gross requirements	30	35	10	25	75	85	20	65	220	55

Use the least total cost and the least unit cost lot-sizing method to determine what quantity the first order should be released and for which period.

	Quantity Ordered	Period
Least total cost		(Click to select) 4 to 6, 4 to 7, 4 to 8, 4 to 9, 4 to 10, 9, 4, 4 to 5, 9 to 10
Least unit cost		(Click to select)9 to 10, 4 to 7, 4 to 6, 4, 4 to 8, 4 to 5, 9, 4 to 9, 4 to 10