all questions please

Authorisation Communication Delegation Control Planning Evaluation In your concept videos, the purpose of a budgets that were discussed included Planning, Control, Evaluation, Authorisation, Delegation and Communication. Match the statements below with the managers responsibility: Analyse costs and determine cost formulas Revise budget as needed Prepare internal budget reports that summarise and analyse performance Develop operational budgets When preparing a production budget, the quantity to be produced equals: Select one: a. sales quantity + opening inventory + closing inventory b. sales quantity - Opening inventory - closing inventory c. sales quantity + opening inventory + closing inventory d. sales quantity - Opening inventory + closing inventory e sales quantity + opening inventory-closing inventory Clear my choice 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: 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. C7 B15 B16 C10 E10: Choose... E14: Choose... 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 =SUM(D14:016) forr =D10 or =D7*B25 =C17"B26 or =C17*$B$26 E10 =D7+B25 =D100D7 Je completed. Match up the cells bel te this column. E14 Choose... formulae in order to complete E10 Choose... =E10 E14 =SUM(B16:016) =D15 Raw material purchases E 18 19 20 21 22 23 24 25 26 27 Raw materials data Usage per unit of production (metres) Purchase price per metre ($) 28 29 30 Assumptions 1 The closing stock in one month is 4% of the fo 2 From December onwards production of tables Required Which of the following cells require the input relating to another cell on the spreadsheet? C Choose... Sug =E10 or the following: =SUM(B16:016) D12 =D15 =B15 The =SUM(B10:010) 5 yet to be completed. Mato fori =D16 complete this column. =B16 E10 =SUM(B10:E10) =SUM(B15:D15) E14: Choose