### Windsor's Boards: Inventory and Cost of Goods Sold Calculation for Xpert SnowboardsWindsor's Boards sells a snowboard, Xpert, that is popular with snowboard enthusiasts. Information relating to Windsor’s purchases of Xpert snowboards during September is shown below. During the same month, 303 Xpert snowboards were sold. Windsor’s uses a periodic inventory system.#### Purchases and Inventory Data:| Date | Explanation | Units | Unit Cost | Total Cost ||-------------|-------------|-------|-----------|------------|| Sept. 1 | Inventory | 65 | $100 | $6,500 || Sept. 12 | Purchases | 113 | $104 | $11,752 || Sept. 19 | Purchases | 50 | $108 | $5,400 || Sept. 26 | Purchases | 125 | $113 | $14,125 || **Totals** | | **353** | | **$37,777** |### Computation Tasks:(a) **Compute the ending inventory at September 30 and cost of goods sold using the FIFO and LIFO methods.**The table presents two columns – FIFO and LIFO – where calculations will be inserted for:- **The ending inventory at September 30**- **Cost of goods sold**| | FIFO | LIFO ||--------------|------|------|| The ending inventory at September 30 | $ | $ || Cost of goods sold | $ | $ |### Explanation of Methods:**FIFO (First In, First Out):**The FIFO method assumes that the oldest inventory items are sold first. Therefore, the ending inventory consists of the most recently purchased items.**LIFO (Last In, First Out):**The LIFO method assumes that the newest inventory items are sold first. Thus, the ending inventory consists of the oldest items in stock.By using these methods, Windsor’s Boards will be able to accurately measure the value of their unsold inventory and the cost of goods that were sold during September.*Note: Fill the appropriate values by performing the FIFO and LIFO calculations based on the given data.*

Name: ### Windsor's Boards: Inventory and Cost of Goods Sold Calculation fo
Uploaded: 2024-03-20T06:33:06.000Z
Channel: Bartleby
Description: ### Windsor's Boards: Inventory and Cost of Goods Sold Calculation for Xpert SnowboardsWindsor's Boards sells a snowboard, Xpert, that is popular with snowboard enthusiasts. Information relating to Windsor’s purchases of Xpert snowboards during Sept

Ending inventory (in units) on September 30: = number of units available - number of units sold…

Business

Accounting

Windsor's Boards sells a snowboard, Xpert, that is popular with snowboard enthusiasts. Information relating to Windsor's purchas of Xpert snowboards during September is shown below. During the same month, 303 Xpert snowboards were sold. Windsor's uses periodic inventory system. Date Sept. 1 Sept. 12 Sept. 19 Sept. 26 Explanation Units Inventory Purchases Purchases Purchases Totals 65 113 50 125 353" Unit Cost $100 104 108 113 Total Cost $6,500 11,752 5,400 14,125 $37,777

Windsor's Boards sells a snowboard, Xpert, that is popular with snowboard enthusiasts. Information relating to Windsor's purchas of Xpert snowboards during September is shown below. During the same month, 303 Xpert snowboards were sold. Windsor's uses periodic inventory system. Date Sept. 1 Sept. 12 Sept. 19 Sept. 26 Explanation Units Inventory Purchases Purchases Purchases Totals 65 113 50 125 353" Unit Cost $100 104 108 113 Total Cost $6,500 11,752 5,400 14,125 $37,777

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Required information [The following information applies to the questions displayed below] Cody's Fishing Hole has the following transactions related to its top-selling Shimano fishing reel for the month of June. Cody's Fishing Hole uses a periodic inventory system. Date June 1 June 7 June 12 June 15 June 24 June 27 June 29 Transactions Beginning inventory Ending inventory Cost of goods sold Sale Purchase Sale Purchase Sale Purchase Units 16 11 10 12 10 8 10 Unit Cost $340 330 320 310 Total Cost $5,440 3,300 3,200 3,100 $15,040 Required: 1. Calculate ending inventory and cost of goods sold at June 30, using the specific identification method. The June 7 sale consists of fishing reels from beginning inventory, the June 15 sale consists of three fishing reels from beginning inventory and nine fishing reels from the June 12 purchase, and the June 27 sale consists of one fishing reel from beginning inventory and seven fishing reels from the June 24 purchase.
Required information Trey Monson starts a merchandising business on December 1 and enters Into the following three inventory purchases. Also, on December 15, Monson sells 25 units for $25 each. Purchases on December 7 Purchases on Decenber 14 Purchases on December 21 15 units e $10.00 cost Je units e $15.00 cost 25 units e $18.00 cost Required: Monson sells 25 units for $25 each on December 15. Monson uses a perpetual inventory system. Determine the costs assigned to the December 31 ending inventory when costs are assigned based on LIFO. Perpetual LIFO: Goods purchased Cost of Goods Sold Inventory Balance # of units Cost of Goods Cost per Available for # of units sold Cost per Cost of Goods unit Cost per unit Inventory Balance Date # of units unit Sold Sale December 7 Docember 14
REI sells snowboards. Assume the following information relates to REI's purchases of snowboards during September. During the same month, 107 snowboards were sold. REI uses a periodic inventory system. Date Explanation Units Unit Cost Total Cost Sept. 1 Inventory 13 $110 $1,430 Sept. 12 Purchases 49 113 5,537 Sept. 19 Purchases 53 114 6,042) Sept. 26 Purchases Totals 135 335 20 115 2,300 $15,309 Compute the ending inventory at September 30 using FIFO, LIFO, and average cost. (Round average cost per unit to 3 decimal places, eg. 125.153 and final answers to O decimal places, e.g. 125.) Ending inventory at September 30 eTextbook and Media FIFO LIFO $ AVERAGE-COST Compute the cost of goods sold for the month using the FIFO, LIFO, and average cost methods. (Round average cost per unit to 3 decimal places, eg. 125.153 and final answers to O decimal places, eg. 125) FIFO LIFO AVERAGE-COST
Buffalo Corp. sells a snowboard, EZslide, that is popular with snowboard enthusiasts. Below is information relating to Buffalo Corp.’s purchases of EZslide snowboards during September. During the same month, 103 EZslide snowboards were sold. Buffalo Corp. uses a periodic inventory system. Date Explanation Units Unit Cost Total Cost Sept. 1 Inventory 14 $110 $ 1,540 Sept. 12 Purchases 50 113 5,650 Sept. 19 Purchases 54 114 6,156 Sept. 26 Purchases 22 115 2,530 Totals 140 $15,876 (a) Compute the ending inventory at September 30 using the FIFO, LIFO and average-cost methods. (Round average cost per unit to 3 decimal places, e.g. 125.153 and final answers to 0 decimal places, e.g. 125.) FIFO LIFO AVERAGE-COST The ending inventory at September 30 $Enter a dollar amount $Enter a dollar amount $Enter a dollar amount (b) Compute the…
Vaughn Boards sells a snowboard, Xpert, that is popular with snowboard enthusiasts. Information relating to Vaughn's purchases of Xpert snowboards during September is shown below. During the same month. 98 Xpert snowboards were sold. Vaughn's uses a periodic inventory system. Date Explanation Units Unit Cost Total Cost Sept. 1 Inventory 23 HK$970 HK$ 22,310 Sept. 12. Purchases 37 1,020 37,740 Sept. 19 Purchases 13 1.040 13,520 Sept. 26 Purchases 47 1,050 49.350 Totals 120 HK$122.920 (a) Compute the ending inventory at September 30 and cost of goods sold using the FIFO and average-cost methods. (Round per unit cost to 3 decimal places, eg. 15.125 and final answers to O decimal places, eg. 125) FIFO Average-Cost The ending inventory at September 30 HK$ HK$ Cost of goods sold HK$ HK$ (b) For both FIFO and average-cost, calculate the sum of ending inventory and cost of goods sold. (Round per unit cost to 3 decimal places, eg. 15.125 and final answers to O decimal places, eg 125) FIFO…
Required information Use the following information for the Quick Study below. (Algo) (11-14) Skip to question [The following information applies to the questions displayed below.]Trey Monson starts a merchandising business on December 1 and enters into the following three inventory purchases. Monson uses a perpetual inventory system. Also, on December 15, Monson sells 15 units for $27 each. Purchases on December 7 10 units @ $13.00 cost Purchases on December 14 20 units @ $19.00 cost Purchases on December 21 15 units @ $21.00 cost QS 5-14 (Algo) Perpetual: Inventory costing with specific identification LO P1 Of the units sold, eight are from the December 7 purchase and seven are from the December 14 purchase. Determine the costs assigned to ending inventory when costs are assigned based on specific identification.
REI sell snowboards. Assume the following information relates to REI's purchases of snowbourds during tegnember During the same month, 100 snowboards were sold REloses a periodic inventory system Dale Sept. 1 Sept. 12 Sept 19 Sept. 26 Explanation Unit Unit Cont Inventory 15 $110 Purchases 48 113 Purchases 33 114 Purchases 24 115 Totals 140 Compute the ending inventory at September 30 using FIFO LIFO, and average-cost. (Round average cost per 3 decimal places eg. 125.153 and final answers to 0 decimal places 125 Ending inventory at September 30 eTextbook and Media FIFO Your answer is incorrect Cost of goods sold 2775 FIFO $1.630 5,424 6042 3.760 $15.876 13654 LIFO Compute the cost of goods sold for the month using the FIFO, LIFO, and average-cost methock Mound average cost per unit to 3 decimal ploces, eg 125 153 end final enmers to 0 alecimal places, 1253 1344 UFD ETDA AVERAGE-COST $ 3402 AVERAGE-COST 130825
Ivanhoe Company sells a snowboard, EZslide, that is popular with snowboard enthusiasts. Below is information relating to Ivanhoe Company’s purchases of EZslide snowboards during September. During the same month, 95 EZslide snowboards were sold. Ivanhoe Company uses a periodic inventory system. Date Explanation Units Unit Cost Total Cost Sept. 1 Inventory 12 $106 $ 1,272 Sept. 12 Purchases 45 109 4,905 Sept. 19 Purchases 55 110 6,050 Sept. 26 Purchases 21 111 2,331 Totals 133 $14,558 (a) Compute the ending inventory at September 30 using the FIFO, LIFO and average-cost methods. (Round average cost per unit to 3 decimal places, e.g. 125.153 and final answers to 0 decimal places, e.g. 125.) FIFO LIFO AVERAGE-COST The ending inventory at September 30 $Enter a dollar amount $Enter a dollar amount $Enter a dollar amount (b) Compute the cost of goods sold at September 30 using the FIFO, LIFO and average-cost methods. (Round average cost per unit to 3 decimal places, e.g.…
Crane Company sells leather saddles and equipment for horse enthusiasts. Crane 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 180 units $117,000 5 Sale 120 units $101,400 9 Purchase 60 units $42,900 13 Purchase 240 units $187,200 24 Sale 240 units $218,400 27 28 Sale 60 units $62,400 30 Purchase 90 units $77,220 (a1) Calculate Crane Company's cost of goods sold, gross margin, and ending inventory using FIFO. Cost of goods sold Gross margin $ Ending inventory $
Required information Use the following information for the Quick Study below. (Algo) (15-18) [The following information applies to the questions displayed below.] Trey Monson starts a merchandising business on December 1 and enters into the following three inventory purchases. Monson uses a perpetual inventory system. Also, on December 15, Monson sells 29 units for $45 each. Purchases on December 7 Purchases on December 14 Purchases on December 21 QS 5-15A (Algo) Perpetual: Assigning costs with FIFO LO P3 Required: Determine the costs assigned to the December 31 ending inventory based on the FIFO method. Date December 7 December 14 Total December 14 December 15 Totals Total December 15 December 21 19 units @ $18.00 cost 35 units @ $27.00 cost 29 units @ $32.00 cost Goods Purchased Number of Cost Per Units Unit Perpetual FIFO: Goods Purchased 19 at $ 18.00 = $ 342.00 35 at $ 27.00 = $ 945.00 29 at $ 32.00 = $ 928.00 Cost of Goods Sold Number of Units Sold Cost Per Cost of Goods Unit…
Required information Trey Monson starts a merchandising business on December 1 and enters into the following three inventory purchases. Also, on December 15, Monson sells 25 units for $25 each. Purchases on December 7. 15 units @ $10.00 cost 30 units @ $15.00 cost 25 units @ $18.00 cost Purchases on December 14 Purchases on December 21 Required: Monson sells 25 units for $25 each on December 15. Of the units sold, 12 are from the December 7 purchase and 13 are from the December 14 purchase. Monson uses a perpetual inventory system. Determine the costs assigned to the December 31 ending inventory when costs are assigned based on specific identification.
REI sells snowboards. Assume the following information relates to REI's purchases of snowboards during September. During the same month, 109 snowboards were sold. REI uses a periodic inventory system. Date Explanation Units Unit Cost Total Cost Sept. 1 Inventory 14 $102 $1,428 Sept. 12 Purchases 48 105 5,040 Sept. 19 Purchases 50 106 5,300 Sept. 26 Purchases 23 107 2,461 Totals 135 $14,229 (a) Your answer is correct. Compute the ending inventory at September 30 using FIFO, LIFO, and average-cost. (Round average cost per unit to 3 decimal places, e.g. 125.153 and final answers to O decimal places, e.g. 125.) (b) Ending inventory at September 30 $ eTextbook and Media FIFO 2779 $ LIFO 2688 $ AVERAGE-COST 2740 Attempts: 2 of 3 used Compute the cost of goods sold for the month using the FIFO, LIFO, and average-cost methods. (Round average cost per unit to 3 decimal places, e.g. 125.153 and final answers to O decimal places, e.g. 125.) Cost of goods sold $ FIFO $ LIFO AVERAGE-COST $