Question No: 03 This is a subjective question, hence you have to write your answer in the Text-Field given below. Garrett Mamufacturing sold 410,000 units of its product for Rs. 680 per unit in 2020. Variable cost per unit is Rs. 600 and total fixed costs are Rs. 1.64,00,000. (a) Create a spreadsheet model that computes the net income the company earned in 2020 (b) Perform an one-way sensitivity analysis (using Data Table in Excel) and build a schedule of changes in net income, for every unit of change in sales assuming the units sold to be 300000. 325000 350000, 400000, 425000, 450000, 475000 or 500000 during next year. (c) Perform a two-way sensitivity analysis (using Data Table in Excel) and build a schedule of changes in net income, for every unit of change is sales as given in question "b" above and change in variable costs to be Rs. 500, Rs. 525, Rs. 550, Rs. 575, Rs. 600, Rs. 625, Rs. 650, Rs. 675 and Rs. 700 during the next year. (d) Perform a what-if analysis to determine what should be the selling price to earn a desired profit of Rs. 30 million, assuming it sells the same quantity, no change in variable cost and no change in fixed costs [10 Marks] Question No: 03 This is a subjective question, hence you have to write your answer in the Text-Field given below. Garrett Mamufacturing sold 410,000 units of its product for Rs. 680 per unit in 2020. Variable cost per unit is Rs. 600 and total fixed costs are Rs. 1.64,00,000. (a) Create a spreadsheet model that computes the net income the company earned in 2020 (b) Perform an one-way sensitivity analysis (using Data Table in Excel) and build a schedule of changes in net income, for every unit of change in sales assuming the units sold to be 300000. 325000 350000, 400000, 425000, 450000, 475000 or 500000 during next year. (c) Perform a two-way sensitivity analysis (using Data Table in Excel) and build a schedule of changes in net income, for every unit of change is sales as given in question "b" above and change in variable costs to be Rs. 500, Rs. 525, Rs. 550, Rs. 575, Rs. 600, Rs. 625, Rs. 650, Rs. 675 and Rs. 700 during the next year. (d) Perform a what-if analysis to determine what should be the selling price to earn a desired profit of Rs. 30 million, assuming it sells the same quantity, no change in variable cost and no change in fixed costs [10 Marks]