Scribd Logo
Upload

Welcome to Scribd!

  • 8 views

    Sample MIS

    Uploaded by

    kasatsurbhi
    MIS

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Sample MIS

    Uploaded by

    kasatsurbhi
    8 views4 pages
    MIS

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    MIS

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    8 views4 pages

    Sample MIS

    Uploaded by

    kasatsurbhi
    MIS

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 4

    Profilt and Loss Statement

    Feb'23 March'23 Apr'23 May'23 Jun'23 Jul'23 Aug'23


    Sale Net Sale 47,85,694 47,61,221 51,59,947 50,60,823 38,99,103 40,17,272 39,81,598
    Tax 1,87,239 1,80,872 1,97,599 1,69,707 1,39,107 1,40,750 1,27,324
    Gross Sale Total 49,72,933 49,42,093 53,57,546 52,30,530 40,38,210 41,58,022 41,08,922

    Discount 58,005 57,254 70,035 1,10,640 51,020 64,590 1,10,976


    Discount % to sales 1% 1% 1% 2% 1% 2% 3%

    Consumption Opening stock 1,30,093 1,63,497 1,10,437 66,635 1,35,340 1,27,410 1,35,616
    Purchase 15,33,856 18,19,350 16,91,018 17,40,583 14,78,353 15,16,453 14,70,729
    Closing stock 1,63,497 1,10,437 66,635 1,35,340 1,27,410 1,35,616 94,877
    Consumption 15,00,452 18,72,410 17,34,820 16,71,878 14,86,283 15,08,247 15,11,468
    % 31% 39% 34% 33% 38% 38% 38%

    Gross Margin 32,85,242 28,88,811 34,25,127 33,88,945 24,12,820 25,09,025 24,70,130


    69% 61% 66% 67% 62% 62% 62%
    Direct Expense
    Manpower cost Salaries 7,38,328 7,43,325 9,28,429 8,05,974 7,33,958 7,57,479 6,18,023
    Uniforms 18,650 12,350 18,450 17,100 7,950 2,100
    Laundry/DryCleaning 3,500 3,500 3,500 3,500 3,500 3,900 3,500
    Staff room rent 26,030 43,800 44,320 44,060 30,066 30,130 24,000
    Staff Welfare 20,057 51,372 7,858 27,185 18,635 17,144
    Total 7,86,508 8,23,032 10,27,621 8,79,842 8,11,809 8,18,094 6,64,767
    16% 17% 20% 17% 21% 20% 17%

    Operational exp. Rent 2,10,000 2,10,000 2,10,000 4,40,000 2,10,000 2,10,000 2,10,000
    Bakery Rent 20,000 20,000 20,000 20,000 20,000 24,973 20,000
    Electricity bill 1,01,282 1,07,056 1,20,362 1,22,565 1,26,941 1,13,106 1,07,073
    Bakery Electricity 8,000 7,000 19,160 4,330 3,250 7,724
    Water (Accrual/ Actual) 18,730 15,000 15,600 21,000 9,600 9,750 7,800
    Gas 1,41,961 1,27,834 1,14,488 1,06,700 94,530 95,200 86,400
    CCG and Utensils 24,183 6,500 80,372 15,872 48,477 49,737 2,200
    Total 5,24,156 4,93,390 5,60,822 7,45,297 5,13,878 5,06,016 4,41,197
    11% 10% 11% 15% 13% 13% 11%
    Indirect exp.
    Admin cost Guest supplies - - - - - - -
    Ice cubes 5,640 6,240 5,220 7,980 6,660 5,640 6,180
    Liscense for Liqour 66,000 87,000 2,34,000 92,000 69,000 - 23,000
    Cleaning supplies 47,619 39,742 41,750 46,640 44,640 46,570 46,613
    Others/Misc 54,757 27,351 27,124 19,759 22,984 56,824 45,092
    Car Rental 25,500 1,39,500 20,000 22,500 20,000 36,500 20,500
    Transport & Hamali 14,973 3,731 12,570 7,342 14,967 8,439 14,542
    Petrol/ Diesel 2,000 - 2,000 3,530 2,000 500 8,080
    CC machine Comm. 15,480 8,200 11,900 10,000 8,700 7,750 7,380
    Repair&Maintenance 41,340 58,490 38,450 34,981 69,990 1,09,208 1,43,946
    Professional Fees 77,226 52,900 41,000 30,000 30,000 30,000 -
    Printing & Stationary 2,257 5,227 5,307 2,467 12,459 1,646 3,318
    Internet charges/server 4,238 - 7,080 - - 7,372 3,966
    Zomato Commission 85,849 87,469 77,595 73,310 65,360 82,529 92,156
    Zomato Pay 12,837 27,120 27,597 36,060 12,903 14,929 23,365
    Swiggy Commission 46,333 61,458 46,438 30,346 27,027 41,423 58,419
    Swiggy Dine-out Commisssion 5,221 13,008 14,698 22,532 20,259 17,330 17,351
    Dine-out Commission 7,501 4,276 5,407 2,162 498 97 -
    GST 59,201 37,222 29,793 36,947 32,785 34,706 33,540
    Bank Charges 924 932 2,342 910 1,380 7,846 6,627
    Bank Guarantee 45,312 - - -
    Fabrication 36,400 14,500 45,000 23,000 5,500 60,401
    Advocate Fees 1,15,500 2,450 - 25,700
    Total 6,11,296 6,74,365 7,40,583 5,94,966 4,87,062 5,14,809 6,40,176
    13% 14% 14% 12% 12% 13% 16%

    Marketing Cost Social Media 68,700 4,220 38,500 - 14,600 18,700 24,050
    Mark. Printing - - - - - - -
    Total 68,700 4,220 38,500 - 14,600 18,700 24,050
    1% 0% 1% 0% 0% 0% 1%

    Total Sale 47,85,694 47,61,221 51,59,947 50,60,823 38,99,103 40,17,272 39,81,598


    Total expense 35,49,116 39,24,671 41,72,381 40,02,623 33,64,652 34,30,456 33,92,634
    PBDIT 12,36,577 8,36,550 9,87,566 10,58,200 5,34,451 5,86,816 5,88,964
    25.84% 17.57% 19.14% 20.91% 13.71% 14.61% 14.79%

    Interest
    Other Taxes
    Depriciation
    Total - - - - - - -

    Net Profit 12,36,577 8,36,550 9,87,566 10,58,200 5,34,451 5,86,816 5,88,964


    26% 18% 19% 21% 14% 15% 15%

    You might also like