Close Cedar Trail's inventory without pricing the wrong goods

Assignment context

Cedar Trail Outfitters, Inc. is a fictional US retailer and light assembler with a December 31 year-end. Management states that its general-purpose financial statements follow US GAAP. You are the inventory accounting senior. The controller stopped the close when a 70-unit physical count was copied directly into a FIFO worksheet even though contracts, carrier records, and consignment reports were unresolved.

Use inventory units and US dollars. A fact marked stipulated for schedule work is an exercise input, not proof of the underlying accounting judgment. Use authorized current guidance and retain paragraph locators without reproducing protected Codification or Standard text.

Exhibit A — physical count and rights exceptions

The main warehouse count lists 70 TrailCam units. The count team included 15 demonstration units supplied by North Ridge Components under an agreement that says North Ridge retains the goods until Cedar Trail sells them to a customer. Cedar Trail shipped 12 of its own TrailCams to an independent retailer on consignment; the retailer reports that none sold by December 31. Eight more units are with a carrier.

For the 8 in transit, the purchase agreement, carrier acceptance, delivery requirement, insurance responsibility, redirection rights, and loss event are not assembled in one file. The invoice is dated December 29, the carrier scan December 30, receiving report January 3, and payable posting January 4.

Build a location ledger and rights ledger. Reconcile the main count to one owned population and hold the 8-unit conclusion open until the substantive transfer condition is supported. Align the final answer with Accounts Payable. Do not select December or January from the invoice or receipt date alone.

Exhibit B — sales cutoff and consignee activity

A customer order for 10 units was picked December 31, invoiced December 31, accepted by the carrier January 2, and delivered January 4. The executed terms and customer acceptance evidence are missing. Revenue was recorded December 31 and 10 units were removed from the perpetual record.

The consignee's January 5 report shows the 12 Cedar Trail units, no customer sale before year-end, one damaged box, and a proposed commission. Reconcile units, revenue, cost transfer, receivable, commission, damage evidence, and settlement. Delivery to the consignee is not itself a customer sale.

Exhibit C — cost-pool exceptions

The draft unit-cost pool includes:

• ordinary supplier invoice price and inbound freight;
• routine receiving and assembly labor supported by time records;
• emergency air freight caused by Cedar Trail's scheduling mistake;
• abnormal spoilage after a machine-control failure;
• fixed overhead allocated using actual low output rather than documented normal capacity;
• storage after finished goods were ready for sale; and
• sales commissions.

Classify each amount as qualifying inventory cost, current-period charge, or unresolved research. Retain the activity, normality, location-and-condition effect, allocation base, source, amount, preparer, and reviewer. Rebuild unit cost only from accepted amounts.

Exhibit D — stipulated unit stream and method schedules

After ownership and cost issues are separated, use this independent controlled stream for method calculation:

Recompute periodic and perpetual FIFO and LIFO, periodic weighted average, and perpetual moving average. Explain why FIFO agrees here, why average and LIFO differ, and why none of those methods proves physical movement. Add one serial-numbered specific-identification row and state what makes its trace supportable.

The schedule should reproduce $2,840 goods available, 170 units sold, 70 units ending, and the six method results in the checked worked example. Every row must satisfy cost of goods sold plus ending inventory equals $2,840.

Exhibit E — LIFO bridge and possible liquidation

Cedar Trail's LIFO population has a same-date periodic FIFO comparison. Under the stipulated stream, FIFO ending inventory is $980 and LIFO ending inventory is $700. Prepare the $280 bounded reserve and explain which reserve amount bridges the balance sheet and which reserve change bridges period cost.

A separate pool fell by 20 units and released a layer carried at $8 per unit while current unit cost was $14. Quantify the $120 cost difference for review—20 × ($14 − $8)—but do not label it an operating gain without price, volume, mix, replacement, tax, and disclosure evidence. Relative to assigning current $14 cost, the old layer lowers cost of goods sold and raises pretax income by $120; that comparison is not a separate cash gain.

Exhibit F — measurement populations

Two independent items are stipulated for schedule work:

1. An ordinary non-LIFO, non-retail-method item has $980 cost and $900 supported NRV.
2. A LIFO item has $1,000 cost, $940 NRV, $880 replacement cost, and $100 approximately normal profit.

Reperform the $80 LCNRV write-down and the LIFO item's $940 ceiling, $840 floor, $880 designated market, and $120 write-down. Then build an evidence record for condition, ordinary-course selling price, completion, transport, selling costs, replacement cost, normal profit, population, application level, date, sensitivity, and subsequent transactions. The supplied numbers do not prove that record.

Exhibit G — future purchase contract

Cedar Trail signed an order to buy 1,000 units next quarter for $12 each. Current spot price is $10.50. The file does not establish enforceability, cancellation, seller performance, indexed adjustments, expected use, hedging, related parties, or the current recognition and disclosure paragraph.

Keep the future contract separate from owned inventory. Prepare a provisional research memo with recognition, loss, disclosure, and no-entry branches. Do not record $1,500 merely by multiplying the spot-price difference.

Exhibit H — missing-evidence estimates

A fire destroyed one store's count evidence. For a bounded gross-profit estimate, use $20,000 beginning inventory, $80,000 net purchases, $120,000 net sales, and a stipulated 30 percent historical gross margin. Reproduce $16,000 estimated ending inventory and challenge the rate for mix, markdowns, returns, inflation, theft, damage, and purpose.

A different store's average-cost retail pool has $90,000 goods available at cost, $150,000 at retail, and $110,000 net sales. Reproduce the 60 percent ratio and $24,000 estimate. Identify missing markup, markdown, return, discount, transfer, shrinkage, and department-pool evidence. Do not silently convert the average-cost illustration into the conventional retail method.

Exhibit I — draft error and statement effects

The draft includes $5,000 of supplier-owned goods in ending inventory and also records the payable. Trace the inventory and transaction-specific current- period effects, next-period counterbalancing path, tax and comparative-statement questions, correcting entry, and root-cause control. Explain why a zero two- period pretax sum does not make either period correct.

Exhibit J — draft note and IFRS request

The draft note says:

Inventory is stated at the lower of cost or market using FIFO. Management's estimates are reasonable, and all purchase commitments are recorded.

Cedar Trail actually has FIFO, LIFO, and average-cost retail populations, the two stipulated write-downs, a LIFO reserve and possible liquidation, a fire- loss estimate, and an unresolved purchase commitment. Reconcile policy and amount language to the ledgers and workpapers. Build a current US-GAAP requirement-to-evidence map.

Management also asks for “the IFRS number.” Create a separate IAS 2 comparison column. State the FIFO/weighted-average/LIFO and lower-of-cost-and-NRV boundaries, but do not produce a conversion until the current Standard, application level, reversals, tax, transition, and opening-policy facts are researched.

Required close file

Assemble in lesson order:

Submit one indexed packet with source locators, full-precision schedules, entries, statement effects, evidence states, owners, reviewers, triggers, and issue-specific release stops. A zero workbook check is arithmetic evidence, not approval of the close.