Question

In: Accounting

Required information Problem 8-5 (Algo) Various inventory costing methods [LO8-1, 8-4] Skip to question [The following...

Required information

Problem 8-5 (Algo) Various inventory costing methods [LO8-1, 8-4]

Skip to question

[The following information applies to the questions displayed below.]


Ferris Company began January with 7,000 units of its principal product. The cost of each unit is $6. Merchandise transactions for the month of January are as follows:

Purchases
Date of Purchase Units Unit Cost* Total Cost
Jan. 10 6,000 $ 7 $ 42,000
Jan. 18 7,000 8 56,000
Totals 13,000 98,000


* Includes purchase price and cost of freight.

Sales
Date of Sale Units
Jan. 5 3,000
Jan. 12 1,000
Jan. 20 4,000
Total 8,000


12,000 units were on hand at the end of the month.

Problem 8-5 (Algo) Part 1

Required:
1. Calculate January's ending inventory and cost of goods sold for the month using FIFO, periodic system.

2. Calculate January's ending inventory and cost of goods sold for the month using LIFO, periodic system.
  

4. Calculate January's ending inventory and cost of goods sold for the month using Average cost, periodic system.

5. Calculate January's ending inventory and cost of goods sold for the month using Average cost, perpetual system. (Round average cost per unit to 4 decimal places. Enter sales with a negative sign.)
  

Solutions

Expert Solution

Ans. 1 Total units sold =   8,000
Cost of goods available for sale Cost of goods sold Ending inventory
FIFO: # of Units Cost per Cost of goods # of units Cost per Cost of # of Units in Cost per Ending
Unit Available for sale Sold Unit Goods sold Ending inventory Unit Inventory
Beginning inventory 7000 $6.00 $42,000 7000 $6.00 $42,000 0 $0.00 $0
Purchases:
10-Jan 6000 $7.00 $42,000 1000 $7.00 $7,000 5000 $7.00 $35,000
18-Jan 7000 $8.00 $56,000 0 $0.00 7000 $8.00 $56,000
Total 20000 $140,000 8000 $49,000 12000 $91,000
*In FIFO method the units that have purchased first, are released the first one and the ending inventory units remain from the last purchases.
Ans. 2 Cost of goods available for sale Cost of goods sold Ending inventory
LIFO: # of Units Cost per Cost of goods # of units Cost per Cost of # of Units in Cost per Ending
Unit Available for sale Sold Unit Goods sold Ending inventory Unit Inventory
Beginning inventory 7000 $6.00 $42,000 0 $0.00 $0 7000 $6.00 $42,000
Purchases:
10-Jan 6000 $7.00 $42,000 1000 $7.00 $7,000 5000 $7.00 $35,000
18-Jan 7000 $8.00 $56,000 7000 $8.00 $56,000 0 $0.00 $0
Total 20000 $140,000 8000 $63,000 12000 $77,000
*In LIFO method the units that have purchased last, are released the first one and ending inventory units remains from the first purchases.


Related Solutions

Required information Problem 8-1 (Algo) Various inventory transactions; journal entries [LO8-1, 8-2, 8-3] Skip to question...
Required information Problem 8-1 (Algo) Various inventory transactions; journal entries [LO8-1, 8-2, 8-3] Skip to question [The following information applies to the questions displayed below.] James Company began the month of October with inventory of $16,000. The following inventory transactions occurred during the month: The company purchased merchandise on account for $23,500 on October 12. Terms of the purchase were 2/10, n/30. James uses the net method to record purchases. The merchandise was shipped f.o.b. shipping point and freight charges...
Problem 8-1 (Algo) Various inventory transactions; journal entries [LO8-1, 8-2, 8-3] Skip to question [The following...
Problem 8-1 (Algo) Various inventory transactions; journal entries [LO8-1, 8-2, 8-3] Skip to question [The following information applies to the questions displayed below.] James Company began the month of October with inventory of $23,000. The following inventory transactions occurred during the month: The company purchased merchandise on account for $34,000 on October 12. Terms of the purchase were 3/10, n/30. James uses the net method to record purchases. The merchandise was shipped f.o.b. shipping point and freight charges of $580...
Required information The Foundational 15 (Algo) [LO8-2, LO8-3, LO8-4, LO8-5, LO8-7, LO8-9, LO8-10] Skip to question...
Required information The Foundational 15 (Algo) [LO8-2, LO8-3, LO8-4, LO8-5, LO8-7, LO8-9, LO8-10] Skip to question [The following information applies to the questions displayed below.] Morganton Company makes one product and it provided the following information to help prepare the master budget: The budgeted selling price per unit is $70. Budgeted unit sales for June, July, August, and September are 9,400, 25,000, 27,000, and 28,000 units, respectively. All sales are on credit. Thirty percent of credit sales are collected in...
Problem 9-13 (Algo) Retail inventory method; various applications [LO9-3, 9-4, 9-5] Skip to question [The following...
Problem 9-13 (Algo) Retail inventory method; various applications [LO9-3, 9-4, 9-5] Skip to question [The following information applies to the questions displayed below.] On January 1, 2021, Pet Friendly Stores adopted the retail inventory method. Inventory transactions at both cost and retail, and cost indexes for 2021 and 2022 are as follows: 2021 2022 Cost Retail Cost Retail Beginning inventory $ 121,600 $ 190,000 Purchases 520,000 708,000 $ 630,000 $ 1,056,000 Purchase returns 2,500 5,000 3,000 3,600 Freight-in 4,200 6,000...
Required information Problem 8-2B Record notes payable and notes receivable (LO8-2) Skip to question [The following...
Required information Problem 8-2B Record notes payable and notes receivable (LO8-2) Skip to question [The following information applies to the questions displayed below.] Eskimo Joe’s, designer of the world’s second best-selling T-shirt (just behind Hard Rock Cafe), borrows $21 million cash on November 1, 2021. Eskimo Joe’s signs a six-month, 7% promissory note to Stillwater National Bank under a prearranged short-term line of credit. Interest on the note is payable at maturity. Each firm has a December 31 year-end. 2....
Problem 8-31 (Algo) Completing a Master Budget [LO8-2, LO8-4, LO8-7, LO8-8, LO8-9, LO8-10] Hillyard Company, an...
Problem 8-31 (Algo) Completing a Master Budget [LO8-2, LO8-4, LO8-7, LO8-8, LO8-9, LO8-10] Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances: Cash $ 59,000 Accounts receivable 215,200 Inventory 60,600 Buildings and equipment (net) 369,000 Accounts payable $...
Problem 8-10 (Algo) LIFO liquidation [LO8-4, 8-6] Cansela Corporation reports inventory and cost of goods sold...
Problem 8-10 (Algo) LIFO liquidation [LO8-4, 8-6] Cansela Corporation reports inventory and cost of goods sold based on calculations from a LIFO periodic inventory system. The company began 2021 with inventory of 6,800 units of its only product. The beginning inventory balance of $82,000 consisted of the following layers:    3,300 units at $10 per unit = $ 33,000 3,500 units at $14 per unit = 49,000 Beginning inventory $ 82,000    During the three years 2021–2023 the cost of...
Required information Great Adventures Problem AP3-1 Skip to question [The following information applies to the questions...
Required information Great Adventures Problem AP3-1 Skip to question [The following information applies to the questions displayed below.] Tony and Suzie graduate from college in May 2021 and begin developing their new business. They begin by offering clinics for basic outdoor activities such as mountain biking or kayaking. Upon developing a customer base, they’ll hold their first adventure races. These races will involve four-person teams that race from one checkpoint to the next using a combination of kayaking, mountain biking,...
Problem 8-30 (Algo) Integration of the Sales, Production, and Direct Materials Budgets [LO8-2, LO8-3, LO8-4] Milo...
Problem 8-30 (Algo) Integration of the Sales, Production, and Direct Materials Budgets [LO8-2, LO8-3, LO8-4] Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 40,000 October 30,000 August 90,000 November 16,500 September 59,000 December 17,000 The selling price of the beach umbrellas is $11 per...
Exercise 8-16 (Algo) Direct Materials and Direct Labor Budgets [LO8-4, LO8-5] The production department of Zan...
Exercise 8-16 (Algo) Direct Materials and Direct Labor Budgets [LO8-4, LO8-5] The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 7,000 10,000 9,000 8,000 In addition, 8,750 grams of raw materials inventory is on hand at the start of the 1st Quarter and the beginning accounts payable for the 1st Quarter is $5,200. Each...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT