Edexcel D2 2004 June — Question 6

Exam BoardEdexcel
ModuleD2 (Decision Mathematics 2)
Year2004
SessionJune
TopicCurve Sketching
TypeOptimization and assignment problems

6. Joan sells ice cream. She needs to decide which three shows to visit over a three-week period in the summer. She starts the three-week period at home and finishes at home. She will spend one week at each of the three shows she chooses travelling directly from one show to the next. Table 1 gives the week in which each show is held. Table 2 gives the expected profits from visiting each show. Table 3 gives the cost of travel between shows. \begin{table}[h]
\captionsetup{labelformat=empty} \caption{Table 1}
Week123
ShowsA, B, CD, EF, G, H
\end{table} Table 2 \begin{table}[h]
\captionsetup{labelformat=empty} \caption{Table 1}
ShowA\(B\)\(C\)\(D\)\(E\)\(F\)\(G\)\(H\)
Expected Profit \(( \pounds )\)900800100015001300500700600
\end{table} \begin{table}[h]
\captionsetup{labelformat=empty} \caption{Table 3}
Travel costs (£)ABCDEFGH
Home7080150809070
A180150
B140120
C200210
D200160120
E170100110
\end{table} It is decided to use dynamic programming to find a schedule that maximises the total expected profit, taking into account the travel costs.
  1. Define suitable stage, state and action variables.
  2. Determine the schedule that maximises the total profit. Show your working in a table.
  3. Advise Joan on the shows that she should visit and state her total expected profit.
    (3) (Total 18 marks)