Retail Inventory Estimation Methods and Cost Flows

Overview and Comparison of Inventory Estimation Methods

• Gross Profit Method of Estimating Inventory:

  • Estimates cost of goods sold (COGS) to arrive at the estimated ending inventory balance.
  • Basic formula relationship:
  • $\text{Estimated COGS} = \text{Sales} \times (1 - \text{Gross Profit Percentage})$
  • $\text{Estimated Ending Inventory} = \text{Cost of Goods Available for Sale} - \text{Estimated COGS}$
  • Inherent weaknesses and limitations:
  • Gross profit percentages often fluctuate significantly from year to year.
  • Variations across product mixes with disparate gross profit margins require detailed adjustments, segmentations, and operational massaging.
  • Catastrophic event application:
  • Applied when physical inventory is entirely destroyed (e.g., in a severe warehouse fire) but supported by surviving accounting records.
  • Numerical scenario: If sales are known and the estimated gross profit margin is $40\%$, estimated cost of goods sold equals $60\%$ of sales ($1 - 0.40 = 0.60$), generating an estimated COGS of $800{,}000\,$, which directly identifies the cost of destroyed inventory.

• Retail Inventory Method Overview:

  • Tracks inventory simultaneously at cost and at retail selling price.
  • Historical evolution: While older intermediate accounting curricula in the 1980s typically focused on a single approach, modern accounting encompasses four primary variations:
  • Conventional Retail (approximating lower of average cost and net realizable value / FIFO LCM).
  • Average Cost Retail.
  • LIFO Retail.
  • Dollar-Value LIFO Retail.
  • Best-suited environments:
  • High-volume retail enterprises that market large quantities of diverse merchandise with relatively low unit prices.
  • Businesses maintaining continuous estimation across reporting periods via the established cost-to-retail relationship.
  • Procedural control and validation:
  • Periodic validation checks must be conducted throughout the operating year.
  • At least one complete physical inventory count must be performed annually, even when utilizing a continuous perpetual inventory system.
  • Fundamental mechanics of the retail estimation schedule:
  • Goods available for sale are accumulated at both cost and retail:
    • $\text{Beginning Inventory} + \text{Purchases} = \text{Goods Available for Sale (GAS)}$
  • Cost-to-retail ratio is computed:
    • $\text{Cost-to-Retail Percentage} = \frac{\text{Goods Available for Sale at Cost}}{\text{Goods Available for Sale at Retail}}$
  • Ending inventory at retail is determined by subtracting period sales from goods available for sale at retail:
    • $\text{Ending Inventory at Retail} = \text{Goods Available for Sale at Retail} - \text{Sales}$
  • Ending inventory at cost is calculated by applying the percentage:
    • $\text{Ending Inventory at Cost} = \text{Ending Inventory at Retail} \times \text{Cost-to-Retail Percentage}$
  • Estimated cost of goods sold is derived by subtracting ending inventory at cost from goods available for sale at cost:
    • $\text{Estimated Cost of Goods Sold} = \text{Goods Available for Sale at Cost} - \text{Ending Inventory at Cost}$
  • Advantages over simpler estimation models:
  • Yields significantly more accurate valuations and incorporates diverse cost flow assumptions (FIFO, LIFO, and weighted average).
  • Serves as an analytical tool to quantify inventory losses due to shrinkage, theft, spoilage, or casualty.
  • Acts as a control test to evaluate the reasonableness of physical inventory counts.

Core Terminology: Markups, Markdowns, and Related Adjustments

• Initial Markup:

  • The original amount by which the selling price exceeds the purchase cost of an item.
  • Establishes the original retail sales price.

• Additional Markup:

  • A subsequent increase in the retail selling price above the original selling price.
  • Driven by sudden demand increases, market changes, or economic pressure:
  • Examples: Surging gasoline prices; seasonal holiday spikes in wrapping paper, food gifts, and holiday decorations; or high-demand consumer electronics.
  • Toy of the year scenario: A toy with a base retail price of $30\,$ may experience additional markups pushing the retail price to $75\,$.
  • Video game console release: Highly sought items (e.g., Nintendo Switch preorders or successors) sold by secondary retailers at double the base retail price.

• Markup Cancellation:

  • A reduction in an additional markup that does not lower the selling price below the original retail selling price.

• Net Markups:

  • Calculated as:
  • $\text{Net Markups} = \text{Additional Markups} - \text{Markup Cancellations}$

