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 cash flows reported
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 ACCT.(LL)W/CONNECT ACCESS
- CH7-Q50: Hi I have asked this question before, but i haven't received explanation on requirement # 3. Also, last question was not answered. Please answer #6 (last question) and fully explain # 3. thanks! Jellico Inc.'s projected operating income (based on sales of 450,000 units) for the coming year is as follows: Total Sales $ 12,150,000 Total variable cost 7,533,000 Contribution margin $ 4,617,000 Total fixed cost 2,875,878 Operating income $ 1,741,122 Required: 1(a). Compute variable cost per unit. Enter your answer to the nearest cent.$per unit 1(b). Compute contribution margin per unit. Enter your answer to the nearest cent.$per unit 1(c). Compute contribution margin ratio. % 1(d). Compute break-even point in units. units 1(e). Compute break-even point in sales dollars.$ 2. How many units must be sold to earn operating income of $376,542? units 3. Compute the additional operating income that Jellico would earn if sales were $50,000 more than expected.$ 4. For…arrow_forwardP8.6 (LO 3) (Compute FIFO, LIFO, Average-Cost—Periodic and Perpetual) Ehlo Company is a multi product firm. Presented below is information concerning one of its products, the Hawkeye.Date Transaction Quantity Price/Cost1/1 Beginning inventory 1,000 $122/4 Purchase 2,000 182/20 Sale 2,500 304/2 Purchase 3,000 2311/4 Sale 2,200 33Instructions Compute ending inventory AND cost of goods sold, assuming Ehlo uses: a. Periodic system, FIFO cost flow. b. Perpetual system, FIFO cost flow. c. Periodic system, LIFO cost flow. d. Perpetual system, LIFO cost flow. e. Periodic system, weighted-average cost flow. f. Perpetual system,…arrow_forwardEB1. LO 10.1 Ella Maksimovis CEO of her own marketing firm. The firm recently moved from a strip mall in the suburbs to an office space in a downtown building, in order to make the firm’s employees more accessible to clients. Two new clients are interested in using Ella’s advertising services but both clients are in the same line of business, meaning that Ella’s company can represent only one of the clients. Pampered Pooches wants to hire Ella’s firm for a one-year contract for web, newspaper, radio, and direct mail advertising. Pampered will pay $126,000 for these services. Ella estimates the cost of the services requested by Pampered Pooches to be $83,000. Delightful Dogs is interested in hiring Ella to produce mass mailings and web ads. Delightful will pay Ella $94,000 for these services and Ella estimates the cost of these services to be $47,000. Identify any relevant costs, relevant revenues, sunk costs, and opportunity costs that Ella Graham has to consider in making the decision…arrow_forward
- EA4. LO 8.1 Use the information provided to create a standard cost card for production of one glove box switch. To make one switch it takes 16 feet of plastic-coated copper wire and 0.5 pounds of plastic material. The plastic material can usually be purchased for $20.00 per pound, and the wire costs $2.50 per foot. The labor necessary to assemble a switch consists of two types. The first type of labor is assembly, which takes 3.5 hours. These workers are paid $27.00 per hour. The second type of labor is finishing, which takes 2 hours. These workers are paid $29.00 per hour. Overhead is applied using labor hours. The variable overhead rate is $14.90 per labor hour. The fixed overhead rate is $15.60 per hour.arrow_forwardEXERCISE 5–11 Missing Data; Basic CVP Concepts [LO5–1, LO5–9] Fill in the missing amounts in each of the eight case situations below. Each case is independent of the others. (Hint: One way to find the missing amounts would be to prepare a contribution format income statement for each case, enter the known data, and then compute the missing items.) a. Assume that only one product is being sold in each of the four following case situations: {picture11} b. Assume that more than one product is being sold in each of the four following case situations: {picture12}arrow_forward● LO16–3, LO16–4, LO16–7The date is January 10, 2023, and Maryton Hotels’ CFO George Smith is looking with dismay at his company’s financial performance during 2022. Already facing stiff competition from other hotel chains as well as Airbnb, Maryton had run an operating loss in 2020 and 2021 and had responded by engaging in a broad effort to refresh hotel décor and update wi-fi and other infrastructure. That effort concluded in late 2021 and seemed to be showing success in early 2022. However, a variant of the COVID-19 virus reached pandemic status in mid-2022, and business and leisure travel fell off considerably. Occupancy rates at Maryton properties plunged, producing a $10 million pre-tax net operating loss for 2022. Maryton’s CEO has asked that George “work some of his accounting magic” to “put a positive spin on things” and minimize Maryton’s net loss, hoping to calm concerns being voiced by investors and lenders.Required:Assume Maryton has a 25% tax rate. Prepare a journal entry…arrow_forward
- 12. Menchie Corporation is developing standards for its products. One product requires an input that is purchased for P57.00 per kilogram from the supplier. By paying cash, the company gets a discount of 8% off this purchase price. Shipping costs from the supplier's warehouse amount to P3.60 per kilogram. Receiving costs are P0.26 per kilogram. The standard price per kilogram of this input should be: A.P 57.70 В. Р 56.30 С. Р 65.42 D. P 57.00arrow_forward41. LO.2 (Identification of inventory costs) Tyler Tubing’s management has been evalu- ating company policies with respect to control of costs of corrugated metal, one of the firm’s major component materials. The firm’s controller has gathered the following financial data, which may be pertinent to controlling costs associated with the metal tubing: Ordering Costs Annual salary of purchasing department manager $61,500.00 Depreciation of equipment in purchasing…arrow_forwardH6. 18. Question Content Area Aquamarine Company sells one of its products, Product X, for $50 each. Sales volume averages 5,000 units per year. Recently, its main competitor reduced the price of its product to $30. Aquamarine expects sales to drop dramatically unless it matches the price offered by its competitor. In addition, the current profit per unit must be maintained. Information about Product X (for production of 5,000 units) follows: Standard QuantityActual QuantityActual CostMaterials (pounds)8,50010,00025,000Labor (hours)2,0002,50012,000Setups (hours)02,0004,000Material handling (moves)01,0002,500Warranties (number repaired)05008,000 The non-value-added cost per unit is (Round answer to two decimal places.): a. $3.17. b. $4.50. c. $4.13. d. $3.80. 24. Question Content Area Phillips Screw Company produces screw fittings. It is determined that T = 1 inch in diameter. Specification limits allow a variation of plus or minus 0.5 inches. Products produced at…arrow_forward
- Ch. 7 Incremental Analysis Pg 461 Self Practice Please solve the following questions and provide and explanation. Thank you "Big Tent Company has received a special order for 10,000 units at a discount price of $100 each. The product sells for $150, has the following manufacturing costs: " Cost Per Unit Direct Materials $40 Direct Labor $ 20 Variable Manufacturing Overhead $ 20 Fixed Manufacturing Overhead $30 Totaul Unit Cost $110 1) Assume Big Top has enough extra capacity to fill the order without affecting the production or sale of it's product to regular customers. If Big Top accepts offer, what effect will the roder have on the company's short-term profit? 2) If Big Top is at full capacity, what price would be needed to cover all incremental costs, including opportunity costs?arrow_forwardCH11_HW_QA3_LA Required 1: Compute the company’s return on investment (ROI) for the period using the ROI formula stated in terms of margin and turnover. (Round your intermediate calculations and final answer to 2 decimal places.) Margin % Turnover ROI % Required 2: Using Lean Production, the company is able to reduce the average level of inventory by $95,000. (The released funds are used to pay off short-term creditors.) (Round your intermediate calculations and final answers to 2 decimal places.) Effect Margin % Turnover ROI % Required 3: The company achieves a cost savings of $14,000 per year by using less costly materials. (Round your intermediate calculations and final answers to 2 decimal places.) Effect Margin % Turnover ROI % Required 4: The company issues bonds and uses the proceeds to…arrow_forwardCH11_HW_QA3_PIR Required 1: Compute the company’s return on investment (ROI) for the period using the ROI formula stated in terms of margin and turnover. (Round your intermediate calculations and final answer to 2 decimal places.) Margin not attempted % Turnover not attempted ROI not attempted % Required 2: Using Lean Production, the company is able to reduce the average level of inventory by $96,000. (The released funds are used to pay off short-term creditors.) (Round your intermediate calculations and final answers to 2 decimal places.) Effect Margin % Turnover ROI % Required 3: The company achieves a cost savings of $14,000 per year by using less costly materials. (Round your intermediate calculations and final answers to 2 decimal places.) Effect Margin % Turnover ROI % Required 4: The…arrow_forward
- Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE LFinancial & Managerial AccountingAccountingISBN:9781285866307Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning