Fresh Foods Supermarket is evaluating its inventory management system using the FIFO (First-In-First-Out) method for the first quarter of 2024. On January 1st, they had an opening inventory of 500 units at $8 per unit. During January, they purchased 300 units at $10 per unit on January 15th and another 400 units at $12 per unit on January 30th. The store sold 600 units in January at $20 per unit. At the end of January, management wants to calculate the cost of goods sold (COGS), ending inventory value, and gross profit. They also need to determine the inventory turnover ratio for January, assuming the beginning inventory from January 1st represents the average inventory. For tax purposes, they need to calculate their gross profit margin percentage.

Fresh Foods Supermarket is evaluating its inventory management system using the FIFO (First-In-First-Out) method for the first quarter of 2024. On January 1st, they had an opening inventory of 500 units at $8 per unit. During January, they purchased 300 units at $10 per unit on January 15th and another 400 units at $12 per unit on January 30th. The store sold 600 units in January at $20 per unit. At the end of January, management wants to calculate the cost of goods sold (COGS), ending inventory value, and gross profit. They also need to determine the inventory turnover ratio for January, assuming the beginning inventory from January 1st represents the average inventory. For tax purposes, they need to calculate their gross profit margin percentage.

Intermediate Accounting: Reporting And Analysis

3rd Edition

ISBN:9781337788281

Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Chapter7: Inventories: Cost Measurement And Flow Assumptions

Section: Chapter Questions

Problem 7MC: Questions M7-6 and M7-7 are based on the following data: City Stationers Inc. had 200 calculators on...

See similar textbooks

Similar questions

Langstons purchased $3,100 of merchandise during the month, and its monthly income statement shows a cost of goods sold of $3,000. What was the beginning inventory if the ending inventory was $1,250?
On September 30, 2013, the general ledger of Leons Golf Shop, which uses the calendar year as its accounting period, showed the following year-to-date account balances: The merchandise inventory account had a 48,000 balance on January 1, 2013. The historical gross profit percentage is 40%. Leon prepares quarterly financial statements and takes physical inventory once a yearat the end of the accounting period. In order to prepare the financial statements for the third quarter, the store needs to have an estimate of ending inventory. You have been asked to use the gross profit method to estimate the ending inventory. Review the worksheet called GP. Study it carefully because it may have a solution format somewhat different from the one shown in your textbook.
Golden Eagle Company began operations on April 1 by selling a single product. Data on purchases and sales for the year are as follows: Purchases: Sales: The president of the company, Connie Kilmer, has asked for your advice on which inventory cost flow method should be used for the 32,000-unit physical inventory that was taken on December 31. The company plans to expand its product line in the future and uses the periodic inventory system. Write a brief memo to Ms. Kilmer comparing and contrasting the LIFO and FIFO inventory cost flow methods and their potential impacts on the companys financial statements.
Fitbands estimated sales are: What are the balances in accounts receivable for January, February, and March if 65% of sales is collected in the month of sale, 25% is collected the month after the sale, and 10% is second month after the sale?
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.
Nonnas Re-Appliance Store collects 55% of its accounts receivable in the month of sale and 40% in the month after the sale. Given the following sales, how much cash will be collected in February?
Amusement tickets estimated sales are: What are the balances in accounts receivable for April, May, and June if 60% of sales are collected in the month of sale, 30% are collected the month after the sale, and 10% are collected the second month after the sale?
Questions M7-6 and M7-7 are based on the following data: City Stationers Inc. had 200 calculators on hand on January 1, 2019, costing 18 each. Purchases and sales of calculators during the month of January were as follows: City uses a periodic inventory system. According to a physical count, 150 calculators were on hand at January 31, 2019. M7-6 The cost of the inventory on January 31, 2019, under the FIFO method is: a. 400 b. 2,700 c. 3,100 d. 3,200 M7-7 The cost of the inventory on January 31, 2019, under the LIFO method is: a. 400 b. 2,700 c. 3,100 d. 3,200
Zonkey Enterprises uses LIFO with a periodic inventory system to keep track of its inventory. It began the year with 100 units that cost $10 each. It made the following purchases: January 7, 100 for $12 each; January 22, 100 for $13 each. During the month it sold 120 units. How much ending inventory should be reported on the balance sheet, COGS on the January income statement, and cost of goods available for sale during the month? How is ending inventory being calculated?
Martinez Shoe Sales has a January 31 fiscal year-end. At the start of the year, Martinez had 250 pairs of shoes in its Inventory at a cost of $30 per pair. Assume that the oldest inventory is sold first. Martinez uses a perpetual inventory system and estimates returns of 5% on all sales. During the month of February 2022, the following transactions took place: Feb. 4 Purchased 1,000 pairs for $20 each from Marigold Corp. on account, terms n/30. 11 Returned 100 pairs to Marigold for $2,000 credit because the shoes were the wrong size. 13 Sold 210 pairs for $90 each to Shoes for Kids, terms n/30. 18 Granted credit of $1,080 to Shoes for Kids for the return of 12 pairs that were the wrong colour. The shoes were restored to inventory. 26 Paid Marigold the amount owing. 28 Received payment in full from the Shoes for Kids. Record the February transactions. (Credit account titles are automatically indented when the amount is entered. Do not indent…
Synergy Company began 2020 with 23,500 units of Product X in its inventory that cost $8.40 per unit, and it made successive purchases of the product as follows: Mar. 7 30,500 units @ $ 9.90 each May 25 35,500 units @ $ 11.90 each Aug. 1 26,000 units @ $ 12.90 each Nov. 10 35,500 units @ $ 14.40 each The company uses a periodic inventory system. On December 31, 2020, a physical count disclosed that 19,500 units of Product X remained in inventory.Required:1. Calculate the number and total cost of the units available for sale during 2020. 2. Prepare calculations showing the amounts that should be assigned to 2020 ending inventory and to the cost of goods sold, assuming: (Image attached)a. FIFO b. Weighted average cost basis. (Round the "Average cost per unit" answer to 2 decimal places.)
A company has beginning inventory of 300 units at $ 16.75 each; They purchased 400 units at $ 6.51 each on June 2; On June 15, they also purchased 200 units at $ 12.62 each. A physical count of merchandise inventory at the end of the month revealed that 500 units were sold. What is the cost of goods sold using the FIFO inventory method? Round your answer to the nearest dollar.