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$)$; Current liabilities $=$$$65,000,000$; Long$-$term liabilities $=$$$35,000,000$; Stockholder's equity $=$$$45,000,000$

$\backslash$table$[[,$Symbol,Value,Rate$],[$Sales$,S,200,000,000,],[$Cost of goods sold,CGS$,90,000,000,],[$Gross Margin,$GM=S-CGS,110,000,000,],[$Transportation Cost,$TC,12,000,000,],[$Warehousing Cost,WC$,3,000,000,],[$Inventory Carrying Cost,$IC=INW,,30\%$