1 of 6

Business Data Management�Capstone project�Jan – Apr 2022

VED PRATAP

Indian Institute of Technology, Madras

2 of 6

ABOUT BUSINESS AND COLLECTION OF DATA�

“Gupta ji Phal Dukan” is located near Income Tax Golambar, Bailey Road, Patna - 800001.
The business is run by a middle-aged man, Niraj Gupta, to support his family.
The data has been collected over a period of more than one month ( 01-Feb-2022 to 10-Mar-2022) by visiting the shopkeeper daily, asking him questions, and taking notes on diary. For analysis, Data has been collected for 7 fruits only. Fruits are Orange, Sweet lemon (Mousami), Apple, Pomegranate (Anaar), Kiwi, Dragon fruit and Pear (Naaspati).
After collection, It has been faired on A4 sheets and then whole analysis has been done by Microsoft excel.

Gupta ji phal dukan in Patna, Bihar.

Fig. 1

Fig. 2

Fig.1: Sample of data collected on diary.

Fig.2: Sample of data faired on A4 sheets.

3 of 6

Analysis & Interpretation�

MARKET ANALYSIS

TECHNICAL ANALYSIS

FINANCIAL ANALYSIS

ECONOMIC ANALYSIS

ECOLOGICAL ANALYSIS

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.

The shop makes total of ₹ 1,072,050.00 in the given period.
Apple generate the highest revenue where kiwi generate the least revenue.
Apple is also the most sold item. Kiwi is the least sold item.

4 of 6

Analysis & Interpretation�

Management Objectives

Customer Objectives

Project Objectives

Implementation Plan

Schedules

Tasks

Resources

5 of 6

Analysis & Interpretation�

Management Objectives

Customer Objectives

Project Objectives

Implementation Plan

Schedules

Tasks

Resources

Generally, Shop makes least revenue on Tuesday and highest revenue on Saturday. In specific, it makes least revenue on 08-March-2022 and highest revenue on 07-March-2022.

In general, Shop Makes least profit on Tuesday and highest profit on Thursday. It makes the highest profit on 09-Feb-2022.

At first, There is constant fluctuation is observed in terms of the stock that is left at the end of each day. Later, it’s start increasing. The management of daily left overs and selling them the next day as per the then prevailing rates is practiced by Niraj.

The shop an average of 13.07% profit per day.

6 of 6

Recommendations�

THANK YOU

Fruits tend to be cheaper on Monday and Thursday. He should buy more fruits on Monday or Thursday and keeps it in stock (In proper condition).

On the overall, Niraj makes the least profit on Tuesday. He should buy and hence, sell more of apples which generate high revenues and high profits.

He can start a new scheme that ‘if anyone buys 2 Kgs of Apple the a packet of ‘kiwi’ will be free’. This scheme further increases the sale of ‘Apple’ and also attract the customer attention towards ‘Kiwi’.

The shop is located in urban area. He can start ‘Home delivery service under specific range (KMs)’. This will increase the expenditure but also increase the revenue by increasing sales and overall he can make profits and gain more customers.