A. Calculate the number of days of cost of goods sold held in inventory for March, April May, and June assuming quarterly cost of goods sold is used to calculate average daily cost of goods sold. I need help to answer this question. Please show me how to calculate thin in a excel spreadsheet.

DEC.	JAN.	FEB.	MAR.	APR.	MAY	JUN.
Cost of goods sold	1000	1500	2100	2700	3500	4800
Ending Inventory	300	450	630	810	1050	1440
You may assume that each month has 30 days.
A.	Calculate the number of days of cost of goods sold held in inventory for March, April
May, and June assuming quarterly cost of goods sold is used to calculate average daily cost
of goods sold.	I need help to answer this question. Please show me how to calculate thin in a excel spreadheet.