Fit Regression Model for Predict Cash-to-cash Cycle Time

Use Fit Regression Model to use multiple predictors to predict cash-to-cash cycle time.

This example applies to the Supply Chain Module. For more information, go to www.minitab.com/supply-chain-module.

Example

Cash-to-cash cycle time is the length of time between the purchase of raw materials and payment for a finished product.

In this worksheet, Number of Days is the response. Invoice Accuracy is a continuous predictor, and Product is a categorical predictor. The predictors may explain differences in cash-to-cash cycle time.

C1	C2	C3-T
`Number of Days`	`Invoice Accuracy`	`Product`
43	0.84	Jigsaw
46	0.89	Drill
34	0.93	Jigsaw
41	0.89	Drill

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Cycle Time, select Cash-to-cash cycle time.
Select Predict cash-to-cash cycle time, then click OK.
Select Fit Regression Model, then click OK.
In Responses, enter the column that contains the cycle time data. The response is also called the Y variable.
In Continuous predictors, enter the columns of numeric data that may explain or predict changes in cash-to-cash cycle time. The predictors are also called X variables.
In Categorical predictors, enter the categorical classifications or group assignments that may explain or predict changes in cash-to-cash cycle time. The predictors are also called X variables.
Click OK.

Tip

For more information about this analysis, click Help in the main dialog box.