Question

In: Accounting

                           Purchase Units  Unit Cost    Sold Units Beg.nventory    &

                           Purchase Units  Unit Cost    Sold Units

Beg.nventory          3000                  0.60$

            Dec3           4000             0.74$

Dec5                                                                  4400

Dec17    2200    0.80$

Dec22    2100

Compute ending inventory and cost of goods sold using moving- average cost, assuming the Company uses the perpetual inventory system

Solutions

Expert Solution

First of all format of data is confusing. I am assuming the Dec 5 and Dec 22 units are sold units and other are purchases.

Calculation of ending inventory and cost of goods sold using moving- average cost, assuming the Company uses the perpetual inventory system

Perpetual Moving Average

Goods Purchased

Cost of Goods Sold

Inventory Balance

# of units

Unit Cost

Cost per unit

# of units

Cost per unit

Cost of goods sold

Total Cost of Goods (a)

Total Available Units (b)

Unit Average Cost (a/b)

Beginning Inventory

$1,800.00

3000

$0.6000

Purchases Dec.3

4000

$0.74

$2,960.00

$1,800.00

3000

$2,960.00

4000

$4,760.00

7000

$0.6800

Sales Dec.5

4400

$0.68

$2,992.00

$1,768.00

2600

$0.6800

Purchases Dec.17

2200

$0.80

$1,760.00

$1,768.00

2600

$1,760.00

2200

$3,528.00

4800

$0.7350

Sales Dec.22

2100

$0.7350

$1,543.50

$1,984.50

2700

$0.7350

TOTAL

$4,535.50

Cost of Goods Sold = $4,535.50

Ending Inventory = $1,984.50

Hope the above calculations, working and explanations are clear to you and help you in understanding the concept of question.... please rate my answer...in case any doubt, post a comment and I will try to resolve the doubt ASAP…thank you


Related Solutions

Units Sold to Break Even, Unit Variable Cost, Unit Manufacturing Cost, Units to Earn Target Income...
Units Sold to Break Even, Unit Variable Cost, Unit Manufacturing Cost, Units to Earn Target Income Werner Company produces and sells disposable foil baking pans to retailers for $2.50 per pan. The variable cost per pan is as follows: Direct materials $0.30 Direct labor 0.57 Variable factory overhead 0.74 Variable selling expense 0.17 Fixed manufacturing cost totals $136,541 per year. Administrative cost (all fixed) totals $18,619. Required: 1. Compute the number of pans that must be sold for Werner to...
If 12,500 units are produced and sold, what is the variable cost per unit produced and sold?
Martinez Company’s relevant range of production is 7,500 units to 12,500 units. When it produces and sells 10,000 units, its average costs per unit are as follows:  Average Cost Per UnitDirect materials$ 5.60Direct labor$ 3.10Variable manufacturing overhead$ 1.40Fixed manufacturing overhead$ 4.00Fixed selling expense$ 2.60Fixed administrative expense$ 2.20Sales commissions$ 1.20Variable administrative expense$ 0.454. If 12,500 units are produced and sold, what is the variable cost per unit produced and sold? (Round your answer to 2 decimal places.)
Use the following data of Makrel ​Sales, Inc.: Unit Total Units Units Cost Cost Sold Beginning...
Use the following data of Makrel ​Sales, Inc.: Unit Total Units Units Cost Cost Sold Beginning inventory 18 $6 $108 Purchase on Apr 25 35 7 245 Purchase on Nov 16 13 10 130 Sales 45 ? ? MakrelMakrel ​Sales' LIFO cost of ending inventory would be A.$186. B.$129. C.$154. D.$450.
1. If 18,000 units are produced and sold, what is the variable cost per unit produced and sold?
Refer to the data given in Exercise 1-7. Answer all questions independently.  Kubin Company's relevant range of production is 18,000 to 22,000 units. When it produces and sells 20,000 units, its average costs per unit are as follows:   Required: 1. If 18,000 units are produced and sold, what is the variable cost per unit produced and sold? 2. If 22,000 units are produced and sold, what is the variable cost per unit produced and sold? 3. If 18,000 units are...
Price per Unit Variable Cost per Unit Units Sold per Year Basic $ 700 $ 220...
Price per Unit Variable Cost per Unit Units Sold per Year Basic $ 700 $ 220 700 Retest 1,050 580 200 Vital 4,600 3,100 100 Variable costs include the labor costs of the medical technicians at the lab. Fixed costs of $490,000 per year include building and equipment costs and the costs of administration. A basic "unit" is a routine drug test administered. A retest is given if there is concern about the results of the first test, particularly if...
month of 05/2020 = 140 units sold. 05/01 Inventory Units Unit cost Total cost 05/15 Purchases...
month of 05/2020 = 140 units sold. 05/01 Inventory Units Unit cost Total cost 05/15 Purchases 6 5 $13 $ 845 05/24 Purchases 5 4 16 864 Totals 7 5 17 1275 1 9 4 2984 Ending invent.@ 05/31 and cost of goods sold using FIFO/LIFO FIFO LIFO End Inventory 05/31 ? ? Cost o f goods sold ? ? Needing some help with homework Thanks!
Coopers Company reported the following information: Units Unit Cost Units Sold Jan 1 Beginning inventory 190...
Coopers Company reported the following information: Units Unit Cost Units Sold Jan 1 Beginning inventory 190 $50 Mar 8 Sale 100 Apr 10 Purchase 320 55 Jun 20 Sale 240 Oct 10 Purchase 570 60 Nov 30 Sale 450 Total Selling price per unit during the year: $75    790 Required Complete the following table. Cost Total Periodic Perpetual Date Purchased per Unit Cost Sold FIFO Weighted Average Units $ $ Units Units $ $ Units $ $
Philips Company has the following data available Transaction Units purchased Unit cost Units sold Transaction 300...
Philips Company has the following data available Transaction Units purchased Unit cost Units sold Transaction 300 10 March 1 Purchase 200 12 April 25 sale 330 June 10 Purchase 370 14 July 20 sale 250 October 30 Purchase 340 11 December 15 sale 390 if Philips uses a perpetual FIFO inventory system, the cost of ending inventory on Dec 31 is I need the steps in the form of table
Potter Company has the following data​ available: Transaction Units Purchased Unit Cost Units Sold Beginning Inventory...
Potter Company has the following data​ available: Transaction Units Purchased Unit Cost Units Sold Beginning Inventory 500 ​$10 March 1 Purchase 200 ​$12 April 25 Sale 350 June 10 Purchase 300 ​$14 July 20 Sale 250 October 30 Purchase 300 ​$15 December 15 Sale 400 If Potter Company uses a perpetual movingminus average inventory​ system, the cost of goods sold for the year is​ ________. ​ (Round average cost per unit to four decimal places and all other numbers to...
Sales (16,000 units × $211 per unit) $ 3,376,000 Cost of goods sold Direct materials $...
Sales (16,000 units × $211 per unit) $ 3,376,000 Cost of goods sold Direct materials $ 400,000 Direct labor 688,000 Production supplies 448,000 Plant manager salary 200,000 1,736,000 Gross profit 1,640,000 Selling expenses Sales commissions 128,000 Packaging 256,000 Advertising 100,000 484,000 Administrative expenses Administrative salaries 250,000 Depreciation—office equip. 220,000 Insurance 190,000 Office rent 200,000 860,000 Income from operations $ 296,000 (1) Compute the total variable cost per unit. (2) Compute the total fixed costs. (3) Compute the income from operations...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT