
WIP Inventory Valuation and Cost Tracking
📄 Prompt Template
Generate a report that calculates the cost of work-in-progress (WIP) inventory by tracking the value of raw materials, labor, and overhead applied at each production stage. The calculation should break down costs by product type, production stage, and location, providing an up-to-date valuation of the WIP inventory. Use [RawMaterialCost], [LaborCost], [OverheadCost], [ProductType], [Stage], and [Location] as placeholders. The report should include a detailed cost per unit at each stage of production and cumulative costs. Ensure the output includes a summary of total WIP costs at the end of the report.