Solve in excel sheet

na ogue a rer o as gas oves, nc mneys, ovens an so on. grown significantly under the CEO Vivaan Rajputs dynamic leadership. In line with his belief to enhance competitiveness by using research and development for launching innovative products in the market, Kutchina Vogue has recently developed a zero Maintenance Electric Chimney (known as Chimney) which is ideally suited for Indian cooking. The research and development cost of Chimney amounts to Rs. 20000,000. To gauge the market prospects for Chimney, a market survey was conducted by Bazar Gyani, the VP, Marketing, at an estimated cost of Rs. 500,000. The results of the survey were very positive showing a significant demand for Chimney. The survey report also indicated that Chimney could capture 8 percent of the current market size of 100,000 units of gas electric chimney. Considering the growth of satellite towns/cities and residential colonies, the market is expected to grow at 2 percent annually. The VP, Marketing suggested to the CEO that a market penetration pricing strategy would be most suitable and Chimney should be priced at Rs. 5,000 per unit in the initial year of the launch. The price could be raised in subsequent years by 5 percent annually. The marketing and administrative costs are expected to be Rs. 400,000 per year. Kutchina Vogue is presently using 6 machines acquired 3 years ago at a cost of Rs. 1,000,000 each, having a useful life of 7 years, with no salvage value These machines are currently being used for manufacturing other types of chimneys. They could be sold for Rs. 200,000 per machine Wth a removal cost of Rs. 30000 for each The machine to manufacture Chimney is available in that market for Rs. 10,000,000 with a useful life of 4 years and salvage value of Rs. It can produce other bype of chimneys also. The new machine, being state of the art technology would imprue the productivity of the workers as well reduce the unit variable cost of manufacturing to Rs. 600 which would increase by 5 percent annually. The table below summarizes the labor cost with the existing machine and the new equipment New Machine/Equipment Skilled Labor Main tenance Men Floor Managers 20 2 3 Monthly Salary Rs. 4,000 Rs. 6,000 Rs. 8,000 15 2 Monthly salary Rs. 4000 Rs. 6,000 Rs. 8,000 The maintenance costs currently amount to Rs. 100,000 per year (existing machines). They would total Rs. 70,000 With the new equipment. The net v..klng capital required to start production of Chmney would be Rs. 600,000. The policy of Kutchina Vogue is to pay five months' salary' as compensation in case of lay-off of employees. Should Kutchina Vogue launch the Chimney? Assume the followng: (i) Tax, 35 percent depreciation for tax purposes. Give the solutions in excel format. (ii) Required rate of return, 14 percent and (iii) Straight line