Scribd Logo
Upload

Welcome to Scribd!

  • 29 views

    Bai 2

    Uploaded by

    Lan Huỳnh
    The document provides instructions to update various elements of a monthly budget workbook, including adding actual budget totals to a chart, updating a table and adding a company logo. It also instructs to make a copy of the summary worksheet, change the workbook theme, and calculate the average of positive values in a column.

    Copyright:

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

    Bai 2

    Uploaded by

    Lan Huỳnh
    29 views4 pages
    The document provides instructions to update various elements of a monthly budget workbook, including adding actual budget totals to a chart, updating a table and adding a company logo. It also instructs to make a copy of the summary worksheet, change the workbook theme, and calculate the average of positive values in a column.

    Original Title

    Bai 2 (1)

    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 provides instructions to update various elements of a monthly budget workbook, including adding actual budget totals to a chart, updating a table and adding a company logo. It also instructs to make a copy of the summary worksheet, change the workbook theme, and calculate the average of positive values in a column.

    Copyright:

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

    Bai 2

    Uploaded by

    Lan Huỳnh
    The document provides instructions to update various elements of a monthly budget workbook, including adding actual budget totals to a chart, updating a table and adding a company logo. It also instructs to make a copy of the summary worksheet, change the workbook theme, and calculate the average of positive values in a column.

    Copyright:

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

    1. On the “Summary” worksheet, include “Actual” of “Budget totals” to the “Budget Overview” Chart.

    Do not change other s


    2. Add the text “GOOGLE’s budget” as the document Status property of the document.
    3. Locate the “Index” table and update value of the last column of this table without changing the format.
    4. On the “Expenses” worksheet, in cell F1, use a function to get the average of the cells from “Difference” column that are g
    5. Make a copy of the “Summary” worksheet and color the copied sheet tab to Dark Blue.
    6. Add the logo.png file to the right of the “Monthly Budget” title on the “Summary” worksheet. Then Fill Pattern type Solid
    7. Change the theme of this workbook to “Slice”.
    Chart. Do not change other settings.

    fference” column that are greater than 0.

    Then Fill Pattern type Solid diamond to this picture.


    MOS EXCEL 2016

    MONTHLY BUDGET
    BUDGET OVERVIEW
    BUDGET TOTALS ESTIMATED PRIVATE ACTUAL DIFFERENCE
    ESTIMATED
    Income 63,300.00 126,600.00 57,450.00 (5,850.00) 63,300.00
    Expenses 54,500.00 109,000.00 49,630.00 (4,870.00)

    54,500.00
    is cell. Top 5 Operating Expenses are automatically updated in Top5Expenses table, below.

    WHAT ARE MY TOP 5 HIGHEST OPERATING EXPENSES?


    Income Expenses
    EXPENSE AMOUNT % OF EXPENSES 15% REDUCTION

    Maintenance and repairs 4,600.00 9.3% 690.00 EXPENSE OVERVIEW


    Supplies 4,500.00 9.1% 675.00 5,000.00 10.0%

    Rent or mortgage 4,500.00 9.1% 675.00 4,000.00 8.0%

    Taxes 3,200.00 6.4% 480.00 3,000.00 6.0%


    Advertising 2,500.00 5.0% 375.00 2,000.00 4.0%
    Total 19,300.00 38.9% 2,895.00 1,000.00 2.0%

    0.00 0.0%
    1 2 3 4 5

    INCOME ESTIMATED ACTUAL TOP 5 AMOUNT DIFFERENCE AMOUNT % OF EXPENSES


    Net sales 60,000.00 54,000.00 54,000.00 (6,000.00)
    Interest income 3,000.00 3,000.00 3,000.00 0.00
    Asset sales (gain/loss) 300.00 450.00 450.00 150.00
    INCOME OVERVIEW
    Total Income 63,300.00 57,450.00 (5,850.00) 60,000.00 70,000.00
    50,000.00 60,000.00
    40,000.00 50,000.00
    40,000.00
    30,000.00
    PERSONNEL EXPENSES ESTIMATED ACTUAL TOP 5 AMOUNT DIFFERENCE 30,000.00
    20,000.00 20,000.00
    Wages 9,500.00 9,600.00 9,600.00 (100.00)
    10,000.00 10,000.00
    Employee benefits 4,000.00 0.00 0.00 4,000.00
    0.00 0.00
    Commission 5,000.00 4,500.00 4,500.00 500.00
    ACTUAL ESTIMATED
    Total Personnel Expenses 18,500.00 14,100.00 4,400.00

    Page 3 of 4
    MOS EXCEL 2016

    MONTHLY BUDGET
    OPERATING EXPENSES ESTIMATED ACTUAL DIFFERENCE

    Advertising 3,000.00 2,500.00 500.00

    Bad debts 2,000.00 2,000.00

    Cash discounts 1,500.00 2,175.00

    Delivery costs 2,000.00 1,500.00

    Depreciation 1,000.00 1,000.00

    Dues and subscriptions 500.00 525.00

    Insurance 1,300.00 1,275.00

    Interest 2,000.00 2,200.00

    Legal and auditing 1,000.00 800.00

    Maintenance and repairs 4,500.00 4,600.00

    Office supplies 800.00 750.00

    Postage 400.00 350.00

    Rent or mortgage 4,100.00 4,500.00

    Sales expenses 350.00 400.00

    Shipping and storage 900.00 840.00

    Supplies 5,000.00 4,500.00

    Taxes 3,000.00 3,200.00

    Telephone 250.00 280.00

    Utilities 1,400.00 1,385.00

    Other 1,000.00 750.00

    Page 4 of 4

    You might also like