Question

In: Accounting

Arizona Inc. uses the perpetual inventory system, and recorded the following data pertaining to raw material...

Arizona Inc. uses the perpetual inventory system, and recorded the following data pertaining to raw material X during January 2018:

Units

Date Received Cost Issued On Hand

Jan 1 Inventory $4.50 3,200

Jan 11 Sale ($18) 1,600 1,600

Jan 15 Purchase 1,000 $4.70 2,600

Jan 17 Sale ($18) 1,100 1,500

Jan 25 Purchase 1,500 $4.90 3,000

Round your answer to two decimals.

Instructions:

Determine the cost of sales, gross profit and inventory value of raw material X inventory at January 31, 2018 using the moving-weighted average method.

Determine the cost of sales, gross profit and inventory value of raw material X inventory at January 31, 2018 using the average cost method.

Expert Solution

a)Under moving average method ,average cost per unit is calculated at the time of every purchase .

Formula :Average cost per unit =Cost of inventory available for sale/Units available for sale

MOVING WEIGHTED AVERAGE METHOD
DATE	PURCHASE	COST OF SALES	INVENTORY AT END
	Quantity	Unit cost	Total	Quantity	Unit cost	Total	Quantity	Unit cost	Total
Jan 1							3200	4.50	14400
Jan 11				1600	4.50	7200	3200-1600=1600	4.50	7200
Jan 15	1000	4.70	4700				1600+1000=2600	[7200+4700]/2600 11900/2600 4.58	11900
Jan 17				1100	4.58	5038	2600-1100=1500	4.58	6862
Jan 25	1500	4.9	7350				1500+1500=3000	[6862+7350]/3000 4.74	14212
Total						12238

Sales revenue

Units sales	1600+1100=2700
unit selling price	18
Total sales revenue	48600

Cost of goods sold	12238
Gross profit (sales -cost of sales ))	48600-12238 = 36362
Inventory as on Jan 31	14212

2)

	Quantity	*	Unit cost	=	total
Beginning	3200		4.5		14400
Jan 15	1000		4.7		4700
Jan 25	1500		4.9		7350

Total	5700				26450

Average cost per unit = 26450 /5700

= $ 4.64

Cost of goods sold (unit sold *average cost per unit)	2700*4.64=12528
Gross profit (sales -cost of sales ))	48600-12528= 36072
Inventory as on Jan 31 (cost of goods available for sale -cost of sales)	26450-12528 = 13922

ekkarill92 answered 1 year ago

During January, Metro Co., which maintains a perpetual inventory system, recorded the following information pertaining to...

During January, Metro Co., which maintains a perpetual inventory system, recorded the following information pertaining to its inventory: Units Unit Total On Units Cost Cost Hand Balance on 1/1 1,000 $1 $1,000 1,000 Purchased on 1/7 600 3 1,800 1,600 Sold on 1/20 900 700 Purchased on 1/25 400 5 2,000 1,100 Under the moving-average method, what amount should Metro report as inventory at January 31? $3,300 $3,225 $2,640 $3,900

The inventory data of Bilal Inc. is provided below, The company uses perpetual inventory system. Inventory:...

The inventory data of Bilal Inc. is provided below, The company uses perpetual inventory system. Inventory: 1st March = 200 units @ $4.00 (purchased) Purchases: 12th March = 500 units @ $4.50 (purchased) 15th March = 400 units @ $4.75 (purchased) 17th March = 828 units @ $5.00 (purchased) Sales: 20th March = 1928 units sold Instructions Under a perpetual inventory system, determine the cost of goods sold and ending inventory for the month of March under FIFO method

Jaywall Corporation, which uses a perpetual inventory system, recorded the following inventory transactions during 20X3. ...

Jaywall Corporation, which uses a perpetual inventory system, recorded the following inventory transactions during 20X3. Units Unit Cost Units Selling Price April 1 Beginning inventory 45 $8 25 Purchase 150 9 May 4 Purchase 65 10 16 Sale 120 $16 June 4 Purchase 50 12 (a) Using the FIFO cost formula, calculate the amount of the cost of goods sold for the quarter ended June 30. (Show calculations) (b) Using the average cost formula, calculate the amount of ending...

Emmett Inc. uses a perpetual inventory system and had the following activity for a single inventory...

Emmett Inc. uses a perpetual inventory system and had the following activity for a single inventory item: 1. Calculate the value of COGS, Ending Inventory and Gross profit under FIFO and Moving Average. (round unit cost to two digits) Units Unit Cost 1-Jan inventory 510 100.00 Purchases 5-Jan 275 110.00 10-Jan 175 114.00 15-Jan 100 116.00 20-Jan 125 118.00 Sales 12-Jan 525 135.00 18-Jan 405 140.00 22-Jan 200 142.00

Tama Inc. uses a perpetual inventory system and had the following activity for a single inventory...

Tama Inc. uses a perpetual inventory system and had the following activity for a single inventory item: Units Unit Cost Total Cost May 1, inventory 140 $2.50 $350 Purchases: May 5 200 3.50 700 May 10 140 4.50 630 May 15 160 5.50 880 Sales: May 11 250 May 19 150 Using the perpetual system, determine the ending inventory and cost of goods sold under weighted-average method (round unit cost...

The Lippert Company uses the perpetual inventory system. The following July data are for an item...

The Lippert Company uses the perpetual inventory system. The following July data are for an item in Lippert's inventory: July 1 Beginning inventory 60 units @ $11 per unit 10 Purchased 80 units @ $12 per unit 15 Sold 90 units @ 26 Purchased 55 units @ $13 per unit Calculate the cost of goods sold for the July 15 sale using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost methods. Round your final answers to the...

Concord Limited uses a perpetual inventory system. The inventory records show the following data for its...

Concord Limited uses a perpetual inventory system. The inventory records show the following data for its first month of operations: Date Explanation Units Unit Cost Total Cost Balance in Units Aug. 2 Purchases 237 $73 $17,301 237 3 Purchases 475 97 46,075 712 10 Sales (300 ) 412 15 Purchases 894 122 109,068 1,306 25 Sales (330 ) 976 Calculate the cost of goods sold and ending inventory using the FIFO cost method. Cost of goods sold $enter a dollar...

Addison Inc. uses a perpetual inventory system. The following information about one inventory item for the...

Addison Inc. uses a perpetual inventory system. The following information about one inventory item for the month of september: Sep. 1 Inventory 24 units at $15 5 sold 17 units 17 Purchased 10 units at $20 30 sold 8 units If Addison uses LIFO, the cost of the ending inventory on September 30 is a. $160 b.$125 c. $180 d. $145 Please help! I don't understand. Due at 11:59 p.m. Thanks!

Metlock, Inc. uses a perpetual inventory system. Data for product E2-D2 include the following purchases. Date...

Metlock, Inc. uses a perpetual inventory system. Data for product E2-D2 include the following purchases. Date Number of Units Unit Price May 7 205 $12 July 28 123 15 On June 1, Metlock sold 107 units, and on August 27, 164 more units. Prepare the perpetual inventory schedule for the above transactions using FIFO. (Round answers to 0 decimal places, e.g. 1,250.) Product E2-D2 Date Purchases Cost of Goods Sold Balance May 7 $enter a dollar amount $enter a dollar...

Bramble Outdoor Stores Inc. uses a perpetual inventory system and has a beginning inventory, as at...

Bramble Outdoor Stores Inc. uses a perpetual inventory system and has a beginning inventory, as at April 1, of 148 tents. This consists of 51 tents at a cost of $ 206 each and 97 tents at a cost of $ 223 each. During April, the company had the following purchases and sales of tents: Purchases Sales Date Units Unit Cost Units Unit Price Apr. 3 75 $ 414 10 202 $ 271 17 249 414 24 287 290 30...