Please give me 2-3 paragraphs on an ANALYSIS of the COST VOLUME PROFIT (CVP) and answer the following questions (3-5). I put the excel below. If you do any excel calculations please submit seperate :) thank you.

ACCT 4210 DAY CARE IN PUBLIC HOUSING Assignment: 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, assume instead that he has hired you to analyze the proposal in preparation for the board meeting. Specifically, Mr. Schaefer wants you to do the following: Prepare a cost-volume-profit (CVP) analysis of the proposal's financial implications. Specifically, prepare an 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 weighted 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. However, I have not included the formulas. 3) How would you describe the cost structure of the Alta Vista day-care center? In other words, what costs from Attachment A can be managed; can the center avoid any of the variable or fixed costs? What costs are missing from Attachment A, if any? 4) What is the break-even number of students needed to enroll without the administrative fee to the VOA office? Should the office charge this fee to the day-care center in the short term? In the long term? Is charging the fee consistent with the VOA's mission? 5) If the Alta Vista day-care center opens based on Mr. Schaefer's current plan, do you predict that it will succeed or fail? 20 25 SU 2.550 1,333 700 4,583 3,400 1,867 700 5,967 4.250 2,400 700 7,350 5,383 3,200 700 9,283 60 40 40 642 782 3,801 75 50 50 835 1,010 90 60 60 1.029 1,239 6.111 111 74 74 1,300 1,559 7.724 4,957 3,126 175 239 11 33 9 3,928 700 300 11 33 9 4 3 4 Revenue: 2-3 year olds ($17 per day x 250/12 x 80% 4-5 year olds ($16 per day x 250/12 x 80% 5 year olds ($7 per day x 250/12 x 80%) Total revenue Variable costs: 8102 Educational supplies (53 per student) 8103 Recreational supplies ($2 per student) 8105 Housekeeping supplies ($2 per student) 8201 Administrative expense (14% of total revenue) Total variable costs Contribution margin (CM) Fixed costs: 7000 Salaries, total 7103 Employee benefits 7201 FICA taxes 8001 Employee fees paid 8004 Staff development training 8005 Help wanted ads 8010 Membership in other organizations 8101 Medical/first aid kit supplies 8104 Food and beverage supplied by USDA 8106 Office supplies 8111 Telephone expense 8112 Postage 8401 Rent 8402 Equipment maintenance 8404 Mortgageote/loan interest 8406 Utilities, total 8501 General insurance 8502 Workmen's compensation 8601 Outside printing 8606 Subscriptions and publications 8702 Van maintenance/insurance/gas 8706 Staff mileage 9402 Miscellaneous expenses 9500 Depreciation Total fixed costs Total variable and fixed costs Operating profit (loss) Weighted average CM per student Number of students needed to break even Round up break-even students 1 3 0 5 140 25 0 22 0 240 92 10 25 2 45 48 10 0 4.264 5,046 (463) 190.05 22.44 23 0 5 140 25 0 22 0 240 92 13 25 2 45 48 10 0 5,655 6,665 (698) 198.28 28.52 29 4,665 875 357 16 33 9 4 3 0 10 140 30 0 22 0 240 92 15 25 2 45 48 10 0 6.641 7.880 (530) 203.70 32.60 33 5,402 1,050 413 16 33 9 4 3 0 10 140 30 0 22 0 240 92 19 25 2 45 48 10 0 7,613 9,172 111 208.76 36.47 37 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 222.15 19.19 20.00 5,792 231.68 24.41 25.00 7,140 238.00 27.90 40.00 9,024 243.89 31.21 44.00 ACCT 4210 DAY CARE IN PUBLIC HOUSING Assignment: 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, assume instead that he has hired you to analyze the proposal in preparation for the board meeting. Specifically, Mr. Schaefer wants you to do the following: Prepare a cost-volume-profit (CVP) analysis of the proposal's financial implications. Specifically, prepare an 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 weighted 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. However, I have not included the formulas. 3) How would you describe the cost structure of the Alta Vista day-care center? In other words, what costs from Attachment A can be managed; can the center avoid any of the variable or fixed costs? What costs are missing from Attachment A, if any? 4) What is the break-even number of students needed to enroll without the administrative fee to the VOA office? Should the office charge this fee to the day-care center in the short term? In the long term? Is charging the fee consistent with the VOA's mission? 5) If the Alta Vista day-care center opens based on Mr. Schaefer's current plan, do you predict that it will succeed or fail? 20 25 SU 2.550 1,333 700 4,583 3,400 1,867 700 5,967 4.250 2,400 700 7,350 5,383 3,200 700 9,283 60 40 40 642 782 3,801 75 50 50 835 1,010 90 60 60 1.029 1,239 6.111 111 74 74 1,300 1,559 7.724 4,957 3,126 175 239 11 33 9 3,928 700 300 11 33 9 4 3 4 Revenue: 2-3 year olds ($17 per day x 250/12 x 80% 4-5 year olds ($16 per day x 250/12 x 80% 5 year olds ($7 per day x 250/12 x 80%) Total revenue Variable costs: 8102 Educational supplies (53 per student) 8103 Recreational supplies ($2 per student) 8105 Housekeeping supplies ($2 per student) 8201 Administrative expense (14% of total revenue) Total variable costs Contribution margin (CM) Fixed costs: 7000 Salaries, total 7103 Employee benefits 7201 FICA taxes 8001 Employee fees paid 8004 Staff development training 8005 Help wanted ads 8010 Membership in other organizations 8101 Medical/first aid kit supplies 8104 Food and beverage supplied by USDA 8106 Office supplies 8111 Telephone expense 8112 Postage 8401 Rent 8402 Equipment maintenance 8404 Mortgageote/loan interest 8406 Utilities, total 8501 General insurance 8502 Workmen's compensation 8601 Outside printing 8606 Subscriptions and publications 8702 Van maintenance/insurance/gas 8706 Staff mileage 9402 Miscellaneous expenses 9500 Depreciation Total fixed costs Total variable and fixed costs Operating profit (loss) Weighted average CM per student Number of students needed to break even Round up break-even students 1 3 0 5 140 25 0 22 0 240 92 10 25 2 45 48 10 0 4.264 5,046 (463) 190.05 22.44 23 0 5 140 25 0 22 0 240 92 13 25 2 45 48 10 0 5,655 6,665 (698) 198.28 28.52 29 4,665 875 357 16 33 9 4 3 0 10 140 30 0 22 0 240 92 15 25 2 45 48 10 0 6.641 7.880 (530) 203.70 32.60 33 5,402 1,050 413 16 33 9 4 3 0 10 140 30 0 22 0 240 92 19 25 2 45 48 10 0 7,613 9,172 111 208.76 36.47 37 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 222.15 19.19 20.00 5,792 231.68 24.41 25.00 7,140 238.00 27.90 40.00 9,024 243.89 31.21 44.00