please do it in 55 minutes please urgently... I'll give you up thumb definitely

estion 10 -t yet swered arked out of 10 Flag estion Use the spreadsheet extract to answer the questions B C D E 1 Materials budgets: 50mm x 20mm pine 2 3 September October Total November 4 5 units units units units 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Usage budget Production of tables Raw material usage Purchases budget Production usage Add: closing stock Less: opening stock Purchases Raw material purchases Raw materials data Usage per unit of production (metres) Purchase price per metre ($) 250 metres metres 625 625 28 (25) 628 $ 5903.20 2.5 9.40 -280 metres 700 metres 700 29 (28) 701 $ 6589.40 290 metres 725 metres 725 30 (29) 726 820 metres metres ? ? ? 2 2055 $ $ 6824.40 19317.00 F 27 28 Assumptions 29 1 The closing stock in one month is 4% of the following month's production requirement 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 rather than a formula relating to another cell on the spreadsheet? Choose... Suggest a formula for the following: C16; Choose... The total column has yet to be completed. Match up the cells below with the appropriate formulae in order to complete this column. E15: Choose... # E16: Choose... + Which of the following cells require the input on the spreadsheet? Choose... Choos... Suggest a formula fo ng: B15 C16; Choose... C10 C7 The total column has B16 ompleted. Ma complete this column. E15: Choose... F16 Required Which of the following cells require the input of an a on the spreadsheet? Choose... Suggest a formula for the following: C16 Choose... Choose... The t completed. Match up t =-B15 or =-C14*0.04 =SUM(D14:D16) D10 or =D7*B25 =C17*B26 or =C17*$B$26 comp E15: E16: =D7+B25 =D10*D7 Required Which of the following cells require the in on the spreadsheet? Choose... Suggest a formula for the following: C16; Choose... The total column has yet to be completed complete this column. E15: Choo... Choose... E16: =E10 =SUM(B16:D16) =D15 =B15 =SUM(B10:D10) =D16 =B16 =SUM(B10:E10) =SUM(B15:D15) evious page Required Which of the following cells require the in on the spreadsheet? Choose... # Suggest a formula for the following: C16; Choose... The total column has yet to be completed complete this column. E15: Choose... E16: Choose... Choose... =E10 =SUM(B16:D16) =D15 =815 =SUM(B10:D10) =D16 =B16 =SUM(B10:E10) =SUM(B15:D15) Ous page