Each budget should have a column for the respective products and in total

Your team is requested to answer the following questions by showing all computations. (HINT: Excel spreadsheet could be used to present both the computations and solutions.) Each budget should have a column for the respective products (Console Tables and Side Boards) and in total. Prepare the following sections of a master budget for October 2017: a) Sales revenue budget (in units and in dollars) (3 Marks) b) Production budget in units (3 Marks) c) Direct materials usage budget and direct materials purchases budget (both budgets should be presented in units and in dollars) (6 Marks) d) Direct labour cost budget (4 Marks) e) Manufacturing overhead budget (show the variable and fixed cost components) (4 Marks) f) Ending inventory budgets for direct materials and finished goods (4 Marks) g) Cost of goods sold budget by showing the product line data and in total (4 Marks) 2 marks are allocated for the format of presentation (i.e., Excel presentation and use of formulas in Excel, clarity, neatness, completeness, etc.)