(Learning Objective 4: Compute and evaluate gross profit percentage and inventory turnover) The Red Wagon Shop had the following inventory data:2017Ending inventory at:FIFO Cost ...............LIFO Cost...............2018$27,92012,510$ 30,50020,150Cost of goods sold at:FIFO Cost ...............LIFO Cost...............Sales revenue ...............$ 87,63097,980138,000Company managers need to know the company’s gross profit percentage and rate of inventoryturnover for 2018 under1. FIFO.2. LIFO.Which method produces a higher gross profit percentage? A higher inventory turnover?

(Learning Objective 4: Compute and evaluate gross profit percentage and inventory turnover) The Red Wagon Shop had the following inventory data:2017Ending inventory at:FIFO Cost ...............LIFO Cost...............2018$27,92012,510$ 30,50020,150Cost of goods sold at:FIFO Cost ...............LIFO Cost...............Sales revenue ...............$ 87,63097,980138,000Company managers need to know the company’s gross profit percentage and rate of inventoryturnover for 2018 under1. FIFO.2. LIFO.Which method produces a higher gross profit percentage? A higher inventory turnover?

Name: (Learning Objective 4: Compute and evaluate gross profit percentage an
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: (Learning Objective 4: Compute and evaluate gross profit percentage and inventory turnover) The Red Wagon Shop had the following inventory data:2017Ending inventory at:FIFO Cost ...............LIFO Cost...............2018$27,92012,510$ 30,50020,150Co

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter16: Manufacturing Accounting (mfg)

Section: Chapter Questions

Problem 3R: The following data pertain to 2012 activities of Twisp Industries: Use your completed worksheet to...

See similar textbooks

Similar questions

(Learning Objectives 1, 2: Show how to account for inventory transactions; applythe FIFO cost method) Accounting records for Allegheny Corporation yield the followingdata for the year ended June 30, 2018:Inventory, June 30, 2017.......................................................................... $ 13,000Purchases of inventory (on account)......................................................... 53,000Sales of inventory—82% on account; 18% for cash (cost $46,000).........Inventory at FIFO, June 30, 2018 ............................................................73,00020,000Requirements1. Journalize Allegheny’s inventory transactions for the year under the perpetual system.2. Report ending inventory, sales, cost of goods sold, and gross profit on the appropriatefinancial statement
(Learning Objective 2: Calculate purchases by analyzing inventory account activity)On Willow Grove Department Stores’ most recent balance sheet, the balance of its inventory at the beginning of the year was $12,000. At the end of the year, the inventory balancewas $14,500. During that year, its cost of goods sold was $55,000. All purchases of inventorythroughout the year were on account. What was the total of Willow Grove’s purchases duringthe year?
(Learning Objectives 1, 2: Show how to account for inventory transactions; applythe FIFO cost method) Accounting records for Jubilee Corporation yield the following datafor the year ended June 30, 2018 (assume sales returns are non-existent):Inventory, June 30, 2017.......................................................................... $ 7,000Purchases of inventory (on account)......................................................... 61,000Sales of inventory—77% on account; 23% for cash (cost $49,000).........Inventory at FIFO, June 30, 2018 ............................................................100,00019,000Requirements1. Journalize Jubilee’s inventory transactions for the year under the perpetual system.2. Report ending inventory, sales, cost of goods sold, and gross profit on the appropriatefinancial statement.
(Learning Objective 2: Apply various inventory costing methods) A Gold MedalSports outlet store began August 2018 with 42 pairs of running shoes that cost the store $31each. The sales price of these shoes was $63. During August, the store completed these inventory transactions:Units Unit CostSale ............. 16 $319 Purchase...... 81 33$6313 Sale ............. 26 31 63Sale ............. 33 6422 Sale ............. 36 33 6429 Purchase...... 18 35Aug 218 13Unit Sales PriceRequirements1. The preceding data are taken from the store’s perpetual inventory records. Which costmethod does the store use? Explain how you arrived at your answer.2. Determine the store’s cost of goods sold for August. Also compute gross profit for August.3. What is the cost of the store’s August 31 inventory of running shoes?
(Learning Objectives 4, 5: Compute gross profit; estimate inventory using the grossprofit method) Cleveland Company, a camera store, lost some inventory in a fire on October15. To file an insurance claim, the company must estimate its October 15 inventory using thegross profit method. For the past two years, Cleveland Company’s gross profit has averaged41% of net sales. Its inventory records reveal the following data:Inventory, October 1................ $ 57,700Transactions October 1–15:Purchases ................................. 490,800Purchase discounts................... 17,000Purchase returns....................... 70,900Sales......................................... 660,000Requirements1. Estimate the cost of the lost inventory using the gross profit method.2. Prepare the income statement for October 1 to October 15 for this product through grossprofit. Show the detailed computations of cost of goods sold in a separate schedule.
(Learning Objective 2: Compare inventory by three methods) Navy Surplus beganJuly 2018 with 80 stoves that cost $10 each. During the month, the company made the following purchases at cost:1826July 6 90 stoves @ $20100 stoves @ $2530 stoves @ $30= $1,800= 2,500= 900The company sold 250 stoves, and at July 31, the ending inventory consisted of 50 stoves. Thesales price of each stove was $52.Requirements1. Determine the cost of goods sold and ending inventory amounts for July under the averagecost, FIFO, and LIFO costing methods. Round the average cost per unit to two decimalplaces, and round all other amounts to the nearest dollar.2. Explain why cost of goods sold is highest under LIFO. Be specific.3. Prepare the Navy Surplus income statement for July. Report gross profit. Operating expensestotaled $3,250. The company uses average costing for inventory. The income tax rate is 40%.
Learning Objective 2: Compare ending inventory and cost of goods sold—FIFOvs. LIFO) Paulson’s specializes in sound equipment. Company records indicate the followingdata for a line of speakers:Unit Cost$4964JunDate12713ItemBalance...................Purchase.................Sale ........................Sale ........................Quantity18376Sale Price$115103Requirements1. Determine the amounts that Paulson’s should report for cost of goods sold and endinginventory two ways:a. FIFOb. LIFO2. Paulson’s uses the FIFO method. Prepare the company’s income statement for the monthended June 30, 2018, reporting gross profit. Operating expenses totaled $340, and theincome tax rate was 35%.
(Learning Objective 2: Compare inventory by three methods) SWAT Surplus beganMarch 2018 with 100 tents that cost $10 each. During the month, the company made the following purchases at cost:1826Mar 6 110 tents @ $20120 tents @ $2540 tents @ $30= $2,200= 3,000= 1,200The company sold 318 tents, and at March 31, the ending inventory consisted of 52 tents. Thesales price of each tent was $52.Requirements1. Determine the cost of goods sold and ending inventory amounts for March under theaverage-cost, FIFO, and LIFO costing methods. Round the average cost per unit to twodecimal places, and round all other amounts to the nearest dollar.2. Explain why cost of goods sold is highest under LIFO. Be specific.3. Prepare the SWAT Surplus income statement for March. Report gross profit. Operatingexpenses totaled $3,250. The company uses average costing for inventory. The income taxrate is 36%.
(Learning Objectives 1, 2: Show how to account for inventory transactions; applythe FIFO cost method) Spear Corporation’s inventory records for its retail division show thefollowing at May 31:May 1 Beginning inventory ............... 10 units @ $160 = $1,60015 Purchase................................. 5 units @ 161 = 80526 Purchase................................. 14 units @ 170 = 2,380At May 31, 11 of these units are on hand. Journalize the following for Spear Corporation underthe perpetual system:1. Total May purchases in one summary entry. All purchases were on credit.2. Total May sales and cost of goods sold in two summary entries. The selling price was $560per unit, and all sales were on credit. Assume that Spear uses the FIFO inventory method.3. Under FIFO, how much gross profit would Spear earn for the month ending May 31? Whatis the FIFO cost of Spear Corporation’s ending inventory?
Learning Objectives 1, 2: Show how to account for inventory in a perpetual systemusing the average-costing method) Western Trading Company purchases inventory in cratesof merchandise; each crate of inventory is a unit. The fiscal year of Western Trading ends eachJanuary 31. Assume you are dealing with a single Western Trading store in Nashville, Tennessee. The Nashville store began the year with an inventory of 20,000 units that cost a total of$1,060,000. During the year, the store purchased merchandise on account as follows:July (29,000 units at $59) ..................................... $1,711,000November (49,000 units at $63) ........................... 3,087,000December (59,000 units at $69)............................ 4,071,000Total purchases..................................................... $8,869,000Cash payments on account totaled $8,541,000. During fiscal year 2018, the store sold 155,000units of merchandise for $15,887,500, of which $4,900,000 was for cash and the balance…
(Learning Objective 3: Explain GAAP and apply the lower-of-cost-or-market ruleto inventories) Anderson Trade Mart has recently had lackluster sales. The rate of inventoryturnover has dropped, and the merchandise is gathering dust. At the same time, competitionhas forced Anderson’s suppliers to lower the prices that Anderson will pay when it replacesits inventory. It is now December 31, 2018, and the net realizable value of Anderson’s endinginventory is $55,000 below what the company actually paid for the goods, which was $265,000.Before any adjustments at the end of the period, the Cost of Goods Sold account has a balanceof $820,000.a. What accounting action should Anderson take in this situation?b. Give any journal entry required.c. At what amount should the company report Inventory on the balance sheet?d. At what amount should the company report Cost of Goods Sold on the incomestatement?e. Discuss the accounting principle or concept that is most relevant to this situation
(Learning Objectives 1, 2, 3: Apply GAAP for sales, sales returns, and salesdiscounts) Antique Interiors reported the following transactions in October:Oct 210111519Sold merchandise on account to Tim Hinkel, $1,200, terms 1/10, n/30.Sold merchandise on account to Ben Homan, $2,600, terms 2/10, n/30.Collected payment from Hinkel for the October 2 sale.Homan returned $2,000 of the merchandise purchased on October 10.Collected payment from Homan for the balance of the October 10 sale.Requirements1. Record the foregoing transactions in the journal of Antique Interiors using the grossmethod. (You do not need to make the cost of sales journal entries; assume that these entrieswill be made by the company when it makes its other adjusting entries at period end.)2. Calculate the amount of gross sales minus sales discounts for the month of October.