Question

In: Accounting

Bramble Inc. is a retailer operating in British Columbia. Bramble uses the perpetual inventory method. All...

Bramble Inc. is a retailer operating in British Columbia. Bramble uses the perpetual inventory method. All sales returns from customers result in the goods being returned to inventory; the inventory is not damaged. Assume that there are no credit transactions; all amounts are settled in cash. You are provided with the following information for Bramble Inc. for the month of January 2020.

Date

Description

Quantity

Unit Cost or Selling Price

January 1 Beginning inventory 100 $21
January 5 Purchase 148 24
January 8 Sale 115 36
January 10 Sale return 10 36
January 15 Purchase 55 26
January 16 Purchase return 5 26
January 20 Sale 93 41
January 25 Purchase 26 28

Calculate the Moving-average cost per unit at January 1, 5, 8, 10, 15, 16, 20, & 25. (Round answers to 3 decimal places, e.g. 5.251.)

Moving-Average Cost per unit

January 1 $
January 5 $
January 8 $
January 10 $
January 15 $
January 16 $
January 20 $
January 25 $

Solutions

Expert Solution

Moving Method
Purchases Sales Ending Inventory Workings
DATE units Cost/Unit Total units Cost/Unit Total units Cost/Unit Total
Beginning Inventory 100 $      21.00 $ 2,100.00 [100 units @ $21]=$2,100
January 05 148 $    24.00 $ 3,552.00 248 $      22.79 $ 5,652.00 [$2,100+5,652]/[100+148]=$22.79
January 08 115 $      22.79 $ 2,620.89 133 $      22.79 $ 3,031.11 [$5,652-2,620.89]/[248-115]=$22.79
January 10 -10 $      22.79 $   -227.90 143 $      22.79 3259.02 [$3,031.11-[-227.90]]/[133-[-10]]=$22.79
January 15 55 $    26.00 $ 1,430.00 198 $      23.68 $ 4,689.02 [$3,259.02+1,430]/[143-55]=$23.68
January 16 -5 $    26.00 $   -130.00 193 $      23.62 $ 4,559.02 [$4,689.02-130]]/[198-5]]=$23.62
January 20 93 $      23.62 $ 2,196.83 100 $      23.62 $ 2,362.18 [$4,559.02-2,196.83]/[193-93]=$23.62
January 25 26 $    28.00 $     728.00 126 $      24.53 $ 3,090.18 [$3,090.18+728]/[100+26]=$24.53
Closing inventory 126 $ 3,090.18

***************************************

If you have any doubts, drop your messages in the comment box! Thank you!!!  ALL THE BEST!!!!
#STAY SAFE


Related Solutions

