Excel homework

The amount of fuel in each tank must be managed to maintain the aircraft’s center of gravity (CG) within limits. The center of gravity equation is as follows, and must be maintained between 24 and 32. The units for FB, CW, AB, and UD are in thousands of pounds.

Set up Excel to accept the variables of the equation as input in thousands of pounds. Write an equation in Excel that references the values input into the carriable cells to calculate the center of gravity. Then write a logic test to alert the pilot with the prompt “WARNING – CENTER OF GRAVITY” if the calculated center of gravity is outside of its prescribed range, or “Center of gravity within limits” if it is within range. Execute the calculation with the following amounts (in thousands of pounds): FB = 15, CW = 5, AB = 3, and UD = 0.2. Is the resultant CG within limits?