You are a newly hired safety engineer for southwest Airlines. You have noticed that too many 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 the cell background color to green.
sharing excel file for the same