Bramble Inc. is a retailer operating in British Columbia. Bramble uses the perpetual inventory method. All...
Bramble Inc. is a retailer operating in British Columbia. Bramble uses the perpetual inventory method. All sales returns from customers result in the goods being returned to inventory; the inventory is not damaged. Assume that there are no credit transactions; all amounts are settled in cash. You are provided with the following information for Bramble Inc. for the month of January 2020. Date Description Quantity Unit Cost or Selling Price January 1 Beginning inventory 100 $14 January 5 Purchase 139...
Bramble Inc. is a retailer operating in British Columbia. Bramble uses the perpetual inventory method. All...
Bramble Inc. is a retailer operating in British Columbia. Bramble uses the perpetual inventory method. All sales returns from customers result in the goods being returned to inventory; the inventory is not damaged. Assume that there are no credit transactions; all amounts are settled in cash. You are provided with the following information for Bramble Inc. for the month of January 2020. Date Description Quantity Unit Cost or Selling Price January 1 Beginning inventory 100 $21 January 5 Purchase 148...
Mercer Inc. is a retailer operating in British Columbia. Mercer uses the perpetual inventory method. All...
Mercer Inc. is a retailer operating in British Columbia. Mercer uses the perpetual inventory method. All sales returns from customers result in the goods being returned to inventory; the inventory is not damaged. Assume that there are no credit transactions; all amounts are settled in cash. You are provided with the following information for Mercer Inc. for the month of January 2015.   Date     Description Quantity Unit Cost or Selling Price January 1 Beginning inventory 100 $18 January 5 Purchase...
Cheyenne Inc. is a retailer operating in British Columbia. Cheyenne uses the perpetual inventory method. All...
Cheyenne Inc. is a retailer operating in British Columbia. Cheyenne uses the perpetual inventory method. All sales returns from customers result in the goods being returned to inventory; the inventory is not damaged. Assume that there are no credit transactions; all amounts are settled in cash. You are provided with the following information for Cheyenne Inc. for the month of January 2020. For each of the following cost flow assumptions, calculate cost of goods sold, ending inventory, and gross profit....
Bramble Corp. is a retailer operating in Calgary, Alberta. Bramble Corp. uses the perpetual inventory method....
Bramble Corp. is a retailer operating in Calgary, Alberta. Bramble Corp. uses the perpetual inventory method. Assume that there are no credit transactions; all amounts are settled in cash. You are provided with the following information for Bramble Corp. for the month of January 2017. Date Description Quantity Unit Cost or Selling Price Dec. 31 Ending inventory 156 $18 Jan. 2 Purchase 109 20 Jan. 6 Sale 181 41 Jan. 9 Purchase 78 22 Jan. 10 Sale 48 46 Jan....
Problem 6-08A a1-a2 Vaughn Inc. is a retailer operating in British Columbia. Vaughn uses the perpetual...
Problem 6-08A a1-a2 Vaughn Inc. is a retailer operating in British Columbia. Vaughn uses the perpetual inventory method. All sales returns from customers result in the goods being returned to inventory; the inventory is not damaged. Assume that there are no credit transactions; all amounts are settled in cash. You are provided with the following information for Vaughn Inc. for the month of January 2020. Date Description Quantity Unit Cost or Selling Price January 1 Beginning inventory 100 $15 January...
Problem 6-08A a1-a2 (Part Level Submission) Bramble Inc. is a retailer operating in British Columbia. Bramble...
Problem 6-08A a1-a2 (Part Level Submission) Bramble Inc. is a retailer operating in British Columbia. Bramble uses the perpetual inventory method. All sales returns from customers result in the goods being returned to inventory; the inventory is not damaged. Assume that there are no credit transactions; all amounts are settled in cash. You are provided with the following information for Bramble Inc. for the month of January 2020. Date Description Quantity Unit Cost or Selling Price January 1 Beginning inventory...
Windsor, Inc. is a retailer operating in Calgary, Alberta. Windsor, Inc. uses the perpetual inventory method....
Windsor, Inc. is a retailer operating in Calgary, Alberta. Windsor, Inc. uses the perpetual inventory method. Assume that there are no credit transactions; all amounts are settled in cash. You are provided with the following information for Windsor, Inc. for the month of January 2017. Date Description Quantity Unit Cost or Selling Price Dec. 31 Ending inventory 155 $20 Jan. 2 Purchase 95 22 Jan. 6 Sale 163 38 Jan. 9 Purchase 71 24 Jan. 10 Sale 51 43 Jan....
Bieber Inc. is a retailer operating in Calgary, Alberta. Bieber Inc. uses the perpetual inventory method....
Bieber Inc. is a retailer operating in Calgary, Alberta. Bieber Inc. uses the perpetual inventory method. Assume that there are no credit transactions; all amounts are settled in cash. You are provided with the following information for Bieber Inc. for the month of January 2017. Date Description Quantity Unit Cost or Selling Price Dec. 31 Ending inventory 160 $20 Jan. 2 Purchase 100 22 Jan. 6 Sale 180 40 Jan. 9 Purchase 75 24 Jan. 10 Sale 50 45 Jan....
Tamarisk, Inc. is a retailer operating in Calgary, Alberta. Tamarisk, Inc. uses the perpetual inventory method....
Tamarisk, Inc. is a retailer operating in Calgary, Alberta. Tamarisk, Inc. uses the perpetual inventory method. Assume that there are no credit transactions; all amounts are settled in cash. You are provided with the following information for Tamarisk, Inc. for the month of January 2017. date description quantity unit cost or selling price Dec 31 ending inventory 174 20 Jan 2 purchase 98 22 Jan 6 sale 197 40 Jan 9 purchase 68 24 Jan 10 sale 50 45 Jan...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT