Shepherd Cycles started May with 5 bicycles that cost $48 each. On May 16, Shepherd purchased 30 bicycles at $55 each. On May 31, Shepherd sold 21 bicycles for $110 each. Requirements 1. 2. Requirement 1. Prepare Shepherd Cycle's perpetual inventory record assuming the company uses the FIFO inventory costing method. Start by entering the beginning inventory balances. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of inventory purchased, sold, and on hand at the end of the period. (Enter the oldest inventory layers first. Abbreviation used: QTY = Quantity; Tot. = Total) Shepherd Cycles Date May 1 May 16 Prepare Shepherd Cycle's perpetual inventory record assuming the company uses the FIFO inventory costing method. Journalize the May 16 purchase of merchandise inventory on account and the May 31 sale of merchandise inventory on account. May 31 Purchases QTY Unit Cost Tot. Cost 30 $ 55 $ 1,650 Cost of Goods Sold QTY Unit Cost Tot. Cost 5 16 S 48 S $ 240 2070 Inventory on Hand QTY Unit Cost Tot. Cost 48 $ 240 5 $ 5 $ 48 $ 240 30 $ 55 $ 1,650

Shepherd Cycles started May with 5 bicycles that cost $48 each. On May 16, Shepherd purchased 30 bicycles at $55 each. On May 31, Shepherd sold 21 bicycles for $110 each. Requirements 1. 2. Requirement 1. Prepare Shepherd Cycle's perpetual inventory record assuming the company uses the FIFO inventory costing method. Start by entering the beginning inventory balances. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of inventory purchased, sold, and on hand at the end of the period. (Enter the oldest inventory layers first. Abbreviation used: QTY = Quantity; Tot. = Total) Shepherd Cycles Date May 1 May 16 Prepare Shepherd Cycle's perpetual inventory record assuming the company uses the FIFO inventory costing method. Journalize the May 16 purchase of merchandise inventory on account and the May 31 sale of merchandise inventory on account. May 31 Purchases QTY Unit Cost Tot. Cost 30 $ 55 $ 1,650 Cost of Goods Sold QTY Unit Cost Tot. Cost 5 16 S 48 S $ 240 2070 Inventory on Hand QTY Unit Cost Tot. Cost 48 $ 240 5 $ 5 $ 48 $ 240 30 $ 55 $ 1,650

Name: Shepherd Cycles started May with 5 bicycles that cost $48 each. On Ma
Uploaded: 2024-03-20T06:32:37.000Z
Channel: Bartleby
Description: Shepherd Cycles started May with 5 bicycles that cost $48 each. On May 16, Shepherd purchased 30 bicycles at $55 each. On May 31, Shepherd sold 21 bicycles for $110 each.Requirements1.2.DateMay 1May 16Prepare Shepherd Cycle's perpetual inventory rec

Financial Accounting

15th Edition

ISBN:9781337272124

Author:Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:Carl Warren, James M. Reeve, Jonathan Duchac

Chapter7: Inventories

Section: Chapter Questions

Problem 4PB: The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are...

See similar textbooks

Related questions

Q: Trey Monson starts a merchandising business on December 1 and enters into the following three…

A: Introduction: FIFO: FIFO stands for First in First out. Which means first received inventory to be…

Q: Futuristic Electronic Center began October with 100 units of merchandise inventory that cost $70…

A: Weighted Average Method :— It is one of the method of inventory valuation in which it is assumed…

Q: New Tech Cycles started March with 5 bicycles that cost $48 each. On March 16, New Tech purchased 30…

A: The inventory can be valued using various methods as LIFO, FIFO and weighted average method. Using…

Q: Trey Monson starts a merchandising business on December 1 and enters into three inventory purchases:…

A: Weighted average method is a method of inventory valuation where unit cost of goods available is…

Q: Pink Company has beginning inventory of 24 units at a cost of $12.00 each on May 1. On June 5, it…

A: In case of LIFO method latest goods will be sold first. Thus ending inventory consists of goods…

Q: The Boxwood Company sells blankets for $35.00 each. The following was taken from the inventory…

A: METHOD LIFO - LAST IN FIRST OUT : DATE PURCHASE SALE BALANCE MAY 03 9 UNITS X $18 MAY…

Q: nit. On November 2, the company purchased 10 units at $ nit. Then, on November 8, the company sold…

A: Answer :LIFO = Last in first out Cost of good sold = Unit sold * cost per unit

Q: A company reports the following beginning inventory and two purchases for the month of January. On…

A: Lets understand the basics.inventory and cost of goods sold can be calculated using,(1) FIFO(2)…

Q: Required information Use the following information for the Quick Study below. (Algo) (15-18) [The…

A: Under specific identification method each item of inventory is identified and its cost record is…

Q: A company uses a periodic inventory system. On August 1, the company had 6 items of beginning…

A: As per the Specification identification method cost is ascertained on the basis of units issued/sold…

Q: Marigold Company uses a perpetual inventory system. Its beginning inventory consists of 60 units…

A: Sales on account means credit sales.

Q: A company reports the following beginning inventory and 2 purchases for the month of January. On…

A: LIFO: LIFO stands for Last-In, First-Out. In this method inventory purchased at last will be sell…

Q: Perpetual FIFO: Goods purchased Cost of Goods Sold Inventory Balance # of units Cost per unit # of…

A: FIFO Method-First-In, First-Out Under this method , oldest products of a company's inventory is…

Q: 1) Specific identification method assuming: (i) The March 5 sale consisted of 1,000 liters from the…

A: Specific identification method- Under specific identification method goods are identified on the…

Q: Oahu Kiki tracks the number of units purchased and sold throughout each accounting period but…

A: Inventory includes all the items, merchandise, and raw materials that are used by the business…

Q: Determine the costs assigned to ending inventory when costs are assigned based on the LIFO method.

A: Organizations follow different types of inventory accounting based on the industry and the products…

Q: Thraya Industries had the following transactions in the month of March. Thraya uses a perpetual…

A: The objective of the question is to calculate the cost of goods sold, ending inventory, and gross…

Q: Fancy Iron began August with 45 units of iron inventory that cost $24 each. During August, the…

A: Perpetual system of inventory states that the inventory would be continuously managed as well as…

Q: Coronado Company uses a perpetual inventory system. Its beginning inventory consists of 80 units…

A: Inventory: Inventory refers to the unit of goods that are purchased or produced to sell. They are…

Concept explainers

Inventory Valuation

Before discussing the topic inventory valuation let’s discuss the meaning of inventory. In accounting, inventory is also known as stock. Inventory means all the finished goods, materials, merchandise that a business holds for the purpose of selling it in the market with the motive of earning profit.

Topic Video

Question

Shepherd Cycles started May with 5 bicycles that cost $48 each. On May 16, Shepherd purchased 30 bicycles at $55 each. On May 31, Shepherd sold 21 bicycles for $110 each.
Requirements
1.
2.
Date
May 1
May 16
Prepare Shepherd Cycle's perpetual inventory record assuming the company uses the FIFO inventory costing method.
Journalize the May 16 purchase of merchandise inventory on account and the May 31 sale of merchandise inventory on account.
Requirement 1. Prepare Shepherd Cycle's perpetual inventory record assuming the company uses the FIFO inventory costing method.
Start by entering the beginning inventory balances. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of
inventory purchased, sold, and on hand at the end of the period. (Enter the oldest inventory layers first. Abbreviation used: QTY = Quantity; Tot. = Total)
Shepherd Cycles
May 31
Purchases
QTY Unit Cost Tot. Cost
30 $ 55 $
1,650
Cost of Goods Sold
QTY Unit Cost Tot. Cost
5 $
16
48 $
240
2070
Inventory on Hand
QTY Unit Cost Tot. Cost
5 $
48 $
48 $
55 $
5 $
30 $
C
240
240
1,650

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Introduction:

VIEW

Step 2: Part 1 & 2:

VIEW

Solution

VIEW

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

On April 5, a customer returns 20 bicycles with a sales price of $250 per bike to Barrio Bikes. Each bike cost Barrio Bikes $100. The customer had yet to pay on their account. The bikes are in sellable condition. Prepare the journal entry or entries to recognize this return if the company uses A. the perpetual inventory system B. the periodic inventory system
Jessie Stores uses the periodic system of calculating inventory. The following information is available for December of the current year when Jessie sold 500 units of inventory. Using the FIFO method, calculate Jessies inventory on December 31 and its cost of goods sold for December.
West Bicycle Shop uses a three-column purchases journal. The company is located in Topeka, Kansas. In addition to a general ledger, the company also uses an accounts payable ledger. Transactions for January related to the purchase of merchandise are as follows: Jan. 4 Bought fifty 10-speed bicycles from Nielsen Company, 4,775, invoice no. 26145, dated January 3; terms net 60 days; FOB Topeka. 7 Bought tires from Barton Tire Company, 792, invoice no. 9763, dated January 5; terms 2/10, n/30; FOB Topeka. 8 Bought bicycle lights and reflectors from Gross Products Company, 384, invoice no. 17317, dated January 6; terms net 30 days; FOB Topeka. 11 Bought hand brakes from Bray, Inc., 470, invoice no. 291GE, dated January 9; terms 1/10, n/30; FOB Kansas City, freight prepaid and added to the invoice, 36 (total 506). 19 Bought handle grips from Gross Products Company, 96.50, invoice no. 17520, dated January 17; terms net 30 days; FOB Topeka. 24 Bought thirty 5-speed bicycles from Nielsen Company, 1,487, invoice no. 26942, dated January 23; terms net 60 days; FOB Topeka. 29 Bought knapsacks from Davila Manufacturing Company, 304.80, invoice no. 762AC, dated January 26; terms 2/10, n/30; FOB Topeka. 31 Bought locks from Lamb Safety Net, 415.47, invoice no. 27712, dated January 26; terms 2/10, n/30; FOB Dodge City, freight prepaid and added to the invoice, 22 (total 437.47). Required 1. If using Working Papers, open the following accounts in the accounts payable ledger and record the January 1 balances, if any, as given: Barton Tire Company, 156; Bray, Inc.; Davila Manufacturing Company, 82.88; Gross Products Company; Lamb Safety Net, 184.20; Nielsen Company. For the accounts having balances, write Balance in the Item column and place a check mark in the Post. Ref. column. Skip this step if using CengageNow or CLGL. 2. If using Working Papers, record the balance of 423.08 in the Accounts Payable 212 controlling account as of January 1. Write Balance in the Item column and place a check mark in the Post. Ref. column. Skip this step if using CengageNow or CLGL. 3. Record the transactions in the purchases journal. If using Working Papers, begin on page 81. 4. Post to the accounts payable ledger daily. Skip this step if using CLGL. 5. Post to the general ledger at the end of the month. Skip this step if using CLGL. 6. Prepare a schedule of accounts payable, and compare the balance of the Accounts Payable controlling account with the total of the schedule of accounts payable.
Dymac Appliances uses the periodic inventory system. Details regarding the inventory of appliances at January 1, purchases invoices during the next 12 months, and the inventory count at December 31 are summarized as follows: Instructions 1. Determine the cost of the inventory on December 31 by the first-in, first-out method. Present data in columnar form, using the following headings: If the inventory of a particular model comprises one entire purchase plus a portion of another purchase acquired at a different unit cost, use a separate line for each purchase. 2. Determine the cost of the inventory on December 31 by the last-in, first-out method, following the procedures indicated in (1). 3. Determine the cost of the inventory on December 31 by the weighted average cost method, using the columnar headings indicated in (1). 4. Discuss which method (FIFO or LIFO) would be preferred for income tax purposes in periods of (a) rising prices and (b) declining prices.
Beginning inventory, purchases, and sales for Item Widget are as follows: Assuming a perpetual inventory system and using the first-in, first-out (FIFO) method, determine (a) the cost of merchandise sold on March 25 and (b) the inventory on March 31.
Carla Company uses the perpetual inventory system. The following information is available for January of the current year when Carla sold 1,600 units of inventory on January 14. Using the FIFO method, calculate Carlas cost of goods sold for January and its January 31 inventory.
The beginning inventory for Dunne Co. and data on purchases and sales for a three-month period are shown in Problem 7-1B. Instructions 1. Determine the inventory on June 30 and the cost of merchandise sold for the three-month period, using the first-in, first-out method and the periodic inventory system. 2. Determine the inventory on June 30 and the cost of merchandise sold for the three-month period, using the last-in, first-out method and the periodic inventory system. 3. Determine the inventory on June 30 and the cost of merchandise sold for the three-month period, using the weighted average cost method and the periodic inventory system. Round the weighted average unit cost to the dollar. 4. Compare the gross profit and June 30 inventories using the following column headings:
WORK SHEET EXTENSIONS FOR MERCHANDISE INVENTORY ADJUSTMENTS: PERIODIC INVENTORY SYSTEM The following partial work sheet is taken from Kevins Gift Shop for the year ended December 31, 20--. The ending merchandise inventory is 50,000. 1. Complete the Adjustments columns for the merchandise inventory. 2. Extend the merchandise inventory to the Adjusted Trial Balance and Balance Sheet columns. 3. Extend the remaining accounts to the Adjusted Trial Balance and Income Statement columns. 4. Prepare a cost of goods sold section from the partial work sheet.
Beginning inventory, purchases, and sales for Item Zebra 9x are as follows: Assuming a perpetual inventory system and using the last-in, first-out (LIFO) method, determine (a) the cost of merchandise sold on April 27 and (b) the inventory on April 30.
WORK SHEET EXTENSIONS FOR MERCHANDISE INVENTORY ADJUSTMENTS: PERIODIC INVENTORY SYSTEM The following partial work sheet is taken from Nicoles Gift Shop for the year ended December 31, 20--. The ending merchandise inventory is 37,000. 1. Complete the Adjustments columns for the merchandise inventory. 2. Extend the merchandise inventory to the Adjusted Trial Balance and Balance Sheet columns. 3. Extend the remaining accounts to the Adjusted Trial Balance and Income Statement columns. 4. Prepare a cost of goods sold section from the partial work sheet.
Recording Sale and Purchase Transactions Jordan Footwear sells athletic shoes and uses the perpetual inventory system. During June, Jordan engaged in the following transactions its first month of operations: a. On June1, Jordan purchased, on credit, 100 pairs of basketball shoes and 210 pairs of running shoes with credit terms of 2/10, n/30. The basketball shoes were purchased at a cost of $85 per pair, and the running shoes were purchased at a cost of $60 per pair. Jordan paid Mole Trucking $310 cash to transport the shoes from the manufacturer to Jordans warehouse, shipping terms were F.O.B. shipping point, and the items were shipped on June 1 and arrived on June 4. b. On June 2, Jordan purchased 88 pairs of cross-training shoes for cash. The shoes cost Jordan $65 per pair. c. On June 6, Jordan purchased 125 pairs of tennis shoes on credit. Credit terms were 2/10, n/25. The shoes were purchased at a cost of $45 per pair. d. On June 10, Jordan paid for the purchase of the basketball shoes and the running shoes in Transaction a. e. On June 12, Jordan determined that $585 of the tennis shoes were defective. Jordan returned the defective merchandise to the manufacturer. f. On June 18, Jordan sold 50 pairs of basketball shoes at $116 per pair, 92 pairs of running shoes for S85 per pair, 21 pairs of cross-training shoes for $100 per pair, and 48 pairs of tennis shoes for $68 per pair. All sales were for cash. The cost of the merchandise sold was $13,295. No sales returns are expected. g. On June 21, customers returned 10 pairs of the basketball shoes purchased on June 18. The cost of the merchandise returned was $850. h. On June 23, Jordan sold another 20 pairs of basketball shoes, on credit, for $116 per pair and 15 pairs of cross-training shoes for $100 cash per pair. The cost of the merchandise sold was $2,675. i. On June 30, Jordan paid for the June 6 purchase of tennis shoes minus the return on June 12. j. On June 30, Jordan purchased 60 pairs of basketball shoes, on credit, for S85 each. The shoes were shipped F.O.B. destination and arrived at Jordan on July 3. Required: 1. Prepare the journal entries to record the sale and purchase transactions for Jordan during June 2019. 2. Assuming operating expenses of $5,300 and income taxes of $365, prepare Jordans income statement for June 2019.
Sunrise Flowers sells flowers to a customer on credit for $130 on October 18, with a cost of sale to Sunrise of $50. What entry to recognize this sale is required if Sunrise Flowers uses a perpetual inventory system?