The Shirt Shop had the following transactions for T-shirts for Year 1, its first year of operations:Jan. 20Apr. 21July 25Sept. 19PurchasedPurchasedPurchasedPurchasedRequired ADuring the year, The Shirt Shop sold 810 T-shirts for $20 each.Requireda. Compute the amount of ending inventory The Shirt Shop would report on the balance sheet, assuming the following cost flowassumptions: (1) FIFO, (2) LIFO, and (3) weighted average.b. Compute the difference in gross margin between the FIFO and LIFO cost flow assumptions.400 units200 units280 units90 unitsComplete this question by entering your answers in the tabs below.Required BEnding inventory@@FIFO$8 = $3,200$10 =2,000$13 =3,640$15 =1,350Compute the amount of ending inventory The Shirt Shop would report on the balance sheet, assuming the following cost flowassumptions: (1) FIFO, (2) LIFO, and (3) weighted average. (Round intermediate calculations to 2 decimal places and finalanswers to nearest whole dollar amount.)LIFOWeightedAverage< Required ARequired B >

Under the FIFO method, the oldest products in inventory are sold first. Under the LIFO method, the…

The Shirt Shop had the following transactions for T-shirts for Year 1, its first year of operations: Jan. 20 Purchased Apr. 21 Purchased July 25 Purchased Sept. 19 Purchased Required A Required B 400 units 200 units 280 units 90 units During the year, The Shirt Shop sold 810 T-shirts for $20 each. Required a. Compute the amount of ending inventory The Shirt Shop would report on the balance sheet, assuming the following cost flow assumptions: (1) FIFO, (2) LIFO, and (3) weighted average. b. Compute the difference in gross margin between the FIFO and LIFO cost flow assumptions. Complete this question by entering your answers in the tabs below. Ending inventory @ $8 = @ $10 = @ $13 = @ $15 = FIFO Compute the amount of ending inventory The Shirt Shop would report on the balance sheet, assuming the following cost flow assumptions: (1) FIFO, (2) LIFO, and (3) weighted average. (Round intermediate calculations to 2 decimal places and final answers to nearest whole dollar amount.) $3,200 2,000 3,640 1,350 LIFO Weighted Average

The Shirt Shop had the following transactions for T-shirts for Year 1, its first year of operations: Jan. 20 Purchased Apr. 21 Purchased July 25 Purchased Sept. 19 Purchased Required A Required B 400 units 200 units 280 units 90 units During the year, The Shirt Shop sold 810 T-shirts for $20 each. Required a. Compute the amount of ending inventory The Shirt Shop would report on the balance sheet, assuming the following cost flow assumptions: (1) FIFO, (2) LIFO, and (3) weighted average. b. Compute the difference in gross margin between the FIFO and LIFO cost flow assumptions. Complete this question by entering your answers in the tabs below. Ending inventory @ $8 = @ $10 = @ $13 = @ $15 = FIFO Compute the amount of ending inventory The Shirt Shop would report on the balance sheet, assuming the following cost flow assumptions: (1) FIFO, (2) LIFO, and (3) weighted average. (Round intermediate calculations to 2 decimal places and final answers to nearest whole dollar amount.) $3,200 2,000 3,640 1,350 LIFO Weighted Average

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter7: Inventory Cost Flow Assumptions (fifolifo)

Section: Chapter Questions

Problem 9R: Click the Chart sheet tab. On the screen is a column chart showing ending inventory costs. During a...

See similar textbooks

Similar questions

