Demand Forecast
Sheet1
| flight market | Price of snack sold on airplane | average income of passenger | price of snack (presumably carried by passenger) | amount of passengers available | quantity sold |
| 1 | 8.5 | 75586 | 8.75 | 274000 | 7952 |
| 2 | 8.5 | 67521 | 8.5 | 13450 | 8222 |
| 3 | 8.5 | 71333 | 7.64 | 54150 | 7166 |
| 4 | 8.75 | 77352 | 7.35 | 6800 | 6686 |
| 5 | 8.75 | 41450 | 7.75 | 11245 | 7715 |
| 6 | 8.75 | 57655 | 8.15 | 54500 | 6643 |
| 7 | 9 | 60265 | 8.55 | 26600 | 5155 |
| 8 | 9 | 69542 | 8 | 158000 | 7127 |
| 9 | 9 | 71596 | 7.75 | 22500 | 5834 |
| 10 | 9.25 | 72657 | 7.45 | 46150 | 5093 |
| 11 | 9.25 | 66421 | 7.89 | 8200 | 5828 |
| 12 | 9.25 | 77624 | 7.49 | 38500 | 6590 |
| 13 | 9.5 | 80110 | 8.15 | 105000 | 6228 |
| 14 | 9.5 | 87421 | 7.8 | 92000 | 7218 |
| 15 | 9.5 | 88450 | 7.9 | 38720 | 5846 |