6. Using a spreadsheet computer software program, construct a supply chain finance model and calculate the profit margin; ROA; inventory turns; and trans portation, warehousing, and inventory costs as a percentage of revenue for the following:

Sales = $200,000,000; Transportation cost = $7,000,000;

Warehousing cost = $1,600,000; Inventory carrying cost = 28 percent;

Cost of goods sold = $70,000,000; Other operating costs = $65,000,000;

Average inventory = $10,000,000; Accounts receivable = $30,000,000;

Cash = $15,000,000; Net fixed assets = $90,000,000;

Interest = $10,000,000; Taxes = 40 percent of (EBIT - interest), Current liabilities = $65,000,000; Long-term liabilities = $35,000,000; and Stockholders equity = $45,000,000.