The VP of admissions has a second concern as well. There are a variety of ways to attract students and increase applications. The university can purchase online advertising, send out traditional mailings, and do in-person recruiting at various functions. The VP estimates that each online ad will result in 50 new applications, each traditional mailing will result in 30 new applications, and each recruiting event will result in 12 new applications. Online advertising costs $850 per ad, mailings cost $600 each, and in-person recruiting events cost $300 per appearance.  The university wants to maintain a broad presence, so at least 3 of each form of recruiting is desired. There are limited personnel available for recruiting, so a maximum of 5 in-person recruiting events can be managed.  At least half of the advertising must be online, as the university president wants to expand enrollments in on-line programs. The VP has a budget of $7,000. The VP wants to understand the mathematical problem that must be solved to figure out how many of each type of advertising should be used, and have an Excel file that can solve the problem. (For convenience, feel free to solve the problem in terms of partial units...i.e. the final answer can be 1.2 online ads, 2.6 mailings, etc.).  

Based on your results, what marketing strategy would you recommend to the VP? 

What would be the impact of increasing the marketing budget by $2,000?



And finally, the President of SWC has decided that the organizational structure of the university is suboptimal. As such, the President is ready to kick off a project aimed at reorganizing the university departments. She has created the following list of activities and completion times, but would like your help visualizing the project map. The President is also concerned about the length of the project, and wants to know the probability that the project will be finished within 57 weeks (assuming project finish times follow a normal distribution). Be sure to document ALL STEPS needed to reach this probability calculation.   

Year Applications 2 2009 803 3 2010 877 4 2011 942 2012 863 6. 2013 937 7 2014 1054 8 2015 922 9. 2016 976 10 2017 1103 11 2018 1351 12 2019 907 2020 1322 3.