Skip to main content
DD-WCP-003-Q044 Very Hard Time series

Manufacturing's cash tied up

A document is open at a date when its PostingDate is on or before that date and its SettledDate is empty or later than that date. Receivables = open "Customer invoice" and "Card takings" documents; payables = open "Supplier invoice" documents; stock = ClosingValue in FactStockMonthEnd at that month-end. DSO = receivables / Revenue of the three calendar months ending that month (FactMonthlyPL) x the days in those months; DIO = stock / CostOfSales of the same months x days; DPO = payables / SupplierInvoices of the same months x days; CCC = DSO + DIO - DPO. By how much did Mizan Manufacturing's working capital tied up (receivables + stock - payables) change from 31 December 2024 to 31 December 2025, in USD (negative for a fall)?
Expected
One amount in USD, 2 decimals · KPI card
Tables
FactWCDocument, FactStockMonthEnd · columns
  • FactWCDocument
  • FactStockMonthEnd
  • DocumentType
  • Amount
  • ClosingValue
  • SnapshotDate

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us