Assignment: Quantitative Decision Making
Micromedia offers computer training seminars on a variety of topics. In the seminars each student works at a personal computer provided by Micromedia, practicing the particular activity that the instructor is presenting. Micromedia is currently planning a two-day seminar on the use of Microsoft Excel in statistical analysis. The projected fee for the seminar is only $600 per student. The cost for the conference room, instructor compensation, lab assistants, and promotion is $9600 for two days to be incurred by Micromedia. In addition, Micromedia rents computers for its seminars at a cost of $60 per computer per day. Each student uses one computer. So, the cost of renting a computer, incurred by Micromedia, will be $120 per student. You must find the breakeven point, the point when the cost is equal to revenue for Micromedia. In addition, you must resolve an additional situation of determining the number of students needed to be enrolled in order to make a profit of $9600.
Task:
a. Define the goal seeking problem to be solved in your own words in detail.
b. Develop a mathematical model for the total profit if x represents the number of students enrolled in the seminar.
c. Develop a Microsoft Excel spreadsheet to solve your problem.
d. Run the Excel's Goal Seek tool to determine the breakeven point. Capture and include the part of the screen to explain your results.
e. Run the Excel's Goal Seek tool to determine the number of students need to be enrolled in order to make a profit of $9600. Capture and include the part of the screen to explain your results.
Format your assignment according to the give formatting requirements:
a. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
b. The response also includes a cover page containing the title of the assignment, the course title, the student's name, and the date. The cover page is not included in the required page length.
c. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.