Question

In: Accounting

Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month...

Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month of October. Sandra's Purse Boutique uses a periodic inventory system.

Date Transactions Units Unit Cost Total Cost
October 1 Beginning inventory 6 $ 850 $ 5,100
October 4 Sale 4
October 10 Purchase 5 860 4,300
October 13 Sale 3
October 20 Purchase 4 870 3,480
October 28 Sale 7
October 30 Purchase 8 880 7,040
$ 19,920

Using weighted-average cost, calculate ending inventory and cost of goods sold at October 31. (Round your intermediate and final answers to 2 decimal places.)

Ending inventory-

Cost of goods sold-

Solutions

Expert Solution

Calculation of Cost of goods available for sale:

A B A x B
Date Transaction Units Unit Cost Total Cost
Oct-01 Beginning inventory 6 $850 $5,100
Oct-10 Purchase 5 $860 $4,300
Oct-20 Purchase 4 $870 $3,480
Oct-30 Purchase 8 $880 $7,040
23 $19,920

Cost of goods available for sale = $19,920

Number of units available for sale = 23

weighted-average cost per unit = Cost of goods available for sale/ Number of units available for sale

= 19,920/23

= $866.09

Number of units sold = 14

Cost of goods sold = Number of units sold x weighted-average cost per unit

= 14 x 866.09

= $12,125.26

Ending inventory units = Number of units available for sale- Number of units sold

= 23-14

= 9

Cost of ending inventory = Ending inventory units x weighted-average cost per unit

= 9 x 866.09

= $7,794.81

Ending inventory = $7,794.81

Cost of goods sold =$12,125.26

Please give a positive rating if you are satisfied with this solution and if you have any query kindly ask.

Thanks!!!


Related Solutions

Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month
Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month of October. Sandra's Purse Boutique uses a periodic inventory system.  Date   Transactions Units   Unit Cost   Total Cost October 1   Beginning inventory   6     $ 850       $ 5,100     October 4   Sale   4                       October 10   Purchase   5       860         4,300     October 13   Sale   3                       October 20   Purchase   4       870         3,480     October 28   Sale   7                       October 30   Purchase   8       880         7,040                               $ 19,920         Calculate ending inventory and cost of...
Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month...
Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month of October. Sandra's Purse Boutique uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost October 1 Beginning inventory 6 $ 710 $ 4,260 October 4 Sale 4 October 10 Purchase 5 720 3,600 October 13 Sale 3 October 20 Purchase 4 730 2,920 October 28 Sale 7 October 30 Purchase 7 740 5,180 $ 15,960 Required: 1. Calculate ending inventory and...
Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month...
Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month of October. Sandra's Purse Boutique uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost October 1 Beginning inventory 6 $ 850 $ 5,100 October 4 Sale 4 October 10 Purchase 5 860 4,300 October 13 Sale 3 October 20 Purchase 4 870 3,480 October 28 Sale 7 October 30 Purchase 8 880 7,040 $ 19,920 Using LIFO, calculate ending inventory and...
Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month...
Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month of October. Sandra's Purse Boutique uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost October 1 Beginning inventory 6 $ 700 $ 4,200 October 4 Sale 4 October 10 Purchase 5 710 3,550 October 13 Sale 3 October 20 Purchase 4 720 2,880 October 28 Sale 7 October 30 Purchase 8 730 5,840 $ 16,470 Required: 1. Calculate ending inventory and...
Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month...
Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month of October. Sandra's Purse Boutique uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost October 1 Beginning inventory 6 $ 790 $ 4,740 October 4 Sale 4 October 10 Purchase 5 800 4,000 October 13 Sale 3 October 20 Purchase 4 810 3,240 October 28 Sale 7 October 30 Purchase 8 820 6,560 $ 18,540 2. Using FIFO, calculate ending inventory...
Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month...
Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month of October. Sandra's Purse Boutique uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost October 1 Beginning inventory 6 $ 770 $ 4,620 October 4 Sale 4 October 10 Purchase 5 780 3,900 October 13 Sale 3 October 20 Purchase 4 790 3,160 October 28 Sale 7 October 30 Purchase 7 800 5,600 $ 17,280 2. Using FIFO, calculate ending inventory...
Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month...
Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month of October. Sandra's Purse Boutique uses a periodic inventory system.   Date Transactions Units Cost per Unit Total Cost   October 1 Beginning inventory 6 $700     $ 4,200        October 4 Sale 4   October 10 Purchase 5 710     3,550        October 13 Sale 3   October 20 Purchase 4 720     2,880        October 28 Sale 7   October 30 Purchase 8 730     5,840     ...
Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month...
Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month of October. Sandra's Purse Boutique uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost October 1 Beginning inventory 6 $ 900 $ 5,400 October 4 Sale 4 October 10 Purchase 5 910 4,550 October 13 Sale 3 October 20 Purchase 4 920 3,680 October 28 Sale 7 October 30 Purchase 7 930 6,510 $ 20,140 1. Calculate ending inventory and cost...
Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month...
Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month of October. Sandra's Purse Boutique uses a periodic inventory system.   Date Transactions Units Cost per Unit Total Cost   October 1 Beginning inventory 6 $870     $ 5,220        October 4 Sale 4   October 10 Purchase 5 880     4,400        October 13 Sale 3   October 20 Purchase 4 890     3,560        October 28 Sale 7   October 30 Purchase 7 900     6,300     ...
Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month...
Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month of October. Sandra's Purse Boutique uses a periodic inventory system.   Date Transactions Units Cost per Unit Total Cost   October 1 Beginning inventory 6 $760     $ 4,560        October 4 Sale 4   October 10 Purchase 5 770     3,850        October 13 Sale 3   October 20 Purchase 4 780     3,120        October 28 Sale 7   October 30 Purchase 8 790     6,320     ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT