How to Optimize Accounts Receivable Using Discrete Response DOE?

  • Context: Graduate 
  • Thread starter Thread starter diorio
  • Start date Start date
  • Tags Tags
    Discrete Doe Response
Click For Summary
SUMMARY

This discussion focuses on optimizing accounts receivable performance using a discrete response Design of Experiments (DOE). The user proposes a 2-level factorial experiment involving three factors: letters, calls, and SMS, each with binary outcomes (Yes/No). The challenge lies in analyzing the discrete response (Paid/Not Paid) and determining the appropriate number of trials needed to achieve statistically significant results. Recommendations include conducting multiple trials per treatment and utilizing ANOVA to assess factor significance and interactions.

PREREQUISITES
  • Understanding of Design of Experiments (DOE) principles
  • Familiarity with discrete response variables in statistical analysis
  • Knowledge of ANOVA for analyzing factor significance
  • Experience with factorial experiments and their applications
NEXT STEPS
  • Research discrete response Design of Experiments methodologies
  • Learn about ANOVA techniques for factorial experiments
  • Explore statistical software options for conducting DOE, such as Minitab or R
  • Investigate case studies on optimizing accounts receivable using DOE
USEFUL FOR

Accounts receivable managers, data analysts, and professionals involved in process optimization and statistical analysis will benefit from this discussion.

diorio
Messages
1
Reaction score
0
Hi Everyone,

I am looking for some assistance on a problem that I have been working on for the last few weeks. I would like to optimise the performance of an accounts receivable department. In this dept there are several tools available to obtain a commitment to pay such as letters, phone calls, sms and others. I would like to run an experiment to determine the optimal use of these tools and I suspect that there may be some interactions between these factors.

I have researching how I can run a simple design of experiments to determine the optimal treatment. For example I could run a simple 2 level 2 factorial experiment:

Factors:
Letter Call Account
Y Y Paid
Y N ?
N Y ?
N N ?

The issue that I have is that not only are my factors discrete (Y/N), my response is discrete as well (Paid/Not Paid). I am having difficulty finding an example of how to conduct a DOE with a discrete (binomial) response.

After some researching I am starting to believe I need to run multiple trials for each treatment. For example running multiple instances of: Letter Yes / Call Yes treatment so that I can obtain a resulting proportion (example: 4 of 7 customers treated in this manner paid - 57%), I have seen some places that there are suggestions to run np>5 number of treatments. If in this instance if I expect 70% proportion of people to pay, then I believe I may need to run n=5/.7=(7 to 8) trials of each treatment.

Can anyone advise if I am on the right track?

I have searched numerous six sigma and DOE references and haven't been able to reach a definitive conclusion. Is there anyone out there that could advise me or provide a similar example or book that may assist me with a discrete response DOE?
 
Physics news on Phys.org
You have 3 factors , i.e. letter, sms, and call, to control the incidences of get paid. Each factor has 2 level, yes/no. So you have 2x2x2=8 different treatments.

Say you decide to trial 80 customers, there are random 10 customers for each treatment. Resulting a data set of 80 rows, 4 columns. 3 columns indicate the factor used, and the last column indicates the payment.

Use ANOVA you can study the significance of the factors and their interactions.
 

Similar threads

  • · Replies 1 ·
Replies
1
Views
1K
  • · Replies 16 ·
Replies
16
Views
2K
  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 19 ·
Replies
19
Views
3K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 7 ·
Replies
7
Views
3K
  • · Replies 0 ·
Replies
0
Views
1K
  • · Replies 28 ·
Replies
28
Views
3K
Replies
11
Views
4K