🍽️ Restaurant Sales Analysis

This repository contains a comprehensive Restaurant Sales Analysis project. The project focuses on analyzing sales data, projecting revenues, and optimizing financial performance, with key features such as dynamic pricing for chicken items and loan calculations for purchasing new equipment.

📋 Project Overview

This project is designed to simulate the role of a restaurant manager making key financial and sales decisions. The tasks covered include sales projections, actual sales comparisons, pricing strategy, loan management, and performance analysis through Excel functions and visualizations. The project aims to:

• Stimulate sales by analyzing underperforming menu items.
• Compare projected and actual sales to identify trends.
• Perform loan repayment calculations for equipment purchases.
• Utilize Excel features such as formulas, functions, conditional formatting, sparklines, and charts to generate insights.

📊 Features

1. Sales Analysis

• Lookup Table: Assign dynamic pricing to chicken items.
• Sales Performance: Compare projected vs. actual sales over four months.
• Revenue Calculations: Calculate total revenue for each menu item and identify the best performers.

2. Loan Repayment Simulation

• Quarterly Payment Calculations: Calculate payments for purchasing a new refrigeration unit based on varying interest rates and repayment periods.
• Financial Projections: Use Excel PMT functions to create loan repayment scenarios.

3. Visualizations

• Charts: Create sparklines and bar charts to analyze total revenue and sales trends for each menu item.
• Conditional Formatting: Highlight high-performing items and visually distinguish data for easier analysis.

4. File Management

• Set custom properties (author, manager, restaurant name) to identify and personalize the workbook.
• Sort and Filter: Use Excel sorting and filtering capabilities to display top performers and summarize data effectively.

🧰 Technologies Used

• Microsoft Excel: All sales analysis and financial projections are handled within an Excel file.
• Git and GitHub: This project is managed with version control, allowing for tracking changes and collaboration.

📝 Project Structure

• Sales_YourName.xlsx: This Excel file contains all the sales and financial data for the restaurant.
• images/: Contains any visuals or screenshots used in the project.
• README.md: Project documentation (this file).

📸 Screenshots

1. Chicken Sales Analysis Table

2. Loan Repayment Plan

   

🚀 How to Run the Project

1. Clone the repository:

   git clone https://github.com/Gbekoilias/restaurant-sales-analysis.git
   

2. Open the Excel file Sales_YourName.xlsx.
3. Follow the tasks in the project description to complete the analysis.

🛠️ Version Control

This project is version-controlled with Git and hosted on GitHub. Follow these steps to contribute or track changes:

• Major Changes: Whenever a significant update (e.g., adding new features or fixing bugs) is made to the project, it will be committed with detailed comments explaining the changes. For example:

git add .
git commit -m "Added revenue calculation and visualized sales trends using sparklines"
git push origin main

• Branching: When adding new features, create a new branch

git checkout -b feature-name

• Merge it into the main branch after review:

git checkout main
git merge feature-name

🤝 Contributing

Feel free to fork this repository and submit pull requests for any enhancements or bug fixes. To contribute:

• Fork the Repository: Click the "Fork" button on GitHub. Clone your forked repo:

Copy code
git clone https://github.com/YourUsername/restaurant-sales-analysis.git

• Create a new branch for the feature or bug fix:

Copy code
git checkout -b feature/fix-description

• Commit your changes with detailed messages:

Copy code
git commit -m "Detailed message about your fix or feature"

• Push your changes to your forked repository:

Copy code
git push origin feature/fix-description

• Submit a Pull Request on GitHub.

📧 Contact

For any queries, feel free to reach out to me via email at [gbekoilias@gmail.com].