1. Gigi Kretek is one of cigarette company that have 3% market share in Indonesia. Based on Indonesian government website the population of people with age more than 15 are 206.708.299 people and the smoker took 30% of this population. Market growth factor each year will be estimated 5% and market share growth rate will be estimated 1%. Gigi Kretek receive monthly revenue for each cigarette Rp 2.500,- with monthly cost for each cigarette Rp 2.200. This cost will be increased yearly to 2% to full fill the government law. The company plan to create a new cigarette product with investing Rp 7.000.000.000,- that consist of Rp 3.500.000.000,- for R&D and product trial to the market Rp 3.500.000.000,-.
2. 1. Make a spreadsheet model to predict the yearly profit and a cumulative profit up to 5 year ahead (4 points) (LO 3)
   2. What year Gigi will be predicted to start gaining a positive profit for this new product and how much the profit on that year ? (4 points) (LO 3)
   3. Provide your answer with final Screen shoot showing the formula on how you find the answer of point b. (2 points) (LO 3)note : answer with explanation in excell