Sales Transportation Cost Warehousing Cost Inventory Carrying cost Cost of Goods Sold Other operating costs Average Inventory Accounts Receivable Cash Next fixed assets Interest Taxes Current Liabilities Long-Term liabilities Stockholders equity Simbol S TC WC W CGS OOC IN AR CA FA INT 200,000,000 12,000,000 3,000,000 30% 90,000,000 50,000,000 10,000,000 30,000,000 15,000,000 90,000,000 10,000,000 40% 65,000,000 35,000,000 45,000,000 Symbol Sales Cost of Goods Sold S CGS Gross Margin GM=S-CGS Transportation TC Warehousing WC Inventory Carrying IC=INW Other Operating Cost OOC Total Operating Cost TOC Earnings before interest and taxes EBIT Interest INT Taxes TX Net Income NI Asset Deployment Inventory Accounts Receivable IN AR Cash CA Fixed Assets FA Total Assets TA Ratio Analysis Profit Margin Return on Assets Inventory Turns/year NI/S NI/TA CGS/IN Transportation as % of sales TC/S Warehousing as % of sales WC/S Inventory carrying as % of sales IC/S Base Reduce by 15% Transportation Warehouse Inventory Calculated cell Sales Transportation Cost Warehousing Cost Inventory Carrying cost Cost of Goods Sold Other operating costs Average Inventory Accounts Receivable Cash Next fixed assets Interest Taxes Current Liabilities Long-Term liabilities Stockholders equity Simbol S TC WC W CGS OOC IN AR CA FA INT 200,000,000 12,000,000 3,000,000 30% 90,000,000 50,000,000 10,000,000 30,000,000 15,000,000 90,000,000 10,000,000 40% 65,000,000 35,000,000 45,000,000 Symbol Sales Cost of Goods Sold S CGS Gross Margin GM=S-CGS Transportation TC Warehousing WC Inventory Carrying IC=INW Other Operating Cost OOC Total Operating Cost TOC Earnings before interest and taxes EBIT Interest INT Taxes TX Net Income NI Asset Deployment Inventory Accounts Receivable IN AR Cash CA Fixed Assets FA Total Assets TA Ratio Analysis Profit Margin Return on Assets Inventory Turns/year NI/S NI/TA CGS/IN Transportation as % of sales TC/S Warehousing as % of sales WC/S Inventory carrying as % of sales IC/S Base Reduce by 15% Transportation Warehouse Inventory Calculated cell