MAKE A SALES FORECAST (SHOWING Q1, Q2, Q3, Q4)

A leading global manufacturer of MRI machines (used at hospitals) needed to create a quarter wise sales forecast and yearly forecast for next year (2022) for its products & services in India. The typical sales process and activities are as follows. Based on past year data, typical conversion rate at various stages of sales process are as follows Conversion Rate Sales Stage (based on historical data) Lead/Suspect 15% Prospect 30% Qualified Prospect (technically qualified) 45% Committed (commercial negotiation on) 75% Also we had a discussion with the 4 sales representatives and they have provided following information Sales Discussion points/Notes/Emails received person SP1 1. Lead stage proposal with AIIMS Bhubaneswar of deal size INR 50 Million, tentative closing by (Manages July 2022 with probability of success 60% Eastern 2. Committed proposal from KIMS of deal size INR 20 Million, tentative closing by Aug 2022 Region) with probability of success 80% 3. Prospect stage proposal with SOM of deal size INR 30 Million, tentative closing by Mar 2022 With probability of success 30% SP2 1. Qualified prospect stage proposal with Bombay Hospital of deal size INR 100 Million, tentative (Manages closing by June 2022 with probability of success 40% Western 2. Lead proposal from Breach Candy Hospital of deal size INR 50 Million, tentative closing by Nov Region) 2022 with probability of success 30% 3. Qualified prospect with Apollo of deal size INR 10 Million, tentative closing by May 2022 with probability of success of 60% SP3 1. Committed proposal with Apollo of deal size INR 25 Million, tentative closing by Feb 2022 (Manages with probability of success 90% Southern 2. Lead stage proposal from CMC Vellore of deal size INR 50 Million, tentative closing by Aug Region) 2022 with probability of success 80% 3.Prospect stage proposal with Yashoda Hospital of deal size INR 30 Million, tentative closing by Mar 2022 with probability of success 80% SP4 1. Qualified prospect stage proposal with AIIMS Delhi of deal size INR 30 Million, tentative (Manages closing by May 2022 with probability of success of 70% Northern 2. Committed proposal from Indraprastha Hospital of deal size INR 20 Million, tentative closing Region) by Aug 2022 with probability of success 90% 3. Lead stage proposal with Fortis of deal size INR 30 Million, tentative closing by Nov 2022 with probability of success 40% Create a sales forecast (showing Q1, Q2, Q3, Q4) and overall for 2022 based on the above information