Please answer question #$3$ below in Excel format. Kindly provide$/$show all your work on how you got the answer. Thank you. Much appreciated.

Question $3$

An electronics store reported a COGS of $$12,000,000$ and an average inventory of $$3,000,000$ for

the past year.

a$)$ Calculate the inventory turnover ratio for the electronics store.

b$)$ If the industry standard for inventory turnover in electronics is $5$ times per year, analyze whether

the store's inventory turnover is efficient and discuss potential improvements.

c$)$ Provide recommendations based on the $4$ foundational elements of supply chain management.