Cash-to-cash adds inventory days and receivable days, then subtracts payable days. Paying a supplier later reduces the cash tied up under this definition. Compare periods with the same calculation and consider payment terms; a lower figure alone does not establish a healthier supplier relationship.
You work on Pine Harbor Distribution's fictional planning file. Before calculating, check the time period, the unit and which business event each input records. Keep those definitions in the workbook so another analyst can reproduce the result. The first task gives you the steps. Later tasks use new quantities, a boundary case and a handoff to another planner. Your answer is recalculated on a second copy of the inputs, so enter a formula rather than a number copied from the example.
Calculate inventory days + receivable days - payable days. Keep a negative result if the inputs produce one.