Question

In: Accounting

The following information relates to the Sarasota Company. Date Ending Inventory (End-of-Year Prices) Price Index December...

The following information relates to the Sarasota Company.

Date

Ending Inventory
(End-of-Year Prices)

Price
Index

December 31, 2013 $ 65,600 100
December 31, 2014 118,040 130
December 31, 2015 127,728 144
December 31, 2016 143,636 149
December 31, 2017 133,765 155


Use the dollar-value LIFO method to compute the ending inventory for Sarasota Company for 2013 through 2017.

Solutions

Expert Solution

Solution:

Computation of inventory at base year prices and change from prior year - Sarasota Company
Date Inventory at end of year prices Price index (Percentage) Inventory at base year prices Change from Prior Years
31-Dec-13 $65,600.00 100 $65,600.00 $0.00
31-Dec-14 $118,040.00 130 $90,800.00 $25,200.00
31-Dec-15 $127,728.00 144 $88,700.00 -$2,100.00
31-Dec-16 $143,636.00 149 $96,400.00 $7,700.00
31-Dec-17 $133,765.00 155 $86,300.00 -$10,100.00
Computation of dollar value inventory - LIFO
Particulars Amount
December 31, 2013:
$65,600*$1 $65,600.00
December 31, 2014:
$65,600*$1 $65,600.00
$25,200*1.30 $32,760.00
Inventory at Dec 31, 2014 $98,360.00
December 31, 2015:
$65,600*$1 $65,600.00
$23,100*1.30 $30,030.00
Inventory at Dec 31, 2015 $95,630.00
December 31, 2016:
$65,600*$1 $65,600.00
$23,100*1.30 $30,030.00
$7,700*1.49 $11,473.00
Inventory at Dec 31, 2016 $107,103.00
December 31, 2017:
$65,600*$1 $65,600.00
$20,700*1.30 $26,910.00
Inventory at Dec 31, 2017 $92,510.00

Related Solutions

The following information relates to the Novak Company. Date Ending Inventory (End-of-Year Prices) Price Index December...
The following information relates to the Novak Company. Date Ending Inventory (End-of-Year Prices) Price Index December 31, 2013 $ 66,900 100 December 31, 2014 103,194 117 December 31, 2015 110,940 129 December 31, 2016 124,887 133 December 31, 2017 115,787 139 Use the dollar-value LIFO method to compute the ending inventory for Novak Company for 2013 through 2017.
The following information relates to the Shamrock Company. Date Ending Inventory (End-of-Year Prices) Price Index December...
The following information relates to the Shamrock Company. Date Ending Inventory (End-of-Year Prices) Price Index December 31, 2013 $ 69,400 100 December 31, 2014 102,080 116 December 31, 2015 110,208 128 December 31, 2016 123,816 132 December 31, 2017 116,058 138 Use the dollar-value LIFO method to compute the ending inventory for Shamrock Company for 2013 through 2017. Ending Inventory 2013 $ 2014 $ 2015 $ 2016 $ 2017 $
Presented below is information related to Kingbird Company. Date Ending Inventory (End-of-Year Prices) Price Index December...
Presented below is information related to Kingbird Company. Date Ending Inventory (End-of-Year Prices) Price Index December 31, 2017 $ 78,200 100 December 31, 2018 242,950 215 December 31, 2019 239,604 246 December 31, 2020 271,272 267 December 31, 2021 320,579 287 December 31, 2022 382,833 297 Compute the ending inventory for Kingbird Company for 2017 through 2022 using the dollar-value LIFO method. Ending Inventory 2017 $enter a dollar amount 2018 $enter a dollar amount 2019 $enter a dollar amount 2020...
Presented below is information related to Metlock Company. Date Ending Inventory (End-of-Year Prices) Price Index December...
Presented below is information related to Metlock Company. Date Ending Inventory (End-of-Year Prices) Price Index December 31, 2014 $ 83,800 100 December 31, 2015 176,802 158 December 31, 2016 175,320 180 December 31, 2017 197,535 195 December 31, 2018 238,140 210 December 31, 2019 286,452 218 Compute the ending inventory for Metlock Company for 2014 through 2019 using the dollar-value LIFO method.
Presented below is information related to Skysong Company. Date Ending Inventory (End-of-Year Prices) Price Index December...
Presented below is information related to Skysong Company. Date Ending Inventory (End-of-Year Prices) Price Index December 31, 2017 $ 87,400 100 December 31, 2018 152,755 137 December 31, 2019 148,824 156 December 31, 2020 168,493 169 December 31, 2021 200,018 182 December 31, 2022 238,140 189 Compute the ending inventory for Skysong Company for 2017 through 2022 using the dollar-value LIFO method. Ending Inventory 2017: Ending Inventory 2018: Ending Inventory 2019:   Ending Inventory 2020: Ending Inventory 2021: Ending Inventory 2022:
Presented below is information related to Marigold Company. Date Ending Inventory (End-of-Year Prices) Price Index December...
Presented below is information related to Marigold Company. Date Ending Inventory (End-of-Year Prices) Price Index December 31, 2014 $ 83,600 100 December 31, 2015 261,723 231 December 31, 2016 258,456 264 December 31, 2017 292,006 286 December 31, 2018 349,580 308 December 31, 2019 421,399 319 Compute the ending inventory for Marigold Company for 2014 through 2019 using the dollar-value LIFO method. Ending Inventory 2014 $ 2015 $ 2016 $ 2017 $ 2018 $ 2019 $
Presented below is information related to Concord Company. Date Ending Inventory (End-of-Year Prices) Price Index December...
Presented below is information related to Concord Company. Date Ending Inventory (End-of-Year Prices) Price Index December 31, 2017 $ 83,200 100 December 31, 2018 145,934 131 December 31, 2019 142,950 150 December 31, 2020 161,696 163 December 31, 2021 193,200 175 December 31, 2022 227,698 181 Compute the ending inventory for Concord Company for 2017 through 2022 using the dollar-value LIFO method.
The following information relates to the inventory of Margaret’s Megamart Ltd during December. Ignore GST. Date...
The following information relates to the inventory of Margaret’s Megamart Ltd during December. Ignore GST. Date Units Units cost Total cost 1/12 Beginning inventory 700 $ 12.00 $ 8,400 10/12 Purchase 500 12.60 6,300 15/12 Purchase 300 13.20 3,960 23/12 Purchase 500 14.00 7,000 Totals 2,000 $25,660 Margaret’s Megamart Ltd uses the periodic inventory system. A physical count on 31 December verified that 650 units were on hand. Required: a) Determine the Ending inventory and Cost of Sales for the...
Company X has the following information: Inventory at end-of-year prices of $1,300,000 (2018 – base year),...
Company X has the following information: Inventory at end-of-year prices of $1,300,000 (2018 – base year), $1,450,000 (2019), and $1,350,000 (2020) The price index is 105 in 2019 and 107 in 2020 Use the dollar-value LIFO method to calculate ending inventory for 2019 and 2020.
1. The following information relates to inventory for Shoeless Joe Inc. Date Quantity Price March 1...
1. The following information relates to inventory for Shoeless Joe Inc. Date Quantity Price March 1 Beginning Inventory 20 $2 March 7 Purchase 15 3 March 11 Sale 25 7 March 12 Purchase 20 4 At what amount would Shoeless report ending inventory using FIFO cost flow assumptions? 2. Ace Bonding Company purchased inventory on account. The inventory costs $2,000 and is expected to sell for $3,000. How should Ace record the purchase using a perpetual inventory system? A. Inventory...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT