PLEASE PROVIDE EXCEL AND A PARAGRAH THAT ANSWERS THE QUESTIONS PROVIDED:

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 seniorshome 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	$ 921,000	$ 263,000	$ 403,000	$ 255,000
Variable expenses	475,000	119,000	205,000	151,000
Contribution margin	446,000	144,000	198,000	104,000
Fixed expenses:
Depreciation	69,700	8,300	40,500	20,900
Liability insurance	43,200	20,200	7,300	15,700
Program administrators' salaries	114,400	40,500	38,800	35,100
General administrative overhead*	184,200	52,600	80,600	51,000
Total fixed expenses	411,500	121,600	167,200	122,700
Net operating income (loss)	$ 34,500	$ 22,400	$ 30,800	$ (18,700)

*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 $34,500 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.

Excel:

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

1-b. Based on the financial advantage (disadvantage) of discontinuing the Housekeeping program calculated in requirement Req 1A, should the Housekeeping program be discontinued?

2-a. make 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?

Business/Financial Analysis Presentation (Paragraph):

PLEASE ANSWER THIS PARAGRAPH WITH A LOT OF DETAIL. THIS IS THE MOST IMPORTANT PART! a. Cover your business problem b. Explain your applied Differential Key Concept with your analysis/approach. Highlight Key calculations/considerations used for the solution d. Walk through the solution e. What you learned about the problem/case, additional consideration or thoughts helpful in understanding the business issue. IN ADDITION, conclude with key takeaways/questions/considerations you have for the business problem using the following strategic planning and change management tools. SWOT Analysis o A technique for assessing the performance, competition, risk, and potential of a business, as well as part of a business such as a product line or division, an industry, or other entity. PESTLE Analysis o Bird's eye view of the whole environment from many different angles that one wants to check and keep a track of while contemplating a certain idea/plan. Change Impact Analysis o The Change Impact Matrix is a descriptive tool that details the scope of the changes that everyone involved in a project will face. The matrix is useful for presenting the project context to upper management when discussing the project status, schedule, and progress to plan.