# Question & Answer: You are a newly hired safety engineer for Southwest Airlines. You have noticed that too marry planes are allowed to t…..

You are a newly hired safety engineer for Southwest Airlines. You have noticed that too marry planes are allowed to take off that exceed their weight capacity, due to math errors from the controllers. As such, you are writing a spreadsheet that will help the controllers correctly add up the inputs, do a comparison and display the proper results. Here are the conditions…. Inputs: Fuel amount In lbs Number of Passengers Average Passenger Weight Average Baggage Weight per passenger Additional Cargo Weight Known: the total allowable weight for a Boeing 737 is 30,000 lbs. Calculated Values Displayed on Sheet (Make sure you include units) Total Passenger Weight Total Amount of Baggage and Cargo Total Amount of Fuel Total Weight Operation Action Displayed on the Sheet “Overweight -STOP” “Underweight- Proceed” Do some research and find the “conditional format” option In Excel. If the action is “STOP”, then change the cell background color to red. If the action is “Proceed”, change tire cell background color to green.

Two calculate this and show the result in “lbs” we use the following steps

Don't use plagiarized sources. Get Your Custom Essay on
Question & Answer: You are a newly hired safety engineer for Southwest Airlines. You have noticed that too marry planes are allowed to t…..
GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS \$13/PAGE

(1) open excel, create a worksheet and write input headings as mentioned

(2) To show the weight in lbs select home tab–> select number format –> select custom option

and write the following format 0.00 “lbs”

(3) Give the input values and calculate total Passenger weight ( =C2*B2) where c2 denotes Average passenger weight and B2 denotes Number of passengers and we calculate all amounts

(4) At last, We specify Action to be taken whether it is to be stopped or proceed on condition that the weight whould be less than or equal to 30000 lbs

For doing this We use the following formula

=IF(I2<=30000,”Proceed”,”STOP”) where I2 denotes the Total Weight

then we apply Conditional formatting

To apply conditional formatting select the home tab–> select Style group and select Conditional formating

Then select highlight cell rules –> Text that contains

in the text that contains specify the text and color rule

I am including a link to get the solved excel sheet

https://1drv.ms/x/s!AnTSkDPRZYm0gdhF89iIvmm2naetow