Question

In: Accounting

Dec. 31 Ending inventory q:145 selling price:19 Jan. 2 Purchase q:90 selling price:21 Jan. 6 Sale...

Dec. 31 Ending inventory q:145 selling price:19

Jan. 2 Purchase q:90 selling price:21

Jan. 6 Sale q:166 seling price:43

Jan. 9 Purchase q:75 selling price:23

Jan. 10 Sale q:52 Selling price:48

Jan. 23 Purchase q:94 selling price:24
Jan. 30 Sale q:143 selling price:51

calculate average cost for each unit

Solutions

Expert Solution

SOLUTION =

WE ASSUME THAT ENTITY ELECT TO USE THE WEIGHTED AVERAGE COST METHOD

CALCULATION OF WEIGHTED AVERAGE COST PER UNIT FOR MONTH OF JANUARY

PARTICULARS

CHANGE IN QUANTITY UNIT COST TOTAL ACTUAL COST(CHANGE IN QUANTITY*COST / UNIT)
BEGINNING INVENTORY 145 19 2,755
PURCHASE (JAN 2) 90 21 1,890
SALE ( JAN 6) -166 - -
PURCHASE (JAN 9) 75 23 1,725
SALE (JAN 10) -52 - -
PURCHASE (JAN 23) 94 24 2,256
SALE ( JAN 30) -143 - -
TOTAL 43 8,626

AS PER TABLE TOTAL NUMBER OF UNITS = OPENING INVENTORY + PURCHASE =145+259 = 404

TOTAL COST = 8,626

WEIGHTED AVERAGE COST PER UNIT = TOTAL COST/NUMBER OF UNITS PURCHASED

= 8,626/404 = 21.35/UNIT

VALUATION OF ENDING INVENTORY = ENDING INVENTORY * AVERAGE COST / UNIT

=43*21.35 = 918.05

IF THE ENTITY USING PERPECTUAL INVENTORY SYSTEM WE WOULD HAVE TO RECOMPUTE THE WEIGHTED AVERAGE COST AFTER EVERY TRANSACTION AS BELOW >

PARTICULAR QUANTITY QUANTITY WITH US PURCHSE COST OF SALES TOTAL COST OF INVENTORY INVENTORY MOVING AVG. UNIT COST
BEGINNING INVENTORY 145 145 - - 145*19=2,755 19
PURCHASE 90 235 1,890 - 2,755+1890=4,645 4,645/235=19.76
SALE 166 69 166*19.76=3280.16 4645-3280.16=1364.84 1364.84/69=19.78
PURCHASE 75 144 1725 1725+1364.84=3089.84 3089.84/144=21.45
SALE 52 92 52*21.45=1115.4 3089.84-1115.4=1974.44 1974.44/92=21.45
PURCHASE 94 186 2256 2256+1974.44=4230.44 4230.44/186=22.74
SALE 143 43 143*22.74=3,251.82 4230.44-3251.82=978.59 978.59/43=22.74
TOTAL 5871 7647.38

WE CAN SEE THAT COST OF GOODS SOLD + INVENTORY BALANCE (7647.38+978.59) = 8,625.97 IS SAME AS LAST TABLE 8626 ( ROUNDING OFF DIFFERENCE) BUT MOVING WEIGHTED AVERAGE CALCULATIONS ARE SLIGHTLY DIFFERENT.


Related Solutions

