Edexcel D2 2003 June — Question 6

Exam BoardEdexcel
ModuleD2 (Decision Mathematics 2)
Year2003
SessionJune
TopicFixed Point Iteration

6. Kris produces custom made racing cycles. She can produce up to four cycles each month, but if she wishes to produce more than three in any one month she has to hire additional help at a cost of \(\pounds 350\) for that month. In any month when cycles are produced, the overhead costs are \(\pounds 200\). A maximum of 3 cycles can be held in stock in any one month, at a cost of \(\pounds 40\) per cycle per month. Cycles must be delivered at the end of the month. The order book for cycles is
MonthAugustSeptemberOctoberNovember
Number of cycles required3352
Disregarding the cost of parts and Kris’ time,
  1. determine the total cost of storing 2 cycles and producing 4 cycles in a given month, making your calculations clear. There is no stock at the beginning of August and Kris plans to have no stock after the November delivery.
  2. Use dynamic programming to determine the production schedule which minimises the costs, showing your working in the table below.
    StageDemandStateActionDestinationValue
    \multirow[t]{3}{*}{1 (Nov)}\multirow[t]{3}{*}{2}0 (in stock)(make) 20200
    1 (in stock)(make) 10240
    2 (in stock)(make) 0080
    \multirow[t]{2}{*}{2 (Oct)}\multirow[t]{2}{*}{5}140\(590 + 200 = 790\)
    230
    The fixed cost of parts is \(\pounds 600\) per cycle and of Kris’ time is \(\pounds 500\) per month. She sells the cycles for \(\pounds 2000\) each.
  3. Determine her total profit for the four month period.
    (3)
    (Total 18 marks)