Question

In: Accounting

Sharon Lee Company was formed on December 1, 2019. The following information is available from Lee’s...

Sharon Lee Company was formed on December 1, 2019. The following information is available from Lee’s inventory records for Product BAP.

Units

Unit Cost

January 1, 2020 (beginning inventory) 1,440 $ 8
Purchases:
   January 5, 2020 2,880 9
   January 25, 2020 3,120 10
   February 16, 2020 1,920 11
   March 26, 2020 1,440 12

A physical inventory on March 31, 2020, shows 3,840 units on hand.

(c2)

Compute the ending inventory at March 31, 2020, under Weighted-average inventory method. (Round answer to 0 decimal places, e.g. 2,760.)

Weighted-Average

Ending Inventory at March 31, 2020 $

Solutions

Expert Solution

Ending Inventory on March 31, 2020 = $38,054 or $38,059

Working

Units Cost per unit value
Beginning Balance 1440 $                     8.00 $ 11,520
Purchases
2880 $                     9.00 $ 25,920
3120 $                   10.00 $ 31,200
1920 $                   11.00 $ 21,120
1440 $                   12.00 $ 17,280
Cost of goods available for sale 10800 $ 107,040

.

Average Cost of Inventory
Units (A) 10800
Total Cost (B) $ 107,040
Average Cost (C=B/A) $ 9.91

.

Weighted Average method
Total Units Available for sale 10800
Units Sold 6960
Closing Stock in Units 3840
Valuation
Ending Inventory 3840 @ $               9.91 $            38,059

Related Solutions

Sarah Allen Company was formed on December 1, 2019. The following information is available from Allen’s...
Sarah Allen Company was formed on December 1, 2019. The following information is available from Allen’s inventory records for Product BAP. Units Unit Cost January 1, 2020 (beginning inventory) 1,620 $ 8 Purchases:    January 5, 2020 3,240 9    January 25, 2020 3,510 10    February 16, 2020 2,160 11    March 26, 2020 1,620 12 A physical inventory on March 31, 2020, shows 4,320 units on hand. a. Prepare schedule to compute the ending inventory at March 31, 2020, under FIFO inventory...
CHO Company was formed on December 1, 2009. The following information is available from Jones's inventory...
CHO Company was formed on December 1, 2009. The following information is available from Jones's inventory record for Product X.                                                                                                                Units        Unit Cost             January 1, 2010 (beginning inventory)                                      1,600             $18.00             Purchases:                   January 5, 2010                                                                    2,600             $20.00                   January 25, 2010                                                                  2,400             $21.00                   February 16, 2010                                                                1,000             $22.00                   March 15, 2010                                                                    1,800             $23.00 A physical inventory on March 31, 2010, shows 2,500 units on hand. Prepare schedules to compute the ending inventory at March 31,...
Ivanhoe Company was formed on December 1, 2016. The following information is available from Ivanhoe’s inventory...
Ivanhoe Company was formed on December 1, 2016. The following information is available from Ivanhoe’s inventory records for Product BAP. Units Unit Cost January 1, 2017 (beginning inventory) 732 $ 8.00 Purchases:    January 5, 2017 1,464 9.00    January 25, 2017 1,586 10.00    February 16, 2017 976 11.00    March 26, 2017 732 12.00 A physical inventory on March 31, 2017, shows 1,952 units on hand. -Prepare schedule to compute the ending inventory at March 31, 2017, under FIFO inventory method. -Prepare...
Shamrock Company was formed on December 1, 2016. The following information is available from Shamrock’s inventory...
Shamrock Company was formed on December 1, 2016. The following information is available from Shamrock’s inventory records for Product BAP. Units Unit Cost January 1, 2017 (beginning inventory) 726 $ 7.00 Purchases: January 5, 2017 1,452 8.00 January 25, 2017 1,573 9.00 February 16, 2017 968 10.00 March 26, 2017 726 11.00 A physical inventory on March 31, 2017, shows 1,936 units on hand. 1) Prepare schedule to compute the ending inventory at March 31, 2017, under LIFO inventory method....
ACD Company was formed on December 1, 2018. The following information is available from ACD's inventory...
ACD Company was formed on December 1, 2018. The following information is available from ACD's inventory record for Product X.                                                                                                                Units        Unit Cost             January 1, 2019 (beginning inventory)                                      1,600             £18.00             Purchases:                   January 5, 2019                                                                    2,600             £20.00                   January 25, 2019                                                                  2,400             £21.00                   February 16, 2019                                                                1,000             £22.00                   March 15, 2019                                                                    1,800             £23.00 A physical inventory on March 31, 2019, shows 2,500 units on hand. Instructions Prepare schedules assuming the periodic method to compute the...
CHO Company was formed on December 1, 2009. The following information is available from Jones's inventory...
CHO Company was formed on December 1, 2009. The following information is available from Jones's inventory record for Product X.                                                                                                                     Units       Unit Cost              January 1, 2010 (beginning inventory)                                       1,600     $18.00              Purchases:                    January 5, 2010                                                                      2,600     $20.00                    January 25, 2010                                                                    2,400     $21.00                    February 16, 2010                                                                  1,000     $22.00                    March 15, 2010                                                                      1,800     $23.00 A physical inventory on March 31, 2010, shows 2,500 units on hand. Prepare schedules to compute the ending inventory at March 31,...
Riverbed Company was formed on December 1, 2016. The following information is available from Riverbed’s inventory...
Riverbed Company was formed on December 1, 2016. The following information is available from Riverbed’s inventory records for Product BAP. Units Unit Cost January 1, 2017 (beginning inventory) 732 $ 8.00 Purchases:    January 5, 2017 1,464 9.00    January 25, 2017 1,586 10.00    February 16, 2017 976 11.00    March 26, 2017 732 12.00 A physical inventory on March 31, 2017, shows 1,952 units on hand. Prepare schedule to compute the ending inventory at March 31, 2017, under FIFO inventory method. Units...
The following information is available for the OLIVIA Company for the month of December 2019 1....
The following information is available for the OLIVIA Company for the month of December 2019 1. On December 31, 2019 the balance in the company's Cash account has a balance of $16,297 . 2. The company's bank statement shows a balance December 31, 2019 of $19,522 . 3. Outstanding checks at December 31, 2019 total $ 2,877 . 4. A deposit placed in the bank's night depository on December 31, 2019 totaling $ 1,676 did not appear on the bank...
The following information is available from TJ Foods Inc. for the year ended December 31, 2019:...
The following information is available from TJ Foods Inc. for the year ended December 31, 2019:                            At Cost At Retail Sales 100000 Purchases 48000   90000 Inventory January 1, 2019    24000 54000 Net Additional Markups 12000 Net Markdowns 6000 Required a)What is the inventory cost on December 31, 2019 under the average cost retail method (Non LCM)? b) What is the inventory cost on December 31, 2019 under the retail method on FIFO...
Frate Company was formed on December 1, 2015, and uses the periodic inventory system. The following information is available from Frate's inventory records for Product Ply:
Frate Company was formed on December 1, 2015, and uses the periodic inventory system. The following information is available from Frate's inventory records for Product Ply:UnitsUnit CostJanuary 1, 2016 (beginning inventory)3,600$10.00Purchases:      January 6, 20164,30011.00      January 25, 20164,00011.50      February 17, 20163,40012.00      March 27, 20163,70012.50A physical inventory on March 31, 2016 shows 7,200 units on hand.Required:For each method, enter your answers in chronological order.Prepare schedules to compute the ending inventory at March 31, 2016, under each of the following inventory methods:(For the weighted average method, round...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT