Question

The following schedule relates to the company's inventory for the month of April. The Company Uses...

The following schedule relates to the company's inventory for the month of April. The Company Uses the Perpetual Inventory System. Calculate the Company's Cost of Goods Sold, Gross Margin, and Ending Inventory using Weighted-Average.


April 1: Beginning Inventory 72 Units ---- Total Cost = $42,768

April 3: Purchase 48 Units ---- Total Cost = $29,712

April 5: Sale 27 Units ----Total Cost = $30,483

April 11: Purchase 24 Units ---Total Cost = $15,480

April 15: Sale 56 Units ---Total Cost = $67,312

April 22: Sale 37 Units --- Total Cost = $42,624

April 28: Purchase 48 Units ---Total Cost = $32,736

Homework Answers

Answer #1

Weighted Average:

Date Purchases COGS Balance
April Units Cost per unit Total Cost Units Cost per unit Total Cost Units Cost per unit Total Cost
1 72 594 42,768
3 48 619 29,712 120 604 72,480
5 27 604 16,308 93 604 56,172
11 24 645 15,480 117 612.41 71,652
15 56 612.41 34,295 61 612.41 37,357
22 37 612.41 22,659 24 612.42 14,698
28 48 682 32,736 72 658.81 47,434
Total 120 77,928 120 73,262 72 47,434

Cost of Goods Sold = $73,262

Gross Margin = Gross Margin / Sales * 100

Gross Margin = Sales - Cost of Goods Sold

= (30,483 + 67,312 + 42,624) - 73,262

= 140,419 - 73,262

= $67,157

Gross Margin % = 67,157 / 140,419 * 100

= 47.83%

Ending Inventory = $47,434

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Saddlery Company sells leather saddles and equipment for horse enthusiasts. Saddlery uses the perpetual inventory system....
Saddlery Company sells leather saddles and equipment for horse enthusiasts. Saddlery uses the perpetual inventory system. The following schedule relates to the company’s inventory for the month of May: Cost Sales May 1 Beginning inventory 150 units $82,500 5 Sale 100 units $71,500 9 Purchase 50 units $30,250 13 Purchase 200 units $132,000 24 Sale 200 units $154,000 27 Sale 50 units $44,000 30 Purchase 75 units $54,450 A) Calculate Saddlery Company’s cost of goods sold, gross margin, and ending...
FIFO and LIFO Costs Under Perpetual Inventory System The following units of an item were available...
FIFO and LIFO Costs Under Perpetual Inventory System The following units of an item were available for sale during the year: Beginning inventory 22 units @ $45 Sale 10 units @ $70 First purchase 31 units @ $46 Sale 23 units @ $72 Second purchase 26 units @ $48 Sale 22 units @ $74 The firm uses the perpetual inventory system, and there are 24 units of the item on hand at the end of the year. a. What is...
Consider the following information for Maynor Company, which uses a perpetual inventory system:    Transaction Units...
Consider the following information for Maynor Company, which uses a perpetual inventory system:    Transaction Units Unit Cost Total Cost January 1 Beginning Inventory 20 $ 70 $ 1,400 March 28 Purchase 30 76 2,280 August 22 Purchase 40 80 3,200 October 14 Purchase 45 86 3,870 Goods Available for Sale 135 $ 10,750 The company sold 45 units on May 1 and 40 units on October 28. Required: Calculate the company's ending inventory and cost of goods sold using...
During January, a company that uses a perpetual inventory system had beginning inventory, purchases, and sales...
During January, a company that uses a perpetual inventory system had beginning inventory, purchases, and sales as follows : Units Cost per unit Begin Inventory 100 12 Jan 5 Sale 50 10 Purchase 70 16 15 Sale 25 25 Sale 35 Required: Prepare a schedule showing cost of goods sold and ending inventory using weighted average. Prepare a schedule showing cost of goods sold and ending inventory using First In First Out. Compute gross profit under for a and b....
Morgan Inc. has the following units and costs for the month of April: Units Purchased at...
Morgan Inc. has the following units and costs for the month of April: Units Purchased at Cost Units Sold at Retail Beginning inventory, April 1 1,200 units at $25 Purchase 1, April 9 1,500 units at $28 Sale 1, April 12 2,400 units at $45 Purchase 2, April 22 1,000 units at $30 If Morgan uses a perpetual inventory system, what is the cost of goods sold under LIFO at April 30?
Glassworks Ltd. uses the periodic inventory system. Calculate Glassworks’ cost of goods sold, gross margin, and...
Glassworks Ltd. uses the periodic inventory system. Calculate Glassworks’ cost of goods sold, gross margin, and ending inventory for the month of July using weighted average. All of the units sold were priced at $20 per unit. Units Cost/Unit Amount July 1 Beginning inventory 4,000 $12.00 $48,000 4 Purchase 6,000 $12.50 75,000 8 Sale 6,590 14 Sale 1,410 22 Purchase 5,000 $12.75 63,750 28 Sale 2,960
Inventory Costing Methods VanderMeer Inc. reported the following information for the month of August: Inventory, August...
Inventory Costing Methods VanderMeer Inc. reported the following information for the month of August: Inventory, August 1 69 units @ $22 Purchase: August 7 53 units @ $24 August 18 68 units @ $25 August 27 40 units @ $27 During August, VanderMeer sold 150 units. The company uses a periodic inventory system. Required: What is the value of ending inventory and cost of goods sold for August under the following assumptions. Assumption Cost of Goods Sold Ending Inventory 1....
Giles Manufacturing uses a periodic inventory system and has the following transactions for the month of...
Giles Manufacturing uses a periodic inventory system and has the following transactions for the month of June 2018:   Date Transactions Units Cost per Unit Total Cost   June 1 Beginning inventory 17     $240     $ 4,080        June 7 Sale 12       June 12 Purchase 13     230     2,990        June 15 Sale 11       June 24 Purchase 14     220     3,080        June 27 Sale 15       June 29 Purchase 8     210     1,680      $11,830...
Consider the following information for Maynor Company, which uses a periodic inventory system:        Transaction...
Consider the following information for Maynor Company, which uses a periodic inventory system:        Transaction Units Unit Cost Total Cost   January 1 Beginning Inventory 31 $ 81 $ 2,511   March 28 Purchase 41 87 3,567   August 22 Purchase 62 91 5,642   October 14 Purchase 67 97 6,499 Goods Available for Sale 201 $ 18,219    The company sold 67 units on May 1 and 62 units on October 28.     Required: Calculate the company's ending inventory and cost of...
Sunland Company uses a periodic inventory system. For April, when the company sold 550 units, the...
Sunland Company uses a periodic inventory system. For April, when the company sold 550 units, the following information is available. Units Units Cost Total Units April 1 Inventory 340 $23 $7,820 April 15 Purchase 390 28 10,920 April 23 Purchase 270 30 8,100 Total 1,000 $26,840 Compute the April 30 inventory and the April cost of goods sold using the average-cost method. (Round answers to 0 decimal places, e.g. 2,760.) Ending Inventory? Cost of Goods Sold?
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT