decision support system **Please solve (QUESTION 2) in excel sheet with detailed steps**

solve it in excel using excel functions and formulas such as linear, moving average, exponential smoothing etc...

ITIS461/ITIS361 2nd 2020-2021 Assignment.3 - Planning A company sells a product in four markets. The manager of decided to focus only on two markets instead on four markets. So, he reduced the production and decided that the Quantity Produced should be 7000 per market in the first year. The Quantity Produced is expected to grow by 6% every year. The Cost Per Unit is $180 and expected to decrease by 5% every year. The Price Per Unit is $500 and expected to decrease by 4% per year. The mangers Knows that the Quantity Sold and its Growth Rate is different in every market. So, he decided to develop a Planning Model and calculate the NPV for every market to find out which markets are going to be more profitable "best two markets": Qusetion1 "First Market": Develop an excel model that calculate the profits over 5 years for the First Market. Knowing that the Total Quantity Sold for year-1 should be forecasted and calculated from the below table (the price is given for each month, and the sale is depending on the period and price). Any $25 dollar change in price will change 150 units sold. Month n Qty Sold Price $ 275 January 1 400 $ 300 275 February March $ 270 422 April $ 265 450 May $ 294 289 June $ 279 450 July $ 204 ? 8 $ 200 ? 204 ? August September 9 $ October 10 $ 270 November 11 $ 230 ? ? December 12 $ 240 ? Qusetion2 "Second Market": Develop an excel model that calculate the profits over 5 years for the Second Market. Knowing that the Quantity Sold for year 1 expected to increase by 10% and it is shown as cubic function of the price: Price Quantity Sold 8000 7000 6000 5250 4500 $ 250 $ 350 $ 450 $ 500 $ 550 234567