D2 June 2011 Q7

EdexcelOld spec13 marksDynamic Programming

7. Patrick is to take orders for his company’s products.
He will visit four countries over the next four weeks.
He will visit just one country each week.
He will leave from his office in London and will only return there after visiting the four countries.
He will travel directly from one country to the next.
He wishes to determine a schedule of four countries to visit.

Table 1 shows the countries he could visit in each week.

WeekWeek 1Week 2Week 3Week 4
Possible countriesA or BC, D or EF or GH or I

Table 1

Table 2 shows the value of the orders, in £100s, he expects to take in each country.

CountryABCDEFGHI
Value of expected orders in £100s221742413929273638

Table 2

Table 3 shows the cost, in £100s, of travelling between the various countries.

Travel costs in £100sABCDEFGHI
London5354
A542
B443
C65
D63
E44
F67
G56

Table 3

The expected income is the value of the expected orders minus the cost of travel.

It is decided to use dynamic programming to find a schedule that maximises the total expected income for these four weeks.

(a) Complete the table in the answer book to determine the optimal expected income. (11)
(b) State Patrick’s two optimal schedules. (2)