automotive dealer excel report
TRANSCRIPT
Automotive Dealer Excel Operational RiportExcel Operational Riport
10 minutesof cost management
Premessa
• Spesso le aziende presentano processi di produzione del reddito complessi ed articolati;
• La maggior parte degli automotive dealer presentano 4 distinte are di business che occorre monitorare separatamente:business che occorre monitorare separatamente:
Auto Nuove
A t U tAuto Usate
Ricambi
Officina
2Dr Michele Benvenuti - 10 minutes of costs management -
ObiettivoTroppi numeri non aiutano la comprensione, la mia proposta è legata a reportistiche strutturate ma semplici da comprendere…
… imparate a sviluppate in casa i report con Exceldalla raccolta dati alla presntazione…dalla raccolta dati alla presntazione,
sarete autonomi e flessibili con costi ridotti!
Origine Dati
Contabilità PresentazioneAnalisiRaccolta Dati
Planner di attività
Consumi di magazzino
Gestionali case automobilistiche
3Dr Michele Benvenuti - 10 minutes of costs management -
Un esempio passo per passo• Per ogni area di business identificate alcuni indicatori;
• definite degli obiettivi mensili o settimanali;• riportate i risultati del periodo in corso;p p ;
• riportate i risultati dall’inizio dell’anno al periodo in corso compreso;• Utilizzate una grafica intuitiva come sparkline o bullet graph
4Dr Michele Benvenuti - 10 minutes of costs management -
Have a coffe break with me…
About me: My name is Michele Benvenuti. I have 15 years experience on cost management . I gained my experience collaborating first at a Faculty of g g y p g yEconomics, where I graduated. During my career I've been working for some important food industries. Today I am part of the staff of a consultant company.
What I’m offering: … I help you to manage your reportso you can manage your business…
Many cost management consultants or companies try to sell software, not me.
How to: test me let's do it free of charge for my work
Probably you already have the technology you need! The first step is to get people involved and to optimize your internal processes.
How to: test me, let s do it free of charge for my work…1. Contact me and tell me about your company2. I'll send you a documentation to guarantee the respect of the confidentiality of
information and that this first trial is free of any charge.information and that this first trial is free of any charge.3. Send me the latest trial balance you have available and some operational
data4. discuss with me on what are the important information you need to manage in p y g
the best way your business5. See the result
5Dr Michele Benvenuti - 10 minutes of costs management -
Contact me…
10 minutesof cost management Michele Benvenutiof cost management Michele Benvenuti
Consultant in Cost Management,Business Intelligence
and Enterprise Information Management
+39 335 [email protected]
skype: michelebenvenuti
Be update! follow my blogBe update! follow my blog…
10minofcostmanagement.blogspot.itg g p