Videos
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
| 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
INTERMEDIATE ACCOUNTING (LL) W/CONNECT
- Chapter 17 Revenue and expense data for the current calendar year for Smith Electronics Company and for the electronics industry are as follows. The Smith Electronics Company data are expressed in dollars. The electronics Industry averages are expressed in percentages. Smith Electronics Electronics Industry Company Average $3,142,000 103.0% Sales 3.0% 150,000 Sales returns and allowances $2,992,000 100.0% Net sales 60.0% 1,850,000 Cost of goods sold 40.0% $1,142,000 Gross profit $750,000 23.0% Selling expenses 257,000 10.0% Administrative expenses 33.0% $1,007,000 Total operating expenses 7.0% $135,000 Operating income Other income 50,000 1.5% $185,000 8.5% 42,500 1.0% Other expense Income before income tax $142,500 7.5% Income tax expense 5.0% 76,000 $66,500 Net Income 2.5% a. Prepare a common-sized income statement comparing the results of operations for Smith Electronics Company with the industry average Round to one decimal place. b. As far as the data permit, comment on…arrow_forwardExercise 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_forwardPackaging Corporation of America produces containerboard and white papers. WestRock Co. manufactures paper products and corrugated products. Financial statement data for these two companies follow: Packaging Corporation of America ($ in millions of dollars) 2015 2016 2017 2018 Sales $5,779.0 689.2 $6,444.9 $7,014.6 Accounts receivable at December 31 $636.5 830.7 901.9 WestRock Co. ($ in millions of dollars) 2015 2016 2017 2018 $14,171.8 1,592.2 $14,859.7 1,886.8 $16,285.1 2,010.7 Sales Accounts receivable at December 31 $1,575.4 Source: Computed from amounts in the Packaging Corporation of America and WestRock Co. Form 10-Ks for 2014- 2018. In 2015 and 2016, WestRock was known as WRKC.., Inc. Required: 1. Determine the receivables turnover ratios for both companies for 2016, 2017, and 2018. (Use 365 days in a year. Do not round intermediate calculations. Round your answers to 1 decimal place.) 2. Which company collected its accounts receivable more quickly in 2018?arrow_forward
- 90 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_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_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_forward
- A7arrow_forward15 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_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
- A9arrow_forwardQ2 The following information relating to third and last quarter of 2018-19 is furnished by a company which manufactures and sells a single product: Third Quarter (Actual) Last Quarter (Estimate) Sales 6,24,000 6,60,000 Inventory of raw material and finished goods Closing Balance Target Closing Balance Raw Material A (kgs) 23,500 25,000 Raw Material B (kgs) 13,400 15,000 Finished Goods (units) 700 1,000 Unit Cost data: Raw Material A- →10 kgs@ ? 6 5 kgs @ ? 4 Raw Material B- Direct Labour: Machine Shop-> Machine time: 5 hours @ 7 8 Assembly-> Labour time: 2 hours @ ? 10 Production Overheads: Machine Shop-> ? 24 per machine hour Assembly-> ? 20 per labour hour Selling and Administration overheads- 20% of production cost Profit Margin- 10% of selling price Production and sales occur evenly during the budget period. Required: (1) to calculate the selling price of the product and the number of units estimated to be sold (i) to prepare for the last quarter of the year: (a) Production Budget…arrow_forwardPROBLEM 14: MMM Company started operations in 2019. The following data are abstracted from the company's production and sales records: 2019 2020 2021 of units Number produced Number of units sold Unit production cost 116,250 108,750 P 4.50 P 5.20 P 5.80 900,000 120,000 75,000 101,250 97,500 Sales revenue 600,000 975,000 19. Using the FIFO cost flow assumption, the gross profit for the year ended December 31, 2021 is: PROBLEM 15: The following quarterly cost data have been accumulated for New DDD Manufacturing, Inc.: Raw materials, 1/1/2022 Purchases of raw materials 10,000 units at P6.00 8,500 units at P7.00 11,000 units at P7.50 Raw materials transferred to work in process Work in process, 1/1/2022 Direct labor Manufacturing overhead Work in process, 3/31/2022 21,500 units 5,600 units at P13.50 P 250,000 325,000 4,200 units at P13.75 20. If New Dehi uses the FIFO method for valuing raw materials inventories, compute for the cost of goods manufactured for the quarter ended March 31,…arrow_forward
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning