It explains that the machinesВ installedВ in the month of JanuaryВ contributes to new policies of Jan, Feb and March. The image shows business sourcing for 2 months. Refer to image of data from Sheet First below. ItвЂ™s important to understand every bit of information available in the given data. Machines Installed вЂ“ Number of machines installed in a particular month.Total New Policies вЂ“ New policies soldВ by machines.Machine Installed Month вЂ“ Month in which new machines were installed.Business Sourcing Month вЂ“ Month in which company got newВ business (new policies).LetвЂ™s quickly understand the information provided in the data set: Read the complete problem statement here. Now, what should be the expected business in 2016 & 2017? Assuming, annual machines installed are capped at 6500 (due to budget constraints) and average annual premium at 55,000 (due to product portfolio).How many new machines are required to achieve 170 crores of new business in 2017 ?.Forecast the month wise new business (premium in millions) in 20 ?.Soon, the board members started raising questions on his decision.Д«ased on this situation, the challenge was to answer 3 questions: Soon, their customer acquisition rate declined. Assurenaut expected their sales to shoot up with this innovative product. Robossurance is a newly created channel which consists of smart machines.В These machines are installed in different location to studyВ the consumer purchase behaviour and recommends the best insurance plan. Assurenaut, CEO of AssureNext with a decision on вЂњRobossuranceвЂќ. There can be many solutions to this problem, this article revealsВ one of them. This solution has been provided by the client. Prior knowledge of basic excel commands will be helpful. Note: This solution requires using advanced excel methods, number crunching abilitiesВ and a logical approach. This tutorial will make you proficient at using excel to find business solutions. Hence, hereвЂ™s a complete solution to the business problem shared in Mini Hack Excel. After the competition ended, the participants were keen to know what did they miss. Of course, winners were rewarded with amazon vouchers worth INR 18000 ($265). It was organized to help people learn using excel while by working on business problems. More than 1300 participants registered for this competition. We organized an exclusive competition named Mini Excel HackВ on 5th March 2016. But, the difficult part is to understand вЂњwhen to use which commandвЂќ. When I started learning excel, I realized that itвЂ™s quite easy to learn. Often it is seen thatВ the journey of a data analyst begins with MS Excel. Excel is a powerful and easy to use tool for data analysis.

Solver for excel 2017