Design a spreadsheet that will allow an individual employee with estimated annual medical expenses of $400 to compare the total expenses under each pla

Exercie 1:
Your client is the planning of?ce of a major university.
Part of the job of the planning of?ce is to forecast the
annual donations of alumni through the university’s long-
established giving program. Until now, the forecast has
been made subjectively. The client wants you to develop a
more objective approach. The Planning Of?ce can make
data available for the past 10 years that shows for each
alumni class in that year:
?? The number of living alumni in the class
?? The number of givers
?? Total direct donations from the class
?? Other gifts for the class (e.g., employer matching)
Exercice 2:
Congress is considering a new law that will grant
amnesty to the roughly 11 million illegal aliens in the
United States. Under this law, anyone who has entered
the country illegally in the past can apply for permanent
residence status and a green card, which conveys the right
to work. This law, if passed, can be expected to have
signi?cant impacts on industries that currently rely on
illegal workers (such as hospitality, meat packing, and
construction). It may also have impacts on wages, school
enrollments, healthcare costs, and the future rate of illegal
immigration.
Exercice 3:
Design a spreadsheet that will enable you to request the required
funds from your team’s ?nance of?cer, order supplies from
the home of?ce, and ensure dissemination of appropriate
quantities to each village. Your ?nal order to the home
of?ce should specify the number of packages required of
each item.
Exercice 4
Design a spreadsheet that will allow an individual employee with
estimated annual medical expenses of $400 to compare the
total expenses under each plan.

Don't use plagiarized sources. Get Your Custom Essay on
Design a spreadsheet that will allow an individual employee with estimated annual medical expenses of $400 to compare the total expenses under each pla
Just from $13/Page
Order Now