Integrating problem; inventories and
• LO8–4, LO8–6, LO8–7
Inverness Steel Corporation is a producer of flat-rolled carbon, stainless and electrical steels, and tubular products. The company’s income statement for the 2018 fiscal year reported the following information ($ in millions):
Sales | $6,255 |
Cost of goods sold | 5,190 |
The company’s balance sheets for 2018 and 2017 included the following information ($ in millions):
2018 | 2017 | |
Current assets: | ||
Accounts receivable, net | $703 | $583 |
Inventories | 880 | 808 |
The statement of
Accounts Receivable (in part)
The allowance for uncollectible accounts was $10 and $7 at December 31, 2018 and 2017, respectively. All sales are on credit.
Inventories
Inventories are valued at the lower of cost or market. The cost of the majority of inventories is measured using the last in, first out (LIFO) method. Other inventories are measured principally at average cost and consist mostly of foreign inventories and certain raw materials. If the entire inventory had been valued on an average cost basis, inventory would have been higher by $480 and $350 at the end of 2018 and 2017, respectively.
During 2018, 2017, and 2016, liquidation of LIFO layers generated income of $6, $7, and $25, respectively.
Required:
Using the information provided:
1. Determine the amount of accounts receivable Inverness wrote off during 2018.
2. Calculate the amount of cash collected from customers during 2018.
3. Calculate what cost of goods sold would have been for 2018 if the company had used average cost to value its entire inventory.
4. Calculate the following ratios for 2018:
a. Receivables turnover ratio
b. Inventory turnover ratio
c. Gross profit ratio
5. Explain briefly what caused the income generated by the liquidation of LIFO layers. Assuming an income tax rate of 35%, what was the effect of the liquidation of LIFO layers on cost of goods sold in 2018?
1.
Inventory: It refers to the current assets that a company expects to sell during the normal course of business operations, the goods that are under process to be completed for future sale, or currently used for producing goods to be sold in the market.
Accounts Receivable: It is a current asset that reflects the amount due from the customers on account of credit sales by the company.
the amount of accounts receivable that Company I wrote off during 2018.
Explanation of Solution
Determinethe amount of accounts receivable that Company I wrote off during 2018.
Details | Amount (in millions) |
Beginning Balance | $7 |
Add: Bad debt expense for 2018 | $8 |
Less: Ending balance | ($10) |
Accounts receivable written off | $5 |
Table (1)
Therefore, the amount of accounts receivable that Company I wrote off during 2018 is $5 million.
2.
To Calculate: the amount of cash collected from customers during 2018.
Explanation of Solution
Calculate the amount of cash collected from customers during 2018.
Details | Amount (in millions) |
Beginning Balance ($583+$7) | $590 |
Add: Credit Sales | $6,255 |
Less: Inventory write-offs (Refer Table 1) | ($5) |
Less: Ending balance | ($713) |
Cash collected from customers | $6,127 |
Table (2)
Therefore, the amount of cash collected from customers during 20182018 is $6,127 million.
3.
To Calculate: the cost of goods sold that would have been for 2018 if the company had used average cost to value its entire inventory.
Explanation of Solution
If the company had used average cost to value its entire inventory, its cost of goods sold for 2018 would have been lower by $130 million ($480 million-$350 million). As per the information provided, the beginning inventory would have been higher by $350 million and the ending inventory would have been higher by $480 million.
An increase in beginning inventory increases the cost of goods sold while an increase in ending inventory decreases the cost of goods sold. Since there is an increase in the ending inventory of $130 million, it reduces the cost of goods sold by the same amount. The purchases during the year is not affected due to change in the inventory method.
Thus, the cost of goods sold would decrease to $5,060 million ($5,190 million-$130 million).
4.
To Calculate: the given ratios for 2018.
Explanation of Solution
a.
Calculate the receivable turnover ratio.
Sales =$6,255 million
Average accounts receivable =$643 million
Working note:
Determine the average accounts receivable.
b.
Calculate the inventory turnover ratio.
Cost of goods sold =$5,190 million
Average inventory =$844 million
Working note:
Determine the average inventory.
Calculate the gross profit ratio.
Gross Profit =$1,065 million
Net sales =$6,255 million
Working note:
Determine the gross profit
Therefore, the receivable turnover ratio for 2018 is 9.73 times, inventory turnover ratio is 6.15 times, and the gross profit ratio is 17%.
5.
To Explain: the cause of the income generated by the liquidation of LIFO layers and the effect of the liquidation of LIFO layers on cost of goods sold in 2018.
Explanation of Solution
At the time of increasing inventory costs and declining inventory quantities, the LIFO liquidation of the inventory layers purchased at lower costs of the previous years are sold in the current period to match with the current selling prices. Thus, the income generated from this liquidation of inventories is known as LIFO liquidation profit.
In the present case, the LIFO liquidation has decreased the cost of goods sold by $9.23 million ($6 million ÷ (1-35%).
Want to see more full solutions like this?
Chapter 8 Solutions
Loose Leaf Intermediate Accounting
- Exercise 9-12 (Algo) Calculate gross profit, cost of goods sold, and selling price LO 9-2, 9-3 MBI Incorporated had sales of $36 million for fiscal 2022. The company's gross profit ratio for that year was 26%. Required: a. Calculate the gross profit and cost of goods sold for MBI for fiscal 2022. b. Assume that a new product is developed and that it will cost $488 to manufacture. Calculate the selling price that must be set for this new product if its gross profit ratio is to be the same as the average achieved for all products for fiscal 2022. c. From a management viewpoint, it could use the estimated selling price as a "target" in conducting marketing research studies to assess its ultimate prospects for success at this price. Complete this question by entering your answers in the tabs below. Required A Required B Required C Calculate the gross profit and cost of goods sold for MBI for fiscal 2022. Note: Enter your answers in millions rounded to 2 decimal places. (i.e., 5,500,000…arrow_forward90 Marston Corporation Statement of Income for the Year Ending December 31, 2022 Using Sales Agents Using Own Sales Force $26,000,000 Sales Cost of goods sold Variable Fixed Gross margin Marketing costs Commissions Fixed costs Operating income $11,700,000 2,870,000 4,680,000 3,420,000 $26,000,000 14,570,000 11,430,000 8,100,000 $ 3,330,000 $11,700,000 2,870,000 2,600,000 5,500,000 14,570,000 11,430,000 8,100,000 $ 3,330,000 Marston is considering hiring its own sales staff to replace the network of agents. Marston will pay its salespeople a commission of 10% and incur additional fixed costs of $2,080,000. 4 Required 1. Calculate Marston Corporation's 2022 contribution margin percentage, breakeven revenues, and degree of operating leverage under each of the two scenarios. (You will first have to recast the 2022 statement of income assuming Marston had hired its own sales staff.) 2. Describe the advantages and disadvantages of each type of sales alternative. 3. In 2023, Marston uses its…arrow_forwardProblem 17-2 (LO 17-1) A service company has the... A service company has the following financial information (in millions of $) Sales $510 210 Cost of outsourced facilitating goods Cost of in-house services provided Administrative costs 199 77 Pretax earnings 24 (Round answers to 1 decimal place.) a. What is the profit leverage effect of reducing the cost of the facilitating goods in this company? b. It has been suggested that the in-house services costs could be reduced by 10 percent in the coming year by implementing lean systems. What effect would this have on earnings increase in percentage? c. What is the profit leverage effect of in-house services relative to profits?arrow_forward
- ILLUSTRATION 7. From the following information, interpret the results of operations of manufacturing concern using trend ratios : (Amount in '000 $ For the year ended 31st March 2016 2015 2014 2013 10,000 9,500 5,890 Sales (net) 13,000 12,000 Cost of Goods Sold 7,280 6,960 6,000 5,040 1,100 3,610 970 4,000 1,000 Gross Profit 5,720 Selling Expenses 1,200 Net Operating Profit 4,520 3,940 2,640 3,000arrow_forward14-19 Customer profitability, customer-cost hierarchy. Enviro-Tech has only two retail and two wholesale customers. Information relating to each customer for 2017 follows (in thousands):Wholesale Customers Retail CustomersNorth AmericaWholesalerSouth AmericaWholesaler Green Energy Global PowerRevenues at list prices $375,000 $590,000 $175,000 $130,000Discounts from list prices 25,800 47,200 8,400 590Cost of goods sold 285,000 510,000 144,000 95,000Delivery costs 4,550 6,710 2,230 2,145Order processing costs 3,820 5,980 2,180 1,130Cost of sales visit 6,300 2,620 2,620 1,575Enviro-Tech’s annual distribution-channel costs are $33 million for wholesale customers and $12 million forretail customers. The company’s annual corporate-sustaining costs, such as salary for top managementand general-administration costs are $48 million. There is no cause-and-effect or benefits-received relationship between any cost-allocation base and corporate-sustaining costs. That is, Enviro-Tech could…arrow_forward7-20 7-27 22 7-27 7-27 7-28 7-29 7-35 7-37 7-38 7-39 8-1 9-1 P7-5 (LO 6), AN Brislin Company has four operating divisions. During the first quarter of 2022, the company reported aggregate income from operations of $213,000 and the following divisional results. Sales Cost of goods sold Selling and administrative expenses Income (loss) from operations I $250,000 200,000 75,000 $(25,000) Analysis reveals the following percentages of variable costs in each division. Division Cost of goods sold Selling and administrative expenses II III IV $200,000 $500,000 $450,000 192,000 300,000 250,000 60,000 60,000 50,000 $(52,000) $140,000 $150,000 III 80% II I 70% 90% 60 40 50 Discontinuance of any division would save 50% of the fixed costs and expenses for that division. Top management is very concerned about the unprofitable divisions (I and II). Consensus is that one or both of the divisions should be discontinued. Instructions a. Compute the contribution margin for Divisions I and II. a.…arrow_forward
- Problem 13-02A (Video) The comparative statements of Cullumber Company are presented here: Cullumber CompanyIncome StatementsFor the Years Ended December 31 2020 2019 Net sales $1,891,640 $1,751,600 Cost of goods sold 1,059,640 1,007,100 Gross profit 832,000 744,500 Selling and administrative expenses 501,100 480,100 Income from operations 330,900 264,400 Other expenses and losses Interest expense 23,700 21,700 Income before income taxes 307,200 242,700 Income tax expense 93,700 74,700 Net income $213,500 $168,000 Cullumber CompanyBalance SheetsDecember 31 Assets 2020 2019 Current assets Cash $60,100 $64,200 Debt investments (short-term) 74,000 50,000 Accounts receivable 118,900 103,900 Inventory 127,700 117,200 Total current assets 380,700 335,300 Plant assets (net)…arrow_forwardSecurity First Income Statement For the Year Ended May 31, 2018 Product Line Industrial Household Systems Systems Total Net Sales Revenue $310,000 $330,000 $640,000 Cost of Goods Sold: Variable 35,000 43,000 78,000 Fixed 240,000 64,000 304,000 Total Cost of Goods Sold 275,000 107,000 382,000 Gross Profit 35,000 223,000 258,000 Selling and Administrative Expenses: Variable 68,000 70,000 138,000 Fixed 40,000 22,000 62,000 Total Selling and Administrative Expenses 108,000 92,000 200,000 Operating Income (Loss) $(73,000) $131,000 $58,000 Members of the board of directors of Security First have received the following operating income data for the year ended may 31, 2018. Requirement 1. Prepare a differential analysis to show whether Security First should…arrow_forwardPROBLEM 14: MMM Company started operations in 2019. The following data are abstractedfrom the company’s production and sales records: 2019 2020 2021 Number of units produced 120,000 116,250 101,250 Number of units sold 75,000 108,750 97,500 Unit production cost P 4.50 P 5.20 P 5.80 Sales revenue 600,000 900,000 975,000 Using the FIFO cost flow assumption, the gross profit for the year ended December 31, 2021 is:arrow_forward
- 15 Question 6: Inventories Answer the following three questions using the below information taken from the annual report of a US manufacturing firm. You can ignore taxes for this exercise. Income Statement: December 31 2021 2020 (millions of dollars) Net Sales 150 120 Cost of Goods Sold 110 95 Selling, General and Administrative 15 15 Expenses Other operating expenses 10 15 Net income 15 -5 Inventories: Inventories are valued at the lower of cost or net realizable value. The majority of our inventory is valued on the "last-in, first-out" (LIFO) basis, but inventories of certain subsidiaries are valued using the FIFO (“first-in, first-out") method. December 31 Inventory (millions of dollars) 2021 2020 Raw materials Work in process Finished products Total 10 14 11 13 9 7 30 34 If inventories had been valued using only the FIFO method, inventories would have been $18 million and $12 million higher than reported at December 31, 2021 and 2020, respectively. A. Please calculate COGS/Average…arrow_forwardRussell Department Stores, Inc. Income Statement Compared with Industry Average Year Ended December 31, 2018 Russell Industry Average Net sales revenue $780,000 100.0 % Cost of goods sold 524,940 65.8 Gross Profit 255,060 34.2 Operating Expenses 162,240 19.7 Operating Income 92,820 14.5 Other Expenses 7,800 0.4 Net Income 85,020 14.1 % MORE INFO: Russell/industry average Total Assets $480,000 100.0 % total Liabilities 327,360 64.7 total Liabilities and Stockholders' Equity $480,000 100.0 % SOLVE for % of total (round total to one decimal place x.x%) Amount Percent of total Net Sales Revenue 780,000 Cost of goods sold 524,940 gross profit 255,060 operating expenses 162240 operating income 92820 other expenses 7800arrow_forwardBOARD ACTIVITY Instructions: Horizontal Vertical Make a Horizontal Analysis and Vertical Analysis for 2014 2015 Analysis Analysis Revenue 1,939,500 1,674,675 1. the given SCI. Cost of Goods Sold 900,000 843,975 2. 8. Gross Profit 1,039,500 830,700 10. Selling and General Expenses 445,500 409,725 ur Other Expenses 37,575 30,825 giv 5. 11. Net Income 556,425 390,150 12.arrow_forward
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning