Use the spreadsheet extract to answer the questions F C D E E 1 1 Materials budgets: 50mm 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 8 9 metres metres metres metres 10 Raw material usage 625 700 725 ? 11 12 13 Purchases budget metres metres metres metres 14 Production usage 625 700 725 ? 15 Add: closing stock 28 29 30 ? 16 Less: opening stock (25) (28) ( (29) 2 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) 2.5 26 Purchase price per metre ($) 9.40 27 28 Assumptions 29 1 The closing stock in one month is 4% of the following month's production requirement 302 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: D14; Choose.. The total column has yet to be completed. Match up the cells below with the appropriate formulae in order to complete this column. E10: Choose.. E14: Choose... 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: Choose.. B16 D14; Choose. C7 Choose. B15 =-B15 or --C14*0.04 =SUM(D14:016) =D10 or=D7*B25 =C17+B26 or=C17*$B$26 =D7-B25 =D10-D7 C10 The total column has yet to be completed. Match up the cells below with the appropriate formulae in order to complete this column. E10: Choose... Choose... E14: = 10 E10 AND E14 HAVE THE SAME DROP BOX OPTIONS =SUM(B16:016) =D15 =B15 =SUM(B10:010) =D16 =B16 =SUM(B10:E10) =SUM(B15:15)