Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 8 views

    Excel 2 Solution

    Uploaded by

    h20230845
    Alka opens a new nursery school in January 2022, spending Rs. 402500 on initial expenses. The school's monthly expenses include a Rs. 14,000 rental fee, electricity costs depending on operating hours, teacher salaries of Rs. 20,000 paid biweekly, and maintenance costs. Revenue is Rs. 1,000,000 per month from 500 students paying Rs. 2,000 fees each. The school is closed for 2 months in summer and 1 month in winter. Alka will break even in April 2022. In February and March she makes a profit of Rs. 68240 and Rs. 66240 respectively.

    Copyright:

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

    Excel 2 Solution

    Uploaded by

    h20230845
    8 views6 pages
    Alka opens a new nursery school in January 2022, spending Rs. 402500 on initial expenses. The school's monthly expenses include a Rs. 14,000 rental fee, electricity costs depending on operating hours, teacher salaries of Rs. 20,000 paid biweekly, and maintenance costs. Revenue is Rs. 1,000,000 per month from 500 students paying Rs. 2,000 fees each. The school is closed for 2 months in summer and 1 month in winter. Alka will break even in April 2022. In February and March she makes a profit of Rs. 68240 and Rs. 66240 respectively.

    Original Description:

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Alka opens a new nursery school in January 2022, spending Rs. 402500 on initial expenses. The school's monthly expenses include a Rs. 14,000 rental fee, electricity costs depending on operating hours, teacher salaries of Rs. 20,000 paid biweekly, and maintenance costs. Revenue is Rs. 1,000,000 per month from 500 students paying Rs. 2,000 fees each. The school is closed for 2 months in summer and 1 month in winter. Alka will break even in April 2022. In February and March she makes a profit of Rs. 68240 and Rs. 66240 respectively.

    Copyright:

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

    Excel 2 Solution

    Uploaded by

    h20230845
    Alka opens a new nursery school in January 2022, spending Rs. 402500 on initial expenses. The school's monthly expenses include a Rs. 14,000 rental fee, electricity costs depending on operating hours, teacher salaries of Rs. 20,000 paid biweekly, and maintenance costs. Revenue is Rs. 1,000,000 per month from 500 students paying Rs. 2,000 fees each. The school is closed for 2 months in summer and 1 month in winter. Alka will break even in April 2022. In February and March she makes a profit of Rs. 68240 and Rs. 66240 respectively.

    Copyright:

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

    Alka opens a new nursery school on 1st January 2022.

    When
    local newspapers in five prime spots, and Rs. 32,500 for a 5-y
    She also bought a professional audio conferencing set up for
    The school building has been taken on rent, which is Rs 14,00
    school building, so she can vacate it at the end of any month
    of electricity is calculated depending on the number of hours
    The school runs for 5 days a week, each working day for 8 hou
    needs 80 units of electricity while on Saturday every hour nee
    20,000 per teacher; they are paid only @50% for months whe
    months, students pay half of monthly fee. The school remain
    The current location is centrally located in the city, so there is
    fees on a monthly basis @ 2000 per month. Alka’s salary as P
    is closed. Few other expenses are:

    Guest room built in beginning 100 K


    Extra light fans 20 K
    One time install 10 K
    Maintainace- once every 2 months starting Jan 2022* 2 K
    *Except after holidays, it is 3 K for opening month.

    Questions:
    a. When (which month) will Alka break even?
    b. What will be her profits status in the following months – F
    Show all calculations in excel itself
    ol on 1st January 2022. When she opened the school, she paid Rs. 15000 for business cards, Rs. 100,000 for a listing in
    spots, and Rs. 32,500 for a 5-year business license (non-returnable) to avail parking facilities for teachers and parents.
    audio conferencing set up for Rs.1, 25,000.
    ken on rent, which is Rs 14,000 per month that must be paid at the beginning of each month. There is no lease on the
    ate it at the end of any month should she decide to move to a new location or to go out of business. The monthly cost
    nding on the number of hours the school is operational and paid on use basis.
    ek, each working day for 8 hours, and 4 hours on Saturday, Sunday is complete shut off. During weekdays, every hour
    ile on Saturday every hour need just 10 units. Each unit costs Rs. 6.00. 20 teachers are paid once every 15 days @ Rs.
    id only @50% for months when school is closed for general interaction with students’ in weekends. During closed
    onthly fee. The school remains closed for summer (2 months – May and June) and winter (1 month - December).
    located in the city, so there is no plan to change the location. School has an enrollment of 500 students, each paying
    0 per month. Alka’s salary as Principal and manager is Rs. 40,000 per month & she doesn’t take any salary when school
    re:

    100 K

    nths starting Jan 2022* 2 K


    for opening month.

    ka break even?
    us in the following months – February, March, April and May?
    ll calculations in excel itself
    Cost Consider every month as a dicreet set
    Items Amount of weeks for calculations
    Sunk Biz card 15000
    Ad 100000
    Lic 32500
    AV 125000
    Gu ro 100000
    Extra L&F 20000
    Install 10000 teachers are paid half their salary when school is closed
    402500

    Monthly Jan Feb Mar Apr May Jun Jul Aug Sep
    Rent 14000 14000 14000 14000 14000 14000 14000 14000 14000
    No of wks 4 4 4 4 4 4 4 4 4
    Full days 20 20 20 20 20 20 20 20 20
    Half days 4 4 4 4 4 4 4 4 4
    Ele.FD 76800 76800 76800 76800 9600 9600 9600 9600 9600
    Ele.HD 960 960 960 960 240 240 240 240 240
    Main 2000 0 2000 0 2000 0 3000 0 2000
    Tea pay 1 400000 400000 400000 400000 400000 400000 400000 400000 400000
    Tea pay 2 400000 400000 400000 400000 400000 400000 400000 Guest room 100000
    Prin sal 40000 40000 40000 40000 0 0 100000 100000 100000 Extra light fans 20000
    933760 931760 933760 931760 414000 414000 926840 923840 925840
    TC 1336260 One time install 10 K
    Maintain every 2 mo
    Rev 1000000 1000000 1000000 1000000 500000 500000 1000000 1000000 1000000 starting Jan 2022* 2K
    10,00,000 *Except after holidays, it is 3 K
    Net profit -336260 68240 66240 68240 86000 86000 73160 76160 74160 Prin salary (Alka)** 100000
    Loss am 336260 268020 201780 133540 47540 -38460 ** also half in closure time
    Cum profit Profit
    Porfit am 152460
    BEP

    You might also like