If the fuel burn rate described in the text does not match with the figures in the table, which one do we take for calculation?

This is a case study. I hope you to help us solve these three questions.

You are asked to use Excel to solve some of them.

There are two following documents. One is case study background and questions, and another is how to add Solver to Excel, a useful function that you are asked to use.

The content is about management account and control.

Wish receive a comprehensive specific answer draft which can get a high score.

 

BTW, there are some Q&A, hope to provide some help.

Question – specific

Q: If the fuel burn rate described in the text does not match with the figures in the table, which one do we take for calculation?
A: The rate given in the table should be taken for the purpose of calculation. The burn rates described in the text are derived from ideal test conditions and may not hold true in reality.

Q: Does the objective function need to be expressed in words or as a mathematical equation?
A: Either or both is fine.

Q: Is the fuel burn shown in Table 1 for BC1900 or ATR-72?
A: BC1900

Q: Do we need to calculate optimal solutions for all kinds of aircrafts?

A: No; just for BC1900