Exercise 7 – Low-cost airline

最新推荐文章于 2024-10-02 22:45:05 发布

help-assignment

最新推荐文章于 2024-10-02 22:45:05 发布

阅读量342

点赞数 5

分类专栏：作业文章标签： C++ 算法大作业课程设计

本文链接：https://blog.csdn.net/telnet3000/article/details/141557843

版权

作业专栏收录该内容

104 篇文章 5 订阅

订阅专栏

Exercise 7 – Low-cost airline

w,e,c,h,a,t : help-assignment

Shankly Air is a new low cost airline carrier. As a new low cost airline, they offer just two routes, which are Bangkok to Liverpool and Liverpool to Bangkok. The ticket price will vary depending on the period (morning, noon, evening), package (pro, eco, flex), and destination (Liverpool or Bangkok).

Bangkok-Liverpool

Shankly Pro

Shankly Eco

Shankly Flex

Morning

780

1200

2200

Noon

790

1500

2300

Evening

830

1600

2400

Liverpool-Bangkok

Shankly Pro

Shankly Eco

Shankly Flex

Morning

800

1280

2380

Noon

820

1680

2500

Evening

860

1780

2580

Shankly Air also offers 3 additional options to choose from:

Shankly Sure: Bag insurance - 200 Baht
Shankly Baggage: Additional 5 kgs - 300 Baht
Shankly Airport-to-town: Taxi from airport to town - 500 Baht

If customers have a membership card, there will receive a 25 percent discount. There will be 10 percent airport tax to calculate as well. Calculate the final ticket price for Bob Paisley:

He will travel from Liverpool to Bangkok in the morning with the Shankly Flex Package
He is a member of Shankly Air
He will get Shankly Sure and Shankly Airport-to-town as additional options

Exercise 8 – Fruit Sales

Copy the following data into Excel and use Advanced Filter to display the results for the questions listed below:

First Name

Last Name

Product

Sales

Continent

Quarter

Jurgen

Klopp

Apple

100000