Adair needs your help in completing her Income Statement. She has provided the basic assumptions, but you need to provide the calculations that will be used as you perform What-If analysis.
A. Open Week5 _ Lab6 _ Adair _ Daycare _ Student. xlsx. Notice that Adair has provided the basic assumptions concerning her costs and her revenue.
B. Complete the following calculations. Revenue
• Total Revenue: Multiply tuition per day times number of days by number of children.
Variable expenses are those expenses that will depend on the number of children served each year. Jane has provided the assumptions. Define annual costs based on the cost per day multiplied by the number of children multiplied by the number of days.
• Food Expenses
• Supply Expenses
Teacher Cost: Create a VLOOKUP function to determine the annual teacher cost. The Lookup Value is the number of children. The Lookup Table is in cells E3: F7. The Index Column is the second column in the table. You want the closest match. Multiply the LOOKUP function times the annual teacher salary.
Total Variable expenses: This will be the SUM of all of the Variable Expenses( B17: B19).