Jse the spreadsheet extract to answer the questions D E F B Materials budgets: 50mm x 20mm pine AN 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 (28) 701 metres 725 30 (29) metres ? ? ? 2055 726 $ $ $ $ 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 28 29 30 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... e Pattempt=1028749&cmid=2871405&page=& in (metres) 2.5 B) 9.40 month is 4% of the following month's production s production of tables will plateau at 290 equire the input of an actual value ra e spreadsheet v Choose... lowing: C7 B15 B16 C10 pe completed. Match up the cells belo 25 Usage per unit of production (metres) Purchase price per metre ($) 2.5 9.40 26 27 28 29 30 Assumptions 1 The closing stock in one month is 4% of the following month's productic 2 From December onwards production of tables will plateau at 290 Required Which of the following cells require the input of an actual value relating to another cell on the spreadsheet? Choose... Suggest a formula for the following: D14Choose... =-B15 or --C14*0.04 The ESUM(D14:016) forn =D10 or=D7*B25 =C17*B26 or =C17*$B$26 E10 =D7+B25 =D10-D7 E14: Choose... e completed. Match up the cells be e this column. spreadsheet? Ch . Suggest a formula for the following: D14; Choose... The total column has yet to be completed. Match formulae in order to complete this column. E10 Choose... =E10 E14 =SUM(B16:016) =D15 =B15 =SUM(B10:010) =D16 =B16 =SUM(B10:E10) =SUM(B15:015) 30 2 From December onwards production of tables will plateau at 290 Required Which of the following cells require the input of an actual value rathe 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 w formulae in order to complete this column. E10: Choose... E14 Choose... =E10 =SUM(B16:116) =D15 =B15 =SUM(B10:010) =D16 =B16 CLINIR10:10)