31.10.14 cred analysis report

7
Credit Analysis Report OCTOBER 2014 Root Cause 1: Commercial Decision RTS; shown below. 4 - C ustomer Exp ectation R TS 6 - Commerc ial Decisio n RT S a - Sales E rror RTS D - Damage - Condition V O h - D espatch Err or VO l - Picking Error VO N - Over Su pply RTS P - Q uality Mach ining VO R - Q uality - Gr ade VO T - Custome r Error VO U - C ustomer Err or RTS W - Haulier Error RTS x - 3 rd Party Pr ocess RT S Z - Sales E rror VO Reason Code INPUT Total Main Credit Issuer [RTS Commercial Decision]: Sales Person A. Row Labels 6 - Commercial Decision RTS No. Of Credits Sales Person A # Sales Person B # Sales Person C # Sales Person D # Sales Person E # Sales Person F # Sales Person G # Grand Total # Vicky Fellows; Oct 2014 1

Upload: victoria-fellows

Post on 14-Apr-2017

19 views

Category:

Documents


1 download

TRANSCRIPT

Page 1: 31.10.14 cred analysis report

Credit Analysis Report OCTOBER 2014

Root Cause 1: Commercial Decision RTS; shown below.

4 - Custo

mer Ex

pectati

on RTS

6 - Commerc

ial Deci

sion RTS

a - Sa

les Er

ror R

TS

D - Dam

age -

Condition VO

h - Desp

atch Er

ror VO

l - Pick

ing Erro

r VO

N - Ove

r Supply R

TS

P - Qualit

y Mach

ining VO

R - Qualit

y - Grad

e VO

T - Custo

mer Err

or VO

U - Custo

mer Err

or RTS

W - Hau

lier Er

ror RTS

x - 3rd Part

y Proces

s RTS

Z - Sa

les Er

ror V

O

Reason Code INPUT

Total

Main Credit Issuer [RTS Commercial Decision]: Sales Person A.

Row Labels

6 - Commercial Decision RTS No. Of Credits

Sales Person A #

Sales Person B #

Sales Person C #

Sales Person D #

Sales Person E #

Sales Person F #

Sales Person G #

Grand Total #

Vicky Fellows; Oct 2014 1

Page 2: 31.10.14 cred analysis report

Credit Analysis Report OCTOBER 2014

Root Cause 2: Quality Grade RTS; shown below.

Customer Damaged Despatch Other Picking Quality Quantity Sales

REAL Root Causes

Total

Main Credit Issuer [Quality]: Sales Person Z.

Row LabelsQuality No. Of Credits

Sales Person Z #Sales Person Y #Sales Person X #Sales Person W #Sales Person V #Sales Person U #Sales Person P #Sales Person O #Sales Person N #Sales Person M #Sales Person L #Sales Person K #Sales Person J #

Grand Total #

Vicky Fellows; Oct 2014 1

Page 3: 31.10.14 cred analysis report

Credit Analysis Report OCTOBER 2014

Root Cause 3: Sales Errors.

Sales Errors Invoiced VS Rep

Total

Main Credit Issuer [Sales Errors]:

Row LabelsSales Errors No. Of ErrorsSALES PERSON 1 XSALES PERSON 2 XSALES PERSON 3 XSALES PERSON 4 XSALES PERSON 5 XSALES PERSON 6 XSALES PERSON 7 XSALES PERSON 8 XSALES PERSON 9 XSALES PERSON 10 XSALES PERSON 11 XSALES PERSON 12 XGrand Total X

Vicky Fellows; Oct 2014 1

Jackie: Credits IssuedSales Error No. Of ErrorsPrice Error XInput Error XLack of Communication XComputer Error XOther XGrand Total X

Page 4: 31.10.14 cred analysis report

Credit Analysis Report OCTOBER 2014

Main Reason for Returns from Customer:

COMMERCIAL DECISION RTSMain complaints No. of ComplaintIncorrect Size XQuality XFussy Customer/Rejection XIncorrectly Stored/Transported XStock Cleanse XCancellations XDamaged or Machined incorrectly X

Main Quality Complaints:

QUALITY RTSMain complaints No. of ComplaintPoor Quality XMachined Incorrectly XTransport Damages XSplitting XDirty. Old stock. Too many knots. XDelaminating/Too wet XIncorrect Size XBlack and Mouldy XShipping Issue, worm holes etc. XFussy Customer XBlue Stained XRipples/grains on face XManufacturer Fault X

Main Sales Errors:

SALES ERROR CREDITSSales Errors Reason No. Of ErrorsLack of Communication XPricing Error/Dispute XWrong Product Booked XInput Error XCustomer Error XBooked to Wrong Account/Branch XLate Delivery XInsufficient Credit Given X

Cancellation X

Conclusions – MINUTED FROM BUSINESS CONTROLS MANAGER

Vicky Fellows; Oct 2014 1

SALES ERROR CREDITS

Input Errors No. Of Errors

Incorrect Size X

Incorrect Date XDid not know how to delete X

Wrong Info given X

Incorrect Qty X

Despatch Error X

Grand Total X

Page 5: 31.10.14 cred analysis report

Credit Analysis Report OCTOBER 2014

1. Quality of timber is in question frequently; a lot are marked by holes, misshapen or exposed to wet weather.

2. A large number of products are being machined wrongly or damaged from them.

3. Transportation damages are adding to returns.

4. Sizing errors during input generating more returns.

5. Lack of communication between internal and external sales staff and between customers and sales, generating confusion and eventually sales errors.

6. Lack of training on the deletion of items that are causing some orders to be processed in error.

7. A large number of input errors are due to typing mistakes when rushing through.

8. Some changes to orders are being taken verbally without being recorded or written down; thus generating orders with incorrect information to the relevant picking teams.

Corrective Actions – MINUTED FROM BUSINESS CONTROLS MANAGER

1. Ensure Quality of timber is routinely inspected to ensure it is dry, unmarked and generally in good storage conditions.

Vicky Fellows; Oct 2014 1

Page 6: 31.10.14 cred analysis report

Credit Analysis Report OCTOBER 2014

2. Sawyers to take more care in not damaging product and products to be inspected before loading on vehicles and despatched.

3. Take extra care in vehicle loading and securing packs down to minimise movement during travel.

4. Increase the level of communication with staff and customers on pricing changes, pricing agreements made by external reps to decrease the number of input errors.

5. Double check any confusion regarding orders (with customers) or mill items needed machining (with mill staff) to decrease input error.

6. Lack of training on the deletion of items that are causing some orders to be processed in error.

7. Clarification is needed on orders in the future; confusion leads to increased errors in sizes and products being issued. And take general care when inputting to ensure accurate data is sent for processing.

8. Any verbal orders or changes must be written and recorded to ensure changes are made and orders not forgotten.

Vicky Fellows; Oct 2014 1