Intermediate

Inventory Turnover & Obsolescence Analysis

Identifies slow-moving stock and calculates the necessary valuation reserve.

Analyze the inventory aging report for {company_name}. Total Inventory: {total_inv}. Breakdown: 0-90 days ({cat_1}), 91-180 days ({cat_2}), and 180+ days ({cat_3}). Calculate the Inventory Turnover Ratio and recommend an 'Inventory Obsolescence Reserve' (E&O) entry based on a {reserve_percent}% write-down for the oldest category.

Related Prompts

Management Accounting & FP&A
Intermediate

Inventory Valuation: LIFO vs FIFO Impact

Analyzes the effect of inventory cost flow assumptions on COGS and taxes.

GPT-4oGemini 1.5 Pro
0
0
170
Management Accounting & FP&A
Advanced

Allocating Shared Service Costs (Corporate Overhead)

Determines how to charge back HR, IT, and Finance costs to operating business units.

Claude 3.5 Sonnet
0
0
167
Management Accounting & FP&A
Beginner

KPI tree: link strategy to drivers and metrics

Creates a KPI tree that connects strategic objectives to operational drivers and metrics with definitions. Useful for leadership alignment and dashboard design.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
153