Question

Jackson County Senior Services is a nonprofit organization devoted to providing essential services to seniors who live in their own homes within the Jackson County area. Three services are provided for seniors—home nursing, Meals On Wheels, and housekeeping. Data on revenue and expenses for the past year follow:

		Total		Home Nursing		Meals On Wheels		House- keeping
Revenues	$	931,000	$	269,000	$	405,000	$	257,000
Variable expenses		475,000		112,000		210,000		153,000
Contribution margin		456,000		157,000		195,000		104,000
Fixed expenses:
Depreciation		69,500		8,800		40,400		20,300
Liability insurance		43,800		20,200		7,900		15,700
Program administrators’ salaries		115,800		40,700		38,600		36,500
General administrative overhead*		186,200		53,800		81,000		51,400
Total fixed expenses		415,300		123,500		167,900		123,900
Net operating income (loss)	$	40,700	$	33,500	$	27,100	$	(19,900)

*Allocated on the basis of program revenues.

The head administrator of Jackson County Senior Services, Judith Miyama, considers last year’s net operating income of $40,700 to be unsatisfactory; therefore, she is considering the possibility of discontinuing the housekeeping program.

The depreciation in housekeeping is for a small van that is used to carry the housekeepers and their equipment from job to job. If the program were discontinued, the van would be donated to a charitable organization. None of the general administrative overhead would be avoided if the housekeeping program were dropped, but the liability insurance and the salary of the program administrator would be avoided.

Required:

1-a. What is the financial advantage (disadvantage) of discontinuing the Housekeeping program?

1-b. Should the Housekeeping program be discontinued?

2-a. Prepare a properly formatted segmented income statement.

2-b. Would a segmented income statement format be more useful to management in assessing the long-run financial viability of the various services?

Answer 1

Solution 1a:

Impact on net income on dropping housekeeping program
Particulars	Current Total	Total if housekeeping dropped	Difference: Net Operating income increase (decrease)
Revenues	$931,000.00	$674,000.00	-$257,000.00
Variable expenses	$475,000.00	$322,000.00	-$153,000.00
Contribution margin	$456,000.00	$352,000.00	-$104,000.00
Fixed expenses:
Depreciation	$69,500.00	$69,500.00	$0.00
Liability insurance	$43,800.00	$28,100.00	-$15,700.00
Program administrator salaries	$115,800.00	$79,300.00	-$36,500.00
General Administrative Overhead	$186,200.00	$186,200.00	$0.00
Total fixed expenses	$415,300.00	$363,100.00	-$52,200.00
Net Operating income (loss)	$40,700.00	-$11,100.00	-$51,800.00

Solution 1b:

As there is net financial disadvantage, therefore housekeeping program should not be discontinued.

Solution 2a:

Segmanted Income Statement
Particulars	Total	Home Nursing	Meals on Wheels	Housekeeping
Revenues	$931,000.00	$269,000.00	$405,000.00	$257,000.00
Variable manufacturing and selling expenses	$475,000.00	$112,000.00	$210,000.00	$153,000.00
Contribution margin	$456,000.00	$157,000.00	$195,000.00	$104,000.00
Fixed expenses:
Depreciation	$69,500.00	$8,800.00	$40,400.00	$20,300.00
Liability insurance	$43,800.00	$20,200.00	$7,900.00	$15,700.00
Program administrator salaries	$115,800.00	$40,700.00	$38,600.00	$36,500.00
Total traceable fixed expenses	$229,100.00	$69,700.00	$86,900.00	$72,500.00
Segmant income	$226,900.00	$87,300.00	$108,100.00	$31,500.00
Common fixed expenses	$186,200.00
Net Operating income (Loss)	$40,700.00

Solution 2b:

Yes, segmented income statement format be more useful to management in assessing the long-run financial viability of the various services