Solve problems using formulas- Excel
Mark3433
CommentsofProfessor-DalginQMMM6CaseStudySpreadsheet-Seyfullah.Dalgin65.xlsxSheet1
| No Title | ||||||||
| 4.1 Blending Aviation Gasoline | ||||||||
| Properties of feedstocks | ||||||||
| Alkylate | CCG | SRG | Isopentane | |||||
| Reid | 5 | 8 | 4 | 20 | ||||
| Octane | ||||||||
| Low TEL | 98 | 87 | 83 | 101 | ||||
| High TEL | 107 | 93 | 89 | 108 | ||||
| Value/gallon | $4.50 | $2.50 | $2.25 | $2.35 | ||||
| Gasoline | Price/gallon | |||||||
| A | $3.00 | |||||||
| B | $3.50 | |||||||
| C | $4.00 | |||||||
| Blending decisions (in gallons) | ||||||||
| Alkylate | CCG | SRG | Isopentane | Total made | Required | |||
| A | 37131 | 87887 | 4899 | 83 | 130000 | >= | 120000 | |
| B | 34312 | 0 | 73457 | 22230 | 130000 | >= | 130000 | |
| C | 68557 | 0 | 61643 | 24773 | 154973 | >= | 120000 | |
| Total used | 140000 | 87887 | 140000 | 47086 | ||||
| <= | <= | <= | <= | |||||
| Available | 140000 | 130000 | 140000 | 110000 | ||||
| Left over | 0 | 42113 | 0 | 62914 | ||||
| Reid vapor pressure constraints | Constraint on A and B | |||||||
| Actual Reid | Max Reid | Nominal Max | Gallons A | 130000 | ||||
| A | 910000 | <= | 910000 | 7 | >= | |||
| B | 910000 | <= | 910000 | 7 | Gallons B | 130000 | ||
| C | 1084808 | <= | 1084808 | 7 | ||||
| Octane constraints | ||||||||
| Actual octane | Min octane | Nominal Min | ||||||
| A | 11700000 | >= | 11700000 | 90 | ||||
| B | 12610000 | >= | 12610000 | 97 | ||||
| C | 15497264 | >= | 15497264 | 100 | ||||
| Total revenue | $1,718,022 | |||||||
The results provided was correct. However, the model is incomplete. Most importantly, there were no formulas or analysis calculations that were provided to validate the source of the numbers posted in the model. Additional, there was no color coding to identify types of variables. Therefore, it is not possible to evaluate your analysis approach (i.e., how you arrived at any mathematical conclusions). I have given you partial credit for your submission. If you want to discuss my decision, please let me know. However, due to the fact that you did not initially demonstrate a proper analysis - the grade will not increase.
