Define the goal seeking problem to be solved

Assignment Help Finance Basics

Reference no: EM132624448

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.

When done, submit the report in Microsoft Word (no other format will be accepted) format using the Sample Report file (attached below in the attachements) as a template by the due date.

Question 1. Define the goal seeking problem to be solved in your own words in detail.

Question 2. Develop a mathematical model for the total profit if x represents the number of students enrolled in the seminar.

Question 3. Develop a Microsoft Excel spreadsheet to solve your problem.

Question 4. Run the Excel's Goal Seek tool to determine the breakeven point. Capture and include the part of the screen to explain your results.

Question 5. 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.

Reference no: EM132624448

Questions Cloud

Understanding of the social construction of culture : How do understanding of the social construction of culture applicable to social work

Question - Preparing and posting journal entries : Question - Preparing and posting journal entries; preparing a trial balance. Post the journal entries from part 1 to the ledger accounts

Validity and helpfulness of gender socialization sources : Explain the validity and helpfulness of gender socialization sources.

What are the journal entries that Branch-Rickie recorded : What are the journal entries that Branch-Rickie recorded during the three-year period for these transactions

Define the goal seeking problem to be solved : Develop a mathematical model for the total profit if x represents the number of students enrolled in the seminar. Define the goal seeking problem to be solved

What tort lawsuit could be brought against him : Review the video, Teary Druggist Jailed in Death, and do some online research about the actual case. What criminal charges were or could be filed against

Explore the gender norms in society : Explore the gender norms in society and point out who you notice women and men are treated differently

How is money supply growth affected by an increase : How is money supply growth affected by an increase in the reserve requirement ratio? Assume that the reserve requirements ratio is 5%.

Prepare the income statement for Kissick Co : Prepare the income statement (ignoring income taxes) for Kissick Co.'s first year of operations and a balance sheet as of the end of the year

User Account

All Pages