Micromedia offers computer training seminars

Assignment Help Business Management

Reference no: EM132623005

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.

Please upload the Excel spreadsheet too.

Tasks to be completed:

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

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

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

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.

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.

6. Upload your Excel spreadsheet

Attachment:- Sample Report.rar

Reference no: EM132623005

Questions Cloud

Functions of the fed : What Pro's and Con's do you envision coming from one Global Central Bank (list and discuss)? Given your reasoning should there be one Global Central Bank?

What would be the effect of this on financial statements : XYZ Limited did not charge depreciation for the year ending December 2019. What would be the effect of this on financial statements of the company

Determine both the relationship of risks : Question - Determine both the relationship of risks in the planning of the audit and factors that influence those risks

Should you maintain a separate ledger account for each : If you are working in a manufacturing company and you have three accounts in different banks, should you maintain a separate ledger account for each

Micromedia offers computer training seminars : Micromedia offers computer training seminars on a variety of topics. In the seminars each student works at a personal computer provided by Micromedia,

Estimate the cost of the unit : It costs a contractor $13,750 to manufacture their first unit. The company expects to experience a 93% unit learning curve. Estimate the cost of the 14th unit

Evaluate economic conditions-influence company performance : Evaluate economic conditions that influence company performance. Consider political, environmental, currency, global economics and government influence

Differences between offshoring and outsourcing : Describe the challenges and opportunities of human resources. What are the differences between offshoring and outsourcing?

Evaluate trends in stock price and dividend payout : Evaluate trends in stock price, dividend payout, and total stockholders' equity. Relate recent events or market conditions to the trends you identified.

User Account

All Pages