lab6_marrero

lab6_marrero - Day Care Wonders Income Statement Author...

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

View Full Document Right Arrow Icon
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.
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
Image of page 3
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 Right Arrow Icon
Ask a homework question - tutors are online