SOLVE BY EXCEL PLZ

Tomas Jone is the investment manager at the High Moon Feet which is a famous company specialist in sport shoes and other sport equipment's in Western Asia. Jone needs your help to support his decision regarding the company investments. The strategic assumptions regarding the company project necessitate the development of two planning models. The first one is a tentative plan for years (2016-2020) which will be used to estimate the price and the fixed cost. The second plan (years from 2021 to 2025) will be the actual model which will help the manager to take a decision. 1- The following are some assumptions provided by the manager to help you in developing the tentative model: a. At price $30, demand was 1600 units. With each $1 increase in the price, 8 units will be decreased from the company demand. b. The following UNIT 500 800 1000 1200 2000 COST 7000 32500 36700 41000 43280 c. The unit selling price is $70 and is expected to grow at 12% per year d. Fixed cost is $2300 and is expected to be grow at 15% per year