Use the spreadsheet extract to answer the questions D E F 1 Materials budgets: 60mm x 20mm pine 2 3 September October November Total 4 5 Usage budget units units units units 6 7 Production of tables 250 280 290 820 metres metres metres metres 10 Raw material usage 625 700 725 7 11 12 13 Purchases budget metres metres 14 Production usage 625 700 metres 725 metres ? 16 Add: closing stock 28 29 30 ? 76 Less: opening stock (25) (28) (29) ? 17 Purchases 628 701 726 2055 18 19 $ $ $ $ 20 21 Raw material purchases 5903 20 6589.40 6824.40 19317.00 22 23 24 Raw materials data 25 Usage per unit of production (metres) 25 26 27 28 29 Purchase price per metre (5) Assumptions 1 The closing stock in one month is 4% of the following month's production requirement 9.40 31 2 From December onwards production of tables will plateau at 290 Required Which of the following cells require the input of an actual value rather than a formula relating to another cell on the spreadsheet? Choose... Suggest a formula for the following: C21; Choose # The total column has yet to be completed. Match up the cells below with the appropriate formulae in order to complete this column. E14: Choose E16: Choose :