lab6_marrero

# lab6_marrero - Day Care Wonders Income Statement Author...

This preview shows pages 1–3. Sign up to view the full content.

Day Care Wonders Income Statement Solution Author Dayani Marrero Date Created 2/22/2012 Purpose Contents Income Statement with One and Two Variable Data Tables Scenario Summary Recommendation This spreadsheet provides What-If analysis based on the  Income Statement of Jane Morales.  This What-If analysis wil   help Ms. Morales determine  whether it is viable for her to start  this business.  This is a recommendation as to Ms. Morales ability to make \$75,000 profit from her Day Care Center.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Day Care Wonders Income Statement Teacher:Student Ratio Required Students Teachers Solution 1 1 Assumptions 7 2 Number of Children/Day 15 13 3 Average Days per Year 250 19 4 Teacher Cost per Year 15,000 Food per Child per Day 1.3 Effect of Varying Number of Children on Expenses and Net Income Supplies per Child per Year 25 Initial Values 6 7 8 9 10 11 12 13 14 15 Expenses \$74,563 \$41,525 \$56,863 \$57,200 \$57,538 \$57,875 \$58,213 \$58,550 \$73,888 \$74,225 \$74,563 Annual Revenue
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 02/22/2012 for the course BIS 155 taught by Professor Frye during the Spring '10 term at DeVry Chicago.

### Page1 / 3

lab6_marrero - Day Care Wonders Income Statement Author...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online