MiniTab specialist required//Measure phase (DMAIC approach for Lean Six Sigma project - Order to Cash Process)

I am running a university lean six sigma project applying a DMAIC approach.

Business Case: Freight & Logistics industry - Order to Cash process. Cash Application team is responsible for posting accurately and timely incoming payments. If an incoming payment does not match an open invoice or cannot be identified will be left unallocated (unapplied) on customer's account.

Problem Statement: for the financial year 2018 the monthly average unapplied cash was $2 million against a target of $1.2 million.

DMAIC approach - Measure phase. I have uploaded an excel file containing the unallocated cash for financial year 2018 aged by 0-30 days, 30-60 days, 90-120 days etc - Total unallocated Cash.

My request are to:

1- Run a pareto chart on my data and what's the output (what the data are telling me - I should have clusters on my data).

2- Figure out what cluster I have and what stats test should I run to get a good description of the data. For example, I know that there are few customers that have higher unallocated cash (unapplied) than the average. So maybe I should run 2 tests, 1 for average customers (unallocated monthly cash 2 million) and one for non average (unallocated monthly cash over 2.5 million or less than 1.5 million).

3- Run a boxplot graph and what it tells me.

4- Testing the normality distribution/assumption of my data.

5- Run MiniTab SixPack Process Capability Analysis and what it tells me.

Compétences : Comptabilité, Mathématiques, Minitab, SAP, Analyses statistiques

en voir plus : six sigma tools, which tool is most commonly used in dmaic measure phase, what is the importance of the define phase in terms of its placement in the dmaic method, six sigma life cycle, dmaic template, stages of six sigma implementation, dmaic process map, six sigma analyze phase, affordable online courses pmp itil lean six sigma, lean six sigma training spanish, lean six sigma works spanish, lean six sigma translation spanish, lean six sigma spanish, lean six sigma terminology spanish, lean six sigma training, lean six sigma proposal, lean six sigma project proposal, logo lean six sigma, lean six sigma, lean six sigma\

Concernant l'employeur :
( 1 commentaire ) Birmingham, Poland

Nº du projet : #18967653

Décerné à:


Hello I am Certified Black Belt Lean Six Sigma from ASQ (American Society of Quality) I am expert Lean Six Sigma Coach and consultant. I am Minitab trainer till Minitab version 18. I have completed similar projects (r Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(10 Commentaires)

3 freelance font une offre moyenne de $116 pour ce travail


hello. am engineer in statistics, i worked before problems in quality like yours, i can help you Asap......

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(70 Commentaires)

Good at Minitab with great experience working on the data and also interpreting the results. I can show you some of the work that I have successfully done in the past. Look forward to hearing from you

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(6 Commentaires)