Scribd Logo
Upload

Welcome to Scribd!

  • 20 views

    Excel Activity

    Uploaded by

    Christian Jimenez
    The document shows business expenses from January to June broken down by category including office supplies, lease, utilities, phone, computer, and internet. It provides the total costs by month and quarter as well as averages for each expense category. A forecast is given for the lease expense in Q3 and charts are included to visualize the monthly expense trends. The table tracks the monthly and total expenses from January to June for office supplies, lease, utilities, phone, computer, and internet. It also calculates the quarterly totals for Q1 and Q2 as well as average costs for each expense category. The document analyzes business expenses over a 6 month period,

    Copyright:

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

    Excel Activity

    Uploaded by

    Christian Jimenez
    20 views5 pages
    The document shows business expenses from January to June broken down by category including office supplies, lease, utilities, phone, computer, and internet. It provides the total costs by month and quarter as well as averages for each expense category. A forecast is given for the lease expense in Q3 and charts are included to visualize the monthly expense trends. The table tracks the monthly and total expenses from January to June for office supplies, lease, utilities, phone, computer, and internet. It also calculates the quarterly totals for Q1 and Q2 as well as average costs for each expense category. The document analyzes business expenses over a 6 month period,

    Original Title

    EXCEL ACTIVITY

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document shows business expenses from January to June broken down by category including office supplies, lease, utilities, phone, computer, and internet. It provides the total costs by month and quarter as well as averages for each expense category. A forecast is given for the lease expense in Q3 and charts are included to visualize the monthly expense trends. The table tracks the monthly and total expenses from January to June for office supplies, lease, utilities, phone, computer, and internet. It also calculates the quarterly totals for Q1 and Q2 as well as average costs for each expense category. The document analyzes business expenses over a 6 month period,

    Copyright:

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

    Excel Activity

    Uploaded by

    Christian Jimenez
    The document shows business expenses from January to June broken down by category including office supplies, lease, utilities, phone, computer, and internet. It provides the total costs by month and quarter as well as averages for each expense category. A forecast is given for the lease expense in Q3 and charts are included to visualize the monthly expense trends. The table tracks the monthly and total expenses from January to June for office supplies, lease, utilities, phone, computer, and internet. It also calculates the quarterly totals for Q1 and Q2 as well as average costs for each expense category. The document analyzes business expenses over a 6 month period,

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 5

    Business Expenses

    Expenses January February march APRIL MAY JUNE TOTAL COST


    Office Supplies ₱ 332.08 ₱ 359.84 ₱ 357.69 ₱ 343.28 ₱ 355.29 ₱ 358.69 ₱ 2,106.87
    Lease ₱ 770.00 ₱ 770.00 ₱ 770.00 ₱ 790.00 ₱ 790.00 ₱ 790.00 ₱ 4,680.00
    Utilities ₱ 384.00 ₱ 374.00 ₱ 387.00 ₱ 124.00 ₱ 455.00 ₱ 499.00 ₱ 2,223.00
    Phone ₱ 179.00 ₱ 449.00 ₱ 392.00 ₱ 111.00 ₱ 383.00 ₱ 320.00 ₱ 1,834.00
    Computer ₱ 347.00 ₱ 293.00 ₱ 400.00 ₱ 473.00 ₱ 288.00 ₱ 743.00 ₱ 2,544.00
    Internet ₱ 447.00 ₱ 292.00 ₱ 477.00 ₱ 392.00 ₱ 237.00 ₱ 374.00 ₱ 2,219.00
    Total Cost By month ₱ 2,459.08 ₱ 2,537.84 ₱ 2,783.69 ₱ 2,233.28 ₱ 2,508.29 ₱ 3,084.69 ₱ 15,606.87
    Q1 COSTS ₱ 7,780.61 Q2 COSTS ₱ 7,826.26

    Lease Forecast for Q3 ₱ 2,430.00 Chart Title


    ₱3,000.00
    ₱2,000.00
    ₱1,000.00
    ₱-
    s se es e r et h
    l ie a iti on te rn nt
    pp Le til Ph pu te o
    S u U
    Co
    m In ym
    ce s tB
    Offi Co
    tal
    To
    January February march
    AVERAGE COST
    ₱ 351.15
    ₱ 780.00
    ₱ 370.50
    ₱ 305.67
    ₱ 424.00
    ₱ 369.83
    ₱ 2,601.15

    et nt
    h
    e rn o
    t
    In ym
    s tB
    Co
    tal
    To
    Marks Out of Percentage ASSET liabilities assetts/lianbilities
    80 100 80 2432 3644 0.66739846322722
    75 150 50
    10 20 50
    135 200 67.5
    465 500 93
    NAMES TIME-IN TIME-OUT NO.OF HOURS
    sdfsdfsdf 8:00 AM 3:40 PM 6.67
    sdfsdfsdf 8:00 AM 4:30 PM 8.50
    dsfsdfs 9:00 AM 6:12 PM 9.20
    sfsdfs 8:00 AM 4:10 PM 8.17
    Messy Data First Name Last name Birth Date
    Bruce Cabbot 06/29/93 Bruce Cabbot 6/29/1993
    Dany Comebacaser 07/13/77 Dany Comebacaser 6/13/1993
    Afdfsd Adfdvdf 03/22/99 Afdfsd Adfdvdf 6/22/1993
    Dffgfg Dewefsd 02/02/99 Dffgfg Dewefsd 6/2/1993
    Hhdfdhdf Qdjsdsdf 04/04/88 Hhdfdhdf Qdjsdsdf 6/4/1993
    Fdergbc Cdfhfg 01/01/90 Fdergbc Cdfhfg 6/1/1993
    Hnmnh Uiwerwpo 12/12/99 Hnmnh Uiwerwpo 6/12/1993
    Bsdhdjdf Thdjad 07/07/87 Bsdhdjdf Thdjad 6/7/1993

    You might also like