Cumberland County Senior Services is a non$-$profit organization devoted to providing essential

services to seniors who live in their own homes within the Cumberland County area. Three services

are provided for seniors$$home nursing, Meals on Wheels, and housekeeping. In the home nursing

program, nurses visit seniors on a regular basis to check on their general health and to perform tests

ordered by their physicians. The Meals on Wheels program delivers a hot meal once a day to each

senior enrolled in the program. The housekeeping service provides weekly housecleaning and maintenance services. Data on revenue and expenses for the past year follow:

Total Home$-$Nursing Meals$-$on $-$wheels House keeping

Revenues $1,026,000$ $ $296,400$ $ $456,000$ $ $273,600$$

Variable expenses $569,800$$ $139,600$$ $245,000$ $ $185,200$$

Contribution margin $456,200$$ $156,800$$ $211,000$$ $88,400$$

Fixed expenses:

Depreciation $73,320$$ $9,120$$ $42,100$ $ $22,100$$

Liability insurance $47,180$$ $22,100$$ $8,400$$ $16,680$$

Program administrators$$

salaries $124,100$$ $43,500$$ $40,100$$ $40,500$$

General administrative

overhead$*205,200$$ $59,280$$ $91,200$$ $54,720$$

Total fixed expenses $449,800$$ $134,000$$ $181,800$$ $134,000$$

Operating income $($loss$)6,400$ $ $22,800$ $ $29,200$ $ $(45,600)$$

$*$Allocated on the basis of program revenues.

The head administrator of Cumberland County Senior Services, Judith Ewa, is concerned about the

organization$$s finances and considers the operating income of $$6,400$ last year to be razor$-$thin.

$($Last year$$s results were very similar to the results for previous years and are representative of what

would be expected in the future.$)$ She feels that the organization should be building its financial

reserves at a more rapid rate in order to prepare for the next inevitable recession. After seeing the

above report, Ewa asked for more information about the financial advisability of discontinuing the

housekeeping program.

The depreciation in the housekeeping category 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. Depreciation charges assume zero salvage value. 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.

Requirement $1$:

Prepare a segmented income statement that clearly shows traceable fixed expenses, segment

margins and the total revenues and expenses for the company.