a
andrewjcollis

Andrew C

@andrewjcollis
5,0(9)

Excel Dashboards, Budgets and Financial Models I Hospitality

Australie
Anglais
Certaines informations sont présentées en anglais.
À propos de moi
I own and run a restaurant in Sydney. Every dashboard, budget and cost model I sell here, I built for myself first — because I needed it on a Monday morning, not because it looked good in a portfolio. Now I build them for other operators and small businesses: Excel and Google Sheets dashboards, budgets and cash flow forecasts, cost and margin analysis, financial models, VBA automation, and Word templates that don't fall apart. Every file is unlocked, documented and yours to edit. No black boxes, no jargon. Tell me the decision you're trying to make and I'll tell you what you need.... Plus d’infos

Compétences

a
andrewjcollis
Andrew C
hors ligne • 
Temps de réponse moyen de 1 heure

Voir mes services

Formules & Macros
I will build excel vba macros and automation to save you hours of manual work
5,0(1)
Tableaux de bord des données
I will clean your data build an excel dashboard and write the report

Portfolio

Expérience professionnelle

TokyoTaco®

Owner I Operator

TokyoTaco®

Dec 2021 - Present4 yrs 9 mos

I co-founded and run a Japanese-Mexican fusion restaurant, and I own the P&L end to end — weekly labour and food cost, menu margin by dish, cash flow, supplier pricing and promotion performance. Every model the business runs on, I built: recipe costing down to ingredient level, a weekly labour dashboard fed automatically from our rostering system, a 13-week cash flow, and a budget vs actual pack I review every Monday. This is why my spreadsheets are built the way they are. I have to use them at 6am on a Saturday, not present them.

Accor

Restaurant Manager

Accor

Mar 2017 - Mar 20214 yrs

Hotel food and beverage across restaurant, bar, banquets and events. Forecast covers and revenue against occupancy, costed function and event packages, and reconciled event P&Ls after the fact. Hotel finance is where I learned budgeting discipline properly: driver-based forecasts, month-end variance analysis, and having to defend a number to a financial controller who has already read the file. It is the reason I build models with a checks tab and no hardcoded numbers.

9 Avis
5,0

(9)
(0)
(0)
(0)
(0)
Détails de la notation
  • Niveau de communication avec le freelance
    5
  • Qualité de la livraison
    5
  • Valeur de la livraison
    5
1 à 5 avis sur 9
Trier par
Les plus pertinents
    S
    image-docs

    sherley_jiang

    CN

    Chine

    Collaboration en cours
    5

    Very glad to work with Andrew again, he followed all the instructions and deliver it with a fast time, the recording are also perfect, we'de love to work with him again for more projects! Thanks again!

    50 $US

    Prix

    2 jours

    Durée

    gig

    Formules & Macros

    Utile?
    Oui
    Non
    D
    image-docs

    dougfogg

    AU

    Australie

    Collaboration en cours
    5

    On Time & to budget

    50 $US

    Prix

    10 jours

    Durée

    Utile?
    Oui
    Non
    H
    image-docs

    hairyasbeards

    AU

    Australie

    5

    Andrew was great communication throughout and worked with me through clarifying the details. Highly recommend

    50 $US-100 $US

    Prix

    3 semaines

    Durée

    Utile?
    Oui
    Non
    S

    saramonroe451

    US

    États-Unis

    5

    Highly IMPRESSIVE! Andrew C's exceptional attention to detail and professionalism truly exceeded my expectations in data processing. Not only did he deliver superb quality work, but his quick responsiveness and language fluency made the collaboration a breeze. 🙌

    50 $US-100 $US

    Prix

    2 jours

    Durée

    Utile?
    Oui
    Non
    S
    image-docs

    sherley_jiang

    CN

    Chine

    Collaboration en cours
    5

    Very happy to work with Andrew,pay highly attention to our instruction and fast delivery,we'd like to work with him again with more project. Many thanks for your support again!

    50 $US-100 $US

    Prix

    8 jours

    Durée

    Utile?
    Oui
    Non