i really need help with lap . just in excel please

Assignment # 4 1. An Excel file (the model and its solution) and Expectations. 1. Define the following terminologies: i. Robustness ii. Sensitivity 2. In a similar manner to the predictive model which presented in chapter 1 of the HTMI book, submit a technical report to describe the overall modeling solution process to solve the attached External Problem. You are investor who has two businesses, the first is purchasing scraped computers and selling their parts as spare parts. The second is dealing in new computers. The first business has a long term profit cycle; however, it has a profit margin ranges from 45% to 66% of the purchasing price. The second has a short term profit cycle and has a profit margin ranges from 25% to 40% of the purchasing price. Now, you have an extra amount of money which is enough to be invested in only one of the two businesses. By adding this amount of investment to either of the two businesses, its sales are supposed to be doubled. a) Establish a predictive model to find out, to which of the two businesses the new investment is supposed to be added. Consider the following notes and directions: Sales records during the last two years give the following monthly basis data: The monthly purchasing of scraped computers ranges between SR 51,000 and SR 100,000 Purchasing prices of new computer unit vary between SR 2,200 and SR 4,200. The number of monthly purchased computers between 18 and 40 units. . Consider a monthly period for your calculations and remember that ultimately you want to have maximum benefit from your investment Use random number generator to estimate the model parameters. b) For the established model, evaluate the Robustness and Sensitivity of the results. c) What would be the decision if the addition of the amount of investment to the first business it will increase its sales by 27%. d) Evaluate the Robustness and Sensitivity of the results for the case discussed above