Elsa’s Boards sells a snowboard, Xpert, that is popular with snowboard enthusias

Question

Elsa’s Boards sells a snowboard, Xpert, that is popular with snowboard enthusiasts. Information relating to Elsa’s purchases and sales of Xpert snowboards during September is shown below. During the same month, 298 Xpert snowboards were sold. Additional data regarding Elsa’s sales of Xpert snowboards are provided below. Elsa’s uses a perpetual inventory system.

Calculate moving average cost at Sept 1, 5, 12, 16, 19, 26 & 29. (Round answers to 2 decimal places, e.g. 1.25.)

Compute ending inventory at September 30 using FIFO, LIFO, and moving-average cost. (Round average-cost per unit to 2 decimal places, e.g. 12.50 and final answer to 0 decimal places, e.g. 1,250.)

Compare ending inventory using a perpetual inventory system to ending inventory using a periodic inventory system.

Which inventory cost flow method (FIFO, LIFO) gives the same ending inventory value under both periodic and perpetual?

Which method gives different ending inventory values?

please include all answers and calculations. thank you

Date Sept. 1 Sept. 12 Purchases 111 Sept. 19 Purchases Sept. 26 Purchases 123 Unit Cost $102 103 108 110 Explanation Units Total Cost $6,528 11,433 5,292 13,530 $36,783 Inventory 64 49 Totals 347 Unit Price 30 $199 199 210 Total Units Date Sept. 5 Sept. 16 Sept. 29 Sale Sale Sale 123 145 298 Revenue $5,970 24,477 30,450 $60,897 Totals

Explanation / Answer

Moving average cost at any date = Total cost of inventory held till that date/ No. of units of inventory held

Sep 1 = $6528/ 64 = $102

Sep 5 = ($6528 - 3060)/ 34 = $102

Sep 12 = ($3468 + 11433)/ 145 = $102.77

Sep 16 = [$14901 - (123 x 102.77)]/ 22 = $102.74

Sep 19 = ($2260.28 + 5292)/ 71 = $106.37

Sep 26 = ($7552.27 + 13530)/ 194 = $108.67

Sep 29 = ($21081.98 - (145 x $108.67)]/ 49 = $108.67

Ending inventory moving average cost = 49 x $108.67 = $5325

Ending Inventory FIFO (Periodic method):

Cost of sales = (30 x $102) + (34 x $102) + (89 x $103) + (22 x $103) + (49 x $108) + (74 x $110)

= $31393

Ending inventory FIFO = 36783 - 31393 = $5390

Ending Inventory LIFO (Periodic method):

Cost of sales = (30 x $110) + (93 x $110) + (30 x $108) + (19 x $108) + (111 x $103) + (15 x $102)

= $31785

Ending inventory LIFO = 36783 - 31785 = $4998

Ending inventory FIFO perpetual:

Ending inventory = $5390

Ending inventory LIFO perpetual:

Ending inventory = 2244 + 2916 = $5160

FIFO gives the same ending inventory value under both periodic and perpetual

LIFO gives different ending inventory values

FIFO LIFO Moving average cost The ending inventory $5390 $4998 $5325

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.