Project Details

The Somato Business Insights Project delves into crucial aspects of the food delivery platform. Quarterly performance insights offer a holistic view, aiding trend identification. Order accuracy, calculated by delivered and fixed quantities, ensures efficient order fulfillment. The top 10 customers, based on unique IDs, guide tailored strategies. Monthly sales trends are graphically presented for swift analysis. Payment mode correlations reveal customer preferences, optimizing payment systems. Restaurant performance metrics cover order fulfillment times, satisfaction scores, and volumes. The GitHub repository facilitates easy execution and visualization. This comprehensive toolkit empowers stakeholders with actionable data, fostering informed decisions and strategic planning for optimized resource utilization and business growth. Feel free to inquire for further details. The Somato Business Insights Project stands as a vital resource for a nuanced understanding of business dynamics.

Live Interactive Dashboard

Live Interactive Dashboard

Project Details

Indraprastha Apollo Hospitals is embarking on a project to establish a new 710-bed hospital unit, funded by an 80 crore loan. The goal is to meet the increasing healthcare demands by expanding their services. The project involves assessing partner profiles, estimating revenue capacity, planning staffing and organizational structure, detailing plant and machinery requirements, and analyzing project costs and financing options.

A crucial aspect of the project is the creation of a 10-year financial projection, which includes a balance sheet, profit and loss statement, and interest payable schedule. This financial forecast will provide insights into the project's profitability, cash flow, and repayment schedule for the term loan. Additionally, a Break Even Analysis will be conducted to determine the point at which the project starts generating profit.

Project Details

In the project, I conducted a comprehensive manpower planning exercise for an organization in the fashion industry located in Gwalior. With a current workforce of 250 employees and future requirements of future requirements 200 considering expansion plans and anticipated turnover rates 12% (additional 3% involuntary).
I developed two detailed sheets.
The first sheet focuses on the existing workforce, detailing positions, departments, roles, employee names, years of experience, and skills/competencies. This sheet provides a snapshot of the current talent pool.
The second sheet outlines the manpower planning for the required 238 new employees across various departments. It breaks down the requirements for each department, considering additional hires, replacements, and total manpower needed. Moreover, it suggests recruitment methods tailored to each department's needs, such as job portals, employee referrals, job fairs, and social media platforms along with hiring in Quarter wise.

Project Details

In my project on Google's profit and loss account, I explored the effects of changes in various factors on the company's profitability using two main methods: One-Way Analysis and Tornado Analysis.

With One-Way Analysis, I tweaked each factor individually within realistic ranges, like increasing or decreasing by 5% or 10%. This helped me understand how small changes in things like revenue or expenses can affect profit.

In Tornado Analysis, I looked at the combined impact of multiple factors changing at the same time. By visualizing these changes, I gained insights into which factors have the most significant influence on Google's profit and loss.

Overall, these analyses revealed valuable insights into how Google's financial health can be affected by different scenarios. Understanding these impacts is crucial for making informed decisions and managing the company's finances effectively.

Project Details

The project looked at how MRF, BKT Tyres, and Apollo have been paying dividends to their shareholders over the past ten years. We checked three important things: how much of their profits they shared as dividends (payout ratio), how much money investors made from dividends compared to the price of their shares (dividend yield), and how fast their dividends grew over time.

For MRF, the amount of profit they shared as dividends stayed pretty much the same each year. People who invested in MRF got a decent amount of money compared to what they paid for their shares, but it varied a bit from year to year. However, MRF consistently increased the amount they paid out in dividends over time.
We also looked at why MRF made these choices. It turned out that they were really good at making money and managing their finances, so they could afford to pay dividends regularly. When compared to other companies like BKT and Apollo, MRF stood out for its stable and well-managed dividend payment.