Dan Schaefer, executive director of the Petersburg, VA, office of the Volunteers of America (VOA), is eager for the board of directors to approve his plan to open a day-care center in the Alta Vista housing community. Mr. Schaefer believes this proposal is an ideal way to begin to rebuild Alta Vista. The Petersburg VOA helped to establish this community in 1971; unfortunately, the residents have seen a rise in criminal activity and a decrease in their quality of life.

Although the board approves Mr. Schaefer's proposal at the end of the case, assumeinsteadthat he has hired you to analyze the proposal in preparation for the board meeting. Specifically, there are three parts to this assignment:

1.Read the case.

2.Make acost-volume-profit (CVP) analysis of the proposal's financial implications. Make analysis that includes the projected revenue, variable costs, and fixed costs for enrollment levels of 20, 25, 30 and 37 students using the monthly projections in Attachment A of the case. Then, compute the average contribution margin (CM) per student (computed as the total CM divided by the number of students enrolled) and the number of students that need to enroll at each of the four levels of enrollment for the center to break even. For this analysis, I have provided an Excel template in which I have already sorted variable and fixed costs. I have included the raw data, but I have not included the formulas.

oWhen you are finished with the CVP analysis,

3.

oDo you think that (a) Dan Schaefer should recommend the proposal or (b) Dan Schaefer shouldnotrecommend the proposal.

oSupport for your statement

Home \\DEVE ` TELL ME What you well too !` G` SIETE \\ 86 Cut _DEF Copy - Times New RO -| 10 -| A" A ab Wrap Text General Normal Bad Good [ Autosum - AY ` Paste\\ [* Fill - `` Format Painter\\ \\B I U -^ _ ` - A - = = =*$ 3{{\\Merge & Center *\\ $80 7 .0 Conditional Format as| Neutral Formatting - Table - Calculation Insert Delete Format\\\\ Clear - Sort & Find & Filter - Select * Clipboard Font Alignment Number Styles Cells Editing A K 45 X for M in E U HA N *\\HE H \\Analysis of Financial Projections - With Given Case Data\\ 20 - - Total Number of Students - - - 37 \\REVENUE .\\ \\2 - 3 year Old = 1 $ 7 7 FET day H ZSCHITZ H EIL` 3 . 4 0101 5 . 3813 - 5 year Old = 1$ TE; FIET day H ZE LITZ' M EL` 1.3:3:3 \\. BET LILLE 5 year old = [$ 7 FET day & 25017Z H BO` ! !` Total revenue\\ }| Variable costs :\\ BITLIZ Educational SUPPLIES |} PET SALAJEN! BYLIZ Fiecreational =UFFlies 1$ 2' PER Student!* $70S HOUSEKEEPING SUFFliE = 1 $ 2' FIET Student !` ` ``IN NOE BIZZY AdministrativE EXPENSE 174` Of total REVENUE* !* Total variable costs* 13010 \\Contribution margin [MY] TE| Fixed costs :` Salaries , total\\ FIZZ EMPLOYEE BENEFIT=\\ 175 1 : 05 FELT FILLHISHES 201\\ DiLILMY` EMPLOYEE FEES Paid Staff development training _HELP wanted add=\\ BUTTO Membership in Other organizations.* BTLIT Medicalifirst aid kit SUFFlies $1[14 Food and GIE VETS`E SUFFliEd Ly LISILIA \\BILIE LIFTICE SUPPLIES\\ 28\\ _TELEPHONE EXPERIEE* 29\\ BYTZ FastEZE BEEF } ~ + M O V E NT O N = = N O W} ~ `^ ED B4[IT] F E GUNMEN BONOM BUD WAL` `` \\BALLZ EQUIPITIent Maintenance* Mortgag Einsteinan interest BALIE I LUtilities . total\\ GENEISTIMEHITSNICE\\ \\GSLIZ `OrKITIEr" = COMIFIFTIEStion \\DIGILIT [lutside Printing\\ \\BEIDIE Subscriptions and Publications* \\BILLZ {'arimaintenanceinsurance : `as \\BIRDIE {itaff mile =]E* $34 [12\\ MiscellANEOUS EXPERISEE* 45 0 0 LEFTEciation\\ Total fixed costs\\ Total variable and fixed costs Operating profit [loss !` Average [M per student Number of students needed to break ever _ J ITI LI Round up break- even students* Total [MY without administrative fee* Average LM PER Student *10 admin . Fee* umber of students *to admin . fee Breakeven number of*$ Round up break - even students\\ Alta Vista Project Analysis\\ ( 7 ) Ready + 6096\\