a
andrewjcollis

Andrew C

@andrewjcollis
5,0(10)

Excel Dashboards, Budgets and Financial Models I Hospitality

Australië
Engels
Sommige informatie wordt in het Engels weergegeven.
Over mij
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.... Lees meer

Skills

a
andrewjcollis
Andrew C
offline • 
Gemiddelde reactietijd: 1 uur

Bekijk mijn diensten

Formules en macro's
I will build excel vba macros and automation to save you hours of manual work
5,0(2)
Data dashboards
I will clean your data build an excel dashboard and write the report

Portfolio

Werkervaring

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.

10 Reviews
5,0

(10)
(0)
(0)
(0)
(0)
Specificering van de beoordeling
  • Communicatieniveau van de freelancer
    5
  • Kwaliteit van de levering
    5
  • Waarde van de levering
    5
1-5 van 10 reviews
Sorteer op
Meest relevant
    S
    image-docs

    sherley_jiang

    CN

    China

    Lopende samenwerking
    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!

    US$ 50

    Prijs

    2 dagen

    Looptijd

    gig

    Formules en macro's

    Nuttig?
    Ja
    Nee
    D
    image-docs

    dougfogg

    AU

    Australië

    Lopende samenwerking
    5

    On Time & to budget

    US$ 50

    Prijs

    10 dagen

    Looptijd

    Nuttig?
    Ja
    Nee
    H
    image-docs

    hairyasbeards

    AU

    Australië

    5

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

    US$ 50-US$ 100

    Prijs

    3 weken geleden

    Looptijd

    Nuttig?
    Ja
    Nee
    S

    saramonroe451

    US

    Verenigde Staten

    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. 🙌

    US$ 50-US$ 100

    Prijs

    2 dagen

    Looptijd

    Nuttig?
    Ja
    Nee
    S
    image-docs

    sherley_jiang

    CN

    China

    Lopende samenwerking
    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!

    US$ 50-US$ 100

    Prijs

    8 dagen

    Looptijd

    Nuttig?
    Ja
    Nee