Data: Date Item Units Cost per unit Dec. 1 Inventory 30 $12 Dec. 10 Purchase 60...

Data:

Date Item Units Cost per unit

Dec. 1 Inventory 30 $12

Dec. 10 Purchase 60 $13

Dec. 20 Purchase 40 $14

Dec. 12 Sale 40

Dec. 27 Sale 15

Required: (1) Find the ending inventory and the cost of goods sold for December under the

periodic inventory system using the following inventory costing methods.

(a) average cost

(b) FIFO

(2) Also find ending inventory and the cost of goods sold for the month of December

under the perpetual inventory system using the LIFO inventory costing system.

Expert Solution

Hope it helps.. in case of any doubts or issues, please do comment below

ekkarill92 answered 1 year ago

Units Per unit cost Beginning Inventory 200 $ 120.00 $ 24,000.00 30-Jan purchase 130 $ 124.00...

Units Per unit cost Beginning Inventory 200 $ 120.00 $ 24,000.00 30-Jan purchase 130 $ 124.00 $ 16,120.00 12-Mar purchase 220 $ 128.00 $ 28,160.00 Total Sales 350 $ 320.00 $ 112,000.00 Ending Inventory FIFO LIFO Ending Inventory Ending Inventory Goods Available for Sale Goods Available for Sale Deduct ending Inventory Deduct ending Inventory Cost of Goods Sold Cost of Goods Sold Sales Sales Cost of Goods Sold Cost of Goods Sold Gross Profit Gross Profit Operating Expense $ 24,000.00...

Beginning Inventory # of units Cost per unit Total Beginning Inventory 15 $10 $150 Jan 1....

Beginning Inventory # of units Cost per unit Total Beginning Inventory 15 $10 $150 Jan 1. Purchase 15 $11 $165 Jan 10. Purchase 15 $12 $180 Total 45 1. During January, AA sold 20 units at $30 per unit. Under FIFO, how much is the Gross Profit? $365 $380 $390 $395 2. During January, AA sold 20 units at $30 per unit Under the Weighted Average Method, how much is the Gross Profit?. $365 $380 $395 $400 3. During January,...

The beginning inventory was 320 units at a cost of $10 per unit. Goods available for...

The beginning inventory was 320 units at a cost of $10 per unit. Goods available for sale during the year were 1,360 units at a total cost of $15,060. In May, 620 units were purchased at a total cost of $6,820. The only other purchase transaction occurred during October. Ending inventory was 580 units. Required: a. Calculate the number of units purchased in October and the cost per unit purchased in October. b-1. Assume the periodic inventory system is used....

What is the inventory carrying cost per unit per year for this item?

For a certain item, the cost-minimizing order quantity obtained with the basic EOQ model is 200 units, and the total annual inventory (carrying and setup) cost is $600. What is the inventory carrying cost per unit per year for this item?

Using the specific identification method: Date Units purchased Cost per unit Ending inventory March 1 20...

Using the specific identification method: Date Units purchased Cost per unit Ending inventory March 1 20 Xbox?s 360 $ 275 5 Xbox?s from March April 1 41 Xbox?s 360 250 11 Xbox?s from April May 1 70 Xbox?s 360 240 8 Xbox?s from May a. Calculate the ending inventory. Ending inventory $ b. Calculate the cost of goods sold. Cost of goods sold $

Using the specific identification method: Date Units purchased Cost per unit Ending inventory March 1 15...

Using the specific identification method: Date Units purchased Cost per unit Ending inventory March 1 15 Xbox′s 360 $ 275 2 Xbox′s from March April 1 45 Xbox′s 360 250 15 Xbox′s from April May 1 60 Xbox′s 360 240 12 Xbox′s from May a. Calculate the ending inventory.Ending inventory $: b. Calculate the cost of goods sold. Cost of goods sold $:

Lower-of-Cost-or-Market Method On the basis of the following data: Item Inventory Quantity Cost per Unit Market...

Lower-of-Cost-or-Market MethodOn the basis of the following data: $$ \begin{array}{lccc} \text { Item } & \text { Inventory Quantity } & \text { Cost per Unit } & \begin{array}{l} \text { Market Value per Unit } \\ \text { (Net Realizable Value) } \end{array} \\ \hline \text { JFW1 } & 6,330 & \$ 10 & \$ 11 \\ \text { SAW9 } & 1,140 & 36 & 34 \end{array} $$Determine the value of the inventory at the lower-of-cost-or-market by applying...

June 1st. Inventory 10 $3 $30 June 5th: Purchase 12 $5 $60 June 15th: Purchase 25...

June 1st. Inventory 10 $3 $30 June 5th: Purchase 12 $5 $60 June 15th: Purchase 25 $7 $175 June 21st: Purchase 13 $10 $130 June 30th: Inventory 25 $395 What is the $ Amount for Cost of Goods Sold using the LIFO cost flow assumption?

Annual demand is 12500 units, cost per order is $60 and carrying cost per unit as...

Annual demand is 12500 units, cost per order is $60 and carrying cost per unit as a percentage is 8%. The company works 50 weeks a year; the lead-time on all orders placed is 5 weeks. Assuming constant lead-time demand, and a unit cost of $40 what is the economic order quantity? What is the reorder point. If lead-time demand shows variability that follows a normal distribution with a mean μ =280 and a standard deviation σ =20, what will...

The purchase schedule for Marin and Associates is as follows: Date Items Purchased Cost per Item...

The purchase schedule for Marin and Associates is as follows: Date Items Purchased Cost per Item March 15 6,300 $1.30 July 30 9,500 1.50 December 17 6,600 1.60 Total 22,400 The inventory balance as of the beginning of the year was $15,400 (15,400 units at $1), and an inventory count at year-end indicated that 11,300 items were on hand. Sales and operating expenses (excluding cost of goods sold) totaled $52,500 and $10,400, respectively. The federal income tax is 30 percent...

Question