USA: +1 (725) 712-1730 
Sign in
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.
Expert Answer
Two calculate this and show the result in “lbs” we use the following steps
(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
