Please help with questions 1-4 thanks!

Yamato case for LGAV3130: Air Cargo Planning & Control (Homework) Tokyo to Hokkaido WTP #of Demand at (Yen) respondents Each Price Demand (scaled) at Each Price 2300 2176 2 5 37 35 30 24 1865 400 600 800 1,000 1.200 1,400 1,600 1,800 2,000 2,200 Due date: See the syllabus Demand (scaled) Planes for box at Each Needed Price Rounded 23000 6 21757 5 18649 5 14919 4 5595 1 3730 1 3108 1 2486 1 2486 1 0 0 6 15 3 1 1 0 9 Name: Profit from Revenue Cost (Yen) Profit (Yen) Round Trip (Yen) (Yen) 9.200.000 17.250,000 -8,050,000 -13.300.000 13,054,054 16,317.568 -3,263,514 -5,513,514 14,918,919 13,986,486 932.432 1.682,432 14.918.919 11.189.189 3,729,730 6,746,034 6,713.514) 4.195,946 2,517,568 5,599,089 5,221,622 2,797,297 2,424,324 5.179,759 4.972.973 2,331,081 2.641,892 5,413,631 4,475,676 1.864.865 2.610,811 3,295,593 4.972.973 1.864.865 3.108.108 3,515.717 0 0 0 0 6 1492 559 373 311 249 249 5 4 4 4 0 0 0 Hokkaido to Tokyo Revenue (Yen) Cost (Yen) Profit (Yen) WTP # of Demand at (Yen) respondents Each Price 400 0 46 600 0 46 800 9 46 1,000 16 37 1.200 8 21 1,400 3 13 1,600 8 10 1,800 1 2 2,000 1 1 2,200 0 0 Demand (scaled) at Each Price 1500 1500 1500 1207 685 424 326 65 Demand (scaled) for box at Each Price 15000 15000 15000 12065 6848 4239 3261 652 326 0 Planes Needed Rounded 4 4 4 3 2 1 1 6.000.000 11.250.000 -5,250,000 9,000,000 11.250,000 -2.250,000 12.000.000 11.250.000 750.000 12,065,217 9.048.913 3,016,304 8,217,391 5.135,870 3,081,522 5.934,783 3.179,348 2.755,435 5,217,391 2.445,652 2,771,739 1,173,913 489.130 684,783 652.174 244,565 407,609 0 0 0 33 0 0 Q1: Choose WTP (Yen) based on your calculation to maximize the profit of the company? Q2: How many plane(s) needed to maximize profit? Q3: Reasons of your answer on Q1 and Q2. Calculate load factor at the WTP that you choose. Load factor = demand for box at the WTP /total capacity (B777:4,000 boxes) Q4: Describe recommendations for future market development. Think about that if Yamato apply different WTP to get more business opportunity, Which WTP? Why