D2 June 2014 Q7
7. A company assembles microlight aircraft.
They can assemble up to four aircraft in any one month, but if they assemble more than three they will have to hire additional space at a cost of £1000 per month.
They can store up to two aircraft at a cost of £500 each per month.
The overhead costs are £2000 in any month in which work is done.
Aircraft are delivered at the end of each month. There are no aircraft in stock at the beginning of March and there should be none in stock at the end of July.
The order book for aircraft is
| Month | March | April | May | June | July |
|---|---|---|---|---|---|
| Number ordered | 3 | 4 | 2 | 4 | 3 |
Use dynamic programming to determine the production schedule which minimises the costs. Show your working in the table provided in the answer book and state the minimum production cost. (14)
E.g.
| Stage | State | Action | Dest | Value | Marks |
|---|---|---|---|---|---|
| July | 2 | 1 | 0 | 1000 + 2000 = 3000* | 1M1 1A1 (2) |
| (3) | 1 | 2 | 0 | 500 + 2000 = 2500* | |
| 0 | 3 | 0 | 2000 = 2000* | ||
| June | 2 | 2 | 0 | 1000 + 2000 + 2000 = 5000* | |
| (4) | 3 | 1 | 1000 + 2000 + 2500 = 5500 | 2M1 2A1ft 3A1 (3) | |
| 4 | 2 | 1000 + 2000 + 1000 + 3000 = 7000 | |||
| 1 | 3 | 0 | 500 + 2000 + 2000 = 4500* | ||
| 4 | 1 | 500 + 2000 + 1000 + 2500 = 6000 | |||
| 0 | 4 | 0 | 2000 + 1000 + 2000 = 5000* | ||
| May | 2 | 0 | 0 | 1000 + 5000 = 6000* | |
| (2) | 1 | 1 | 1000 + 2000 + 4500 = 7500 | ||
| 2 | 2 | 1000 + 2000 + 5000 = 8000 | |||
| 1 | 1 | 0 | 500 + 2000 + 5000 = 7500 | ||
| 2 | 1 | 500 + 2000 + 4500 = 7000* | 3M1 4A1ft 5A1 (3) | ||
| 3 | 2 | 500 + 2000 + 5000 = 7500 | |||
| 0 | 2 | 0 | 2000 + 5000 = 7000 | ||
| 3 | 1 | 2000 + 4500 = 6500* | |||
| 4 | 2 | 2000 + 1000 + 5000 = 8000 | |||
| April | 2 | 2 | 0 | 1000 + 2000 + 6500 = 9500* | |
| (4) | 3 | 1 | 1000 + 2000 + 7000 = 10000 | ||
| 4 | 2 | 1000 + 2000 + 1000 + 6000 = 10000 | |||
| 1 | 3 | 0 | 500 + 2000 + 6500 = 9000* | 4M1 6A1 (2) | |
| 4 | 1 | 500 + 2000 + 1000 + 7000 = 10500 | |||
| 0 | 4 | 0 | 2000 + 1000 + 6500 = 9500* | ||
| March | 0 | 3 | 0 | 2000 + 9500 = 11500* | |
| (3) | 4 | 1 | 2000 + 1000 + 9000 = 12000 | 5M1 7A1 (2) |
| Scheme | Marks | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1B1 | ||||||||||||
| Total cost: £11500 | 2B1 (2) | ||||||||||||
| 14 marks |
Notes
ALL M marks - Must bring earlier optimal results into calculations. Ignore extra rows. Must have right ‘ingredients’ (– storage costs, overheads, additional space costs) at least once per stage. Penalise lack of * only once per question.
1M1: First stage completed. 3 rows, something in each cell.
1A1: CAO condone missing * here. No extra rows.
2M1: Second stage completed with 3 states and at least 6 rows. Bod if something in each cell.
2A1ft: Any 2 states correct. Ft for their * values or the correct * values.
3A1: CAO All 3 states correct. No missing/extra rows.
3M1: 3rd stage completed with 3 states and at least 9 rows. Bod if something in each cell.
4A1ft: Any state correct. Ft on their * values or the correct * values.
5A1: CAO All 3 states correct. No missing/extra rows.
4M1: 4th stage completed with 3 states and at least 6 rows. Bod if something in each cell.
6A1: CAO All 3 states correct. No missing/extra rows.
5M1: 5th stage completed with at least 2 rows. Bod if something in each cell.
7A1: CAO Final, state correct. No missing/extra rows.
1B1: CAO Must have earned all previous M marks.
2B1: CAO Must have earned all previous M marks.
Alt correct solution – adding the storage costs at start of each month
| Stage | State | Action | Dest | Value | Marks |
|---|---|---|---|---|---|
| July | 2 | 1 | 0 | 2000 = 2000* | 1M1 |
| (3) | 1 | 2 | 0 | 2000 = 2000* | 1A1 |
| 0 | 3 | 0 | 2000 = 2000* | ||
| June | 2 | 2 | 0 | 2000 + 2000 = 4000* | 2M1 |
| (4) | 3 | 1 | 500 + 2000 + 2000 = 4500 | ||
| 4 | 2 | 1000 + 2000 + 1000 + 2000 = 6000 | |||
| 1 | 3 | 0 | 2000 + 2000 = 4000* | 2A1ft | |
| 4 | 1 | 500 + 2000 + 1000 + 2000 = 5500 | |||
| 0 | 4 | 0 | 2000 + 1000 + 2000 = 5000* | 3A1 | |
| May | 2 | 0 | 0 | 5000 = 5000* | 3M1 |
| (2) | 1 | 1 | 500 + 2000 + 4000 = 6500 | ||
| 2 | 2 | 1000 + 2000 + 4000 = 7000 | |||
| 1 | 1 | 0 | 2000 + 5000 = 7000 | ||
| 2 | 1 | 500 + 2000 + 4000 = 6500* | 4A1ft | ||
| 3 | 2 | 1000 + 2000 + 4000 = 7000 | |||
| 0 | 2 | 0 | 2000 + 5000 = 7000 | ||
| 3 | 1 | 500 + 2000 + 4000 = 6500* | 5A1 | ||
| 4 | 2 | 1000 + 2000 + 1000 + 4000 = 8000 | |||
| April | 2 | 2 | 0 | 2000 + 6500 = 8500* | 4M1 |
| (4) | 3 | 1 | 500 + 2000 + 6500 = 9000 | ||
| 4 | 2 | 1000 + 2000 + 1000 + 5000 = 9000 | |||
| 1 | 3 | 0 | 2000 + 6500 = 8500* | 6A1 | |
| 4 | 1 | 500 + 2000 + 1000 + 6500 = 10000 | |||
| 0 | 4 | 0 | 2000 + 1000 + 6500 = 9500* | ||
| March | 0 | 3 | 0 | 2000 + 9500 = 11500* | 5M1 |
| (3) | 4 | 1 | 500 + 2000 + 1000 + 8500 = 12000 | 7A1 |
| Month | March | April | May | June | July |
| Number made | 3 | 4 | 3 | 3 | 3 |
Total cost: £11500 1B1 2B1