Work In Progress (Historical)
Returns the work in progress (WIP) inventory balance from historical balance sheets, representing partially completed products in the manufacturing process.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol |
| Year | Yes | Fiscal year or period code |
| Quarter | No | Calendar quarter 1-4 |
| TTM | No | Set to "TTM" for trailing twelve months |
Notes
- Most relevant for manufacturing companies
- High WIP may indicate production bottlenecks
- Part of total inventory breakdown
Examples
=hf_Work_in_progress("BA", 2023, 4)=hf_Work_in_progress("CAT", "ly", 2)=hf_Work_in_progress(A1, B1, C1)When to Use
- Manufacturing efficiency analysis
- Production cycle time analysis
- Inventory composition breakdown
- Operational efficiency metrics
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need total inventory | hf_Total_inventory() |
| Need finished goods | hf_Finished_goods() |
| Need raw materials | hf_Raw_materials() |
Common Issues & FAQ
Q: Why is WIP very high for some companies? A: Companies with long production cycles (aerospace, shipbuilding) typically have high WIP.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?