Create an Excel VBA Dashboard for a Small Ride-Hailing Business
Budget: $10 – $30 USD
I need an Excel dashboard to manage and visualize the financial and operational performance of my ride-hailing business. The dashboard should allow for monthly data entry of key parameters and display this data visually. Additionally, it should include a financial forecast and cash flow analysis.
Requirements
Monthly Data Entry Sheet (Parameters_Mensuels)
Columns:
Month (Mois)
Number of Drivers (Nombre de Chauffeurs)
Number of Rides per Day per Driver (Nombre de Courses par Jour et par Chauffeur)
Number of Operating Days per Month (Nombre de Jours d'Opération par Mois)
Average Fare per Ride (Prix Moyen d'une Course)
Commission per Ride (Commission sur Chaque Course)
Monthly Expenses (Dépenses)
Dashboard Sheet (Tableau_de_Bord)
Visual representation of:
Number of Drivers
Number of Rides
Monthly Revenue
Operating Days
Commission
Data should be updated automatically from the Parameters_Mensuels sheet.
Cash Flow Sheet (Plan_Tresorerie)
Columns:
Month (Mois)
Revenue (Revenu)
Expenses (Dépenses)
Cash Flow (Cash Flow)
Balance (Solde)
The balance should be a running total of the cash flow.
Automation with VBA
A VBA script that updates the Dashboard and Cash Flow sheets based on the data entered in the Parameters_Mensuels sheet.
Deliverables:
Excel file with three sheets: "Paramètres_Mensuels", "Tableau_de_Bord", and "Plan_Tresorerie".
VBA script to automate the updating of the Dashboard and Cash Flow sheets.
Instructions on how to use the file and run the VBA script.
Timeline: Please provide an estimated timeline for completion.
Budget: Provide a quote for the entire project, including any revisions.
Requirements
Monthly Data Entry Sheet (Parameters_Mensuels)
Columns:
Month (Mois)
Number of Drivers (Nombre de Chauffeurs)
Number of Rides per Day per Driver (Nombre de Courses par Jour et par Chauffeur)
Number of Operating Days per Month (Nombre de Jours d'Opération par Mois)
Average Fare per Ride (Prix Moyen d'une Course)
Commission per Ride (Commission sur Chaque Course)
Monthly Expenses (Dépenses)
Dashboard Sheet (Tableau_de_Bord)
Visual representation of:
Number of Drivers
Number of Rides
Monthly Revenue
Operating Days
Commission
Data should be updated automatically from the Parameters_Mensuels sheet.
Cash Flow Sheet (Plan_Tresorerie)
Columns:
Month (Mois)
Revenue (Revenu)
Expenses (Dépenses)
Cash Flow (Cash Flow)
Balance (Solde)
The balance should be a running total of the cash flow.
Automation with VBA
A VBA script that updates the Dashboard and Cash Flow sheets based on the data entered in the Parameters_Mensuels sheet.
Deliverables:
Excel file with three sheets: "Paramètres_Mensuels", "Tableau_de_Bord", and "Plan_Tresorerie".
VBA script to automate the updating of the Dashboard and Cash Flow sheets.
Instructions on how to use the file and run the VBA script.
Timeline: Please provide an estimated timeline for completion.
Budget: Provide a quote for the entire project, including any revisions.