Reference no: EM132624481
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.
Why you want to be hire and mention long term goals
: A great cover letter to be enthusiastic and pursuing on why you want to be hire and mention long term goals and achievement. ( as special agent).
|
Prepare Green Production contribution margin income
: repare Green Production's contribution margin income statement for 175 shows performed in 2016. Report only two categories of costs: variable and fixed
|
What are some everyday examples of ageism and adultism
: What are some everyday examples of ageism and adultism? What are the underlying values and norms that perpetuate ageism/adultism?
|
Contrast various direct or indirect strategies an import
: Contrast various direct or indirect strategies an import or export organization can implement to make the supply-chain process more efficient.
|
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
|
How compare market conditions with company performance
: Evaluate economic conditions that influence company performance. Consider political, environmental, currency (money), global economics
|
Examine the importance of financial statements
: Identify the salient information contained in the financial statements (income statement, balance sheet, statement of cash flow).
|
How do you use the four principles of social interaction
: How do you use the four principles of social interaction (reciprocity, fairness, rationality, and pleasure) in your own life
|
Briefly describe each of the crimes
: Briefly describe each of the crimes (who was involved, what the crime was, who the victim was, etc.) Explain the outcome of each case, including the punishment.
|