Using the attached spreadsheet, construct a supply chain finance model by calculating P&L and Balance Sheets and the appropriate ratios and measures and calculate the profit margin; ROA; inventory turns; along with transportation, warehousing, and inventory cost as a percentage of sales (revenues) for the following: Baseline Sales Transportation cost Warehousing cost Inventory carrying rate Cost of goods sold Other operating costs Average inventory Cash Accounts receivable Net fixed assets Interest Tax rate Current liabilities Long-term Liabilities $200,000,000 $12,000,000 $3,000,000 0.31 $90,000,000 $50,000,000 $8,000,000 $15,000,000 $30,000,000 $90,000,000 $10,000,000 20%² $65,000,000 $35,000,000

Using the attached spreadsheet, construct a supply chain finance model by calculating P&L and Balance Sheets and the appropriate ratios and measures and calculate the profit margin; ROA; inventory turns; along with transportation, warehousing, and inventory cost as a percentage of sales (revenues) for the following: Baseline Sales Transportation cost Warehousing cost Inventory carrying rate Cost of goods sold Other operating costs Average inventory Cash Accounts receivable Net fixed assets Interest Tax rate Current liabilities Long-term Liabilities $200,000,000 $12,000,000 $3,000,000 0.31 $90,000,000 $50,000,000 $8,000,000 $15,000,000 $30,000,000 $90,000,000 $10,000,000 20%² $65,000,000 $35,000,000

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter9: Responsibility Accounting And Decentralization

Section: Chapter Questions

Problem 1PB: Use the following information to answer the questions that follow. A. Calculate the operating income...

See similar textbooks

Similar questions

Given the following information, convert Cardinal Companys cost of goods sold from its income statement into payments to suppliers for its statement of cash flows.
Calculate the projected inventory turnover, days sales outstanding (DSO), fixed assets turnover, and total assets turnover. How does Computron’s utilization of assets stack up against that of other firms in its industry?
Use the weighted-average (AVG) cost allocation method, with perpetual inventory updating, to calculate (a) sales revenue, (b) cost of goods sold, and c) gross margin for B75 Company, considering the following transactions.
Use the first-in, first-out (FIFO) cost allocation method, with perpetual inventory updating, to calculate (a) sales revenue, (b) cost of goods sold, and c) gross margin for A75 Company, considering the following transactions.
Using the following information, prepare the Cost of Goods Sold section of an income statement.
Use the last-in, first-out (LIFO) cost allocation method, with perpetual inventory updating, to calculate (a) sales revenue, (b) cost of goods sold, and c) gross margin for A75 Company, considering the following transactions.
Use the first-in, first-out method (FIFO) cost allocation method, with perpetual inventory updating, to calculate (a) sales revenue, (b) cost of goods sold, and c) gross margin for B75 Company, considering the following transactions.
Use the last-in, first-out method (LIFO) cost allocation method, with perpetual inventory updating, to calculate (a) sales revenue, (b) cost of goods sold, and c) gross margin for B75 Company, considering the following transactions.
What insights can be gained from inventory ratio analysis, such as inventory turnover ratio and number of days sales in inventory ratio?
Use the following information to answer the questions that follow. A. Calculate the operating income percentage for each of the stores. Comment on how your analysis has changed for each store. B. Perform a vertical analysis for each store. Based on your analysis, what accounts would you want to investigate further? How might management utilize this information? C. Which method of analysis (using a dollar value or percentage) is most relevant and/or useful? Explain.
Define each of the following terms: Liquidity ratios: current ratio; quick, or acid test, ratio Asset management ratios: inventory turnover ratio; days sales outstanding (DSO); fixed assets turnover ratio; total assets turnover ratio Financial leverage ratios: debt ratio; times-interest-earned (TIE) ratio; EBITDA coverage ratio Profitability ratios: profit margin on sales; basic earning power (BEP) ratio; return on total assets (ROA); return on common equity (ROE) Market value ratios: price/earnings (P/E) ratio; price/cash flow ratio; market/book (M/B) ratio; book value per share Trend analysis; comparative ratio analysis; benchmarking DuPont equation; window dressing; seasonal effects on ratios
The following information is taken from a companys records. Applying the lower-of-cost-or-market approach, what is the correct value that should be reported on the balance sheet for the inventory?