Question

In: Accounting

Smith-Kline Company maintains inventory records at selling prices as well as at cost. For 2018, the...

Smith-Kline Company maintains inventory records at selling prices as well as at cost. For 2018, the records indicate the following data:

($ in 000s)
Cost Retail
Beginning inventory $ 81 $ 135
Purchases 575 1,015
Freight-in on purchases 32
Purchase returns 1 1
Net markups 3
Net markdowns 7
Net sales 918


Required:
Assuming the price level increased from 1 at January 1 to 1.20 at December 31, 2018, use the dollar-value LIFO retail method to approximate cost of ending inventory and cost of goods sold. (Do not round intermediate calculations. Round final answers to the nearest whole dollar. Enter your answers in thousands.)

($ in 000s)
Estimated ending inventory at retail
Estimated ending inventory at cost
Estimated cost of goods sold

Solutions

Expert Solution

Solution: Calculation of cost of ending inventory:

Particulars cost($ in 000s) Retail($ in 000s)
Beginning Inventory 81 135
Add: purchases 575 1,015
Freight In 32
Net markups 3
Less: Purchase return (1) (1)
Net markdowns (7)
Goods available for sale (excluding beginning Inventory) 606 1,010
Goods available for sale (including beginning Inventory) 687 1,145
Base layer cost to retail percentage(81*100/135=60%)
2018 layer cost to retail percentage(606*100/1010= 60%)
Less: Net sales (918)
Estimated ending inventory at current year retail prices 227
Estimated ending inventory at cost(given below) (103)
Estimated cost of goods sold 584
Ending inventory at year end retail prices Step1: Ending inventory at base year retail prices Step2: inventory layers at base year retail prices Step3: Inventory layers converted to cost
$227 (given above) $227÷1.2 = $189 $135*1*60% $81
$31*1.2*60% $22
Total ending inventory at dollar value LIFO retail cost $103

Related Solutions

Smith-Kline Company maintains inventory records at selling prices as well as at cost. For 2018, the...
Smith-Kline Company maintains inventory records at selling prices as well as at cost. For 2018, the records indicate the following data. ($ in 000s) Cost Retail Beginning Inventory $112 $160 Purchases $812 $1067 Freight- in on purch. 37 Purchase returns 1 3 Net markups 5 Net markdowns 9 net sales 923 Required: Assuming the price level increased from 1 at January 1 to 1.45 at December 31, 2018, use the dollar-value LIFO retail method to approximate cost of ending inventory...
Smith-Kline Company maintains inventory records at selling prices as well as at cost. For 2018, the...
Smith-Kline Company maintains inventory records at selling prices as well as at cost. For 2018, the records indicate the following data: ($ in 000s) Cost Retail Beginning inventory $ 81 $ 135 Purchases 575 1,015 Freight-in on purchases 32 Purchase returns 1 1 Net markups 3 Net markdowns 7 Net sales 918 Required: Assuming the price level increased from 1 at January 1 to 1.20 at December 31, 2018, use the dollar-value LIFO retail method to approximate cost of ending...
Smith-Kline Company maintains inventory records at selling prices as well as at cost. For 2018, the...
Smith-Kline Company maintains inventory records at selling prices as well as at cost. For 2018, the records indicate the following data: ($ in 000s) Cost Retail Beginning inventory $ 91 $ 130 Purchases 518 905 Freight-in on purchases 23 Purchase returns 1 1 Net markups 3 Net markdowns 7 Net sales 800 Required: Assuming the price level increased from 1 at January 1 to 1.50 at December 31, 2018, use the dollar-value LIFO retail method to approximate cost of ending...
S Smith-Kline Company maintains inventory records at selling prices as well as at cost. For 2021,...
S Smith-Kline Company maintains inventory records at selling prices as well as at cost. For 2021, the records indicate the following data: ($ in 000s) Cost Retail Beginning inventory $ 60 $ 100 Purchases 533 935 Freight-in on purchases 26 Purchase returns 1 1 Net markups 3 Net markdowns 7 Net sales 812 Required: Assuming the price level increased from 1.00 at January 1 to 1.80 at December 31, 2021, use the dollar-value LIFO retail method to approximate cost of...
Smith-Kline Company maintains inventory records at selling prices as well as at cost. For 2021, the records indicate the following data:
Part 1.Smith-Kline Company maintains inventory records at selling prices as well as at cost. For 2021, the records indicate the following data:   ($ in 000s)   Cost Retail Beginning inventory $ 81   $ 126   Purchases   672     1,007   Freight-in on purchases   31         Purchase returns   2     3   Net markups         5   Net markdowns         9   Net sales  ...
Steven’s Stationery a well-known stationary store in town .The business maintains individual inventory records for each...
Steven’s Stationery a well-known stationary store in town .The business maintains individual inventory records for each merchandise they are selling. The following information has been extracted from the records of Steven’s Stationery about one of its popular products. There are 50 units at the beginning of October costing $ 30 each. Date Purchase Date Sales October-09 100 units @ 28 October-11 100 units @ 50 October-17 70 units @ 27 October-15 20 units @ 50 October-25 80 units @ 26...
Assume that the City of Fort Smith maintains its books and records in a manner that...
Assume that the City of Fort Smith maintains its books and records in a manner that facilitates the preparation of fund financial statements. For each of the following events indicate in which fund(s) of the city the event would be recorded and justify your fund selection. A.)The city collected property taxes levied for the general operations of the city. B.)The city collected property taxes levied to pay principal and interest on bonds issued several years in the past to construct...
Hopewell Electronics maintains its LED television inventory using the perpetual method. The inventory records for April...
Hopewell Electronics maintains its LED television inventory using the perpetual method. The inventory records for April follow: Beginning inventory 20 units @ $525 each April 12 purchase 30 units @ $550 each April 20 sale 40 units @ $830 each April 25 purchase 15 units @ $575 each Using the weighted-average cost method, how much is the April 30 ending inventory on the Hopewell Electronics' Balance Sheet? Select one: A. $21,600 B. $13,750 C. $14,025 D. $14,175
The inventory records of Frost Company for the years 2016 and 2017 reveal the cost and...
The inventory records of Frost Company for the years 2016 and 2017 reveal the cost and market of the January 1, 2016, inventory to be $125,000. On December 31, 2016, the cost of inventory was $130,000, while the market value was only $128,000. The December 31, 2017, market value of inventory was $140,000, and the cost was only $135,000. Frost uses a perpetual inventory system. Assume Frost uses the allowance method and a perpetual inventory system. Prepare the necessary journal...
The inventory records of Frost Company for the years 2016 and 2017 reveal the cost and...
The inventory records of Frost Company for the years 2016 and 2017 reveal the cost and market of the January 1, 2016, inventory to be $125,000. On December 31, 2016, the cost of inventory was $130,000, while the market value was only $128,000. The December 31, 2017, market value of inventory was $140,000, and the cost was only $135,000. Frost uses a perpetual inventory system. Required: 1. Assume the inventory that existed at the end of 2016 was sold in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT