The Wine Hut of Napa Valley, provided you with the following inventory record showingthe inventory details during the month of March 2022 for a private reserve Francis FordCoppola Merlot Wine:Inventory,Purchases:Inventory Detail - Coppola MerlotFor Month of March 2022March 1March 12March 23Bottles540110200Bottle Cost$20.0021.0022.00A physical inventory on March 31st indicates there are 450 units on hand.Calculate the value of ending inventory as of March 31st and the cost of goods sold forthe month of March assuming the company uses the LIFO inventory system.Important: You must show your detailed calculations, do NOT just provide an answer.

LIFO method is one of the methods of inventory valuation in which it is assumed that recent or new…

The Wine Hut of Napa Valley, provided you with the following inventory record showing the inventory details during the month of March 2022 for a private reserve Francis Ford Coppola Merlot Wine: Inventory Detail - Coppola Merlot For Month of March 2022 Bottles 540 110 200 Inventory, March 1 Purchases: March 12 March 23 Bottle Cost $20.00 21.00 22.00 A physical inventory on March 31st indicates there are 450 units on hand. Calculate the value of ending inventory as of March 31st and the cost of goods sold for the month of March assuming the company uses the LIFO inventory system. Important: You must show your detailed calculations, do NOT just provide an answer.

The Wine Hut of Napa Valley, provided you with the following inventory record showing the inventory details during the month of March 2022 for a private reserve Francis Ford Coppola Merlot Wine: Inventory Detail - Coppola Merlot For Month of March 2022 Bottles 540 110 200 Inventory, March 1 Purchases: March 12 March 23 Bottle Cost $20.00 21.00 22.00 A physical inventory on March 31st indicates there are 450 units on hand. Calculate the value of ending inventory as of March 31st and the cost of goods sold for the month of March assuming the company uses the LIFO inventory system. Important: You must show your detailed calculations, do NOT just provide an answer.

Financial Accounting

15th Edition

ISBN:9781337272124

Author:Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:Carl Warren, James M. Reeve, Jonathan Duchac

Chapter7: Inventories

Section: Chapter Questions

Problem 4CP: Golden Eagle Company began operations on April 1 by selling a single product. Data on purchases and...

See similar textbooks

Similar questions

