Question: Complete the problem below using Excel. Presented below is information related to Meghani Company. They adopted LIFO in 2017 (base year). Ending Inventory Price ___Date

Complete the problem below using Excel.

Presented below is information related to Meghani Company. They adopted LIFO in 2017 (base year).

Ending Inventory Price

___Date (End of year prices) Index ______

December 31, 2017 $ 900,000 100

December 31, 2018 1,260,000 105

December 31, 2019 1,840,000 115

December 31, 2020 1,900,000 125

December 31, 2021 2,200,000 128

Prepare a worksheet showing:

Your calculation of ending inventory using Dollar Value LIFO.
The balance of the LIFO Reserve at the end of each year.
The necessary journal entry each year to adjust the ending inventory to Dollar Value LIFO and record the LIFO Reserve.

Step by Step Solution

★★★★★

3.44 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Date Ending Inventory A Price Index B Ending Inventory Base Year C A 100B Change in Ending Inventory Dec 31 2017 900000 100 900000 0 Dec 31 2018 12600... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Presented below is information related to Meghani Company. Instructions Compute the ending inventory for Meghani Company for 2013 through 2018 using the dollar-value LIFOmethod. Ending Inventory...

Presented below is information related to Hanshew Real Estate Agency. Oct. 1 Pete Hanshew begins business as a real estate agent with a cash investment of $15,000. 2 Hires an administrative...

Presented below is information related to Chevalier Co. 1. On April 5, purchased merchandise from Paris Company for $22,000, terms 2/10, net/30, FOB shipping point. 2. On April 6, paid freight costs...

Retail Inventory Method Presented below is information related to Kuchinsky Company. Compute the inventory by the conventional retail inventory method. Retail Cost Beginning inventory Purchases...

Compute Income Measures Presented below is information related to Viel Company at December 31, 2010, the end of its first year of operations. Sales revenue...................... 310,000 Cost of goods...

Presented below is information related to Kienholz Company for its first month of operations. Identify the balances that appear in the accounts receivable subsidiary ledger and the accounts...

Presented below is information related to City Company for its first month of operations. Determine the balances that appear in the accounts payable subsidiary ledger. What Accounts Payable balance...

Presented below is information related to Montand Company for its first month of operations. Identify the balances that appear in the accounts receivable subsidiary ledger and the accounts receivable...

Presented below is information related to Chung Company for its first month of operations. Determine the balances that appear in the accounts payable subsidiary ledger. What Accounts Payable balance...

Ratio Computations and Effect of Transactions Presented below is information related to Leland Inc. (a) Compute the following ratios or relationships of Leland Inc. Assume that the ending account...

Mrs. Rosa (Rosa) turned 65 on 13 January 2023, she had worked as a senior administrator in one of the reputable accounting firms, Tax expert (Pty) Ltd. She retired on 31 January 2023 after 20 years...

From this article Could you help me to identify and pick it from one of the two ERM quadrants that are typically speculative in nature - and explain what the risk is, why it is speculative, and why...

The company Techito S.A. has the following cost elements: 1. Rental of premises or office 2. Social charges on wages paid for production. 3. Purchase of glue and staples for reinforced section 4....

Design a Hazard Communication Programme use the link https://www.osha.gov/sites/default/files/2018-12/fy10_sh-21003-10_mod_2_hazcom_program.pdf LITERATURE Review of literature on significant...

Bill Gate Company incurred costs for materials and conversion in the amount of P 45,000 and P 4,860 respectively. As of the same date, the work in process inventory in units of P 6,000 is 40%...

Budget cash receipts for the months of January, February, and March. Budgeted sales, all on account: November $ 65,000 December January February March 60,000 82,000 70,000 90,000 Collection of...

You are an agent working for ABC Realty in Omaha and recently sold a $600,000 home as a buyers exclusive agent. The listing agreement indicated that a 6% commission would be paid at closing. What is...

The bookkeeper for Riley, Inc., made the following errors: a. A cash purchase of supplies of $357 was recorded as a debit to Supplies for $375 and a credit to Cash of $375. b. A cash sale of $3,154...

Refer to the data for the Blending Department of Sunspots Beverages, Ltd., in Problem 4-13. Assume that the company uses the FIFO method rather than the weighted-average method in its process costing...

The auto repair shop of Quality Motor Company uses standards to control the labor time and labor cost in the shop. The standard labor cost for a motor tune-up is given below: The record showing the...

What is meant by the term time value of money? Why is a present value always less than the future value to which it relates?

Use co-variances derived in Appendix A to show the result in (4.8).

The data set cherry.dat, from Hand et al. (1994), contains measurements of diameter (inches), height (feet), and timber volume (cubic feet) for a sample of 31 black cherry trees. Diameter and height...

Jackson et al. (1987) compared the precision of systematic and stratified sampling for estimating the average concentration of lead and copper in the soil. The 1-km2 area was divided into 100-m...