Advanced

Pharma inventory and rebate/chargeback accrual framework

Designs a framework to accrue for rebates, chargebacks, returns, and inventory reserves common in pharma. Useful for controllers and audit support.

Create an accrual framework for rebates/chargebacks/returns for {pharma_company}.

Inputs:
- Sales channels and terms: {sales_channels_terms}
- Rebate programs and rates: {rebate_programs}
- Chargeback/contract pricing terms: {chargeback_terms}
- Returns history and policy: {returns_history}
- Inventory on hand and expiry risk: {inventory_data}

Output:
1) Accrual model outline by program (inputs, calculations, timing).
2) Journal entry templates and rollforward schedules.
3) Controls and evidence requirements (data sources, approvals).
4) Key risks and sensitivities (utilization rates, lag, channel mix).

Be transparent about uncertainties and data needs.

Related Prompts

Industry-Specific

Intermediate

Retail gross margin bridge: markdowns, mix, shrink, freight

Builds a gross margin bridge explaining changes driven by markdowns, mix, shrink, and freight. Useful for merchandising and finance alignment.

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

167

Industry-Specific

Advanced

Inventory reserve framework: obsolescence, shrink, and markdowns

Designs an inventory reserve approach for obsolescence and markdowns with calculation templates and controls. Useful for retail and manufacturing close and audit support.

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

218

Industry-Specific

Intermediate

Revenue cycle analytics: denials, days in AR, and cash acceleration

Analyzes revenue cycle KPIs and identifies actionable levers to reduce denials and improve collections. Useful for hospital/practice management and finance teams.

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

160