Question

In: Accounting

Sheffield Inc. has provided you with the following information. This company purchases its inventory from a...

Sheffield Inc. has provided you with the following information. This company purchases its inventory from a supplier for cash and has only cash sales. Sheffield uses the average cost formula in a perpetual inventory system. Increased competition has recently reduced the price of the product.

Date Explanation Units Unit Cost Unit Price
Apr. 1 Beginning inventory 50 $78
6 Purchases 110 89
8 Sales (130 ) $120
15 Purchases 120 68
20 Sales (120 ) 102
27 Purchases 20 59

Based on your answer to part (c), determine whether the company should record a journal entry at the end of April and, if so, prepare the entry. (List all debit entries before credit entries. Credit account titles are automatically indented when the amount is entered. Do not indent manually. Round answers to 2 decimal places, e.g. 1.25. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)
answer to part C was $2450 (49 x 50)

Account Titles and Explanation

Debit

Credit

COGS ?
inventory ?

Solutions

Expert Solution

Account Titles and Explanation Debit Credit
Cost of Goods Sold $875.30
Inventory $875.30
($3,325.30 - $2,450)
Working
Average Cost - Perpetual
Purchases Cost of Goods Sold Inventory Balance
Perpetual Average # of units Cost per unit # of units sold Cost per unit Cost of goods sold # of units Cost per unit Inventory Value
April 1          50 $78.00 $3,900.00
Purchase - April 6        110 $89.00          50 $78.00 $3,900.00
       110 $89.00 $9,790.00
Average cost        160 $85.56 $13,690.00
Sales - April 8             130 $85.56 $11,123          30 $85.56 $2,566.80
Purchase - April 15        120 $68.00          30 $85.56 $2,566.80
       120 $68.00 $8,160.00
Average cost        150 $71.51 $10,726.80
Sale - April 20             120 $71.51 $8,581          30 $71.51 $2,145.30
Purchase - April 27          20 $59.00          30 $71.51 $2,145.30
         20 $59.00 $1,180.00
Average cost             250 $19,704          50 $3,325.30

Related Solutions

You are provided with the following information for Bridgeport Inc., which purchases its inventory from a...
You are provided with the following information for Bridgeport Inc., which purchases its inventory from a supplier for cash and has only cash sales. Bridgeport uses the average cost formula in a perpetual inventory system. Increased competition has recently reduced the price of the product. Date Explanation Units Unit Cost/Price Apr. 1 Beginning inventory 50 $84 6 Purchases 110 87 8 Sales (130 ) 116 15 Purchases 120 71 20 Sales (120 ) 98 27 Purchases 20 62 1. Prepare...
FIFO –LIFO The Inventory Company has provided you with three months of their inventory and purchases...
FIFO –LIFO The Inventory Company has provided you with three months of their inventory and purchases for the last three months: Date Item Quantity Unit Price July 1 Begin Inventory 2,500 $38 July 15 Purchase 3,300 $37 July 29 Purchase 5,500 $36 Aug 11 Purchase 4,100 $36 Aug 30 Purchase 6,700 $35 Sept 14 Purchase 3,900 $34 During three months the company sold 23,200 units.Selling price is $78 and the company’s tax rate is 32%. Required: A.Complete the worksheet for...
Tyler Company has the following information related to purchases and sales of one of its inventory items.
Inventory Costing MethodsTyler Company has the following information related to purchases and sales of one of its inventory items.DateDescriptionUnits Purchased at CostUnits Sold at RetailSept. 1Beginning inventory400 units @ $16Sept. 10Purchase600 units @ $18Sept. 20Sales690 units @ $31Sept. 25Purchase800 units at $19Assume the company uses a perpetual inventory system.Required:Calculate ending inventory and cost of goods sold using the FIFO, LIFO, and average cost methods.FIFOLIFOAvg CostCost of goods sold$fill in the blank 1$fill in the blank 2$fill in the blank 3Ending...
Problem 6-06A a1-a2 (Part Level Submission) You are provided with the following information for Sheffield Inc....
Problem 6-06A a1-a2 (Part Level Submission) You are provided with the following information for Sheffield Inc. Sheffield Inc. uses the periodic method of accounting for its inventory transactions. March 1 Beginning inventory 2,000 liters at a cost of 60¢ per liter. March 3 Purchased 2,500 liters at a cost of 62¢ per liter. March 5 Sold 2,300 liters for $1.05 per liter. March 10 Purchased 4,000 liters at a cost of 69¢ per liter. March 20 Purchased 2,300 liters at...
Problem 6-06A a1-a2 (Part Level Submission) You are provided with the following information for Sheffield Inc....
Problem 6-06A a1-a2 (Part Level Submission) You are provided with the following information for Sheffield Inc. Sheffield Inc. uses the periodic method of accounting for its inventory transactions. March 1 Beginning inventory 2,000 liters at a cost of 60¢ per liter. March 3 Purchased 2,500 liters at a cost of 62¢ per liter. March 5 Sold 2,300 liters for $1.05 per liter. March 10 Purchased 4,000 liters at a cost of 69¢ per liter. March 20 Purchased 2,300 liters at...
When calculating ending inventory under a periodic inventory, you are provided this information: Purchases $88,000; Beginning...
When calculating ending inventory under a periodic inventory, you are provided this information: Purchases $88,000; Beginning Inventory $4,000; Sales Revenue $125,000; physical count of Ending Inventory $7,500. Which of the following is true? Question 23 options: The journal entry to record the ending inventory is Debit Inventory $3,500, Credit Cost of Goods Sold $3,500 Debit Cost of Goods Sold $92,000, Credit Inventory $4,000 and Credit Purchases $88,000 Both a. and b. Neither a. nor b.
You are provided with the following information about Bramble Inc.’s inventory for the month of August:...
You are provided with the following information about Bramble Inc.’s inventory for the month of August: Date Description Units Unit Cost Aug. 1 Beginning inventory 50 $90 4 Purchase 180 91 10 Sale (160 ) 18 Purchase 70 94 25 Sale (100 ) 28 Purchase 40 95 Collapse question part (a) Calculate the cost of ending inventory and cost of goods sold using FIFO in (1) a periodic inventory system, and (2) a perpetual inventory system. Periodic Inventory System Perpetual...
Sheffield Inc. had beginning inventory of $25,200 at cost and $42,000 at retail. Net purchases were...
Sheffield Inc. had beginning inventory of $25,200 at cost and $42,000 at retail. Net purchases were $252,000 at cost and $357,000 at retail. Net markups were $21,000, net markdowns were $14,700, and sales revenue was $308,700. Assume the price level increased from 100 at the beginning of the year to 115 at year-end. Compute ending inventory at cost using the dollar-value LIFO retail method. (Round ratios for computational purposes to 1 decimal place, e.g. 78.7% and final answer to 0...
Simmons Company has the following information about its ending inventory. It values its inventory on an...
Simmons Company has the following information about its ending inventory. It values its inventory on an individual-item basis. Determine the value of the ending inventory. Show your work. Item Quantity Cost Estimated Selling Price Cost to Complete and Sell A 700 $2.25 $3.25 $1.40 B 500 3.00 3.90 0.80 C 3,000 1.80 2.50 1.20 D 1,000 4.70 6.00 1.50
The following information is available for Sheffield Company at December 31, 2018: beginning inventory $139000; ending...
The following information is available for Sheffield Company at December 31, 2018: beginning inventory $139000; ending inventory $121000; cost of goods sold $845000; and sales $1880000. Sheffield’s inventory turnover in 2018 is 14.5 times. 6.2 times. 6.5 times. 6.9 times.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT