Question: Analysis of Financial Projections - With Given Case Data - - - - - - - - - - Total Number of Students - -

Analysis of Financial Projections - With Given Case Data---------- Total Number of Students ----------20253037Revenue:2-3 year olds ($17 per day x 250/12 x 80%)2,5503,4004,2505,3834-5 year olds ($16 per day x 250/12 x 80%)1,3331,8672,4003,2005 year olds ($7 per day x 250/12 x 80%)700700700700 Total revenue4,5835,9677,3509,283 Variable costs:8102 Educational supplies ($3 per student)6075901118103 Recreational supplies ($2 per student)405060748105 Housekeeping supplies ($2 per student)405060748201 Administrative expense (14% of total revenue)6428351,0291,300 Total variable costs7821,0101,2391,559 Contribution margin (CM)3,8014,9576,1117,724 Fixed costs:7000 Salaries, total3,1263,9284,6655,4027103 Employee benefits1757008751,0507201 FICA taxes2393003574138001 Employee fees paid111116168004 Staff development training333333338005 Help wanted ads99998010 Membership in other organizations44448101 Medical/first aid kit supplies33338104 Food and beverage supplied by USDA00008106 Office supplies5510108111 Telephone expense1401401401408112 Postage252530308401 Rent00008402 Equipment maintenance222222228404 Mortgage/note/loan interest00008406 Utilities, total2402402402408501 General insurance929292928502 Workmens compensation101315198601 Outside printing252525258606 Subscriptions and publications22228702 Van maintenance/insurance/gas454545458706 Staff mileage484848489402 Miscellaneous expenses101010109500 Depreciation0000 Total fixed costs4,2645,6556,6417,613 Total variable and fixed costs5,0466,6657,8809,172 Operating profit (loss) Weighted average CM per student Number of students needed to break even Round up break-even students Total CM without administrative fee Weighted average CM per student w/o admin. fee Breakeven number of students w/o admin. fee Round up break-even students
Show step by step work

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!