Question

In: Accounting

Pam’s Creations had the following sales and purchase transactions during Year 2. Beginning inventory consisted of...

Pam’s Creations had the following sales and purchase transactions during Year 2. Beginning inventory consisted of 280 items at $96 each. The company uses the FIFO cost flow assumption and keeps perpetual inventory records.

  

Date Transaction Description
Mar. 5 Purchased 260 items @ $ 106
Apr. 10 Sold 150 items @ $ 207
June 19 Sold 275 items @ $ 207
Sept. 16 Purchased 210 items @ $ 111
Nov. 28 Sold 140 items @ $ 212

Required
a. Record the inventory transactions in general journal format.

b. Calculate the gross margin Pam’s Creations would report on the Year 2 income statement.

c. Determine the ending inventory balance Pam’s Creations would report on the December 31, Year 2, balance sheet.

Solutions

Expert Solution

Solution a:

Computation of ending inventory COGS under FIFO
Date Beginning Inventory Purchase Cost of Goods Sold Ending Inventory
Qty Rate Amount Qty Rate Amount Qty Rate Amount Qty Rate Amount
1-Mar 280 $96.00 $26,880.00 0 $0.00 $0.00 0 $0.00 $0.00 280 $96.00 $26,880.00
5-Mar 280 $96.00 $26,880.00 260 $106.00 $27,560.00 0 $0.00 $0.00 280 $96.00 $26,880.00
260 $106.00 $27,560.00
10-Apr 280 $96.00 $26,880.00 0 $0.00 $0.00 150 $96.00 $14,400.00 130 $96.00 $12,480.00
260 $106.00 $27,560.00 260 $106.00 $27,560.00
19-Jun 130 $96.00 $12,480.00 0 $0.00 $0.00 130 $96.00 $12,480.00 115 $106.00 $12,190.00
260 $106.00 $27,560.00 145 $106.00 $15,370.00
16-Sep 115 $106.00 $12,190.00 210 $111.00 $23,310.00 0 $0.00 $0.00 115 $106.00 $12,190.00
210 $111.00 $23,310.00
28-Nov 115 $106.00 $12,190.00 0 $0.00 $0.00 115 $106.00 $12,190.00 185 $111.00 $20,535.00
210 $111.00 $23,310.00 25 $111.00 $2,775.00
Total 565 $57,215.00 185 $20,535.00
Journal Entries - Pam's Creations
Date Particulars Debit Credit
5-Mar Inventory Dr $27,560.00
      To Accounts Payable $27,560.00
(To record purchase of inventory)
10-Apr Accounts receivables Dr $31,050.00
      To Sales Revenue $31,050.00
(To record sales revenue)
10-Apr Cost of goods sold Dr $14,400.00
      To Inventory $14,400.00
(To record COGS)
19-Jun Accounts receivables Dr $56,925.00
      To Sales Revenue $56,925.00
(To record sales revenue)
19-Jun Cost of goods sold Dr $27,850.00
      To Inventory $27,850.00
(To record COGS)
16-Sep Inventory Dr $23,310.00
      To Accounts Payable $23,310.00
(To record purchase of inventory)
28-Nov Accounts receivables Dr $29,680.00
      To Sales Revenue $29,680.00
(To record sales revenue)
28-Nov Cost of goods sold Dr $14,965.00
      To Inventory $14,965.00
(To record COGS)

Solution b:

Gross Margin = Sales revenue - COGS = ($31,050 + $56,925 + $29,680) - $57,215 = $60,440

Solution c:

Ending inventory balance Pam’s Creations would report on the December 31, Year 2, balance sheet = $20,535


Related Solutions