Masonrys records show the raw materials inventory had purchases of $1,000and an ending raw materials inventory balance of $200. If the cost of materials used during the month was $900, what was the beginning inventory?
Click the Chart sheet tab. On the screen is a column chart showing ending inventory costs. During a deflationary period, which bar (A, B, or C) represents FIFO costing, which represents LIFO costing, and which represents weighted average? Explain your reasoning. On January 4 following year-end, Rio Enterprises received a shipment of 60 units of product costing 580 each. These units had been ordered by Del in December and had been shipped to him on December 27. They were shipped FOB shipping point. Revise the FIFOLIFO3 worksheet to include this shipment. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as FIFOLIFOT. Using the FIFOLIFO3 file, prepare a 3-D bar (stacked) chart showing the cost of goods sold and ending inventory under each of the four inventory cost flow assumptions. No Chart Data Table is needed. Use the values in the Calculations Section of the worksheet for your chart. Enter your name somewhere on the chart. Save the file again as FIFOLIFO3. Print the chart.
Logo Gear purchased $2,250 worth of merchandise during the month, and its monthly income statement shows cost of goods sold of $2,000. What was the beginning inventory if the ending inventory was $1,000?
The Shirt Shop had the following transactions for T-shirts for Year 1, its first year of operations: January 20 April 21 July 25 $12 = $13 = 410 units 130 units 230 units 80 units $14 = September 19 $15 During the year, The Shirt Shop sold 680 T-shirts for $20 each. Required a. Compute the amount of ending inventory The Shirt Shop would report on the balance sheet, assuming the following cost flow assumptions: (1) FIFO, (2) LIFO, and (3) weighted average. b. Compute the difference in gross margin between the FIFO and LIFO cost flow assumptions. Required A Purchased Purchased Purchased Purchased Complete this question by entering your answers in the tabs below. Ending inventory Required B Compute the amount of ending inventory The Shirt Shop would report on the balance sheet, assuming the following cost flow assumptions: (1) FIFO, (2) LIFO, and (3) weighted average. Note: Round intermediate calculations to 2 decimal places and final answers to the nearest whole dollar amount. FIFO @ @ @…
Presented below is information for Chivu Company for the month of March 2020 Cost of goods sold S50,000 Salaries and wages Expense s8,000 Freight-out 7,000 Sales Revenue is0,000 Interest Expense Sales Returns and Allowances 4,000 3,000 Required: Prepare a multiple-step income statement for the month of March by completing the following Salaries and wages Expense Operating Expense Total Operating Expense
Presented below is information for Chivu Company for the month of March 2020: Cost of goods sold s50,000 Salaries and wages Expense S8,000 Sales Revenue Freight-out 7.000 as0,000 Sales Returns and Allowances interest Expense 4,000 3,000 Required: Prepare a multiple-step income statement for the month of March by completing the following Salaries and wages Expense Operating Expense Total Operating Expense
Calculate the cost of the inventory purchased for the purchasing company: Invoice price of goods is $4,000. Purchase terms are 2/10, n/30 and the invoice is paid one week after it was received. The shipping terms are FOB destination and the shipping costs are $300.
1. DeForest Company had the following transactions for the month. Sales for the month are $85 per unit. Number of Units Cost per Unit Total Beginning inventory 500 $40 $20,000 Purchased Apr. 30 600 45 27,000 Purchased Aug. 15 650 40 26,000 Purchased Dec. 10 700 35 24,500 Totals (goods available) 2,450 97,500 Ending Inventory 550 ? In the table below, calculate the dollar value for the period for each of the following items using the listed cost allocation methods and using…
1. A business operate based on a mark-up cost of 40%. If the opening and closing inventories were Gh 3,100 and Gh 4,000 respectively,while purchases were Gh 42,100. What was the value for sales? 2. The following related to God's blessings enterprises for the year ended 31 December 2019. Production cost of goods Production of cost goods completed sales Gh Sales 1,080,000 Inventory of finished goods at a cost. 1,939,500 Inventory of finished goods at a cost 255,000 Selling and distribution 216,000 expenses. Administrative expenses. 180,000 Financial charges 48,000 Goods are transferred to the ware house at a cost plus 100/3%. (a).What is the value of opening inventories. (b)What is the closing inventories.
Russell Retail Group begins the year with inventory of $55000 and ends the year with inventory of $45,000. During the year, the company has four purchases for the following amounts. Purchase on February 17 Purchase on May 6 Purchase on September 8 Purchase on December 4 S210,000 130,000 160,000 410,000 Required: Calculate cost of goods sold for the year.
Crane Marine Products began the year with 10 units of marine floats at a cost of $13.60 each. During the year, it made the following purchases: May 5, 30 units at $19.80; July 16, 15 units at $24.20; and December 7, 20 units at $29.50. Assuming there are 25 units on hand at the end of the period, determine the cost of goods sold under (a) FIFO, (b) LIFO, and (c) average-cost. Crane uses the periodic approach. FIFO LIFO Average-cost $ LA LA tA $ Cost of Goods Sold
DeForest Company had the following transactions for the month. Sales for the month are $85 per unit. In the table below, calculate the dollar value for the period for each of the following items using the listed cost allocation methods and using periodic inventory updating. PLEASE NOTE: All dollar amounts will be rounded to whole dollars using "$" with commas as needed (i.e. $12,345), except for the Weighted Average cost per unit, which will be rounded to two decimal places and include "$" (i.e. $12,345.67). Weighted average cost per unit = per unit. Cost Allocation Method Cost of Goods Available Cost of Goods Sold Ending Inventory Sales Gross Margin First-in, First-out (FIFO) Last-in, First-out (LIFO) Weighted Average (AVG)