Question: Write a program that does the following: (a) It asks for the cost of the flight (cFlight); (b) it asks for the total cost of

Write a program that does the following: (a) It asks for the cost of the flight (cFlight); (b) it asks for the total cost of accommodation (cHotel); (c) it asks the duration of the work trip in number of days (nDays) (d) it calculates the reimbursement for meals by multiplying nDays with a per-diem of $75 (cMeals); (e) it calculates the total reimbursement by adding the costs of flight, hotel and meals (tripCost); (f) it displays a message such as You will be reimbursed $300 for the flight, $500 for the accommodations, and $150 at per-diem for meals. Your total reimbursement is $950.; (g) it checks whether tripCost is less than $1000. If it is less than $1000, the program should display a second message such as You will be reimbursed for your trip cost in your next paycheck. If the tripCost exceeds $1000, the program should display a message such as You need to fill out the expense report to be reimbursed.

Needs to be done in Excel.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Part 1 : Use the IQ variable, choose 10 scores, in the Howell Excel Data Set and transform the x values into z-scores using the = 90 with = 17. Then put all information in a table using the " You...

Im having problems with this problem in excel? "Write a program that does the following: ( a ) It asks for the number of miles the person traveled on a recent trip and stores it in nMiles; ( b ) it...

Problem 1 Write a program that does the following: (a) It asks for the number of miles the person traveled on a recent trip and stores it in nMiles ; (b) it asks for the average miles per gallon the...

Write a program that does the following: ( a ) It asks for the number of miles the person traveled on a recent trip and stores it in nMiles; ( b ) it asks for the average miles per gallon the person...

Please help me make an Executive Summary. Explain what you will examine in the case study. Write an overview of the field you are researching. Make a thesis statement and sum up the results of your...

in excel using developer 1. (4 points) Open a workbook, get into the VBE, insert a module, and enter the following code: Public Sub NowYouSeeMe0 Dim myName as String, nMiles as Integer yourName =...

File Edit + View Insert Cell Kernel Widgets Help Not Trusted Python 3 O Run Code Submit the assignment in the IPython document file notebook (ipynb) format. You will submit only one file called...

Milan Malpensa Airport handles passenger traffic that is taken on domestic and international flights every day. In August, an average of 80 thousand passengers per day (spread over 24 hours a day)...

NASA/SP-2011-3422 Version 1.0 November 2011 NASA Risk Management Handbook NASA/SP-2011-3422 Version 1.0 NASA Risk Management Handbook National Aeronautics and Space Administration NASA Headquarters...

Hi tutor, I have been assigned to develop a master budget for airline industry and the airline we have chosen is Qantas. In master budget,I have to make following budgets, 1)Sales Budget 2)Production...

plese answer only with proper flawchart...i dont need any codes... plese use flowchart for all questions..!! design these programs by using flawchart. 1. There are three seating categories at a...

On June 1, 2018, Crane Company and Cheyenne Company merged to form Ayayai Inc. A total of 837,000 shares were issued to complete the merger. The new corporation reports on a calendar-year basis. On...

.is the study of heredity A. Genomics B. Genetics C. Genetic Engineering D. Paleogenomics . the analysis of the information content of entire genomes. A. Genomics B. Genetics C. Genetic Engineering...

3. A noted accountant once remarked, If it becomes accepted or expected that accounting principles are determined or modified in order to secure purposes other than economic measurement, we assume a...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...