关键词 > 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