Thank you in advance for your help; could you please provide an excel spreadsheet solution too, to help in my understanding?

?

7. Everdeen, Inc., has a 150-day operating cycle. If its average age of inventory is 35 days, how long is its average collection period? If its average payment period is 23 days, what is its cash conversion cycle? Everdeen's average collection period, ACP, is 115 days. (Round to the nearest whole number.) Everdeen's cash conversion cycle, CCC, is 127 days. (Round to the nearest whole number.)