Pam’s Creations had the following sales and purchase transactions during Year 2. Beginning inventory consisted of 180 items at $86 each.
Pam’s Creations had the following sales and purchase transactions during Year 2. Beginning inventory consisted of 180 items at $86 each. The company uses the FIFO cost flow assumption and keeps perpetual inventory records.    Date Transaction Description Mar. 5 Purchased 160 items @ $ 96   Apr. 10 Sold 100 items @ $ 187   June 19 Sold 175 items @ $ 187   Sept. 16 Purchased 110 items @ $ 101   Nov. 28 Sold 90 items @...
Nichols, Inc. had the following balances and transactions during​ 2018: Beginning Merchandise Inventory as of January​...
Nichols, Inc. had the following balances and transactions during​ 2018: Beginning Merchandise Inventory as of January​ 1, 2018 300 units at $80 March 10 Sold 60 units June 10 Purchased 600 units at $85 October 30 Sold 360 units What would be reported for Ending Merchandise Inventory on the balance sheet at December​ 31, 2018 if the perpetual inventory system and the first−​in, first−out inventory costing method are​ used? A. 40,800 B. 51,000 C. 24,000 D. 4,800
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. C.           Compute gross profit under for a...
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....
Ceres Computer Sales uses the perpetual inventory system and had the following transactions during December. Dec....
Ceres Computer Sales uses the perpetual inventory system and had the following transactions during December. Dec. 1 Ceres sold merchandise to ABC, Inc. on credit for $8,500, terms 1/10, n/30. The items sold had a cost of $ 4,200. Dec. 6 Ceres purchased merchandise from Jones, Inc. on credit for $6,000, terms 2/10, n/30. Dec. 7 ABC, Inc. returned $1,100 of goods purchased on Dec. 1 (original cost of the goods to ABC is $375). Required: Prepare the general journal...
During the most recent year, Boston Corp. had the following data: Beginning inventory in units         -  ...
During the most recent year, Boston Corp. had the following data: Beginning inventory in units         -   Units produced               15,000 Units sold ($125 per unit) 12,000 Variable costs per unit:       Direct materials          $15       Direct labor                  $20       Variable overhead          $10 Fixed costs:       Fixed overhead per unit produced          $20       Fixed selling and administrative $ 200,000 Required: A. How many units are in ending inventory? B. Using absorption costing, calculate the per-unit product cost....
Umbrella Corp uses LIFO method to report inventory. Inventory at the beginning of the year consisted...
Umbrella Corp uses LIFO method to report inventory. Inventory at the beginning of the year consisted of 10,000 units of the company's one product for $15 each. During the year: 60,000 units were purchased at the cost of $18 each. 64,000 units were sold. Near the end of the fiscal year, management is considering purchasing an additional 5,000 units at $18. What would the effect of this purchase be on income before taxes? Would the answer be the same if...
Our company had the following balances and transactions during the current year related to merchandise inventory....
Our company had the following balances and transactions during the current year related to merchandise inventory. Beginning merchandise inventory on January 1 120 units at $70 per unit Purchase on February 14 100 units at $85 per unit Sale on August 21 120 units What would be the company’s ending merchandise inventory in dollars on December 31 if the company used perpetual, weighted average (WA) costing method? $9,900 $7,000 $9,218 $7,682
.Our company had the following balances and transactions during the current year related to merchandise inventory....
.Our company had the following balances and transactions during the current year related to merchandise inventory. Beginning merchandise inventory on January 11 20 units at $70 per unitPurchase on February 14 100 units at $85 per unitSale on August 21 120 units What would be the company's ending merchandise inventory in dollars on December 31 if the company used perpetual, last in, first out (LIFO) method? $9,900 $8,500 $8,400 $7,000 2.Our company had the following balances and transactions during the...
Cullumber Cosmetics Inc. had a number of transactions during the year relating to the purchase of...
Cullumber Cosmetics Inc. had a number of transactions during the year relating to the purchase of various inventory items as noted below. For each of the below independent transactions determine what amount should be included in inventory. Lipstick products counted in the physical inventory amount to $23,700 which include $1,400 of duty charges for importing the goods and $2,300 of recoverable taxes (i.e. HST). (If an answer is zero, please enter 0. Do not leave any fields blank.) Inventory $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT