Project Description: The purpose of this assignment is to work on the MS Excel features and functionality.

Create a Vacation Travel Expenses Report for a 7-day vacation of your choice. Your flyer MUST have the project constraints described below. 

Project Constraints:

1.  
   • Save your Excel workbook with your last name and the word TravelExp added, for example, Smith_TravelExp

•  
  • YourLastName_TravelExp 

1.  
   • The title and description of your destination are merged and centered over your expenses with a picture to the left or right of the centered title.  (see sample below “Worksheet Sample 1” ) 
2.  
   • Expense Sheet MUST include the following:

Transportation 

• to and from the destination of your choice (plane, bus, train, or car) 
• If driving you must include the amount (cost) of gas, miles of trip and the miles/gal car uses 
• Car Rental or Taxi/Uber service used during vacation (Total amounts using formulas)

Lodging

• Name of hotel
• Cost per night
• Total Amount using formulas 

Food 

• Insert two or more pictures (stock images) of meals or food that are related to the types of restaurants that you chose 
• List Restaurants you will eat at – a minimum of 3 nice restaurants at your destination with a total cost of meals using formulas 
• Amount of All other food broken down by each day for breakfast, lunch, and dinner.  You may include breakfast with as shown below in Worksheet Sample 1 if your hotel includes breakfast, you may only do this with breakfast.Lunch and Dinner MUST be listed for each day, except for day one and day seven depending on your arrival, hence you may only include lunch or dinner on those days – see sample spreadsheet below “Worksheet Sample 1”. 

Activities 

(both Free and Others with costs listed)

• You must list your activities for each day (totaled for each day with formulas)  

Souvenirs

• All calculations must be done using formulas and cell references (see the second picture “Worksheet Sample 2” below showing formulas used to calculate amounts using formulas). 

For your assignment, create an MS Excel spreadsheet that meets the following Content Requirements: 

• Include your Vacation Expenses.  
• Make sure to use the formulas, such as addition, subtraction, multiplication, average, and so on. Please provide the syntax in the field, such as “A2 + B2.”
• Create borders for vacation.
• Ensure that some of the content is centered, right-aligned, and left-aligned.
• Use different fonts and font sizes.
• Use shading to highlight any part of your vacation.

Last name is Pardo

1 page typed and double-spaced, cover page, with sources, cited both in-text and on a reference page).  Please answer the questions completely (Do not recopy questions in your work).

Answer the following questions:

One of the most difficult constitutional questions is how to distinguish between constitutional and unconstitutional classifications. The Supreme Court uses three tests for this purpose: the rational basis test, the strict scrutiny test, and the heightened scrutiny test. Explain where the constitution uses these tests and why?

 THE RATIONAL BASIS TEST  – Test to determine whether a law complies with the equal protection requirement and places the burden of proof on the parties attacking the law. The person alleging discrimination must show that the law has no rational or legitimate governmental goal.

 SUSPECT CLASSIFICATIONS AND STRICT SCRUTINY  – When a law is subject to the strict scrutiny test, the burden shifts; for the law to be constitutional, the government must show that there is both a “compelling governmental interest” to justify the classification and no less restrictive way to meet this compelling interest.

QUASI-SUSPECT CLASSIFICATIONS AND HEIGHTENED SCRUTINY  – To sustain a law under the heightened scrutiny test, the government must show that its classification serves “important governmental objectives.”

Explain how the certificated airline industry has changed since deregulation in terms of expansion, consolidation, and concentration. Describe several innovations pioneered by the major air carriers in the early 1980s that radically changed the structure of the industry.

Write a one page essay on the fundamental flight line and front desk operations of an FBO.

Please include a Title and Reference Page.

APA-7 Format is required.