Music Teachers Incorporated, is an educational association for music teachers that has 20,000 members. The association operates from a central headquarters but has local membership chapters throughout the United States. Monthly meetings are held by the local chapters to discuss recent developments on topics of interest to music teachers. The association’s magazine, Teachers 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 is presented below.
Music Teachers, Incorporated
Statement of Revenue and Expenses
For the Year Ended November 30
Revenues: 3,275,000
Expenses:
Salaries 920,000
Personnel costs 230,000
Occupancy cost 280,000
Reimbursement of member costs to local chapters 600,000
Other membership services 500,000
Printing and paper 320,000
Postage and shipping 176,000
Instructor’s fees 80,000
General and administrative 38,000
Total expenses 3,144,000
Excess of revenue over expenses. 131,000
The board of directors of music, Teachers, Incorporated, 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 Subscriptions 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. The 20,000 members of the association pay dues of $100 per year, of which $20 covers a one-year subscription to the Teachers Forum. 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 Subscriptions Division.
b. A total of 2,500 one-year subscriptions to Teachers Forum were also sold last year to nonmembers and libraries at $30 per subscription. In addition to subscriptions, the journal generated $100,000 in advertising revenues.
c. The cost to produce the Teachers Forum magazine included $7 per subscription for printing and paper and $4 per subscription for postage and shipping.
d. A total of 28,000 technical reports and professional texts were sold by the Books and Reports Division. at an average selling price per unit of $25. Average costs per publication were $4 for printing and paper and $2 for postage and shipping.
e. The association offers a variety of continuing education courses to both members and nonmembers. The one-day course had a tuition cost of $75 each and were attended by 2,400 students. Outside instructors were paid to teach some courses.
f. Salary costs and space occupied by division follow:
Space Occupied (square
Salaries feet)
Membership $210,000 2,000
Magazine Subscriptions 150,000 2,000
Books and Reports 300,000 3,000
Continuing Education 1180,000 2,000
Corporate staff 80,000 1,000
Total $920,000 10,000
Personnel costs are 25% of salaries in the separate divisions as well as the corporate staff. The $280,000 in occupancy costs (which can be allocated to segments based on their square feet occupied) includes $50,000 in rental cost for a warehouse used by the Books and Reports Division for storage purposes. Assume that the cost could be avoided if the division were eliminated.
g. Printing and paper costs other than for magazine subscriptions and for books and reports relate to the Continuing Education Division.
h. General and administrative expenses include costs relating to overall administration of the association as a whole. The company’s corporate staff does some mailing of materials for general administrative 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. It is not necessary to distinguish between variable and fixed costs.
Required:
I. Develop a segmented income statement for Music Teachers Incorporated. The statement should show the segment margin for each division as well as results for the association as a whole.
Music Teachers Incorporated operates with four segments: Membership Division, Magazine Subscriptions Division, Books and Reports Division, and Continuing Education Division. To prepare a segmented income statement for the association, we will allocate revenues and expenses to each of these segments while also considering the contribution of the corporate staff and common costs.
Membership Division:
Total Revenue for Membership Division: $2,000,000
Expenses for Membership Division
Salaries: $210,000
Personnel costs: $52,500 (25% of salaries)
Occupancy cost (allocated by square feet): ($280,000 / 10,000 sq. ft.) * 2,000 sq. ft. = $56,000
Common Costs: General and administrative expenses: $38,000
Total Expenses for Membership Division: $356,500
Segment Margin for Membership Division: $2,000,000 – $356,500 = $1,643,500
Magazine Subscriptions Division:
Magazine subscription revenues (from members): $400,000
Magazine subscription revenues (from non-members): 2,500 subscriptions * $30/subscription = $75,000
Total Revenue for Magazine Subscriptions Division: $575,000
Expenses for Magazine Subscriptions Division:
Salaries: $150,000
Personnel costs: $37,500 (25% of salaries)
Occupancy cost (allocated by square feet): ($280,000 / 10,000 sq. ft.) * 2,000 sq. ft. = $56,000
Printing and paper costs: $7/subscription * 2,500 subscriptions = $17,500
Postage and shipping costs: $4/subscription * 2,500 subscriptions = $10,000
Common Costs: General and administrative expenses: $38,000
Total Expenses for Magazine Subscriptions Division: $309,000
Segment Margin for Magazine Subscriptions Division: $575,000 – $309,000 = $266,000
Books and Reports Division:
Sales of books and reports: 28,000 units * $25/unit = $700,000
Total Revenue for Books and Reports Division: $700,000
Expenses for Books and Reports Division:
Salaries: $300,000
Personnel costs: $75,000 (25% of salaries)
Occupancy cost (allocated by square feet): ($280,000 / 10,000 sq. ft.) * 3,000 sq. ft. = $84,000
Rental cost for warehouse (avoidable if division eliminated): $50,000
Printing and paper costs: $4/unit * 28,000 units = $112,000
Postage and shipping costs: $2/unit * 28,000 units = $56,000
Common Costs: General and administrative expenses: $38,000
Total Expenses for Books and Reports Division: $715,000
Segment Margin for Books and Reports Division: $700,000 – $715,000 = -$15,000
Continuing Education Division:
Tuition fees from courses: 2,400 students * $75/student = $180,000
Instructor’s fees: $80,000
Total Revenue for Continuing Education Division: $260,000
Expenses for Continuing Education Division:
Salaries: $180,000
Personnel costs: $45,000 (25% of salaries)
Occupancy cost (allocated by square feet): ($280,000 / 10,000 sq. ft.) * 2,000 sq. ft. = $56,000
Printing and paper costs: (Printing and paper costs other than magazine subscriptions and books and reports) $320,000
Common Costs: General and administrative expenses: $38,000
Total Expenses for Continuing Education Division: $699,000
Segment Margin for Continuing Education Division: $260,000 – $699,000 = -$439,000
Now, let’s calculate the association’s overall results:
Total Revenue for the Association: $2,000,000 (Membership) + $575,000 (Magazine Subscriptions) + $700,000 (Books and Reports) + $260,000 (Continuing Education) = $3,535,000
Total Expenses for the Association: $356,500 (Membership) + $309,000 (Magazine Subscriptions) + $715,000 (Books and Reports) + $699,000 (Continuing Education) + $38,000 (Common Costs) = $3,117,500
Excess of revenue over expenses for the Association: $3,535,000 – $3,117,500 = $417,500
In summary, the segmented income statement shows the contribution of each division to Music Teachers Incorporated, with Membership and Magazine Subscriptions generating positive segment margins, Books and Reports operating at a loss, and Continuing Education also running at a loss. The association as a whole has an excess of revenue over expenses of $417,500.
As a renowned provider of the best writing services, we have selected unique features which we offer to our customers as their guarantees that will make your user experience stress-free.
Unlike other companies, our money-back guarantee ensures the safety of our customers' money. For whatever reason, the customer may request a refund; our support team assesses the ground on which the refund is requested and processes it instantly. However, our customers are lucky as they have the least chances to experience this as we are always prepared to serve you with the best.
Plagiarism is the worst academic offense that is highly punishable by all educational institutions. It's for this reason that Peachy Tutors does not condone any plagiarism. We use advanced plagiarism detection software that ensures there are no chances of similarity on your papers.
Sometimes your professor may be a little bit stubborn and needs some changes made on your paper, or you might need some customization done. All at your service, we will work on your revision till you are satisfied with the quality of work. All for Free!
We take our client's confidentiality as our highest priority; thus, we never share our client's information with third parties. Our company uses the standard encryption technology to store data and only uses trusted payment gateways.
Anytime you order your paper with us, be assured of the paper quality. Our tutors are highly skilled in researching and writing quality content that is relevant to the paper instructions and presented professionally. This makes us the best in the industry as our tutors can handle any type of paper despite its complexity.
Recent Comments