Use the spreadsheet extract to answer the questions D E F B Materials budgets: 50mm x 20mm pine September October November Total Usage budget units units units units Production of tables 250 280 290 820 Raw material usage metres 625 metres 700 metres 725 metres ? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Purchases budget Production usage Add: closing stock Less: opening stock Purchases metres 625 28 (25) 628 metres 700 29 metres 725 30 (29) 726 metres ? ? ? 2055 (28) 701 $ $ $ Raw material purchases 5903.20 6589.40 6824.40 19317.00 Raw materials data Usage per unit of production (metres) Purchase price per metre ($) 2.5 9.40 Assumptions 1 The closing stock in one month is 4% of the following month's production requirement 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: 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... will plateau al 29 C7 Required Which of the following cells require the input of an actual value rather than a formula relating to another cell on the spreadshee Choose... Suggest a formula for the following: B15 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... B16 C10 30 4% of the following month's production require 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 relating to another cell on the spreadsheet? Choose... Suggest a formula for the following: D14 Choose... =-B15 or -C14*0.04 The =SUM(D14:016) forr =D10 or=D7B25 =C17*B26 or =C17*$B$26 E10 =D74B25 =D10 D7 E14: Choose se completed. Match up the cells below with te this column. 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 app formulae in order to complete this column. E1C Choose... =E10 E14 SUM(B16:016) =D15 =B15 SUM(B10:010) 016 =B16 =SUM(B10:10) -SUM(B15:015) Previous page Ginishat The total column has yet to be completed. Match up the cells below wit. formulae in order to complete this column. E10: Choose... E14 Choose... =E10 =SUM(B16:016) =D15 =B15 SUM(B10:010) 016 -B16 -SUM(B10:E10) -SUM(B15:015)