IT Experts is a consulting company employing CPAs and IT professionals. They have received a consulting engagement from Lakeside Service Station to design a system (simulation) that would help them predict gasoline demand, order quantity, and profits. Lakeside is a service station that sells gasoline to boat owners and is located in a remote location on a large lake. The demand for gasoline depends on weather conditions and fluctuates according to the following distribution. Shipments arrive once a week. Since Lakeside is located in a remote place, it must order and accept a fixed quantity of gasoline every week for a period of 10 weeks. Joe, the owner, faces the following problem: If he orders too small a quantity, he will lose, in terms of lost business and goodwill, 12 cents per gallon demanded and not provided. If he orders too large a quantity, he will have to pay 10 cents per gallon shipped back due to lack of storage. For each gallon sold he makes $2.05 profit. At the present time, Joe receives 3,500 gallons at the beginning of each week before he opens for business. He feels that he should receive more, maybe 3,600 or even 3,800 gallons. The tank's current capacity is 4,000 gallons. The problem is to find the best order quantity (you must answer this question at a minimum). Assume, Joe starts the first week with 1200 gallons in his beginning inventory. Therefore, the first week, he will have 1200 gallons plus his weekly order. (1) 60 pts. Lakeside wants IT Experts to design a simulation that would help them predict demand. This simulation should be flexible enough so if conditions change (for example, probabilities or if their tank size would increase) that Lakeside's staff can modify the simulation based on new information. Include comments (written) within the cells and do not hardcode numbers within formulas. (2) 12 pts. 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. This is a data visualization of demand compared to units and the variability of weekly profit. (3) 8 pts. Also, they are looking at purchasing a new business, see sheet labeled Marin's 12 Month Trend under Projects. 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 using regression within Excel). Include as a separate worksheet (tab) within your file