this is the only information that was provided

ok just skip those questions and answer these

Use the spreadsheet extract to answer the questions D E F Materials budgets: 50mm x 20mm plne September October November Total Usage budget units units units units Production of tables 250 280 290 820 metres 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 625 Purchases budget Production usage Add: closing stock Less: opening stock Purchases 28 (25) 628 metres 700 29 (28) 701 metres 725 30 (29) 726 metres 2 ? ? 2055 $ $ $ $ Raw material purchases 5903.20 6589.40 6824.40 19317.00 Raw materiais 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 Mayo Raw material purchases 5903.20 6589 40 6824.40 19317,00 21 22 23 24 25 26 27 28 29 30 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: 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.. sment Information and Submission' Identify the most appropriate type of responsibility centre for each of the following organisations; Goerge by Asda . Research and Development Department for Astra Zeneca ge Delegation Evaluation Communication Control Authorisation Planning 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 Control Compare actual results with budgets Prepare internal budget reports that summarise and analyse performance Evaluation Analyse and Forecast Sales Back to 'Assessment Information and Submission nformation Identify the most appropriate type of responsibility centre for each of the following organisations Flag question Question 4 Goerge by Asd Not yet answered Marked out of 2.00 Cost Centre Profit Centre Investment Centre Flag question . Research and Development Department for Astra Zeneca Question 5 Not yet answered Marked out of 2.00 Flag question Goerge by Asda . Research and Development Department for Astra Zenec Cost Centre Profit Centre Investment Centre Identify the most appropriate type of responsibility centre for each of the following organisations; Goerge by Asda Research and Development Department for Astra Zeneca B 1 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 2 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 metres ? ? ? 2055 (29) 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 $ $ $ Raw material purchases 590320 6589 40 6824.40 19317.00 18 19 20 21 22 23 24 25 26 27 28 29 30 Raw materials data Usage per unit of production (metres) Purchase price per metre (8) 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 anothe 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... A Management Accounting student has been tasked to produce a production volume budget for a company. They have been provided the following information Sales for January, February and March have been forecast to be 12000, 11500 and 13500 respectively Inventories of finished goods January 9,500 The closing inventory of finished goods at the end of January, February and March must be equal to 65% of the forecast sales for the following month Sales in April is expected to be 9000 units Production in May is expected to be 4500 units Required Complete the working for the production budget below Production Volume Budget Enter your values to the nearest whole number with a -(minus) sign if it is being subtracted e.g-100 January February March April Opening Stock 9500 7475 8775 Closing Stock ProductionVolume Parts of your answer require attention : Use the spreadsheet extract to answer the questions D E F Materials budgets: 50mm x 20mm plne September October November Total Usage budget units units units units Production of tables 250 280 290 820 metres 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 625 Purchases budget Production usage Add: closing stock Less: opening stock Purchases 28 (25) 628 metres 700 29 (28) 701 metres 725 30 (29) 726 metres 2 ? ? 2055 $ $ $ $ Raw material purchases 5903.20 6589.40 6824.40 19317.00 Raw materiais 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 Mayo Raw material purchases 5903.20 6589 40 6824.40 19317,00 21 22 23 24 25 26 27 28 29 30 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: 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.. sment Information and Submission' Identify the most appropriate type of responsibility centre for each of the following organisations; Goerge by Asda . Research and Development Department for Astra Zeneca ge Delegation Evaluation Communication Control Authorisation Planning 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 Control Compare actual results with budgets Prepare internal budget reports that summarise and analyse performance Evaluation Analyse and Forecast Sales Back to 'Assessment Information and Submission nformation Identify the most appropriate type of responsibility centre for each of the following organisations Flag question Question 4 Goerge by Asd Not yet answered Marked out of 2.00 Cost Centre Profit Centre Investment Centre Flag question . Research and Development Department for Astra Zeneca Question 5 Not yet answered Marked out of 2.00 Flag question Goerge by Asda . Research and Development Department for Astra Zenec Cost Centre Profit Centre Investment Centre Identify the most appropriate type of responsibility centre for each of the following organisations; Goerge by Asda Research and Development Department for Astra Zeneca B 1 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 2 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 metres ? ? ? 2055 (29) 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 $ $ $ Raw material purchases 590320 6589 40 6824.40 19317.00 18 19 20 21 22 23 24 25 26 27 28 29 30 Raw materials data Usage per unit of production (metres) Purchase price per metre (8) 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 anothe 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... A Management Accounting student has been tasked to produce a production volume budget for a company. They have been provided the following information Sales for January, February and March have been forecast to be 12000, 11500 and 13500 respectively Inventories of finished goods January 9,500 The closing inventory of finished goods at the end of January, February and March must be equal to 65% of the forecast sales for the following month Sales in April is expected to be 9000 units Production in May is expected to be 4500 units Required Complete the working for the production budget below Production Volume Budget Enter your values to the nearest whole number with a -(minus) sign if it is being subtracted e.g-100 January February March April Opening Stock 9500 7475 8775 Closing Stock ProductionVolume Parts of your answer require attention