Using Excel, apply the concept from supply chain finance model and calculate the profit margin; ROA; inventory turns; and transportation, warehousing, and inventory costs as a percentage of revenue. $(30$ points$)$

Given that: Sales $=$$$200,000,000$; Transportation cost $=$$$12,000,000$; Warehousing cost $=$ $$3,000,000$; Inventory carrying cost $(W)=30\%$; Cost of goods sold $=$$$90,000,000$; Other operating costs $=$$$50,000,000$; Average inventory $($IN$)=$$$10,000,000($we use average inventory as Inventory in the table below$)$; Accounts receivable $=$$$30,000,000$; Cash $=$$$15,000,000$; Net fixed assets $=$$$90,000,000($We use net fixed assets as Fixed assets in the table below$)$; Interest $=$$$10,000,000$; Taxes $=40\%$ of $($EBIT $-$ Interest

Please use excel