Excel Dashboard & Inventory Management System for Super Mart

  • Status: Pending
  • Prize: $15
  • Entries Received: 49

Contest Brief

I am the owner of a small-scale retail business named MM Ibrahim & Sons Super Mart, and I’m looking for an experienced and creative Excel expert to help me manage my day-to-day operations more efficiently through a professionally designed Excel workbook. The goal is to develop a visually appealing and automated Excel system that includes a dynamic dashboard and multiple functional sheets to handle key aspects of my business, such as sales, inventory, expenses, employee salaries, and investments.

The winning entry should consist of 4 to 6 interconnected sheets, with the first sheet being a dashboard that visually summarizes important business insights. The dashboard should present an overview of daily, weekly, monthly, and yearly sales, show the current state of inventory, employee salary totals, home consumption (items we take for household use from the mart), and overall investment status. It must be eye-catching and easy to understand, using charts, graphs, and summary boxes to represent data effectively.

The second sheet should cover Daily Sales, where I can log each day's transactions with product names, quantities sold, unit prices, and totals. This sheet should automatically calculate daily totals. The third sheet should manage the Inventory, tracking each product's opening stock, purchases, sales, and closing stock. Optional features like low-stock alerts or category-based sorting will be appreciated for added functionality.

Next, a dedicated Employee Salary sheet is needed to manage the salaries of my three employees. It should allow me to track each employee's monthly salary, attendance, or any deductions (optional), and automatically calculate their total payout. Another important sheet is for Home Expenses, where we will log items taken from the store for household needs, including the item name, quantity, unit price, and total cost, with a monthly summary.

Lastly, I need a sheet to record our Investments and Opening Balance, which will track the opening balance at the start of each month, any additional investments we make, and the resulting total capital available. This sheet should help in monitoring the cash flow and financial health of the super mart.

The complete Excel workbook should be user-friendly, well-organized, and automated, making it simple to use even for someone without technical expertise. Please include drop-down menus, conditional formatting, and formula-based automation wherever suitable. The visual design should be clean, modern, and professional, reflecting the values and ambition of our growing business.

The winner of this contest will not only receive the reward but also be given a 5-star rating and detailed, valuable feedback to help build their freelance profile. Additionally, the winner will be considered for future paid projects, including ongoing support and possible expansions to this Excel system as our business grows.

To participate, please submit a PDF files that includes all the mentioned sheets and features. Creativity, usability, and efficiency will be key factors in choosing the winner. Submitting early is encouraged so that we can provide feedback and give you a chance to revise your entry before the contest ends.

We’re excited to work with someone who can bring clarity, automation, and elegance to our business records. Looking forward to seeing your innovative Excel solutions!

**Your suggestion will be highly appreciated.**

Recommended Skills

No winners yet
Post a Contest Like This

Top entries from this contest

View More Entries

Public Clarification Board

  • Siyam7890
    Siyam7890
    • 1 month ago

    Did you just copied someone else contest?

    • 1 month ago
    1. aneemoffice
      aneemoffice
      • 3 weeks ago

      I was looking at the same thing, it's the same contest...

      • 3 weeks ago
  • haseebulrehman25
    haseebulrehman25
    • 3 weeks ago

    Do you have any sample data or preferred visual style (colors, layout, etc.) you’d like incorporated into the dashboard to match your brand identity?

    • 3 weeks ago
  • haseebulrehman25
    haseebulrehman25
    • 3 weeks ago

    Kindly Miss, check My entry #49 Thanks

    • 3 weeks ago
  • Zahrah & Co. Accountant
    Zahrah & Co. Accountant
    • 3 weeks ago

    Hi Miss,
    Hope you are doing well,
    I’m an experienced Excel expert with a strong background in building dynamic dashboards and automated systems tailored for retail businesses. I’d love to help streamline operations for MM Ibrahim & Sons Super Mart by designing a clean, user-friendly Excel workbook with interconnected sheets for Sales, Inventory, Salaries, Home Expenses, and Investments.

    The first sheet will feature a professional dashboard summarizing key metrics with charts and visuals for sales trends, stock levels, and financial health. All sheets will include dropdowns, formulas, and conditional formatting to ensure automation, accuracy, and ease of use—even for non-technical users.

    Let’s create something impactful. Ping me back!

    • 3 weeks ago
  • mdrabbani3
    mdrabbani3
    • 3 weeks ago

    #47

    • 3 weeks ago
  • shameerm6
    shameerm6
    • 4 weeks ago

    Please check My entry #42

    • 4 weeks ago
  • MuhammadHunain11
    MuhammadHunain11
    • 1 month ago

    assalamualikum

    • 1 month ago
  • uswaasif768
    uswaasif768
    • 1 month ago

    #16

    • 1 month ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!