7. Camp Fire USA is a national organization with local com- munity Outreach programs. One program is for after- school programs for first through fifth grade students. They now have one school and are considering expan- sion into one or two additional schools. The two addi- tional schools being considered are Buffett and Gates. Camp Fire has obtained a grant in the amount of $125,000 per year for 3 years to extend to one or more additional schools. Your assignment is to create a Planners Lab model to analyze various scenarios and then make a recommen- dation of what Camp Fire might do. Starting assumptions are as given below. Try to arrive at a defensible recom- mendation to offer programs at both schools and do that within Camp Fire's ability to cover costs in the amount of $125,000 per year. You are free to make changes in assumptions to achieve this goal if your changes are rational and reasonably supported. Assumptions include the following: a. The staff to student ratio is 1 staff member for each 10 students. b. The salary for a staff member is $30,000 per year. c. For Buffett, miscellaneous costs are estimated to be $10,000 per year. For Gates, they are $5,000. d. There are estimated to be 30 student prospects at Buffett and 20 at Gates. e. The Gates school board has agreed to donate $15,000 if Camp Fire will host its program at its school Assumptions 2010 2011 COMMENT Camp Fire USA assumptions 125,000 125,000 Expansion funds Staff to student ratio Staff salary 0.1 0.1 125,000 0.1 30,000 30,000 30,000 COMMENT Buffett school assumptions 30 3 90,000 10,000 30 30 90,000 10,000 90,000 10,000 Number of Buffett students Number of Buffett required staff Buffett required staff cost Buffett misc costs Buffett donation Cost to add Buffett Balance of expansion funds if add Ruffett 100,000 25,000 100,000 25,000 100,000 25,000 COMMENT Gates school assumptions 20 20 Number of Gates students Number of Gates required staff Gates required staff cost Gates misc costs Gates donation Cost to add Gates Balance of expansion funds if add Gates 60,000 5,000 15,000 50,000 75,000 60,000 5,000 15,000 50,000 75,000 60,000 5,000 15,000 50,000 75,000 7. Camp Fire USA is a national organization with local com- munity Outreach programs. One program is for after- school programs for first through fifth grade students. They now have one school and are considering expan- sion into one or two additional schools. The two addi- tional schools being considered are Buffett and Gates. Camp Fire has obtained a grant in the amount of $125,000 per year for 3 years to extend to one or more additional schools. Your assignment is to create a Planners Lab model to analyze various scenarios and then make a recommen- dation of what Camp Fire might do. Starting assumptions are as given below. Try to arrive at a defensible recom- mendation to offer programs at both schools and do that within Camp Fire's ability to cover costs in the amount of $125,000 per year. You are free to make changes in assumptions to achieve this goal if your changes are rational and reasonably supported. Assumptions include the following: a. The staff to student ratio is 1 staff member for each 10 students. b. The salary for a staff member is $30,000 per year. c. For Buffett, miscellaneous costs are estimated to be $10,000 per year. For Gates, they are $5,000. d. There are estimated to be 30 student prospects at Buffett and 20 at Gates. e. The Gates school board has agreed to donate $15,000 if Camp Fire will host its program at its school Assumptions 2010 2011 COMMENT Camp Fire USA assumptions 125,000 125,000 Expansion funds Staff to student ratio Staff salary 0.1 0.1 125,000 0.1 30,000 30,000 30,000 COMMENT Buffett school assumptions 30 3 90,000 10,000 30 30 90,000 10,000 90,000 10,000 Number of Buffett students Number of Buffett required staff Buffett required staff cost Buffett misc costs Buffett donation Cost to add Buffett Balance of expansion funds if add Ruffett 100,000 25,000 100,000 25,000 100,000 25,000 COMMENT Gates school assumptions 20 20 Number of Gates students Number of Gates required staff Gates required staff cost Gates misc costs Gates donation Cost to add Gates Balance of expansion funds if add Gates 60,000 5,000 15,000 50,000 75,000 60,000 5,000 15,000 50,000 75,000 60,000 5,000 15,000 50,000 75,000