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 HomeNursing MealsOnWheels Housekeeping

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.