2018 | |||||||
Cost | Retail | ||||||
Beginning Inventory | $56,000 | $88,000 | |||||
Cost to retail % | 56000/88000 | ||||||
64% | |||||||
Net Purchases | $104,000 | $128,000 | |||||
Freight In | $4,000 | ||||||
Net Markups | $20,000 | ||||||
Net Markdowns | ($4,000) | ||||||
Total | $108,000 | $144,000 | |||||
Ending Inventory % | $108000/$144000 | ||||||
75% | |||||||
Cost | Retail | ||||||
Beginning Inventory | $56,000 | $88,000 | |||||
Purchases | $108,000 | $144,000 | |||||
Total Inventory | $164,000 | $232,000 | |||||
Net Sales to Customer | 129465 | ||||||
Sales to employee | 3375 | 2700/.80 | |||||
Total Sales | 132840 | ||||||
Ending Inventory at retail price | $99,160 | ||||||
/price index | 1.06 | ||||||
Ending Inventory Value | $93,547 | ||||||
Yr | Retail Price | Index | Cost to retail % | Ending Inventory Cost | |||
2018 | 88000 | 1 | 64% | 56320 | |||
2019 | 5547 | 1.08 | 75% | 4493 | |||
93547 | 60813 | ||||||
Cost of Goods Sold -2018 | Total Inventory available -Ending Inventory Cost | ||||||
$164000-$60813 | |||||||
$103,187 | |||||||
Next Yr | |||||||
2019 | |||||||
Cost | Retail | ||||||
Beginning Inventory | $60,813 | $93,547 | |||||
Net Purchase | $109,695 | $134,200 | |||||
Freight In | $4,500 | ||||||
Net Markeups | $12,000 | ||||||
Net Markdowns | ($4,200) | ||||||
Total | $175,008 | $235,547 | |||||
Ending Inventory% | 175008/235547 | ||||||
74% | |||||||
Cost | Retail | ||||||
Beginning Inventory | $60,813 | $93,547 | |||||
Purchases | 175008 | 235547 | |||||
Total Inventory | $235,821 | $329,094 | |||||
Net Sales to Customer | $121,260 | ||||||
Sales to employee | $5,500 | 4400/.8 | |||||
Total Sales | 126760 | ||||||
Ending Inventory at retail price | $202,334 | ||||||
/ Price Index | 1.12 | ||||||
Ending Inventory Value | $180,655 | ||||||
Yr | Retail Price | Index | Cost to retail % | Ending Inventory Cost | |||
2017 | 88000 | 1 | 64% | 56320 | |||
2018 | 5547 | 1.08 | 75% | 4493 | |||
2019 | 87108 | 1.12 | 74% | 72195 | |||
180655 | 133008 | ||||||
Cost of Goods Sold 2019 | Total Inventory available-Ending Inventory Cost | ||||||
$235821-$133008 | |||||||
$102,813 | |||||||
Solution | 2018 | 2019 | |||||
Estimated ending inventory at retail | $99,160 | $180,655 | |||||
Estimated ending inventory at cost | $60,813 | $133,008 | |||||
Estimated cost of goods sold | $103,187 | $102,813 | |||||
On January 1, 2018, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inven...
On January 1, 2021, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2021 and 2022 are as follows: Beginning inventory Net purchases Freight-in Net markups Net markdowns Net sales to customers Sales to employees (net of 20% discount) Price Index: January 1, 2021 December 31, 2021 December 31, 2022 2021 2022 Cost Retail Cost Retail $ 48,000 $ 64,000 103,040 120,000 $115,150 $133,000 3,200 3,700 16,000 10,400...
On January 1, 2021, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2021 and 2022 are as follows: Beginning inventory Net purchases Freight-in Net markups Net markdowns Net sales to customers Sales to employees (net of 20% discount) Price Index: January 1, 2021 December 31, 2021 December 31, 2022 2021 2022 Cost Retail Cost Retail $28,000 $ 40,000 85,000 108,000 $90,000 $114,000 2,000 2,500 10,000 8,000 2,000...
On January 1, 2016, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2016 and 2017 are as follows: 2016 2017 Cost Retail Cost Beginning inventory Net purchases Freight-in Net markups Net markdowns Net sales to customers Sales to employees (net of 20% discount) Price Index: $28,000 40,000 108,000 $ 90,000 $ 114,000 85,000 2,000 2,500 10,000 2,000 100,000 2,400 8,000 2,200 104,000 4,000 January 1, 2016 December...
On January 1, 2021, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2021 and 2022 are as follows: 2021 2022 Cost Retail Cost Retail Beginning inventory $ 57,000 $ 76,000 Net purchases 109,160 126,000 $ 115,150 $ 132,400 Freight-in 3,800 4,300 Net markups 19,000 11,600 Net markdowns 3,800 4,000 Net sales to customers 124,460 120,440 Sales to employees (net of 10% discount) 4,500 5,850 Price Index: January...
On January 1, 2021, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2021 and 2022 are as follows: 2021 2022 Cost Retail Cost Retail Beginning inventory $ 39,200 $ 56,000 Net purchases 92,600 116,000 $ 104,166 $ 128,400 Freight-in 2,800 3,300 Net markups 14,000 9,600 Net markdowns 2,800 3,000 Net sales to customers 113,355 117,120 Sales to employees (net of 20% discount) 3,300 5,280 Price Index: January...
On January 1, 2021, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2021 and 2022 are as follows: Beginning inventory Net purchases Freight-in Net markups Net markdowns Net sales to customers Sales to employees (net of 20% discount) Price Index: January 1, 2021 December 31, 2021 December 31, 2022 2021 2022 Cost Retail Cost Retail $46,200 $ 66,000 97,350 121,000 $111,998 $137,900 3,300 3,800 16,500 10,600 3,300...
On January 1, 2021, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2021 and 2022 are as follows: Beginning inventory Net purchases Freight-in Net markups Net markdowns Net sales to customers Sales to employees (net of 20% discount) Price Index: January 1, 2021 December 31, 2021 December 31, 2022 2021 2022 Cost Retail Cost Retail $ 58,500 $ 78,000 110,180 127,000 $115,808 $133,100 3,900 4,400 19,500 11,800...
On January 1, 2021, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2021 and 2022 are as follows: 2021 2022 Cost Retail Cost Retail Beginning inventory $ 57,000 $ 76,000 Net purchases 109,160 126,000 $ 115,150 $ 132,400 Freight-in 3,800 4,300 Net markups 19,000 11,600 Net markdowns 3,800 4,000 Net sales to customers 124,460 120,440 Sales to employees (net of 10% discount) 4,500 5,850 Price Index: January...
On January 1, 2021, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2021 and 2022 are as follows: 2021 2022 Cost Retail Cost Retail Beginning inventory $ 37,700 $ 58,000 Net purchases 87,120 117,000 $ 93,886 $ 123,300 Freight-in 2,900 3,400 Net markups 14,500 9,800 Net markdowns 2,900 3,100 Net sales to customers 115,790 112,000 Sales to employees (net of 20% discount) 3,400 5,440 Price Index: January...
Check my work On January 1, 2021, HGC Camera Store adopted the dollar-value LIFO retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2021 and 2022 are as follows: Beginning inventory Net purchases Freight-in Net markups Net markdowns Net sales to customers Sales to employees (net of 20% discount) Price Index: January 1, 2021 December 31, 2021 December 31, 2022 2021 2022 Cost Retail Cost Retail $34,500 $ 46,000 93,860 111,000 $106,834 $123,900 2,300 2,800...