(2) They would also, like to see a graphical representation (vertical bar graph) of the simulated demand vs. the units sold AND a line graph of the weekly profit. (3] Also they are looking at purchasing a new business, see sheet labeled Marin's 12 Month Trend under lCourse Documents. The company's total costs and units of sales over the last 12 months are provided and they want you to run a regression analysis so they can better understand the costs (numbers do not correlate with the above situation...however, I want you to explore regression within Excel}. Include as a separate worksheet {tab} within your file. (4) They require a training manual (documentation) in MSWord (1-2 pages in length). The manual (instructions) you would provide your client should describe how to use the file, modify the file, and interpret the data. Also, in your rst paragraph you should tell your client what this system, which you just designed, will do for them. . .its purpose. (5} The last thing they are requesting is a NPV analysis of a new tank. . .ii a new tank will cost $20,000 and increase net cashow by $6,000 in the first year after the purchase, and $5,200 for the next 4 years [years 2-5), should they invest in the tank if their discount rate is 10%? 15%? What is the intemal rate of return? (6) In your simulation spreadsheet answer the following questions: (a) How much would you charge for this job AND why? Show your calculations within your Excel file. ([3) Should your client invest in the new tank? My? (place both of these answers under your calculation of NPV. . .#5 above)