Question: 1. a) Fill in the missing numbers in the inventory schedule using the weighted-average cost inventory valuation method. This company uses the perpetual inventory system.

Take me to the text Outdoor Company uses the perpetual inventory system

and its inventory consists of four products as at March 31, 2022.

1. a) Fill in the missing numbers in the inventory schedule using the weighted-average cost inventory valuation method. This company uses the perpetual inventory system.

Do not enter dollar signs or commas in the input boxes.
Round all answers to 2 decimal places. All unit cost calculations should be rounded to 2 decimal places as well.
 

Inventory Schedule
 PurchasesSalesBalance
TransactionDescriptionQuantityAmountQuantityAmountQuantityAmount
 Opening Balance    0$ 0
May 5Purchase from AAA Co.400$4,800.00Answer$AnswerAnswer$Answer
May 7Sale to SSS Co.Answer$AnswerAnswer$Answer200$2,400.00
May 13Sale to TTT Co.Answer$Answer100$AnswerAnswer$Answer
May 15Purchase from BBB Co.100$1,900.00Answer$AnswerAnswer$Answer
May 24Sale to UUU Co.Answer$Answer50$AnswerAnswer$Answer
May 28Purchase from CCC Co.60$780.00Answer$AnswerAnswer$Answer


 

b) If the FIFO method had been used, what would the value of COGS been for the sale to UUU Co.?

COGS = $Answer


 

c) If the specific identification method had been used, what would the value of COGS been for the sale to UUU Co.? Assume all the units were purchased from BBB Co.

COGS = $Answer

 

2. Drago Company has a fiscal year end on December 31. The company has only one product in inventory, and all units of that product are identical (homogenous). The opening balance unit price is $12 per unit. Complete the following schedule to calculate the value of ending inventory using the weighted-average cost method under the perpetual inventory system. Then calculate the cost of goods sold for the year 2022.

Do not enter dollar signs or commas in the input boxes.

Round all answers to 2 decimal places.

DatePurchasesSalesBalance
 QuantityCostQuantityCostQuantityValue
Jan 26    100$Answer
Feb 1814$13.00  114$Answer
Mar 632$15.00  146$Answer
Apr 27  15$12.75131$Answer
Jul 2117$17.00  148$Answer
Sep 3  34$13.24114$Answer
Nov 16  11$13.24103$Answer


 

Required


 

Calculate the cost of goods sold.


 

Cost of Goods Sold = $Answer

 

3. An inventory record card for item M-405 shows the following details in 2022.

DatePurchasesSalesBalance
 QuantityCost/UnitQuantityCost/UnitQuantityCost/Unit 
Mar 1    55$68 
Mar 5  37$6818$68 
Mar 9    18$68 
 119$70  119$70 
Mar 18  18$68   
   51$7068$70 
Mar 24    68$70 
 44$73  44$73 
Mar 29  68$70   
   27$7317$73 
Mar 31    17$73 
 42$77  42$77 


 

Required


 

The company uses the FIFO cost method for inventory valuation under the perpetual inventory system. Calculate the cost of goods sold for the month, and the value of ending inventory at the end of March.


 

Do not enter dollar signs or commas in the input boxes.

Cost of Goods Sold = $Answer

Ending Inventory = $Answer

 


4. GB, a bookseller, had the following transactions during the month of March 2022 and uses the perpetual inventory system.

DateTransactionPurchasesSalesBalance
  QuantityCostQuantityCostQuantityCost
Mar 1     0$0
Mar 1Bought 25 novels at $32 each.25$32  25$32
Mar 4Bought 25 bags at $43 each.    25$32
  25$43  25$43
Mar 9Sold 7 bags.    25$32
    7$4318$43
Mar 17Bought 24 pencil cases at $5 each.    25$32
      18$43
  24$5  24$5
Mar 22Sold 6 bags.    25$32
    6$4312$43
      24$5
Mar 25Sold 9 pencil cases    25$32
      12$43
    9$515$5


 

Required


 

The company uses the specific identification cost method for inventory valuation. Calculate the cost of goods sold, and the value of ending inventory for March.


 

Do not enter dollar signs or commas in the input boxes.

Cost of Goods Sold = $Answer

Ending Inventory = $Answer

 

5. A company reported ending inventory of $81,000 in Year 1. It was discovered in Year 2 that the correct value of the ending inventory was $109,000 for Year 1, and a correction was made. Complete the following table based on this information. Assume the company uses the perpetual inventory system.

Do not enter dollar signs or commas in the input boxes.

Enter a negative sign as appropriate for the Profit(Loss) line item.

ItemReportedCorrect Amount
Inventory$81,000$Answer
Current Assets$187,000$Answer
Total Assets$590,000$Answer
Owner's Equity, Year 1$192,000$Answer
Sales$1,020,000$Answer
Cost of Goods Sold$510,000$Answer
Profit (Loss) for Year 1$13,000$Answer


6. A company has three types of products: gadgets, widgets, and gizmos. The cost and market price of each type is listed below. Complete the table by applying the lower of cost and net realizable value (LCNRV).

Do not enter dollar signs or commas in the input boxes.

 LCNRV Applied to
DescriptionCategoryCostNRVIndividualCategoryTotal
Gadget Type 1Gadgets$950$1,080$Answer  
Gadget Type 2Gadgets$5,100$5,400$Answer  
Total Gadgets$Answer$Answer $Answer 
Widget AWidgets$110$110$Answer  
Widget BWidgets$230$60$Answer  
Total Widgets$Answer$Answer $Answer 
Gizmo 1Gizmos$2,320$2,110$Answer  
Gizmo 2Gizmos$2,000$2,210$Answer  
Total Gizmos$Answer$Answer $Answer 
Total$Answer$Answer$Answer$Answer$Answer

Take me to the text Outdoor Company uses the perpetual inventory system and its inventory consists of four products as at March 31, 2022. Selected information is provided below. Required a) Calculate the inventory value that should be reported on March 31, 2022, using the LCNRV applied on an individual item basis. Do not enter dollar signs or commas in the input boxes. Product Number of Units Cost (per unit) NRV (per unit) LCNRV (per unit) 1 15 $99 $119 $ 2 3 4 50 50 40 Inventory Value Total LCNRV Inventory Value = $ LA $ $94 $70 $107 GA $ $63 $ $53 $ $167 $

Step by Step Solution

3.37 Rating (150 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

1 a Weightedaverage Inventory Schedule Purchases Sales Balance Transaction Description Unit Cost Quantity Amount Quantity Amount Quantity Amount Opening Balance 0 0 May05 Purchase from AAA Co 12 400 4... View full answer

blur-text-image
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!