Đã hoàn thành

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.

Kĩ năng: Kế toán, Toán học, Minitab, SAP, Phân tích thống kê

Xem nhiều hơn: 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\

Về Bên Thuê:
( 0 nhận xét ) Warsaw, Poland

ID dự án: #18967653

Được trao cho:

DrAmirAdly

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 Thêm

$93 USD trong 2 ngày
(9 Đánh Giá)
3.2

4 freelancer đang chào giá trung bình $124 cho công việc này

lamyae88sid

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

$155 USD trong 3 ngày
(54 Nhận xét)
5.6
orugantn

Hi, I have experience in six sigma and ran several analysis using Minitab. I reviewed the data and I can complete the requirements within 2 days. Can you please contact to discuss the details. Please feel free Thêm

$120 USD trong 3 ngày
(19 Nhận xét)
5.0
jameskaikai

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

$100 USD trong 0 ngày
(6 Nhận xét)
3.0