• Markdown:

  • A reduction below the original retail selling price, commonly utilized for clearance sales, promotional markdowns, or discontinued stock.
  • Example: Department store racks (such as at Kohl's) discounting merchandise at $50\%$ off retail one week, returning to regular price the next week, and dropping by $20\%$ in a subsequent week.

• Markdown Cancellation:

  • An increase in the selling price following a markdown that does not cause the selling price to exceed the original retail selling price.

• Net Markdowns:

  • Calculated as:
  • $\text{Net Markdowns} = \text{Markdowns} - \text{Markdown Cancellations}$

• Column Allocation Rules:

  • Markups and markdowns affect exclusively the retail column because they represent pricing adjustments at the consumer level and do not alter the historical acquisition cost paid to suppliers.

Retail Inventory Cost Flow Methods

• Average Cost Retail Method:

  • Incorporates both net markups and net markdowns in calculating the cost-to-retail percentage.
  • Treats all goods available for sale as a homogeneous pool.
  • Ratio determination formula:
  • $\text{Cost-to-Retail Ratio} = \frac{\text{Beginning Inventory at Cost} + \text{Purchases at Cost}}{\text{Beginning Inventory at Retail} + \text{Purchases at Retail} + \text{Net Markups} - \text{Net Markdowns}}$
  • Numerical demonstration:
  • Goods available for sale at cost divided by goods available for sale at retail yields a cost-to-retail percentage of $64\%$.
  • Subtracting net sales yields an ending inventory at retail of $198\,$ (or $198{,}000\,$ depending on unit denomination).
  • Ending inventory at cost equals $198 \times 0.64 = 126.72\,$.

• Conventional Retail Method (Lower of Cost or Market / FIFO Approximation):

  • Designed to approximate the lower of average cost and net realizable value.
  • Treatment of markdowns: Net markdowns are excluded from the denominator when calculating the cost-to-retail percentage.
  • Ratio determination formula:
  • $\text{Conventional Cost-to-Retail Ratio} = \frac{\text{Beginning Inventory at Cost} + \text{Purchases at Cost}}{\text{Beginning Inventory at Retail} + \text{Purchases at Retail} + \text{Net Markups}}$
  • Mechanical effect:
  • Excluding net markdowns keeps the denominator higher, resulting in an artificially lower cost-to-retail percentage.
  • When this lower percentage is applied to ending inventory at retail, it produces a lower, more conservative ending inventory at cost, reflecting write-downs consistent with lower of cost or market principles.
  • Subsequent deduction of markdowns:
  • Net markdowns are deducted from retail goods available for sale along with net sales to determine the ending inventory at retail.
  • Comparative numerical results:
  • In the standard illustration, conventional ending inventory at retail remains $198\,$, while ending inventory at cost drops to approximately $125{,}136\,$ (or expressed as $1.25\,$ vs $1.36\,$ in comparative ratios), decreasing inventory asset valuation and raising estimated COGS.

• LIFO Retail Method (Stable Price Levels):

  • Operating premise:
  • Does not follow the physical movement of inventory units.
  • Ending inventory consists of the oldest costs (beginning inventory layer) plus incremental additions from current purchases.
  • Preservation of layers:
  • Businesses maintain sufficient acquisition schedules so that beginning inventory layers do not undergo involuntary liquidation or erosion.
  • Multi-layer calculation mechanics:
  • Requires separate cost-to-retail percentages for distinct layers.
  • Beginning inventory layer ratio:
    • $\text{Beginning Inventory Ratio} = \frac{\text{Beginning Inventory at Cost}}{\text{Beginning Inventory at Retail}} = \frac{347{,}200}{560{,}000} = 62\%$
  • Current period purchases ratio (excluding beginning inventory):
    • Markups and markdowns are included in the current year calculation above the line.
    • $\text{Current Year Ratio} = \frac{\text{Purchases at Cost}}{\text{Purchases at Retail} + \text{Net Markups} - \text{Net Markdowns}} = 64.68\%$
    • A current period ratio higher than the base period ratio ($64.68\%$ versus $62\%$) confirms the occurrence of price increases during the operating period.
  • Deriving total ending inventory:
    • Ending inventory at retail is computed by subtracting net sales from total goods available for sale at retail (yielding $198\,$).
    • This retail total is segregated into layers:
    • Layer 1: Base/Beginning inventory at retail, valued at the base cost ratio ($62\%$).
    • Layer 2: Incremental retail increase for the current year, valued at the current purchase ratio ($64.68\%$).
    • The costed layers are summed to establish the ending inventory at cost.

Special Accounting Adjustments in the Retail Method

• Freight-In (Transportation Costs):

  • Added exclusively to the purchases at cost.
  • Excluded from the retail column because transportation costs represent a cost of acquiring goods, not an increase in the established consumer selling price.

• Purchase Returns:

  • Deducted in both the cost and retail columns to eliminate returned inventory from available stock.

• Purchase Discounts (Gross Method vs. Net Method):

  • Gross Method:
  • Invoices are recorded at full gross face value.
  • Cash discounts are recorded only when taken within the discount term.
  • Common in governmental organizations.
  • Net Method:
  • Invoices are recorded net of cash discounts from inception.
  • Failure to take a discount is treated as an explicit finance expense (discounts lost).
  • Applied by companies emphasizing strict material cost controls (such as construction enterprises where preserving minimal project costs is required to ensure customer margins).

• Sales Returns and Allowances:

  • Subtracted from gross sales to arrive at net sales:
  • $\text{Net Sales} = \text{Gross Sales} - \text{Sales Returns}$
  • Sales discounts are typically excluded from retail reductions.

• Inventory Shortages, Spoilage, and Breakage:

  • Normal shortages (theft, physical breakage, natural spoilage) are subtracted from the retail column in calculating ending inventory.
  • Deducted alongside net sales from goods available for sale at retail to prevent phantom inventory from remaining in the ending retail balance.

Dollar-Value LIFO Retail Method

• Core Methodology:

  • Unifies the retail inventory method with dollar-value LIFO techniques to eliminate the distortive effects of general price level inflation from ending inventory valuations.
  • Distinguishes real physical inventory growth from mere price changes.

• Step-by-Step Procedure:

  1. Calculate ending inventory at current-year retail prices:
  • $\text{Ending Inventory at Current Retail} = \text{Goods Available for Sale at Retail} - \text{Net Sales}$
  1. Deflate ending inventory at current retail to base-year retail prices using the current price index:
  • $\text{Ending Inventory at Base Retail} = \frac{\text{Ending Inventory at Current Retail}}{\text{Price Index}}$
  1. Compare ending inventory at base retail with the beginning inventory at base retail:
  • If ending inventory exceeds beginning inventory at base retail, a new layer is created:
    • $\text{New Layer at Base Retail} = \text{Ending Inventory at Base Retail} - \text{Beginning Inventory at Base Retail}$
  • If ending inventory at base retail is lower, previous layers are systematically liquidated in reverse chronological order (LIFO order).
  1. Re-inflate the new layer to current-year retail price levels:
  • $\text{New Layer at Current Retail} = \text{New Layer at Base Retail} \times \text{Price Index}$
  1. Convert the inflated retail layer to cost using the current year's purchase cost-to-retail percentage:
  • $\text{New Layer at Cost} = \text{New Layer at Current Retail} \times \text{Current Year Cost-to-Retail Percentage}$
  1. Compute total ending inventory at dollar-value LIFO cost by adding the new layer at cost to the existing base layer at cost:
  • $\text{Ending Inventory at Cost} = \text{Base Layer at Cost} + \text{New Layer at Cost}$

• Numerical Illustration of Dollar-Value LIFO Layers:

  • Base inventory at cost: $400\,$.
  • Assumed price index in 2027: $110\%$ (represented as $1.10$).
  • Ending inventory at current retail deflated by the index yields base-year retail.
  • Comparative difference reveals a new layer at base retail of $20\,$.
  • Inflating the layer: $20 \times 1.10 = 22\,$ at current retail.
  • Multiplying by the current year's cost-to-retail percentage yields the new layer at dollar-value LIFO cost, added to the base layer of $400\,$.
  • Multi-year layer tracking:
  • Track layers across chronological years (Base Layer, 2027, 2028, and 2029 layers).
  • Handle layer erosion when inventory levels drop: When retail at base prices decreases (e.g., from an increment of $40\,$ down to $30\,$), the most recent layer is partially liquidated, leaving a residual layer.

Practical Accounting Applications, Historical Context, and Exam Preparation

• Historical Retail Accounting Practices (The Great Atlantic & Pacific Tea Company / A&P):

  • Operations during the 1970s relied heavily on paper documentation, physical price labeling markers, and mechanical registers.
  • Mechanical registers lacked automatic change calculators until computerized electronic registers emerged around 1977 and 1978.
  • Early computerized registers acted as adding machines connected via dedicated networks to in-store mainframe computers, enabling centralized store-to-office communication.
  • Inventory verification procedures:
  • Complete physical inventory counts were executed at retail prices.
  • Sales transacted from the store opening until the conclusion of the count had to be added to the sales totals.
  • Beginning inventory figures were taken from the prior count at retail.
  • Vendor purchase invoices explicitly printed both the acquisition cost and the designated retail price because store personnel physically marked every item.
  • Counting teams tagged every shelf, rack, and aisle at multiple locations to verify count completeness and prevent audit discrepancies.
  • Retail organizational pressures:
  • Store managers were heavily evaluated on inventory losses, shrinkage, and counting variances.
  • Historical case: A&P management utilized purported inventory discrepancies as grounds to dismiss a long-tenured store manager without severance benefits prior to closing a marginally profitable store location.

• Technological Tools in Accounting Education and Practice:

  • Spreadsheet proficiency (e.g., Microsoft Excel):
  • Intermediate accounting problems in computerized platforms (such as Connect) provide standardized entry templates, but spreadsheet mastery is critical for manual analysis.
  • Standardized workbook templates allow recurring schedules to be reused efficiently for complex retail inventory models.
  • Application to institutional budgeting:
  • Repeating financial templates streamline corporate and organizational governance.
  • Example: Institutional budgeting processes (such as church finance operations) present standardized template formats that flow sequentially through board review, the budget committee, and voting assemblies.

• Study Strategies for Intermediate Accounting Examinations:

  • The retail method presents cognitive challenges because it applies across four distinct scenarios: Average Cost, Conventional, LIFO, and Dollar-Value LIFO.
  • Managing high information volume: Preparing concise, handwritten format schedules and formula summaries strengthens cognitive recall for open-note and professional evaluations.
  • Rigorous test preparation requirements:
  • Comprehensive review of chapter mechanics, formula variations, and practical homework problems is necessary to build fluid mastery.
  • Advanced accounting and auditing subjects (such as consolidated financial statements or auditing concepts) require dedicated preparation across multi-day blocks to achieve rapid execution under exam time constraints.

Questions & Discussion

• Prompt: What would be an example of a situation where a retail store would implement an additional markup on an item?

  • Response: Retailers apply additional markups when product demand rises substantially. Specific occurrences include:
  • Fuel and gasoline retailers raising pump prices following market fluctuations.
  • Seasonal spikes during holiday periods where consumer demand intensifies for gift wrap, decorative ornaments, and seasonal confectionery.
  • Toy and entertainment crazes where consumer demand vastly outstrips supply (such as the toy of the year having its base retail price raised from $30\,$ to $75\,$, or the launch of the Nintendo Switch console where consumers paid double retail to acquire available units).

• Prompt: Should freight-in be included in the cost column of purchases when computing the cost-to-retail percentage?

  • Response: Yes. Any direct transportation expense incurred to bring merchandise to the retail establishment forms an integral component of inventory acquisition cost and must be added to purchases at cost. It is excluded from the retail column because shipping costs do not alter the established retail price charged to consumers.

• Prompt: Why do markups and markdowns affect exclusively the retail column rather than both the cost and retail columns?

  • Response: Markups and markdowns represent changes in consumer sales prices occurring after goods are placed in the store. They do not retroactively alter the acquisition cost paid to vendors. Therefore, they are recorded solely in the retail column to adjust the denominator of the cost-to-retail ratio.

• Prompt: In an in-class practice problem using the average cost method, what was the estimated ending inventory at retail given the provided schedule parameters?

  • Response: Performing the calculations by running two columns (cost and retail), determining the goods available for sale ratio, and subtracting sales gives an ending inventory at retail of $954\,$ (corresponding to multiple choice option A).

• Prompt: What is the critical operational difference between the conventional retail method and the average cost retail method?

  • Response: The conventional method deliberately excludes net markdowns when computing the cost-to-retail percentage. This leaves a larger denominator, resulting in a lower cost-to-retail percentage that values ending inventory at a lower amount to approximate the lower of cost or market. The average cost method includes both net markups and net markdowns directly in the goods available for sale calculation when determining the percentage.

• Prompt: What items should a student consider writing down when preparing notes for an intermediate accounting exam?

  • Response: Detailed format templates and specific formula structures for each of the primary inventory variations are critical: Average Cost, Conventional, LIFO, and Dollar-Value LIFO. Because of the volume of technical rules, preparing organized structural formats on paper facilitates quick recall during evaluations.