Janice Colangelo Breakeven workshops variable vs fixed costs

Janice Colangelo heads the Training Centre of the large HR Consulting firm EMT Consulting. The firm has three major departments: Recruitment, Training and Career Services.

The Training Centre provides management training for employees of various businesses. Recruitment provides recruitment services and Career Services assists personnel with resumes and offers advice on career planning.
The Training Centre employs 2 administrative assistants, 1 training officer and Janice, the manager on a permanent basis. Part-time trainers are hired on an as-needed basis. Part-time trainers are paid $1500 per workshop.

During 2008 the Training Centre conduction 200 workshops with 20 individuals in each. The charge per individual was $300. This is the maximum number of workshops that can be held in a year.

Income from operations $35,550
Common Allocated costs (10% of revenue) 120,000
Net Income or (loss) $(84,450)

Required:

1. a. Classify each of the costs as variable or fixed.
Can you please help me to classify VC or FC?

2. Given the allocated costs at 10% of revenue, calculate the number of workshops that must be offered to break-even.

Can you please help me to the right formula for Question 2, I do not understand how to figure it out.

Solution Summary

Your guidance is in excel, attached. It shows how each cost is classified, illustrates how to find the contribution margin per workshop and then walks you through the breakeven computation per workshop.