Maria B, Inc. uses a perpetual inventory system. This system includes a perpetual inventory record card for each of the 50 types of the products the company keep in stock. The following transactions show the purchase and sale of particular round table (product code AB-RB7) during November. Nov.1 Balance on hand, 50 units, cost $60 each…………………………………….$3,000 Nov.4Purchase, 20 Units, cost $65 each……………………………………………..$1300 Nov.8Sale, 35 units, Sale price $100 each…………………………………………...$3500 Nov.9 Purchase, 40 units, cost $65 each……………………………………………..$2600 Nov.20Sale, 60 units, sale price $100 each…………………………………………..$6000 Nov.25Purchase 40 units, cost $70 each…………………………………….……….$2800 Nov.30Sale 5 units sale price $110 each………………………………………...…….$550 Required: Record the beginning inventory, the purchases, the cost of goods sold, and the running balance on an inventory record card by Using Average Cost Method & LIFO method. Prepare journal entries to record these purchases and sales in…
Maria B, Inc. uses a perpetual inventory system. This system includes a perpetual inventory record card for each of the 50 types of the products the company keep in stock. The following transactions show the purchase and sale of particular round table (product code AB-RB7) during November. Nov.1 Balance on hand, 50 units, cost $60 each…………………………………….$3,000 Nov.4Purchase, 20 Units, cost $65 each……………………………………………..$1300 Nov.8Sale, 35 units, Sale price $100 each…………………………………………...$3500 Nov.9 Purchase, 40 units, cost $65 each……………………………………………..$2600 Nov.20Sale, 60 units, sale price $100 each…………………………………………..$6000 Nov.25Purchase 40 units, cost $70 each…………………………………….……….$2800 Nov.30Sale 5 units sale price $110 ea Maria B, Inc. uses a perpetual inventory system. This system includes a perpetual inventory record card for each of the 50 types of the products the company keep in stock. The following transactions show the purchase and sale of particular round table (product code AB-RB7)…
Sunshine Electronics Ltd records its inventory of Smile Luminous backpacks by using a perpetual inventory system on a FIFO basis. The following details are supplied for one particular popular make and model for the month of November. Complete the worksheet using FIFO, LIFO and Moving Average. 1 may Balance of 20 backpacks costed at $155 6 May Purchased 20 backpacks at $160 each 10 May Sold 15 backpacks at $300 each 15 May Purchased 10 backpacks at $180 each 18 May Sold 30 backpacks at $320 22 May Purchased 20 backpacks at $170 each 30 May Sold 12 backpacks at $310 each
Golden Eagle Company began operations on April 1 by selling a single product. Data on purchases and sales for the year are as follows: Purchases: Sales: The president of the company, Connie Kilmer, has asked for your advice on which inventory cost flow method should be used for the 32,000-unit physical inventory that was taken on December 31. The company plans to expand its product line in the future and uses the periodic inventory system. Write a brief memo to Ms. Kilmer comparing and contrasting the LIFO and FIFO inventory cost flow methods and their potential impacts on the companys financial statements.
You have been working with the Humber Room Restaurant to determine the best method to value physical inventory. The following information is taken from the Humber Room Restaurant from the inventory records for the month of January: 1/1 Opening inventory 12 units @ $2.05 each 1/5 Purchased 22 units @ $2.75 1/12 Purchased 16 units @$1.75 1/19 Purchased 10 units @ $2.10 On January 31, the physical inventory indicated that 12 units remained on the shelf. The value on the shelf was 6 cans priced at $2.10 and 6 cans priced at $1.75 a.Determine the value of the closing inventory using the following methods 1.Actual purchase price method 2.FIFO 3.Last purchase price method 4.Weighted-average purchase price methodLast purchase price method 5.LIFO b.After analyzing the physical inventory based on the five methods in part a, what method would be "best suited" for the Humber Room Restaurant? Explain your answer in full sentences
Sylvester has a bird shop that sells canaries. Sylvester maintains accurate records on the number of birds purchased from its suppliers and the number sold to customers. The records show the following purchases and sales during 2021. Date Transactions Units Cost per Unit Total Cost January 1 Beginning inventory 35 $40 $ 1,400 April 14 Purchase 80 42 3,360 August 22 Purchase 130 44 5,720 October 29 Purchase 95 46 4,370 340 $14,850 Jan. 1–Dec. 31 Sales ($60 each) 280 Sylvester uses a periodic inventory system and believes there are 60 birds remaining in ending inventory. However, Sylvester neglects to make a final inventory count at the end of the year. An employee accidentally left one of the cages open one night and 10 birds flew away, leaving only 50 birds in ending inventory. Sylvester is not aware of the lost canaries. Required: 1. What amount will Sylvester calculate for ending inventory and cost of goods sold using FIFO, assuming he erroneously believes…
Please answer in 30 mins. You have been working with the Humber Room Restaurant to determine the best method to value physical inventory. The following information is taken from the Humber Room Restaurant from the inventory records for the month of January: 1/1 Opening inventory 12 units @ $2.05 each 1/5 Purchased 22 units @ $2.75 1/12 Purchased 16 units @$1.75 1/19 Purchased 10 units @ $2.10 On January 31, the physical inventory indicated that 12 units remained on the shelf. The value on the shelf was 6 cans priced at $2.10 and 6 cans priced at $1.75 a.Determine the value of the closing inventory using the following methods : 1.Actual purchase price method 2.FIFO 3.Last purchase price method 4.Weighted-average purchase price methodLast purchase price method 5.LIFO b.After analyzing the physical inventory based on the five methods in part a, what method would be "best suited" for the Humber Room Restaurant? Explain your answer in full sentences.
Executive Suites, Inc., uses a perpetual inventory system. This system includes a perpetual inventory record card for each of the 60 types of products the company keeps in stock. The following transactions show the purchases and sales of a particular desk chair (product code DC-7) during September. Sept. 1 Balance on hand. 50 units, cost $60 each........................$3,000 Sept. 4 Purchase, 20 units, cost $65 each........................................$1,300 Sept. 8 Sale, 35 units. sales price $100 each...................................$3,500 Sept. 9 Purchase, 40 units, cost $65 each........................................$2,600 Sept. 20 Sale, 60 units, sales price $100 each.................................$6,000 Sept. 25 Purchase, 40 units, cost $70 each.......................................$2,800 Sept. 30 Sale, 5 units, soles price $110 each.....................................$550a. Record the beginning inventory, the purchases, the cost of goods sold, and the running balance…
Samuelson and Messenger (SAM) began 2018 with 200 units of its one product. These units were purchasednear the end of 2017 for $25 each. During the month of January, 100 units were purchased on January 8 for $28each and another 200 units were purchased on January 19 for $30 each. Sales of 125 units and 100 units weremade on January 10 and January 25, respectively. There were 275 units on hand at the end of the month. SAMuses a periodic inventory system. Calculate ending inventory and cost of goods sold for January using (1) FIFO,and (2) average cost.
Salt and Mineral (SAM) began 2024 with 330 units of its one product. These units were purchased near the end of 2023 for $20 each. During the month of January, 165 units were purchased on January 8 for $23 each and another 330 units were purchased on January 19 for $25 each. Sales of 170 units and 200 units were made on January 10 and January 25, respectively. There were 455 units on hand at the end of the month. SAM uses a perpetual inventory system. Required: Complete the below table to calculate ending inventory and cost of goods sold for January using FIFO. Complete the table to calculate ending inventory and cost of goods sold for January.
RMPW makes and sells premium Ultimate Ale and related products.All purchases and sales are made On credit . RMPW uses the perpetual inventory system. They also use the 3-way match to verify invoices and record purchases. Analyze the events below and complete the requirements. 1. June 15: Shipped and billed (sold) 50 cases of ale to Eagles bar for $500. Prepare invoice number 200. The ale cost RMPW $300. 2. July 17: Received $2,000 from Longhorn (customer) for goods that were delivered and billed the prior month. 3. July 31: Received invoice for $1000 from TD Hops for raw materials that have been received and ordered. RMPw performed the 3 way match. (Assume RMPW records purchases when they perform the 3way match) Requirements: for each event identify A) account (s) debited B) account (s) credited C) the special journal used to record the event D) any subsidiary ledgers updated from the event.
Required information Use the following information for the Quick Study below. Trey Monson starts a merchandising business on December 1 and enters into three inventory purchases: Purchases on December 7 15 units @ $18.00 cost Purchases on December 14 29 units @ $27.00 cost Purchases on December 21 25 units @ $32.00 cost QS 5-13 Periodic: Inventory costing with specific identification LO P1 Required:Monson sells 25 units for $45 each on December 15. Of the units sold, 12 are from the December 7 purchase and 13 are from the December 14 purchase and assume the periodic inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on specific identification.