Music Teacher\'s Inc. is an educational association for music teachers that has
ID: 2583973 • Letter: M
Question
Music Teacher's Inc. is an educational association for music teachers that has 20,000 members. The association operates from a central HQ but has local membership chapters throughout the US. Monthly meetings are held by the local chapters to discuss recent development on topics of interest to music teachers. The association's journal, Teacher's Forum, is issued monthly with features about recent developments in the field. The association publishes books and reports and also sponsors professional courses that qualify for continuing professional education credit. The association's statement of revenues and expenses for the current year are below: Music Teachers Inc. Statement of Revenue & Expenses for the year ended Nov. 30 Revenues........................................................................$3,275,000 Expenses: Salaries..........................................................................920,000 Personal costs...............................................................230,000 Occupancy costs...........................................................280,000 Reimbursement of member cost to local chapters........600,000 Other member services.................................................500,000 Printing and paper.........................................................320,000 Postage and shipping....................................................176,000 Instuctors' fees ..............................................................80,000 General and admin........................................................38,000 Total Expenses ..............................................................3,144,000 Excess of Revenue over Expenses .............................$131,000 The board of directors of Music Teachers Inc. has requested that a segmented income statement be prepared showing the contribution of each segment to the association. The association has four segments: Membership Division, Magazine Subscription Division, Books and Reports Division, and Continuing Education Division. Mike Doyle has been assigned responsibility for preparing the segmented income statement and he has gathered the following data: a. Membership dues are $100 per year, of which $20 is considered to cover a one year subscription to the association's journal. Other benefits include membership in the association and chapter affiliation. The portion of the dues covering the magazine subscription ($20) should be assigned to the magazine subscription division. b. One year subscription to the Teacher's Forum were sold to members and libraries at $30 per subscription. A total of 2,500 of these subscriptions were sold last year. In addition to subscriptions, the magazine generated $100,000 in advertising revenue. The cost per magazine subscription were $7 for printing and paper and $4 for postage and shipping. c. A total of 28,000 technical reports and professional texts were sold by the books and reports division at an average unit selling price of $25. Average costs per publication were $4 for printing and paper and $2 for postage and shipping. d. The association offers a variety of continuing education courses to both members and non members. The one day course had a tuition cost of $75 each and were attended by 2,400 students. A total of 1,760 studentes took two day courses at a tuition cost of $125 for each student. Outside instructors were paid to teach some courses. e. Salary costs and space occupied were as follows: Salaries Space Occupied (sq. ft.) Membership................. $210,000 2,000 Magazine Subscription..150,000 2,000 Books and reports ........300,000 3,000 Continuing education.....180,000 2,000 Corporate staff ..............80,000 1,000 Total ............................$920,000 10,000 Personal costs are 25% of salaries in the seperate division as well as for the corporate staff. The $280,000 in occupancy costs includes $50,000 in rental cost for a warehouse used by the books and reports division for storage purposes. f. Printing and paper costs other than for magazine subscriptions and for books and reports relate to the continuing educaiton division g. General and admin expenses relate include costs related to overall admin of the association as a whole. The company's corporate staff does some mailing of materials for general admin purposes. The expenses that can be traced or assigned to the corporate staff, as well as any other expenses that are not traceable to the segments, will be treated as common costs, therefore not necessary to distinguish between variable and fixed costs. REQUIRED 1. Prepare a contribution format segmented income statement for Music Teachers Inc. This statement should show the segment margin for each division as well as results for the association as a whole. 2. Give arguments for and against allocating all costs of the association to the four divisions.
Explanation / Answer
Revenues:
Membership dues (20,000 × $100)........................
$2,000,000
Assigned to Magazine Subscriptions Division
(20,000 × $20).................................................
400,000
Assigned to Membership Division..........................
$1,600,000
Non-member magazine subscriptions (2,500 × $30)
$ 75,000
Reports and texts (28,000 × $25)..........................
$ 700,000
Continuing education courses:
One-day (2,400 × $75)......................................
$ 180,000
Two-day (1,760 × $125)....................................
220,000
Total revenue......................................................
$ 400,000
Salary and personnel costs:
Salaries
Personnel Costs (25% of Salaries)
Membership Division..................
$210,000
$ 52,500
Magazine Subscriptions Division..
150,000
37,500
Books and Reports Division........
300,000
75,000
Continuing Education Division.....
180,000
45,000
Total assigned to divisions..........
840,000
210,000
Corporate staff..........................
80,000
20,000
Total........................................
$920,000
$230,000
(continued)
Some may argue that, except for the $50,000 in rental cost directly attributed to the Books and Reports Division, occupancy costs are common costs that should not be allocated. The correct treatment of the occupancy costs depends on whether they could be avoided in part by eliminating a division. In the solution below, we have assumed they could be avoided.
Occupancy costs ($230,000 allocated + $50,000 direct to the Books and
Reports Division = $280,000):
Allocated to:
Membership Division
($230,000 × 0.2).......................................
$ 46,000
Magazine Subscriptions Division
($230,000 × 0.2).......................................
46,000
Books and Reports Division
($230,000 × 0.3 + $50,000)........................
119,000
Continuing Education Division
($230,000 × 0.2).......................................
46,000
Corporate staff
($230,000 × 0.1).......................................
23,000
Total occupancy costs...................................
$280,000
Printing and paper costs.................................
$320,000
Assigned to:
Magazine Subscriptions Division
(22,500 × $7).........................................
$157,500
Books and Reports Division
(28,000 × $4).........................................
112,000
269,500
Remainder—Continuing Education Division...
$ 50,500
Postage and shipping costs.............................
$176,000
Assigned to:
Magazine Subscriptions Division
(22,500 × $4).........................................
$ 90,000
Books and Reports Division
(28,000 × $2).........................................
56,000
146,000
Remainder—corporate staff.........................
$ 30,000
Case 12-34 (continued)
Division
Association Total
Membership
Magazine Subscriptions
Books & Reports
Continuing Education
Revenues:
Membership dues.......................
$2,000,000
$1,600,000
$400,000
Non-member magazine subscriptions...........................
75,000
75,000
Advertising.................................
100,000
100,000
Reports and texts........................
700,000
$700,000
Continuing education courses.......
400,000
$400,000
Total revenues............................
3,275,000
1,600,000
575,000
700,000
400,000
Expenses traceable to segments:
Salaries......................................
840,000
210,000
150,000
300,000
180,000
Personnel costs..........................
210,000
52,500
37,500
75,000
45,000
Occupancy costs.........................
257,000
46,000
46,000
119,000
46,000
Reimbursement of member costs to local chapters.............................
600,000
600,000
Other membership services..........
500,000
500,000
Printing and paper......................
320,000
157,500
112,000
50,500
Postage and shipping..................
146,000
90,000
56,000
Instructors’ fees..........................
80,000
80,000
Total traceable expenses..............
2,953,000
1,408,500
481,000
662,000
401,500
Division segment margin................
322,000
$ 191,500
$94,000
$ 38,000
$(1,500)
Division
Association Total
Membership
Magazine Subscriptions
Books & Reports
Continuing Education
Division segment margin................
322,000
$ 191,500
$94,000
$ 38,000
$(1,500)
Less common expenses not traceable to divisions:
Salaries—corporate staff..............
80,000
Personnel costs..........................
20,000
Occupancy costs.........................
23,000
Postage and shipping..................
30,000
General and administrative...........
38,000
Total common expenses.................
191,000
Excess of revenues over expenses..
$ 131,000
Revenues:
Membership dues (20,000 × $100)........................
$2,000,000
Assigned to Magazine Subscriptions Division
(20,000 × $20).................................................
400,000
Assigned to Membership Division..........................
$1,600,000
Non-member magazine subscriptions (2,500 × $30)
$ 75,000
Reports and texts (28,000 × $25)..........................
$ 700,000
Continuing education courses:
One-day (2,400 × $75)......................................
$ 180,000
Two-day (1,760 × $125)....................................
220,000
Total revenue......................................................
$ 400,000
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.