关键词 > ENGSCI/STATS255

ENGSCI / STATS 255 MODELLING AND ANALYTICS IN OPERATIONS RESEARCH OPTIMISATION AND DATA-DRIVEN DECISION MAKING

发布时间:2022-03-31

Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

ENGSCI / STATS 255

SEMESTER ONE 2021

MODELLING AND ANALYTICS IN OPERATIONS RESEARCH OPTIMISATION AND DATA-DRIVEN DECISION MAKING

Term Test

Question 1 (16 marks)

Kwantas is an Australian airline that is restarting Trans-Tasman operations after a 12-month suspension due to recent events.   Given the expected demand, Kwantas is scheduling their Airbus A330-300 aircraft on Trans-Tasman routes; this aircraft-type has 270 economy seats.

For a particular Sydney-to-Auckland flight, Kwantas needs to decide how many economy seats to allocate to each of four fare categories.   Each fare category is associated with a ticket price. Each economy seat with a passenger costs Kwantas ·100 in operational costs, except for Premium seats which cost Kwantas ·150 per seat.


Fare Category

Ticket Price

Reward

·0

Discount

·250

Full

·400

Premium

·500

Kwantas requires there to be at least 10, and no more than 30 reward seats.  No more than 30% of total seats can be Discounted seats.  At least 20% of seats allocated with a non-zero ticket price must be Full or Premium seats. All 270 seats must be allocated into one of the fare categories.

Kwantas would like to maximise the profit from allocating seats on this Sydney to Auckland flight. You can assume that all seats allocated into each category will be sold/occupied.

(a) Define the decision variables required to formulate this problem, and give their units.

(2 marks)

once in the objective and in each constraint, and that all expressions are linear.(b) Formulate this problem as a linear program.  Ensure that each variable appears at most

(8 marks)

The following relate to independent changes to the formulation in Question 1(b).

Show the changes needed in your formulation in order to model these additional requirements. Ensure that you define any new variables that are needed, and that all resulting expressions are linear, with each variable appearing no more than once. Giving expressions such as 0.5 × 73 is acceptable in your answers.

(c) Kwantas would like to ensure that if any seats are to be allocated as Premium, then at least five seats are allocated as such.   Because Premium customers expect luxury, a fixed ·500 cost must be paid for top-quality Champagne if any Premium seats are allo- cated.                                                                                                                      (3 marks)



(d) If there are too many reward seats offered on a flight, the total cost of operating the flight increases due to increased administration costs.  Specifically, if 21 or more reward seats are allocated and sold on this flight, then an additional fixed cost of ·2000 must be paid.                                                                                                                        (3 marks)



Question 2 (14 marks)

Kwantas is famous for serving Weis fruit ice cream bars on its Trans-Tasman flights.  Given increased passenger numbers due to the Trans-Tasman bubble, Kwantas needs to reallocate its stock from non-Trans-Tasman ports to East Coast airports.

Stocks of Weis bars are to be moved from Canberra (CBR) and Perth (PER) to Sydney (SYD), Melbourne (MEL) and Brisbane (BNE). In addition, the Brisbane Duallever Factory can man- ufacture Weis ice cream bars that Kwantas can order.

An Excel formulation that reallocates stock of Weis bars to minimise cost of shipping has been solved by Kwantas, and is given below.  The units in the problem are in boxes of Weis ice cream, and dollars per box.

Use the Excel formulation and associated Solver output to answer the following questions.


A

B

C

D

E

F

G

H

1

Costs:

SYD

MEL

BNE

VALUE

2

CBR

3

4

6

3

PER

8

9

10

4

Factory

5

7

2

1700

5

6

Constraints:

SYD

MEL

BNE

VALUE

Supply

7

CBR

50

150

0

200

<=

200

8

PER

90

0

0

90

<=

300

9

Factory

10

0

90

100

<=

100

10

VALUE

150

150

90

11

=

=

=

12

Demand

150

150

90

Variable Cells