Please help Using simple and multivariate regression models in excel.

The data are for each franchise store. SALES = annual net sales/ $1000 SQFT = number sq. ft/1000 INVENTORY = inventory/S1000 ADVERTISING = amount spent on advertizing $1000 FAMLLES = size of sales district/1000 families STORES = number of competing stores in district Franchise. Our goal is to build a prediction model to establish which the individual factors affect sales in our franchises and how? Project Report should be 5-7 pages long and include tables and visuals to support our analysis? Regression Models: - Which individual factors affect sales in our franchises and how? - Which factors are critical to the design of the store: area (sq ft), inventory, advertising spend, size of the sales district, number of competing stores? Bivariate Relationships: - How is the size of the customer base around each store related to our expected sales? Multivariate Regression: - Which collection of factors affect sales in our franchises and how? - Can we create a model to design a store given certain demographics so we can achieve a certain level of sales? - Examine each of the variables and see if any variables need to be transformed to improve the multi-variate model. Prediction Analysis: We just opened a store in a neighborhood with 5,000 families, the store is 5,000sqft, we are planning to spend $5,000 a month in advertising, carry $250,000 in inventory and there are 5 competing stores in the neighborhood. - What are the projected sales