BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 37

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).