Bidiyah Sugar Factory had the following data: Jan. 1, 2019 Dec. 31, 2019 Raw materials inventory...
Bidiyah Sugar Factory had the following data: Jan. 1, 2019 Dec. 31, 2019 Raw materials inventory RO 80,000 RO 64,000 Work in process inventory 104,000 116,000 Finished goods inventory 100,000     92,000 During 2019, the company purchased RO 1,450,000 of materials, had a direct labor costs of RO 250,000, and manufacturing overhead was RO160,000. The cost of goods manufactured is: Select one: a. 1,684,000 b. 1,864,000 c. 1,610,000 d. 410,000 e. None of the answers are correct
A company is selling 2 types of bicycles with sales as follows: Selling price   Purchase cost  ...
A company is selling 2 types of bicycles with sales as follows: Selling price   Purchase cost   commission on sale Model Y   600 370 50   Model Z   400    300    25   The 2/3 of bicycles sold is model Z. Fixed cost is : EUR 36.000. Considering that the sales mix is fixed: A.   What is the break even point in money for the shop . B.   How many bicycles from each category should be sold so that the net profit...
Beg Inventory 50 units at $5 each Purchase 10 units at $6 each Sale 30 units...
Beg Inventory 50 units at $5 each Purchase 10 units at $6 each Sale 30 units at $15 each Purchase 10 units at $7 each Sale 25 unites at $15 each a .)Find Cost of Goods Sold and Ending Inventory using the FIFO method B.)Find Cost of Goods Sold and Ending Inventory using the LIFO - Perpetual
Problem 2. Given the following information, determine the cost of ending inventory at December 31: December...
Problem 2. Given the following information, determine the cost of ending inventory at December 31: December 2: 5 units were purchased at $7 per unit. December 9: 10 units were purchased at $9.40 per unit. December 11: 12 units were sold at $35 per unit December 15: 20 units were purchased at $10.15 per unit December 22: 18 units were sold at $35 per unit Use the above information for parts a, b and c. a> (14 points) Use the...
Given the following information, determine the cost of ending inventory at December 31: December 2: 5...
Given the following information, determine the cost of ending inventory at December 31: December 2: 5 units were purchased at $7 per unit. December 9: 10 units were purchased at $9.40 per unit. December 11: 12 units were sold at $35 per unitDecember 15: 20 units were purchased at $10.15 per unit December 22: 18 units were sold at $35 per unit Use the above information for parts a, b and c. a. Use the LIFO , Last In First...
Exercise 6-21 Complete the accounting cycle using inventory transactions (LO6-2, 6-3, 6-5, 6-6, 6-7) Skip to...
Exercise 6-21 Complete the accounting cycle using inventory transactions (LO6-2, 6-3, 6-5, 6-6, 6-7) Skip to question [The following information applies to the questions displayed below.] On January 1, 2021, the general ledger of Big Blast Fireworks includes the following account balances: Accounts Debit Credit Cash $ 24,500 Accounts Receivable 43,000 Allowance for Uncollectible Accounts $ 2,900 Inventory 43,000 Land 81,100 Accounts Payable 28,700 Notes Payable (6%, due in 3 years) 43,000 Common Stock 69,000 Retained Earnings 48,000 Totals $...
Date Transaction Units Cost Sell 1/1 Beginning inventory 1,700 $28 3/6 Sale 1,100 $38 6/26 Purchase...
Date Transaction Units Cost Sell 1/1 Beginning inventory 1,700 $28 3/6 Sale 1,100 $38 6/26 Purchase 3,100 29 8/2 Purchase 2,100 30 10/31 Sale 3,500 40 (e) Periodic system, weighted-average cost flow. (f) Perpetual system, moving-average cost flow.
No. 2  Dan Tire has the following inventory records for the month ending July 31, 2011: Units          Unit...
No. 2  Dan Tire has the following inventory records for the month ending July 31, 2011: Units          Unit Cost Beginning Inventory             100             $18.00 Purchased July 10                  400             $15.00 Purchased July 18                  300            $17.00 Purchased July28                   200            $16.00 Dan Tire sold 140 tires on July 11 and 300 tires on July 27.  Compute the ending inventory and the cost of goods sold under the periodic inventory system using the three methods listed below. FIFO, LIFO, Weighted-average
Q 2?Rafique Inc. makes product A and sells at selling price of SAR 45 per unit....
Q 2?Rafique Inc. makes product A and sells at selling price of SAR 45 per unit. Badr Inc. wants to buy 5,000 units at SAR 27 per unit. Rafique Inc. has a normal capacity of 101,000 units and projected sales to regular customers this year is 92,000 units. Per unit costs traceable to the product (based on normal capacity of 92,000 units) are listed below? Direct Materials??8.1 Direct Labour?`??6.0 Variable Mfg. Overhead?6.2 Fixed mfg. overhead??4.8 Fixed administrative costs?0.8 Fixed Selling...
Q 2?Rafique Inc. makes product A and sells at selling price of SAR 45 per unit....
Q 2?Rafique Inc. makes product A and sells at selling price of SAR 45 per unit. Badr Inc. wants to buy 5,000 units at SAR 27 per unit. Rafique Inc. has a normal capacity of 101,000 units and projected sales to regular customers this year is 92,000 units. Per unit costs traceable to the product (based on normal capacity of 92,000 units) are listed below? Direct Materials??8.1 Direct Labour?`??6.0 Variable Mfg. Overhead?6.2 Fixed mfg. overhead??4.8 Fixed administrative costs?0.8 Fixed Selling...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT