You run a small daycare out of your home. Many of the parents, who love your interactions with their children, have begun talking to you about expanding your operations. Never having thought about opening a daycare business, you have begun to research the cost involved in opening your own center. After gathering some data, you believe you can open a business. But you need to analyze the data and make the data look more presentable to your investors. The workbook contains worksheets with estimated revenues and expenses over a two-year period.
On the revenue worksheet:
* Convert the revenue data set to a table
*Calculate revenue based on the # Children and Income per columns
*Create an advanced filter of your choice to explore the data
On the expenses worksheet:
*Convert the expenses data to a table
*Add two slicers of your choosing to help explore the data
*Filter the data using slicers, copy the filtered data, and then paste a copy to a new worksheet with an appropriate sheet name.
*Insert some blank rows above the table and use SUBTOTAL functions to create three different calculations on the data that is filtered.
w N in 10 00 B D E 1 Date Account Category #Children Income Per 2 2 12/31/2022 Day Care REVENUE 10 $ 150.00 3 12/31/2022 Day Care REVENUE 10 $ 150.00 4 12/31/2022 Day Care REVENUE 6 $ 150.00 5 12/31/2022 Day Care REVENUE 3 $ 150.00 6 11/30/2022 Day Care REVENUE 10 $ 150.00 7 11/30/2022 Day Care REVENUE 9 $ 150.00 8 11/30/2022 Day Care REVENUE 7 $ 150.00 9 9 11/30/2022 Day Care REVENUE 10 $ 150.00 10 11/30/2022 Day Care REVENUE 8 $ 150.00 11 10/31/2022 Field Trip REVENUE 5 $ 25.00 12 10/31/2022 Day Care REVENUE 10 $ 150.00 13 10/31/2022 Day Care REVENUE 6 $ 150.00 14 10/31/2022 Day Care REVENUE 6 $ 150.00 15 10/31/2022 Day Care REVENUE 8 $ 150.00 16 9/30/2022 Day Care REVENUE 5 $ 150.00 17 9/30/2022 Day Care REVENUE 6 $ 150.00 18 9/30/2022 Day Care REVENUE 5 $ 150.00 19 9/30/2022 Day Care REVENUE 9 $ 150.00 Lo/ann DEVENLIC Revenue Expenses Documentation 100 + B D 1 Date Account Category 2 1/31/2021 RENT FACILITY 3 1/31/2021 FIELD TRIPS FIELD TRIPS 4 1/31/2021 INSURANCE INSURANCE 5 1/31/2021 WORKERS COMPENSATION INSURANCE 6 1/31/2021 FRINGES (401K ER MATCH) PAYROLL 7 1/31/2021 GROUP INSURANCE PAYROLL 8 1/31/2021 OVERTIME PREMIUM PAYROLL 9 1/31/2021 PAYROLL ADMIN/TECHNICAL PAYROLL 10 1/31/2021 PAYROLL SERVICES PAYROLL 11 1/31/2021 PAYROLL SUPERVISORY PAYROLL 12 1/31/2021 PAYROLL TAXES PAYROLL 13 1/31/2021 PHONE PHONE 14 1/31/2021 COMPUTER/INTERNET SERVICES SUPPLIES 15 1/31/2021 OFFICE SUPPLIES SUPPLIES 16 2/28/2021 RENT FACILITY 17 2/28/2021 INSURANCE INSURANCE 18 2/28/2021 WORKERS COMPENSATION INSURANCE 19 2/28/2021 FRINGES (401K ER MATCH) PAYROLL Expenses $ 550.00 $ 143.00 $ 175.00 $ 75.00 $ 340.00 $ 184.00 $ 335.00 $ 106.00 $ 135.00 $ 144.00 $ 276.00 $ 127.00 $ 89.00 $ 109.00 $ 550.00 $ 175.00 $ 75.00 $ 173.00 ARIA DAVDAL -lonionnaa Revenue Expenses Documentation w N in 10 00 B D E 1 Date Account Category #Children Income Per 2 2 12/31/2022 Day Care REVENUE 10 $ 150.00 3 12/31/2022 Day Care REVENUE 10 $ 150.00 4 12/31/2022 Day Care REVENUE 6 $ 150.00 5 12/31/2022 Day Care REVENUE 3 $ 150.00 6 11/30/2022 Day Care REVENUE 10 $ 150.00 7 11/30/2022 Day Care REVENUE 9 $ 150.00 8 11/30/2022 Day Care REVENUE 7 $ 150.00 9 9 11/30/2022 Day Care REVENUE 10 $ 150.00 10 11/30/2022 Day Care REVENUE 8 $ 150.00 11 10/31/2022 Field Trip REVENUE 5 $ 25.00 12 10/31/2022 Day Care REVENUE 10 $ 150.00 13 10/31/2022 Day Care REVENUE 6 $ 150.00 14 10/31/2022 Day Care REVENUE 6 $ 150.00 15 10/31/2022 Day Care REVENUE 8 $ 150.00 16 9/30/2022 Day Care REVENUE 5 $ 150.00 17 9/30/2022 Day Care REVENUE 6 $ 150.00 18 9/30/2022 Day Care REVENUE 5 $ 150.00 19 9/30/2022 Day Care REVENUE 9 $ 150.00 Lo/ann DEVENLIC Revenue Expenses Documentation 100 + B D 1 Date Account Category 2 1/31/2021 RENT FACILITY 3 1/31/2021 FIELD TRIPS FIELD TRIPS 4 1/31/2021 INSURANCE INSURANCE 5 1/31/2021 WORKERS COMPENSATION INSURANCE 6 1/31/2021 FRINGES (401K ER MATCH) PAYROLL 7 1/31/2021 GROUP INSURANCE PAYROLL 8 1/31/2021 OVERTIME PREMIUM PAYROLL 9 1/31/2021 PAYROLL ADMIN/TECHNICAL PAYROLL 10 1/31/2021 PAYROLL SERVICES PAYROLL 11 1/31/2021 PAYROLL SUPERVISORY PAYROLL 12 1/31/2021 PAYROLL TAXES PAYROLL 13 1/31/2021 PHONE PHONE 14 1/31/2021 COMPUTER/INTERNET SERVICES SUPPLIES 15 1/31/2021 OFFICE SUPPLIES SUPPLIES 16 2/28/2021 RENT FACILITY 17 2/28/2021 INSURANCE INSURANCE 18 2/28/2021 WORKERS COMPENSATION INSURANCE 19 2/28/2021 FRINGES (401K ER MATCH) PAYROLL Expenses $ 550.00 $ 143.00 $ 175.00 $ 75.00 $ 340.00 $ 184.00 $ 335.00 $ 106.00 $ 135.00 $ 144.00 $ 276.00 $ 127.00 $ 89.00 $ 109.00 $ 550.00 $ 175.00 $ 75.00 $ 173.00 ARIA DAVDAL -lonionnaa Revenue Expenses Documentation
